SELECT suffix FROM SITES WHERE lower(server_name)='www.chateau-doex.ch'
		

			select
				pk_sites_param as paramkey,
				fk_site_id as siteid,
				param_value as paramvalue
			from sites_param
			where
			param_value in (?)
			and fk_site_id in (?) 

			select 
				PD.PAGE_ID as pageId,
				
					case PNPD.NAVCODE when ? then 1 else 2 end as sorter,
					PNN.NODE_ID as parentNodeId,
				
				N.NODE_ID as nodeId
			from G_PAGES_DETAILS PD
				join G_PAGES P on (P.PAGE_ID=PD.PAGE_ID and P.DELETED=?)
				join G_NODES N on (N.PAGE_ID=P.PAGE_ID and N.DELETED=?)
				join G_NODES_SITES_REL REL on (REL.NODE_ID=N.NODE_ID and REL.SITE_ID=?)
				
					left outer join G_NODES_REL PNNREL on (PNNREL.NODE_ID=N.NODE_ID)
					left outer join G_NODES PNN on (PNN.NODE_ID=PNNREL.PARENT_NODE_ID and PNN.DELETED=?)
					left outer join G_PAGES_DETAILS PNPD on (PNPD.PAGE_ID=PNN.PAGE_ID and PNPD.NAVCODE=? and PNPD.DELETED=?)
				
			where PD.NAVCODE=?
				and PD.DELETED=? order by sorter limit 1 

			select 
				PD.PAGE_ID as pageId
			from G_PAGES_DETAILS PD
				join G_PAGES P on (P.PAGE_ID=PD.PAGE_ID and P.DELETED=?)
				join G_PAGES_SITES_REL REL on (REL.PAGE_ID=P.PAGE_ID and REL.SITE_ID=?)
			where PD.NAVCODE=?
				and PD.DELETED=? limit 1 

			select 
				REL.NODE_ID as nodeId
			from G_NODES_PAGES_REL REL
				join G_NODES N on (N.NODE_ID=REL.NODE_ID and N.DELETED=?) 
				join G_NODES_SITES_REL NS on (NS.NODE_ID=REL.NODE_ID and NS.SITE_ID=?)
			where REL.PAGE_ID=? 

			select 
				PD.PAGE_ID as pageId,
				
				N.NODE_ID as nodeId
			from G_PAGES_DETAILS PD
				join G_PAGES P on (P.PAGE_ID=PD.PAGE_ID and P.DELETED=?)
				join G_NODES N on (N.PAGE_ID=P.PAGE_ID and N.DELETED=?)
				join G_NODES_SITES_REL REL on (REL.NODE_ID=N.NODE_ID and REL.SITE_ID=?)
				
			where PD.NAVCODE=?
				and PD.DELETED=? limit 1 

												SELECT * FROM gTmpPageNode WHERE nodeId=17207 

