Untitled query #79913

This query is marked as a draft This query has been published by Superyetkin.

SQL

SELECT
	B.title,
    COUNT(*) AS c
FROM
(
SELECT
	cl.cl_to AS title
from
	page p
    INNER JOIN categorylinks cl
    ON cl.cl_from = p.page_id
    INNER JOIN page p2
    ON p2.page_namespace = 14
    AND p2.page_title = cl.cl_to
WHERE
	p.page_namespace = 0
    AND p2.page_id BETWEEN 5000000 AND 10000000
	AND cl.cl_to LIKE 'Taxa_named_by%'

) B

GROUP BY
	B.title

HAVING c >= 5

ORDER BY c DESC

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...