select * from `redirects` where `van` like 'https://www.promotie-kledij.eu/nl/product/id-003-hooded-sweater-heather-grey-ik-like-mezelf-ook-zonder-filter.html'

select `PROD_FAMILIEREF`, `PROD_OMSCHRIJVING1`, `PROD_NAAM1`, `PROD_SLUG1`, `PROD_SLUG2`, `PROD_SLUG3`, `PROD_SLUG4`, `idProduct` from `product` where `PROD_SLUG1` = 'id-003-hooded-sweater-heather-grey-ik-like-mezelf-ook-zonder-filter' limit 1

select `PRD_REF`, `PRD_ARTIKELCODE`, `PRD_EXTRAOMSCHRIJVING1`, `PRD_EXTRANAAM1`, `PRD_SLUG1`, `idProductfeatures`, `idProduct`, `PRD_PRIJS`, `idMerken`, `idPrdbtwpercentage`, `PRD_PROMO`, `PRD_NIEUW`, `idPrdeenheid`, `PRD_CATALOG_PAGE` from `productfeatures` where `idProduct` = '3729' and `productfeatures`.`PRD_ACTIEF` = '1' order by `PRD_VOLGORDE` asc limit 1

select * from `product` where `product`.`idProduct` in ('3729')

select `prdcategorie`.*, `ecom_productcategorie`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productcategorie`.`idPrdcategorie` as `pivot_idPrdcategorie` from `prdcategorie` inner join `ecom_productcategorie` on `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` where `idBron` = '0' and `ecom_productcategorie`.`idProductfeatures` in ('90655')

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

select * from `prdeenheid` where `prdeenheid`.`idPrdeenheid` in ('2')

select * from `prdmedia` where `prdmedia`.`idProduct` = '3729' and `MEDIA_TYPE` = 'I' order by `MEDIA_VOLGORDE` asc, `idPrdmedia` 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 `productfeatures` where `idProductfeatures` = '90655' limit 1

insert into `ecom_meest_bekeken` (`idContacts`, `idProductfeatures`, `NAAM1`, `NAAM2`, `NAAM3`, `NAAM4`, `idSession`, `ip`, `updated_at`, `created_at`) values ('', '90655', 'ID.003 Hooded Sweater Heather Grey Ik like mezelf ook zonder filter XS', '', '', '', '8rl4o6cfdinahrgkig50hiu067', '3.238.72.122', '2022-05-19 09:57:47', '2022-05-19 09:57:47')

select * from `productfeatures` where `productfeatures`.`idProduct` = '3729' order by `PRD_VOLGORDE` asc, `idProductfeatures` asc

select `ecom_customfeatures`.`code` as `customcode`, `ecom_customfeatures`.`id` as `idEcomCustomfeature`, `ecom_productcustomfeatures`.* from `ecom_productcustomfeatures` left join `ecom_customfeatures` on `ecom_productcustomfeatures`.`idEcomCustomfeatures` = `ecom_customfeatures`.`id` where `ecom_productcustomfeatures`.`idProductfeatures` in ('90655', '90656', '90657', '90658', '90659', '90660') order by `ecom_customfeatures`.`volgorde` asc

select * from `ecom_customfeatures` where `ecom_customfeatures`.`id` in ('873', '3365')

select `ecom_custfeatwaarde`.*, `ecom_productcustomfeatures_waardes`.`productcustomfeature_id` as `pivot_productcustomfeature_id`, `ecom_productcustomfeatures_waardes`.`waarde_id` as `pivot_waarde_id` from `ecom_custfeatwaarde` inner join `ecom_productcustomfeatures_waardes` on `ecom_custfeatwaarde`.`id` = `ecom_productcustomfeatures_waardes`.`waarde_id` where `ecom_productcustomfeatures_waardes`.`productcustomfeature_id` in ('113270', '113271', '113272', '113273', '113274', '113275', '113276', '113277', '113278', '113279', '113280', '113281')

select `idProductfeatures` from `productfeatures` where `productfeatures`.`idProduct` = '3729' order by `PRD_VOLGORDE` asc, `idProductfeatures` asc

select `id` from `ecom_customgroep` where `code` = '275.42' limit 1

select `id` from `ecom_customfeatures` where `code` = '0001' and `ecom_customgroep_id` = '873' limit 1

select `ecom_custfeatwaarde`.`id` as `waarde_id`, `PRD_SLUG1` as `slug_field`, `ecom_custfeatwaarde`.`waarde1` as `waarde`, `productfeatures`.`idProductfeatures` as `idProductfeatures`, `prdmedia`.`MEDIA_BESTANDSNAAM`, `pm`.`MEDIA_BESTANDSNAAM` as `PRD_MEDIA_BESTANDSNAAM`, `pm`.`MEDIA_ALTREF1` as `PRD_MEDIA_ALTREF` from `productfeatures` inner join `ecom_productcustomfeatures` on `productfeatures`.`idProductfeatures` = `ecom_productcustomfeatures`.`idProductfeatures` inner join `ecom_productcustomfeatures_waardes` on `ecom_productcustomfeatures`.`id` = `ecom_productcustomfeatures_waardes`.`productcustomfeature_id` inner join `ecom_custfeatwaarde` on `ecom_productcustomfeatures_waardes`.`waarde_id` = `ecom_custfeatwaarde`.`id` inner join `prdmedia` on `ecom_custfeatwaarde`.`id` = `prdmedia`.`idAttributen` left join `prdmedia` as `pm` on `productfeatures`.`idProductfeatures` = `pm`.`idProductfeatures` where `productfeatures`.`idProductfeatures` in ('90655', '90656', '90657', '90658', '90659', '90660') and `productfeatures`.`PRD_ACTIEF` = '1' and `ecom_custfeatwaarde`.`idEcomCustomfeatures` = '873' group by `ecom_custfeatwaarde`.`id` order by `productfeatures`.`PRD_VOLGORDE` asc

select `id` from `ecom_customfeatures` where `code` = '0002' and `ecom_customgroep_id` = '873' limit 1

select `ecom_custfeatwaarde`.`idEcomCustomfeatures`, `ecom_custfeatwaarde`.`id` as `waarde_id`, `PRD_SLUG1` as `slug_field`, `ecom_custfeatwaarde`.`waarde1` as `waarde`, `productfeatures`.`idProductfeatures` as `idProductfeatures` from `productfeatures` inner join `ecom_productcustomfeatures` on `productfeatures`.`idProductfeatures` = `ecom_productcustomfeatures`.`idProductfeatures` inner join `ecom_productcustomfeatures_waardes` on `ecom_productcustomfeatures`.`id` = `ecom_productcustomfeatures_waardes`.`productcustomfeature_id` inner join `ecom_custfeatwaarde` on `ecom_productcustomfeatures_waardes`.`waarde_id` = `ecom_custfeatwaarde`.`id` where `productfeatures`.`idProductfeatures` in ('90655', '90656', '90657', '90658', '90659', '90660') and `productfeatures`.`PRD_ACTIEF` = '1' and `ecom_custfeatwaarde`.`idEcomCustomfeatures` = '3365' group by `ecom_custfeatwaarde`.`id` order by `ecom_custfeatwaarde`.`volgorde` asc, `ecom_custfeatwaarde`.`id` asc

select count(`id`) as aggregate from `ecom_personalisatiemodule` inner join `ecom_personalisatiemodule_product` on `ecom_personalisatiemodule`.`id` = `ecom_personalisatiemodule_product`.`ecom_personalisatiemodule_id` where `ecom_personalisatiemodule_product`.`product_id` = '3729'

select `idPrdcategorie` from `ecom_productfamiliecategorie` where `idProduct` = '3729'

select count(`id`) as aggregate from `ecom_personalisatiemodule` inner join `ecom_personalisatiemodule_categorie` on `ecom_personalisatiemodule`.`id` = `ecom_personalisatiemodule_categorie`.`ecom_personalisatiemodule_id` where `ecom_personalisatiemodule_categorie`.`categorie_id` in ('1', '2', '5', '100')

select `prdcategorie`.*, `ecom_productcategorie`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productcategorie`.`idPrdcategorie` as `pivot_idPrdcategorie` from `prdcategorie` inner join `ecom_productcategorie` on `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` where `ecom_productcategorie`.`idProductfeatures` = '90655' and `idBron` = '1' limit 1

select `ecom_customgroep`.*, `ecom_prodcat_custgroep`.`ecom_productcategorie_id` as `pivot_ecom_productcategorie_id`, `ecom_prodcat_custgroep`.`ecom_customgroep` as `pivot_ecom_customgroep` from `ecom_customgroep` inner join `ecom_prodcat_custgroep` on `ecom_customgroep`.`id` = `ecom_prodcat_custgroep`.`ecom_customgroep` where `ecom_prodcat_custgroep`.`ecom_productcategorie_id` in ('5') order by `volgorde` asc

select * from `ecom_labels`

select * from `ecom_client_labels`

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

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

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

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

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

select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '90655' 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` = '90655'

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

select `product`.*, `ecom_product_rel`.`idProduct_rel` as `pivot_idProduct_rel`, `ecom_product_rel`.`idProduct` as `pivot_idProduct` from `product` inner join `ecom_product_rel` on `product`.`idProduct` = `ecom_product_rel`.`idProduct` where `ecom_product_rel`.`idProduct_rel` = '3729'

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