SELECT urun.*,marka.AD as marka_ad, urun_indirim.fiyat AS ind_fiyat FROM urun LEFT JOIN urun_indirim ON urun_indirim.`index` = urun.`INDEX` AND '2010.09.09' >= urun_indirim.`baslangic` AND '2010.09.09' <= urun_indirim.`bitis` LEFT JOIN materyal ON urun.MATERYAL = materyal.`INDEX` LEFT JOIN kategori ON urun.kategori = kategori.`INDEX` LEFT JOIN marka ON marka.`index` = urun.marka WHERE 1=1 AND YAYINLA = 1 AND ( MARKA='157' ) ORDER BY `rectime` DESC,`PUAN` DESC, `KATEGORI` ASC LIMIT 0, 21
