;with CTE_CORP as
(
SELECT id_corp
FROM T_CORP
WHERE
f_corp_domain = 'site2zp.mpstaging.ch'
OR f_corp_domain = 'site2zp.mpstaging.ch'
OR f_corp_domain2 = 'site2zp.mpstaging.ch'
OR f_corp_domain2 = 'site2zp.mpstaging.ch'
)
SELECT id_corp,f_corp_name,f_corp_domain,f_corp_cug,f_corp_shop,f_corp_wettbewerb,f_corp_locator,f_corp_gb,f_corp_bildstreifen,f_corp_fachhandel_sport,
f_corp_portrait,f_corp_published,f_corp_construction,f_corp_mailingfrom,t_corp.m_insr_date,j_area,f_corpfolder_layout,f_corpfolder_name,f_corpfolder_col2width,
f_corpfolder_col3width,f_corpfolder_tablewidth,f_corpfolder_greeting1,f_corpmeta_author,f_corpmeta_publisher,f_corpmeta_Copyright,f_corpmeta_pagetype,
f_corpmeta_pagetopic,f_corpmeta_audience,f_corpmeta_language,f_corpmeta_Robots,f_corpmeta_revisit,f_corp_pageeditor,f_corp_wwwcall,f_corp_grusskarte,
f_corp_newsletter_katalog,f_corp_formds,f_corp_hasPDFTracking,f_corp_highslideEnlargeImage,f_corp_highslideSquare,f_corp_highslideLightBox,f_corp_filemanager,
f_corp_mediamanager,f_corp_hasCatView,f_corp_hasMobileSite,f_corp_hasFancyLink,f_corp_hasGeotargeting,f_corp_hasGeotargetingRegion,f_corp_highslideOnMouseOver,
f_corp_hasInlineEntryList,f_corp_inlineCompatibleMode,f_corp_useSEO,f_corp_SEOExtension,f_corp_SEOType,f_corp_hasCKFinder,f_corp_hasCKEditor,f_corp_useAppBuilderLogin,f_corp_AppBuilderLoginConf,f_corp_hasImgMenu,
ISNULL(F_CORP_ARCHIV,0) as f_corp_archiv,
f_corp_domain3 as lucee_testlink,F_CORP_HASGRIDMODE,
f_corp_runningOnLucee
,ISNULL(f_corp_useSEOBACKEND,0) as f_corp_useSEOBackend
,ISNULL(f_corp_SSL,0) as f_corp_SSL
,ISNULL(f_corp_dsgvoCookie,0) as f_corp_dsgvoCookie
,ISNULL(f_corp_hreflang,0) as f_corp_hreflang
,f_corp_defaultlang
,ISNULL(f_corp_enableRichSnippets,0) as f_corp_enableRichSnippets
,ISNULL(f_corp_enableOpenGraph,0) as f_corp_enableOpenGraph
FROM t_corp INNER JOIN t_CorpFolder ON t_corp.ID_CORP = t_CorpFolder.j_corp LEFT OUTER JOIN t_corpmeta ON t_corp.ID_CORP = t_corpmeta.J_CORP
WHERE ID_CORP = (select TOP 1 ID_CORP from CTE_CORP)

SELECT id_corp,f_corp_name,f_corp_domain,f_corp_cug,f_corp_shop,f_corp_wettbewerb,f_corp_locator,f_corp_gb,f_corp_bildstreifen,f_corp_fachhandel_sport,f_corp_portrait,f_corp_published,
f_corp_construction,f_corp_mailingfrom,t_corp.m_insr_date,j_area,f_corpfolder_layout,f_corpfolder_name,f_corpfolder_col2width,f_corpfolder_col3width,
f_corpfolder_tablewidth,f_corpfolder_greeting1,f_corpmeta_author,f_corpmeta_publisher,f_corpmeta_Copyright,f_corpmeta_pagetype,f_corpmeta_pagetopic,
f_corpmeta_audience,f_corpmeta_language,f_corpmeta_Robots,f_corpmeta_revisit,f_corp_pageeditor,f_corp_wwwcall,f_corp_grusskarte,f_corp_newsletter_katalog,
f_corp_formds,f_corp_hasPDFTracking,f_corp_highslideEnlargeImage,f_corp_highslideSquare,f_corp_highslideLightBox,f_corp_filemanager,f_corp_mediamanager,
f_corp_hasCatView,f_corp_hasMobileSite,f_corp_hasFancyLink,f_corp_hasGeotargeting,f_corp_hasGeotargetingRegion,f_corp_highslideOnMouseOver,f_corp_useSEO,
f_corp_hasInlineEntryList,f_corp_inlineCompatibleMode,f_corp_SEOExtension,f_corp_SEOType,f_corp_hasCKFinder,f_corp_hasCKEditor,f_corp_useAppBuilderLogin,f_corp_AppBuilderLoginConf,f_corp_hasImgMenu,
ISNULL(F_CORP_ARCHIV,0) as f_corp_archiv,
f_corp_domain3 as lucee_testlink, F_CORP_HASGRIDMODE,
f_corp_runningOnLucee
,ISNULL(f_corp_useSEOBACKEND,0) as f_corp_useSEOBackend
,ISNULL(f_corp_SSL,0) as f_corp_SSL
,ISNULL(f_corp_dsgvoCookie,0) as f_corp_dsgvoCookie
,ISNULL(f_corp_hreflang,0) as f_corp_hreflang
,f_corp_defaultlang
,ISNULL(f_corp_enableRichSnippets,0) as f_corp_enableRichSnippets
,ISNULL(f_corp_enableOpenGraph,0) as f_corp_enableOpenGraph
FROM t_corp INNER JOIN t_CorpFolder ON t_corp.ID_CORP = t_CorpFolder.j_corp LEFT OUTER JOIN t_corpmeta ON t_corp.ID_CORP = t_corpmeta.J_CORP
WHERE id_corp = 1

