Was gibt es Neues?
Weil jedes Kind anders ist, kreiert Janod intelligentes Spielzeug, das alle ihre Wünsche erfüllt und ihnen hilft, ihre Talente zu entfalten. Entdecken Sie all das in unserem Magazin!
Aucun article
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=4
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=4
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=4
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=4
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=4
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=4
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=4
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=4
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=4
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=4
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=4
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=4
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=4
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=4
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=4
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=4
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