Motociklų dalys - MotoMoto

SELECT p.id, p.newprice, p.intervalprice, p.parent, p.oldprice, p.urllt, p.url, p.photo1, p.photo2, p.photo3, p.photo4, p.photo5, p.photo6, p.photo7, p.photo8, p.photo9, p.photo10, p.photo11, p.photo12, p.photo13, p.photo14, p.photo15, p.spalva, p.titlelt, p.gamintojas, p.oldprice, p.suspenduota, p.suspenduota_data, p.terminas, p.klaipeda, p.term FROM Product AS p INNER JOIN `CategoryList` AS c ON (p.id = c.product AND c.category = 2) INNER JOIN `Product_models` AS pm ON (p.id = pm.product AND pm.model = ) where p.`active` = 1 and `titlelt` != '' and p.`gamintojas` = 123 GROUP BY p.id order by `days` asc, is_photo desc, `nr` desc limit 3200, 25 Motociklų dalys - MotoMoto