Mungon ambulanca ne Shkoder,ndeshja fillon me vone... » Vazhdojne situatat qesharake ne Superligen shqipta...
Nderpritet ndeshja ne Kukes » Rreth minutes 60 ne pjesen e tribunes perballe ku ...
Lajmet e fundit para Flamurtari-Vllaznia » Lajmet e fundit qe vijne nga Vlora jane pozitive p...
Skenderbeu kampion, Terbuni dhe Bylis bien nga kat... » Ekipi i Skenderbeut te Korçes eshte shpallur kampi...
Partizani fiton ne Korçe dhe rihap kampionatin » Ekipi i Partizanit ka arritur te fitoje ne minutat...
Ndodhe edhe kjo ne Superiore » Ne ndeshje e sotme midis Terbunit dhe Bylis qe do ...
Kapllanaj:Federata po tallet me ne » Nuk ka te sosur polemika per qeshtjen Albi A...
Stavri Nica dorehiqet » Pas barazimit ne Puke kunder Terbunit,trajneri i k...
Vangjeli ne perfundim te ndeshjes » Ishte nje gol vendimtar ne minutat e fundit.Mbajme...
Sabien Lilaj:Kundershtari po luan ashper » Ne perfundim te pjeses se pare mesfushori i korçar...
E enjte, 16 Korrik 2026
Superliga
Kategoria 1
Kosova
Got error 28 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=36 AND r.project_id=100 GROUP BY m.id ORDER BY m.match_date ASC, m.match_number
