select * from `redirects` where `van` like 'https://www.promotie-kledij.eu/nl/categorie/hoge-visibiliteit-183.html'

select * from `prdcategorie` where `CATE_SLUG1` = 'hoge-visibiliteit-183' and `CATE_ACTIEF` = '1' limit 1

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

select * from `prdcategorie` where `prdcategorie`.`idPrdcategorie` in ('0')

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 `prdcategorie`.`idBron` = '2' group by `prdcategorie`.`idPrdcategorie` order by `prdcategorie`.`CATE_NAAM1` asc

SELECT titel, value_id AS pf_id, count(ecfid) AS aantal, textwaarde, groepwaarde, volgorde, feature_id, textcode, a.idProduct FROM(
                                    SELECT cf.`titel1` AS titel, cf.volgorde as volgorde, pf.id AS ecfid,
                                           `ecom_custfeatwaarde`.`waarde1` AS textwaarde, `ecom_custfeatwaarde`.`code` AS textcode, concat(`ecom_custfeatwaarde`.`waarde1`,cf.id)
                                            AS groepwaarde, ecom_custfeatwaarde.id AS value_id,
                                            concat('single_',pf.id) AS type_id, ecom_custfeatwaarde.`volgorde` AS value_volgorde, cf.id AS feature_id, pf.idProduct
                                    FROM `ecom_productfamiliecustomfeatures` pf
                                    INNER JOIN `ecom_customfeatures` cf ON pf.`idEcomCustomfeatures` = cf.`id`
                                    INNER JOIN `ecom_productfamiliecustomfeatures_waardes` pfw ON pf.`id` = pfw.`productfamiliecustomfeature_id`
                                    INNER JOIN `ecom_custfeatwaarde` ON pfw.`waarde_id` = `ecom_custfeatwaarde`.`id`
                                    INNER JOIN `ecom_customgroep` on (cf.`ecom_customgroep_id` = `ecom_customgroep`.`id`)
                                    INNER JOIN `ecom_productfamiliecategorie` ON `pf`.`idProduct` = `ecom_productfamiliecategorie`.`idProduct` WHERE cf.type = 1 AND cf.active = 1 AND ecom_productfamiliecategorie.idPrdcategorie = 183 GROUP BY pf.idProduct, ecom_custfeatwaarde.id
                                    ORDER BY titel, textwaarde ASC) a
                                    INNER JOIN `ecom_productfamiliecategorie` ON a.idProduct = `ecom_productfamiliecategorie`.`idProduct`
                                    WHERE `ecom_productfamiliecategorie`.`idPrdcategorie` = 183 AND textwaarde IS NOT NULL AND titel IS NOT NULL GROUP BY value_id ORDER BY volgorde, titel asc, textwaarde asc

select count(*) as aggregate from `productfeatures` inner join `product` on `productfeatures`.`idProduct` = `product`.`idProduct` inner join `ecom_productcategorie` on `productfeatures`.`idProductfeatures` = `ecom_productcategorie`.`idProductfeatures` inner join `ecom_productfeatures_shops` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_shops`.`idProductfeatures` where `ecom_productfeatures_shops`.`idShop` = '1' and `productfeatures`.`PRD_ACTIEF` = '1' and `productfeatures`.`PRD_VOLGORDE` = '0' and `ecom_productcategorie`.`idPrdcategorie` = '183'

select `productfeatures`.`PRD_REF`, `productfeatures`.`PRD_ARTIKELCODE`, `productfeatures`.`PRD_EXTRANAAM1`, `productfeatures`.`PRD_SLUG1`, `productfeatures`.`idProductfeatures`, `productfeatures`.`idProduct`, `productfeatures`.`PRD_PRIJS`, `productfeatures`.`idMerken`, `idPrdbtwpercentage`, `PRD_PROMO`, `PRD_NIEUW` from `productfeatures` inner join `product` on `productfeatures`.`idProduct` = `product`.`idProduct` inner join `ecom_productcategorie` on `productfeatures`.`idProductfeatures` = `ecom_productcategorie`.`idProductfeatures` inner join `ecom_productfeatures_shops` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_shops`.`idProductfeatures` where `ecom_productfeatures_shops`.`idShop` = '1' and `productfeatures`.`PRD_ACTIEF` = '1' and `productfeatures`.`PRD_VOLGORDE` = '0' and `ecom_productcategorie`.`idPrdcategorie` = '183' order by `PROD_VOLGORDE` asc limit 24 offset 0

