use arwiki_p;

select  CONCAT('[[user:',actor_name,']]') AS ' المراجع',

        CONCAT('[[',page_Title,']]') AS 'المقالة المراجعة',

        DATE_FORMAT(log_timestamp, "%d/%m/%Y")  AS 'تاريخ المراجعة'

from logging

INNER JOIN actor ON logging.log_actor = actor.actor_id

LEFT JOIN page ON logging.log_page = page.page_id

where log_action = "approve-i"

and log_namespace = 0

and page_is_redirect = 0

and log_timestamp > DATE_SUB(NOW(), INTERVAL 1 MONTH)

/* تحييد الإداريين */

AND NOT actor_name IN (

                    SELECT user_name 

                            FROM user_groups 

                                INNER JOIN user ON user_id = ug_user 

                                WHERE ug_group = 'sysop'

                    )

#and actor_name Like "Nehaoua"

group by page_title

ORDER BY actor_name DESC

#LIMIT 100;

​