HOT NEWS
E premte, 29 Mars 2024
  • Superliga
  • Kategoria 1
  • Kosova
Got error -1 from storage engine SQL=SELECT m.*, DATE_FORMAT(m.time_present,"%H:%i") time_present, playground.name AS playground_name, playground.short_name AS playground_short_name, tt1.project_id, CASE WHEN CHAR_LENGTH(t1.alias) AND CHAR_LENGTH(t2.alias) THEN CONCAT_WS(':', m.id, CONCAT_WS("_", t1.alias, t2.alias)) ELSE m.id END AS slug FROM newing_joomleague_match AS m INNER JOIN newing_joomleague_round AS r ON m.round_id=r.id LEFT JOIN newing_joomleague_project_team AS tt1 ON m.projectteam1_id=tt1.id LEFT JOIN newing_joomleague_project_team AS tt2 ON m.projectteam2_id=tt2.id LEFT JOIN newing_joomleague_team AS t1 ON t1.id=tt1.team_id LEFT JOIN newing_joomleague_team AS t2 ON t2.id=tt2.team_id LEFT JOIN newing_joomleague_division AS d1 ON tt1.division_id=d1.id LEFT JOIN newing_joomleague_division AS d2 ON tt2.division_id=d2.id LEFT JOIN newing_joomleague_playground AS playground ON playground.id=m.playground_id WHERE r.roundcode=2 AND r.project_id=2 GROUP BY m.id ORDER BY m.match_date ASC, m.match_number
Rezultatet - Ndeshja 2-te (10.09.2008)

6 Team(s) not playing: Shqiperi, Portugali, Malta, Suedi, Hungari, Danimarke

Lajmet e Fundit

    Lajmet me te lexuara

      Komentet e fundit