سیستم عامل شما معتبر نیستselect if(la.lastkill,ch.totalKills-la.lastkill,ch.totalKills) as time,ch.name from charlegendary.characters as ch left join v3_full.imlastweek as la on ch.guid=la.guid where ch.account>0 and ch.guid not IN('19','244','70','24','1048','5107') and la.week='14' group by ch.guid order by time desc limit 10