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 ;