Got error -1 from storage engine SQL=SELECT matches.* , playground.name AS playground_name, playground.short_name AS playground_short_name FROM newing_joomleague_match AS matches INNER JOIN newing_joomleague_round AS r ON matches.round_id = r.id INNER JOIN newing_joomleague_project_team AS pt1 ON matches.projectteam1_id = pt1.id INNER JOIN newing_joomleague_team AS t1 ON t1.id = pt1.team_id INNER JOIN newing_joomleague_project_team AS pt2 ON matches.projectteam2_id = pt2.id INNER JOIN newing_joomleague_team AS t2 ON t2.id = pt2.team_id LEFT JOIN newing_joomleague_playground AS playground ON playground.id = matches.playground_id WHERE r.project_id = 121 AND r.roundcode = 16 AND (t1.id = 131 OR t1.id = 131) AND matches.published = 1 GROUP BY matches.id
ORDER BY matches.match_date ASC, matches.match_number
Kategoria 1 2018-19
Match Schedule for Veleciku |
MD | Date | Time | Home Team | Away Team | Result | ||||||
1 | 09.09.2018 | 18:00 h | Dinamo | - | Veleciku | 1 | - | 0 | |||
2 | 15.09.2018 | 18:00 h | Veleciku | - | Vora | 2 | - | 1 | |||
3 | 22.09.2018 | 18:00 h | Beselidhja | - | Veleciku | 2 | - | 1 | |||
4 | 29.09.2018 | 18:00 h | Veleciku | - | Iliria | 1 | - | 0 | |||
5 | 06.10.2018 | 16:00 h | Vllaznia | - | Veleciku | 1 | - | 0 | |||
6 | 21.10.2018 | 16:00 h | Veleciku | - | Korabi | 2 | - | 1 | |||
7 | 27.10.2018 | 16:00 h | Erzeni | - | Veleciku | 2 | - | 1 | |||
8 | 04.11.2018 | 16:00 h | Veleciku | - | Burreli | 1 | - | 0 | |||
9 | 10.11.2018 | 16:00 h | Shenkolli | - | Veleciku | 3 | - | 0 | |||
10 | 24.11.2018 | 16:00 h | Veleciku | - | Dinamo | 0 | - | 0 | |||
11 | 01.12.2018 | 16:00 h | Vora | - | Veleciku | 0 | - | 2 | |||
12 | 08.12.2018 | 16:00 h | Veleciku | - | Beselidhja | 0 | - | 1 | |||
13 | 17.12.2018 | 16:00 h | Iliria | - | Veleciku | 0 | - | 1 | |||
14 | 22.12.2018 | 15:30 h | Veleciku | - | Vllaznia | 0 | - | 2 | |||
15 | 02.02.2019 | 16:00 h | Korabi | - | Veleciku | 3 | - | 1 | |||
16 | 09.02.2019 | 16:00 h | Veleciku | - | Erzeni | 3 | - | 1 | |||
17 | 16.02.2019 | 16:00 h | Burreli | - | Veleciku | 5 | - | 2 | |||
18 | 23.02.2019 | 16:00 h | Veleciku | - | Shenkolli | 1 | - | 0 |