Internet Explorer wordt niet ondersteund voor deze website. U wordt geadviseerd om een moderne webbrowser te gebruiken.
Even geduld...
Bezig met laden configurator
Stap 1 3

Kies uw achterdeur

Gebruik de filters om snel te zoeken en de resultaten te verfijnen.

Stap 2 3

Bepaal de juiste maat

Pas de deur volledig aan naar jouw situatie.

{substepvalue} {substepname}
Kies een draairichting
Voor buitendeuren is het belangrijk om aan te geven of de deur naar binnen of naar buiten open draait. De meeste voordeuren gaan naar binnen open en de meeste achterdeuren naar buiten.
{substepvalue} {substepname}
Stap 3 3

Accessoires

Maak je deur compleet door accessoires toe te voegen.

{substepvalue} {substepname}
{substepvalue} {substepname}
Stap 5 5 2

Controleer je bestelling

Je hebt voor de onderstaande producten gekozen. We adviseren je om de informatie nog eenmaal goed te controleren.

Terug
    {mainsteps}
  •   Bestellen/mailen Deze deur wordt speciaal voor jou op maat gemaakt en kan daarom niet geretourneerd worden
    Totaalprijs*
    * Eventuele kortingen worden berekend in de winkelwagen

Mail deze configuratie naar mijn mailadres

Bewaar deze configuratie

Vul hier je e-mailadres in en kies een naam voor deze configuratie.

Uw configuratie is opgeslagen

Voeg configuratie toe aan uw winkelwagen op uw mobiel

