{"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(8377)","data":[{"id_match":"3005","ma_tstamp":"13 Jan 2019, 09:00","lg_name":"LIGA AAFI REGIONAL DEPOK MUSIM 2018-2019","custom_info":"KATEGORI U-8 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=..%2Fupload%2Flogo%2Fleagues_lglogo_tsx1548037467.png&hash=7ef671ce617b259c6d553c5ccbd9085c118e95ed253abfa4e951be29e78b7231\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"liga-aafi-regional-depok-musim-2018-2019","mp_side":"Visitor","tm_name":"MUTIARA DARUSSALAM FA","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_tsx1536166619.png&hash=22058877d78ab43a5e45f476f2102cec533ba19b87cf829e246a862eae7d3d86\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"An Nahl 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_tsx1545291502.png&hash=02c28edd15c354743b82e95453991681e048e8a68422c96bfced1ffb5d18c3f3\" 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":"3008","ma_tstamp":"13 Jan 2019, 10:30","lg_name":"LIGA AAFI REGIONAL DEPOK MUSIM 2018-2019","custom_info":"KATEGORI U-8 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=..%2Fupload%2Flogo%2Fleagues_lglogo_tsx1548037467.png&hash=7ef671ce617b259c6d553c5ccbd9085c118e95ed253abfa4e951be29e78b7231\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"liga-aafi-regional-depok-musim-2018-2019","mp_side":"Home","tm_name":"MUTIARA DARUSSALAM FA","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_tsx1536166619.png&hash=22058877d78ab43a5e45f476f2102cec533ba19b87cf829e246a862eae7d3d86\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"United Kebz Futsal Academy (UKFA)","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_tsx1534434338.png&hash=6f12552428cef76328f328e04b3273580cddc0aade35781546f820393b5af529\" 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":"3188","ma_tstamp":"27 Jan 2019, 09:30","lg_name":"LIGA AAFI REGIONAL DEPOK MUSIM 2018-2019","custom_info":"KATEGORI U-8 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=..%2Fupload%2Flogo%2Fleagues_lglogo_tsx1548037467.png&hash=7ef671ce617b259c6d553c5ccbd9085c118e95ed253abfa4e951be29e78b7231\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"liga-aafi-regional-depok-musim-2018-2019","mp_side":"Visitor","tm_name":"MUTIARA DARUSSALAM FA","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_tsx1536166619.png&hash=22058877d78ab43a5e45f476f2102cec533ba19b87cf829e246a862eae7d3d86\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"NUFI FAZZ Futsal Club","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_tsx1511778792.jpg&hash=1bde8921475df8ee8490a3fd8364f502487126a192924fe0f0a201c7f5230c82\" 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":"3326","ma_tstamp":"03 Feb 2019, 09:00","lg_name":"LIGA AAFI REGIONAL DEPOK MUSIM 2018-2019","custom_info":"KATEGORI U-8 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=..%2Fupload%2Flogo%2Fleagues_lglogo_tsx1548037467.png&hash=7ef671ce617b259c6d553c5ccbd9085c118e95ed253abfa4e951be29e78b7231\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"liga-aafi-regional-depok-musim-2018-2019","mp_side":"Home","tm_name":"MUTIARA DARUSSALAM FA","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_tsx1536166619.png&hash=22058877d78ab43a5e45f476f2102cec533ba19b87cf829e246a862eae7d3d86\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"ALKI FUTSAL","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_tsx1516680685.jpg&hash=9b69de7d08d39753072f2197f92d1b94b2496e94e04835348ce2d2b811010366\" 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":"3331","ma_tstamp":"03 Feb 2019, 11:30","lg_name":"LIGA AAFI REGIONAL DEPOK MUSIM 2018-2019","custom_info":"KATEGORI U-8 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=..%2Fupload%2Flogo%2Fleagues_lglogo_tsx1548037467.png&hash=7ef671ce617b259c6d553c5ccbd9085c118e95ed253abfa4e951be29e78b7231\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"liga-aafi-regional-depok-musim-2018-2019","mp_side":"Home","tm_name":"MUTIARA DARUSSALAM FA","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_tsx1536166619.png&hash=22058877d78ab43a5e45f476f2102cec533ba19b87cf829e246a862eae7d3d86\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"Spartans Futsal School","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_tsx1684584370.jpg&hash=4156438a3bda67e1aff66b857e40fe78749658ca4e45bc28cd108a1375e72764\" 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":"3524","ma_tstamp":"17 Feb 2019, 08:00","lg_name":"LIGA AAFI REGIONAL DEPOK MUSIM 2018-2019","custom_info":"KATEGORI U-8 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=..%2Fupload%2Flogo%2Fleagues_lglogo_tsx1548037467.png&hash=7ef671ce617b259c6d553c5ccbd9085c118e95ed253abfa4e951be29e78b7231\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"liga-aafi-regional-depok-musim-2018-2019","mp_side":"Home","tm_name":"MUTIARA DARUSSALAM FA","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_tsx1536166619.png&hash=22058877d78ab43a5e45f476f2102cec533ba19b87cf829e246a862eae7d3d86\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"An Nahl 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_tsx1545291502.png&hash=02c28edd15c354743b82e95453991681e048e8a68422c96bfced1ffb5d18c3f3\" 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":"3527","ma_tstamp":"17 Feb 2019, 09:30","lg_name":"LIGA AAFI REGIONAL DEPOK MUSIM 2018-2019","custom_info":"KATEGORI U-8 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=..%2Fupload%2Flogo%2Fleagues_lglogo_tsx1548037467.png&hash=7ef671ce617b259c6d553c5ccbd9085c118e95ed253abfa4e951be29e78b7231\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"liga-aafi-regional-depok-musim-2018-2019","mp_side":"Visitor","tm_name":"MUTIARA DARUSSALAM FA","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_tsx1536166619.png&hash=22058877d78ab43a5e45f476f2102cec533ba19b87cf829e246a862eae7d3d86\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"United Kebz Futsal Academy (UKFA)","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_tsx1534434338.png&hash=6f12552428cef76328f328e04b3273580cddc0aade35781546f820393b5af529\" 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":"3972","ma_tstamp":"24 Mar 2019, 09:00","lg_name":"LIGA AAFI REGIONAL DEPOK MUSIM 2018-2019","custom_info":"KATEGORI U-8 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=..%2Fupload%2Flogo%2Fleagues_lglogo_tsx1548037467.png&hash=7ef671ce617b259c6d553c5ccbd9085c118e95ed253abfa4e951be29e78b7231\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"liga-aafi-regional-depok-musim-2018-2019","mp_side":"Visitor","tm_name":"MUTIARA DARUSSALAM FA","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_tsx1536166619.png&hash=22058877d78ab43a5e45f476f2102cec533ba19b87cf829e246a862eae7d3d86\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"ALKI FUTSAL","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_tsx1516680685.jpg&hash=9b69de7d08d39753072f2197f92d1b94b2496e94e04835348ce2d2b811010366\" 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":"3977","ma_tstamp":"24 Mar 2019, 11:30","lg_name":"LIGA AAFI REGIONAL DEPOK MUSIM 2018-2019","custom_info":"KATEGORI U-8 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=..%2Fupload%2Flogo%2Fleagues_lglogo_tsx1548037467.png&hash=7ef671ce617b259c6d553c5ccbd9085c118e95ed253abfa4e951be29e78b7231\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","lg_slug":"liga-aafi-regional-depok-musim-2018-2019","mp_side":"Visitor","tm_name":"MUTIARA DARUSSALAM FA","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_tsx1536166619.png&hash=22058877d78ab43a5e45f476f2102cec533ba19b87cf829e246a862eae7d3d86\" alt=\"Image\" style=\"width:20px; height:20px; margin: 0\" \/>","tm_name_opponent":"Spartans Futsal School","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_tsx1684584370.jpg&hash=4156438a3bda67e1aff66b857e40fe78749658ca4e45bc28cd108a1375e72764\" 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"}],"elapsed":"0.0006 s"}