Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Neechalkaran
.
All Distinct Roman Title without Tamil interlink and with English Category.
Toggle Highlighting
SQL
#select * from categorylinks where cl_type = "page" #Select page_title, GROUP_CONCAT(DISTINCT cl_to ORDER BY cl_to SEPARATOR', ') As "Categories" #from page JOIN categorylinks on page_id = cl_from where page_namespace = 0 GROUP BY page_title Select page_title, GROUP_CONCAT(DISTINCT cl_to ORDER BY cl_to SEPARATOR', ') As "Categories" from page JOIN categorylinks on page_id = cl_from where categorylinks.cl_to Like "%English%" and page_title REGEXP "^[A-Za-z ]+$" and page_namespace=0 and page_title not in (SELECT ll_title FROM langlinks where ll_lang="ta") GROUP BY page_title #Total 8418902 #Total 6987406 #Total 5863496 #LIMIT 100;
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
.
Checking query status...