Re: SELECT / ORDER BY

Hello, This may help. http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html Best, Karl On Sep 11, 2010, at 1:47 AM, Ron Piggott wrote:

I wrote the query below to determine the 10 most popular words used: SELECT COUNT( bible_concordance_usage.reference ) AS word_usage, bible_concordance_words.reference , bible_concordance_words.word FROM bible_concordance_usage INNER JOIN bible_concordance_words ON bible_concordance_usage.bible_concordance_words_reference = bible_concordance_words.reference GROUP BY bible_concordance_usage.bible_concordance_words_reference ORDER BY word_usage DESC, bible_concordance_words.word ASC, bible_concordance_usage.date_accessed DESC LIMIT 10 What I don't like about the results is that if 8 words have been used 5 times then the remaining 2 words the query chooses are from words used 4 times. The results are in alphabetical order A to Z for the words used 5 times and back to A to Z for words used 4 times. My question: is there a way to make my query above into a "sub query" and have a main query order the results of the sub query "ORDER BY words ASC" so all the words displayed are in alphabetical order? Ron Ron --PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Karl DeSaulniers Design Drumm http://designdrumm.com