[thelist] mysql join and subqueries

[Matt Warden]

> SELECT logins.member_id, count(*) AS logincount
>    FROM logins INNER JOIN profile
>      ON logins.member_id = profile.member_id
>    WHERE city = 'vancouver' AND category_id = '0' AND
>      profile_data LIKE '%three%'
>    GROUP BY logins.member_id
>    ORDER BY logincount DESC
>    LIMIT 0, 20

Phil,

I believe the city field is in the members table, so the join with
members is required.

-- 
Matt Warden
Miami University
Oxford, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.