మొలకలు (మొత్తం, వాడుకరి, శీర్షిక, బైట్)

SQL

use tewiki_p;
select distinct 
    actor_name వాడుకరి పేరు,
    p.page_count,
    p.page_len 
from 
	revision r, 
    page p,
    actor,
    page_props
where 
	r.rev_parent_id = 0
    and actor_id=rev_actor
    and rev_page=page_id
    and page_id=pp_page
    and page_id not in (select pp_page from page_props where pp_propname in ('disambiguation'))
    and r.rev_len < 2049 
    and p.page_len < 2049 
    and p.page_namespace = 0 
    and p.page_is_redirect = 0 
    and rev_timestamp < '20230000000000' 
    and rev_timestamp > '20050000000000' 
    and r.rev_page = p.page_id
order by page_len desc

SQL

Checking query status...