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
XXN
.
defect
Toggle Highlighting
SQL
USE rowiki_p; #select * from page /*join categorylinks*/ where page_id = "39407"; #select * from category where cat_title = "Pagini_de_categorisit"; /* show columns from category; show columns from categorylinks;*/ SELECT CONCAT("Categorie:",cat_title) FROM category JOIN page ON cat_title = page_title AND page_namespace = 14 WHERE NOT EXISTS ( SELECT * FROM templatelinks WHERE tl_from = page_id AND tl_from_namespace = 14 AND tl_namespace = 10 AND tl_title IN ("Redcat", "RedCat", "Redirect_categorie", "Redirect_category", "Category_redirect", "RedirCat", "Rc", "Seecat", "Red_cat", "Redirecționare_categorie") ) #tl_title not IN ("redcat", "RedCat", "redirect_categorie") AND cat_pages = 0;#*/
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...