My query is the following:
SELECT count(db.user_data.page_url) AS total_urls, db.authors.author FROM db.authors LEFT JOIN db.user_data ON db.authors.author_id = db.user_data.id WHERE (db.user_data.date > (now() - INTERVAL 30 MINUTE)) AND db.user_data.domain LIKE '%example.com%' GROUP BY author;
It returns all results between
now() and last 30 minutes, that's fine. But those results are based on period (interval) of 30 minutes starting from current moment (in seconds).
How to select all rows based on
now() - INTERVAL 30 MINUTE ,but including all results from the last 30-th minute inclusively? Because now the interval is "moving" by current moment + 30 last minutes.
So each new second I am getting different results, because of "sliding", "moving" interval?