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
Nono314
.
Toggle Highlighting
SQL
use s51434__mixnmatch_p tools-db; SELECT CONCAT('Q', `P245`.`q`), `P245`.`ext_name`, `P245`.`ext_desc`, `P245`.`ext_id`, `P245`.`ext_url`, `P650`.`ext_desc`, `P650`.`ext_id`, `P650`.`ext_url` FROM `entry` AS `P245` JOIN `entry` AS `P650` ON `P245`.`ext_name`=`P650`.`ext_name` AND `P650`.`catalog`=13 AND (`P650`.`user` IS NULL OR `P650`.`user`=0) AND `P650`.`type`='person' WHERE `P245`.`catalog`=27 AND NOT `P245`.`q` IS NULL AND NOT `P245`.`q`=0 AND NOT `P245`.`user` IS NULL AND NOT `P245`.`user`=0 AND `P245`.`type`='person' LIMIT 100000;
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...