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
.
Toggle Highlighting
SQL
USE commonswiki_p; SELECT CONCAT("*[[:File:",page_title,"]]") as File, el_to as Link FROM page, externallinks WHERE page_namespace = 6 AND page_is_redirect = 0 AND page_id = el_from AND el_to like '%spacetelescope.or%' AND page_id not in (SELECT cl_from from categorylinks WHERE cl_to IN ("Content_created_by_the_European_Space_Agency", "Hubble_images", "ESA_images", "Hubble_Deep_Fields", "Hubble_Deep_Field", "Hubble_Deep_Field_South", "Hubble_Ultra_Deep_Field", "Hubble_Solar_System_images", "Hubble_images_of_nebulae", "Hubble_images_of_spiral_galaxies", "Hubble_images_of_ring_galaxies", "Hubble_images_of_star_clusters", "Hubble_images_of_quasars", "Hubble_images_of_elliptical_galaxies", "Hubble_images_of_individual_stars", "Hubble_images_of_gravitational_lensing", "Hubble_images_of_galaxies", "Hubble_images_of_supernovas", "Hubble_images_of_interacting_galaxies", "Videos_from_the_Hubble_Space_Telescope", "High_Resolution_Stereo_Camera", "Hubble_images_of_comets", "P/2013_P5", "Hubble_eXtreme_Deep_Field", "Hubble_images_of_irregular_galaxies", "Photos_taken_by_Rosetta", "Photos_of_Comet_Churyumov-Gerasimenko_taken_by_Rosetta", "Photos_taken_by_Mars_Express", "Photos_of_Earth_by_Rosetta", "Photos_of_Mars_by_Rosetta", "Photos_of_Mars_by_Hubble", "Photos_of_Pluto_system_by_Hubble", "Hubble_12", "Photos_of_Jupiter_system_by_Hubble", "Photos_of_Ceres_by_Hubble", "Photos_of_Saturn_system_by_Hubble", "Photos_of_Uranus_system_by_Hubble", "Photos_of_Neptune_system_by_Hubble", "Photos_of_Vesta_by_Hubble", "Photos_of_the_Moon_by_Hubble", "Photos_of_Eris_by_Hubble", "Visual_Monitoring_Camera")) GROUP BY page_title ORDER BY page_title
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...