آخری چوبیس گھنٹوں میں بننے والے نئے مضامین

SQL

select count(rc_title)
from recentchanges 
join page on rc_cur_id=page_id 
where rc_new=1 and rc_namespace=0 
and page_is_redirect=0 
/*and page.page_len>70*/
and rc_deleted=0 
and DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY)<rc_timestamp; 


SELECT page_title, page_len, actor_name
FROM revision
JOIN actor ON rev_actor = actor_id
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 rev_timestamp > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY)
 ORDER BY page_len ASC LIMIT 500 ;

SQL

Checking query status...