 | | | Limit in subquery | Limit in subquery 2005-08-14 - By Pooly
Back
Hi,
I use ther version 4.1.11, and when I run this query :
SELECT c.id,c.subject,c.res_type,c.news_id,c.com_thread,c.timestamp +
0 as timestamp FROM comments c WHERE c.id IN (SELECT d.id FROM
comments d WHERE d.res_type=1 GROUP BY d.news_id ORDER BY d.id DESC
LIMIT 5 ) ORDER BY c.timestamp DESC;
ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT &
IN/ALL/ANY/SOME subquery'
Does anyone know if this limit will be lifted and when ?
Or does anyone know how to write this query in another way ?
I try to pull the last 5 comments that match "res_type=1" but with
only one by news_id and only the last 5 comments.
(I guess I could use a temp table, feed with the 5 matching id, then
join it with the comments table)
--
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
|