SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value
FROM `ps_feature_value_lang` fvl
LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=1
WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 15))
ORDER BY id_feature_value
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value
FROM `ps_feature_value_lang` fvl
LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=1
WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 15))
ORDER BY id_feature_value
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value
FROM `ps_feature_value_lang` fvl
LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=1
WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 16))
ORDER BY id_feature_value
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value
FROM `ps_feature_value_lang` fvl
LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=1
WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 16))
ORDER BY id_feature_value
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value
FROM `ps_feature_value_lang` fvl
LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=1
WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 20))
ORDER BY id_feature_value
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value
FROM `ps_feature_value_lang` fvl
LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=1
WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 20))
ORDER BY id_feature_value
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value
FROM `ps_feature_value_lang` fvl
LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=1
WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 18))
ORDER BY id_feature_value
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value
FROM `ps_feature_value_lang` fvl
LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=1
WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 18))
ORDER BY id_feature_value
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value
FROM `ps_feature_value_lang` fvl
LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=1
WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 14))
ORDER BY id_feature_value
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value
FROM `ps_feature_value_lang` fvl
LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=1
WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 14))
ORDER BY id_feature_value
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value
FROM `ps_feature_value_lang` fvl
LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=1
WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 19))
ORDER BY id_feature_value
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value
FROM `ps_feature_value_lang` fvl
LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=1
WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 19))
ORDER BY id_feature_value
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value
FROM `ps_feature_value_lang` fvl
LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=1
WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 17))
ORDER BY id_feature_value
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value
FROM `ps_feature_value_lang` fvl
LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=1
WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 17))
ORDER BY id_feature_value
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value
FROM `ps_feature_value_lang` fvl
LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=1
WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 13))
ORDER BY id_feature_value
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value
FROM `ps_feature_value_lang` fvl
LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=1
WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 13))
ORDER BY id_feature_value
Ajouter à ma wishlist
Vous devez avoir un compte pour pouvoir utiliser cette fonctionnalité.
Connexion Inscription
