Query : select urun.*,kategori.namePath from urun,kategori,marka where ((1=1 ) AND (urun.userGroup like '%,,%' OR urun.userGroup = '')) AND urun.active=1 AND urun.markaID = marka.ID AND kategori.active=1 AND urun.catID=kategori.ID AND (kategori.name like '%%%%%A%%MA' OR urun.ID = '%%%%%A%%MA' OR marka.name like '%%%%%A%%MA' OR urun.name like '%%%%%%A%%MA%' OR urun.onDetay like '%%%%%%A%%MA%' OR urun.tedarikciCode like '%%%%%%A%%MA%' OR urun.gtin like '%%%%%%A%%MA%' OR urun.data1 like '%%%%%%A%%MA%' OR urun.seo like '%%%%%%A%%MA%' OR urun.name like '%%%%%%A%%MA%' OR urun.filitre like '%%%%%%A%%MA%' OR urun.filitre like '%%%%%%A%%MA%' OR urun.metaKeywords like '%%%%%%A%%MA%' OR urun.metaKeywords like '%%%%%%A%%MA%' OR urun.metaDescription like '%%%%%%A%%MA%' OR urun.metaDescription like '%%%%%%A%%MA%' OR (urun.name like '%%%%%%' AND urun.name like '%A%%MA%')) AND urun.fiyat >= '0' AND fiyat <= '99999999999' group by urun.catID order by kategori.namePath, urun.name like '% İÇ AÇMA %' desc,urun.name like '%İÇ AÇMA%' desc,if(urun.resim = '' or urun.resim is null,1,0),if(urun.stok = 0,1,0),urun.seq desc,urun.ID desc
Can't create/write to file '/tmp/#sql-temptable-199a1-55ccbfe-59839d.MAI' (Errcode: 28 "No space left on device")