SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 737 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bioBlue Wave Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 740 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bioRed Pyramid Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 735 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bioPink Herringbone Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 739 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bioGreen Jungle Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 734 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bioBlue Gingham Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 736 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bioGreen Illusion Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 732 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bioPure White Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 738 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bioBlue Jungle Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 733 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bioNavy Blue Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 637 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bio Havana Sand Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 635 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bioBlue Herringbone Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 632 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bioBilly Navy Prix 17,50 € Taille S
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 641 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bio Yellow Sand Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 639 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bio White Illusion Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 634 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bioBilly Red Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 638 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bio Red Clover Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 640 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bio Blue Illusion Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 633 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bioBilly Green Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 636 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Caleçon coton bioGrey Sand Prix 17,50 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 825 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Coffret de 5 CaleçonsL'Essentiel Prix 74,17 € Taille S
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 824 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Coffret de 5 CaleçonsL'Affirmé Prix 74,17 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 826 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Coffret de 5 CaleçonsLe Moderne Prix 74,17 € Taille S M L XL
SELECT ims.id_image FROM `ps_image` i LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product WHERE i.`id_product` = 879 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Coffret de 3 caleçons / 4 paires de chaussettes - L'éternel Prix 80,83 € Taille S M L XL
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 737 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 740 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 735 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 739 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 734 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 736 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 732 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 738 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 733 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 637 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 635 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 632 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 641 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 639 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 634 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 638 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 640 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 633 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 636 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 825 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 824 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 826 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 
SELECT ims.id_image
FROM `ps_image` i
LEFT JOIN `ps_image_shop` ims ON i.id_product=ims.id_product
WHERE i.`id_product` = 879 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 