SELECT
SUM(@Atak := silah_log.adet*silah_liste.silahatak) AS ToplamAtak
FROM silah_log 
LEFT JOIN silah_liste ON
silah_liste.silahid = silah_log.silahid