PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- $q = mysql_query("SELECT date_format(`date`, '%H') AS `hour`, date_format(`date`, '%Y-%m-%d %H:%i:%S') AS `date`, sum(`watches`) AS `hour_watches` FROM table GROUP BY `hour` having `date`>NOW()-INTERVAL 1 DAY ORDER BY `date` ASC;");