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
Elph
.
Toggle Highlighting
SQL
USE enwiki_p; SELECT distinct page_title FROM page INNER JOIN categorylinks WHERE cl_from = page_id AND cl_to = 'Food_retailing' or cl_to = 'Imitation_foods' or cl_to = 'Food_law' or cl_to = 'Consumer_symbols' or cl_to = 'Certification_marks' or cl_to = 'Product_certification' or cl_to = 'Consumer_protection' or cl_to = 'Food_safety' or cl_to = 'Food_preservation' or cl_to = 'Food_storage_containers' or cl_to = 'Kitchenware' or cl_to = 'Child_safety' or cl_to = 'Food_packaging' or cl_to = 'Droughts' or cl_to = 'Diets' or cl_to = 'Eating_behaviors_of_humans' or cl_to = 'Nutrition' or cl_to = 'Dietetics' or cl_to = 'Food_and_drink_festival_stubs' or cl_to = 'Food_and_drink_stubs' or cl_to = 'Infant_feeding' or cl_to = 'Food_writers' or cl_to = 'Sustainable_food_system' or cl_to = 'Food_politics' or cl_to = 'Malnutrition' or cl_to = 'Sustainable_agriculture' or cl_to = 'Food_waste' AND page_namespace = 0 AND page_is_redirect = 0 AND page_title NOT IN ( SELECT ll_from FROM langlinks WHERE ll_lang = "ar" ) ;
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...