select * from `ecom_settings` where `id` = '22' limit 1

select * from `ecom_settings` where `id` = '23' limit 1

select * from `ecom_settings` where `key` = 'nieuwe_btw_regels' limit 1

select `waarde`, `key` from `ecom_settings` where `key` in ('mollie_redirect_url', 'mollie_webhook_url')

select * from `ecom_labels`

select * from `ecom_client_labels`

select * from `prdcategorie` where `CATE_SLUG1` = 'cabine' limit 1

select * from `ecom_merken` where `naam1` = 'scania' limit 1

select count(*) as aggregate from `productfeatures` where `idMerken` = '2' and `PRD_actief` = '1' and `productfeatures`.`PRD_SLUG1` != ''

select * from `productfeatures` where `idMerken` = '2' and `PRD_actief` = '1' and `productfeatures`.`PRD_SLUG1` != '' order by `PRD_EXTRANAAM1` asc limit 24 offset 0

select * from `ecom_merken` where `naam1` = 'scania' limit 1

select `productfeatures`.`idProductfeatures` from `productfeatures` inner join `ecom_productcategorie` on `productfeatures`.`idProductfeatures` = `ecom_productcategorie`.`idProductfeatures` where `ecom_productcategorie`.`idPrdcategorie` = '2' and `productfeatures`.`PRD_SLUG1` != '' and `idMerken` = '2'

select distinct `idProductfeatures` from `productfeatures` where `idProductFeatures` in ('3543', '3550', '3551', '4676', '4677', '4678', '4679', '4680', '4681', '4682', '4683', '4684', '4686', '4687', '4914', '4916', '4921', '4923', '4924', '4925', '4927', '4930', '6371', '9489', '9495', '9496', '9497', '9499', '9501', '9502', '9503', '9504', '9506', '10655', '10656', '11004', '11485', '11670', '11780', '13603', '13609', '13612', '13764', '13924', '13940', '13941', '13942', '14050', '14101', '14112', '14119', '14120', '14209', '14236', '14237', '14262', '14274', '14310', '14348', '14353', '14409', '14435', '14502', '14759', '14761', '14777', '14818', '15017', '15098', '15099', '15140', '15247', '15368', '15691', '15692', '15703', '15728', '15782', '15783', '15784', '16006', '16234', '16235', '16236', '16237', '16238', '16239', '16427', '16875', '16876', '16878', '16889', '16890', '17023', '17024', '17037', '17141', '17142', '17839', '18104', '18105', '18210', '18211', '18213', '18561', '18562', '18564', '18747', '18748', '18749', '18751', '18752', '18754', '18755', '18756', '18757', '18898', '18942', '19503', '19504', '19507', '19508', '19525', '19987', '19988', '20080', '20081', '20086', '20135', '20145', '20146', '20147', '20148', '20149', '20168', '20172', '20175', '20176', '20177', '20262', '20327', '20545', '20546', '20581', '20582', '20583', '20584', '20589', '20590', '20591', '20592', '20644', '20645', '20646', '20647', '20661', '20794', '20795', '20907', '20956', '20972', '20987', '21067', '21113', '21175', '21414', '21415', '21416', '21417', '21418', '21542', '21658', '21659', '21662', '21663', '21664', '21708', '21709', '21716', '21722', '21786', '21791', '21978', '21980', '21981', '21982', '22041', '22051', '22137', '22138', '22205', '22234', '22235', '22236', '22253', '22254', '22379', '22380', '22397', '22398', '22399', '22496', '22497', '22500', '22565', '22566', '22567', '22568', '22569', '22583', '22723', '22724', '22777', '22799', '22800', '22828', '22829', '22969', '22970', '22971', '22972', '23076', '23127', '23259', '23261', '23262', '23720', '23842', '23886', '24069', '24179', '24516', '24880', '24884', '24905', '24924', '24938', '24940', '24975', '25359', '25548', '25720', '25758', '25811', '25814', '25817', '25818', '25819', '25825', '25883', '26001', '26074', '26076', '26077', '26078', '26079', '26099', '26101', '26102', '26103', '26104', '26105', '26106', '26107', '26108', '26109', '26110', '26111', '26112', '26113', '26114', '26115', '26116', '26117', '26118', '26119', '26120', '26122', '26137', '26230', '26231', '26232', '26234', '26235', '26236', '26238', '26291', '26317', '26484', '26608', '26609', '26613', '26749', '26750', '26751', '26752', '26753', '26754', '26803', '26852', '26875', '26929', '26930', '26931', '27007', '27054', '27082', '27185', '27186', '27239', '27240', '27276', '27284', '27323', '27407', '27415', '27416', '27417', '27418', '27429', '27492', '27493', '27515', '27677', '27678', '27679', '27680', '27681', '27682', '27767', '27806', '27807', '27808', '27810', '27811', '27812', '27813', '27814', '27825', '27874', '28374', '28377', '28986', '28987', '28988', '29078', '29079', '29084', '29086', '29087', '29104', '29331', '29334', '29335', '29417', '29418', '29419', '29424', '29425', '29624', '29778', '29874', '30359', '30681', '30766', '30793', '30808', '30809', '30810', '30811', '30860', '31158', '31159', '31222', '31297', '31298', '31299', '31300', '31301', '31302', '31315', '31316', '31429', '31604', '31605', '31608', '31609', '31611', '31612', '31613', '31614', '31616', '31617', '31618', '31632', '31633', '31716', '31773', '31838', '31839', '31840', '32090', '32415', '32418', '32442', '32443', '32444', '32445', '32466', '32589', '32801', '32910', '33773', '33774', '33775', '33778', '33862', '33863', '33902', '33947', '33977', '34269', '34285', '34332', '34333', '34334', '34344', '34423', '34508', '34513', '34514', '34515', '34516', '34528', '34529', '34532', '34534', '34535', '34834', '35097', '35222', '35224', '35315', '35396', '35397', '35398', '35402', '35403', '35404', '35405', '35406', '35407', '35408', '35409', '35410', '35411', '35412', '35413', '35414', '35415', '35416', '35417', '35418', '35419', '35420', '35422', '35428', '35429', '35430', '35801', '35802', '36177', '36374', '36375', '36376', '36382', '36493', '36494', '37979', '38634', '38635', '38636', '38637', '38638', '38652', '38714', '38783', '38815', '38816', '38817', '39157', '39173', '39663', '40819', '40822', '40823', '40824', '40825', '40826', '40827', '40928', '40929', '40930', '40960', '41305', '41306', '41307', '41308', '41309', '41355', '41357', '41525', '41672', '41911', '41912', '41913', '41914', '41915', '41916', '41917', '41918', '41919', '41920', '41921', '41922', '42094', '42267', '42268', '42422', '43436', '43437', '43505', '43565', '43759', '43803', '43860', '43861', '43862', '43863', '43864', '43865', '43866', '43867', '43868', '43869', '43899', '43934', '44032', '44033', '44192', '44510', '44511', '44632', '44633', '44821', '44822', '45009', '45010', '45011', '45026', '45032', '45033', '45312', '45645', '45846', '45889', '46199') and `productfeatures`.`PRD_SLUG1` != '' and `idMerken` = '2' order by `PRD_EXTRANAAM1` asc

