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 Organic cotton boxer shortsBlue Wave Price €17.50 Size 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 Organic cotton boxer shortsRed Pyramid Price €17.50 Size 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 Organic cotton boxer shortsPink Herringbone Price €17.50 Size 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 Organic cotton boxer shortsGreen Jungle Price €17.50 Size 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 Organic cotton boxer shortsBlue Gingham Price €17.50 Size 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 Organic cotton boxer shortsGreen Illusion Price €17.50 Size 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 Organic cotton boxer shortsPure White Price €17.50 Size 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 Organic cotton boxer shortsBlue Jungle Price €17.50 Size 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 Organic cotton boxer shortsNavy Blue Price €17.50 Size 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 Organic cotton boxer shortsHavana Sand Price €17.50 Size 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 Organic cotton boxer shortsBlue Herringbone Price €17.50 Size 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 Organic cotton boxer shortsBilly Navy Price €17.50 Size 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 Organic cotton boxer shortYellow Sand Price €17.50 Size 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 Organic cotton boxer shortsWhite Illusion Price €17.50 Size 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 Organic cotton boxer shortsBilly Red Price €17.50 Size 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 Organic cotton boxer shortsRed Clover Price €17.50 Size 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 Organic cotton boxer shortsBlue Illusion Price €17.50 Size 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 Organic cotton boxer shortsBilly Green Price €17.50 Size 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 Organic cotton boxer shortsGrey Sand Price €17.50 Size 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 Boxer short Gift BoxThe Essential Price €74.17 Size 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 Boxer short Gift BoxThe Asserted Price €74.17 Size 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 Boxer short Gift BoxThe Modern Price €74.17 Size 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 Box of 3 boxers Shorts / 4 pairs of socks - The eternal Price €80.83 Size 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 