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
Kvapilikova
.
Toggle Highlighting
SQL
SELECT p.page_title, c.cl_to, c.cl_from, c.cl_type, l.ll_lang, l.ll_title FROM page p INNER JOIN (SELECT * FROM categorylinks WHERE cl_to IN ( "Avionics", "Aeronautical_navigation_systems", "Aircraft_radars", "Helicopter_radars", "Northrop_Grumman_radars", "Aircraft_recorders", "Avionics_computers", "Guidance_computers", "IBM_avionics_computers", "Avionics_programming_languages", "Avionics_companies", "Aselsan", "Ferranti", "L3Harris_Technologies", "Radar_manufacturers", "Selex_ES", "Thales_Group", "Identification_friend_or_foe", "Radio_direction_finding") ) AS c ON p.page_id = c.cl_from LEFT OUTER JOIN (SELECT * FROM langlinks WHERE ll_lang in ("cs", "en") ) AS l ON l.ll_from = c.cl_from
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...