Quote:
|
Originally Posted by Zester
What is wrong with this Sub Query:
Code:
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).