Untitled query #76743

SQL

-- Daty początku i końca podawane są w formacie RRRR-MM-DD HH:MM:SS według strefy czasowej CEST
WITH
	user_timetable(ut_username, ut_start_time, ut_end_time) AS (
		SELECT "Msz2001", "2022-09-19 06:00:00", "2022-09-19 11:45:00"
    	UNION ALL SELECT "Msz2001", "2022-09-19 13:00:00", "2022-09-19 18:50:00"
      	UNION ALL SELECT "Msz2001", "2022-09-20 10:00:00", "2022-09-20 14:00:00"
	),
	-- Przelicz daty na format MediaWiki
	user_timetable_mw(utm_username, utm_start_time, utm_end_time) AS (
		SELECT
  			ut_username,
  			DATE_FORMAT(DATE_ADD(STR_TO_DATE(ut_start_time, "%Y-%m-%d %H:%i:%s"), INTERVAL -2 HOUR), "%Y%m%d%H%i%s"),
  			DATE_FORMAT(DATE_ADD(STR_TO_DATE(ut_end_time, "%Y-%m-%d %H:%i:%s"), INTERVAL -2 HOUR), "%Y%m%d%H%i%s")
 		FROM user_timetable
	)
SELECT
	DATE_FORMAT(
      DATE_ADD(
        STR_TO_DATE(rev_timestamp, "%Y%m%d%H%i%s"),
        INTERVAL 2 HOUR -- Zakładamy, że jesteśmy w CEST, czyli 2 godziny do przodu względem UTC
      ),
      "%Y-%m-%d %H:%i:%s"
    ) AS "Czas",
    user_name AS "Użytkownik",
    CONCAT(
      CASE
      	WHEN page_namespace = 10 THEN "Szablon:"
      	WHEN page_namespace = 14 THEN "Kategoria:"
      	ELSE ""
      END,
      REPLACE(page_title, "_", " ")
    ) AS "Strona"
FROM revision
	JOIN page ON page_id = rev_page
	JOIN actor ON rev_actor = actor_id
    JOIN user ON actor_user = user_id
    JOIN user_timetable_mw ON user_name = utm_username
    	AND rev_timestamp >= utm_start_time
        AND rev_timestamp <= utm_end_time
    WHERE page_namespace IN (0, 10, 14) -- PG, szablon, kategoria
    ORDER BY rev_timestamp ASC;
SQL

Checking query status...
