Esatto, nelle mille prove tra tutte le combinazioni possibili ho fatto anche:
$query = "(SELECT SUM(me.count) as cnt,CONCAT(pl.first_name,' ',pl.last_name) as name, t.t_name,t.id as tid ,ev.e_img,ev.e_name,pl.id,pl.def_img FROM #__bl_match_events as me, #__bl_match as m, #__bl_matchday as md...