Dishola: Reviews by the Dish

dishola /dish•ō•lâ/
v. To share the love of food - dish by dish. n. The ultimate source to find real meals at real places that rule.
Cocoa Puro
Community > Dish Map

dishola is all over the world

Loading the map...

Cities Dished: 509

Top 10 Cities
  1. Austin, TX [1898 dishes]
  2. San Francisco, CA [334 dishes]
  3. New York, NY [145 dishes]
  4. Houston, TX [69 dishes]
  5. Seattle, WA [47 dishes]
  6. Portland, OR [40 dishes]
  7. Dallas, TX [38 dishes]
  8. San Jose, CA [36 dishes]
  9. San Diego, CA [30 dishes]
  10. Los Angeles, CA [29 dishes]

Copyright dishola® 2006-9. All rights reserved. | Terms of Use | Privacy Policy | Contact
(dishola_development) 542 queries took 681 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `restaurant_locations`21211
2DESCRIBE `restaurants`771
3SET NAMES 'UTF8'00
4DESCRIBE `dishes`20201
5DESCRIBE `users`23231
6DESCRIBE `profiles`68683
7DESCRIBE `facebook_connect`771
8DESCRIBE `reviews`11111
9DESCRIBE `reviewsvotes`882
10DESCRIBE `images`11111
11DESCRIBE `tokens`772
12DESCRIBE `user_friends`551
13DESCRIBE `bookmarks`551
14DESCRIBE `safaris`882
15DESCRIBE `dishes_safaris`331
16DESCRIBE `safaris_users`331
17DESCRIBE `sets`16162
18DESCRIBE `sets_dishes`661
19DESCRIBE `sets_users`771
20DESCRIBE `featured_dishes`10101
21DESCRIBE `dish_images`771
22DESCRIBE `dish_image_votes`881
23DESCRIBE `tags`221
24DESCRIBE `dishes_tags`331
25DESCRIBE `dish_wanteds`881
26DESCRIBE `dish_wanteds_tags`331
27DESCRIBE `dish_wanteds_dishes`331
28SELECT locality_name, administrative_area, CONCAT(locality_name, '_', administrative_area) AS uniquestring, country_name_code, latitude, longitude FROM restaurant_locations AS Location WHERE latitude <> '' AND locality_name <> '' GROUP BY uniquestring ORDER BY locality_name, administrative_area50950938
29SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Abilene' AND `administrative_area` = 'TX' 111
30SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Adrian' AND `administrative_area` = 'TX' 111
31SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Akron' AND `administrative_area` = 'OH' 111
32SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Alameda' AND `administrative_area` = 'CA' 111
33SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Albany' AND `administrative_area` = 'NY' 111
34SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Albuquerque' AND `administrative_area` = 'NM' 111
35SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Alexandria' AND `administrative_area` = 'LA' 111
36SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Alexandria' AND `administrative_area` = 'VA' 111
37SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Alviso' AND `administrative_area` = 'CA' 111
38SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Amarillo' AND `administrative_area` = 'TX' 111
39SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Ames' AND `administrative_area` = 'IA' 111
40SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Amiristar' AND `administrative_area` = 'Rajasthan' 111
41SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Amsterdam' AND `administrative_area` = 'Noord-Holland' 111
42SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Anaheim' AND `administrative_area` = 'CA' 111
43SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Anchorage' AND `administrative_area` = 'AK' 111
44SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Ankara' AND `administrative_area` = '68' 111
45SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Annapolis' AND `administrative_area` = 'MD' 112
46SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Apple Valley' AND `administrative_area` = 'CA' 111
47SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Arapahoe' AND `administrative_area` = 'NE' 111
48SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Araras' AND `administrative_area` = 'SP' 111
49SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Arcadia' AND `administrative_area` = 'CA' 111
50SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Arlington' AND `administrative_area` = 'TX' 111
51SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Arlington' AND `administrative_area` = 'VA' 111
52SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Arusha' AND `administrative_area` = 'Tanzania' 111
53SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Ash Fork' AND `administrative_area` = 'AZ' 111
54SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Asheville' AND `administrative_area` = 'NC' 111
55SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Asheville' AND `administrative_area` = 'North Carolina' 111
56SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Atascadero' AND `administrative_area` = 'CA' 112
57SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Atlanta' AND `administrative_area` = 'GA' 111
58SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Auckland' AND `administrative_area` = 'Auckland' 111
59SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Aurora' AND `administrative_area` = 'CO' 111
60SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Austin' AND `administrative_area` = 'TX' 118
61SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Bangkok' AND `administrative_area` = 'Thailand' 112
62SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Bastrop' AND `administrative_area` = 'TX' 111
63SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Baton Rouge' AND `administrative_area` = 'LA' 111
64SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Beaumont' AND `administrative_area` = 'TX' 111
65SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Beaverton' AND `administrative_area` = 'OR' 111
66SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Bedminster' AND `administrative_area` = 'NJ' 111
67SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Beijing' AND `administrative_area` = '22' 111
68SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Beijing' AND `administrative_area` = 'CN' 111
69SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Beirut' AND `administrative_area` = 'Lebanon' 112
70SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Bellingham' AND `administrative_area` = 'WA' 111
71SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Belo Horizonte' AND `administrative_area` = 'Minas Gerais' 112
72SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Belvedere Tiburon' AND `administrative_area` = 'CA' 112
73SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Ben Lomond' AND `administrative_area` = 'CA' 111
74SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Benton' AND `administrative_area` = 'AR' 111
75SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Berkeley' AND `administrative_area` = 'CA' 111
76SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Berlin' AND `administrative_area` = 'Berlin' 111
77SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Bernalillo' AND `administrative_area` = 'NM' 111
78SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Beverly Hills' AND `administrative_area` = 'CA' 111
79SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Big Sur' AND `administrative_area` = 'CA' 111
80SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Birmingham' AND `administrative_area` = 'MI' 111
81SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Bloomingdale' AND `administrative_area` = 'IL' 111
82SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Boise' AND `administrative_area` = 'ID' 111
83SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Boon Lay and Pioneer' AND `administrative_area` = 'Singapore' 111
84SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Bora Bora' AND `administrative_area` = 'French Polynesia' 112
85SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Boston' AND `administrative_area` = 'MA' 113
86SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Bothell' AND `administrative_area` = 'WA' 113
87SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Bouilland' AND `administrative_area` = 'Burgundy' 111
88SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Bradenton' AND `administrative_area` = 'FL' 112
89SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Brea' AND `administrative_area` = 'CA' 111
90SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Breaux Bridge' AND `administrative_area` = 'LA' 112
91SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Breckenridge' AND `administrative_area` = 'CO' 112
92SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Bronx' AND `administrative_area` = 'NY' 111
93SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Brooklyn' AND `administrative_area` = 'NY' 111
94SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Brookshire' AND `administrative_area` = 'TX' 111
95SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Brownwood' AND `administrative_area` = 'TX' 111
96SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Brugge' AND `administrative_area` = 'Brugge' 111
97SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Brugge' AND `administrative_area` = 'Vlaams Gewest' 111
98SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Brunswick East' AND `administrative_area` = 'VIC' 111
99SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Budapest' AND `administrative_area` = 'Budapest' 111
100SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Buellton' AND `administrative_area` = 'CA' 111
101SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Buenos Aires' AND `administrative_area` = '07' 112
102SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Buffalo Gap' AND `administrative_area` = 'TX' 112
103SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Burbank' AND `administrative_area` = 'CA' 112
104SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Burien' AND `administrative_area` = 'WA' 111
105SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Burnet' AND `administrative_area` = 'TX' 111
106SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Cabo San Lucas' AND `administrative_area` = 'Baja California Sur' 112
107SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Calgary' AND `administrative_area` = 'AB' 111
108SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Cambridge' AND `administrative_area` = 'England' 111
109SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Cambridge' AND `administrative_area` = 'MA' 111
110SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Camdenton' AND `administrative_area` = 'MO' 111
111SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Campbell' AND `administrative_area` = 'CA' 111
112SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Canon City' AND `administrative_area` = 'CO' 112
113SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Cape Canaveral' AND `administrative_area` = 'FL' 111
114SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Cardiff' AND `administrative_area` = 'Wales' 111
115SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Carlsbad' AND `administrative_area` = 'CA' 111
116SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Carmel' AND `administrative_area` = 'CA' 112
117SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Ceceda' AND `administrative_area` = 'Asturias' 111
118SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Cedar Hill' AND `administrative_area` = 'TX' 112
119SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Cedar Park' AND `administrative_area` = 'TX' 111
120SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Central' AND `administrative_area` = 'Hong Kong' 112
121SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Chagny' AND `administrative_area` = 'Burgundy' 111
122SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Chamblee' AND `administrative_area` = 'GA' 111
123SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Charleston' AND `administrative_area` = 'SC' 111
124SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Charlotte' AND `administrative_area` = 'NC' 112
125SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Chatswood' AND `administrative_area` = 'NSW' 111
126SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Chattanooga' AND `administrative_area` = 'TN' 111
127SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Chicago' AND `administrative_area` = 'I.L.' 111
128SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Chicago' AND `administrative_area` = 'IL' 111
129SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Cincinnati' AND `administrative_area` = 'OH' 111
130SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Cittá del Messico' AND `administrative_area` = 'DF' 111
131SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Ciudad de México' AND `administrative_area` = 'Distrito Federal' 112
132SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Claremont' AND `administrative_area` = 'CA' 111
133SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Clifton Springs' AND `administrative_area` = 'NY' 111
134SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Clinton' AND `administrative_area` = 'NC' 111
135SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Colfax' AND `administrative_area` = 'CA' 111
136SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'College Station' AND `administrative_area` = 'TX' 111
137SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Cologne' AND `administrative_area` = 'Nordrhein-Westfalen' 111
138SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Colorado Springs' AND `administrative_area` = 'CO' 111
139SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Columbia' AND `administrative_area` = 'MO' 111
140SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Columbia' AND `administrative_area` = 'SC' 111
141SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Coon Rapids' AND `administrative_area` = 'IA' 111
142SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Cordova' AND `administrative_area` = 'TN' 111
143SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Cornelius' AND `administrative_area` = 'NC' 111
144SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Coronado' AND `administrative_area` = 'CA' 111
145SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Corpus Christi' AND `administrative_area` = 'TX' 111
146SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Cotati' AND `administrative_area` = 'CA' 112
147SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Cottingham' AND `administrative_area` = 'J3' 111
148SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Covington' AND `administrative_area` = 'IN' 111
149SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Covington' AND `administrative_area` = 'LA' 111
150SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Creve Coeur' AND `administrative_area` = 'MO' 111
151SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Culpeper' AND `administrative_area` = 'VA' 111
152SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Culver City' AND `administrative_area` = 'CA' 111
153SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Cupertino' AND `administrative_area` = 'CA' 111
154SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Dallas' AND `administrative_area` = 'TX' 111
155SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Daly City' AND `administrative_area` = 'CA' 111
156SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Decatur' AND `administrative_area` = 'GA' 111
157SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'del Mar' AND `administrative_area` = 'CA' 111
158SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'del Valle' AND `administrative_area` = 'TX' 111
159SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Denton' AND `administrative_area` = 'TX' 111
160SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Denver' AND `administrative_area` = 'CO' 111
161SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Depew' AND `administrative_area` = 'NY' 111
162SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Des Moines' AND `administrative_area` = 'IA' 113
163SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Driftwood' AND `administrative_area` = 'TX' 111
164SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Dripping Springs' AND `administrative_area` = 'TX' 111
165SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Dublin' AND `administrative_area` = 'CA' 111
166SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Durham' AND `administrative_area` = 'NC' 111
167SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Edgartown' AND `administrative_area` = 'MA' 111
168SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Edinburg' AND `administrative_area` = 'TX' 111
169SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Egremont' AND `administrative_area` = 'MA' 111
170SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'El Paso' AND `administrative_area` = 'TX' 111
171SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'El Salvador' AND `administrative_area` = 'Argentina' 111
172SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Encinitas' AND `administrative_area` = 'CA' 111
173SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Eugene' AND `administrative_area` = 'OR' 111
174SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Euless' AND `administrative_area` = 'TX' 111
175SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Evanston' AND `administrative_area` = 'IL' 111
176SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Fairport' AND `administrative_area` = 'NY' 111
177SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Falls Church' AND `administrative_area` = 'VA' 111
178SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Farmington' AND `administrative_area` = 'MO' 111
179SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Federal Way' AND `administrative_area` = 'WA' 111
180SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Fitzroy' AND `administrative_area` = 'VIC' 111
181SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Flushing' AND `administrative_area` = 'NY' 111
182SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Fort Wayne' AND `administrative_area` = 'IN' 111
183SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Fort Worth' AND `administrative_area` = 'TX' 111
184SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Frederick' AND `administrative_area` = 'MD' 111
185SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Fredericksburg' AND `administrative_area` = 'TX' 111
186SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Fresno' AND `administrative_area` = 'CA' 111
187SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Fulshear' AND `administrative_area` = 'TX' 111
188SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Gardiner' AND `administrative_area` = 'NY' 111
189SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Girdwood' AND `administrative_area` = 'Alaska' 111
190SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Glasgow' AND `administrative_area` = 'Scotland' 111
191SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Glen Ellen' AND `administrative_area` = 'CA' 111
192SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Glendale' AND `administrative_area` = 'CA' 111
193SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Glendora' AND `administrative_area` = 'CA' 111
194SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Golden' AND `administrative_area` = 'CO' 112
195SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Görlitz' AND `administrative_area` = 'Silesia' 111
196SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Gral Viamonte' AND `administrative_area` = 'Argentina' 111
197SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Grand Canyon' AND `administrative_area` = 'AZ' 111
198SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Grapevine' AND `administrative_area` = 'TX' 111
199SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Greensboro' AND `administrative_area` = 'NC' 111
200SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Greenville' AND `administrative_area` = 'SC' 111