[TYPO3-core] Announcing TYPO3 4.5.18, 4.6.11 and 4.7.3

[Jigal van Hemert]

Hi,

On 8-8-2012 19:16, Stefan Frömken wrote:
> This one produces the problems:
>
> http://forge.typo3.org/projects/typo3v4-core/repository/revisions/b846f3d219e2280b2b967b7f1a3c017060815125/diff/typo3/sysext/cms/tslib/class.tslib_content.php
>
>
> http://forge.typo3.org/issues/34152
>
> I try to reopen the report.

The query your TS generates is:

SELECT pages.uid, pages.title, tt_content.uid as uid, tt_content.pid as 
pid, tt_content.t3ver_state as t3ver_state FROM tt_content LEFT OUTER 
JOIN pages ON (tt_content.pid = pages.uid) WHERE tt_content.pid IN 
(1,2,3,4,5,6,7,8,9,10,11,13,14,15,16,17,18,19,20,21,22) AND nav_hide = 0 
AND tt_content.deleted=0 AND tt_content.t3ver_state<=0 AND 
tt_content.pid<>-1 AND tt_content.hidden=0 AND 
tt_content.starttime<=1344455700 AND (tt_content.endtime=0 OR 
tt_content.endtime>1344455700) AND (tt_content.fe_group='' OR 
tt_content.fe_group IS NULL OR tt_content.fe_group='0' OR 
FIND_IN_SET('0',tt_content.fe_group) OR 
FIND_IN_SET('-1',tt_content.fe_group)) GROUP BY tt_content.pid ORDER BY 
MAX(tt_content.tstamp) DESC LIMIT 7

The uid field plus a few others from tt_content are added and this field 
is used instead of pages.uid in the typolink.

Workaround is to use the pages table as the base:

     table = pages
     select {
         orderBy = MAX(tt_content.tstamp) DESC
         groupBy = tt_content.pid
         pidInList = 1
         recursive = 10
         max = 7
         where = nav_hide = 0
         selectFields = pages.uid, pages.title
         rightjoin = tt_content ON (tt_content.pid = pages.uid)
     }


-- 
Jigal van Hemert
TYPO3 Core Team member

TYPO3 .... inspiring people to share!
Get involved: typo3.org