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 ( "Multimedia", "Multimedia_artists", "Women_multimedia_artists", "American_multimedia_artists", "Belgian_multimedia_artists", "British_multimedia_artists", "Canadian_multimedia_artists", "Chinese_multimedia_artists", "Dutch_multimedia_artists", "French_multimedia_artists", "German_multimedia_artists", "Indian_multimedia_artists", "Irish_multimedia_artists", "Italian_multimedia_artists", "Japanese_multimedia_artists", "Serbian_multimedia_artists", "Spanish_multimedia_artists", "Digital_media", "Digital_art", "Digital_audio", "Digital_broadcasting", "Digital_comics", "Computer_storage_media", "Digital_divide", "Digital_Revolution", "Digital_media_education", "Digital_media_educators", "Electronic_documents", "Electronic_games", "Electronic_literature", "Information_Age", "Interactive_media", "LaserDisc", "Digital_libraries", "Digital_media_use_and_mental_health", "New_media", "News_websites", "Digital_media_organizations", "Digital_media_works_about_philosophy", "Digital_photography", "Podcasting", "Digital_preservation", "Digital_radio", "Digital_rights", "Digital_rights_management", "Software", "Digital_television", "Transmediation", "Digital_typography", "Video", "Video_games", "Video_games_with_downloadable_content", "Virtual_reality_works", "Websites", "Websites_about_digital_media", "World_Wide_Web", "Hypermedia", "HyperCard_products", "Internet_radio", "Internet_radio_by_country", "Internet_audio_players", "Peercasting", "Internet_radio_software", "Internet_radio_stations", "Internet_broadcasting_stubs", "Internet_television", "Internet_television_channels", "Internet_television_by_country", "American_web_producers", "Australian_streaming_companies", "Original_programming", "Peercasting", "Screenshots_of_vodcasts", "Smart_TV", "Internet_television_software", "Internet_streaming_services", "TVF_Play_Shows", "Video_on_demand", "Web_animation", "Web_series", "Internet_broadcasting_stubs", "Multimedia_logos", "Multimedia_ministries", "Ministry_of_Communications_and_Multimedia_(Malaysia)", "Optical_disc_authoring", "Optical_disc_authoring_software", "Presentation", "Presentation_software", "Smart_TV", "Multimedia_software", "Multimedia_software_by_platform", "Audio_software", "Authoring_systems", "Multimedia_software_comparisons", "Demoscene_software", "Digital_rights_management_circumvention_software", "Adobe_Flash", "Multimedia_frameworks", "Free_multimedia_software", "Free_multimedia_codecs,_containers,_and_splitters", "HyperCard_products", "Multimedia_production_software_suites", "Optical_disc_authoring_software", "PDF_software", "Media_players", "Podcasting_software", "Media_readers", "Streaming_software", "Tag_editors", "Video_editing_software", "Video_software", "Visual_effects_software", "Multimedia_software_stubs", "Streaming", "Internet_radio", "Internet_streaming_services", "Internet_television", "Music_streaming_services", "Professional_wrestling_streaming_services", "Streaming_software", "Streaming-only_albums", "Streaming_media_systems", "Twitch_(service)_streamers", "Video_on_demand", "Multimedia_works", "Multimedia_collaborative_fiction", "Multimedia_operas", "Transmediation") ) AS c ON p.page_id = c.cl_from LEFT OUTER JOIN (SELECT * FROM langlinks WHERE ll_lang = "fr" ) 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...