Tewiki: Stubs create din 2020

SQL

use tewiki_p;
select DISTINCT
    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 
	revision r, 
    page p,
    actor,
    page_props
where 
		page_id=rev_page
	and r.rev_parent_id = 0
    and actor_id=rev_actor
    and page_id=pp_page
    and 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 < 2049 
    and p.page_namespace = 0 
    and p.page_is_redirect = 0 
order by page_len desc
SQL

Checking query status...