select count(*) as aggregate from `productfeatures` where `idProductFeatures` in ('3543', '3550', '3551', '4676', '4677', '4678', '4679', '4680', '4681', '4682', '4683', '4684', '4686', '4687', '4914', '4916', '4921', '4923', '4924', '4925', '4927', '4930', '6371', '9489', '9495', '9496', '9497', '9499', '9501', '9502', '9503', '9504', '9506', '10655', '10656', '11004', '11485', '11670', '11780', '13603', '13609', '13612', '13764', '13924', '13940', '13941', '13942', '14050', '14101', '14112', '14119', '14120', '14209', '14236', '14237', '14262', '14274', '14310', '14348', '14353', '14409', '14435', '14502', '14759', '14761', '14777', '14818', '15017', '15098', '15099', '15140', '15247', '15368', '15691', '15692', '15703', '15728', '15782', '15783', '15784', '16006', '16234', '16235', '16236', '16237', '16238', '16239', '16427', '16875', '16876', '16878', '16889', '16890', '17023', '17024', '17037', '17141', '17142', '17839', '18104', '18105', '18210', '18211', '18213', '18561', '18562', '18564', '18747', '18748', '18749', '18751', '18752', '18754', '18755', '18756', '18757', '18898', '18942', '19503', '19504', '19507', '19508', '19525', '19987', '19988', '20080', '20081', '20086', '20135', '20145', '20146', '20147', '20148', '20149', '20168', '20172', '20175', '20176', '20177', '20262', '20327', '20545', '20546', '20581', '20582', '20583', '20584', '20589', '20590', '20591', '20592', '20644', '20645', '20646', '20647', '20661', '20794', '20795', '20907', '20956', '20972', '20987', '21067', '21113', '21175', '21414', '21415', '21416', '21417', '21418', '21542', '21658', '21659', '21662', '21663', '21664', '21708', '21709', '21716', '21722', '21786', '21791', '21978', '21980', '21981', '21982', '22041', '22051', '22137', '22138', '22205', '22234', '22235', '22236', '22253', '22254', '22379', '22380', '22397', '22398', '22399', '22496', '22497', '22500', '22565', '22566', '22567', '22568', '22569', '22583', '22723', '22724', '22777', '22799', '22800', '22828', '22829', '22969', '22970', '22971', '22972', '23076', '23127', '23259', '23261', '23262', '23720', '23842', '23886', '24069', '24179', '24516', '24880', '24884', '24905', '24924', '24938', '24940', '24975', '25359', '25548', '25720', '25758', '25811', '25814', '25817', '25818', '25819', '25825', '25883', '26001', '26074', '26076', '26077', '26078', '26079', '26099', '26101', '26102', '26103', '26104', '26105', '26106', '26107', '26108', '26109', '26110', '26111', '26112', '26113', '26114', '26115', '26116', '26117', '26118', '26119', '26120', '26122', '26137', '26230', '26231', '26232', '26234', '26235', '26236', '26238', '26291', '26317', '26484', '26608', '26609', '26613', '26749', '26750', '26751', '26752', '26753', '26754', '26803', '26852', '26875', '26929', '26930', '26931', '27007', '27054', '27082', '27185', '27186', '27239', '27240', '27276', '27284', '27323', '27407', '27415', '27416', '27417', '27418', '27429', '27492', '27493', '27515', '27677', '27678', '27679', '27680', '27681', '27682', '27767', '27806', '27807', '27808', '27810', '27811', '27812', '27813', '27814', '27825', '27874', '28374', '28377', '28986', '28987', '28988', '29078', '29079', '29084', '29086', '29087', '29104', '29331', '29334', '29335', '29417', '29418', '29419', '29424', '29425', '29624', '29778', '29874', '30359', '30681', '30766', '30793', '30808', '30809', '30810', '30811', '30860', '31158', '31159', '31222', '31297', '31298', '31299', '31300', '31301', '31302', '31315', '31316', '31429', '31604', '31605', '31608', '31609', '31611', '31612', '31613', '31614', '31616', '31617', '31618', '31632', '31633', '31716', '31773', '31838', '31839', '31840', '32090', '32415', '32418', '32442', '32443', '32444', '32445', '32466', '32589', '32801', '32910', '33773', '33774', '33775', '33778', '33862', '33863', '33902', '33947', '33977', '34269', '34285', '34332', '34333', '34334', '34344', '34423', '34508', '34513', '34514', '34515', '34516', '34528', '34529', '34532', '34534', '34535', '34834', '35097', '35222', '35224', '35315', '35396', '35397', '35398', '35402', '35403', '35404', '35405', '35406', '35407', '35408', '35409', '35410', '35411', '35412', '35413', '35414', '35415', '35416', '35417', '35418', '35419', '35420', '35422', '35428', '35429', '35430', '35801', '35802', '36177', '36374', '36375', '36376', '36382', '36493', '36494', '37979', '38634', '38635', '38636', '38637', '38638', '38652', '38714', '38783', '38815', '38816', '38817', '39157', '39173', '39663', '40819', '40822', '40823', '40824', '40825', '40826', '40827', '40928', '40929', '40930', '40960', '41305', '41306', '41307', '41308', '41309', '41355', '41357', '41525', '41672', '41911', '41912', '41913', '41914', '41915', '41916', '41917', '41918', '41919', '41920', '41921', '41922', '42094', '42267', '42268', '42422', '43436', '43437', '43505', '43565', '43759', '43803', '43860', '43861', '43862', '43863', '43864', '43865', '43866', '43867', '43868', '43869', '43899', '43934', '44032', '44033', '44192', '44510', '44511', '44632', '44633', '44821', '44822', '45009', '45010', '45011', '45026', '45032', '45033', '45312', '45645', '45846', '45889', '46199') and `productfeatures`.`PRD_SLUG1` != '' and `idMerken` = '2'

