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

[Stefan Frömken]

Thanks for this workaround and the full Query. I have found a solution 
for my problem already. I habe given the uid-field a name:

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

	renderObj = TEXT
	renderObj {
	  field = title
	  required = 1
	  typolink.parameter.field = pageUid
	  typolink.ATagParams = class=internal-link
	  wrap = <li>|</li>
	}
	wrap = <h2>Meine zuletzt bearbeiteten Inhalte</h2><ul>|</ul>
}

Am 08.08.2012 22:05, schrieb 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)
>      }
>
>