SELECT suffix FROM SITES WHERE lower(server_name)='www.yverdonlesbainsregion.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 N.NODE_ID when ? then 1 when ? then 2 when ? then 3 when ? then 4 else 5 end as sortorderParentNode, 
				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 and PNNREL.PARENT_NODE_ID in (?,?,?,?))
				
			where PD.NAVCODE=?
				and PD.DELETED=? order by sortorderParentNode 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=? limit 1 

							SHOW TABLES;
						

			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER(?) and sp.fk_site_id = ? 

			select LANGUAGES from G_SITES where SITE_ID=? 

			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER(?) and sp.fk_site_id = ? 

				select PAGE_ID as pageId
				from G_PAGES
				where PAGE_ID IN (?)
				and DELETED=? 
				AND VISIBLE=? 

			select
			T.TEMPLATE_ID as templateId
			,T.NAME ,T.CONTENT ,T.PDFCONTENT ,T.OUTPUT3CONTENT ,T.OUTPUT4CONTENT ,T.OUTPUT5CONTENT ,T.PDF ,T.SITE_ID as siteId ,T.TEMPLATE_MAPPING as templateMapping
			from G_TEMPLATES T 
				join G_PAGES P on (P.TEMPLATE_ID=T.TEMPLATE_ID)
			where P.PAGE_ID=? 
			and P.DELETED=? 

			select USE_TEMPLATE_ID as templateId 
			from G_TEMPLATE_FIELDS 
			where TEMPLATE_ID=?
			and use_template_id is not null
		

			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER(?) and sp.fk_site_id = ? 

			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER(?) and sp.fk_site_id = ? 

			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER(?) and sp.fk_site_id = ? 

			select PAGE_ID from G_NODES
			where PAGE_ID=?
			and DELETED=? 

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

			select USE_TEMPLATE_ID as templateId 
			from G_TEMPLATE_FIELDS 
			where TEMPLATE_ID=?
			and use_template_id is not null
		

			select TF.NAME, TF.DESCRIPTION, TF.PROXY, TF.ADMIN_ONLY, TF.ISEDITABLE, F.NAME as FIELDNAME, F.DATATYPE, F.MAXLENGTH, TF.CHARCOUNT, TF.USE_TEMPLATE_ID as useTemplateId
			from G_TEMPLATE_FIELDS TF 
				join G_FIELDS F on (F.FIELD_ID=TF.FIELD_ID)
			where TF.TEMPLATE_ID=? 
			order by TF.SORTORDER,TF.TEMPLATE_FIELD_ID
		

			select LANGUAGE
			from G_PAGES_DETAILS 
			where PAGE_ID=?
			and DELETED=?
			and VISIBLE=? 

			select IFNULL(PD.PAGE_ID,PDDFLT.PAGE_ID) as id,
			P.online_from,
			P.online_to
			,IFNULL(PD.meta_description,PDDFLT.meta_description) as meta_description ,IFNULL(PD.meta_keywords,PDDFLT.meta_keywords) as meta_keywords ,IFNULL(PD.meta_title,PDDFLT.meta_title) as meta_title ,IFNULL(PD.title_offe,PDDFLT.title_offe) as title_offe ,IFNULL(PD.abstract2,PDDFLT.abstract2) as abstract2 ,IFNULL(PD.place,PDDFLT.place) as place ,IFNULL(PD.url_logo,PDDFLT.url_logo) as url_logo ,IFNULL(PD.url2_logo,PDDFLT.url2_logo) as url2_logo ,IFNULL(PD.booking_info,PDDFLT.booking_info) as booking_info ,IFNULL(PD.text1,PDDFLT.text1) as text1 ,IFNULL(PD.text2,PDDFLT.text2) as text2 ,IFNULL(PD.text3,PDDFLT.text3) as text3 ,IFNULL(PD.navcode,PDDFLT.navcode) as navcode ,P.disable_dropdown ,P.r_key as r_key ,P.s_key as s_key ,IFNULL(IF(P.x_coord=0,NULL,P.x_coord),IF(IFNULL((select x from r_addresses where pk_address=P.INFRA_FK_ADDRESS),0)>0,(select x from r_addresses where pk_address=P.INFRA_FK_ADDRESS),(select x from r_resorts where pk_resort=P.R_KEY))) as x_coord ,IFNULL(IF(P.y_coord=0,NULL,P.y_coord),IF(IFNULL((select y from r_addresses where pk_address=P.INFRA_FK_ADDRESS),0)>0,(select y from r_addresses where pk_address=P.INFRA_FK_ADDRESS),(select y from r_resorts where pk_resort=P.R_KEY))) as y_coord ,P.INFRA_FK_ADDRESS as adr_key ,IFNULL(PD.address,PDDFLT.address) as adr_raw 
			from G_PAGES P
			left outer join G_PAGES_DETAILS PD on (PD.PAGE_ID=P.PAGE_ID
										and PD.DELETED=? and PD.VISIBLE=?
										and PD.LANGUAGE=?)
			left outer join G_PAGES_DETAILS PDDFLT on (PDDFLT.PAGE_ID=P.PAGE_ID
										and PDDFLT.DELETED=?
										and PDDFLT.VISIBLE=?
										and PDDFLT.LANGUAGE=P.DEFAULT_LANG)

			

			where P.PAGE_ID=?
				and P.DELETED=? and P.VISIBLE=? 

			
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG))) as caption, IFNULL((select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as img_place, gdr.URL as img_url, gid.width, gid.height, 
				1 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
				
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)	
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, IFNULL((select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as img_place, gdr.URL as img_url, gid.width, gid.height, 
				2 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
		
		
			
			UNION
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, (select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG) as img_place, gdr.URL as img_url, gid.width, gid.height, 
				3 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, (select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG) as img_place, gdr.URL as img_url, gid.width, gid.height, 
				4 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			ORDER BY querynr,langsort LIMIT 1 

			
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG))) as caption, gdr.URL as img_url, gid.width, gid.height, 
				1 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
				
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)	
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				2 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
		
		
			
			UNION
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				3 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				4 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			ORDER BY querynr,langsort LIMIT 1 

			
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG))) as caption, gdr.URL as img_url, gid.width, gid.height, 
				1 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
				
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)	
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				2 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
		
		
			
			UNION
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				3 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				4 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			ORDER BY querynr,langsort LIMIT 1 

			
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG))) as caption, gdr.URL as img_url, gid.width, gid.height, 
				1 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
				
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)	
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				2 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
		
		
			
			UNION
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				3 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				4 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			ORDER BY querynr,langsort LIMIT 1 

			
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG))) as caption, gdr.URL as img_url, gid.width, gid.height, 
				1 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
				
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)	
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				2 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
		
		
			
			UNION
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				3 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				4 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			ORDER BY querynr,langsort LIMIT 1 

			
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG))) as caption, gdr.URL as img_url, gid.width, gid.height, 
				1 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
				
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)	
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				2 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
		
		
			
			UNION
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				3 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				4 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			ORDER BY querynr,langsort LIMIT 1 

			
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG))) as caption, gdr.URL as img_url, gid.width, gid.height, 
				1 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
				
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)	
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				2 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
		
		
			
			UNION
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				3 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				4 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			ORDER BY querynr,langsort LIMIT 1 

			
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG))) as caption, gdr.URL as img_url, gid.width, gid.height, 
				1 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
				
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)	
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				2 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
		
		
			
			UNION
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				3 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				4 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			ORDER BY querynr,langsort LIMIT 1 

			
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG))) as caption, gdr.URL as img_url, gid.width, gid.height, 
				1 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
				
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)	
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				2 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
		
		
			
			UNION
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				3 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				4 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			ORDER BY querynr,langsort LIMIT 1 

			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER(?) and sp.fk_site_id = ? 

			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER(?) and sp.fk_site_id = ? 

			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER(?) and sp.fk_site_id = ? 

			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER(?) and sp.fk_site_id = ? 

			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER(?) and sp.fk_site_id = ? 

			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER(?) and sp.fk_site_id = ? 

			
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG))) as caption, IFNULL((select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as img_place, gdr.URL as img_url, gid.width, gid.height, 
				1 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
				
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)	
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, IFNULL((select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as img_place, gdr.URL as img_url, gid.width, gid.height, 
				2 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
		
		
			
			UNION
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, (select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG) as img_place, gdr.URL as img_url, gid.width, gid.height, 
				3 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, (select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG) as img_place, gdr.URL as img_url, gid.width, gid.height, 
				4 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			ORDER BY querynr,langsort LIMIT 1 

			
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG))) as caption, gdr.URL as img_url, gid.width, gid.height, 
				1 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
				
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)	
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				2 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
		
		
			
			UNION
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				3 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				4 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			ORDER BY querynr,langsort LIMIT 1 

			
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG))) as caption, IFNULL((select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as img_place, gdr.URL as img_url, gid.width, gid.height, 
				1 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
				
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)	
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, IFNULL((select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as img_place, gdr.URL as img_url, gid.width, gid.height, 
				2 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
		
		
			
			UNION
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, (select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG) as img_place, gdr.URL as img_url, gid.width, gid.height, 
				3 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, (select gl.place from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG) as img_place, gdr.URL as img_url, gid.width, gid.height, 
				4 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			ORDER BY querynr,langsort LIMIT 1 

			
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG))) as caption, gdr.URL as img_url, gid.width, gid.height, 
				1 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
				
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)	
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				2 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
		
		
			
			UNION
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				3 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				4 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			ORDER BY querynr,langsort LIMIT 1 

			
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG))) as caption, gdr.URL as img_url, gid.width, gid.height, 
				1 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
				
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)	
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				2 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
		
		
			
			UNION
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				3 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				4 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			ORDER BY querynr,langsort LIMIT 1 

			
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG))) as caption, gdr.URL as img_url, gid.width, gid.height, 
				1 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
				
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)	
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				2 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
		
		
			
			UNION
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL(gdr.caption,(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				3 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.LANGUAGE = ?
				and gdr.LANGUAGE = ?
				and gd.PAGE_ID = ?
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			UNION		
			(SELECT 
				'http://images.gadmin.st.s3.amazonaws.com/' || gid.filepath as path, IFNULL((select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = ?),(select gl.caption from G_IMAGES_DETAILS gl where gl.DELETED=? and gl.IMAGE_ID = gid.IMAGE_ID and gl.LANGUAGE = gi.DEFAULT_LANG)) as caption, gdr.URL as img_url, gid.width, gid.height, 
				4 as querynr,
				gdr.language,
				CASE gdr.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN P.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
			FROM
				G_IMAGES_VERSIONS gid
				inner join G_PAGES_DETAILS_IMAGES_REL gdr on gdr.IMAGE_ID = gid.IMAGE_ID
				inner join G_PAGES_DETAILS gd on gd.PAGE_ID = gdr.PAGE_ID
				inner join G_PAGES P on gd.PAGE_ID = P.PAGE_ID
				inner join G_IMAGES gi on gi.IMAGE_ID=gid.IMAGE_ID
			WHERE
				gid.DELETED=?
				and gi.DELETED=?
				and gd.PAGE_ID = ?
				and gd.LANGUAGE = P.DEFAULT_LANG
				and gdr.LANGUAGE = P.DEFAULT_LANG
				and gdr.POSITION in (?)
				and gid.IMAGES_SIZE_ID = ? 
			)
			
			ORDER BY querynr,langsort LIMIT 1 

			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER(?) and sp.fk_site_id = ? 

			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER(?) and sp.fk_site_id = ? 

			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER(?) and sp.fk_site_id = ? 

Application Variables:
applicationname=REGSITE_YVERDON
basepath=/mnt/webroot/sites/otv_yverdon/
checkmobilesite=Complex type
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 (35)
langpath=fr
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 (7)
navfooter_en=Query (7)
navfooter_fr=Query (7)
navfooter_it=Query (7)
navidadmin=6143
navidfoot=6939
navidmain=6938
navidpart=6941
navidreg=6940
navidserv=6942
navidtop=6943
navigationlink=Complex type
navmain_de=Query (6)
navmain_en=Query (6)
navmain_fr=Query (6)
navmain_it=Query (6)
navparentnodeids=5468,6938,6942,6939
navpartiques_de=Query (5)
navpartiques_en=Query (5)
navpartiques_fr=Query (5)
navpartiques_it=Query (5)
navregion_de=Query (7)
navregion_en=Query (7)
navregion_fr=Query (7)
navregion_it=Query (7)
navservice_de=Query (5)
navservice_en=Query (5)
navservice_fr=Query (5)
navservice_it=Query (5)
navtop_de=Query (4)
navtop_en=Query (4)
navtop_fr=Query (4)
navtop_it=Query (4)
navtree_de=Query (530)
navtree_en=Query (530)
navtree_fr=Query (530)
navtree_it=Query (530)
navtreeid=5468
outputhandler=Struct (49)
refreshapplication=Complex type
resizefont=Complex type
securityservice=Struct (19)
shownavigation=Complex type
siteid=118
sitepath=sites-yverdon
sitetitle=Struct (4)
tagcache=Struct (16)
trans=Struct (5)
updatetimeyve_de={ts '2012-02-04 08:11:33'}
updatetimeyve_en={ts '2012-02-04 07:08:21'}
updatetimeyve_fr={ts '2012-02-04 08:21:12'}
util=Struct (23)
weatheryve_de=<?xml version="1.0" encoding="UTF-8"?>
<Article><Location link="/de/page.cfm/meteo" name="Yverdon-les-Bains"><Day exp="4. Februar 2012" val="20120204"><TxtDay>bedeckt</TxtDay><SymbDay>5</SymbDay><TempMor>-12</TempMor><TempAft>-12</TempAft></Day><Day exp="5. Februar 2012" val="20120205"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-15</TempMor><TempAft>-8</TempAft></Day><Day exp="6. Februar 2012" val="20120206"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-13</TempMor><TempAft>-8</TempAft></Day><Day exp="7. Februar 2012" val="20120207"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-8</TempAft></Day><Day exp="8. Februar 2012" val="20120208"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9. Februar 2012" val="20120209"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-9</TempMor><TempAft>-2</TempAft></Day></Location><Location link="/de/page.cfm/meteo" name="Orbe"><Day exp="4. Februar 2012" val="20120204"><TxtDay>bedeckt</TxtDay><SymbDay>5</SymbDay><TempMor>-12</TempMor><TempAft>-12</TempAft></Day><Day exp="5. Februar 2012" val="20120205"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-15</TempMor><TempAft>-8</TempAft></Day><Day exp="6. Februar 2012" val="20120206"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-13</TempMor><TempAft>-8</TempAft></Day><Day exp="7. Februar 2012" val="20120207"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-8</TempAft></Day><Day exp="8. Februar 2012" val="20120208"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9. Februar 2012" val="20120209"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-9</TempMor><TempAft>-2</TempAft></Day></Location><Location link="/de/page.cfm/meteo" name="Yvonand"><Day exp="4. Februar 2012" val="20120204"><TxtDay>bedeckt</TxtDay><SymbDay>5</SymbDay><TempMor>-12</TempMor><TempAft>-12</TempAft></Day><Day exp="5. Februar 2012" val="20120205"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-15</TempMor><TempAft>-8</TempAft></Day><Day exp="6. Februar 2012" val="20120206"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-13</TempMor><TempAft>-8</TempAft></Day><Day exp="7. Februar 2012" val="20120207"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-8</TempAft></Day><Day exp="8. Februar 2012" val="20120208"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9. Februar 2012" val="20120209"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-9</TempMor><TempAft>-2</TempAft></Day></Location><Location link="/de/page.cfm/meteo" name="Grandson"><Day exp="4. Februar 2012" val="20120204"><TxtDay>bedeckt</TxtDay><SymbDay>5</SymbDay><TempMor>-12</TempMor><TempAft>-12</TempAft></Day><Day exp="5. Februar 2012" val="20120205"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-15</TempMor><TempAft>-8</TempAft></Day><Day exp="6. Februar 2012" val="20120206"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-13</TempMor><TempAft>-8</TempAft></Day><Day exp="7. Februar 2012" val="20120207"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-8</TempAft></Day><Day exp="8. Februar 2012" val="20120208"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9. Februar 2012" val="20120209"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-9</TempMor><TempAft>-2</TempAft></Day></Location></Article> 
weatheryve_en=<?xml version="1.0" encoding="UTF-8"?>
<Article><Location link="/en/page.cfm/meteo" name="Yverdon-les-Bains"><Day exp="4 February 2012" val="20120204"><TxtDay>cloudy</TxtDay><SymbDay>55</SymbDay><TempMor>-12</TempMor><TempAft>-12</TempAft></Day><Day exp="5 February 2012" val="20120205"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-15</TempMor><TempAft>-8</TempAft></Day><Day exp="6 February 2012" val="20120206"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-13</TempMor><TempAft>-8</TempAft></Day><Day exp="7 February 2012" val="20120207"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-8</TempAft></Day><Day exp="8 February 2012" val="20120208"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9 February 2012" val="20120209"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-9</TempMor><TempAft>-2</TempAft></Day></Location><Location link="/en/page.cfm/meteo" name="Orbe"><Day exp="4 February 2012" val="20120204"><TxtDay>cloudy</TxtDay><SymbDay>55</SymbDay><TempMor>-12</TempMor><TempAft>-12</TempAft></Day><Day exp="5 February 2012" val="20120205"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-15</TempMor><TempAft>-8</TempAft></Day><Day exp="6 February 2012" val="20120206"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-13</TempMor><TempAft>-8</TempAft></Day><Day exp="7 February 2012" val="20120207"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-8</TempAft></Day><Day exp="8 February 2012" val="20120208"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9 February 2012" val="20120209"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-9</TempMor><TempAft>-2</TempAft></Day></Location><Location link="/en/page.cfm/meteo" name="Yvonand"><Day exp="4 February 2012" val="20120204"><TxtDay>cloudy</TxtDay><SymbDay>55</SymbDay><TempMor>-12</TempMor><TempAft>-12</TempAft></Day><Day exp="5 February 2012" val="20120205"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-15</TempMor><TempAft>-8</TempAft></Day><Day exp="6 February 2012" val="20120206"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-13</TempMor><TempAft>-8</TempAft></Day><Day exp="7 February 2012" val="20120207"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-8</TempAft></Day><Day exp="8 February 2012" val="20120208"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9 February 2012" val="20120209"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-9</TempMor><TempAft>-2</TempAft></Day></Location><Location link="/en/page.cfm/meteo" name="Grandson"><Day exp="4 February 2012" val="20120204"><TxtDay>cloudy</TxtDay><SymbDay>55</SymbDay><TempMor>-12</TempMor><TempAft>-12</TempAft></Day><Day exp="5 February 2012" val="20120205"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-15</TempMor><TempAft>-8</TempAft></Day><Day exp="6 February 2012" val="20120206"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-13</TempMor><TempAft>-8</TempAft></Day><Day exp="7 February 2012" val="20120207"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-8</TempAft></Day><Day exp="8 February 2012" val="20120208"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9 February 2012" val="20120209"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-9</TempMor><TempAft>-2</TempAft></Day></Location></Article> 
weatheryve_fr=<?xml version="1.0" encoding="UTF-8"?>
<Article><Location link="/fr/page.cfm/meteo" name="Yverdon-les-Bains"><Day exp="4 février 2012" val="20120204"><TxtDay>très nuageux à couvert</TxtDay><SymbDay>5</SymbDay><TempMor>-12</TempMor><TempAft>-12</TempAft></Day><Day exp="5 février 2012" val="20120205"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-15</TempMor><TempAft>-8</TempAft></Day><Day exp="6 février 2012" val="20120206"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-13</TempMor><TempAft>-8</TempAft></Day><Day exp="7 février 2012" val="20120207"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-8</TempAft></Day><Day exp="8 février 2012" val="20120208"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9 février 2012" val="20120209"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-9</TempMor><TempAft>-2</TempAft></Day></Location><Location link="/fr/page.cfm/meteo" name="Orbe"><Day exp="4 février 2012" val="20120204"><TxtDay>très nuageux à couvert</TxtDay><SymbDay>5</SymbDay><TempMor>-12</TempMor><TempAft>-12</TempAft></Day><Day exp="5 février 2012" val="20120205"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-15</TempMor><TempAft>-8</TempAft></Day><Day exp="6 février 2012" val="20120206"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-13</TempMor><TempAft>-8</TempAft></Day><Day exp="7 février 2012" val="20120207"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-8</TempAft></Day><Day exp="8 février 2012" val="20120208"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9 février 2012" val="20120209"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-9</TempMor><TempAft>-2</TempAft></Day></Location><Location link="/fr/page.cfm/meteo" name="Yvonand"><Day exp="4 février 2012" val="20120204"><TxtDay>très nuageux à couvert</TxtDay><SymbDay>5</SymbDay><TempMor>-12</TempMor><TempAft>-12</TempAft></Day><Day exp="5 février 2012" val="20120205"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-15</TempMor><TempAft>-8</TempAft></Day><Day exp="6 février 2012" val="20120206"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-13</TempMor><TempAft>-8</TempAft></Day><Day exp="7 février 2012" val="20120207"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-8</TempAft></Day><Day exp="8 février 2012" val="20120208"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9 février 2012" val="20120209"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-9</TempMor><TempAft>-2</TempAft></Day></Location><Location link="/fr/page.cfm/meteo" name="Grandson"><Day exp="4 février 2012" val="20120204"><TxtDay>très nuageux à couvert</TxtDay><SymbDay>5</SymbDay><TempMor>-12</TempMor><TempAft>-12</TempAft></Day><Day exp="5 février 2012" val="20120205"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-15</TempMor><TempAft>-8</TempAft></Day><Day exp="6 février 2012" val="20120206"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-13</TempMor><TempAft>-8</TempAft></Day><Day exp="7 février 2012" val="20120207"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-8</TempAft></Day><Day exp="8 février 2012" val="20120208"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9 février 2012" val="20120209"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-9</TempMor><TempAft>-2</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_yverdon/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=20657835; CFTOKEN=77495715; AWSELB=590FB3B30812EDC7EB028AF9472203E2487E8BC09AB97DEC7499BCB3CAFCFBF3FDBF35F751E1F5D156505E81F7ECDA1F81DDCB2DB2FA0F49616380FB93D48C85352E6DC7FA
HTTP_HOST=www.yverdonlesbainsregion.ch
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/alphuetten-karte
PATH_TRANSLATED=/mnt/webroot/sites/otv_yverdon/html/page.cfm
QUERY_STRING=
REMOTE_ADDR=10.235.46.189
REMOTE_HOST=10.235.46.189
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/de/page.cfm
SERVER_NAME=www.yverdonlesbainsregion.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=20657835
CFTOKEN=77495715

Request Parameters:
_testdumpdatasourcedone=true
dumpmode=true
env=Struct (1)
langpath=de
langpathid=2
qlangpath=dt
siteid=118
suffix=

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

Session Variables:
cfid=20657835
cftoken=77495715
fontsize=0
sessionid=REGSITE_YVERDON_20657835_77495715
urltoken=CFID=20657835&CFTOKEN=77495715