select distinct * from `productfeatures` where `idProductFeatures` in ('3543', '3550', '3551', '4676', '4677', '4678', '4679', '4680', '4681', '4682', '4683', '4684', '4686', '4687', '4914', '4916', '4921', '4923', '4924', '4925', '4927', '4930', '6371', '9489', '9495', '9496', '9497', '9499', '9501', '9502', '9503', '9504', '9506', '10655', '10656', '11004', '11485', '11670', '11780', '13603', '13609', '13612', '13764', '13924', '13940', '13941', '13942', '14050', '14101', '14112', '14119', '14120', '14209', '14236', '14237', '14262', '14274', '14310', '14348', '14353', '14409', '14435', '14502', '14759', '14761', '14777', '14818', '15017', '15098', '15099', '15140', '15247', '15368', '15691', '15692', '15703', '15728', '15782', '15783', '15784', '16006', '16234', '16235', '16236', '16237', '16238', '16239', '16427', '16875', '16876', '16878', '16889', '16890', '17023', '17024', '17037', '17141', '17142', '17839', '18104', '18105', '18210', '18211', '18213', '18561', '18562', '18564', '18747', '18748', '18749', '18751', '18752', '18754', '18755', '18756', '18757', '18898', '18942', '19503', '19504', '19507', '19508', '19525', '19987', '19988', '20080', '20081', '20086', '20135', '20145', '20146', '20147', '20148', '20149', '20168', '20172', '20175', '20176', '20177', '20262', '20327', '20545', '20546', '20581', '20582', '20583', '20584', '20589', '20590', '20591', '20592', '20644', '20645', '20646', '20647', '20661', '20794', '20795', '20907', '20956', '20972', '20987', '21067', '21113', '21175', '21414', '21415', '21416', '21417', '21418', '21542', '21658', '21659', '21662', '21663', '21664', '21708', '21709', '21716', '21722', '21786', '21791', '21978', '21980', '21981', '21982', '22041', '22051', '22137', '22138', '22205', '22234', '22235', '22236', '22253', '22254', '22379', '22380', '22397', '22398', '22399', '22496', '22497', '22500', '22565', '22566', '22567', '22568', '22569', '22583', '22723', '22724', '22777', '22799', '22800', '22828', '22829', '22969', '22970', '22971', '22972', '23076', '23127', '23259', '23261', '23262', '23720', '23842', '23886', '24069', '24179', '24516', '24880', '24884', '24905', '24924', '24938', '24940', '24975', '25359', '25548', '25720', '25758', '25811', '25814', '25817', '25818', '25819', '25825', '25883', '26001', '26074', '26076', '26077', '26078', '26079', '26099', '26101', '26102', '26103', '26104', '26105', '26106', '26107', '26108', '26109', '26110', '26111', '26112', '26113', '26114', '26115', '26116', '26117', '26118', '26119', '26120', '26122', '26137', '26230', '26231', '26232', '26234', '26235', '26236', '26238', '26291', '26317', '26484', '26608', '26609', '26613', '26749', '26750', '26751', '26752', '26753', '26754', '26803', '26852', '26875', '26929', '26930', '26931', '27007', '27054', '27082', '27185', '27186', '27239', '27240', '27276', '27284', '27323', '27407', '27415', '27416', '27417', '27418', '27429', '27492', '27493', '27515', '27677', '27678', '27679', '27680', '27681', '27682', '27767', '27806', '27807', '27808', '27810', '27811', '27812', '27813', '27814', '27825', '27874', '28374', '28377', '28986', '28987', '28988', '29078', '29079', '29084', '29086', '29087', '29104', '29331', '29334', '29335', '29417', '29418', '29419', '29424', '29425', '29624', '29778', '29874', '30359', '30681', '30766', '30793', '30808', '30809', '30810', '30811', '30860', '31158', '31159', '31222', '31297', '31298', '31299', '31300', '31301', '31302', '31315', '31316', '31429', '31604', '31605', '31608', '31609', '31611', '31612', '31613', '31614', '31616', '31617', '31618', '31632', '31633', '31716', '31773', '31838', '31839', '31840', '32090', '32415', '32418', '32442', '32443', '32444', '32445', '32466', '32589', '32801', '32910', '33773', '33774', '33775', '33778', '33862', '33863', '33902', '33947', '33977', '34269', '34285', '34332', '34333', '34334', '34344', '34423', '34508', '34513', '34514', '34515', '34516', '34528', '34529', '34532', '34534', '34535', '34834', '35097', '35222', '35224', '35315', '35396', '35397', '35398', '35402', '35403', '35404', '35405', '35406', '35407', '35408', '35409', '35410', '35411', '35412', '35413', '35414', '35415', '35416', '35417', '35418', '35419', '35420', '35422', '35428', '35429', '35430', '35801', '35802', '36177', '36374', '36375', '36376', '36382', '36493', '36494', '37979', '38634', '38635', '38636', '38637', '38638', '38652', '38714', '38783', '38815', '38816', '38817', '39157', '39173', '39663', '40819', '40822', '40823', '40824', '40825', '40826', '40827', '40928', '40929', '40930', '40960', '41305', '41306', '41307', '41308', '41309', '41355', '41357', '41525', '41672', '41911', '41912', '41913', '41914', '41915', '41916', '41917', '41918', '41919', '41920', '41921', '41922', '42094', '42267', '42268', '42422', '43436', '43437', '43505', '43565', '43759', '43803', '43860', '43861', '43862', '43863', '43864', '43865', '43866', '43867', '43868', '43869', '43899', '43934', '44032', '44033', '44192', '44510', '44511', '44632', '44633', '44821', '44822', '45009', '45010', '45011', '45026', '45032', '45033', '45312', '45645', '45846', '45889', '46199') and `productfeatures`.`PRD_SLUG1` != '' and `idMerken` = '2' order by `PRD_EXTRANAAM1` asc limit 24 offset 0

select `idPrdcategorie` from `prdcategorie` where `idBron` = '2'