SELECT MenuItemID
FROM t_Menu
WHERE MenuItemTarget = 1777 AND (MenuLinkTypeID = 3)

SELECT id_layoutfolder,f_layoutfolder_pfad,f_layoutFolder_bgimg,f_layoutFolder_bgprefix,f_layoutFolder_bghomepage,f_layoutFolder_pagprefix,f_layoutFolder_cssprefix,f_layoutFolder_imgwindow_height,f_layoutFolder_imgwindow_width
,f_layoutfolder_menu_wrapallowed,f_layoutfolder_menu_count,f_layoutfolder_menu_levelcount,f_layoutfolder_mpscript_content,f_layoutfolder_gridStyles,f_layoutfolder_ckEditorStyles
FROM t_layoutFolder
WHERE id_layoutFolder = 8331
AND j_corp = 1

SELECT ISNULL(f_corp_ssl,0) AS ssl, f_corp_domain
FROM t_corp
WHERE f_corp_domain = 'site2zp.mpstaging.ch'
OR f_corp_domain2 = 'site2zp.mpstaging.ch'

SELECT t_corpfolder.f_corpfolder_layout
FROM t_corpfolder
WHERE j_corp = 1

SELECT t_layoutfolder.*,t_layoutfolder.f_layoutfolder_docType
FROM t_layoutfolder
WHERE id_layoutfolder = 8331

SELECT f_corp_siteupdate
FROM t_corp
WHERE id_corp = 1

SELECT m_insr_date,m_updt_date,f_art_write,f_art_status,f_art_allow,f_art_restrict,f_art_start,f_art_end,f_art_save,f_art_lang,j_corp,j_area
FROM t_art
WHERE id_art = 1777

INSERT into T_PERFORM (ID_PERFORM,F_PERFORM_TIME,F_PERFORM_SPROC,F_PERFORM_QUERY,F_PERFORM_ACTION,f_perform_cfid,f_perform_cftoken,f_perform_art,f_perform_page,f_perform_site,M_INSR_BY,M_INSR_DATE,F_PERFORM_DAY,f_perform_remote,f_perform_referer,f_perform_agent,f_perform_info)
VALUES (0,16,0,6,'QUERY_STRING:id_art=1777',0,0,1777,0,0,0,{ts '2019-07-30 11:16:15'},2019211,'172.16.180.21','','Lucee (CFML Engine)','reqEnd')

CGI Variables:
auth_password=
auth_type=
auth_user=
cert_cookie=
cert_flags=
cert_issuer=
cert_keysize=
cert_secretkeysize=
cert_serialnumber=
cert_server_issuer=
cert_server_subject=
cert_subject=
cf_template_path=E:\inetpub\wwwroot\modulpark\site\index.cfm
content_length=0
content_type=
context_path=
gateway_interface=CGI/1.1
http_accept=
http_accept_encoding=
http_accept_language=
http_connection=Keep-Alive
http_cookie=ROUTEID.0e9f56dedc1c6a43ee0c263a6d1b336b=.node1; cfid=ac1450ec-3146-4018-b6d5-0636c1968cd9; cftoken=0
http_host=site2zp.mpstaging.ch
http_referer=
http_user_agent=Lucee (CFML Engine)
https=off
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=172.16.180.25
local_host=ra01-p
path_info=
path_translated=E:\inetpub\wwwroot\modulpark\site\index.cfm
query_string=id_art=1777
remote_addr=172.16.180.21
remote_host=172.16.180.21
remote_user=
request_method=GET
request_url=http://site2zp.mpstaging.ch/site/index.cfm?id_art=1777
script_name=/site/index.cfm
server_name=site2zp.mpstaging.ch
server_port=80
server_port_secure=0
server_protocol=HTTP/1.1
server_software=Microsoft-IIS/8.5
web_server_api=

