Re: Cannot use COUNT() or user defined columns in select where clause

[Steffan]

Oops, the query that works is supposed to be:

SELECT `account`.`id`, `account`.`screenname`, `partychat_host`.`slots`-(COUNT(`partychat_user`.`pid`)-1) as `slots_left`
FROM `account`, `lock`, `partychat_host`, `partychat_user`
WHERE
(
`account`.`id` = `lock`.`userid`
AND
`lock`.`listing` = '0'
AND
`lock`.`listing_self` != '1'
AND
`account`.`confcode` = ''
AND
`partychat_host`.`userid` = `account`.`id`
AND
`partychat_user`.`pid` = `partychat_host`.`pid`
)
group by `partychat_user`.`pid`
ORDER BY `partychat_host`.`date_chat`