tewiki: Stubs (All)

Fork of tewiki:Pages in Stub category, created during period by Chaduvari

This query is marked as a draft This query has been published by Vjsuseela.

SQL

use tewiki_p;
select 
--    actor_name,
	p.page_title,
    p.page_len
 --   rev_timestamp as creation_date

--    concat(mid(rev_timestamp,1,4),"-",mid(rev_timestamp,5,2),"-",mid(rev_timestamp,7,2)) as creation_date
from 
    page p

where 
-- 		page_id=rev_page
-- 	and r.rev_parent_id = 0
--    and actor_id=rev_actor
--   and  page_id=pp_page
     page_id not in (select pp_page from page_props where pp_propname in ('disambiguation'))
    and page_id not in (select cl_from from categorylinks where cl_to like ('%మొలక%'))
    and p.page_len < 4100 
    and p.page_namespace = 0 
    and p.page_is_redirect = 0 
order by p.page_len

SQL

Checking query status...