Request Variables:
aaa_isstatic=172.16.180.21
aaaaasessiontimeout=11.46:15
adrlistbruggdb=AdrListBrugg07DB
adrlistdb=AdrListDB
adrlistpipedb=AdrListPipeDB
adrlistsuhnerautomationdb=AdrListSuhnerAutomationDB
adrlistsuhneraviationdb=AdrListSuhnerAviationDB
agenturrights=no
allowshortregform=yes
approot=E:\Inetpub\wwwroot\modulpark\
appwidereg=no
artloop=ArtLoop
attributeslist=id_art=1777
attributessepar=?
badmintondb=BadmintonDB
bisbackend=false
biscf=false
bremgartendb=BremgartenDB
bruggonline=bruggonline_sql_extern_02
cablesmetallnotierungen=CablesMetallnotierungen
centralmerge=no
cgipath=index.cfm
comparkdb=comparkDB
corp_bg_folder=domains/Modulpark_ch/application/design_20141031_1614
corp_css_folder=domains/Modulpark_ch/application/design_20141031_1614
corp_design_folder=../domains/Modulpark_ch/application/design_20141031_1614
corp_file_root=domains\Modulpark_ch
corp_menu_levelcount=3
corp_menu_wrapallowed=0
corp_root_folder=domains/Modulpark_ch
corp_sec_root=E:\Inetpub\wwwroot\modulpark\domains\Modulpark_ch\data\secure\
corpdomain=https://www.modulpark.ch
corpnew=yes
corpprotocol=https
corpregbyuser=no
cugaccess=1
currentlayout=8331
currentsite=0
datasource_dyntables=MPDynTables
datasource_modules=MPModules
datasource_odbc=modulpark
datasource_perform=modulpark_perform
datasource_perform_archiv=modulpark_perform_archiv
debug_f_artsave=0
debug_f_artstatus=0
debug_isstatic=yes2
debug_ma1={ts '2019-01-15 08:41:36'} - f_corp_siteupdate = {ts '2019-01-11 16:42:37'} -> true
debug_ma2={ts '2019-01-15 08:41:36'} - m_insr_date = {ts '2004-08-17 17:30:36'} -> true
debug_ma3={ts '2019-01-15 08:41:36'} - m_updt_date = {ts '2013-04-20 17:34:13'} -> true
debug_ma4=1777
debugvsprache=DEPRECATED VAR
feldenkrais=feldenkrais
freiamtdb=FreiamtDB
gridmode=false
gslab=GSLab
hotelbookingdb=HotelBookingDB
httproot=http://site2zp.mpstaging.ch/
imagesroot=E:\Inetpub\wwwroot\modulpark\
ingbio=ingbio_fachzeitschrift
inlinemode=true
jqueryallreadyloaded=true
jqueryalreadyloaded=true
kloeti=kloeti
mainemail=info@modulpark.ch
mainservername=https://cms.modulpark.ch/
mess_curlang=DE
messages_odbc=messages_hub
messg=Struct (1279)
newcodeparts=yes
newdesignparts=yes
org.apache.catalina.AccessLog.Protocol=HTTP/1.1
org.apache.catalina.AccessLog.RemoteAddr=172.16.180.21
org.apache.catalina.AccessLog.RemoteHost=172.16.180.21
org.apache.catalina.AccessLog.ServerPort=80
org.apache.tomcat.remoteAddr=172.16.180.21
orgelbaudb=OrgelBauDB
pathtosite=site
pwdb=MPModules
qhead=Query (1)
requesturl=http://site2zp.mpstaging.ch/site/index.cfm?id_art=1777
restartapplication=false
rigips=rigips_cd
rinikenlivedb=RinikenLive
rolemax=5
scriptname=/site/index.cfm
sdefaultmailsender=webserver@modulpark.ch
searchdsn=ES
securedocpath=E:\Inetpub\wwwroot\modulpark\
servername=site2zp.mpstaging.ch
serverprotocol=http
shopaccess=1
showmainlayout=no
sitelogmodeison=false
sitemodus=normal
smtpserver=mailer.modulpark.ch
sodafresh=sodafresh
sriptname=/site/index.cfm
sslroot=https://site2zp.mpstaging.ch/
start=1564478176450
t_proc=0
t_qry=6
tc_app_messages=0
urlprotocol=http
urltoken=vsprache=DE
urltokenlogin=vsprache=DE&CFID=ac1450ec-3146-4018-b6d5-0636c1968cd9&CFToken=0
urltokenslash=vsprache/DE
v_layoutfolder_id=8331
v_layoutfolder_pfad=design_20141031_1614
vjspath=http://site2zp.mpstaging.ch/js
webroot=http://site2zp.mpstaging.ch/