مقالات أنشئت في ال24 ساعة الماضية حسب حجم الصفحة

SQL

SELECT page_title,page_len
FROM revision
INNER JOIN page ON rev_page = page_id  
WHERE rev_parent_id = 0
    AND page_is_redirect = 0
    AND page_namespace = 0
    AND page_title NOT LIKE "%توضيح%"
    AND page_id NOT IN (
        SELECT tl_from
        FROM templatelinks
        WHERE tl_title = "وصف_صفحة_توضيح"
        OR tl_title = "فهرس_بادئة"
        OR tl_title = "توضيح"
        OR tl_title = "قد_يقصد"
            AND tl_namespace = 10
                )
    #AND rev_timestamp > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY)
 ORDER BY page_len ASC LIMIT 500 ;

SQL

Checking query status...