templ-page-cat-user-draft

SQL

USE rowiki_p;/* */
SELECT page_title
FROM page
#join revision on page.page_id = revision.rev_page 
join templatelinks on page.page_id = templatelinks.tl_from
join categorylinks on page.page_id = categorylinks.cl_from
#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*/
where tl_namespace = 10
AND tl_title = "Infocaseta_Astru"
AND tl_title not like "NavigatorPlaneteMinore"
#AND rev_user_text = "..."
#and cl_to not like "Centura_de_asterorizi"
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...
