Re: [PHP-DB] 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