select `idPrdcategorie` from `ecom_productcategorie` where `idProductfeatures` in ('27493', '26803', '26238', '45312', '34334', '27492', '41308', '41309', '41307', '41306', '41305', '38815', '38816', '23127', '26236', '30793', '23842', '31302', '20086', '19987', '19988', '43934', '45889', '31429', '38817', '38652', '22799', '22800', '23720', '29874', '33862', '33863', '32415', '32418', '25359', '24940', '30359', '33773', '41672', '23076', '18104', '24516', '29104', '29087', '29086', '29079', '29084', '29078', '17839', '14236', '27007', '28987', '44822', '44821', '21175', '31298', '22972', '44510', '25883', '34508', '26875', '21542', '14777', '41355', '40960', '18564', '17142', '26291', '33947', '31297', '33775', '22500', '18942', '14759', '17141', '10656', '14502', '43565', '15140', '38714', '27825', '28986', '26317', '30766', '26074', '27810', '26076', '27811', '26077', '27813', '26079', '27812', '26078', '27814', '10655', '24069', '22971', '22970', '22969', '28988', '32801', '29778', '15728', '3543', '21716', '20135', '3551', '14237', '3550', '16427', '18105', '14262', '11004', '24938', '32466', '22496', '25758', '27807', '27808', '26613', '30860', '14310', '21791', '27806', '20907', '14209', '14818', '24884', '11780', '37979', '34333', '34332', '34528', '32589', '29335', '27240', '29331', '32443', '32442', '29334', '27239', '34516', '14761', '20661', '41357', '13603', '11485', '16876', '16878', '16875', '18898', '22138', '14101', '22137', '27874', '27407', '42267', '29419', '29425', '33977', '29417', '29418', '29424', '18751', '18747', '18749', '18748', '18752', '18754', '18757', '18756', '18755', '21663', '21662', '21664', '27418', '27323', '27415', '27416', '27417', '6371', '31838', '31840', '31839', '21658', '21659', '38783', '31159', '31158', '22829', '22828', '46199', '15692', '20987', '23259', '22379', '22253', '22254', '22724', '22583', '22380', '13924', '22723', '15691', '24179', '23262', '23261', '22205', '22051', '20262', '14112', '22041', '24880', '21722', '15017', '33902', '36493', '36494', '26754', '26609', '26608', '26749', '26751', '26750', '26752', '24924', '26753', '40930', '40929', '40928', '15783', '15784', '43864', '43866', '43869', '43862', '43863', '43867', '43868', '43860', '43861', '43865', '27082', '20646', '20644', '14409', '20645', '14435', '20647', '4676', '4679', '4677', '4678', '4680', '4681', '4682', '4683', '4684', '4686', '4687', '13940', '20795', '14348', '20794', '14353', '20545', '15247', '20546', '20168', '44511', '18562', '18211', '18561', '18210', '44033', '44032', '20583', '20581', '19507', '20582', '19508', '20584', '20590', '20589', '19503', '20591', '19504', '20592', '26929', '26930', '26931', '22399', '22397', '22398', '26118', '26122', '26120', '26107', '26119', '26106', '26117', '26108', '26115', '26105', '26116', '27429', '26112', '26104', '26114', '26102', '26113', '26101', '26111', '26103', '26109', '26099', '26110', '28377', '4914', '4916', '40826', '43899', '40827', '40819', '40822', '40824', '40825', '40823', '13941', '4923', '4924', '4925', '4921', '4927', '4930', '13942', '17023', '15098', '17024', '15099', '20080', '20081', '15703', '15782', '27681', '27680', '27682', '27678', '27677', '27679', '21978', '21982', '21980', '21981', '18213', '42094', '24905', '45026', '43436', '43437', '26230', '27185', '26231', '27186', '26232', '27276', '26234', '26235', '45033', '35397', '35398', '35396', '39157', '42422', '45032', '42268', '17037', '30810', '30809', '35429', '35409', '35404', '35415', '35412', '35406', '35418', '35420', '35422', '35430', '35410', '35405', '35416', '35413', '35407', '35419', '30811', '30808', '35428', '35408', '35402', '35414', '35411', '35403', '35417', '45645', '41915', '41922', '41916', '41920', '41912', '41921', '41913', '41918', '41914', '41919', '41911', '41917', '36374', '36376', '36375', '15368', '34534', '34535', '34532', '14120', '14119', '20956', '20972', '31773', '21786', '16234', '16237', '16239', '16235', '16236', '16238', '34514', '34515', '34513', '26484', '22497', '32444', '26137', '31299', '35097', '35802', '35801', '25720', '21708', '25817', '25818', '25819', '21709', '27284', '25811', '25814', '25825', '34344', '32445', '33774', '34529', '38638', '38636', '38637', '38634', '38635', '21417', '21418', '21415', '21416', '21414', '39663', '13764', '27054', '16006', '9495', '9489', '44192', '35315', '9497', '14274', '9501', '9502', '9503', '9504', '9506', '9499', '28374', '31716', '45010', '45011', '43759', '31633', '31632', '43803', '34269', '31608', '32910', '31605', '31604', '31612', '31616', '31618', '31617', '31614', '43505', '31613', '31611', '31609', '45009', '22777', '11670', '19525', '23886', '20172', '32090', '26852', '24975', '20177', '20176', '20175', '36177', '33778', '9496', '41525', '27767', '35224', '29624', '45846', '44633', '44632', '22565', '22566', '14050', '13612', '34423', '31301', '20327', '31300', '13609', '22567', '22568', '22569', '26001', '36382', '34285', '35222', '39173', '34834', '16890', '16889', '21113', '31316', '31315', '27515', '30681', '20146', '22236', '20145', '21067', '20149', '20147', '22234', '20148', '22235', '25548', '31222') and `idPrdcategorie` in ('14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31') group by `idPrdcategorie`

select * from `prdcategorie` where `idPrdcategorie` in ('14', '15', '16', '17', '20', '21', '22', '23', '25', '26', '28', '29', '30', '31') and `BRON_LEVEL` = '1'

