MySQL
User 'leopompevcmvc' has exceeded the 'max_questions' resource (current value: 64000)

Query

			select
				w.id as websiteId,
				l.id as languageId,
				p.id as pageId,
				w.aliasId,
				
				tw.expression as websiteUrl,
				tp.expression as pageUrl,
				concat(ifNull(tw.expression, ifNull(twf.expression, "")), if(lw.languageId is null, "", concat("/", l.id)), if(tp.expression is null, if(tpf.expression is null, "", concat("/", tpf.expression)), concat("/", tp.expression))) as completeUrl,
				
				twt.expression as websiteMetaTitle,
				twd.expression as websiteMetaDescription,
				twk.expression as websiteMetaKeywords,
				
				tpt.expression as pageMetaTitle,
				tpd.expression as pageMetaDescription,
				tpk.expression as pageMetaKeywords,
				
				if (p.favicon != '', p.favicon, w.favicon) as favicon,
				p.phpClass,
				p.phpData as pagePhpData,
				w.phpData as websitePhpData

			from (
				select id, url, metaTitle, metaDescription, metaKeywords, favicon, defaultLanguageId, 0 as aliasId, phpData
				from website
				
				union all
				
				select w.id, wa.url, wa.metaTitle, wa.metaDescription, wa.metaKeywords, if(wa.favicon = '', w.favicon, wa.favicon) as favicon, wa.defaultLanguageId, wa.id as aliasId, wa.phpData
				from website w
				inner join websiteAlias wa on wa.websiteId = w.id
			) w

			inner join page p on p.websiteId = w.id

			left join language│website lw on lw.websiteId = w.id
			inner join language l on l.id = ifNull(lw.languageId, w.defaultLanguageId)

			left join language│translation tw on tw.translationId = w.url && tw.languageId = l.id
			left join language│translation twf on twf.translationId = w.url && twf.languageId = 'fr'

			left join language│translation tp on tp.translationId = p.url && tp.languageId = l.id
			left join language│translation tpf on tpf.translationId = p.url && tpf.languageId = 'fr'

			left join language│translation twt on twt.translationId = w.metaTitle && twt.languageId = l.id
			left join language│translation twd on twd.translationId = w.metaDescription && twd.languageId = l.id
			left join language│translation twk on twk.translationId = w.metaKeywords && twk.languageId = l.id

			left join language│translation tpt on tpt.translationId = p.metaTitle && tpt.languageId = l.id
			left join language│translation tpd on tpd.translationId = p.metaDescription && tpd.languageId = l.id
			left join language│translation tpk on tpk.translationId = p.metaKeywords && tpk.languageId = l.id
			
			where 'https://leopompes-france.fr/en/pump/LVR32/LVR32-10__F,LVR32-9-2__F' like concat(concat(ifNull(tw.expression, ifNull(twf.expression, "")), if(lw.languageId is null, "", concat("/", l.id)), if(tp.expression is null, if(tpf.expression is null, "", concat("/", tpf.expression)), concat("/", tp.expression))), "%")
			order by length(completeUrl) desc, length(websiteUrl) desc