Approved pages tagged with {{غير مراجعة}}

Fork of Approved pages tagged with {{غير مراجعة}} by ASammour

This query is marked as a draft This query has been published by ASammour.

SQL

use arwiki_p;
select logging.log_title from logging
where logging.log_namespace = 0
and logging.log_page not in (select cl_from from categorylinks where cl_to like "جميع_المقالات_غير_المراجعة")
and logging.log_page not in (select l1.log_page from logging l1 where l1.log_page = logging.log_page and l1.log_action like "approve-i")
/*and logging.log_id = (select max(l1.log_id) from logging l1 where l1.log_id = logging.log_id and l1.log_namespace = 0 and l1.log_action like "%approve%")*/

SQL

Checking query status...