[MySQL]Zapytanie sql Opcje

[meehow18]

Witam,
mam takie zapytanie:

[SQL] pobierz, plaintext 
SELECT COUNT('subscriber_id') AS  `count`, DATE_FORMAT( FROM_UNIXTIME(  `date` ), '%d' ) AS  'day', DATE_FORMAT( FROM_UNIXTIME(  `date` ), '%Y-%m-%d' ) AS  'date_formatted'
FROM `subscribers`
LEFT JOIN `autoresponder` ON `subscribers`.`id_autoresponder` = `autoresponder`.`id_autoresponder`
LEFT JOIN `users` ON `autoresponder`.`user_id` = `users`.`user_id`
WHERE `users`.`user_id` = 12
AND `date` >= 1470348295
AND `date` <= 1470953095
AND `subscribers`.`active` = 1
GROUP BY `date` 
ORDER BY `date_formatted` ASC
[SQL] pobierz, plaintext 

Wszystko było by ok, ale czasami zwraca mi:

[PHP] pobierz, plaintext 
Array
        (
            [0] => Array
                (
                    [count] => 1
                    [day] => 09
                    [date_formatted] => 2016-08-09
                )
 
            [1] => Array
                (
                    [count] => 1
                    [day] => 09
                    [date_formatted] => 2016-08-09
                )
 
            [2] => Array
                (
                    [count] => 1
                    [day] => 11
                    [date_formatted] => 2016-08-11
                )
 
        )
 
[PHP] pobierz, plaintext 

A chciałbym, aby zwróciło:

[PHP] pobierz, plaintext 
Array
        (
            [0] => Array
                (
                    [count] => 2
                    [day] => 09
                    [date_formatted] => 2016-08-09
                )
 
 
            [1] => Array
                (
                    [count] => 1
                    [day] => 11
                    [date_formatted] => 2016-08-11
                )
 
        )
 
[PHP] pobierz, plaintext 

[darko]

Spróbuj z distinct:

SELECT DISTINCT COUNT('subscriber_id') AS `count`, ...

[meehow18]

Właśnie też próbowałem i też lipa, bo nie zlicza tego drugiego.

[PHP] pobierz, plaintext 
Array
        (
            [0] => Array
                (
                    [count] => 1
                    [day] => 09
                    [date_formatted] => 2016-08-09
                )
 
            [1] => Array
                (
                    [count] => 1
                    [day] => 11
                    [date_formatted] => 2016-08-11
                )
 
        )
[PHP] pobierz, plaintext 

[mmmmmmm]

GROUP BY DATE_FORMAT( FROM_UNIXTIME( `date` ), '%Y-%m-%d' )
zamiast
GROUP BY `date`

[meehow18]

ok dzięki
dałem GROUP BY 'date_formatted' bo to ta sama wartość i działa ladnie