files using template, with short description

SQL

use rowiki_p;
SELECT DISTINCT p.page_title FROM page p
INNER JOIN categorylinks ON cl_to = p.page_id
WHERE p.page_namespace = 6
AND cl_to = 'Copertă album'
AND page_is_redirect=0
AND page_len < 50
/*select p1.page_namespace, p1.page_title, cl1.cl_to from categorylinks as cl1 join page as p1
on cl1.cl_from = p1.page_id
where p1.page_namespace = 6
and exists
(select * from page as p2
 where p2.page_title = cl1.cl_to
 and exists
(select * from categorylinks as cl2
where cl2.cl_to = "Copertă album"
and cl2.cl_from = p2.page_id))
AND page_is_redirect=0
AND page_len < 50*/

SQL

Checking query status...