Door het scannen van de QR-code wordt deze configuratie in de winkelwagen van Praxis geplaatst. Hier kun je de bestelling eenvoudig en veilig afronden.

  • {stepnumber} {mainstepname} {steps}
  • {stepvalue} {stepname}:

    Request Details

    Session Id:xjasie5gwbsih0lrtebhfgciRequest Type:GET
    Time of Request:21-10-2021 18:30:53Status Code:200
    Request Encoding:Unicode (UTF-8)Response Encoding:Unicode (UTF-8)

    Trace Information

    CategoryMessageFrom First(s)From Last(s)
    aspx.pageBegin PreInit
    aspx.pageEnd PreInit0,0000320,000032
    aspx.pageBegin Init0,0000470,000015
    LoginControl_Init - isValidForThisDomain: True0,0007140,000667
    LoginControl - SetupWebsite - proceed: True, GoAnCode: , TagManagerId: GTM-TSQHNV80,0010360,000321
    useTagManager: False0,0011110,000075
    This is page: homepage.aspx. With masterpagefile: 0,0012840,000173
    CSS template IDs found: 0,0016520,000369
    End load CSS from Wiser...0,0016660,000013
    JS template IDs found: 0,0019650,000300
    NO JS template inline found0,0019780,000013
    End load JS from Wiser...0,0019880,000010
    aspx.pageEnd Init0,0020360,000048
    aspx.pageBegin InitComplete0,0020440,000008
    aspx.pageEnd InitComplete0,0020520,000009
    aspx.pageBegin PreLoad0,0020630,000010
    aspx.pageEnd PreLoad0,0020730,000010
    aspx.pageBegin Load0,0020860,000013
    aspx.pageEnd Load0,0021030,000016
    aspx.pageBegin LoadComplete0,0021090,000007
    aspx.pageEnd LoadComplete0,0021150,000006
    aspx.pageBegin PreRender0,0021210,000006
    aspx.pageEnd PreRender0,0021640,000044
    aspx.pageBegin PreRenderComplete0,0021730,000009
    aspx.pageEnd PreRenderComplete0,0021790,000006
    aspx.pageBegin SaveState0,0023630,000185
    aspx.pageEnd SaveState0,0023700,000007
    aspx.pageBegin SaveStateComplete0,0023760,000006
    aspx.pageEnd SaveStateComplete0,0023820,000006
    aspx.pageBegin Render0,0023870,000006
    QUERY SYSCON START:
                           SELECT
                               #SUMMARY
                               IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template
                               ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template
                               ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template

                               #PROGRESS
                               ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template
                               ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template
                               ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template

                               ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template
                               ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template
                               ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template

                               ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template
                               ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template
                               ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template

                               #CONFIGURATOR
                           ,configurator.name
                           ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template
                               ,configvalues.price_calculation_query

                               #MAIN STEPS
                           #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template
                               ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template
                           ,mainsteps.name AS mainstepname
                               ,mainstepvalues.free_content1 AS mainstep_free_content1
                               ,mainstepvalues.free_content2 AS mainstep_free_content2
                               ,mainstepvalues.free_content3 AS mainstep_free_content3
                               ,mainstepvalues.free_content4 AS mainstep_free_content4
                               ,mainstepvalues.free_content5 AS mainstep_free_content5

                               #STEPS
                           ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template
                           ,steps.name AS stepname
                           ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template
                           ,stepvalues.datasource
                           ,stepvalues.custom_query
                           ,stepvalues.fixed_valuelist
                               ,stepvalues.datasource_connectedtype
                               ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name
                               ,stepvalues.free_content1 AS step_free_content1
                               ,stepvalues.free_content2 AS step_free_content2
                               ,stepvalues.free_content3 AS step_free_content3
                               ,stepvalues.free_content4 AS step_free_content4
                               ,stepvalues.free_content5 AS step_free_content5
                               ,stepvalues.datasource_connectedid
                               ,stepvalues.isrequired
                               ,stepvalues.check_connectedid

                               #SUBSTEPS
                           ,substeps.name AS substepname
                           ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template
                           ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template
                           ,substepvalues.datasource AS substep_datasource
                           ,substepvalues.custom_query AS substep_custom_query
                           ,substepvalues.fixed_valuelist AS substep_fixed_valuelist
                               ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype
                               ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name
                               ,substepvalues.datasource_connectedid AS substep_datasource_connectedid
                               ,substepvalues.isrequired AS substep_isrequired
                               ,substepvalues.check_connectedid AS substep_check_connectedid

                               #Get the applied regex
                               ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex,
                                   IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex

                           FROM easy_items configurator
                           JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id
    LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom
                           JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1

                           LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id
                           LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom

                           LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1
                           LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id
                           LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom
                           LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1
                           LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id
                           LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom
                           WHERE
                           configurator.moduleid=320 AND
                           configurator.`level`=1 AND
                           configurator.`name`=?name
                           ORDER BY mainsteps.volgnr,steps.volgnr
                          
    0,0029320,000545
    Open connection with DB0,0030440,000112
    QUERY SYSCON END:
                           SELECT
                               #SUMMARY
                               IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template
                               ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template
                               ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template

                               #PROGRESS
                               ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template
                               ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template
                               ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template

                               ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template
                               ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template
                               ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template

                               ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template
                               ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template
                               ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template

                               #CONFIGURATOR
                           ,configurator.name
                           ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template
                               ,configvalues.price_calculation_query

                               #MAIN STEPS
                           #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template
                               ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template
                           ,mainsteps.name AS mainstepname
                               ,mainstepvalues.free_content1 AS mainstep_free_content1
                               ,mainstepvalues.free_content2 AS mainstep_free_content2
                               ,mainstepvalues.free_content3 AS mainstep_free_content3
                               ,mainstepvalues.free_content4 AS mainstep_free_content4
                               ,mainstepvalues.free_content5 AS mainstep_free_content5

                               #STEPS
                           ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template
                           ,steps.name AS stepname
                           ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template
                           ,stepvalues.datasource
                           ,stepvalues.custom_query
                           ,stepvalues.fixed_valuelist
                               ,stepvalues.datasource_connectedtype
                               ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name
                               ,stepvalues.free_content1 AS step_free_content1
                               ,stepvalues.free_content2 AS step_free_content2
                               ,stepvalues.free_content3 AS step_free_content3
                               ,stepvalues.free_content4 AS step_free_content4
                               ,stepvalues.free_content5 AS step_free_content5
                               ,stepvalues.datasource_connectedid
                               ,stepvalues.isrequired
                               ,stepvalues.check_connectedid

                               #SUBSTEPS
                           ,substeps.name AS substepname
                           ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template
                           ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template
                           ,substepvalues.datasource AS substep_datasource
                           ,substepvalues.custom_query AS substep_custom_query
                           ,substepvalues.fixed_valuelist AS substep_fixed_valuelist
                               ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype
                               ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name
                               ,substepvalues.datasource_connectedid AS substep_datasource_connectedid
                               ,substepvalues.isrequired AS substep_isrequired
                               ,substepvalues.check_connectedid AS substep_check_connectedid

                               #Get the applied regex
                               ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex,
                                   IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex

                           FROM easy_items configurator
                           JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id
    LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom
                           JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1

                           LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id
                           LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom

                           LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1
                           LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id
                           LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom
                           LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1
                           LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id
                           LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom
                           WHERE
                           configurator.moduleid=320 AND
                           configurator.`level`=1 AND
                           configurator.`name`=?name
                           ORDER BY mainsteps.volgnr,steps.volgnr
                          
    0,0940040,090960
    RenderStep Kies uw buitendeur connected to: 2289 - mainstepnumber: 1 - stepnumber: 1 - dependentvalue: 2289 - datasource connectedid: 22890,0974720,003468
    [RenderValues] set query and/or replacements0,0975240,000052
    [RenderValues] Execute query0,0982600,000736
    QUERY SYSCON START: SET @doortype = 'buitendeur';
    SET @doorsubtype = 'achterdeuren';
    SET @_door_id = IF('{door_id}' LIKE '{%}', false, CAST('{door_id}' AS UNSIGNED));
    SET @_glass_id = IF('{glass_id}' LIKE '{%}', false, CAST('{glass_id}' AS UNSIGNED));

    SELECT
    door.fsc AS fsc,
    door.KOMO AS komo,
    IF(IFNULL(door.warrantyinYears,0)>9,1,0) AS ten_yr_guarantee,
    door.id AS door_id,
    doorCat.id AS door_cat_id,
    doorCat.`name` AS door_name,
    doorCat.style AS style,
    IFNULL(doorCat.door_wood_type, "Overig") AS door_wood_type,
    GROUP_CONCAT(DISTINCT CONCAT(door.height, "x", door.width)) AS sizes,
    IFNULL(MIN(glass.id),"") AS glass_id,
    IFNULL(glass.description_short, "") AS glass_name,
    doorCat.containsglass AS has_glass,
    IFNULL(GROUP_CONCAT(DISTINCT glass.glassType),IF(doorCat.containsglass =0,"Zonder glas", "")) AS glass_type,
    REPLACE(CONCAT_WS(" met ", doorCat.name, glass.description_short), 'met zonder','zonder') AS `name`,
    GROUP_CONCAT(DISTINCT door.producttype) AS door_type,
    door.eancode AS door_ean,
    glass.eancode AS glass_ean,
    MIN(door.priceDTM) AS door_price,
    glass.priceDTM AS glass_price,
    REPLACE(TRUNCATE(MIN(door.priceDTM) + IFNULL(glass.priceDTM,0) + IFNULL(mounting_package.priceDTM,0),2), '.',',') AS total_price,
    IFNULL(CONCAT('<li>',REPLACE(doorCat.usp_s, '\r\n', '</li><li>'),'</li>'),'') AS usps,
    CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(IFNULL(img.bestandsnaam,imgBackup.bestandsnaam), '')) AS img_url,
    REPLACE(CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(IFNULL(img.bestandsnaam,imgBackup.bestandsnaam), '')),'_klein_','_vergroting_')  AS img_url_large,
    REPLACE(CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(img2.bestandsnaam, '')),'_klein_','_vergroting_')  AS img2_url_large,
    IFNULL(img2.bestandsnaam, '') AS sfeerImageFile
    FROM shop_products door
    JOIN shop_pro_cat door_to_cat ON door_to_cat.product_id=door.id
    JOIN shop_category doorCat ON doorCat.doortype=@doortype AND doorCat.id=door_to_cat.cat_id
    LEFT JOIN shop_koppeling glass_to_door ON glass_to_door.prod_dest=door.id AND glass_to_door.koppeltype IN("Roede", "Glas")
    LEFT JOIN shop_products glass ON glass.id=glass_to_door.prod_source
    LEFT JOIN shop_koppeling mounting_package_to_glass ON mounting_package_to_glass.prod_dest=glass.id AND mounting_package_to_glass.koppeltype="Verplicht item"
    LEFT JOIN shop_products mounting_package ON mounting_package.id=mounting_package_to_glass.prod_source

    # needs to be optimized
    LEFT JOIN shop_pictures img ON img.cat_id=doorCat.id AND img.formaatnaam = 'klein' AND img.fototype='deur' AND IF(glass.description_short IS NULL, img.name = doorCat.`name`, img.name = glass.description_short) #AND img.name = IFNULL(glass.description_short, "")
    LEFT JOIN shop_pictures imgBackup ON imgBackup.cat_id=doorCat.id AND imgBackup.formaatnaam = 'klein' AND imgBackup.fototype='deur'  #AND img.name = IFNULL(glass.description_short, "")
    #LEFT JOIN shop_pictures imgLarge ON imgLarge.cat_id=doorCat.id AND imgLarge.formaatnaam = 'vergroting' AND imgLarge.fototype='deur' AND IF(glass.description_short IS NULL, imgLarge.name = doorCat.`name`, imgLarge.name = glass.description_short) #AND img.name = IFNULL(glass.description_short, "")
    #LEFT JOIN shop_pictures imgBackupLarge ON imgBackupLarge.cat_id=doorCat.id AND imgBackupLarge.formaatnaam = 'vergroting' AND imgBackupLarge.fototype='deur'  #AND img.name = IFNULL(glass.description_short, "")
    LEFT JOIN shop_pictures img2 ON img2.cat_id=doorCat.id AND img2.formaatnaam = 'vergroting' AND img2.fototype='sfeerfoto' AND IF(glass.description_short IS NULL, img.name = doorCat.`name`, img.name = glass.description_short)
    WHERE doorCat.doortype=@doortype
           AND doorCat.doorsubtype=@doorsubtype
    AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visibleDTM, door.visibleDTMBranch) <> 0
    AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', doorCat.visibleDTM, doorCat.visibleDTMBranch) <> 0
    AND IF(@_door_id = false, 1, door.id = @_door_id)
    AND IF(@_glass_id = false, 1, glass.id = @_glass_id)
       AND (glass.id IS NULL OR glass.visibleDTM <> 0)
    GROUP BY `name`
    ORDER BY `name`
    0,0982910,000031
    Open connection with DB0,0983620,000071
    QUERY SYSCON END: SET @doortype = 'buitendeur';
    SET @doorsubtype = 'achterdeuren';
    SET @_door_id = IF('{door_id}' LIKE '{%}', false, CAST('{door_id}' AS UNSIGNED));
    SET @_glass_id = IF('{glass_id}' LIKE '{%}', false, CAST('{glass_id}' AS UNSIGNED));

    SELECT
    door.fsc AS fsc,
    door.KOMO AS komo,
    IF(IFNULL(door.warrantyinYears,0)>9,1,0) AS ten_yr_guarantee,
    door.id AS door_id,
    doorCat.id AS door_cat_id,
    doorCat.`name` AS door_name,
    doorCat.style AS style,
    IFNULL(doorCat.door_wood_type, "Overig") AS door_wood_type,
    GROUP_CONCAT(DISTINCT CONCAT(door.height, "x", door.width)) AS sizes,
    IFNULL(MIN(glass.id),"") AS glass_id,
    IFNULL(glass.description_short, "") AS glass_name,
    doorCat.containsglass AS has_glass,
    IFNULL(GROUP_CONCAT(DISTINCT glass.glassType),IF(doorCat.containsglass =0,"Zonder glas", "")) AS glass_type,
    REPLACE(CONCAT_WS(" met ", doorCat.name, glass.description_short), 'met zonder','zonder') AS `name`,
    GROUP_CONCAT(DISTINCT door.producttype) AS door_type,
    door.eancode AS door_ean,
    glass.eancode AS glass_ean,
    MIN(door.priceDTM) AS door_price,
    glass.priceDTM AS glass_price,
    REPLACE(TRUNCATE(MIN(door.priceDTM) + IFNULL(glass.priceDTM,0) + IFNULL(mounting_package.priceDTM,0),2), '.',',') AS total_price,
    IFNULL(CONCAT('<li>',REPLACE(doorCat.usp_s, '\r\n', '</li><li>'),'</li>'),'') AS usps,
    CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(IFNULL(img.bestandsnaam,imgBackup.bestandsnaam), '')) AS img_url,
    REPLACE(CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(IFNULL(img.bestandsnaam,imgBackup.bestandsnaam), '')),'_klein_','_vergroting_')  AS img_url_large,
    REPLACE(CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(img2.bestandsnaam, '')),'_klein_','_vergroting_')  AS img2_url_large,
    IFNULL(img2.bestandsnaam, '') AS sfeerImageFile
    FROM shop_products door
    JOIN shop_pro_cat door_to_cat ON door_to_cat.product_id=door.id
    JOIN shop_category doorCat ON doorCat.doortype=@doortype AND doorCat.id=door_to_cat.cat_id
    LEFT JOIN shop_koppeling glass_to_door ON glass_to_door.prod_dest=door.id AND glass_to_door.koppeltype IN("Roede", "Glas")
    LEFT JOIN shop_products glass ON glass.id=glass_to_door.prod_source
    LEFT JOIN shop_koppeling mounting_package_to_glass ON mounting_package_to_glass.prod_dest=glass.id AND mounting_package_to_glass.koppeltype="Verplicht item"
    LEFT JOIN shop_products mounting_package ON mounting_package.id=mounting_package_to_glass.prod_source

    # needs to be optimized
    LEFT JOIN shop_pictures img ON img.cat_id=doorCat.id AND img.formaatnaam = 'klein' AND img.fototype='deur' AND IF(glass.description_short IS NULL, img.name = doorCat.`name`, img.name = glass.description_short) #AND img.name = IFNULL(glass.description_short, "")
    LEFT JOIN shop_pictures imgBackup ON imgBackup.cat_id=doorCat.id AND imgBackup.formaatnaam = 'klein' AND imgBackup.fototype='deur'  #AND img.name = IFNULL(glass.description_short, "")
    #LEFT JOIN shop_pictures imgLarge ON imgLarge.cat_id=doorCat.id AND imgLarge.formaatnaam = 'vergroting' AND imgLarge.fototype='deur' AND IF(glass.description_short IS NULL, imgLarge.name = doorCat.`name`, imgLarge.name = glass.description_short) #AND img.name = IFNULL(glass.description_short, "")
    #LEFT JOIN shop_pictures imgBackupLarge ON imgBackupLarge.cat_id=doorCat.id AND imgBackupLarge.formaatnaam = 'vergroting' AND imgBackupLarge.fototype='deur'  #AND img.name = IFNULL(glass.description_short, "")
    LEFT JOIN shop_pictures img2 ON img2.cat_id=doorCat.id AND img2.formaatnaam = 'vergroting' AND img2.fototype='sfeerfoto' AND IF(glass.description_short IS NULL, img.name = doorCat.`name`, img.name = glass.description_short)
    WHERE doorCat.doortype=@doortype
           AND doorCat.doorsubtype=@doorsubtype
    AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visibleDTM, door.visibleDTMBranch) <> 0
    AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', doorCat.visibleDTM, doorCat.visibleDTMBranch) <> 0
    AND IF(@_door_id = false, 1, door.id = @_door_id)
    AND IF(@_glass_id = false, 1, glass.id = @_glass_id)
       AND (glass.id IS NULL OR glass.visibleDTM <> 0)
    GROUP BY `name`
    ORDER BY `name`
    0,2942930,195931
    [RenderValues] Do last replacements. Num items: 390,2943310,000037
    [RenderValues] replacements done0,7020280,407698
    RenderStep (values rendered) Kies uw buitendeur connected to: 2289 - mainstepnumber: 1 - stepnumber: 1 - dependentvalue: 2289 - datasource connectedid: 22890,7022520,000224
    [RenderValues] set query and/or replacements0,7027010,000449
    RenderSubStep  connected to:  - mainstepnumber: 1 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: 0,7027160,000015
    Language 38 is new0,7029190,000203
    Cache item 'ML_38' already exists, so language is not cached again0,7029490,000029
    Session 'MlJclLanguage' set to 380,7029600,000012
    Start replace dynamic content0,7029770,000017
    Replace dynamic content only once0,7030410,000064
    End replace dynamic content0,7030630,000022
    No caching of lanuage 38. Because it is not changed within this session.0,7385180,035456
    Cache item 'ML_38' already exists, so language is not cached again0,7385880,000069
    Session 'MlJclLanguage' set to 380,7385990,000011
    Start replace dynamic content0,7388980,000299
    Replace dynamic content only once0,7395430,000645
    End replace dynamic content0,7395530,000009
    Start replacing system objects0,7395640,000012
    Start replacing translation0,7401350,000571
    Start replacing objects0,7402820,000146
    Start replacing request0,7404910,000209
    Start replacing session0,7801910,039700
    Start replacing standards0,7845400,004349
    Start replacing objecs again0,7849500,000410
    [RenderValues] set query and/or replacements0,8765230,091572
    RenderSubStep  connected to:  - mainstepnumber: 1 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: 0,8765950,000073
    No caching of lanuage 38. Because it is not changed within this session.0,8768750,000280
    Cache item 'ML_38' already exists, so language is not cached again0,8769230,000048
    Session 'MlJclLanguage' set to 380,8769440,000021
    Start replace dynamic content0,8769730,000029
    Replace dynamic content only once0,8770610,000088
    End replace dynamic content0,8770740,000013
    RenderStep Binnendraaiend connected to: binnendeuren  deurtype - mainstepnumber: 2 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: binnendeuren - deurtype0,8821210,005048
    [RenderValues] set query and/or replacements0,8821580,000036
    RenderStep (values rendered) Binnendraaiend connected to: binnendeuren  deurtype - mainstepnumber: 2 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: binnendeuren - deurtype0,8821950,000037
    [RenderValues] set query and/or replacements0,8822360,000042
    [RenderValues] Execute query0,8824320,000196
    QUERY SYSCON START: SET @isBinnen = IF('{uitvoering}' ='Binnendraaiend', true,false);
    SET @isSet = IF('{uitvoering}' LIKE '{%}', false, true);

    SELECT * FROM (
    SELECT 'Links binnendraaiend' AS valuelist_1, 'linksbinnendraaiend' AS valuelist_2, 'L1' AS valuelist_3
    UNION
    SELECT'Rechts binnendraaiend', 'rechtsbinnendraaiend', 'R2'
    ) binnen
    WHERE @isBinnen AND @isSet
    UNION ALL

    SELECT * FROM (
    SELECT 'Links buitendraaiend' AS valuelist_1, 'linksbuitendraaiend' AS valuelist_2, 'L3' AS valuelist_3
    UNION
    SELECT'Rechts buitendraaiend', 'rechtsbuitendraaiend', 'R4'
    ) buiten
    WHERE @isBinnen = false AND @isSet;
    0,8824600,000029
    Open connection with DB0,8824900,000030
    QUERY SYSCON END: SET @isBinnen = IF('{uitvoering}' ='Binnendraaiend', true,false);
    SET @isSet = IF('{uitvoering}' LIKE '{%}', false, true);

    SELECT * FROM (
    SELECT 'Links binnendraaiend' AS valuelist_1, 'linksbinnendraaiend' AS valuelist_2, 'L1' AS valuelist_3
    UNION
    SELECT'Rechts binnendraaiend', 'rechtsbinnendraaiend', 'R2'
    ) binnen
    WHERE @isBinnen AND @isSet
    UNION ALL

    SELECT * FROM (
    SELECT 'Links buitendraaiend' AS valuelist_1, 'linksbuitendraaiend' AS valuelist_2, 'L3' AS valuelist_3
    UNION
    SELECT'Rechts buitendraaiend', 'rechtsbuitendraaiend', 'R4'
    ) buiten
    WHERE @isBinnen = false AND @isSet;
    0,9017930,019302
    [RenderValues] Do last replacements. Num items: 00,9018570,000064
    [RenderValues] replacements done0,9018690,000013
    RenderSubStep Kies een draairichting (binnen)_kopie connected to: draairichting - mainstepnumber: 2 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: draairichting0,9019120,000042
    No caching of lanuage 38. Because it is not changed within this session.0,9022040,000293
    Cache item 'ML_38' already exists, so language is not cached again0,9022360,000032
    Session 'MlJclLanguage' set to 380,9022510,000015
    Start replace dynamic content0,9022880,000037
    Replace dynamic content only once0,9023690,000081
    End replace dynamic content0,9023810,000012
    No caching of lanuage 38. Because it is not changed within this session.0,9054100,003029
    Cache item 'ML_38' already exists, so language is not cached again0,9054420,000033
    Session 'MlJclLanguage' set to 380,9054580,000015
    Start replace dynamic content0,9057940,000336
    QUERY SYSCON START: SELECT * FROM easy_webpages WHERE id=640,9062190,000425
    Open connection with DB0,9062410,000022
    QUERY SYSCON END: SELECT * FROM easy_webpages WHERE id=640,9662220,059981
    Set SEO fields on webpage0,9662790,000057
    title: Welkom op mijn website0,9663100,000031
    metadescription: Vul hier de meta description in0,9663280,000018
    canonicalurl: 0,9663450,000017
    noindex: False0,9663650,000020
    nofollow: False0,9663820,000017
    AddSEOFields: Title=Welkom op mijn website, Description=Vul hier de meta description in, Keywords=Vul hier de metatags in, CanonicalURL=, NoIndex=False, NoFollow=False, Robots=0,9664090,000028
    page Is Nothing: False0,9664380,000029
    page.Header Is Nothing: True0,9664550,000017
    String.IsNullOrWhiteSpace(MetaName): False0,9664710,000016
    page Is Nothing: False0,9665540,000083
    page.Header Is Nothing: True0,9665700,000016
    String.IsNullOrWhiteSpace(MetaName): False0,9665870,000017
    Start replace dynamic content0,9666420,000056
    Replace dynamic content only once0,9667040,000061
    End replace dynamic content0,9667140,000010
    Start replace dynamic content0,9667330,000020
    End replace dynamic content0,9668890,000155
    End replace dynamic content0,9669040,000015
    [RenderValues] set query and/or replacements0,9669560,000053
    [RenderValues] Execute query0,9670990,000143
    QUERY SYSCON START: SET @isBinnen = IF('{uitvoering}' ='Binnendraaiend', true,false);
    SET @isSet = IF('{uitvoering}' LIKE '{%}', false, true);

    SELECT * FROM (
    SELECT 'Links binnendraaiend' AS valuelist_1, 'linksbinnendraaiend' AS valuelist_2, 'L1' AS valuelist_3
    UNION
    SELECT'Rechts binnendraaiend', 'rechtsbinnendraaiend', 'R2'
    ) binnen
    WHERE @isBinnen AND @isSet
    UNION ALL

    SELECT * FROM (
    SELECT 'Links buitendraaiend' AS valuelist_1, 'linksbuitendraaiend' AS valuelist_2, 'L3' AS valuelist_3
    UNION
    SELECT'Rechts buitendraaiend', 'rechtsbuitendraaiend', 'R4'
    ) buiten
    WHERE @isBinnen = false AND @isSet;
    0,9671170,000018
    Open connection with DB0,9671420,000025
    QUERY SYSCON END: SET @isBinnen = IF('{uitvoering}' ='Binnendraaiend', true,false);
    SET @isSet = IF('{uitvoering}' LIKE '{%}', false, true);

    SELECT * FROM (
    SELECT 'Links binnendraaiend' AS valuelist_1, 'linksbinnendraaiend' AS valuelist_2, 'L1' AS valuelist_3
    UNION
    SELECT'Rechts binnendraaiend', 'rechtsbinnendraaiend', 'R2'
    ) binnen
    WHERE @isBinnen AND @isSet
    UNION ALL

    SELECT * FROM (
    SELECT 'Links buitendraaiend' AS valuelist_1, 'linksbuitendraaiend' AS valuelist_2, 'L3' AS valuelist_3
    UNION
    SELECT'Rechts buitendraaiend', 'rechtsbuitendraaiend', 'R4'
    ) buiten
    WHERE @isBinnen = false AND @isSet;
    0,9887090,021566
    [RenderValues] Do last replacements. Num items: 00,9887790,000070
    [RenderValues] replacements done0,9888130,000034
    RenderSubStep Kies een draairichting (binnen)_kopie connected to: draairichting - mainstepnumber: 2 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: draairichting0,9889130,000100
    No caching of lanuage 38. Because it is not changed within this session.0,9892450,000332
    Cache item 'ML_38' already exists, so language is not cached again0,9892890,000045
    Session 'MlJclLanguage' set to 380,9893050,000016
    Start replace dynamic content0,9893520,000047
    Replace dynamic content only once0,9894350,000083
    End replace dynamic content0,9894520,000017
    RenderStep Bepaal de afmeting connected to: deurtype - mainstepnumber: 2 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: deurtype0,9895200,000069
    [RenderValues] set query and/or replacements0,9895520,000032
    [RenderValues] Execute query0,9899170,000365
    QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}');
    SET @doorCat =   CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED);
    SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED);

    SELECT DISTINCT(door.height) AS hoogte
    FROM shop_products door
    JOIN shop_pro_cat spc ON spc.product_id = door.id
    JOIN shop_category doorCat ON doorCat.id = spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visibleDTM<>0

    LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass
    LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short
    LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id

    WHERE IF(@doorGlass>0, k.id IS NOT NULL, 1)
    AND door.visibleDTM<>0
    ORDER BY door.height
    0,9899730,000055
    Open connection with DB0,9900200,000047
    QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}');
    SET @doorCat =   CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED);
    SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED);

    SELECT DISTINCT(door.height) AS hoogte
    FROM shop_products door
    JOIN shop_pro_cat spc ON spc.product_id = door.id
    JOIN shop_category doorCat ON doorCat.id = spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visibleDTM<>0

    LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass
    LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short
    LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id

    WHERE IF(@doorGlass>0, k.id IS NOT NULL, 1)
    AND door.visibleDTM<>0
    ORDER BY door.height
    1,0091820,019162
    [RenderValues] Do last replacements. Num items: 01,0092300,000048
    [RenderValues] replacements done1,0092630,000034
    RenderStep (values rendered) Bepaal de afmeting connected to: deurtype - mainstepnumber: 2 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: deurtype1,0093040,000041
    [RenderValues] set query and/or replacements1,0093630,000059
    [RenderValues] Execute query1,0097300,000366
    QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}');
    SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED);
    SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED);
    SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED);
    SET @turnType = IF('{draairichting}' IN ('R2/L3', 'L3', 'R2', 'links'), 'links', 'rechts');
    SET @implementation = IF('{uitvoering}' IN('Buitendraaiend', 'Binnendraaiend', 'schuifdeur'), 'stomp', '{uitvoering}');
    SET @implementation = IF(@implementation='opdek', CONCAT(@implementation, ' ', @turnType) , @implementation);

    SELECT
    DISTINCT(door.width) AS breedte
    FROM shop_products door
    JOIN shop_pro_cat spc ON spc.product_id = door.id
    JOIN shop_category doorCat ON doorCat.id=spc.cat_id AND  doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visibleDTM<>0

    LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass
    LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short AND glass_avail .visibleDTM<>0
    LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id

    WHERE (door.producttype = @implementation OR door.producttype = CONCAT(@implementation, ' ', @turnType))
    AND door.height='{height}'
    #AND door.visibleDTM<>0
    AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visibleDTM, door.visibleDTMBranch) <> 0

    AND IF(@doorGlass > 0, k.id IS NOT NULL, 1)

    ORDER BY door.width
    1,0097550,000025
    Open connection with DB1,0098110,000056
    QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}');
    SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED);
    SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED);
    SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED);
    SET @turnType = IF('{draairichting}' IN ('R2/L3', 'L3', 'R2', 'links'), 'links', 'rechts');
    SET @implementation = IF('{uitvoering}' IN('Buitendraaiend', 'Binnendraaiend', 'schuifdeur'), 'stomp', '{uitvoering}');
    SET @implementation = IF(@implementation='opdek', CONCAT(@implementation, ' ', @turnType) , @implementation);

    SELECT
    DISTINCT(door.width) AS breedte
    FROM shop_products door
    JOIN shop_pro_cat spc ON spc.product_id = door.id
    JOIN shop_category doorCat ON doorCat.id=spc.cat_id AND  doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visibleDTM<>0

    LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass
    LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short AND glass_avail .visibleDTM<>0
    LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id

    WHERE (door.producttype = @implementation OR door.producttype = CONCAT(@implementation, ' ', @turnType))
    AND door.height='{height}'
    #AND door.visibleDTM<>0
    AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visibleDTM, door.visibleDTMBranch) <> 0

    AND IF(@doorGlass > 0, k.id IS NOT NULL, 1)

    ORDER BY door.width
    1,0311000,021289
    [RenderValues] Do last replacements. Num items: 01,0311450,000045
    [RenderValues] replacements done1,0311580,000013
    RenderSubStep Breedte_kopie connected to: hoogte - mainstepnumber: 2 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: hoogte1,0312000,000042
    No caching of lanuage 38. Because it is not changed within this session.1,0315480,000348
    Cache item 'ML_38' already exists, so language is not cached again1,0315920,000044
    Session 'MlJclLanguage' set to 381,0316070,000015
    Start replace dynamic content1,0316410,000034
    Replace dynamic content only once1,0317470,000107
    End replace dynamic content1,0317630,000015
    No caching of lanuage 38. Because it is not changed within this session.1,0321960,000433
    Cache item 'ML_38' already exists, so language is not cached again1,0322210,000025
    Session 'MlJclLanguage' set to 381,0322340,000013
    Start replace dynamic content1,0322800,000046
    Replace dynamic content only once1,0323840,000104
    End replace dynamic content1,0324010,000017
    [RenderValues] set query and/or replacements1,0324440,000043
    [RenderValues] Execute query1,0329200,000476
    QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}');
    SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED);
    SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED);
    SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED);
    SET @turnType = IF('{draairichting}' IN ('R2/L3', 'L3', 'R2', 'links'), 'links', 'rechts');
    SET @implementation = IF('{uitvoering}' IN('Buitendraaiend', 'Binnendraaiend', 'schuifdeur'), 'stomp', '{uitvoering}');
    SET @implementation = IF(@implementation='opdek', CONCAT(@implementation, ' ', @turnType) , @implementation);

    SELECT
    DISTINCT(door.width) AS breedte
    FROM shop_products door
    JOIN shop_pro_cat spc ON spc.product_id = door.id
    JOIN shop_category doorCat ON doorCat.id=spc.cat_id AND  doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visibleDTM<>0

    LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass
    LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short AND glass_avail .visibleDTM<>0
    LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id

    WHERE (door.producttype = @implementation OR door.producttype = CONCAT(@implementation, ' ', @turnType))
    AND door.height='{height}'
    #AND door.visibleDTM<>0
    AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visibleDTM, door.visibleDTMBranch) <> 0

    AND IF(@doorGlass > 0, k.id IS NOT NULL, 1)

    ORDER BY door.width
    1,0329530,000033
    Open connection with DB1,0329950,000042
    QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}');
    SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED);
    SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED);
    SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED);
    SET @turnType = IF('{draairichting}' IN ('R2/L3', 'L3', 'R2', 'links'), 'links', 'rechts');
    SET @implementation = IF('{uitvoering}' IN('Buitendraaiend', 'Binnendraaiend', 'schuifdeur'), 'stomp', '{uitvoering}');
    SET @implementation = IF(@implementation='opdek', CONCAT(@implementation, ' ', @turnType) , @implementation);

    SELECT
    DISTINCT(door.width) AS breedte
    FROM shop_products door
    JOIN shop_pro_cat spc ON spc.product_id = door.id
    JOIN shop_category doorCat ON doorCat.id=spc.cat_id AND  doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visibleDTM<>0

    LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass
    LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short AND glass_avail .visibleDTM<>0
    LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id

    WHERE (door.producttype = @implementation OR door.producttype = CONCAT(@implementation, ' ', @turnType))
    AND door.height='{height}'
    #AND door.visibleDTM<>0
    AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visibleDTM, door.visibleDTMBranch) <> 0

    AND IF(@doorGlass > 0, k.id IS NOT NULL, 1)

    ORDER BY door.width
    1,0538650,020871
    [RenderValues] Do last replacements. Num items: 01,0539130,000048
    [RenderValues] replacements done1,0539250,000012
    RenderSubStep Breedte_kopie connected to: hoogte - mainstepnumber: 2 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: hoogte1,0539680,000043
    No caching of lanuage 38. Because it is not changed within this session.1,0543220,000354
    Cache item 'ML_38' already exists, so language is not cached again1,0543620,000040
    Session 'MlJclLanguage' set to 381,0543780,000017
    Start replace dynamic content1,0544340,000055
    Replace dynamic content only once1,0545100,000076
    End replace dynamic content1,0545280,000018
    RenderStep Veiligheidspakket connected to: uitvoering;draairichting;hoogte;breedte; - mainstepnumber: 3 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte;1,0579910,003463
    [RenderValues] set query and/or replacements1,0580600,000069
    [RenderValues] Execute query1,0585710,000511
    QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}');
    SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED);
    SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED);
    SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED);

    SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}');
    SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', '{draairichting}','%'), CONCAT('%',@implementation,'%')));

    SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1);

    SELECT
    @doorId,
    p.id AS product_id,
        p.eancode,
         p.description_short AS description_short,
    IFNULL(p.serie, p.producttype) AS name,
       REPLACE(REPLACE(p.priceCando, '.',','), ',00', ',-')  AS price,
    spk.cat_id,
    sp.bestandsnaam,
    suitable_for,
    suitable_for2
    FROM shop_products p
    JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'veiligheidspakket'
    JOIN shop_pro_cat spk ON spk.product_id=p.id
    LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal'
    WHERE IFNULL(p.serie, p.producttype) = 'Veiligheidspakket'
    AND ( NULLIF(p.suitable_for2,'') IS NULL
    OR suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(@implementation, 'schuifdeur', 'schuif'), '%')
    ) AND
    # turntypes
    (suitable_for IS NULL OR suitable_for = 'ALLE' OR
    '{draairichting}' LIKE CONCAT('%', suitable_for , '%')
    OR (
    (SELECT suitable_for FROM shop_products WHERE eancode = '{draairichting}') LIKE CONCAT('%', suitable_for , '%')
    )
    )
    #AND p.visibleDTM<>0
    AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visibleDTM, p.visibleDTMBranch) <> 0

    ORDER BY name
    1,0586020,000031
    Open connection with DB1,0586490,000047
    QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}');
    SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED);
    SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED);
    SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED);

    SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}');
    SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', '{draairichting}','%'), CONCAT('%',@implementation,'%')));

    SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1);

    SELECT
    @doorId,
    p.id AS product_id,
        p.eancode,
         p.description_short AS description_short,
    IFNULL(p.serie, p.producttype) AS name,
       REPLACE(REPLACE(p.priceCando, '.',','), ',00', ',-')  AS price,
    spk.cat_id,
    sp.bestandsnaam,
    suitable_for,
    suitable_for2
    FROM shop_products p
    JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'veiligheidspakket'
    JOIN shop_pro_cat spk ON spk.product_id=p.id
    LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal'
    WHERE IFNULL(p.serie, p.producttype) = 'Veiligheidspakket'
    AND ( NULLIF(p.suitable_for2,'') IS NULL
    OR suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(@implementation, 'schuifdeur', 'schuif'), '%')
    ) AND
    # turntypes
    (suitable_for IS NULL OR suitable_for = 'ALLE' OR
    '{draairichting}' LIKE CONCAT('%', suitable_for , '%')
    OR (
    (SELECT suitable_for FROM shop_products WHERE eancode = '{draairichting}') LIKE CONCAT('%', suitable_for , '%')
    )
    )
    #AND p.visibleDTM<>0
    AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visibleDTM, p.visibleDTMBranch) <> 0

    ORDER BY name
    1,0832920,024644
    [RenderValues] Do last replacements. Num items: 01,0833470,000055
    [RenderValues] replacements done1,0833630,000016
    RenderStep (values rendered) Veiligheidspakket connected to: uitvoering;draairichting;hoogte;breedte; - mainstepnumber: 3 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte;1,0834230,000060
    [RenderValues] set query and/or replacements1,0835160,000093
    RenderSubStep  connected to:  - mainstepnumber: 3 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: 1,0835410,000025
    No caching of lanuage 38. Because it is not changed within this session.1,0838810,000340
    Cache item 'ML_38' already exists, so language is not cached again1,0839220,000041
    Session 'MlJclLanguage' set to 381,0839370,000015
    Start replace dynamic content1,0839690,000032
    Replace dynamic content only once1,0840750,000106
    End replace dynamic content1,0840960,000021
    No caching of lanuage 38. Because it is not changed within this session.1,0844840,000388
    Cache item 'ML_38' already exists, so language is not cached again1,0845060,000021
    Session 'MlJclLanguage' set to 381,0845200,000014
    Start replace dynamic content1,0845380,000018
    Replace dynamic content only once1,0845880,000051
    End replace dynamic content1,0845980,000010
    [RenderValues] set query and/or replacements1,0846170,000019
    RenderSubStep  connected to:  - mainstepnumber: 3 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: 1,0846300,000013
    No caching of lanuage 38. Because it is not changed within this session.1,0847670,000137
    Cache item 'ML_38' already exists, so language is not cached again1,0847800,000013
    Session 'MlJclLanguage' set to 381,0847910,000011
    Start replace dynamic content1,0848060,000015
    Replace dynamic content only once1,0848590,000053
    End replace dynamic content1,0848690,000010
    RenderStep Driepuntssluiting (alleen bij geen veiligheidspakket) connected to: veiligheidspakket;uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: veiligheidspakket;uitvoering;draairichting;hoogte;breedte1,0849010,000031
    [RenderValues] set query and/or replacements1,0849190,000018
    [RenderValues] Execute query1,0852040,000285
    QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}');
    SET @doorCat =     CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED);
    SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED);
    SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED);

    SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}');
    SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', '{draairichting}','%'), CONCAT('%',@implementation,'%')));

    SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1);
    SET @isIndustrial = (SELECT IF(COUNT(*)>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%');
    SET @isDouble = IF('{dubbel}' = 'Ja', true, false);
    SET @results = false;

    SELECT * FROM (
    SELECT 'Geen driepuntsluiting' AS valuelist_1, 0 AS valuelist_2, 0 AS valuelist_3, 0 AS result

    UNION

    SELECT
    IF(p.serie LIKE '%sleutel%','Sleutelbediend','Krukbediend'),
    IF(p.serie LIKE '%sleutel%','sleutelbediend','krukbediend'),
    p.id,
    GREATEST(@results := true, -1) AS result
    FROM shop_products p
    JOIN shop_koppeling k ON k.prod_source=p.id AND k.prod_dest = @doorId AND k.koppeltype = 'Driepuntssluiting'
    WHERE ( NULLIF(p.suitable_for2,'') IS NULL
    OR suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(@implementation, 'schuifdeur', 'schuif'), '%')
    ) AND
    # turntypes
     (suitable_for IS NULL OR suitable_for = 'ALLE' OR
    REPLACE(REPLACE('{draairichting}', 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', suitable_for , '%')
    OR
    #inverted
    suitable_for LIKE CONCAT('%', REPLACE(REPLACE('{draairichting}', 'links', 'R2/L3'), 'rechts', 'L1/R4') , '%')
    OR (
    (SELECT suitable_for FROM shop_products WHERE eancode = '{draairichting}') LIKE CONCAT('%', suitable_for , '%')
    )
    )  
    #AND p.visibleDTM<>0
       AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visibleDTM, p.visibleDTMBranch) <> 0
    GROUP BY p.id
    ) res
    WHERE '{veiligheidspakketJanee}'<>'Ja' AND @results
    1,0852250,000021
    Open connection with DB1,0852720,000047
    QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}');
    SET @doorCat =     CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED);
    SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED);
    SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED);

    SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}');
    SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', '{draairichting}','%'), CONCAT('%',@implementation,'%')));

    SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1);
    SET @isIndustrial = (SELECT IF(COUNT(*)>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%');
    SET @isDouble = IF('{dubbel}' = 'Ja', true, false);
    SET @results = false;

    SELECT * FROM (
    SELECT 'Geen driepuntsluiting' AS valuelist_1, 0 AS valuelist_2, 0 AS valuelist_3, 0 AS result

    UNION

    SELECT
    IF(p.serie LIKE '%sleutel%','Sleutelbediend','Krukbediend'),
    IF(p.serie LIKE '%sleutel%','sleutelbediend','krukbediend'),
    p.id,
    GREATEST(@results := true, -1) AS result
    FROM shop_products p
    JOIN shop_koppeling k ON k.prod_source=p.id AND k.prod_dest = @doorId AND k.koppeltype = 'Driepuntssluiting'
    WHERE ( NULLIF(p.suitable_for2,'') IS NULL
    OR suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(@implementation, 'schuifdeur', 'schuif'), '%')
    ) AND
    # turntypes
     (suitable_for IS NULL OR suitable_for = 'ALLE' OR
    REPLACE(REPLACE('{draairichting}', 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', suitable_for , '%')
    OR
    #inverted
    suitable_for LIKE CONCAT('%', REPLACE(REPLACE('{draairichting}', 'links', 'R2/L3'), 'rechts', 'L1/R4') , '%')
    OR (
    (SELECT suitable_for FROM shop_products WHERE eancode = '{draairichting}') LIKE CONCAT('%', suitable_for , '%')
    )
    )  
    #AND p.visibleDTM<>0
       AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visibleDTM, p.visibleDTMBranch) <> 0
    GROUP BY p.id
    ) res
    WHERE '{veiligheidspakketJanee}'<>'Ja' AND @results
    1,1108640,025592
    [RenderValues] Do last replacements. Num items: 01,1109110,000047
    [RenderValues] replacements done1,1109200,000009
    RenderStep (values rendered) Driepuntssluiting (alleen bij geen veiligheidspakket) connected to: veiligheidspakket;uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: veiligheidspakket;uitvoering;draairichting;hoogte;breedte1,1109570,000037
    [RenderValues] set query and/or replacements1,1110210,000063
    RenderSubStep  connected to:  - mainstepnumber: 3 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: 1,1110410,000020
    No caching of lanuage 38. Because it is not changed within this session.1,1112800,000239
    Cache item 'ML_38' already exists, so language is not cached again1,1113140,000034
    Session 'MlJclLanguage' set to 381,1113270,000013
    Start replace dynamic content1,1113480,000021
    Replace dynamic content only once1,1114110,000064
    End replace dynamic content1,1114240,000012
    No caching of lanuage 38. Because it is not changed within this session.1,1117880,000365
    Cache item 'ML_38' already exists, so language is not cached again1,1118280,000039
    Session 'MlJclLanguage' set to 381,1118660,000038
    Start replace dynamic content1,1118970,000032
    Replace dynamic content only once1,1119990,000102
    End replace dynamic content1,1120120,000013
    [RenderValues] set query and/or replacements1,1120340,000022
    RenderSubStep  connected to:  - mainstepnumber: 3 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: 1,1120450,000011
    No caching of lanuage 38. Because it is not changed within this session.1,1122500,000206
    Cache item 'ML_38' already exists, so language is not cached again1,1122740,000024
    Session 'MlJclLanguage' set to 381,1123040,000030
    Start replace dynamic content1,1123220,000018
    Replace dynamic content only once1,1123710,000049
    End replace dynamic content1,1123820,000011
    RenderStep Slotgatfrezing (bij geen driepuntsluiting) nieuw connected to: driepuntsluiting;veiligheidspakket;uitvoering;breedte;hoogte - mainstepnumber: 3 - stepnumber: 3 - dependentvalue: 1 - datasource connectedid: driepuntsluiting;veiligheidspakket;uitvoering;breedte;hoogte1,1124210,000039
    [RenderValues] set query and/or replacements1,1124340,000013
    [RenderValues] Execute query1,1129560,000522
    QUERY SYSCON START: # Keep this query the same in ALL configurators for the "Accessoires" STEP!!!

    SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}');
    SET @doorCat =     CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED);
    SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED);
    SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED);

    SET @implementation =  IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}');
    SET @turntype =  IF('{draairichting}' LIKE '{%}', '','{draairichting}');
    SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', @turntype,'%'), CONCAT('%',@implementation,'%')));

    SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1);

    SET @isIndustrial = (SELECT IF(COUNT(*)>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%');
    SET @isDouble = IF('{dubbel}' = 'Ja', true, false);


    SELECT
    @doorId,
    IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%', '2x ','') AS ammountPrefix,
    IFNULL(info.html, '') AS info,
    p.id AS product_id,
       CONCAT(IF(@isDouble, ' ', ''), p.description_short) AS product_description,
    IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', ''))) AS product_name,
       REPLACE(REPLACE(p.priceDTM * IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%',2,1), '.',','), ',00', ',-')  AS price,
       'images/prod-scharnieren.png' AS product_image,
    spk.cat_id,
    IFNULL(sp.bestandsnaam, '') AS bestandsnaam,
    p.suitable_for,
    p.suitable_for2
    FROM shop_products p
    JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'service'
    JOIN shop_pro_cat spk ON spk.product_id=p.id #AND spk.cat_id IN(2386)# CAT (accessoires)
    LEFT JOIN easy_webpages info ON info.seoname = CONCAT('uitleg-', IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', ''))))
    LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal'

    WHERE (NULLIF(p.suitable_for2,'') IS NULL
    OR p.suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(LOWER(@implementation), 'schuifdeur', 'schuif'), '%')
    ) AND
    # turntypes
     (p.suitable_for IS NULL OR p.suitable_for = 'ALLE' OR
    REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', p.suitable_for , '%') OR
    # reversed
    p.suitable_for LIKE CONCAT('%', REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') , '%')
    OR (
    (SELECT suitable_for FROM shop_products WHERE eancode = @turntype) LIKE CONCAT('%', p.suitable_for , '%')
    )
    ) AND ('{driepuntssluiting}' = '0' OR  '{driepuntssluiting}' LIKE '{%}')  AND '{veiligheidspakketJanee}' <> 'Ja' AND  p.producttype='slotgatfrezing'
    #AND p.visibleDTM<>0
    AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visibleDTM, p.visibleDTMBranch) <> 0

    GROUP BY p.id
    ORDER BY product_name
    1,1129900,000033
    Open connection with DB1,1130520,000063
    QUERY SYSCON END: # Keep this query the same in ALL configurators for the "Accessoires" STEP!!!

    SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}');
    SET @doorCat =     CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED);
    SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED);
    SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED);

    SET @implementation =  IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}');
    SET @turntype =  IF('{draairichting}' LIKE '{%}', '','{draairichting}');
    SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', @turntype,'%'), CONCAT('%',@implementation,'%')));

    SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1);

    SET @isIndustrial = (SELECT IF(COUNT(*)>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%');
    SET @isDouble = IF('{dubbel}' = 'Ja', true, false);


    SELECT
    @doorId,
    IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%', '2x ','') AS ammountPrefix,
    IFNULL(info.html, '') AS info,
    p.id AS product_id,
       CONCAT(IF(@isDouble, ' ', ''), p.description_short) AS product_description,
    IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', ''))) AS product_name,
       REPLACE(REPLACE(p.priceDTM * IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%',2,1), '.',','), ',00', ',-')  AS price,
       'images/prod-scharnieren.png' AS product_image,
    spk.cat_id,
    IFNULL(sp.bestandsnaam, '') AS bestandsnaam,
    p.suitable_for,
    p.suitable_for2
    FROM shop_products p
    JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'service'
    JOIN shop_pro_cat spk ON spk.product_id=p.id #AND spk.cat_id IN(2386)# CAT (accessoires)
    LEFT JOIN easy_webpages info ON info.seoname = CONCAT('uitleg-', IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', ''))))
    LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal'

    WHERE (NULLIF(p.suitable_for2,'') IS NULL
    OR p.suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(LOWER(@implementation), 'schuifdeur', 'schuif'), '%')
    ) AND
    # turntypes
     (p.suitable_for IS NULL OR p.suitable_for = 'ALLE' OR
    REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', p.suitable_for , '%') OR
    # reversed
    p.suitable_for LIKE CONCAT('%', REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') , '%')
    OR (
    (SELECT suitable_for FROM shop_products WHERE eancode = @turntype) LIKE CONCAT('%', p.suitable_for , '%')
    )
    ) AND ('{driepuntssluiting}' = '0' OR  '{driepuntssluiting}' LIKE '{%}')  AND '{veiligheidspakketJanee}' <> 'Ja' AND  p.producttype='slotgatfrezing'
    #AND p.visibleDTM<>0
    AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visibleDTM, p.visibleDTMBranch) <> 0

    GROUP BY p.id
    ORDER BY product_name
    1,1355600,022507
    [RenderValues] Do last replacements. Num items: 01,1356130,000053
    [RenderValues] replacements done1,1356260,000013
    RenderStep (values rendered) Slotgatfrezing (bij geen driepuntsluiting) nieuw connected to: driepuntsluiting;veiligheidspakket;uitvoering;breedte;hoogte - mainstepnumber: 3 - stepnumber: 3 - dependentvalue: 1 - datasource connectedid: driepuntsluiting;veiligheidspakket;uitvoering;breedte;hoogte1,1356730,000047
    [RenderValues] set query and/or replacements1,1357540,000081
    RenderSubStep  connected to:  - mainstepnumber: 3 - stepnumber: 3 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: 1,1357720,000018
    No caching of lanuage 38. Because it is not changed within this session.1,1360470,000275
    Cache item 'ML_38' already exists, so language is not cached again1,1361020,000055
    Session 'MlJclLanguage' set to 381,1361220,000020
    Start replace dynamic content1,1361500,000028
    Replace dynamic content only once1,1362280,000078
    End replace dynamic content1,1362420,000013
    No caching of lanuage 38. Because it is not changed within this session.1,1367410,000499
    Cache item 'ML_38' already exists, so language is not cached again1,1367690,000028
    Session 'MlJclLanguage' set to 381,1367840,000016
    Start replace dynamic content1,1368080,000024
    Replace dynamic content only once1,1368960,000088
    End replace dynamic content1,1369130,000017
    [RenderValues] set query and/or replacements1,1369470,000034
    RenderSubStep  connected to:  - mainstepnumber: 3 - stepnumber: 3 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: 1,1370020,000055
    No caching of lanuage 38. Because it is not changed within this session.1,1372740,000272
    Cache item 'ML_38' already exists, so language is not cached again1,1373020,000028
    Session 'MlJclLanguage' set to 381,1373170,000015
    Start replace dynamic content1,1373380,000021
    Replace dynamic content only once1,1374050,000066
    End replace dynamic content1,1374180,000013
    RenderStep Accessoires connected to: uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 4 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte1,1374620,000044
    [RenderValues] set query and/or replacements1,1374890,000027
    [RenderValues] Execute query1,1380300,000541
    QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}');
    SET @doorCat =     CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED);
    SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED);
    SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED);

    SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}');
    SET @turntype = IF('{draairichting}' LIKE '{%}', '','{draairichting}');
    SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', @turntype,'%'), CONCAT('%',@implementation,'%')));

    SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1);

    SET @isIndustrial = (SELECT IF(COUNT(*)>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%');
    SET @isDouble = IF('{dubbel}' = 'Ja', true, false);


    SELECT
    @doorId,
    IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%', '2x ','') AS ammountPrefix,
    #IFNULL(info.html, '') AS info,
    p.usp_s AS info,
    p.id AS product_id,
       CONCAT(IF(@isDouble, ' ', ''), p.description_short) AS product_description,
    LOWER(IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) AS product_name,
       REPLACE(REPLACE(IFNULL(SUM(innerProducts.priceDTM), p.priceDTM) * IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%',2,1), '.',','), ',00', ',-')  AS price,
       'images/prod-scharnieren.png' AS product_image,
    spk.cat_id,
    IFNULL(MIN(spi.bestandsnaam), sp.bestandsnaam) AS bestandsnaam,
    p.suitable_for,
    p.suitable_for2
    FROM shop_products p
    JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype IN ('accessoire', 'accessoirepakket')
    JOIN shop_pro_cat spk ON spk.product_id=p.id #AND spk.cat_id IN(2386)# CAT (accessoires)
    LEFT JOIN easy_webpages info ON info.seoname = CONCAT('uitleg-', IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', ''))))
    LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal'

    LEFT JOIN shop_koppeling k2 ON k2.prod_dest = k.prod_source AND k2.koppeltype='accessoire' # schuifsysteem
    LEFT JOIN shop_products innerProducts ON innerProducts.id=k2.prod_source
    LEFT JOIN shop_pictures spi ON spi.product_id=innerProducts.id AND spi.formaatnaam='normaal'

    WHERE (NULLIF(p.suitable_for2,'') IS NULL
    OR p.suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(LOWER(@implementation), 'schuifdeur', 'schuif'), '%')
    ) AND
    # turntypes
     (p.suitable_for IS NULL OR p.suitable_for = 'ALLE' OR
    REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', p.suitable_for , '%')
    OR (
    (SELECT suitable_for FROM shop_products WHERE eancode = @turntype) LIKE CONCAT('%', p.suitable_for , '%')
    )
    )
    #AND p.visibleDTM<>0
    AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visibleDTM, p.visibleDTMBranch) <> 0

    GROUP BY p.id
    ORDER BY product_name
    1,1380650,000035
    Open connection with DB1,1381470,000082
    QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}');
    SET @doorCat =     CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED);
    SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED);
    SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED);

    SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}');
    SET @turntype = IF('{draairichting}' LIKE '{%}', '','{draairichting}');
    SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', @turntype,'%'), CONCAT('%',@implementation,'%')));

    SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1);

    SET @isIndustrial = (SELECT IF(COUNT(*)>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%');
    SET @isDouble = IF('{dubbel}' = 'Ja', true, false);


    SELECT
    @doorId,
    IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%', '2x ','') AS ammountPrefix,
    #IFNULL(info.html, '') AS info,
    p.usp_s AS info,
    p.id AS product_id,
       CONCAT(IF(@isDouble, ' ', ''), p.description_short) AS product_description,
    LOWER(IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) AS product_name,
       REPLACE(REPLACE(IFNULL(SUM(innerProducts.priceDTM), p.priceDTM) * IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%',2,1), '.',','), ',00', ',-')  AS price,
       'images/prod-scharnieren.png' AS product_image,
    spk.cat_id,
    IFNULL(MIN(spi.bestandsnaam), sp.bestandsnaam) AS bestandsnaam,
    p.suitable_for,
    p.suitable_for2
    FROM shop_products p
    JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype IN ('accessoire', 'accessoirepakket')
    JOIN shop_pro_cat spk ON spk.product_id=p.id #AND spk.cat_id IN(2386)# CAT (accessoires)
    LEFT JOIN easy_webpages info ON info.seoname = CONCAT('uitleg-', IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', ''))))
    LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal'

    LEFT JOIN shop_koppeling k2 ON k2.prod_dest = k.prod_source AND k2.koppeltype='accessoire' # schuifsysteem
    LEFT JOIN shop_products innerProducts ON innerProducts.id=k2.prod_source
    LEFT JOIN shop_pictures spi ON spi.product_id=innerProducts.id AND spi.formaatnaam='normaal'

    WHERE (NULLIF(p.suitable_for2,'') IS NULL
    OR p.suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(LOWER(@implementation), 'schuifdeur', 'schuif'), '%')
    ) AND
    # turntypes
     (p.suitable_for IS NULL OR p.suitable_for = 'ALLE' OR
    REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', p.suitable_for , '%')
    OR (
    (SELECT suitable_for FROM shop_products WHERE eancode = @turntype) LIKE CONCAT('%', p.suitable_for , '%')
    )
    )
    #AND p.visibleDTM<>0
    AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visibleDTM, p.visibleDTMBranch) <> 0

    GROUP BY p.id
    ORDER BY product_name
    1,1611890,023042
    [RenderValues] Do last replacements. Num items: 01,1612530,000064
    [RenderValues] replacements done1,1612670,000014
    RenderStep (values rendered) Accessoires connected to: uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 4 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte1,1613070,000040
    [RenderValues] set query and/or replacements1,1613820,000076
    RenderSubStep  connected to:  - mainstepnumber: 3 - stepnumber: 4 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: 1,1614140,000032
    No caching of lanuage 38. Because it is not changed within this session.1,1618060,000392
    Cache item 'ML_38' already exists, so language is not cached again1,1618960,000090
    Session 'MlJclLanguage' set to 381,1619260,000030
    Start replace dynamic content1,1619650,000039
    Replace dynamic content only once1,1620450,000080
    End replace dynamic content1,1620560,000011
    No caching of lanuage 38. Because it is not changed within this session.1,1623700,000315
    Cache item 'ML_38' already exists, so language is not cached again1,1624010,000031
    Session 'MlJclLanguage' set to 381,1624270,000025
    Start replace dynamic content1,1624540,000028
    Replace dynamic content only once1,1625520,000098
    End replace dynamic content1,1625650,000013
    [RenderValues] set query and/or replacements1,1625870,000022
    RenderSubStep  connected to:  - mainstepnumber: 3 - stepnumber: 4 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: 1,1625990,000012
    No caching of lanuage 38. Because it is not changed within this session.1,1627530,000154
    Cache item 'ML_38' already exists, so language is not cached again1,1628420,000090
    Session 'MlJclLanguage' set to 381,1628590,000016
    Start replace dynamic content1,1628760,000017
    Replace dynamic content only once1,1629290,000053
    End replace dynamic content1,1629400,000011
    No caching of lanuage 38. Because it is not changed within this session.1,1663970,003457
    Cache item 'ML_38' already exists, so language is not cached again1,1664570,000061
    Session 'MlJclLanguage' set to 381,1664870,000030
    Start replace dynamic content1,1670870,000600
    Replace dynamic content only once1,1679190,000832
    End replace dynamic content1,1679340,000015
    Start replacing system objects1,1679410,000007
    Start replacing translation1,1716770,003735
    Start replacing objects1,1719020,000225
    Start replacing request1,1721440,000243
    Start replacing session1,2301340,057990
    Start replacing standards1,2348700,004736
    Start replacing objecs again1,2353070,000437
    aspx.pageEnd Render1,2540840,018777

    Control Tree

    Control UniqueIDTypeRender Size Bytes (including children)ViewState Size Bytes (excluding children)ControlState Size Bytes (excluding children)
    __PageASP.homepage_aspx12303000
        ctl00System.Web.UI.HtmlControls.HtmlHead106800
            ctl01System.Web.UI.HtmlControls.HtmlMeta2400
            ctl02System.Web.UI.HtmlControls.HtmlMeta7000
            ctl03System.Web.UI.HtmlControls.HtmlMeta4500
            LiteralTagmanagerCodeSystem.Web.UI.WebControls.Literal8400
            ctl08System.Web.UI.LiteralControl8600
            ctl04System.Web.UI.HtmlControls.HtmlTitle5100
            ctl05System.Web.UI.HtmlControls.HtmlGenericControl46400
                ctl09System.Web.UI.LiteralControl42400
            ctl06System.Web.UI.HtmlControls.HtmlLink11500
            ctl07System.Web.UI.HtmlControls.HtmlGenericControl11600
        LoginCJuiceControlLibrary.LoginControl2400

    Session State

    Session KeyTypeValue
    JCLSEOURLSystem.String 
    JCLSEOURLWQSSystem.String 
    JCLSEOURLQSSystem.String 
    JuiceControlCustIdSystem.Int32290
    MlJclLanguageSystem.Int3238

    Application State

    Application KeyTypeValue

    Request Cookies Collection

    NameValueSize

    Response Cookies Collection

    NameValueSize
    ASP.NET_SessionIdxjasie5gwbsih0lrtebhfgci42

    Headers Collection

    NameValue
    Connectionclose
    Content-Length0
    Accepttext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    Accept-Encodingbr,gzip
    Accept-Languageen-US,en;q=0.5
    Hostconfigurator-dtm-cando.happygeeks.dev
    If-Modified-SinceMon, 27 Sep 2021 20:17:50 GMT
    User-AgentCCBot/2.0 (https://commoncrawl.org/faq/)
    X-Forwarded-Protohttp
    X-Forwarded-For18.204.2.231

    Response Headers Collection

    NameValue
    Set-CookieASP.NET_SessionId=xjasie5gwbsih0lrtebhfgci; path=/; secure; HttpOnly; SameSite=Lax
    Cache-Controlprivate
    Content-Typetext/html

    Form Collection

    NameValue

    Querystring Collection

    NameValue
    configuratorachterdeuren

    Server Variables

    NameValue
    ALL_HTTPHTTP_CONNECTION:close HTTP_CONTENT_LENGTH:0 HTTP_ACCEPT:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 HTTP_ACCEPT_ENCODING:br,gzip HTTP_ACCEPT_LANGUAGE:en-US,en;q=0.5 HTTP_HOST:configurator-dtm-cando.happygeeks.dev HTTP_IF_MODIFIED_SINCE:Mon, 27 Sep 2021 20:17:50 GMT HTTP_USER_AGENT:CCBot/2.0 (https://commoncrawl.org/faq/) HTTP_X_FORWARDED_PROTO:http HTTP_X_FORWARDED_FOR:18.204.2.231
    ALL_RAWConnection: close Content-Length: 0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Encoding: br,gzip Accept-Language: en-US,en;q=0.5 Host: configurator-dtm-cando.happygeeks.dev If-Modified-Since: Mon, 27 Sep 2021 20:17:50 GMT User-Agent: CCBot/2.0 (https://commoncrawl.org/faq/) X-Forwarded-Proto: http X-Forwarded-For: 18.204.2.231
    APPL_MD_PATH/LM/W3SVC/22/ROOT
    APPL_PHYSICAL_PATHC:\inetpub\wwwroot\configurator-cando - LIVE\
    AUTH_TYPE 
    AUTH_USER 
    AUTH_PASSWORD 
    LOGON_USER 
    REMOTE_USER 
    CERT_COOKIE 
    CERT_FLAGS 
    CERT_ISSUER 
    CERT_KEYSIZE 
    CERT_SECRETKEYSIZE 
    CERT_SERIALNUMBER 
    CERT_SERVER_ISSUER 
    CERT_SERVER_SUBJECT 
    CERT_SUBJECT 
    CONTENT_LENGTH0
    CONTENT_TYPE 
    GATEWAY_INTERFACECGI/1.1
    HTTPSoff
    HTTPS_KEYSIZE 
    HTTPS_SECRETKEYSIZE 
    HTTPS_SERVER_ISSUER 
    HTTPS_SERVER_SUBJECT 
    INSTANCE_ID22
    INSTANCE_META_PATH/LM/W3SVC/22
    LOCAL_ADDR136.144.214.155
    PATH_INFO/homepage.aspx
    PATH_TRANSLATEDC:\inetpub\wwwroot\configurator-cando - LIVE\homepage.aspx
    QUERY_STRINGconfigurator=achterdeuren
    REMOTE_ADDR136.144.151.253
    REMOTE_HOST136.144.151.253
    REMOTE_PORT19868
    REQUEST_METHODGET
    SCRIPT_NAME/homepage.aspx
    SERVER_NAMEconfigurator-dtm-cando.happygeeks.dev
    SERVER_PORT80
    SERVER_PORT_SECURE0
    SERVER_PROTOCOLHTTP/1.1
    SERVER_SOFTWAREMicrosoft-IIS/10.0
    URL/homepage.aspx
    HTTP_CONNECTIONclose
    HTTP_CONTENT_LENGTH0
    HTTP_ACCEPTtext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    HTTP_ACCEPT_ENCODINGbr,gzip
    HTTP_ACCEPT_LANGUAGEen-US,en;q=0.5
    HTTP_HOSTconfigurator-dtm-cando.happygeeks.dev
    HTTP_IF_MODIFIED_SINCEMon, 27 Sep 2021 20:17:50 GMT
    HTTP_USER_AGENTCCBot/2.0 (https://commoncrawl.org/faq/)
    HTTP_X_FORWARDED_PROTOhttp
    HTTP_X_FORWARDED_FOR18.204.2.231

    Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.3770.0