Here is the texte displaid in debug mode :
ts FROM 4jx_slim_stats WHERE dt BETWEEN 1433116800 AND 1433856406
SELECT dt, COUNT(ip) first_metric, COUNT(DISTINCT(ip)) second_metric FROM 4jx_slim_stats WHERE 1=1 AND (dt BETWEEN 1430438400 AND 1433116799 OR dt BETWEEN 1433116800 AND 1433856406) GROUP BY MONTH(CONVERT_TZ(FROM_UNIXTIME(dt), @@session.time_zone, ‘+00:00’)), DAY(CONVERT_TZ(FROM_UNIXTIME(dt), @@session.time_zone, ‘+00:00’))
SELECT dt, COUNT(DISTINCT visit_id) first_metric, COUNT(DISTINCT ip) second_metric FROM 4jx_slim_stats WHERE (visit_id > 0 AND browser_type <> 1) AND (dt BETWEEN 1430438400 AND 1433116799 OR dt BETWEEN 1433116800 AND 1433856406) GROUP BY MONTH(CONVERT_TZ(FROM_UNIXTIME(dt), @@session.time_zone, ‘+00:00’)), DAY(CONVERT_TZ(FROM_UNIXTIME(dt), @@session.time_zone, ‘+00:00’))
SELECT dt, COUNT(DISTINCT(referer)) first_metric, COUNT(DISTINCT(ip)) second_metric FROM 4jx_slim_stats WHERE (referer IS NOT NULL AND referer NOT LIKE “%https://www.vive-le-piano.com%”) AND (dt BETWEEN 1430438400 AND 1433116799 OR dt BETWEEN 1433116800 AND 1433856406) GROUP BY MONTH(CONVERT_TZ(FROM_UNIXTIME(dt), @@session.time_zone, ‘+00:00’)), DAY(CONVERT_TZ(FROM_UNIXTIME(dt), @@session.time_zone, ‘+00:00’))