SQL
AخA
use arwiki_p;
select page_title, date_format(timediff(current_timestamp,rev_timestamp),
'%k ساعة, %i دقيقة, %s ثانية') from page
inner join categorylinks
on cl_from = page_id
inner join revision
on rev_page = page_id
where cl_to = "جميع_المقالات_غير_المراجعة"
and rev_parent_id = 0
limit 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.