Competition selection query

gistfile1.sql

select concat(users.first_name, ' ', users.last_name) as 'name', users.postcode, convert_tz(entries.created_at, '-08:00', '+10:30') as 'entered at'
from entries 
left join users on users.id = entries.user_id
where convert_tz(entries.created_at, '-08:00', '+10:30') > '2011-08-14' 
and convert_tz(entries.created_at, '-08:00', '+10:30') < '2011-12-01'
and users.is_admin = 0
and users.email not like '%qwoff%'
and users.email not like '%winecru%'
and users.email not like '%vinomofo%'
order by rand()
limit 20