maria-discuss team mailing list archive

[Benoit Panizzon <benoit.panizzon@xxxxxx>]

Hi Kristian

> Maybe try something like this (untested):
> 
> SELECT *
>   FROM (SELECT mail_out_anon+mail_out_auth ss, timeslice
>           FROM domaincounters
>          WHERE domain_id=19
>          ORDER BY timeslice desc
>          LIMIT 24) tmp
>  ORDER BY ss DESC
>  LIMIT 1;

Thank you, that is the solution I was looking for.

Justin, you cannot have a subquery on the same table within your query. My 
previous attempt was to return the ID's of the last 24 timeslices in a 
subquery and then MAX() them. But MariaDB prevents this kind of query.

Mit freundlichen Grüssen

Benoit Panizzon
-- 
I m p r o W a r e   A G    -    
______________________________________________________

Zurlindenstrasse 29             Tel  +41 61 826 93 07
CH-4133 Pratteln                Fax  +41 61 826 93 02
Schweiz                         Web  http://www.imp.ch
______________________________________________________