UNION ALL query help
| From: | Ron Piggott | Date: | Sun, 25 Apr 2010 00:50:20 +0000 |
| Subject: | UNION ALL query help | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47087@lists.php.net to get a copy of this message | ||
I am received the error message:
Unknown column 'title' in 'field list'
from the query below. I am not understanding what I have done wrong. The
goal of the query is with for a RSS feed determining the 15 most current
articles.
Ron
SELECT title, content_date, content, reference FROM ( (
SELECT
page_title, last_update, 'article',
reference FROM
user_pages WHERE include_in_highlights =1 ORDER BY
last_update DESC
LIMIT 15
) UNION ALL (
SELECT blog.entry_title, blog.entry_date,
blog.entry,
blog.reference FROM blog WHERE blog_owners_reference =1 ORDER BY
blog.entry_date DESC, blog.reference DESC LIMIT 15
) ) AS rss_feed ORDER BY rss_feed.content_date DESC LIMIT 15