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

[Lionel B. <lio...@bo...>]

Michael Storz wrote the following on 29.04.2005 09:58 :

>On Thu, 28 Apr 2005, Who Knows wrote:
>  
>
>>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|
>>
>>    
>>
>
>The same error appeared at my installation. That's the reason why I use
>the command
>
>  
>

I'm a PostgreSQL (8.0.1) user :-) Forgot to fire SQLite and MySQL to
test my query... Michael queries or fine for MySQL (you may want to
replace host_ip with src if you use SQLgrey 1.5.x though).

Lionel