select `idMerken` from `productfeatures` where `idProductfeatures` in ('27493', '26803', '26238', '45312', '34334', '27492', '41308', '41309', '41307', '41306', '41305', '38815', '38816', '23127', '26236', '30793', '23842', '31302', '20086', '19987', '19988', '43934', '45889', '31429', '38817', '38652', '22799', '22800', '23720', '29874', '33862', '33863', '32415', '32418', '25359', '24940', '30359', '33773', '41672', '23076', '18104', '24516', '29104', '29087', '29086', '29079', '29084', '29078', '17839', '14236', '27007', '28987', '44822', '44821', '21175', '31298', '22972', '44510', '25883', '34508', '26875', '21542', '14777', '41355', '40960', '18564', '17142', '26291', '33947', '31297', '33775', '22500', '18942', '14759', '17141', '10656', '14502', '43565', '15140', '38714', '27825', '28986', '26317', '30766', '26074', '27810', '26076', '27811', '26077', '27813', '26079', '27812', '26078', '27814', '10655', '24069', '22971', '22970', '22969', '28988', '32801', '29778', '15728', '3543', '21716', '20135', '3551', '14237', '3550', '16427', '18105', '14262', '11004', '24938', '32466', '22496', '25758', '27807', '27808', '26613', '30860', '14310', '21791', '27806', '20907', '14209', '14818', '24884', '11780', '37979', '34333', '34332', '34528', '32589', '29335', '27240', '29331', '32443', '32442', '29334', '27239', '34516', '14761', '20661', '41357', '13603', '11485', '16876', '16878', '16875', '18898', '22138', '14101', '22137', '27874', '27407', '42267', '29419', '29425', '33977', '29417', '29418', '29424', '18751', '18747', '18749', '18748', '18752', '18754', '18757', '18756', '18755', '21663', '21662', '21664', '27418', '27323', '27415', '27416', '27417', '6371', '31838', '31840', '31839', '21658', '21659', '38783', '31159', '31158', '22829', '22828', '46199', '15692', '20987', '23259', '22379', '22253', '22254', '22724', '22583', '22380', '13924', '22723', '15691', '24179', '23262', '23261', '22205', '22051', '20262', '14112', '22041', '24880', '21722', '15017', '33902', '36493', '36494', '26754', '26609', '26608', '26749', '26751', '26750', '26752', '24924', '26753', '40930', '40929', '40928', '15783', '15784', '43864', '43866', '43869', '43862', '43863', '43867', '43868', '43860', '43861', '43865', '27082', '20646', '20644', '14409', '20645', '14435', '20647', '4676', '4679', '4677', '4678', '4680', '4681', '4682', '4683', '4684', '4686', '4687', '13940', '20795', '14348', '20794', '14353', '20545', '15247', '20546', '20168', '44511', '18562', '18211', '18561', '18210', '44033', '44032', '20583', '20581', '19507', '20582', '19508', '20584', '20590', '20589', '19503', '20591', '19504', '20592', '26929', '26930', '26931', '22399', '22397', '22398', '26118', '26122', '26120', '26107', '26119', '26106', '26117', '26108', '26115', '26105', '26116', '27429', '26112', '26104', '26114', '26102', '26113', '26101', '26111', '26103', '26109', '26099', '26110', '28377', '4914', '4916', '40826', '43899', '40827', '40819', '40822', '40824', '40825', '40823', '13941', '4923', '4924', '4925', '4921', '4927', '4930', '13942', '17023', '15098', '17024', '15099', '20080', '20081', '15703', '15782', '27681', '27680', '27682', '27678', '27677', '27679', '21978', '21982', '21980', '21981', '18213', '42094', '24905', '45026', '43436', '43437', '26230', '27185', '26231', '27186', '26232', '27276', '26234', '26235', '45033', '35397', '35398', '35396', '39157', '42422', '45032', '42268', '17037', '30810', '30809', '35429', '35409', '35404', '35415', '35412', '35406', '35418', '35420', '35422', '35430', '35410', '35405', '35416', '35413', '35407', '35419', '30811', '30808', '35428', '35408', '35402', '35414', '35411', '35403', '35417', '45645', '41915', '41922', '41916', '41920', '41912', '41921', '41913', '41918', '41914', '41919', '41911', '41917', '36374', '36376', '36375', '15368', '34534', '34535', '34532', '14120', '14119', '20956', '20972', '31773', '21786', '16234', '16237', '16239', '16235', '16236', '16238', '34514', '34515', '34513', '26484', '22497', '32444', '26137', '31299', '35097', '35802', '35801', '25720', '21708', '25817', '25818', '25819', '21709', '27284', '25811', '25814', '25825', '34344', '32445', '33774', '34529', '38638', '38636', '38637', '38634', '38635', '21417', '21418', '21415', '21416', '21414', '39663', '13764', '27054', '16006', '9495', '9489', '44192', '35315', '9497', '14274', '9501', '9502', '9503', '9504', '9506', '9499', '28374', '31716', '45010', '45011', '43759', '31633', '31632', '43803', '34269', '31608', '32910', '31605', '31604', '31612', '31616', '31618', '31617', '31614', '43505', '31613', '31611', '31609', '45009', '22777', '11670', '19525', '23886', '20172', '32090', '26852', '24975', '20177', '20176', '20175', '36177', '33778', '9496', '41525', '27767', '35224', '29624', '45846', '44633', '44632', '22565', '22566', '14050', '13612', '34423', '31301', '20327', '31300', '13609', '22567', '22568', '22569', '26001', '36382', '34285', '35222', '39173', '34834', '16890', '16889', '21113', '31316', '31315', '27515', '30681', '20146', '22236', '20145', '21067', '20149', '20147', '22234', '20148', '22235', '25548', '31222') and `PRD_ACTIEF` = '1' and `productfeatures`.`PRD_SLUG1` != '' group by `idMerken` order by `PRD_EXTRANAAM1` asc

