SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`name`, cat.`color` category_default_color, cl.`link_rewrite` category_rewrite,
			tax.`rate`, i.`id_image`, il.`legend`, m.`name` manufacturer_name , DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 0 DAY)) > 0 new, v.`nom` nom_ville
		FROM ps_product p
		INNER JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2)
		LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group`
		                                           AND tr.`id_country` = 8
	                                           	   AND tr.`id_state` = 0)
	    LEFT JOIN `ps_tax` tax ON (tax.`id_tax` = tr.`id_tax`)
		LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`
		LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)
		LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
		LEFT JOIN `ps_category` cat ON (p.`id_category_default` = cat.`id_category`)
		LEFT JOIN `ps_category_lang` cl ON (cat.`id_category` = cl.`id_category`)
		LEFT JOIN `ps_category_product` c ON (c.`id_product` = p.`id_product`)
		LEFT JOIN `ps_ville` v ON (v.`id_ville` = p.`location`)
		LEFT JOIN `ps_departement` d ON (d.`id_departement` = v.`id_departement`)
		WHERE p.`active` = 1
		AND pl.`id_lang` = 2 AND p.`id_manufacturer` = 56
		GROUP BY p.`id_product`
		ORDER BY p.`date_add` DESC
		LIMIT 0,20
Locations Diverses T1 à louer - Cosne-Cours-sur-Loire ( 58200 ) - Quartier Centre-ville

Recherche avancée

Il y a 1 erreur :

  1. produit introuvable

Nouveaux produits

Aucun nouveau produit à l'heure actuelle