Error writing file '/tmp/MY0ooY9L' (Errcode: 28 - No space left on device)
SELECT COUNT(IF(tip_id=1 OR tip_id=2 OR tip_id=3 OR tip_id=4,1,NULL)) AS match_news,COUNT(IF(tip_id=5,1,NULL)) AS page_news FROM (SELECT h.tip_id FROM haberler h,haber_iller hi WHERE h.id=hi.haber_id AND h.durum=1 AND h.manset=1 AND hi.il_id='34' AND h.tip_id IN (1,2,3,4,5) ORDER BY h.oncelik,h.siralama LIMIT 8) xyz;SELECT COUNT(IF(tip_id=1 OR tip_id=2 OR tip_id=3 OR tip_id=4,1,NULL)) AS match_news,COUNT(IF(tip_id=5,1,NULL)) AS page_news FROM (SELECT h.tip_id FROM haberler h,haber_iller hi WHERE h.id=hi.haber_id AND h.durum=1 AND h.manset=1 AND hi.il_id='34' AND h.tip_id IN (1,2,3,4,5) ORDER BY h.oncelik,h.siralama LIMIT 8) xyz;You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '12' at line 31
SELECT h.id,h.baslik,h.alt_baslik,substr(h.alt_baslik,1,90) as kisa_alt_baslik,h.mac_id,h.metin,h.oncelik,tip_id,h.galeri_id,h.video_galeri_id, CONCAT(fg.klasor_ad,'/',fgr.resim) AS resim,CONCAT(fg.klasor_ad,'/thumbnails/',fgr.resim) AS resim_thumb, m.mac_durum,m.mac_oncesi_id,m.mac_sonrasi_id,m.roportaj_id,fg.galeri_ad,vg.galeri_ad AS video_galeri_ad, concat(substr(h.baslik,1,27),if(length(h.baslik)>27,'...','')) as kisa_baslik, m.gol1,m.gol2, t1.ad as takim1_ad,t2.ad as takim2_ad,t1.id as takim1_id,t2.id as takim2_id, IF(t1.id>0,getTeamLogo(t1.resim_id),0=0) AS team1_logo, IF(t2.id>0,getTeamLogo(t2.resim_id),0=0) AS team2_logo FROM (haberler h,haber_iller hi,ligler l, sezon s) LEFT JOIN foto_galeri_resimler fgr ON(fgr.id=h.resim_id ) LEFT JOIN foto_galeri fg ON(fg.id=fgr.galeri_id AND fg.uygulama_id=5) LEFT JOIN video_galeri vg ON(vg.id=h.video_galeri_id AND vg.uygulama_id=5) LEFT JOIN maclar m ON(m.id=h.mac_id AND m.lig_id='' AND m.uygulama_id=5) LEFT JOIN takimlar t1 ON(t1.id=m.takim1_id) LEFT JOIN takimlar t2 ON(t2.id=m.takim2_id) WHERE hi.haber_id=h.id and (hi.il_id ='34' or 34=0) /*AND h.tarih>=DATE_ADD('2026-06-06',INTERVAL -3 MONTH)*/ AND h.durum=1 AND h.tip_id in (1,2,3,4) AND (h.manset=1 or 1=0) and h.uygulama_id=5 AND l.id=hi.lig_id AND s.lig_id=l.id AND l.id='' AND s.sene=2026 AND (h.tarih BETWEEN s.bas_tarih AND s.bit_tarih) group by h.id ORDER BY h.`oncelik` DESC,h.`siralama` DESC, h.tarih desc LIMIT ,12;