[TYPO3-dev] Optimizing last 20 query

[John Angel]

Hi Staffan,

It makes things even worse. Now we have "Using temporary":

EXPLAIN SELECT SQL_NO_CACHE * 
FROM (
SELECT crdate, title, uid
FROM pages
WHERE pid
IN ( 1000 ) 
AND deleted =0
AND t3ver_state !=1
AND hidden =0
AND nav_hide =0
) AS cur_pages, (
SELECT bodytext, pid
FROM tt_content
WHERE sys_language_uid =0
AND deleted =0
AND t3ver_state !=1
AND hidden =0
) AS cur_content
WHERE cur_pages.uid = cur_content.pid
ORDER BY cur_pages.crdate DESC 
LIMIT 0 , 20

Regards,
John