Untitled query #76743

SQL

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
    WHERE
    	page_namespace IN (0, 10, 14) -- PG, szablon, kategoria
    	AND user_name IN ("Msz2001", "Piastu", "Michał Sobkowski")
        AND rev_timestamp >= "20220501000000"
        AND rev_timestamp < "20220930235959";
SQL

Checking query status...
