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.
Derrick Sky Vegan Chocolates
Community > Dish Map

dishola is all over the world

Loading the map...

Cities Dished: 509

Top 10 Cities
  1. Austin, TX [1849 dishes]
  2. San Francisco, CA [335 dishes]
  3. New York, NY [145 dishes]
  4. Houston, TX [69 dishes]
  5. Seattle, WA [47 dishes]
  6. Portland, OR [41 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) 512 queries took 212 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SET NAMES 'UTF8'00
2SELECT 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_area50950936
3SELECT 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' 110
4SELECT 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' 110
5SELECT 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' 110
6SELECT 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' 110
7SELECT 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' 110
8SELECT 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' 110
9SELECT 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' 1110
10SELECT 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' 110
11SELECT 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' 110
12SELECT 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' 110
13SELECT 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' 110
14SELECT 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' 110
15SELECT 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' 110
16SELECT 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' 110
17SELECT 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' 110
18SELECT 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' 110
19SELECT 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' 110
20SELECT 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' 110
21SELECT 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' 110
22SELECT 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' 110
23SELECT 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' 110
24SELECT 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' 110
25SELECT 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' 110
26SELECT 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' 110
27SELECT 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' 110
28SELECT 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' 110
29SELECT 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' 110
30SELECT 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' 110
31SELECT 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' 110
32SELECT 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' 110
33SELECT 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' 110
34SELECT 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' 110
35SELECT 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' 110
36SELECT 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' 110
37SELECT 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' 110
38SELECT 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' 110
39SELECT 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' 110
40SELECT 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' 110
41SELECT 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' 110
42SELECT 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' 110
43SELECT 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' 110
44SELECT 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' 110
45SELECT 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' 119
46SELECT 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' 110
47SELECT 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' 110
48SELECT 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' 110
49SELECT 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' 110
50SELECT 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' 110
51SELECT 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' 110
52SELECT 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' 110
53SELECT 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' 110
54SELECT 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' 110
55SELECT 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' 110
56SELECT 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' 110
57SELECT 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' 110
58SELECT 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' 110
59SELECT 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' 110
60SELECT 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' 110
61SELECT 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' 110
62SELECT 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' 110
63SELECT 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' 110
64SELECT 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' 110
65SELECT 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' 1114
66SELECT 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' 110
67SELECT 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' 110
68SELECT 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' 110
69SELECT 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' 110
70SELECT 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' 110
71SELECT 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' 110
72SELECT 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' 110
73SELECT 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' 110
74SELECT 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' 110
75SELECT 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
76SELECT 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' 111
77SELECT 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' 110
78SELECT 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' 110
79SELECT 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' 110
80SELECT 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' 110
81SELECT 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' 110
82SELECT 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' 110
83SELECT 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' 119
84SELECT 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' 110
85SELECT 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' 110
86SELECT 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' 110
87SELECT 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' 110
88SELECT 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' 110
89SELECT 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' 110
90SELECT 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' 110
91SELECT 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' 110
92SELECT 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' 110
93SELECT 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' 110
94SELECT 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' 110
95SELECT 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' 110
96SELECT 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' 110
97SELECT 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' 110
98SELECT 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' 110
99SELECT 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' 110
100SELECT 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' 110
101SELECT 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.' 110
102SELECT 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' 110
103SELECT 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' 110
104SELECT 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' 110
105SELECT 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' 110
106SELECT 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' 110
107SELECT 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' 110
108SELECT 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' 110
109SELECT 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' 110
110SELECT 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' 110
111SELECT 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' 110
112SELECT 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' 110
113SELECT 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' 110
114SELECT 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' 110
115SELECT 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' 110
116SELECT 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' 110
117SELECT 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' 110
118SELECT 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' 110
119SELECT 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' 110
120SELECT 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' 110
121SELECT 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' 110
122SELECT 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' 110
123SELECT 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' 110
124SELECT 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' 110
125SELECT 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' 110
126SELECT 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' 110
127SELECT 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' 110
128SELECT 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' 110
129SELECT 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' 110
130SELECT 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
131SELECT 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' 110
132SELECT 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' 110
133SELECT 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' 110
134SELECT 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' 110
135SELECT 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' 110
136SELECT 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' 110
137SELECT 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' 110
138SELECT 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' 110
139SELECT 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' 110
140SELECT 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' 110
141SELECT 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' 110
142SELECT 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' 110
143SELECT 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' 110
144SELECT 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' 110
145SELECT 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' 110
146SELECT 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' 110
147SELECT 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' 110
148SELECT 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' 110
149SELECT 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' 110
150SELECT 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' 110
151SELECT 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' 110
152SELECT 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' 110
153SELECT 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' 110
154SELECT 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' 110
155SELECT 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' 110
156SELECT 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' 110
157SELECT 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' 110
158SELECT 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' 110
159SELECT 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' 110
160SELECT 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' 110
161SELECT 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' 110
162SELECT 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' 110
163SELECT 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' 110
164SELECT 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' 110
165SELECT 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' 110
166SELECT 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' 110
167SELECT 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' 110
168SELECT 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' 111
169SELECT 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' 110
170SELECT 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' 110
171SELECT 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' 110
172SELECT 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' 110
173SELECT 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' 110
174SELECT 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' 110
175SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Greer' AND `administrative_area` = 'SC' 110
176SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Gulfport' AND `administrative_area` = 'MS' 110
177SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Haleiwa' AND `administrative_area` = 'HI' 110
178SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Half Moon Bay' AND `administrative_area` = 'CA' 110
179SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Hamilton' AND `administrative_area` = 'TX' 110
180SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Hammond' AND `administrative_area` = 'LA' 110
181SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Hanoi' AND `administrative_area` = 'Hanoi' 110
182SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Hayward' AND `administrative_area` = 'CA' 110
183SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Healdsburg' AND `administrative_area` = 'CA' 110
184SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Hico' AND `administrative_area` = 'TX' 110
185SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Highland Park' AND `administrative_area` = 'IL' 110
186SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Ho Chi Minh' AND `administrative_area` = 'HCMC' 110
187SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Ho Chi Minh City' AND `administrative_area` = 'Vietnam' 1110
188SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Hoffman Estates' AND `administrative_area` = 'IL' 110
189SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Hollywood' AND `administrative_area` = 'CA' 110
190SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Hong Kong' AND `administrative_area` = 'Hong Kong' 110
191SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Hong Kong' AND `administrative_area` = 'Lantau Island' 110
192SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Honolulu' AND `administrative_area` = 'HI' 110
193SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Houston' AND `administrative_area` = 'TX' 110
194SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Hudson' AND `administrative_area` = 'FL' 110
195SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Hyderabad' AND `administrative_area` = 'Andhra Pradesh' 110
196SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Indianapolis' AND `administrative_area` = 'IN' 110
197SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Indio' AND `administrative_area` = 'CA' 110
198SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Isla Mujeres' AND `administrative_area` = 'Q.Roo' 111
199SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Islington' AND `administrative_area` = 'England' 113
200SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) WHERE `locality_name` = 'Issaquah' AND `administrative_area` = 'WA' 110