{"status":1,"html":"
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
DATA<\/th>\r\n MECZ<\/th>\r\n WYNIK<\/th>\r\n <\/tr>\r\n <\/thead>\r\n
2021-09-04<\/td>\r\n GTK Gliwice - MKS D\u0105browa G\u00f3rnicza<\/td>\r\n 67 - 95<\/td>\r\n <\/tr>\r\n
2021-09-11<\/td>\r\n Trefl Sopot - GTK Gliwice<\/td>\r\n 91 - 68<\/td>\r\n <\/tr>\r\n
2021-09-16<\/td>\r\n GTK Gliwice - Legia Warszawa<\/td>\r\n 78 - 75<\/td>\r\n <\/tr>\r\n
2021-09-24<\/td>\r\n Twarde Pierniki Toru\u0144 - GTK Gliwice<\/td>\r\n 99 - 85<\/td>\r\n <\/tr>\r\n
2021-10-04<\/td>\r\n GTK Gliwice - Asseco Arka Gdynia<\/td>\r\n 72 - 73<\/td>\r\n <\/tr>\r\n
2021-10-09<\/td>\r\n GTK Gliwice - PGE Sp\u00f3jnia Stargard<\/td>\r\n 110 - 70<\/td>\r\n <\/tr>\r\n
2021-10-14<\/td>\r\n HydroTruck Radom - GTK Gliwice<\/td>\r\n 82 - 94<\/td>\r\n <\/tr>\r\n
2021-10-24<\/td>\r\n GTK Gliwice - Polski Cukier Pszcz\u00f3\u0142ka Start Lublin<\/td>\r\n <\/td>\r\n <\/tr>\r\n
2021-10-28<\/td>\r\n Zastal Enea BC Zielona G\u00f3ra - GTK Gliwice<\/td>\r\n <\/td>\r\n <\/tr>\r\n
2021-11-05<\/td>\r\n GTK Gliwice - Arged BM Slam Stal Ostr\u00f3w Wielkopolski<\/td>\r\n <\/td>\r\n <\/tr>\r\n
2021-11-11<\/td>\r\n Enea Abramczyk Astoria Bydgoszcz - GTK Gliwice<\/td>\r\n <\/td>\r\n <\/tr>\r\n
2021-11-21<\/td>\r\n WKS \u015al\u0105sk Wroc\u0142aw - GTK Gliwice<\/td>\r\n <\/td>\r\n <\/tr>\r\n
2021-12-05<\/td>\r\n Anwil W\u0142oc\u0142awek - GTK Gliwice<\/td>\r\n <\/td>\r\n <\/tr>\r\n
2021-12-12<\/td>\r\n Grupa Sierleccy Czarni S\u0142upsk - GTK Gliwice<\/td>\r\n <\/td>\r\n <\/tr>\r\n <\/tbody>\r\n <\/table>\r\n <\/div>\r\n","$query":"( SELECT * FROM (\tSELECT\r\n\t m.id,\r\n m.gol1,\r\n m.gol2,\r\n TIME_FORMAT(m.godzina, '%H:%i') AS godzina,\r\n DATE_FORMAT(m.data, '%d.%m') AS data_pokaz,\r\n d1.id AS id1,\r\n d2.id AS id2,\r\n d1.nazwa AS nazwa1,\r\n d2.nazwa AS nazwa2,\r\n r.nazwa AS rozgrywka_nazwa,\r\n r.typ AS rozgrywka_typ,\r\n m.stadion,\r\n m.data,\r\n TIME_FORMAT(`godzina`, '%H:%i') AS godzina_show,\r\n DAY(`data`) AS dzien,\r\n MONTH(`data`) AS miesiac\r\n \r\n FROM `moduly_rozgrywki_mecze` m\r\n JOIN `moduly_druzyny` d1\r\n ON m.id_druzyna1 = d1.id\r\n JOIN `moduly_druzyny` d2\r\n ON m.id_druzyna2 = d2.id\r\n JOIN `moduly_rozgrywki` r\r\n ON m.id_rozgrywka = r.id \r\n LEFT JOIN `moduly_rozgrywki_kolejki` k\r\n ON m.id_kolejka = k.id \r\n WHERE (m.id_druzyna1=1 OR m.id_druzyna2=1)\r\n AND r.public = 1 \r\n AND m.data < now()\r\n ORDER BY m.data DESC , m.godzina LIMIT 7 ) \r\n tmp ORDER BY tmp.data ASC LIMIT 7 )\r\n\r\nUNION ALL\r\n (\tSELECT\r\n\t m.id,\r\n m.gol1,\r\n m.gol2,\r\n TIME_FORMAT(m.godzina, '%H:%i') AS godzina,\r\n DATE_FORMAT(m.data, '%d.%m') AS data_pokaz,\r\n d1.id AS id1,\r\n d2.id AS id2,\r\n d1.nazwa AS nazwa1,\r\n d2.nazwa AS nazwa2,\r\n r.nazwa AS rozgrywka_nazwa,\r\n r.typ AS rozgrywka_typ,\r\n m.stadion,\r\n m.data,\r\n TIME_FORMAT(`godzina`, '%H:%i') AS godzina_show,\r\n DAY(`data`) AS dzien,\r\n MONTH(`data`) AS miesiac\r\n \r\n FROM `moduly_rozgrywki_mecze` m\r\n JOIN `moduly_druzyny` d1\r\n ON m.id_druzyna1 = d1.id\r\n JOIN `moduly_druzyny` d2\r\n ON m.id_druzyna2 = d2.id\r\n JOIN `moduly_rozgrywki` r\r\n ON m.id_rozgrywka = r.id \r\n LEFT JOIN `moduly_rozgrywki_kolejki` k\r\n ON m.id_kolejka = k.id \r\n WHERE (m.id_druzyna1=1 OR m.id_druzyna2=1)\r\n AND r.public = 1 \r\n AND m.data > now()\r\n ORDER BY m.data , m.godzina LIMIT 7)"}