{"recordsFiltered":0,"sql":"SELECT CONCAT(lg_date_start, '|', lg_date_end) as lg_date, `lg_date_start`, `lg_date_end`, `lg_name`, IFNULL(div_name, '') as dv_name, IF(LG.lg_type='League', `div_name`, IF(LG.lg_type='Tournament', `br_title`, '')) as pt_info, `LG`.`lg_logo`, `LG`.`lg_slug`, `tm_name`, `tm_logo`, IFNULL(total_goal, 0) as total_goal, IFNULL(total_own_goal, 0) as total_own_goal, IFNULL(total_red, 0) as total_red, IFNULL(total_yellow, 0) as total_yellow, IFNULL(total_green, 0) as total_green, IFNULL(playing_time, 0) as playing_time FROM (((SELECT `MP`.`id_ptcpate_player`, IF(mp_side='Home', `id_ptcpate_home`, id_ptcpate_visitor) as id_ptcpate, `LG`.`id_sport` FROM `match_player` `MP` LEFT JOIN `matches` `MA` ON `MA`.`id_match` = `MP`.`id_match` LEFT JOIN `leagues` `LG` ON `LG`.`id_league`=`MA`.`id_league` WHERE `MP`.`id_player` = '7928' AND `MA`.`ma_type` != 'Friendly' GROUP BY `MP`.`id_ptcpate_player`, `id_ptcpate`, `LG`.`id_sport`) UNION (SELECT `PTP`.`id_ptcpate_player`, `PTP`.`id_ptcpate`, `LG`.`id_sport` FROM `ptcpate_player` `PTP` LEFT JOIN `ptcpates` `PT` ON `PT`.`id_ptcpate` = `PTP`.`id_ptcpate` LEFT JOIN `leagues` `LG` ON `LG`.`id_league`=`PT`.`id_league` WHERE `PTP`.`id_player` = '7928')) as TMP) LEFT JOIN (SELECT SUM(IF(go_is_own_goal='Yes', 1, 0)) AS `total_own_goal`, SUM(IF(go_is_own_goal='No', 1, 0)) AS `total_goal`, `id_ptcpate_player` FROM `goals` `GO` GROUP BY `id_ptcpate_player`) GOX ON `GOX`.`id_ptcpate_player` = `TMP`.`id_ptcpate_player` LEFT JOIN (SELECT SUM(IF(fo_type='Green Card', 1, 0)) AS `total_green`, SUM(IF(fo_type='Yellow Card', 1, 0)) AS `total_yellow`, SUM(IF(fo_type='Red Card', 1, 0)) AS `total_red`, `id_ptcpate_player` FROM `fouls` `FO` GROUP BY `id_ptcpate_player`) FOX ON `FOX`.`id_ptcpate_player` = `TMP`.`id_ptcpate_player` LEFT JOIN (SELECT `id_ptcpate_player`, SUM(`mp_play_minutes`) AS `playing_time` FROM `match_player` `MP` GROUP BY `id_ptcpate_player`) MPX ON `MPX`.`id_ptcpate_player` = `TMP`.`id_ptcpate_player` LEFT JOIN `ptcpates` `PT` ON `PT`.`id_ptcpate`=`TMP`.`id_ptcpate` LEFT JOIN `leagues` `LG` ON `LG`.`id_league` = `PT`.`id_league` LEFT JOIN `teams` `TM` ON `TM`.`id_team` = `PT`.`id_team` LEFT JOIN `divisions` `DV` ON `DV`.`id_division`=`PT`.`ptcpate_id` AND `PT`.`ptcpate_type`='divisions' LEFT JOIN `brptcpates` `BRP` ON `BRP`.`id_ptcpate`=`PT`.`id_ptcpate` LEFT JOIN `brackets` `BR` ON `BR`.`id_bracket`=`BRP`.`id_bracket` WHERE `TMP`.`id_sport` = ''","data":[],"elapsed":"0.0007 s"}