SQL
x
# Taxon categories without main image
SELECT replace(page_title,"_"," ") AS taxon_name FROM page p1,categorylinks cl1
WHERE cl_to='Taxon_categories' AND cl_from=page_id AND page_namespace=14 AND page_is_redirect=0
AND EXISTS (SELECT * FROM page p2,categorylinks cl2 WHERE cl2.cl_to=p1.page_title AND cl2.cl_from=p2.page_id AND p2.page_namespace=6)
AND NOT EXISTS (SELECT * FROM imagelinks WHERE il_from=page_id)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.