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
RoccoMo
.
Toggle Highlighting
SQL
SELECT #pa_page_id AS page_id, #page_title AS page_title, #pa_class AS quality_class, #pa_importance AS importance_class, #pap_project_title as project_title distinct(pap_project_title) as project_title FROM page_assessments INNER JOIN page_assessments_projects ON (pap_project_id = pa_project_id) INNER JOIN page ON (pa_page_id = page_id AND page_namespace = 0 AND page_title in ("PlayStation_2_Expansion_Bay","Maragoli","Wakfu","XrossMediaBar","Ankama","Tiriki","Kabras","Khayo","GunCon","Idakho","PlayStation_Portable_system_software","Kavirondo","Character_class","Kirill_of_Turov","RSX_Reality_Synthesizer","Black_Virgin_of_Oropa","Theme_(computing)","First_generation_of_video_game_consoles","Education_in_Ghana","History_of_Eastern_role-playing_video_games","William_of_Perth","Laban_Ayiro","Nicolas_Blancho","Shadowflare","Central_Station_(online_service)","Zacchaeus_Chesoni","Optiarc","Anthony,_John,_and_Eustathius","Adrian_Alejandro_Wittwer","System_573","Turn-based_MMORPG","Kudan,_Rajasthan","Bukusu","Science,_technology,_engineering,_and_mathematics","Freedo_(producer)","Michael_Kijana_Wamalwa","Roman_Catholic_Archdiocese_of_Pretoria","Timeline_of_PlayStation_3_SKUs","Cleric_(Dungeons_&_Dragons)","PlayStation_TV","Clifton_Miheso","StreamMyGame","Xenia_Tchoumitcheva","PlayStation_3_accessories","Player_versus_player","Immaculate_Heart_of_Mary","Undergraduate_degree","Xbox_network","Jill_Whelan","Neuchâtel_Xamax_FCS","Filemona_F._Indire","Maguss","Anthony_Prospect","AdS_black_brane","Jumba_la_Mtwana","Matungu","PlayStation_Broadband_Navigator","Nyole_tribe","Isukha","Kisa_tribe","Western_Province_(Kenya)","Education_in_Chile","Jampack","Twinking","FD_Trinitron/WEGA","Mu_Online","Kopaganj","Roman_Catholic_Archdiocese_of_Port_Moresby","Roman_Catholic_Archdiocese_of_Los_Altos_Quetzaltenango-Totonicapán","Monato_Esprit","Roman_Catholic_Archdiocese_of_Trento","Swiss_Space_Systems","Embu_people","Kenya_Television_Network","Digital_distribution_of_video_games","5th_Guards_Tank_Division","Czech_Airlines","Palouse_to_Cascades_State_Park_Trail","The_Tomorrow_Children","Education_in_India","Heroes'_Day","Bir_Ben_Ayed","Aleksandr_Nikolaevich_Vasiliev","Caffè_Concerto","Dolder_Grand","Vihiga","TX_Group","Jacqueline_Fuchs","Great_Lakes_Bantu_languages","Manfra","Chiraiyakot","Knight_Online","Andrew_Avellino","Symbols_of_Europe","Western_Province_(Kenya)","Kennedy_family","Cadash","Ohangla","Lufia:_Curse_of_the_Sinistrals","Michael_Nutter","Roman_Catholic_Archdiocese_of_Trento","Tibia_(video_game)","Digital_distribution_of_video_games","SCART","Roman_Catholic_Archdiocese_of_Southwark","Dentin","Anxiolytic","Bail_in_the_United_States","My5","Education_in_India","Otranto","Airiel_Down","Albanian_Horticultural_and_Potato_Institute","Burlap_&_Barrel","Jacqueline_Fuchs","Roman_Catholic_Archdiocese_of_Rabaul","Heartbeat_(company)","Federica_Sallusto","Waltrude","Dharmavaram,_Sri_Sathya_Sai_district"));
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...