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='171' ) ORDER BY `rectime` DESC,`PUAN` DESC, `KATEGORI` ASC LIMIT 0, 21
Elite silver | 214 ürün |
 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Babalar Gününe Özel %50 indirimli fiyat! |
|
:
1 2 3 4 5 6 7 8 9 10 11 |
