| Query Template: /home/www/default/cfc/select.cfc Execution Time: 8 ms Record Count: 0 Cached: No Lazy: No SQL: SELECT app.app_id ,app.app_groupid ,CASE when app.app_id != app.app_groupID THEN ( SELECT app_name FROM application WHERE app_id = app.app_groupID ) ELSE app.app_name END AS app_groupname ,app.app_name ,CASE WHEN dom.dom_name IS NOT NULL THEN 'cae.woonmatchwestfriesland.nl' ELSE app.app_domain END AS app_domain ,app.app_title ,app.app_metakeywords ,app.app_metadescription ,app.app_contactemail ,app.app_systemmail ,app.app_default_days ,app.app_default_option ,app.app_default_optionday ,app.app_default_optiontime ,app.app_default_showday ,app.app_default_showtime ,app.app_default_reactday ,app.app_default_reacttime ,app.app_default_reactions ,app.app_active ,app.app_include ,app.app_dateformat ,app.app_addthiscode ,app.app_mailfromname ,app.app_forwardtomail ,app.app_payment ,app.app_payment ,app.app_memoImportForUser ,app.app_searchDateFormat ,app.app_sto_id ,app.app_connector_wn ,app.app_daily ,app.app_lock ,app.app_financialQuestions ,app.app_paidoffer ,app.app_countpreinvite ,app.app_partnerrequired ,app.app_automaticIncome ,app.app_automaticAssign ,app.app_automaticAssignPool ,app.app_automaticAssignFill ,app.app_hasOptionLetters ,app.app_badDocDenied ,app.app_gotroot_2fa ,app.app_prerequiredocs ,app.app_payment_renewal ,app.app_payment_r_period ,app.app_payment_r_inperiod_cost ,app.app_payment_r_outperiod_cost ,app.app_payment_r_removal ,app.app_payment_r_letter_one ,app.app_payment_r_letter_two ,app.app_payment_partner_free ,app.app_refusal_action ,app.app_noreaction_action ,app.app_doc_zip_email ,app.app_reactrefuse_start ,app.app_extraspecial ,app.app_extraspecial_spoed ,app.app_uta ,app.app_rmw ,app.app_woonzorg ,app.app_areas ,app.app_letterqueue ,app.app_segmentizePartners ,app.app_vera ,app.app_sg_partition ,app.app_studentify ,app.app_oostzaan ,app.app_pubsub ,app.app_incomplete_start ,app.app_sg_template ,app.app_gotroot_sso_only ,app.app_report_portal ,app_reset_password ,app_sso_part ,app_2fa_front ,app_has_external_api ,dom.dom_name ,dom.dom_ssl ,dom.dom_googlemapskey ,dom.dom_redirecttodefault ,dom.dom_splash ,dom.dom_type ,dom.dom_cookie ,dom.dom_shibboleth ,dom.dom_sendgrid_key ,'cdnpath' = 's3://' + sto.sto_accesskey + ':' + sto.sto_secretkey + '@' + 's3.amazonaws.com/' + sto.sto_bucket + '/' ,'cdndistribution' = sto.sto_cdn ,'cdnprivate' = sto.sto_cdnprivate ,IIF(dom.dom_type = 'cae', 0, 1) isProd ,iws.iws_username ,iws.iws_password ,iws.iws_path ,(SELECT jwt FROM jwt_keys WHERE type = 'jwt_general') as jwt_general ,(SELECT jwt FROM jwt_keys WHERE type = 'jwt_sso') as jwt_sso ,(SELECT jwt FROM jwt_keys WHERE type = 'jwt_mailconfirm') as jwt_mailconfirm ,(SELECT jwt FROM jwt_keys WHERE type = 'jwt_admin') as jwt_admin FROM application app INNER JOIN storage sto ON sto.sto_id = app.app_sto_id LEFT JOIN domain dom ON dom.dom_app_id = app.app_id AND dom.dom_active = 1 LEFT JOIN intrawis iws ON iws.iws_app_id = app.app_id WHERE app.app_active = 1 AND ( dom.dom_name = 'cae.woonmatchwestfriesland.nl' ) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| app_id | app_groupid | app_groupname | app_name | app_domain | app_title | app_metakeywords | app_metadescription | app_contactemail | app_systemmail | app_default_days | app_default_option | app_default_optionday | app_default_optiontime | app_default_showday | app_default_showtime | app_default_reactday | app_default_reacttime | app_default_reactions | app_active | app_include | app_dateformat | app_addthiscode | app_mailfromname | app_forwardtomail | app_payment | app_memoImportForUser | app_searchDateFormat | app_sto_id | app_connector_wn | app_daily | app_lock | app_financialQuestions | app_paidoffer | app_countpreinvite | app_partnerrequired | app_automaticIncome | app_automaticAssign | app_automaticAssignPool | app_automaticAssignFill | app_hasOptionLetters | app_badDocDenied | app_gotroot_2fa | app_prerequiredocs | app_payment_renewal | app_payment_r_period | app_payment_r_inperiod_cost | app_payment_r_outperiod_cost | app_payment_r_removal | app_payment_r_letter_one | app_payment_r_letter_two | app_payment_partner_free | app_refusal_action | app_noreaction_action | app_doc_zip_email | app_reactrefuse_start | app_extraspecial | app_extraspecial_spoed | app_uta | app_rmw | app_woonzorg | app_areas | app_letterqueue | app_segmentizePartners | app_vera | app_sg_partition | app_studentify | app_oostzaan | app_pubsub | app_incomplete_start | app_sg_template | app_gotroot_sso_only | app_report_portal | app_reset_password | app_sso_part | app_2fa_front | app_has_external_api | dom_name | dom_ssl | dom_googlemapskey | dom_redirecttodefault | dom_splash | dom_type | dom_cookie | dom_shibboleth | dom_sendgrid_key | cdnpath | cdndistribution | cdnprivate | isProd | iws_username | iws_password | iws_path | jwt_general | jwt_sso | jwt_mailconfirm | jwt_admin | ||