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 actor_name Like "فيصل"

group by page_title

ORDER BY actor_name DESC

#LIMIT 100;