templ-page-cat-user-draft

SQL

USE rowiki_p;/*
SELECT page_title
#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 page.page_id = categorylinks.cl_from
AND tl_namespace = 10
AND tl_title = "Infocaseta_Astru"
AND rev_user_text = "X-bot"
and cl_to not like "Centura_de_aste%"
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_id;*/
select * from category where cat_id = 41905
SQL

Checking query status...
