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
Saeidpourbabak
.
Toggle Highlighting
SQL
USE enwiki_p; SELECT catarlan.ll_title page, catlan.ll_title category#, catar.page_namespace namespace FROM langlinks AS catarlan JOIN page AS catar ON ll_from = page_id AND catar.page_is_redirect = 0 AND catarlan.ll_lang = 'fa' AND (catar.page_namespace = 14 OR catar.page_namespace = 0) JOIN categorylinks ON page_id = cl_from JOIN page AS cat ON cat.page_title = cl_to AND cat.page_is_redirect = 0 AND cat.page_namespace = 14 JOIN langlinks AS catlan ON catlan.ll_from = cat.page_id AND catlan.ll_lang = 'fa' WHERE (1 > 2 #---------------------------------------------------------- OR cl_to LIKE "People_of_African-American_descent" OR cl_to LIKE "East_Germany_at_multi-sport_events" OR cl_to LIKE "West_Germany_at_multi-sport_events" OR cl_to LIKE "British_people_of_American_descent" OR cl_to LIKE "Antigua_and_Barbuda_at_multi-sport_events" OR cl_to LIKE "Anguilla_at_multi-sport_events" OR cl_to LIKE "Chinese_literature" OR cl_to LIKE "Colombian_literature" OR cl_to LIKE "Armenia_at_multi-sport_events" OR cl_to LIKE "Eritrea_at_multi-sport_events" OR cl_to LIKE "Azerbaijani_people_of_American_descent" OR cl_to LIKE "Finnish_people_executed_by_the_Soviet_Union" OR cl_to LIKE "Brazilian_people_of_Israeli_descent" OR cl_to LIKE "Chilean_people_of_Asian_descent" OR cl_to LIKE "Drama_Desk_Award_for_musicals_templates" OR cl_to LIKE "Hungary_infobox_templates" OR cl_to LIKE "Philippines_rail_transport_color_templates" OR cl_to LIKE "Indonesia_at_multi-sport_events" OR cl_to LIKE "English_people_in_healthcare_occupations" OR cl_to LIKE "Ugandan_people_in_health_professions" OR cl_to LIKE "Barbadian_people_in_health_professions" OR cl_to LIKE "Bosnia_and_Herzegovina_people_in_health_occupations" OR cl_to LIKE "Thai_people_in_health_occupations" OR cl_to LIKE "Taiwanese_people_in_health_professions" OR cl_to LIKE "Trinidad_and_Tobago_people_in_health_professions" OR cl_to LIKE "Belgian_television_people" OR cl_to LIKE "Jamaican_people_in_health_occupations" OR cl_to LIKE "United_States_Virgin_Islands_people_in_health_professions" OR cl_to LIKE "Rwandan_people_in_health_professions" OR cl_to LIKE "Singaporean_people_in_health_occupations" OR cl_to LIKE "Sudanese_people_in_health_professions" OR cl_to LIKE "Seychellois_people_in_health_professions" OR cl_to LIKE "Serbian_people_in_health_professions" OR cl_to LIKE "Saudi_Arabian_people_in_health_professions" OR cl_to LIKE "French_people_in_health_professions" OR cl_to LIKE "Latvian_people_in_health_professions" OR cl_to LIKE "Hungarian_people_in_health_professions" OR cl_to LIKE "Moldovan_people_in_health_occupations" OR cl_to LIKE "Namibian_people_in_health_professions" OR cl_to LIKE "Nepalese_people_in_health_professions" OR cl_to LIKE "Nigerian_people_in_health_professions" OR cl_to LIKE "New_Zealand_people_in_health_professions" OR cl_to LIKE "People_from_Chhattisgarh" OR cl_to LIKE "Croatian_people_in_health_professions" OR cl_to LIKE "Colombian_people_in_health_occupations" OR cl_to LIKE "Kenyan_people_in_health_occupations" OR cl_to LIKE "Cape_Verdean_people_in_healthcare_professions" OR cl_to LIKE "Guinean_people_in_health_occupations" OR cl_to LIKE "Federated_States_of_Micronesia_at_multi-sport_events" OR cl_to LIKE "AfD_debates_(Media_and_music)" OR cl_to LIKE "Belize_at_multi-sport_events" OR cl_to LIKE "Listed_buildings_in_Scotland_by_grade" OR cl_to LIKE "Bhutan_at_multi-sport_events" OR cl_to LIKE "Burundi_at_multi-sport_events" OR cl_to LIKE "Burkina_Faso_at_multi-sport_events" OR cl_to LIKE "Ecoregions_of_Italy" OR cl_to LIKE "Jewish_Serbian_history" OR cl_to LIKE "East_Timor_at_multi-sport_events" OR cl_to LIKE "Gibraltar_at_multi-sport_events" OR cl_to LIKE "British_Virgin_Islands_at_multi-sport_events" OR cl_to LIKE "Cook_Islands_at_multi-sport_events" OR cl_to LIKE "Football_Asian_Games_champions_navigational_boxes" OR cl_to LIKE "Central_African_Republic_at_multi-sport_events" OR cl_to LIKE "Democratic_Republic_of_the_Congo_at_multi-sport_events" OR cl_to LIKE "Djibouti_at_multi-sport_events" OR cl_to LIKE "1964_in_case_law" OR cl_to LIKE "Dominica_at_multi-sport_events" OR cl_to LIKE "Landforms_of_Sitka_City_and_Borough,_Alaska" OR cl_to LIKE "American_Samoa_at_multi-sport_events" OR cl_to LIKE "Paleogene_crustaceans" OR cl_to LIKE "Politicians_from_Shanxi" OR cl_to LIKE "Lists_of_Nintendo_characters" OR cl_to LIKE "South_Korea_film-related_lists" OR cl_to LIKE "Jewish_explorers" OR cl_to LIKE "Soviet_Navy_ship_names" OR cl_to LIKE "1978_in_Washington_(state)" OR cl_to LIKE "Podcasts_by_language" OR cl_to LIKE "Ukrainian_medical_doctors" OR cl_to LIKE "Mexican_physicians" OR cl_to LIKE "Chad_at_multi-sport_events" OR cl_to LIKE "Cambodia_at_multi-sport_events" OR cl_to LIKE "Comoros_at_multi-sport_events" OR cl_to LIKE "The_Gambia_at_multi-sport_events" OR cl_to LIKE "German_nu_metal_musical_groups" OR cl_to LIKE "Guyana_at_multi-sport_events" OR cl_to LIKE "Equatorial_Guinea_at_multi-sport_events" OR cl_to LIKE "Guinea_at_multi-sport_events" #-------------------------------------------------------- ) ORDER BY cl_to;
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...