Untitled query #71966

SQL

SELECT p.page_title FROM `page` p
inner join logging_logindex l on p.page_id = l.log_page
where log_type = 'move'
and `page_namespace`=1 AND `page_title` like '%/GA_'
and l.log_timestamp > '20230301195300'
union
SELECT page_title FROM page p inner join revision r on p.page_id = r.rev_page
WHERE page_namespace=1 and r.rev_parent_id = 0 AND page_title LIKE "%/GA_" and rev_timestamp >= '20230301195300'
union
select page_title from page p inner join revision r 
on p.page_latest = r.rev_id AND p.page_title LIKE "%/GA_" and p.page_namespace = 1 and r.rev_timestamp > '20230301195300'
SQL

Checking query status...
