Got error 28 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 = 115 AND r.roundcode = 19 AND (t1.id = 224 OR t1.id = 224) AND matches.published = 1 GROUP BY matches.id
ORDER BY matches.match_date ASC, matches.match_number
Vala Superliga Kosove 2016-17
Match Schedule for FERONIKELI |
MD | Date | Time | Home Team | Away Team | Result | ||||||
1 | 20.08.2016 | 17:00 h | FERONIKELI | - | BESA | 1 | - | 2 | |||
2 | 28.08.2016 | 17:00 h | GJILAN | - | FERONIKELI | 2 | - | 1 | |||
3 | 08.09.2016 | 17:00 h | FERONIKELI | - | TREPCA 89 | 4 | - | 1 | |||
4 | 11.09.2016 | 17:00 h | FERONIKELI | - | FERIZAJ | 2 | - | 1 | |||
5 | 17.09.2016 | 17:00 h | DRENICA | - | FERONIKELI | 1 | - | 2 | |||
6 | 24.09.2016 | 17:00 h | FERONIKELI | - | PRISHTINA | 0 | - | 1 | |||
7 | 28.09.2016 | 17:00 h | TREPCA | - | FERONIKELI | 0 | - | 1 | |||
8 | 11.10.2016 | 17:00 h | FERONIKELI | - | DRITA | 1 | - | 0 | |||
9 | 16.10.2016 | 17:00 h | KF LLAPI | - | FERONIKELI | 0 | - | 3 | |||
10 | 22.10.2016 | 17:00 h | FERONIKELI | - | LIRIA | 1 | - | 0 | |||
11 | 28.10.2016 | 17:00 h | HAJVALIA | - | FERONIKELI | 2 | - | 3 | |||
12 | 02.11.2016 | 16:00 h | BESA | - | FERONIKELI | 1 | - | 1 | |||
13 | 05.11.2016 | 16:00 h | FERONIKELI | - | GJILAN | 1 | - | 0 | |||
14 | 16.11.2016 | 16:00 h | TREPCA 89 | - | FERONIKELI | 0 | - | 0 | |||
15 | 20.11.2016 | 15:00 h | FERIZAJ | - | FERONIKELI | 2 | - | 0 | |||
16 | 25.11.2016 | 14:00 h | FERONIKELI | - | DRENICA | 1 | - | 0 | |||
17 | 30.11.2016 | 15:00 h | PRISHTINA | - | FERONIKELI | 0 | - | 0 | |||
18 | 25.02.2017 | 15:00 h | FERONIKELI | - | TREPCA | 5 | - | 1 | |||
19 | 05.03.2017 | 15:00 h | DRITA | - | FERONIKELI | 0 | - | 1 | |||
20 | 08.03.2017 | 15:00 h | FERONIKELI | - | KF LLAPI | 1 | - | 0 | |||
21 | 12.03.2017 | 15:00 h | LIRIA | - | FERONIKELI | 1 | - | 3 | |||
22 | 17.03.2017 | 16:00 h | FERONIKELI | - | HAJVALIA | 6 | - | 1 | |||
23 | 01.04.2017 | 17:00 h | FERONIKELI | - | DRENICA | 0 | - | 1 |