All pastes #505498 Raw Edit

Miscellany

public sql v1 · immutable
·published 2007-05-23 16:07 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_idDoes not 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 raid_id >= 18GROUP BY raid_id