USE commonswiki_p;

SELECT count(distinct page_title)

FROM page JOIN externallinks ON page_id = el_from

WHERE page_namespace = 6 

AND el_to LIKE '%flickr.com%'

AND page_id not in (select cl_from from categorylinks where cl_type = "file" 

                    AND cl_to in ("Flickr_images_reviewed_by_FlickreviewR", "Flickr_images_verified_by_UploadWizard",

                        "Flickr_images_reviewed_by_trusted_users", "Possibly_unfree_Flickr_images", "Flickr_review_needed",

                        "Flickr_images_uploaded_by_Flickr_upload_bot", "Flickr_images_reviewed_by_File_Upload_Bot_(Magnus_Manske)", 

                        "Files_from_Flickr's_'The_Commons'", "FlickrLickr_images")

                    )