Re: [Sqlgrey-users] Spammer alex@hotmail.com benefits from from_awl

[Who K. <qui...@me...>]

Lionel Bouton wrote:

>
>I'll do this for 1.5.6.
>
>A quick question though. I'm wondering if a "src_awl" would be of any
>use, could people with large sites check how many entries they have in
>domain_awl for the same src ?
>I'm interested in the results of
>SELECT src, count(*) FROM domain_awl GROUP BY src ORDER BY -count(*)
>LIMIT 10;
>and
>SELECT count(*) FROM domain_awl;
>  
>
I'm running mysql-server-3.23.58-4 and it failed attemping your query

*SQL-query:* Documentation <http://dev.mysql.com/doc/mysql/en/SELECT.html>

SELECT src, count( * )
FROM domain_awl
GROUP BY src
ORDER BY - count( * )
LIMIT 10

*MySQL said: *Documentation 
<http://dev.mysql.com/doc/mysql/en/Error-returns.html>

| #1111 - Invalid use of group function|