templ-page-cat-user-draft

SQL

USE rowiki_p;
SELECT /*CONCAT('# [[', */page_title/*, ']]') AS page_title, DATE_FORMAT(rev_timestamp,"%Y-%m-%d") AS rev_timestamp, page_len*/
FROM page, revision, templatelinks, categorylinks 
WHERE page.page_id = revision.rev_page 
AND page.page_id = templatelinks.tl_from
and categorylinks.cl_from = page.page_id
AND tl_namespace = 10
AND tl_title = 'Infocaseta_Astru'
AND rev_user_text = 'X-bot'
and cl_to not like "Centura_de_asteroizi"
AND page_namespace = 0
AND rev_parent_id = 0
/*AND page_is_redirect = 0*/
ORDER BY page_title/*, rev_timestamp, page_len*/
group by page_title;
SQL

Checking query status...
