USE commonswiki_p;

SELECT c.cl_to AS category,

COUNT(DISTINCT file.page_id) AS total

FROM page AS file

INNER JOIN categorylinks AS c ON file.page_id=c.cl_from AND c.cl_to NOT IN ("Photographs_by_Paolo_Monti")

INNER JOIN categorylinks AS cc ON file.page_id=cc.cl_from AND cc.cl_to IN ("Photographs_by_Paolo_Monti")

LEFT JOIN page AS p ON p.page_namespace = 14 AND p.page_title = c.cl_to

WHERE c.cl_to NOT REGEXP "Media_from_BEIC|Files_from|CC-BY|Files_with|test_|Uploaded_with|Self-pub|Items_with_OTRS|GFDL|FAL|PD-|PD_Old|uploaded_by_|Flickr_images_reviewed|Flickr_images_uploaded"

AND p.page_id IS NULL

GROUP BY c.cl_to

HAVING total<3

AND CHAR_LENGTH(c.cl_to) > 75

ORDER BY c.cl_to ASC;