Bug #84949
closedTS select join rewrite FROM to ON
0%
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
Updated by Loon Buster over 6 years ago
- Priority changed from Should have to Must have
very interesting to see how nobody here is responsible for it - so why somebody change it in that senseless way? maybe this person have no idea from subquery :|
annoying.
Updated by Loon Buster over 6 years ago
- Category changed from TypoScript to Frontend
Updated by balli Halli almost 6 years ago
- Start date changed from 2018-05-08 to 2018-12-12
- Tags set to TS SELECT JOIN
Any news on this?
I am facing the same problem and therefore I can't update my installation.
Updated by Susanne Moog over 4 years ago
- Status changed from New to Needs Feedback
Hey,
can you post the query you expected this to result in and the query that is actually generated? In general, a join in probably not the right place for the subselect you want to add here.
Updated by Loon Buster over 4 years ago
Susanne Moog wrote:
Hey,
can you post the query you expected this to result in and the query that is actually generated? In general, a join in probably not the right place for the subselect you want to add here.
..well; no.
i developed a workaround and now, after last 2 years, t3v8 is outdated. so why i should waste my time to find any bugs?
.loon