Haken en sluitingen


Paniekhaak (194025)

Paniekhaak

4,50
Musketon 5/8 (190497)

Musketon 5/8

1,75
Karabijnhaak ()

Karabijnhaak

vanaf 0,75

Getoonde prijzen inclusief korting en BTW | Prijs en zetfouten voorbehouden | Getoonde afbeeldingen kunnen afwijken van de werkelijkheid en zijn altijd exclusief accessoires, tenzij anders vermeld.

(default) 20 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Content`.`id`, `Content`.`slug` FROM `voordehoefsmit`.`nl_contents` AS `Content` WHERE `Content`.`status` = 'publish' AND `Content`.`slug` != ''12120
2SELECT `Content`.`id`, `Content`.`slug` FROM `voordehoefsmit`.`nl_contents` AS `Content` WHERE `Content`.`status` = 'publish' AND `Content`.`slug` != ''12120
3INSERT INTO `voordehoefsmit`.`nl_carts` (`session`, `shipping_method`, `payment_method`, `country`, `ip`, `modified`, `created`) VALUES ('vlto2ef3kbcqacods7hdjr5gi1', 'dhl4you', 'targetpay', 'nl', '54.81.254.212', '2018-07-22 16:22:42', '2018-07-22 16:22:42')110
4SELECT `Cart`.`id`, `Cart`.`session`, `Cart`.`customer_id`, `Cart`.`invoice_address_id`, `Cart`.`shipping_address_id`, `Cart`.`use_other_address`, `Cart`.`country`, `Cart`.`ip`, `Cart`.`data`, `Cart`.`contents`, `Cart`.`subtotal`, `Cart`.`quantity`, `Cart`.`discount`, `Cart`.`shipping`, `Cart`.`tax`, `Cart`.`discounts`, `Cart`.`total`, `Cart`.`shipping_method`, `Cart`.`payment_method`, `Cart`.`promocode`, `Cart`.`debt_account`, `Cart`.`debt_holder`, `Cart`.`comments`, `Cart`.`created`, `Cart`.`modified`, `InvoiceAddress`.`id`, `InvoiceAddress`.`customer_id`, `InvoiceAddress`.`address`, `InvoiceAddress`.`zipcode`, `InvoiceAddress`.`city`, `InvoiceAddress`.`province`, `InvoiceAddress`.`country_id`, `InvoiceAddress`.`role`, `InvoiceAddress`.`modified`, `InvoiceAddress`.`created`, `ShippingAddress`.`id`, `ShippingAddress`.`customer_id`, `ShippingAddress`.`address`, `ShippingAddress`.`zipcode`, `ShippingAddress`.`city`, `ShippingAddress`.`province`, `ShippingAddress`.`country_id`, `ShippingAddress`.`role`, `ShippingAddress`.`modified`, `ShippingAddress`.`created`, `Customer`.`id`, `Customer`.`type`, `Customer`.`gender`, `Customer`.`firstname`, `Customer`.`lastname`, `Customer`.`email`, `Customer`.`phone`, `Customer`.`company`, `Customer`.`activation`, `Customer`.`info`, `Customer`.`customer_card`, `Customer`.`last_login`, `Customer`.`created`, `Customer`.`modified` FROM `voordehoefsmit`.`nl_carts` AS `Cart` LEFT JOIN `voordehoefsmit`.`nl_addresses` AS `InvoiceAddress` ON (`Cart`.`invoice_address_id` = `InvoiceAddress`.`id`) LEFT JOIN `voordehoefsmit`.`nl_addresses` AS `ShippingAddress` ON (`Cart`.`shipping_address_id` = `ShippingAddress`.`id`) LEFT JOIN `voordehoefsmit`.`nl_customers` AS `Customer` ON (`Cart`.`customer_id` = `Customer`.`id`) WHERE `Cart`.`id` = 397296 LIMIT 1110
5SELECT `LineItem`.`id`, `LineItem`.`cart_id`, `LineItem`.`price_id`, `LineItem`.`price`, `LineItem`.`discount`, `LineItem`.`quantity`, `LineItem`.`subtotal`, `LineItem`.`tax`, `LineItem`.`data`, `LineItem`.`freeshipping` FROM `voordehoefsmit`.`nl_line_items` AS `LineItem` WHERE `LineItem`.`cart_id` = (397296) 000
6SELECT `Cart`.`id`, `Cart`.`session`, `Cart`.`customer_id`, `Cart`.`invoice_address_id`, `Cart`.`shipping_address_id`, `Cart`.`use_other_address`, `Cart`.`country`, `Cart`.`ip`, `Cart`.`data`, `Cart`.`contents`, `Cart`.`subtotal`, `Cart`.`quantity`, `Cart`.`discount`, `Cart`.`shipping`, `Cart`.`tax`, `Cart`.`discounts`, `Cart`.`total`, `Cart`.`shipping_method`, `Cart`.`payment_method`, `Cart`.`promocode`, `Cart`.`debt_account`, `Cart`.`debt_holder`, `Cart`.`comments`, `Cart`.`created`, `Cart`.`modified`, `InvoiceAddress`.`id`, `InvoiceAddress`.`customer_id`, `InvoiceAddress`.`address`, `InvoiceAddress`.`zipcode`, `InvoiceAddress`.`city`, `InvoiceAddress`.`province`, `InvoiceAddress`.`country_id`, `InvoiceAddress`.`role`, `InvoiceAddress`.`modified`, `InvoiceAddress`.`created`, `ShippingAddress`.`id`, `ShippingAddress`.`customer_id`, `ShippingAddress`.`address`, `ShippingAddress`.`zipcode`, `ShippingAddress`.`city`, `ShippingAddress`.`province`, `ShippingAddress`.`country_id`, `ShippingAddress`.`role`, `ShippingAddress`.`modified`, `ShippingAddress`.`created`, `Customer`.`id`, `Customer`.`type`, `Customer`.`gender`, `Customer`.`firstname`, `Customer`.`lastname`, `Customer`.`email`, `Customer`.`phone`, `Customer`.`company`, `Customer`.`activation`, `Customer`.`info`, `Customer`.`customer_card`, `Customer`.`last_login`, `Customer`.`created`, `Customer`.`modified` FROM `voordehoefsmit`.`nl_carts` AS `Cart` LEFT JOIN `voordehoefsmit`.`nl_addresses` AS `InvoiceAddress` ON (`Cart`.`invoice_address_id` = `InvoiceAddress`.`id`) LEFT JOIN `voordehoefsmit`.`nl_addresses` AS `ShippingAddress` ON (`Cart`.`shipping_address_id` = `ShippingAddress`.`id`) LEFT JOIN `voordehoefsmit`.`nl_customers` AS `Customer` ON (`Cart`.`customer_id` = `Customer`.`id`) WHERE `Cart`.`id` = 397296 LIMIT 1110
7SELECT `LineItem`.`id`, `LineItem`.`cart_id`, `LineItem`.`price_id`, `LineItem`.`price`, `LineItem`.`discount`, `LineItem`.`quantity`, `LineItem`.`subtotal`, `LineItem`.`tax`, `LineItem`.`data`, `LineItem`.`freeshipping` FROM `voordehoefsmit`.`nl_line_items` AS `LineItem` WHERE `LineItem`.`cart_id` = (397296) 000
8SELECT `Region`.`id`, `Region`.`alias` FROM `voordehoefsmit`.`nl_regions` AS `Region` WHERE `Region`.`block_count` > 0550
9SELECT `Block`.`id`, `Block`.`region_id`, `Block`.`title`, `Block`.`alias`, `Block`.`body`, `Block`.`show_title`, `Block`.`class`, `Block`.`status`, `Block`.`weight`, `Block`.`element`, `Block`.`visibility_roles`, `Block`.`visibility_paths`, `Block`.`visibility_php`, `Block`.`params`, `Block`.`cache`, `Block`.`updated`, `Block`.`created` FROM `voordehoefsmit`.`nl_blocks` AS `Block` WHERE `Block`.`status` = '1' AND `Block`.`region_id` = 1 AND ((((`Block`.`visibility_roles` = '') OR (`Block`.`visibility_roles` LIKE '%\"3\"%'))) AND (((`Block`.`visibility_paths` = '') OR (`Block`.`visibility_paths` LIKE '%\"haken-en-sluitingen\"%') OR (`Block`.`visibility_paths` LIKE '%\"haken-en-sluitingen/*\"%') OR (((`Block`.`visibility_paths` LIKE '%\"-%') AND (`Block`.`visibility_paths` NOT LIKE '%\"-haken-en-sluitingen\"%') AND (`Block`.`visibility_paths` NOT LIKE '%\"-haken-en-sluitingen/*\"%')))))) ORDER BY `Block`.`weight` asc220
10SELECT `Block`.`id`, `Block`.`region_id`, `Block`.`title`, `Block`.`alias`, `Block`.`body`, `Block`.`show_title`, `Block`.`class`, `Block`.`status`, `Block`.`weight`, `Block`.`element`, `Block`.`visibility_roles`, `Block`.`visibility_paths`, `Block`.`visibility_php`, `Block`.`params`, `Block`.`cache`, `Block`.`updated`, `Block`.`created` FROM `voordehoefsmit`.`nl_blocks` AS `Block` WHERE `Block`.`status` = '1' AND `Block`.`region_id` = 4 AND ((((`Block`.`visibility_roles` = '') OR (`Block`.`visibility_roles` LIKE '%\"3\"%'))) AND (((`Block`.`visibility_paths` = '') OR (`Block`.`visibility_paths` LIKE '%\"haken-en-sluitingen\"%') OR (`Block`.`visibility_paths` LIKE '%\"haken-en-sluitingen/*\"%') OR (((`Block`.`visibility_paths` LIKE '%\"-%') AND (`Block`.`visibility_paths` NOT LIKE '%\"-haken-en-sluitingen\"%') AND (`Block`.`visibility_paths` NOT LIKE '%\"-haken-en-sluitingen/*\"%')))))) ORDER BY `Block`.`weight` asc110
11SELECT `Block`.`id`, `Block`.`region_id`, `Block`.`title`, `Block`.`alias`, `Block`.`body`, `Block`.`show_title`, `Block`.`class`, `Block`.`status`, `Block`.`weight`, `Block`.`element`, `Block`.`visibility_roles`, `Block`.`visibility_paths`, `Block`.`visibility_php`, `Block`.`params`, `Block`.`cache`, `Block`.`updated`, `Block`.`created` FROM `voordehoefsmit`.`nl_blocks` AS `Block` WHERE `Block`.`status` = '1' AND `Block`.`region_id` = 5 AND ((((`Block`.`visibility_roles` = '') OR (`Block`.`visibility_roles` LIKE '%\"3\"%'))) AND (((`Block`.`visibility_paths` = '') OR (`Block`.`visibility_paths` LIKE '%\"haken-en-sluitingen\"%') OR (`Block`.`visibility_paths` LIKE '%\"haken-en-sluitingen/*\"%') OR (((`Block`.`visibility_paths` LIKE '%\"-%') AND (`Block`.`visibility_paths` NOT LIKE '%\"-haken-en-sluitingen\"%') AND (`Block`.`visibility_paths` NOT LIKE '%\"-haken-en-sluitingen/*\"%')))))) ORDER BY `Block`.`weight` asc220
12SELECT `Block`.`id`, `Block`.`region_id`, `Block`.`title`, `Block`.`alias`, `Block`.`body`, `Block`.`show_title`, `Block`.`class`, `Block`.`status`, `Block`.`weight`, `Block`.`element`, `Block`.`visibility_roles`, `Block`.`visibility_paths`, `Block`.`visibility_php`, `Block`.`params`, `Block`.`cache`, `Block`.`updated`, `Block`.`created` FROM `voordehoefsmit`.`nl_blocks` AS `Block` WHERE `Block`.`status` = '1' AND `Block`.`region_id` = 6 AND ((((`Block`.`visibility_roles` = '') OR (`Block`.`visibility_roles` LIKE '%\"3\"%'))) AND (((`Block`.`visibility_paths` = '') OR (`Block`.`visibility_paths` LIKE '%\"haken-en-sluitingen\"%') OR (`Block`.`visibility_paths` LIKE '%\"haken-en-sluitingen/*\"%') OR (((`Block`.`visibility_paths` LIKE '%\"-%') AND (`Block`.`visibility_paths` NOT LIKE '%\"-haken-en-sluitingen\"%') AND (`Block`.`visibility_paths` NOT LIKE '%\"-haken-en-sluitingen/*\"%')))))) ORDER BY `Block`.`weight` asc110
13SELECT `Block`.`id`, `Block`.`region_id`, `Block`.`title`, `Block`.`alias`, `Block`.`body`, `Block`.`show_title`, `Block`.`class`, `Block`.`status`, `Block`.`weight`, `Block`.`element`, `Block`.`visibility_roles`, `Block`.`visibility_paths`, `Block`.`visibility_php`, `Block`.`params`, `Block`.`cache`, `Block`.`updated`, `Block`.`created` FROM `voordehoefsmit`.`nl_blocks` AS `Block` WHERE `Block`.`status` = '1' AND `Block`.`region_id` = 7 AND ((((`Block`.`visibility_roles` = '') OR (`Block`.`visibility_roles` LIKE '%\"3\"%'))) AND (((`Block`.`visibility_paths` = '') OR (`Block`.`visibility_paths` LIKE '%\"haken-en-sluitingen\"%') OR (`Block`.`visibility_paths` LIKE '%\"haken-en-sluitingen/*\"%') OR (((`Block`.`visibility_paths` LIKE '%\"-%') AND (`Block`.`visibility_paths` NOT LIKE '%\"-haken-en-sluitingen\"%') AND (`Block`.`visibility_paths` NOT LIKE '%\"-haken-en-sluitingen/*\"%')))))) ORDER BY `Block`.`weight` asc220
14SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`alias`, `Menu`.`description`, `Menu`.`status`, `Menu`.`weight`, `Menu`.`link_count`, `Menu`.`params`, `Menu`.`updated`, `Menu`.`created` FROM `voordehoefsmit`.`nl_menus` AS `Menu` WHERE `alias` != 'admin' AND `Menu`.`status` = '1'550
15SELECT `Promo`.`id`, `Promo`.`name`, `Promo`.`status`, `Promo`.`type`, `Promo`.`scope`, `Promo`.`discount`, `Promo`.`buyqty`, `Promo`.`getqty`, `Promo`.`search`, `Promo`.`code`, `Promo`.`rules`, `Promo`.`starts`, `Promo`.`ends`, `Promo`.`created`, `Promo`.`modified`, `Promo`.`target`, `Promo`.`uses`, `PricesPromo`.`promo_id`, `PricesPromo`.`product_id`, `PricesPromo`.`price_id` FROM `voordehoefsmit`.`nl_promos` AS `Promo` JOIN `voordehoefsmit`.`nl_prices_promos` AS `PricesPromo` ON (`PricesPromo`.`price_id` IN (18, 19, 20, 21, 22, 23, 24) AND `PricesPromo`.`promo_id` = `Promo`.`id`) 000
16SELECT `Spec`.`id`, `Spec`.`product_id`, `Spec`.`name`, `Spec`.`value`, `Spec`.`numeral`, `Spec`.`sortorder` FROM `voordehoefsmit`.`nl_specs` AS `Spec` WHERE `Spec`.`product_id` IN (22, 23, 21) ORDER BY `Spec`.`sortorder` asc 110
17SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`active`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`content`, `Category`.`product_count`, `Category`.`spectemplate`, `Category`.`facetedmenus`, `Category`.`variations`, `Category`.`pricerange`, `Category`.`priceranges`, `Category`.`specs`, `Category`.`options`, `Category`.`prices`, `Category`.`showproducts`, `Category`.`meta_description`, `Category`.`oldcat_id`, `Category`.`class`, `Category`.`created`, `Category`.`modified`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `voordehoefsmit`.`nl_categories` AS `Category` JOIN `voordehoefsmit`.`nl_categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` IN (22, 23, 21) AND `CategoriesProduct`.`category_id` = `Category`.`id`) 331
18SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `voordehoefsmit`.`nl_tags` AS `Tag` JOIN `voordehoefsmit`.`nl_tagged` AS `Tagged` ON (`Tagged`.`foreign_key` IN (22, 23, 21) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Product' 001
19SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`active`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`content`, `Category`.`product_count`, `Category`.`spectemplate`, `Category`.`facetedmenus`, `Category`.`variations`, `Category`.`pricerange`, `Category`.`priceranges`, `Category`.`specs`, `Category`.`options`, `Category`.`prices`, `Category`.`showproducts`, `Category`.`meta_description`, `Category`.`oldcat_id`, `Category`.`class`, `Category`.`created`, `Category`.`modified` FROM `voordehoefsmit`.`nl_categories` AS `Category` WHERE `Category`.`id` = 6 LIMIT 1110
20SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `voordehoefsmit`.`nl_categories` AS `Category` WHERE `Category`.`parent_id` = 6 AND `Category`.`active` = '1'000
(global) 5 queries took 7 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Language`.`id`, `Language`.`code`, `Language`.`name`, `Language`.`alias`, `Language`.`native`, `Language`.`direction`, `Language`.`weight`, `Language`.`icon`, `Language`.`status`, `Language`.`ordering` FROM `voordehoefsmit`.`global_languages` AS `Language` WHERE `status` = 1 ORDER BY `ordering` ASC330
2SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`summary`, `Product`.`description`, `Product`.`extra`, `Product`.`published`, `Product`.`edit_status`, `Product`.`featured`, `Product`.`variations`, `Product`.`options`, `Product`.`tax_class`, `Product`.`sku`, `Product`.`date`, `Product`.`old_id`, `Product`.`supplier_id`, `Product`.`supplier`, `Product`.`meta_description`, `Product`.`main_category`, `Product`.`backorder`, `Product`.`created`, `Product`.`modified`, (IF (`Pricer`.`sale`='on' AND MIN(`Pricer`.`saleprice`) > 0,MIN(`Pricer`.`saleprice`),MIN(`Pricer`.`price`))) AS `Product__lowprice`, (IF (`Pricer`.`sale`='on' AND MIN(`Pricer`.`saleprice`) > 0,MAX(`Pricer`.`saleprice`),MAX(`Pricer`.`price`))) AS `Product__highprice`, (`I18n__nameTranslation`.`content`) AS `Product__i18n_nameTranslation`, (`I18n__summaryTranslation`.`content`) AS `Product__i18n_summaryTranslation`, (`I18n__descriptionTranslation`.`content`) AS `Product__i18n_descriptionTranslation`, (`I18n__slugTranslation`.`content`) AS `Product__i18n_slugTranslation`, `Pricer`.`id`, `Pricer`.`product_id`, `Pricer`.`options`, `Pricer`.`optionkey`, `Pricer`.`label`, `Pricer`.`context`, `Pricer`.`type`, `Pricer`.`sku`, `Pricer`.`price`, `Pricer`.`saleprice`, `Pricer`.`weight`, `Pricer`.`shipfee`, `Pricer`.`stock`, `Pricer`.`inventory`, `Pricer`.`sale`, `Pricer`.`shipping`, `Pricer`.`tax`, `Pricer`.`donation`, `Pricer`.`sortorder`, `Pricer`.`params`, `Pricer`.`created`, `Pricer`.`modified` FROM `voordehoefsmit`.`global_products` AS `Product` INNER JOIN `voordehoefsmit`.`global_product_i18ns` AS `I18n__nameTranslation` ON (`Product`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Product' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'dut') INNER JOIN `voordehoefsmit`.`global_product_i18ns` AS `I18n__summaryTranslation` ON (`Product`.`id` = `I18n__summaryTranslation`.`foreign_key` AND `I18n__summaryTranslation`.`model` = 'Product' AND `I18n__summaryTranslation`.`field` = 'summary' AND `I18n__summaryTranslation`.`locale` = 'dut') INNER JOIN `voordehoefsmit`.`global_product_i18ns` AS `I18n__descriptionTranslation` ON (`Product`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'Product' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'dut') INNER JOIN `voordehoefsmit`.`global_product_i18ns` AS `I18n__slugTranslation` ON (`Product`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Product' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'dut') inner JOIN `voordehoefsmit`.`global_prices` AS `Pricer` ON (`Pricer`.`product_id` = `Product`.`id` AND `Pricer`.`product_id` = `Product`.`id` AND `Pricer`.`type` != 'N/A') WHERE `Product`.`published` = 'on' AND `Product`.`id` in (SELECT `CategoriesProduct`.`product_id` FROM `voordehoefsmit`.`nl_categories_products` AS CategoriesProduct LEFT JOIN `voordehoefsmit`.`nl_categories` AS Category ON (`CategoriesProduct`.`category_id` = `Category`.`id`) WHERE category_id = 6) GROUP BY `Pricer`.`product_id` ORDER BY `Product`.`modified` desc LIMIT 36334
3SELECT `Price`.`id`, `Price`.`product_id`, `Price`.`options`, `Price`.`optionkey`, `Price`.`label`, `Price`.`context`, `Price`.`type`, `Price`.`sku`, `Price`.`price`, `Price`.`saleprice`, `Price`.`weight`, `Price`.`shipfee`, `Price`.`stock`, `Price`.`inventory`, `Price`.`sale`, `Price`.`shipping`, `Price`.`tax`, `Price`.`donation`, `Price`.`sortorder`, `Price`.`params`, `Price`.`created`, `Price`.`modified` FROM `voordehoefsmit`.`global_prices` AS `Price` WHERE `Price`.`product_id` IN (22, 23, 21) 771
4SELECT `Image`.`id`, `Image`.`class`, `Image`.`foreign_id`, `Image`.`filename`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`name`, `Image`.`title`, `Image`.`url`, `Image`.`params`, `Image`.`description`, `Image`.`sort`, `Image`.`created`, `Image`.`modified` FROM `voordehoefsmit`.`global_images` AS `Image` WHERE `Image`.`class` = 'Product' AND `Image`.`foreign_id` IN (22, 23, 21) ORDER BY `Image`.`sort` asc 440
5SELECT COUNT(DISTINCT(`Product`.`id`)) AS count FROM `voordehoefsmit`.`global_products` AS `Product` INNER JOIN `voordehoefsmit`.`global_product_i18ns` AS `ProductI18n` ON (`Product`.`id` = `ProductI18n`.`foreign_key` AND `ProductI18n`.`model` = 'Product' AND `ProductI18n`.`locale` = 'dut') inner JOIN `voordehoefsmit`.`global_prices` AS `Pricer` ON (`Pricer`.`product_id` = `Product`.`id` AND `Pricer`.`product_id` = `Product`.`id` AND `Pricer`.`type` != 'N/A') WHERE `Product`.`published` = 'on' AND `Product`.`id` in (SELECT `CategoriesProduct`.`product_id` FROM `voordehoefsmit`.`nl_categories_products` AS CategoriesProduct LEFT JOIN `voordehoefsmit`.`nl_categories` AS Category ON (`CategoriesProduct`.`category_id` = `Category`.`id`) WHERE category_id = 6) GROUP BY `Pricer`.`product_id`332