Jouets de collection
+ de 20000 références disponibles
Maquette, miniatures, circuits, figurines, jouets de collection, accessoires
Maquettes Miniatures Circuits Figurines Jouets de collection Accessoires
Accueil » Catalogue » Jouets de Collection » Star Wars 1317 - Query execution was interrupted

SELECT DISTINCT cd.categories_id AS id, cd.categories_name AS name FROM categories_description cd, categories cp WHERE cd.language_id = '4' AND (( cd.categories_id = cp.parent_id AND cp.categories_id IN ( select distinct c.categories_id from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join echelle e on p.echelle_id = e.echelle_id left join type on p.type_id = type.type_id , categories c,products_to_categories p2c where p.products_id = p2c.products_id and p.products_status>0 and c.categories_id = p2c.categories_id and c.parent_id IN ( SELECT c2.categories_id FROM categories AS c2 WHERE c2.parent_id = '1830' )) ) or ( cd.categories_id = cp.categories_id AND cp.categories_id IN ( select distinct c.categories_id from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join echelle e on p.echelle_id = e.echelle_id left join type on p.type_id = type.type_id , categories c,products_to_categories p2c where p.products_id = p2c.products_id and p.products_status>0 and p.products_quantity>0 and c.categories_id = p2c.categories_id and c.parent_id='1830' ))) order by categories_name

[TEP STOP]