select `id`, `naam1` from `ecom_merken` where `id` in ('2') order by `naam1` asc

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '27493' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '27493' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '27493' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '27493'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '27493' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '27493'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '27493'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '27493' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '27493' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '27493'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '26803' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '26803' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '26803' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '26803'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '26803' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '26803'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '26803'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '26803' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '26803' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '26803'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '26238' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '26238' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '26238' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '26238'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '26238' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '26238'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '26238'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '26238' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '26238' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '26238'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '45312' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '45312' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45312' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '45312'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45312' order by `PRIS_AANTAL` asc

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '45312'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '45312'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45312' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45312' order by `PRIS_AANTAL` asc

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '45312'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '34334' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '34334' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '34334' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '34334'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '34334' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '34334'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '34334'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '34334' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '34334' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '34334'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '27492' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '27492' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '27492' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '27492'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '27492' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '27492'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '27492'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '27492' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '27492' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '27492'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '41308' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '41308' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41308' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '41308'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41308' order by `PRIS_AANTAL` asc

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '41308'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '41308'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41308' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41308' order by `PRIS_AANTAL` asc

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '41308'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '41309' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '41309' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41309' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '41309'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41309' order by `PRIS_AANTAL` asc

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '41309'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '41309'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41309' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41309' order by `PRIS_AANTAL` asc

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '41309'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '41307' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '41307' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41307' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '41307'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41307' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '41307'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '41307'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41307' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41307' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '41307'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '41306' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '41306' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41306' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '41306'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41306' order by `PRIS_AANTAL` asc

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '41306'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '41306'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41306' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41306' order by `PRIS_AANTAL` asc

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '41306'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '41305' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '41305' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41305' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '41305'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41305' order by `PRIS_AANTAL` asc

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '41305'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '41305'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41305' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41305' order by `PRIS_AANTAL` asc

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '41305'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '38815' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '38815' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '38815' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '38815'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '38815' order by `PRIS_AANTAL` asc

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '38815'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '38815'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '38815' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '38815' order by `PRIS_AANTAL` asc

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '38815'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '38816' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '38816' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '38816' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '38816'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '38816' order by `PRIS_AANTAL` asc

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '38816'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '38816'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '38816' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '38816' order by `PRIS_AANTAL` asc

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '38816'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '23127' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '23127' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '23127' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '23127'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '23127' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '23127'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '23127'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '23127' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '23127' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '26236' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '26236' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '26236' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '26236'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '26236' order by `PRIS_AANTAL` asc

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '26236'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '26236'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '26236' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '26236' order by `PRIS_AANTAL` asc

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '26236'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '30793' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '30793' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '30793' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '30793'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '30793' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '30793'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '30793'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '30793' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '30793' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '30793'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '23842' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '23842' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '23842' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '23842'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '23842' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '23842'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '23842'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '23842' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '23842' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '23842'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '31302' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '31302' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '31302' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '31302'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '31302' order by `PRIS_AANTAL` asc

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '31302'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '31302'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '31302' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '31302' order by `PRIS_AANTAL` asc

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '31302'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '20086' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '20086' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '20086' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '20086'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '20086' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '20086'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '20086'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '20086' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '20086' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '20086'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '19987' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '19987' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '19987' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '19987'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '19987' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '19987'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '19987'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '19987' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '19987' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '19987'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '19988' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '19988' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '19988' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '19988'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '19988' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '19988'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '19988'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '19988' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '19988' order by `PRIS_AANTAL` asc

select * from `ecom_settings` where `key` = 'korting'

select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '19988'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '43934' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '43934' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '43934' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '43934'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '43934' order by `PRIS_AANTAL` asc

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '43934'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '43934'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '43934' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '43934' order by `PRIS_AANTAL` asc

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '43934'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '45889' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '45889' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45889' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '45889'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45889' order by `PRIS_AANTAL` asc

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '45889'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '45889'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45889' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45889' order by `PRIS_AANTAL` asc

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '45889'

select * from `ecom_settings` where `key` = 'korting' limit 1

select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '31429' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `product` where `product`.`idProduct` = '31429' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '31429' order by `PRIS_AANTAL` asc

select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '31429'

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '31429' order by `PRIS_AANTAL` asc

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '31429'

select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '31429'

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '31429' order by `PRIS_AANTAL` asc

select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '31429' order by `PRIS_AANTAL` asc

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1

select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '31429'

select * from `ecom_winkels` limit 1

