FYI mysql> select reporter, count(*) as cnt, profiles.login_name from bugs,profiles where userid=reporter group by reporter having cnt > 6 order by cnt desc; +----------+-----+---------------------------------------+ | reporter | cnt | login_name | +----------+-----+---------------------------------------+ | 6567 | 90 | [EMAIL PROTECTED] | | 2132 | 51 | [EMAIL PROTECTED] | | 6737 | 34 | [EMAIL PROTECTED] | | 5627 | 33 | [EMAIL PROTECTED] | | 6219 | 29 | [EMAIL PROTECTED] | | 6756 | 25 | [EMAIL PROTECTED] | | 6513 | 21 | [EMAIL PROTECTED] | | 6199 | 20 | [EMAIL PROTECTED] | | 6179 | 18 | [EMAIL PROTECTED] | | 6197 | 18 | [EMAIL PROTECTED] | | 5043 | 17 | [EMAIL PROTECTED] | | 151 | 16 | [EMAIL PROTECTED] | | 6933 | 16 | [EMAIL PROTECTED] | | 451 | 16 | [EMAIL PROTECTED] | | 184 | 14 | [EMAIL PROTECTED] | | 1248 | 13 | [EMAIL PROTECTED] | | 6560 | 13 | [EMAIL PROTECTED] | | 807 | 12 | [EMAIL PROTECTED] | | 9 | 10 | [EMAIL PROTECTED] | | 2721 | 10 | [EMAIL PROTECTED] | | 177 | 9 | [EMAIL PROTECTED] | | 6396 | 9 | [EMAIL PROTECTED] | | 757 | 9 | [EMAIL PROTECTED] | | 6810 | 9 | [EMAIL PROTECTED] | | 6551 | 9 | [EMAIL PROTECTED] | | 6377 | 8 | [EMAIL PROTECTED] | | 1613 | 8 | [EMAIL PROTECTED] | | 6849 | 8 | [EMAIL PROTECTED] | | 49 | 8 | [EMAIL PROTECTED] | | 5709 | 7 | [EMAIL PROTECTED] | | 6236 | 7 | [EMAIL PROTECTED] | | 1847 | 7 | [EMAIL PROTECTED] | | 6853 | 7 | [EMAIL PROTECTED] | | 887 | 7 | [EMAIL PROTECTED] | | 911 | 7 | [EMAIL PROTECTED] | | 6352 | 7 | [EMAIL PROTECTED] | | 1123 | 7 | [EMAIL PROTECTED] | | 5589 | 7 | [EMAIL PROTECTED] | | 2777 | 7 | [EMAIL PROTECTED] | +----------+-----+---------------------------------------+ 39 rows in set (0.02 sec)
Thanks to all of them ! -- Warly