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 Cotton socksMottled blue Price €6.67 Size One size : 7 / 11
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 Cotton socks Navy Blue Price €6.67 Size One size : 7 / 11
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 Cotton socksBlack Price €6.67 Size One size : 7 / 11
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 Cotton socksKhaki Green Price €6.67 Size One size : 7 / 11
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 Cotton socks Red pomegranate Price €6.67 Size One size : 7 / 11
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 Cotton socksBeige Price €6.67 Size One size : 7 / 11
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 Cotton SocksBurgundy Price €6.67 Size One size : 7 / 11
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 Cotton socks UK Green Price €6.67 Size One size : 7 / 11
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 Cotton SocksBrick Price €6.67 Size One size : 7 / 11
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 