undercategorized ro articles

SQL

/*use rowiki_p;
select CONCAT('* [[',page_title,']]') as "titlu", count(cl_to) as "categorii" from page 
JOIN templatelinks
ON tl_from = page_id
join categorylinks 
on cl_from = page_id
WHERE tl_namespace = 10
AND page_namespace = 0 
and tl_title IN ("Data_nașterii_și_vârsta", "Dnv", "Bda", "Birth_date_and_age")
group by cl_from
having count(cl_to) < 4
order by categorii asc*/
/**/
use rowiki_p;
select CONCAT('* [[',page_title,']]') as "titlu", count(cl_to) from page 
JOIN templatelinks
ON tl_from = page_id
join categorylinks 
on cl_from = page_id
WHERE tl_namespace = 10
AND page_namespace = 0 
and tl_title IN ("Data_nașterii", "Data_decesului", "Death_date", "Birth_date", "Data_decesului_și_vârsta", "Dda", "Ddv")
group by cl_from
having count(cl_to) < 6/**/
SQL

Checking query status...
