busboy — 2011-06-03T18:27:55-04:00 — #1
I have a simple webpage that uses the following query to show me how many emails are in the notifications table waiting to be sent. Most of the time it works great. But when there are some emails that have type = 'Group Email' no rows are returned even though I know for a fact that there is tons of emails waiting to go out.
select priority, type, count(*) as total from notifications where sent is null group by type order by priority
r937 — 2011-06-03T19:05:59-04:00 — #2
that query is fine
if it's not showing you any results for a specific type, then there are only two possibilities -- there are no rows in the table for that specific type, or there are some rows in the table for that specific type, but none of them have a null sent column