SELECT * , (SELECT image FROM album_images WHERE img_order=1 AND album_id = pro_id AND aim_table='products' LIMIT 0,1) AS thumb FROM products LEFT JOIN versions ON pro_id = ver_fk WHERE ver_fk_table='products' AND ver_lang = 'fr' AND pro_selling_price>0 AND ver_translation_status=3 AND pro_online=1 ORDER BY pro_order ASC LIMIT 0,30

Sofas et Lits, route des Gohineaux, 4, 6880 Bertrix Belgique - + - ouvert tous les jours de 11h à 19h non stop. Fermé le mardi.