check categories [lvwiki]

SQL

use lvwiki_p;
SELECT p.page_title, GROUP_CONCAT(cl_to SEPARATOR '|') FROM page p
INNER JOIN categorylinks cl ON cl.cl_from = p.page_id
WHERE p.page_namespace=0 and p.page_is_redirect=0 and p.page_id not in (select cl_from
							from categorylinks
							where cl_to="Nekategorizētie_raksti")
group by p.page_id
limit 10;

SELECT p2.page_title
from page p2 ON cl.cl_to = p2.page_title AND p2.page_namespace = 14 # 14 = Category
JOIN page_props pp ON pp.pp_page = p2.page_id AND pp.pp_propname = 'hiddencat'
limit 15;
SQL

Checking query status...
