All pastes #505504 Raw Edit

Miscellany

public sql v1 · immutable
·published 2007-05-23 16:11 UTC
rendered paste body
WORKS:SELECT phpraid_signups.raid_id , COUNT(*) AS signedup_count, IFNULL( phpraid_raids.max, 0 ) as maxFROM phpraid_signups LEFT JOIN phpraid_raids ON ( phpraid_signups.raid_id = phpraid_raids.raid_id)WHERE cancel =0AND queue =0GROUP BY raid_idWill work:SELECT phpraid_signups.raid_id , COUNT(*) AS signedup_count, IFNULL( phpraid_raids.max, 0 ) as maxFROM phpraid_signups LEFT JOIN phpraid_raids ON ( phpraid_signups.raid_id = phpraid_raids.raid_id)WHERE cancel =0AND queue =0AND phpraid_raids.raid_id >= 18GROUP BY phpraid_raids.raid_id