select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie`, `idBron` from `prdcategorie` where `CATE_SLUG1` = 'veiligheidskits-sloten' and `CATE_CATALOOG_P4C` = '1' limit 1

select count(*) as aggregate from `productfeatures` inner join `ecom_productcategorie` on `productfeatures`.`idProductfeatures` = `ecom_productcategorie`.`idProductfeatures` inner join `ecom_productfeatures_shops` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_shops`.`idProductfeatures` where `ecom_productcategorie`.`idPrdcategorie` = '201' and `PRD_APART_BESTELBAAR` = '1' and `PRD_CATALOOG_P4C` = '1' and `ecom_productfeatures_shops`.`idShop` = '1' and `productfeatures`.`PRD_ACTIEF` = '1'

select `productfeatures`.*, `ecom_productcategorie`.`idPrdcategorie` as `pivot_idPrdcategorie`, `ecom_productcategorie`.`idProductfeatures` as `pivot_idProductfeatures` from `productfeatures` inner join `ecom_productcategorie` on `productfeatures`.`idProductfeatures` = `ecom_productcategorie`.`idProductfeatures` inner join `ecom_productfeatures_shops` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_shops`.`idProductfeatures` where `ecom_productcategorie`.`idPrdcategorie` = '201' and `PRD_APART_BESTELBAAR` = '1' and `PRD_CATALOOG_P4C` = '1' and `ecom_productfeatures_shops`.`idShop` = '1' and `productfeatures`.`PRD_ACTIEF` = '1' order by `PRD_VOLGORDE` asc limit 12 offset 0

select * from `prdcategorie` where `prdcategorie`.`idPrdcategorie` = '0' limit 1

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

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

select * from `ecom_winkels` limit 1

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

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` inner join `ecom_shops_categorie` on `prdcategorie`.`idPrdcategorie` = `ecom_shops_categorie`.`idPrdcategorie` where `prdcategorie`.`CATE_ACTIEF` = '1' and `ecom_shops_categorie`.`idShops` = '1' and `CATE_CATALOOG_P4C` = '1' and `prdcategorie`.`idBron` = '0' group by `prdcategorie`.`idPrdcategorie` order by `prdcategorie`.`CATE_VOLGORDE` asc

select * from `ecom_labels`

select * from `ecom_client_labels`

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '273' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

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

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '282' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '283' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '274' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '213' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '240' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

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

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '241' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '196' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '175' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('195', '178', '179') order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '195' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '178' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '179' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '233' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '252' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '249' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '186' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('203', '209', '184', '173', '199', '180', '250', '193') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('187', '204', '210', '188', '205', '214', '190', '206', '215', '189', '207', '216', '191', '208', '217', '192', '198') order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '203' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('204', '205', '206', '207', '208') order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '209' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('210', '214', '215', '216', '217') order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '184' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '173' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('187', '188', '190', '189', '191', '192', '198') order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '199' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '180' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '250' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '193' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '183' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

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

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '220' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '172' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('221', '222', '226', '223', '224', '225', '227', '228', '229', '230', '231') order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '221' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '222' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '226' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '223' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '224' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '225' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '227' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '228' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '229' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '230' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '231' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '185' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '171' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '248' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '200' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '182' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

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

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '202' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '194' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '211' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('284', '218', '219') order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '284' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '218' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '219' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '181' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '253' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '234' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

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

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

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '239' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '235' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

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

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '236' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '197' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '174' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('177', '176', '232', '212') order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '177' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '176' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '232' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '212' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '242' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('243', '251', '245', '244', '247', '246') order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('254', '256', '276', '280', '255', '257', '275', '279', '258', '262', '265', '277', '259', '261', '272', '278', '260', '263', '281', '266', '270', '267', '271', '264', '268', '269') order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '243' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('256', '257', '258', '259', '263', '270', '271') order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '251' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('276', '279', '277', '278') order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '245' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('280', '275', '265', '272', '260') order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '244' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select * from `prdcategorie` where `prdcategorie`.`idBron` in ('254', '255', '262', '261', '281', '266', '267', '264', '268', '269') order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '247' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '246' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '170' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '201' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc

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

select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'P-LBEPH00014'

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

select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'P-LBEPH00014' limit 1

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

select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'P-LBEPH00015'

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

select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'P-LBEPH00015' limit 1

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

select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'P-LBEPH00006'

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

select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'P-LBEPH00006' limit 1

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

select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'P-LBEPH00018'

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

select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'P-LBEPH00018' limit 1

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

select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'P-LBECL00507'

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

select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'P-LBECL00507' limit 1

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

select * from `pages` inner join `ecom_pages_shops` on `pages`.`id` = `ecom_pages_shops`.`idPages` left join `ecom_pages_klantgroep` on `pages`.`id` = `ecom_pages_klantgroep`.`pages_id` where `ecom_pages_shops`.`idShops` = '1' and (`ecom_pages_klantgroep`.`pages_id` is null) and `idMenu` = '1' and `idMenu` = '1' and `pagevisibility` = '1' order by `pageorder` asc

select * from `pages` where `pages`.`issubpageof` in ('32') order by `pageorder` asc

select * from `pages` inner join `ecom_pages_shops` on `pages`.`id` = `ecom_pages_shops`.`idPages` left join `ecom_pages_klantgroep` on `pages`.`id` = `ecom_pages_klantgroep`.`pages_id` where `ecom_pages_shops`.`idShops` = '1' and (`ecom_pages_klantgroep`.`pages_id` is null) and `idMenu` = '1' and `idMenu` = '1' and `pagevisibility` = '1' order by `pageorder` asc

select * from `pages` where `pages`.`issubpageof` in ('32') order by `pageorder` asc

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

select * from `ecom_winkels` limit 1

select * from `pages` where `idMenu` = '6' and `pagevisibility` = '1' order by `pageorder` asc