Re: Re: Tag Cloud (WAS Deviation? Distribution? OT?)

From: Date: Thu, 03 May 2007 15:00:27 +0000
Subject: Re: Re: Tag Cloud (WAS Deviation? Distribution? OT?)
References: 1 2  Groups: php.general 
Request: Send a blank email to php-general+get-254337@lists.php.net to get a copy of this message
Richard Lynch wrote:
$query = "select tag, popular from (select tag, count(*) as popular from entry_tag group by tag order by popular desc limit 100) as p order by tag";
I'm no expert, and I have no way to test this, but the following should work and gets shot of the sub-select... select tag, count(1) as popular from entry_tag group by tag order by popular desc, tag limit 100 -Stut

« previous php.general (#254337) next »