https://www.icyphoenix.com/viewtopic.php?f=26&t=7759&p=52259#p52259
-----------------------------------
Informpro
Sun 03 Apr, 2011 16:17

Re: Mysql Query With Rank
-----------------------------------
(use code syntax=php !)
For the group query, use something like [code]AND g.group_id NOT IN (1, 2, 3, 4, 5, 43)[/code]Much more readable than [code]                    AND g.group_id <> 1
                    AND g.group_id <> 2
                    AND g.group_id <> 3
                    AND g.group_id <> 4
                    AND g.group_id <> 5
                    AND g.group_id <> 43[/code]For everything else, it looks good. Nice job ;-).