#84949TS select join rewrite FROM to ON
Description
hello.
that works perfect in 6.x and 7.x;
# $xxx.xxx.xxx is just the uid from the page i want my content f.e. 12 or 114 etc
tmp.lang.stdWrap.cObject = COA
tmp.lang.stdWrap.cObject {
10=TEXT
10.value < config.sys_language_uid
10.wrap = |,{$language.defaultuid}
}
test = CONTENT
test {
table = tt_content
select {
pidInList = {$xxx.xxx.xxx}
join.stdWrap.cObject = COA
join.stdWrap.cObject {
10=TEXT
10.value = (SELECT sys_language_uid FROM `tt_content` WHERE (pid=
12=TEXT
12.value = {$xxx.xxx.xxx})AND(sys_language_uid IN (
15=TEXT
15.value < tmp.lang
20= TEXT
20.value = ) AND deleted=0 AND hidden=0) ORDER BY FIELD(sys_language_uid,
25=TEXT
25.value < tmp.lang
30= TEXT
30.value = ) LIMIT 1) AS tab2 ON (tt_content.sys_language_uid = tab2.sys_language_uid)
}
where = (colPos=0)
orderBy = tt_content.sorting
languageField = 0
}
now in 8.x ts ignored perfectly :(
.loon
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.