Another UNION ALL query

[email protected] ("Ron Piggott")
Newsgroups php.db
Message-ID <2929cea2af1e6c9f3f8b3a1fcc827afa.squirrel@www.theverseoftheday.info>
I have a 'Highlights' heading on my home page.  It is for links to content
on the site ... like specific web pages

I have designed the query below to select the two most popular and least
popular pages used on the site to be the Highlights.  (Each time a web
page is accessed user_hits is increased by 1.)

I would like to display a fifth one that is " ORDER BY RAND () LIMIT 1 "
--- Only I don't know how to ensure it isn't one of the four that are
being displayed already.  Any suggestions?

Ron



SELECT `highlights`.`reference`, `highlights`.`page_command`,
`highlights`.`page_title` FROM (

( SELECT `reference`, `page_command`, `page_title` FROM `user_pages` WHERE
 `include_in_highlights` =1 ORDER BY `user_hits` DESC LIMIT 2 )

UNION ALL

( SELECT `reference`, `page_command`, `page_title` FROM `user_pages` WHERE
 `include_in_highlights` =1 ORDER BY `user_hits` ASC LIMIT 2 )

) AS highlights ORDER BY `highlights`.`page_title` ASC
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.