|
Piotrek Karaś
|
Tuesday 09 March 2010 6:58:28 am
Does anyone have any idea where could an SQL monster like this come from? SELECT e0.id AS e0_id, e0.link AS e0_link, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.is_alias AS e0_is_alias (...) e174.text_md5 AS e174_text_md5, e174.is_alias AS e174_is_alias, e175.id AS e175_id, e175.link AS e175_link, e175.text AS e175_text, e175.text_md5 AS e175_text_md5, e175.action AS e175_action, e175.is_alias AS e175_is_alias
FROM ezurlalias_ml e0, ezurlalias_ml e1, ezurlalias_ml e2, ezurlalias_ml e3, ezurlalias_ml e4, ezurlalias_ml e5, ezurlalias_ml e6, ezurlalias_ml e7, ezurlalias_ml e8, ezurlalias_ml e9, ezurlalias_ml e10, ezurlalias_ml e11, ezurlalias_ml e12, ezurlalias_ml e13, ezurlalias_ml e14, ezurlalias_ml e15 (...) ezurlalias_ml e168, ezurlalias_ml e169, ezurlalias_ml e170, ezurlalias_ml e171, ezurlalias_ml e172, ezurlalias_ml e173, ezurlalias_ml e174, ezurlalias_ml e175
WHERE e0.parent = 0 AND (e0.lang_mask & 3 > 0) AND e0.text_md5 = MD5( 'layout' )
AND e1.parent = e0.link AND (e1.lang_mask & 3 > 0) AND e1.text_md5 = MD5( 'set' )
AND e2.parent = e1.link AND (e2.lang_mask & 3 > 0) AND e2.text_md5 = MD5( 'print' )
AND e3.parent = e2.link AND (e3.lang_mask & 3 > 0) AND e3.text_md5 = MD5( 'layout' )
(...)
AND e172.parent = e171.link AND (e172.lang_mask & 3 > 0) AND e172.text_md5 = MD5( 'set' )
AND e173.parent = e172.link AND (e173.lang_mask & 3 > 0) AND e173.text_md5 = MD5( 'print' )
AND e174.parent = e173.link AND (e174.lang_mask & 3 > 0) AND e174.text_md5 = MD5( 'ezinfo' )
AND e175.parent = e174.link AND (e175.lang_mask & 3 > 0) AND e175.text_md5 = MD5( 'about' )
LIMIT 0, 1
Please mind, that I cut most of it out... look at the numbers ;) Is that something related to the infamous multilingual URL alias problem?
Thanks for any thoughts,
Piotrek
--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu
|