select `pagenamelang1`, `slug1`, `id` from `pages` where `status` = '15' and `pagevisibility` = '1' order by `pageorder` asc limit 1

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where exists ( select productfeatures.idProductfeatures  from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' and `idBron` = '0'

select `id`, `naam1` from `ecom_merken` where exists ( select productfeatures.idProductfeatures  from `productfeatures`  WHERE `ecom_merken`.`id` = `productfeatures`.`idMerken` and `productfeatures`.PRD_ACTIEF = 1 ) order by `naam1` asc

select `pagenamelang1`, `slug1`, `id` from `pages` where `idMenu` = '3' and `pagevisibility` = '1' order by `pageorder` asc limit 1

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '1' and exists ( select productfeatures.idProductfeatures  from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('13') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('209') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('920', '921') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '13' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('209') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('920', '921') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '2' and exists ( select productfeatures.idProductfeatures  from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('100', '121', '122', '127', '128', '129', '130', '131', '139', '145', '146', '147', '148', '149', '154', '155', '157', '159', '160', '161', '162', '166', '171', '179', '180', '181', '182', '183', '185', '188', '189', '191', '205', '206', '208', '210', '216', '217', '229', '230', '232', '233', '234', '235', '236', '247', '248', '251', '252', '254', '255', '264', '265', '266', '267', '269', '270', '275', '276', '284', '286', '287', '289', '298', '299', '300', '304', '311', '313', '314', '317', '318') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('364', '445', '446', '447', '448', '449', '450', '471', '472', '473', '474', '475', '476', '477', '479', '480', '481', '482', '483', '484', '485', '486', '487', '488', '489', '490', '491', '492', '493', '494', '495', '496', '497', '498', '499', '500', '501', '502', '503', '504', '505', '506', '507', '508', '509', '510', '511', '512', '515', '516', '517', '518', '521', '522', '523', '524', '525', '526', '527', '528', '529', '530', '531', '532', '533', '534', '535', '536', '537', '538', '539', '540', '541', '542', '543', '544', '545', '546', '547', '548', '549', '550', '551', '552', '595', '596', '597', '598', '599', '600', '601', '602', '603', '621', '622', '623', '624', '625', '626', '627', '628', '629', '630', '631', '632', '633', '634', '635', '636', '637', '638', '639', '640', '641', '642', '654', '655', '656', '657', '658', '659', '660', '661', '662', '663', '664', '665', '666', '667', '671', '672', '673', '674', '675', '676', '677', '678', '686', '687', '688', '689', '690', '691', '692', '693', '694', '695', '696', '697', '698', '699', '700', '701', '702', '703', '704', '705', '706', '707', '708', '709', '710', '711', '712', '713', '714', '715', '716', '717', '718', '719', '724', '725', '726', '727', '728', '750', '751', '752', '753', '754', '755', '781', '782', '783', '784', '785', '786', '787', '788', '789', '790', '791', '792', '793', '794', '795', '796', '797', '798', '799', '800', '801', '803', '804', '805', '806', '807', '808', '809', '810', '817', '818', '819', '820', '821', '822', '823', '824', '825', '826', '827', '828', '829', '830', '831', '832', '833', '834', '835', '836', '837', '838', '839', '840', '841', '842', '844', '845', '846', '847', '848', '849', '850', '851', '852', '853', '904', '905', '906', '907', '908', '909', '910', '911', '912', '913', '915', '916', '917', '918', '919', '922', '923', '924', '925', '926', '927', '928', '929', '930', '959', '960', '961', '962', '964', '965', '966', '967', '968', '969', '970', '971', '972', '973', '974', '975', '976', '977', '978', '979', '980', '981', '982', '983', '984', '985', '986', '987', '988', '989', '990', '991', '992', '993', '994', '995', '996', '997', '998', '999', '1036', '1037', '1038', '1039', '1040', '1041', '1042', '1043', '1044', '1045', '1046', '1047', '1050', '1051', '1052', '1053', '1054', '1055', '1056', '1057', '1058', '1059', '1060', '1061', '1062', '1063', '1064', '1065', '1066', '1067', '1068', '1069', '1070', '1071', '1072', '1073', '1074', '1075', '1076', '1077', '1078', '1079', '1080', '1081', '1082', '1115', '1116', '1117', '1118', '1119', '1120', '1121', '1122', '1123', '1124', '1125', '1128', '1129', '1130', '1131', '1132', '1133', '1134', '1135', '1136', '1137', '1138', '1139', '1140', '1141', '1142', '1143', '1144', '1149', '1150', '1151', '1152', '1153', '1154', '1155', '1156', '1157', '1158', '1159', '1160', '1161', '1162', '1207', '1208', '1209', '1210', '1211', '1212', '1213', '1214', '1215', '1216', '1217', '1218', '1219', '1220', '1221', '1222', '1223', '1224', '1227', '1228', '1229', '1230', '1258', '1259', '1260', '1261', '1262', '1263', '1264', '1265', '1266', '1267', '1268', '1289', '1290', '1291', '1292', '1293', '1294', '1295', '1304', '1305', '1306', '1307', '1308', '1309', '1310', '1311', '1312', '1319', '1337', '1338', '1339', '1340', '1341', '1342', '1343', '1344', '1345', '1346', '1347', '1348', '1349', '1350', '1351', '1352', '1353', '1354', '1355', '1356', '1357', '1358', '1378', '1379', '1380', '1381', '1382', '1383', '1384', '1385', '1386', '1387', '1388', '1389', '1390', '1391', '1416', '1417', '1418', '1419', '1420', '1421', '1422', '1423', '1425', '1426', '1427', '1428', '1429', '1430', '1431', '1432', '1437', '1438', '1439', '1440', '1441') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '3' and exists ( select productfeatures.idProductfeatures  from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('32', '33', '34', '35', '36', '37', '38', '39') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('90', '95', '96', '97', '98', '133', '138', '140', '141', '165', '172', '173', '198', '204', '222', '228', '238', '242', '246', '260', '271', '279', '283', '301', '307', '310', '312') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('344', '345', '355', '356', '357', '358', '359', '360', '361', '557', '558', '593', '594', '604', '605', '606', '607', '608', '609', '610', '611', '612', '613', '722', '723', '756', '757', '758', '759', '760', '761', '762', '763', '764', '765', '880', '881', '901', '902', '903', '1014', '1015', '1035', '1084', '1085', '1097', '1098', '1111', '1112', '1113', '1114', '1193', '1194', '1231', '1232', '1233', '1234', '1235', '1236', '1237', '1238', '1239', '1273', '1274', '1287', '1288', '1359', '1360', '1361', '1362', '1363', '1397', '1398', '1414', '1415', '1424') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '4' and exists ( select productfeatures.idProductfeatures  from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('40', '41', '42', '43') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('99', '142', '174', '178', '184', '187', '192', '194', '195', '196', '203', '207', '211', '212', '213', '214', '215', '231', '239', '268', '288', '315') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('362', '363', '614', '615', '766', '767', '772', '773', '774', '775', '776', '777', '778', '779', '780', '802', '816', '854', '855', '856', '857', '858', '859', '860', '861', '862', '863', '864', '867', '868', '869', '870', '871', '872', '873', '874', '875', '876', '877', '878', '899', '900', '914', '931', '932', '933', '934', '935', '936', '937', '938', '939', '940', '941', '942', '943', '944', '945', '946', '947', '948', '949', '951', '952', '953', '954', '955', '956', '957', '958', '1048', '1049', '1086', '1087', '1088', '1225', '1226', '1313', '1314', '1315', '1316', '1317', '1318', '1433', '1434') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '40' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('268', '231', '207', '184', '315', '288', '203', '174') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('766', '767', '802', '899', '900', '914', '1048', '1049', '1225', '1226', '1313', '1314', '1315', '1316', '1317', '1318', '1433', '1434') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '41' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('187', '239') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('816', '1086', '1087', '1088') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '42' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('192', '178', '195', '194', '196', '211', '212', '213', '214', '215') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('772', '773', '774', '775', '776', '777', '778', '779', '780', '854', '855', '856', '857', '858', '859', '860', '861', '862', '863', '864', '867', '868', '869', '870', '871', '872', '873', '874', '875', '876', '877', '878', '931', '932', '933', '934', '935', '936', '937', '938', '939', '940', '941', '942', '943', '944', '945', '946', '947', '948', '949', '951', '952', '953', '954', '955', '956', '957', '958') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '43' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('142', '99') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('362', '363', '614', '615') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '6' and exists ( select productfeatures.idProductfeatures  from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('45') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('273') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('1246', '1247', '1249', '1250', '1251') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '45' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('273') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('1246', '1247', '1249', '1250', '1251') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '7' and exists ( select productfeatures.idProductfeatures  from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('46', '48', '49', '50', '51', '52') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('88', '124', '126', '150', '151', '152', '158', '219', '227', '240', '272', '303', '319', '320', '321') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('329', '330', '331', '332', '333', '334', '335', '336', '337', '338', '339', '340', '341', '454', '455', '456', '457', '458', '464', '465', '466', '467', '468', '469', '470', '643', '644', '645', '646', '647', '648', '649', '650', '651', '652', '679', '680', '681', '682', '683', '684', '685', '1003', '1004', '1005', '1006', '1007', '1008', '1009', '1010', '1034', '1089', '1090', '1091', '1092', '1093', '1094', '1240', '1241', '1242', '1243', '1244', '1245', '1372', '1373', '1374', '1375', '1376', '1377', '1442', '1443', '1444', '1445', '1446', '1447', '1448', '1449', '1450', '1451', '1452', '1453', '1454', '1455', '1456', '1457', '1458', '1459', '1460', '1461', '1462', '1463', '1465', '1466', '1467', '1468', '1469', '1470', '1471', '1472') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '8' and exists ( select productfeatures.idProductfeatures  from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('53', '54') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('87', '89', '119', '120', '125', '153', '163', '197', '220', '249', '277', '278', '305', '306') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('323', '324', '327', '342', '343', '437', '439', '440', '441', '442', '443', '444', '459', '460', '461', '462', '463', '653', '720', '879', '1011', '1012', '1126', '1269', '1270', '1271', '1272', '1392', '1393', '1394', '1395', '1396') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '53' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('87', '153', '119') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('323', '324', '327', '437', '653') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '54' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('277', '125', '89', '163', '306', '249', '278', '305', '220', '120', '197') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('342', '343', '439', '440', '441', '442', '443', '444', '459', '460', '461', '462', '463', '720', '879', '1011', '1012', '1126', '1269', '1270', '1271', '1272', '1392', '1393', '1394', '1395', '1396') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '9' and exists ( select productfeatures.idProductfeatures  from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('55', '57') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('102', '103', '105', '106', '107') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('370', '371', '372', '373', '374', '376', '377', '378', '379') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '55' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('103', '102') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('370', '371', '372', '373', '374') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '57' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('106', '107', '105') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('376', '377', '378', '379') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '10' and exists ( select productfeatures.idProductfeatures  from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('58', '59', '60', '61', '62') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('114', '115', '116', '117', '118', '156', '274', '285', '322') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('401', '402', '403', '404', '405', '406', '407', '408', '409', '410', '411', '412', '413', '414', '415', '416', '417', '418', '419', '420', '421', '422', '423', '424', '425', '426', '427', '428', '429', '430', '431', '432', '433', '434', '435', '436', '668', '669', '670', '1255', '1256', '1257', '1296', '1297', '1298', '1299', '1300', '1301', '1302', '1303', '1473', '1474') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '58' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('285') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('1296', '1297', '1298', '1299', '1300', '1301', '1302', '1303') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '59' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('274') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('1255', '1256', '1257') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '60' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('115', '322', '114', '118', '116') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('401', '402', '403', '404', '405', '406', '407', '408', '409', '410', '411', '412', '413', '414', '415', '416', '417', '418', '419', '420', '421', '422', '423', '424', '425', '426', '427', '432', '433', '434', '435', '436', '1473', '1474') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '61' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('117') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('428', '429', '430', '431') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '62' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('156') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('668', '669', '670') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '11' and exists ( select productfeatures.idProductfeatures  from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('63', '64') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('132', '164', '221', '241', '253', '256', '259') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('553', '554', '555', '556', '721', '1013', '1095', '1096', '1145', '1146', '1147', '1148', '1163', '1164', '1165', '1166', '1167', '1168', '1169', '1170', '1171', '1184', '1185', '1186', '1187', '1188', '1189', '1190', '1191', '1192') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '63' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('164', '256') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('721', '1163', '1164', '1165', '1166', '1167', '1168', '1169', '1170', '1171') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '64' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('221', '259', '253', '132', '241') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('553', '554', '555', '556', '1013', '1095', '1096', '1145', '1146', '1147', '1148', '1184', '1185', '1186', '1187', '1188', '1189', '1190', '1191', '1192') order by `CATE_VOLGORDE` asc

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '12' and exists ( select productfeatures.idProductfeatures  from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('65', '66', '67', '68', '69', '70', '71', '72', '74', '73', '75', '77', '76', '78', '79', '80', '81', '83', '82', '84', '85', '86') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('91', '92', '93', '94', '101', '108', '109', '110', '111', '112', '113', '123', '134', '135', '136', '137', '143', '144', '167', '168', '169', '170', '175', '176', '177', '190', '199', '200', '201', '202', '218', '223', '224', '225', '226', '243', '244', '245', '257', '258', '261', '262', '263', '280', '281', '282', '290', '291', '292', '293', '294', '295', '296', '297', '302', '308', '309', '316') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('346', '347', '348', '349', '350', '351', '352', '353', '354', '365', '366', '367', '368', '380', '381', '382', '383', '384', '385', '386', '387', '388', '389', '390', '391', '392', '393', '394', '395', '396', '397', '398', '399', '400', '451', '452', '453', '559', '560', '561', '562', '563', '564', '566', '567', '568', '569', '570', '571', '572', '573', '574', '575', '576', '577', '578', '579', '580', '581', '582', '583', '584', '585', '586', '587', '588', '589', '590', '591', '592', '616', '617', '618', '619', '620', '729', '730', '731', '732', '733', '734', '735', '736', '737', '738', '739', '740', '741', '742', '743', '744', '745', '746', '747', '748', '749', '768', '769', '770', '771', '843', '882', '883', '884', '885', '886', '887', '888', '889', '890', '891', '892', '893', '894', '895', '896', '897', '898', '1000', '1001', '1002', '1016', '1017', '1018', '1019', '1020', '1021', '1022', '1023', '1024', '1025', '1026', '1027', '1028', '1029', '1030', '1031', '1032', '1033', '1099', '1100', '1101', '1102', '1103', '1104', '1105', '1106', '1107', '1108', '1109', '1110', '1173', '1174', '1175', '1176', '1177', '1178', '1179', '1180', '1181', '1182', '1183', '1195', '1196', '1197', '1198', '1199', '1200', '1201', '1202', '1203', '1204', '1205', '1206', '1275', '1276', '1277', '1278', '1279', '1280', '1281', '1282', '1283', '1284', '1285', '1286', '1320', '1321', '1322', '1323', '1324', '1325', '1326', '1327', '1328', '1329', '1330', '1331', '1332', '1333', '1334', '1335', '1336', '1364', '1365', '1366', '1367', '1368', '1369', '1370', '1371', '1399', '1400', '1401', '1402', '1403', '1404', '1405', '1406', '1407', '1408', '1409', '1410', '1411', '1412', '1413', '1435', '1436') order by `CATE_VOLGORDE` asc

select * from `pages` where `id` = '1' limit 1

select * from `ecom_winkels` limit 1

select `pagenamelang1`, `slug1`, `id` from `pages` where `idMenu` = '1' and `pagevisibility` = '1' order by `pageorder` asc

select `pagenamelang1`, `slug1`, `id` from `pages` where `idMenu` = '2' and `pagevisibility` = '1' order by `pageorder` asc

select `pagenamelang1`, `slug1`, `id`, `pagetextlang1` from `pages` where `idMenu` = '5' and `pagevisibility` = '1' limit 1