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 '4%' OR urun.ID = '4%' OR marka.name like '4%' OR urun.name like '%4%%' OR urun.onDetay like '%4%%' OR urun.tedarikciCode like '%4%%' OR urun.gtin like '%4%%' OR urun.data1 like '%4%%' OR urun.seo like '%4%%' OR urun.name like '%4%%' OR urun.filitre like '%4%%' OR urun.filitre like '%4%%' OR urun.metaKeywords like '%4%%' OR urun.metaKeywords like '%4%%' OR urun.metaDescription like '%4%%' OR urun.metaDescription like '%4%%' OR (urun.name like '%4%%')) AND urun.fiyat >= '0' AND fiyat <= '99999999999' group by urun.catID order by kategori.namePath, urun.name like '% 4/ %' desc,urun.name like '%4/%' desc,if(urun.resim = '' or urun.resim is null,1,0),if(urun.stok = 0,1,0),urun.seq desc,urun.ID desc
Table '(temporary)' is marked as crashed and should be repaired