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` = 665 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Chaussettes cotonBleu chiné Prix 6,67 € Taille Taille unique : 41 / 46
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` = 239 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Chaussettes cotonBleu Marine Prix 6,67 € Taille Taille unique : 41 / 46
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` = 237 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Chaussettes cotonNoir Réglisse Prix 6,67 € Taille Taille unique : 41 / 46
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` = 507 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Chaussettes cotonVert Kaki Prix 6,67 € Taille Taille unique : 41 / 46
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` = 242 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Chaussettes cotonRouge Grenade Prix 6,67 € Taille Taille unique : 41 / 46
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` = 235 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Chaussettes cotonBeige Prix 6,67 € Taille Taille unique : 41 / 46
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` = 430 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Chaussettes cotonRouge Bordeaux Prix 6,67 € Taille Taille unique : 41 / 46
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` = 505 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Chaussettes cotonVert Anglais Prix 6,67 € Taille Taille unique : 41 / 46
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` = 238 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC Chaussettes cotonBrique Prix 6,67 € Taille Taille unique : 41 / 46
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` = 665 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` = 239 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` = 237 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` = 507 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` = 242 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` = 235 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` = 430 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` = 505 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` = 238 AND ims.id_shop=2 AND (ims.cover = 0 OR ims.cover is null) ORDER BY `position` ASC 