Untitled query #72634

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 in (select cl_from from categorylinks where cl_to like ('%మొలక%'))
    and p.page_len > 3000 
    and p.page_namespace = 0 
    and p.page_is_redirect = 0 
order by p.page_len desc
SQL

Checking query status...
