Hello!
could you please help me construct proper mysql query. I spent 8 hours
with testing, but no proper results :((
I have a LOG with at least "ID" and "recipient" fields.
I want to extract last 15 different recipients.
I tried this:
SELECT ID DISTINCT recipients
FROM log_table
GROUP BY recipients
ORDER BY ID DESC
LIMIT 15
But this returns some unknown 15 different recipients, but not 15
last. Could you help me, please?
--
Regards,
Andrej
--------------------------------
e-mail: labsy@stripped
Tel.: +386 (0)7 45 210 44
GSM : +386 (0)41 233 335
--------------------------------