hrwiki – nepatrolirane promjene po datumu

SQL

SET @from = "20231002";
SET @to   = DATE_FORMAT(@from + INTERVAL 3 DAY, "%Y%m%d");

SELECT page_title, rev_page, rev_id, rev_timestamp, rev_actor, actor_name, ug_group FROM revision
JOIN actor ON actor_id = rev_actor 
JOIN page ON page_id = rev_page
LEFT JOIN user_groups ON ug_user = actor_user
WHERE 
    /*actor_user is NOT NULL AND */
    rev_timestamp BETWEEN @from AND @to
/*AND ug_group not in ("autopatrolled","sysop","patrooller","bot","ipblock-exempt","bureaucrat","interface-admin","flood")*/
LIMIT 200
;

SQL

Checking query status...