SQL masters:

[Zester]

What is wrong with this Sub Query:

SELECT date 
FROM  `records` 
WHERE  STATUS  =  'published' 
AND date = ( select max(date) FROM `records` )
LIMIT = 25;

it's suppose to spit out the date of the latest 25 articles in 'published' status and nothing more.

[everestcash]

i was thinking, is there a way to rewrite that query using 'order by id' or 'date' instead, without using a sub query. That'll be a simpler approach.

like

select from `records` where status = 'published' order by id desc limit 0, 25;

[ddfGandalf]

select date from records where status='published' order by date desc LIMIT 25;

[woj]

select from `records` where status = 'published' order by id desc limit 0, 25;

[Pryda]

What is wrong with this Sub Query:

SELECT date 
FROM  `records` 
WHERE  STATUS  =  'published' 
AND date = ( select max(date) FROM `records` )
LIMIT = 25;

it's suppose to spit out the date of the latest 25 articles in 'published' status and nothing more.

Your query wants up to 25 record dates for articles published on the same date as the most recent record (published or not).

[sickbeatz]

SELECT date
FROM `records`
WHERE STATUS = 'published' ORDER BY date DESC LIMIT 25;