SELECT DISTINCT( SUBSTRING_INDEX(reference, '.', 1) ) AS reference FROM prstshp_product_attribute pa
LEFT JOIN
prstshp_stock_available sa
ON sa.id_product = pa.id_product AND sa.id_product_attribute = pa.id_product_attribute
WHERE pa.id_product = 264 AND sa.quantity > 0
SELECT DISTINCT( SUBSTRING_INDEX(reference, '.', 1) ) AS reference FROM prstshp_product_attribute pa
LEFT JOIN
prstshp_stock_available sa
ON sa.id_product = pa.id_product AND sa.id_product_attribute = pa.id_product_attribute
WHERE pa.id_product = 285 AND sa.quantity > 0
SELECT DISTINCT( SUBSTRING_INDEX(reference, '.', 1) ) AS reference FROM prstshp_product_attribute pa
LEFT JOIN
prstshp_stock_available sa
ON sa.id_product = pa.id_product AND sa.id_product_attribute = pa.id_product_attribute
WHERE pa.id_product = 262 AND sa.quantity > 0
SELECT DISTINCT( SUBSTRING_INDEX(reference, '.', 1) ) AS reference FROM prstshp_product_attribute pa
LEFT JOIN
prstshp_stock_available sa
ON sa.id_product = pa.id_product AND sa.id_product_attribute = pa.id_product_attribute
WHERE pa.id_product = 263 AND sa.quantity > 0
SELECT DISTINCT( SUBSTRING_INDEX(reference, '.', 1) ) AS reference FROM prstshp_product_attribute pa
LEFT JOIN
prstshp_stock_available sa
ON sa.id_product = pa.id_product AND sa.id_product_attribute = pa.id_product_attribute
WHERE pa.id_product = 284 AND sa.quantity > 0
SELECT DISTINCT( SUBSTRING_INDEX(reference, '.', 1) ) AS reference FROM prstshp_product_attribute pa
LEFT JOIN
prstshp_stock_available sa
ON sa.id_product = pa.id_product AND sa.id_product_attribute = pa.id_product_attribute
WHERE pa.id_product = 286 AND sa.quantity > 0
SELECT DISTINCT( SUBSTRING_INDEX(reference, '.', 1) ) AS reference FROM prstshp_product_attribute pa
LEFT JOIN
prstshp_stock_available sa
ON sa.id_product = pa.id_product AND sa.id_product_attribute = pa.id_product_attribute
WHERE pa.id_product = 276 AND sa.quantity > 0
Sleeve of rigid cloth
English
Español
Français
Português
