Code: Select all
SELECT countrynick, COUNT(DISTINCT ipadresse) AS Count, FROM_UNIXTIME(runtime, '%Y-%m-%d') AS DateNow FROM besog_log WHERE kundeid = '6' GROUP BY countrynick, FROM_UNIXTIME(runtime, '%Y-%m-%d') ORDER BY Count DESCbot is return this dato to me
countrynick Count DateNow
DK - 21 - 2006-03-28
XX - 4 - 2006-03-28
DK - 1 - 2006-03-29
US - 1 - 2006-03-28
BG - 1 - 2006-03-28
i will hav it to look like follow
countrynick Count
DK - 22
XX - 4
US - 1
BG - 1