AIM, datalogger, laptimer, Dynoteg, vermogenstestbank, Capit, bandenwarmers, Wildkart, kartonderdelen, HM, quickshifter
AIM, datalogger, laptimer, Dynoteg, vermogenstestbank, Capit, bandenwarmers, Wildkart, kartonderdelen, HM, quickshifter
Home
Maak Account/Log in
Contact
Winkelwagen
Wenslijst
Nederlands Engels
Winkelwagen meer
Uw winkelwagen is leeg!
Snel Zoeken
 
Gebruik sleutelwoorden om producten te vinden.
Geavanceerd Zoeken
Producten
1317 - Query execution was interrupted

select c.categories_id, cd.categories_name, c.parent_id from categories c join categories_description cd where c.categories_status = '1' and c.categories_id in ( select distinct(x.categories_id) from products_to_categories x join products y on x.products_id = y.Products_id and y.products_status = 1 where x.categories_id = c.categories_id union select distinct(c1.parent_id) from categories c1 join products_to_categories x on x.categories_id = c1.categories_id join products y on x.products_id = y.Products_id and y.products_status = 1 where c1.parent_id = c.categories_id union select distinct(c2.parent_id) from categories c2 join categories c1 on c2.categories_id = c1.parent_id join products_to_categories x on x.categories_id = c1.categories_id join products y on x.products_id = y.Products_id and y.products_status = 1 where c2.parent_id = c.categories_id union select distinct(c3.parent_id) from categories c3 join categories c2 on c3.categories_id = c2.parent_id join categories c1 on c2.categories_id = c1.parent_id join products_to_categories x on x.categories_id = c1.categories_id join products y on x.products_id = y.Products_id and y.products_status = 1 where c3.parent_id = c.categories_id union select distinct(c4.parent_id) from categories c4 join categories c3 on c4.categories_id = c3.parent_id join categories c2 on c3.categories_id = c2.parent_id join categories c1 on c2.categories_id = c1.parent_id join products_to_categories x on x.categories_id = c1.categories_id join products y on x.products_id = y.Products_id and y.products_status = 1 where c4.parent_id = c.categories_id ) and c.parent_id = '0' and c.categories_fsk_18_hidden = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name

[TEP STOP]