{"recordsFiltered":9,"sql":"SELECT `MA`.`id_match`, `MA`.`ma_tstamp`, `lg_name`, IF(ma_type='Bracket', `ma_tourn_round_str`, IF(ma_type='League', CONCAT(div_name, ' Week ', ma_week), ma_title)) as custom_info, `MA`.`ma_type`, `LG`.`lg_logo`, `LG`.`lg_slug`, `MP`.`mp_side`, IF(MP.mp_side='Home', `TH`.`tm_name`, TV.tm_name) as tm_name, IF(MP.mp_side='Home', `TH`.`tm_logo`, TV.tm_logo) as tm_logo, IF(MP.mp_side='Home', `TV`.`tm_name`, TH.tm_name) as tm_name_opponent, IF(MP.mp_side='Home', `TV`.`tm_logo`, TH.tm_logo) as tm_logo_opponent, `MA`.`ma_result`, 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, `mp_play_minutes` FROM `match_player` `MP` LEFT JOIN `matches` `MA` ON `MA`.`id_match`=`MP`.`id_match` 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_match_player` FROM `goals` `GO` GROUP BY `id_match_player`) GOX ON `GOX`.`id_match_player` = `MP`.`id_match_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_match_player` FROM `fouls` `FO` GROUP BY `id_match_player`) FOX ON `FOX`.`id_match_player` = `MP`.`id_match_player` LEFT JOIN `leagues` `LG` ON `LG`.`id_league` = `MA`.`id_league` LEFT JOIN `divisions` `DV` ON `DV`.`id_division` = `MA`.`id_division` LEFT JOIN `teams` `TH` ON `TH`.`id_team` = `MA`.`id_team_home` LEFT JOIN `teams` `TV` ON `TV`.`id_team` = `MA`.`id_team_visitor` WHERE MP.id_player IN(19780)","data":[{"id_match":"6852","ma_tstamp":"31 Jan 2021, 12:10","lg_name":"Junior Futsal LeagueU13","custom_info":"JFL U13 Week 1","ma_type":"League","lg_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fassets%2Fimg%2Fteam_logo_placeholder.png&hash=275faa3017b637ae977dc2a31fb0089d39d48f2b70099cc1346e8f58d137c8b1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"junior-futsal-leagueu13","mp_side":"Home","tm_name":"Opus Futsal Academy","tm_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1610639984.jpg&hash=38e180f9ca0a9a5c02b7ca4e724fc32577a0be1c6629e80aeab5212ee81e1cc1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"Kalong Fa","tm_logo_opponent":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1609409373.jpg&hash=cd6f9da78f9deacb106135c11bb966f1374b003a3ed94b3f0119b1fb91c132c1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","ma_result":"Away Menang","total_goal":"0","total_own_goal":"0","total_red":"0","total_yellow":"0","total_green":"0","mp_play_minutes":"0"},{"id_match":"6868","ma_tstamp":"07 Feb 2021, 12:50","lg_name":"Junior Futsal LeagueU13","custom_info":"JFL U13 Week 2","ma_type":"League","lg_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fassets%2Fimg%2Fteam_logo_placeholder.png&hash=275faa3017b637ae977dc2a31fb0089d39d48f2b70099cc1346e8f58d137c8b1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"junior-futsal-leagueu13","mp_side":"Home","tm_name":"Opus Futsal Academy","tm_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1610639984.jpg&hash=38e180f9ca0a9a5c02b7ca4e724fc32577a0be1c6629e80aeab5212ee81e1cc1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"Virago Junior","tm_logo_opponent":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1609843429.jpg&hash=6b043dc759dac1e89d4afa9cc4b7e9f7176b9495bba6d748a057280ff0c86dc8\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","ma_result":"Home Menang","total_goal":"1","total_own_goal":"0","total_red":"0","total_yellow":"0","total_green":"0","mp_play_minutes":"0"},{"id_match":"6901","ma_tstamp":"14 Feb 2021, 10:40","lg_name":"Junior Futsal LeagueU13","custom_info":"JFL U13 Week 3","ma_type":"League","lg_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fassets%2Fimg%2Fteam_logo_placeholder.png&hash=275faa3017b637ae977dc2a31fb0089d39d48f2b70099cc1346e8f58d137c8b1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"junior-futsal-leagueu13","mp_side":"Visitor","tm_name":"Opus Futsal Academy","tm_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1610639984.jpg&hash=38e180f9ca0a9a5c02b7ca4e724fc32577a0be1c6629e80aeab5212ee81e1cc1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"AKAR FUTSAL ACADEMY","tm_logo_opponent":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1552572258.jpg&hash=460065020089382382d1ae1a17be6234dd343d9a83d9090a3ddc5cf336e6fc19\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","ma_result":"Home Menang","total_goal":"1","total_own_goal":"0","total_red":"0","total_yellow":"0","total_green":"0","mp_play_minutes":"0"},{"id_match":"6938","ma_tstamp":"21 Feb 2021, 10:00","lg_name":"Junior Futsal LeagueU13","custom_info":"JFL U13 Week 4","ma_type":"League","lg_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fassets%2Fimg%2Fteam_logo_placeholder.png&hash=275faa3017b637ae977dc2a31fb0089d39d48f2b70099cc1346e8f58d137c8b1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"junior-futsal-leagueu13","mp_side":"Visitor","tm_name":"Opus Futsal Academy","tm_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1610639984.jpg&hash=38e180f9ca0a9a5c02b7ca4e724fc32577a0be1c6629e80aeab5212ee81e1cc1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"ZEO Futsal Academy","tm_logo_opponent":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1611473126.jpg&hash=0852e8802e3c2c72e8e3401f87ba5ed301bdf0b6013014b2335b62412f86172e\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","ma_result":"Away Menang","total_goal":"1","total_own_goal":"0","total_red":"0","total_yellow":"0","total_green":"0","mp_play_minutes":"0"},{"id_match":"6974","ma_tstamp":"28 Feb 2021, 12:40","lg_name":"Junior Futsal LeagueU13","custom_info":"JFL U13 Week 5","ma_type":"League","lg_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fassets%2Fimg%2Fteam_logo_placeholder.png&hash=275faa3017b637ae977dc2a31fb0089d39d48f2b70099cc1346e8f58d137c8b1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"junior-futsal-leagueu13","mp_side":"Visitor","tm_name":"Opus Futsal Academy","tm_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1610639984.jpg&hash=38e180f9ca0a9a5c02b7ca4e724fc32577a0be1c6629e80aeab5212ee81e1cc1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"Tumaritis Fa","tm_logo_opponent":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1630250846.jpg&hash=c99aa50f90165be9c8ef32b72ed5fb1078f83c3f3493bf2372a56ea2d4f8fdbb\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","ma_result":"Away Menang","total_goal":"0","total_own_goal":"0","total_red":"0","total_yellow":"0","total_green":"0","mp_play_minutes":"0"},{"id_match":"7098","ma_tstamp":"14 Mar 2021, 11:20","lg_name":"Junior Futsal LeagueU13","custom_info":"JFL U13 Week 6","ma_type":"League","lg_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fassets%2Fimg%2Fteam_logo_placeholder.png&hash=275faa3017b637ae977dc2a31fb0089d39d48f2b70099cc1346e8f58d137c8b1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"junior-futsal-leagueu13","mp_side":"Home","tm_name":"Opus Futsal Academy","tm_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1610639984.jpg&hash=38e180f9ca0a9a5c02b7ca4e724fc32577a0be1c6629e80aeab5212ee81e1cc1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"Evolutions FA","tm_logo_opponent":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1655281853.jpg&hash=339a3af15eef5cd432421284ba4503f170a64ae214f29c8c0dbb8a011658d428\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","ma_result":"Away Menang","total_goal":"0","total_own_goal":"0","total_red":"0","total_yellow":"0","total_green":"0","mp_play_minutes":"0"},{"id_match":"7164","ma_tstamp":"21 Mar 2021, 10:40","lg_name":"Junior Futsal LeagueU13","custom_info":"JFL U13 Week 7","ma_type":"League","lg_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fassets%2Fimg%2Fteam_logo_placeholder.png&hash=275faa3017b637ae977dc2a31fb0089d39d48f2b70099cc1346e8f58d137c8b1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"junior-futsal-leagueu13","mp_side":"Home","tm_name":"Opus Futsal Academy","tm_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1610639984.jpg&hash=38e180f9ca0a9a5c02b7ca4e724fc32577a0be1c6629e80aeab5212ee81e1cc1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"ACS","tm_logo_opponent":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1604556837.jpg&hash=55ee82e54db73293d723115c4f3d7b555084e00718d2c0558c1c17a018be4013\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","ma_result":"Home Menang","total_goal":"0","total_own_goal":"0","total_red":"0","total_yellow":"0","total_green":"0","mp_play_minutes":"0"},{"id_match":"7221","ma_tstamp":"28 Mar 2021, 12:10","lg_name":"Junior Futsal LeagueU13","custom_info":"JFL U13 Week 8","ma_type":"League","lg_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fassets%2Fimg%2Fteam_logo_placeholder.png&hash=275faa3017b637ae977dc2a31fb0089d39d48f2b70099cc1346e8f58d137c8b1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"junior-futsal-leagueu13","mp_side":"Home","tm_name":"Opus Futsal Academy","tm_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1610639984.jpg&hash=38e180f9ca0a9a5c02b7ca4e724fc32577a0be1c6629e80aeab5212ee81e1cc1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"JUNIOR FC LENTENG AGUNG","tm_logo_opponent":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1630047353.png&hash=11821feb203b96a113d43cce437a3b751df83d85626fb0d918ae235d83b7d540\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","ma_result":"Away Menang","total_goal":"1","total_own_goal":"0","total_red":"0","total_yellow":"0","total_green":"0","mp_play_minutes":"0"},{"id_match":"7274","ma_tstamp":"04 Apr 2021, 10:40","lg_name":"Junior Futsal LeagueU13","custom_info":"JFL U13 Week 9","ma_type":"League","lg_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fassets%2Fimg%2Fteam_logo_placeholder.png&hash=275faa3017b637ae977dc2a31fb0089d39d48f2b70099cc1346e8f58d137c8b1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"junior-futsal-leagueu13","mp_side":"Home","tm_name":"Opus Futsal Academy","tm_logo":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1610639984.jpg&hash=38e180f9ca0a9a5c02b7ca4e724fc32577a0be1c6629e80aeab5212ee81e1cc1\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"Venom Fa","tm_logo_opponent":"<img src=\"..\/..\/phpthumb\/phpThumb.php?aoe=1&far=1&w=20&h=20&q=80&bg=EEEEEE&f=png&src=..%2Fupload%2Flogo%2Fteams_tmlogo_tsx1609722066.png&hash=5ee525c0863fbc2fa5b2f7965b2accebbb02e878959597744b73841f2d4d0d31\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","ma_result":"Home Menang","total_goal":"1","total_own_goal":"0","total_red":"0","total_yellow":"0","total_green":"0","mp_play_minutes":"0"}],"elapsed":"0.0008 s"}