I have a query:
SELECT Country, COUNT( Country ) AS Cnt FROM properties WHERE (
Country != 'USA' AND Country != 'US' AND Country != 'Unit' AND Country
!= 'United States' AND Country != ' ' AND Country IS NOT NULL ) GROUP
BY Country ORDER BY Cnt DESC LIMIT 8
that gets the top 8 non-US countries
On Fri, Jul 25, 2008 at 12:27 AM, Michael Stearne [EMAIL PROTECTED] wrote:
I have a query:
SELECT Country, COUNT( Country ) AS Cnt
FROM properties WHERE (
Country != 'USA' AND
Country != 'US' AND
Country != 'Unit' AND
Country != 'United States'
AND Country !=
On Fri, Jul 25, 2008 at 12:35 PM, Arthur Fuller [EMAIL PROTECTED] wrote:
ORDER BY implies a sort of the result set. I don't think there is any way
around that.
I guess so. What I am doing is to just run the query once per day and
store the results in memcache.
Michael
Arthur
On Fri, Jul
Hi All,
I have a query which takes approximately 0.5 seconds to execute , it is as
follows
SELECT gamename, MAX(score) AS score, COUNT(valid=1) AS played FROM
gamesessions AS gamesessions
WHERE valid=1 AND sessiontype IN (1,2)
GROUP BY gamename;
EXPLAIN SELECT gives me this, also there is an
Kishore Jalleda [EMAIL PROTECTED] wrote on 10/13/2005 02:25:52 PM:
Hi All,
I have a query which takes approximately 0.5 seconds to execute , it is
as
follows
SELECT gamename, MAX(score) AS score, COUNT(valid=1) AS played FROM
gamesessions AS gamesessions
WHERE valid=1 AND sessiontype IN
That was an excellent reply, I always see you helping so many people, keep
the great work going ..
Sincerely,
Kishore Jalleda
On 10/13/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Kishore Jalleda [EMAIL PROTECTED] wrote on 10/13/2005 02:25:52 PM:
Hi All,
I have a query which takes
Hi!
I've found this in:
http://www.mysql.com/information/presentations/presentation-oscon2000-2719/
Instead of doing a lot of |GROUP BY|s on a big table, create summary
tables of the big table and query this instead.
Would you please tell me how to create summary tables that can help me
get