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 = 96 AND r.roundcode = 5 AND (t1.id = 44 OR t1.id = 44) AND matches.published = 1 GROUP BY matches.id
ORDER BY matches.match_date ASC, matches.match_number
Raiffeisen Superliga Kosove 2013-14
Match Schedule for DRENICA |
MD | Date | Time | Home Team | Away Team | Result | ||||||
1 | 18.08.2013 | 18:30 h | HAJVALIA | - | DRENICA | 4 | - | 1 | |||
2 | 24.08.2013 | 18:00 h | DRENICA | - | TREPCA | 1 | - | 0 | |||
3 | 01.09.2013 | 18:00 h | LLAMKOS KOSOVA FK | - | DRENICA | 2 | - | 1 | |||
4 | 08.09.2013 | 17:00 h | TREPCA 89 | - | DRENICA | 1 | - | 0 | |||
5 | 13.09.2013 | 17:00 h | DRENICA | - | BESA | 0 | - | 2 | |||
6 | 21.09.2013 | 17:00 h | FUSHE KOSOVA | - | DRENICA | 1 | - | 1 | |||
7 | 26.09.2013 | 17:00 h | DRENICA | - | FERIZAJ | 3 | - | 1 | |||
8 | 28.09.2013 | 17:00 h | FERONIKELI | - | DRENICA | 1 | - | 2 | |||
9 | 05.10.2013 | 16:00 h | DRENICA | - | PRISHTINA | 1 | - | 0 | |||
10 | 13.10.2013 | 16:02 h | HYSI | - | DRENICA | 1 | - | 1 | |||
11 | 19.10.2013 | 16:00 h | DRENICA | - | DRITA | 3 | - | 0 | |||
12 | 26.10.2013 | 15:00 h | DRENICA | - | HAJVALIA | 5 | - | 1 | |||
13 | 30.10.2013 | 15:00 h | TREPCA | - | DRENICA | 2 | - | 2 | |||
14 | 05.11.2013 | 15:00 h | DRENICA | - | LLAMKOS KOSOVA FK | 1 | - | 1 | |||
15 | 09.11.2013 | 15:00 h | DRENICA | - | TREPCA 89 | 1 | - | 1 | |||
16 | 16.11.2013 | 14:00 h | BESA | - | DRENICA | 2 | - | 2 | |||
17 | 23.11.2013 | 14:00 h | DRENICA | - | FUSHE KOSOVA | 2 | - | 1 | |||
18 | 07.03.2014 | 17:00 h | FERIZAJ | - | DRENICA | 0 | - | 0 | |||
19 | 15.03.2014 | 17:00 h | DRENICA | - | FERONIKELI | 0 | - | 1 | |||
20 | 23.03.2014 | 17:00 h | PRISHTINA | - | DRENICA | 1 | - | 2 | |||
21 | 26.03.2014 | 17:00 h | DRENICA | - | HYSI | 3 | - | 0 | |||
22 | 30.03.2014 | 17:00 h | DRITA | - | DRENICA | 0 | - | 0 | |||
23 | 05.04.2014 | 17:00 h | DRENICA | - | TREPCA 89 | 1 | - | 3 | |||
24 | 12.04.2014 | 17:00 h | TREPCA | - | DRENICA | 0 | - | 0 | |||
25 | 18.04.2014 | 16:00 h | DRENICA | - | FERONIKELI | 1 | - | 0 | |||
26 | 23.04.2014 | 17:00 h | FUSHE KOSOVA | - | DRENICA | 2 | - | 1 | |||
27 | 26.04.2014 | 16:00 h | DRENICA | - | DRITA | 3 | - | 0 | |||
28 | 04.05.2014 | 16:00 h | BESA | - | DRENICA | 2 | - | 0 |