select * from `product` where `product`.`idProduct` in ('618', '1789', '779', '1906', '3371', '3574', '4096', '2729', '3946', '4297', '1166', '2545', '4197', '3998', '1593', '773', '1904', '4030', '3557', '2727', '3600', '4296', '1163', '1293')

select * from `ecom_merken` where `ecom_merken`.`id` in ('36', '18', '20', '44', '10')

select * from `prdmedia` where `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' and `prdmedia`.`idProduct` in ('618', '773', '779', '1163', '1166', '1293', '1593', '1789', '1904', '1906', '2545', '2727', '2729', '3371', '3557', '3574', '3600', '3946', '3998', '4030', '4096', '4197', '4296', '4297')

SELECT `ecom_merken`.`id` AS `id`, `ecom_merken`.`naam1` AS `merknaam`, COUNT(`product`.`idMerken`) AS aantal FROM (
                          SELECT `productfeatures`.`idProduct` FROM `productfeatures` INNER JOIN `ecom_productcategorie` ON `productfeatures`.`idProductfeatures` = `ecom_productcategorie`.`idProductfeatures`
                          WHERE `ecom_productcategorie`.`idPrdcategorie` = '183'GROUP BY `productfeatures`.`idProduct`) AS z INNER JOIN `product` ON `z`.`idProduct` = `product`.`idProduct` INNER JOIN `ecom_merken` ON `product`.`idMerken` = `ecom_merken`.`id`GROUP BY `product`.`idMerken` ORDER BY `merknaam` ASC

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 * from `ecom_settings` where `id` = '41' 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 `ecom_settings` where `key` = 'korting' limit 1

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '16123'

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` = '16123'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '46350'

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` = '46350'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '22715'

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` = '22715'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '49066'

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` = '49066'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '84467'

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` = '84467'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '88759'

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` = '88759'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '100719'

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` = '100719'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '66560'

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` = '66560'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '98380'

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` = '98380'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '103684'

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` = '103684'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '31135'

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` = '31135'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '62344'

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` = '62344'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '102772'

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` = '102772'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '99010'

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` = '99010'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '77202'

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` = '77202'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '22534'

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` = '22534'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '49045'

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` = '49045'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '99666'

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` = '99666'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '88444'

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` = '88444'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '66524'

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` = '66524'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '88993'

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` = '88993'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '103672'

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` = '103672'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '30979'

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` = '30979'

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

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

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

select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' 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` = '34347'

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` = '34347'

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie`, `idBron` 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 `prdcategorie`.`idBron` = '0' group by `prdcategorie`.`idPrdcategorie` order by `prdcategorie`.`CATE_NAAM1` desc

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

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

select `CATE_NAAM1` as `name`, `CATE_SLUG1` as `cslug`, `prdcategorie`.`idPrdcategorie`, `idBron` 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 `prdcategorie`.`idBron` = '2' group by `prdcategorie`.`idPrdcategorie` order by `prdcategorie`.`CATE_NAAM1` asc

select * from `prdmedia` where `prdmedia`.`idPrdcategorie` = '2' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' limit 1

select `CATE_NAAM1` as `name`, `CATE_SLUG1` as `cslug`, `prdcategorie`.`idPrdcategorie`, `idBron` 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 `prdcategorie`.`idBron` = '1' group by `prdcategorie`.`idPrdcategorie` order by `prdcategorie`.`CATE_NAAM1` asc

select * from `prdmedia` where `prdmedia`.`idPrdcategorie` = '1' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' limit 1

select `CATE_NAAM1` as `name`, `CATE_SLUG1` as `cslug`, `prdcategorie`.`idPrdcategorie`, `idBron` 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 `prdcategorie`.`idBron` = '172' group by `prdcategorie`.`idPrdcategorie` order by `prdcategorie`.`CATE_NAAM1` asc

select * from `prdmedia` where `prdmedia`.`idPrdcategorie` = '172' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' limit 1

select * from `prdmedia` where `prdmedia`.`idPages` = '42' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' limit 1

select * from `prdmedia` where `prdmedia`.`idPages` = '43' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' limit 1

select * from `prdmedia` where `prdmedia`.`idPages` = '29' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' limit 1

select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie`, `idBron` 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 `prdcategorie`.`idBron` = '0' group by `prdcategorie`.`idPrdcategorie` order by `prdcategorie`.`CATE_NAAM1` desc

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

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

select `key`, `waarde` from `ecom_settings` where `key` in ('mollie_creditcard', 'mollie_mistercash', 'mollie_belfius', 'mollie_banktransfer', 'mollie_ideal', 'mollie_kbc', 'mollie_paypal', 'mollie_sofort')

select * from `ecom_winkels` limit 1

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

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

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

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

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

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