templ-page-cat-user-draft

SQL

USE rowiki_p;/* */
SELECT CONCAT('Discuție:', page_title, ']]') AS page_title#page_title#
FROM page as p1
#join revision on page.page_id = revision.rev_page 
join templatelinks on p1.page_id = templatelinks.tl_from
#join categorylinks on page.page_id = categorylinks.cl_from #and cl_to = "Centura_de_asterorizi"
#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 cl_to like "Centura_de_asterorizi"
AND tl_title like "NavigatorPlaneteMinore"
#AND rev_user_text = "..."
AND page_namespace = 0 and NOT EXISTS (SELECT
                     1
                   FROM page AS p2
                   WHERE p2.page_namespace = 1
                   AND p1.page_title = p2.page_title)
#AND rev_parent_id = 0
#AND page_is_redirect = 0
#GROUP BY page_id;/* */
ORDER BY page_title#, rev_timestamp, page_len
#select * from category where cat_id = 41905
SQL

Checking query status...
