Hi,
my table
CREATE TABLE IF NOT EXISTS si_stats_access (
id BIGINT UNSIGNED NOT NULL auto_increment,
session_id CHAR(64) NOT NULL,
fb_id BIGINT unsigned DEFAULT NULL,
domain_id INT UNSIGNED NOT NULL,
browser_id SMALLINT NOT NULL,
so_id SMALLINT NOT NULL,
device_id SMALLINT NOT NULL,
referer_id SMALLINT DEFAULT NULL,
ip VARCHAR(15) NOT NULL,
log_fb_datetime DATETIME DEFAULT NULL,
access_start_datetime DATETIME NOT NULL,
access_end_datetime DATETIME DEFAULT NULL,
country_code CHAR(2) DEFAULT NULL,
country_name VARCHAR(255) DEFAULT NULL,
region_code TINYINT DEFAULT NULL,
region_name VARCHAR(255) DEFAULT NULL,
city VARCHAR(255) DEFAULT NULL,
lat FLOAT( 10, 6 ) DEFAULT 0 ,
lng FLOAT( 10, 6 ) DEFAULT 0,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

my query

SELECT 1 as stats_type_id, domain_id, DATE (access_start_datetime) as date, COUNT (id) as value
FROM si_stats_access
GROUP BY domain_id, DATE(access_start_datetime);

it doesn't work I get only a domain id

as usual can you help me please ?