Application Variables:
applicationname=REGSITE_CHATEAU
basepath=/mnt/webroot/sites/otv_chateaudoex/
datasource=web
gadmin_cfc_parameter=Struct (23)
gadmin_schema_node=Struct (50)
gadmin_schema_page=Struct (53)
gadminversion=4
getcrumbtitle=Complex type
getphrase=Complex type
imagebasepath=http://images.gadmin.st.s3.amazonaws.com
instance=Struct (34)
langpath=fr
languages=fr,en,de
lastreinit=0
locator=Struct (8)
myhostname=ps6
navadmin_de=Query (0)
navadmin_en=Query (0)
navadmin_fr=Query (0)
navadmin_it=Query (0)
navfooter_de=Query (5)
navfooter_en=Query (5)
navfooter_fr=Query (5)
navfooter_it=Query (5)
navidadmin=6143
navidfoot=7451
navidmain=7450
navidpart=7453
navidreg=7452
navidserv=7454
navidtop=7455
navigationlink=Complex type
navmain_de=Query (6)
navmain_en=Query (6)
navmain_fr=Query (6)
navmain_it=Query (6)
navparentnodeids=6874,7450,7454,7451
navpartiques_de=Query (5)
navpartiques_en=Query (5)
navpartiques_fr=Query (5)
navpartiques_it=Query (5)
navregion_de=Query (4)
navregion_en=Query (4)
navregion_fr=Query (4)
navregion_it=Query (4)
navservice_de=Query (5)
navservice_en=Query (5)
navservice_fr=Query (5)
navservice_it=Query (5)
navtop_de=Query (2)
navtop_en=Query (2)
navtop_fr=Query (2)
navtop_it=Query (2)
navtree_de=Query (604)
navtree_en=Query (604)
navtree_fr=Query (604)
navtree_it=Query (604)
navtreeid=6874
outputhandler=Struct (48)
refreshapplication=Complex type
resizefont=Complex type
securityservice=Struct (19)
shownavigation=Complex type
siteid=125
sitepath=sites-chateau
sitetitle=Struct (4)
tagcache=Struct (12)
trans=Struct (5)
updatetimecha_de={ts '2012-02-07 03:31:05'}
updatetimecha_en={ts '2012-02-04 04:49:02'}
updatetimecha_fr={ts '2012-02-07 16:49:12'}
util=Struct (23)
weathercha_de=<?xml version="1.0" encoding="UTF-8"?>
<Article><Location link="/de/page.cfm/meteo" name="Château d'Oex"><Day exp="6. Februar 2012" val="20120206"><TxtDay>klar</TxtDay><SymbDay>51</SymbDay><TempMor>-13</TempMor><TempAft>-13</TempAft></Day><Day exp="7. Februar 2012" val="20120207"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-18</TempMor><TempAft>-13</TempAft></Day><Day exp="8. Februar 2012" val="20120208"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-14</TempMor><TempAft>-8</TempAft></Day><Day exp="9. Februar 2012" val="20120209"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-11</TempMor><TempAft>-6</TempAft></Day><Day exp="10. Februar 2012" val="20120210"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-12</TempMor><TempAft>-8</TempAft></Day><Day exp="11. Februar 2012" val="20120211"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-14</TempMor><TempAft>-7</TempAft></Day></Location><Location link="/de/page.cfm/meteo" name="Rossinière"><Day exp="6. Februar 2012" val="20120206"><TxtDay>klar</TxtDay><SymbDay>51</SymbDay><TempMor>-13</TempMor><TempAft>-13</TempAft></Day><Day exp="7. Februar 2012" val="20120207"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-18</TempMor><TempAft>-13</TempAft></Day><Day exp="8. Februar 2012" val="20120208"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-14</TempMor><TempAft>-8</TempAft></Day><Day exp="9. Februar 2012" val="20120209"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-11</TempMor><TempAft>-6</TempAft></Day><Day exp="10. Februar 2012" val="20120210"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-12</TempMor><TempAft>-8</TempAft></Day><Day exp="11. Februar 2012" val="20120211"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-14</TempMor><TempAft>-7</TempAft></Day></Location><Location link="/de/page.cfm/meteo" name="Rougemont"><Day exp="6. Februar 2012" val="20120206"><TxtDay>klar</TxtDay><SymbDay>51</SymbDay><TempMor>-13</TempMor><TempAft>-13</TempAft></Day><Day exp="7. Februar 2012" val="20120207"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-18</TempMor><TempAft>-13</TempAft></Day><Day exp="8. Februar 2012" val="20120208"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-14</TempMor><TempAft>-8</TempAft></Day><Day exp="9. Februar 2012" val="20120209"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-11</TempMor><TempAft>-6</TempAft></Day><Day exp="10. Februar 2012" val="20120210"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-12</TempMor><TempAft>-8</TempAft></Day><Day exp="11. Februar 2012" val="20120211"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-14</TempMor><TempAft>-7</TempAft></Day></Location></Article> 
weathercha_en=<?xml version="1.0" encoding="UTF-8"?>
<Article><Location link="/en/page.cfm/meteo" name="Château d'Oex"><Day exp="4 February 2012" val="20120204"><TxtDay>clear skies</TxtDay><SymbDay>51</SymbDay><TempMor>-17</TempMor><TempAft>-17</TempAft></Day><Day exp="5 February 2012" val="20120205"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-17</TempMor><TempAft>-9</TempAft></Day><Day exp="6 February 2012" val="20120206"><TxtDay>sunny</TxtDay><SymbDay>1</SymbDay><TempMor>-16</TempMor><TempAft>-12</TempAft></Day><Day exp="7 February 2012" val="20120207"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-16</TempMor><TempAft>-12</TempAft></Day><Day exp="8 February 2012" val="20120208"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-15</TempMor><TempAft>-8</TempAft></Day><Day exp="9 February 2012" val="20120209"><TxtDay>sunny</TxtDay><SymbDay>1</SymbDay><TempMor>-12</TempMor><TempAft>-2</TempAft></Day></Location><Location link="/en/page.cfm/meteo" name="Rossinière"><Day exp="4 February 2012" val="20120204"><TxtDay>clear skies</TxtDay><SymbDay>51</SymbDay><TempMor>-17</TempMor><TempAft>-17</TempAft></Day><Day exp="5 February 2012" val="20120205"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-17</TempMor><TempAft>-9</TempAft></Day><Day exp="6 February 2012" val="20120206"><TxtDay>sunny</TxtDay><SymbDay>1</SymbDay><TempMor>-16</TempMor><TempAft>-12</TempAft></Day><Day exp="7 February 2012" val="20120207"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-16</TempMor><TempAft>-12</TempAft></Day><Day exp="8 February 2012" val="20120208"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-15</TempMor><TempAft>-8</TempAft></Day><Day exp="9 February 2012" val="20120209"><TxtDay>sunny</TxtDay><SymbDay>1</SymbDay><TempMor>-12</TempMor><TempAft>-2</TempAft></Day></Location><Location link="/en/page.cfm/meteo" name="Rougemont"><Day exp="4 February 2012" val="20120204"><TxtDay>clear skies</TxtDay><SymbDay>51</SymbDay><TempMor>-17</TempMor><TempAft>-17</TempAft></Day><Day exp="5 February 2012" val="20120205"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-17</TempMor><TempAft>-9</TempAft></Day><Day exp="6 February 2012" val="20120206"><TxtDay>sunny</TxtDay><SymbDay>1</SymbDay><TempMor>-16</TempMor><TempAft>-12</TempAft></Day><Day exp="7 February 2012" val="20120207"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-16</TempMor><TempAft>-12</TempAft></Day><Day exp="8 February 2012" val="20120208"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-15</TempMor><TempAft>-8</TempAft></Day><Day exp="9 February 2012" val="20120209"><TxtDay>sunny</TxtDay><SymbDay>1</SymbDay><TempMor>-12</TempMor><TempAft>-2</TempAft></Day></Location></Article> 
weathercha_fr=<?xml version="1.0" encoding="UTF-8"?>
<Article><Location link="/fr/page.cfm/meteo" name="Château d'Oex"><Day exp="7 février 2012" val="20120207"><TxtDay>ensoleillé</TxtDay><SymbDay>1</SymbDay><TempMor>-14</TempMor><TempAft>-14</TempAft></Day><Day exp="8 février 2012" val="20120208"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-14</TempMor><TempAft>-8</TempAft></Day><Day exp="9 février 2012" val="20120209"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-14</TempMor><TempAft>-6</TempAft></Day><Day exp="10 février 2012" val="20120210"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-9</TempAft></Day><Day exp="11 février 2012" val="20120211"><TxtDay>ensoleillé</TxtDay><SymbDay>1</SymbDay><TempMor>-13</TempMor><TempAft>-8</TempAft></Day><Day exp="12 février 2012" val="20120212"><TxtDay>ensoleillé</TxtDay><SymbDay>1</SymbDay><TempMor>-14</TempMor><TempAft>-4</TempAft></Day></Location><Location link="/fr/page.cfm/meteo" name="Rossinière"><Day exp="7 février 2012" val="20120207"><TxtDay>ensoleillé</TxtDay><SymbDay>1</SymbDay><TempMor>-14</TempMor><TempAft>-14</TempAft></Day><Day exp="8 février 2012" val="20120208"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-14</TempMor><TempAft>-8</TempAft></Day><Day exp="9 février 2012" val="20120209"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-14</TempMor><TempAft>-6</TempAft></Day><Day exp="10 février 2012" val="20120210"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-9</TempAft></Day><Day exp="11 février 2012" val="20120211"><TxtDay>ensoleillé</TxtDay><SymbDay>1</SymbDay><TempMor>-13</TempMor><TempAft>-8</TempAft></Day><Day exp="12 février 2012" val="20120212"><TxtDay>ensoleillé</TxtDay><SymbDay>1</SymbDay><TempMor>-14</TempMor><TempAft>-4</TempAft></Day></Location><Location link="/fr/page.cfm/meteo" name="Rougemont"><Day exp="7 février 2012" val="20120207"><TxtDay>ensoleillé</TxtDay><SymbDay>1</SymbDay><TempMor>-14</TempMor><TempAft>-14</TempAft></Day><Day exp="8 février 2012" val="20120208"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-14</TempMor><TempAft>-8</TempAft></Day><Day exp="9 février 2012" val="20120209"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-14</TempMor><TempAft>-6</TempAft></Day><Day exp="10 février 2012" val="20120210"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-9</TempAft></Day><Day exp="11 février 2012" val="20120211"><TxtDay>ensoleillé</TxtDay><SymbDay>1</SymbDay><TempMor>-13</TempMor><TempAft>-8</TempAft></Day><Day exp="12 février 2012" val="20120212"><TxtDay>ensoleillé</TxtDay><SymbDay>1</SymbDay><TempMor>-14</TempMor><TempAft>-4</TempAft></Day></Location></Article> 

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=/mnt/webroot/sites/otv_chateaudoex/html/page.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=close
HTTP_COOKIE=CFID=14401096; CFTOKEN=26777629; AWSELB=590FB3B30812EDC7EB028AF9472203E2487E8BC09AB97DEC7499BCB3CAFCFBF3FDBF35F751E1F5D156505E81F7ECDA1F81DDCB2DB2FA0F49616380FB93D48C85352E6DC7FA
HTTP_HOST=www.chateau-doex.ch
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/traditions_culture/expositions_galeries/etambeau
PATH_TRANSLATED=/mnt/webroot/sites/otv_chateaudoex/html/page.cfm
QUERY_STRING=
REMOTE_ADDR=10.235.46.189
REMOTE_HOST=10.235.46.189
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/fr/page.cfm
SERVER_NAME=www.chateau-doex.ch
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Apache/2.2.9 (Debian) JRun/4.0
WEB_SERVER_API=

Cookie Variables:
AWSELB=590FB3B30812EDC7EB028AF9472203E2487E8BC09AB97DEC7499BCB3CAFCFBF3FDBF35F751E1F5D156505E81F7ECDA1F81DDCB2DB2FA0F49616380FB93D48C85352E6DC7FA
CFID=14401096
CFTOKEN=26777629

Request Parameters:
env=Struct (1)
langpath=fr
langpathid=6
qlangpath=fr
siteid=125
suffix=

Server Variables:
COLDFUSION=Struct (8)
OS=Struct (5)

Session Variables:
cfid=14401096
cftoken=26777629
fontsize=0
sessionid=REGSITE_CHATEAU_14401096_26777629
urltoken=CFID=14401096&CFTOKEN=26777629