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
Dishes > National City, CA
Adjust search
Results 1-5 of 40 dishes:
  • Trekking distance from National City, CA (aka within 30 miles)
Sashimi Salad with Matsuhisa Dressing at Nobu San Diego, photo by laura
email to a friend
add to a dish set
9
Avg. Review
Sashimi Salad with Matsuhisa Dressing at Nobu San Diego

207 5th Ave, San Diego, CA (4.6 miles away)
(619) 814-4124

laura on 11/16/09

"Clean" is the word that comes to mind when describing Nobu's sashimi salad. At its base, you'll find thick slices of ahi tuna, drizzled in the much-loved Matsuhisa dressing (think: soy sauce, finely more…   [1 review]

Tags: sashimi  salad  ahi  tuna  onion  soy  sauce  radish  carrot  cucumber  greens  Japanese  edit
Edamame and Spicy Peppers at Nobu San Diego, photo by laura
email to a friend
add to a dish set
9
Avg. Review
Edamame and Spicy Peppers at Nobu San Diego

207 5th Ave, San Diego, CA (4.6 miles away)
(619) 814-4124

laura on 11/16/09

It's hard to go wrong with something as simple as warm edamame and Shishito peppers dappled with sea salt. My tablemates and I particularly enjoyed the peppers - some of which were sweet, while others more…   [1 review]

Tags: edamame  shishito pepper  appetizer  Japanese  edit
Raspberry Scone at Azucar, photo by laura
email to a friend
add to a dish set
10
Avg. Review
Raspberry Scone at Azucar

4820 Newport Ave., San Diego, CA (10.3 miles away)
(619) 523-2020

laura on 11/15/09

I fell in love with Azucar even before I walked into the place. And had it not been for two southern California surfers who recommended the "awesome Cuban coffee down the road, dude," we would've never more…   [1 review]

Tags: Cuban  cafe con leche  scone  raspberry  breakfast  passion  fruit  buttermilk  edit
Cheese Burger at Maryjane's Coffee Shop, photo by laura
email to a friend
add to a dish set
9
Avg. Review
Cheese Burger at Maryjane's Coffee Shop

207 5th Ave, San Diego, CA (4.6 miles away)
(619) 764-6950

laura on 11/15/09

This cheddar cheese burger from MaryJane's, the bustling coffee shop in downtown San Diego, knocked my socks off. The 1/2 pound of Angus beef was perfectly cooked medium rare, and draped in a cheddar more…   [1 review]

Tags: cheeburger  cheddar  butter  bun  lettuce  tomato  red  onion  cole  slaw  edit
Grilled Octopus Salad at Starlite, photo by sam
email to a friend
add to a dish set
10
Avg. Review
Grilled Octopus Salad at Starlite

3175 India St, San Diego, CA (6.5 miles away)
(619) 358-9766

sam on 06/06/09

Garlic, smoked paprika, tender..mmmmmm good, like good sex. more…   [1 review]

Tags: octopus  edit

Copyright dishola® 2006-9. All rights reserved. | Terms of Use | Privacy Policy | Contact
(dishola_development) 32 queries took 26 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SET NAMES 'UTF8'00
2SELECT * FROM locations_lookup WHERE locality_name='National City' AND (administrative_area='CA' OR country_name_code='CA') LIMIT 0,1118
3SELECT `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name`, (((acos(sin((32.6707*pi()/180)) * sin((Location.latitude*pi()/180)) + cos((32.6707*pi()/180)) * cos((Location.latitude*pi()/180)) * cos(((-117.0946 - Location.longitude) * pi()/180)))) * 180/pi()) * 60 * 1.1515) as distance_from_user FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) LEFT JOIN `users` AS `User` ON (`Dish`.`user_id` = `User`.`id`) LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`longitude` BETWEEN -117.528301498 AND -116.660898502 AND `Location`.`latitude` BETWEEN 32.2369985023 AND 33.1044014977 AND `Dish`.`disabled`=0 ORDER BY `last_review_date` DESC LIMIT 5553
4SELECT `Tag`.`id`, `Tag`.`tag`, `DishesTag`.`id`, `DishesTag`.`dish_id`, `DishesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `dishes_tags` AS `DishesTag` ON (`DishesTag`.`dish_id` IN (3795, 3794, 3781, 3780, 3268) AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 35350
5SELECT `DishSet`.`id`, `DishSet`.`user_id`, `DishSet`.`name`, `DishSet`.`description`, `DishSet`.`private`, `DishSet`.`location`, `DishSet`.`country_name_code`, `DishSet`.`administrative_area`, `DishSet`.`locality_name`, `DishSet`.`postal_code`, `DishSet`.`latitude`, `DishSet`.`longitude`, `DishSet`.`count_users`, `DishSet`.`count_dishes`, `DishSet`.`created`, `DishSet`.`modified`, `SetsDish`.`id`, `SetsDish`.`set_id`, `SetsDish`.`dish_id`, `SetsDish`.`order`, `SetsDish`.`created`, `SetsDish`.`modified` FROM `sets` AS `DishSet` JOIN `sets_dishes` AS `SetsDish` ON (`SetsDish`.`dish_id` IN (3795, 3794, 3781, 3780, 3268) AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 000
6SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2397' LIMIT 1110
7SELECT `Dish`.`id`, `Dish`.`user_id`, `Dish`.`name`, `Dish`.`location_id`, `Dish`.`disabled`, `Dish`.`created`, `Dish`.`modified`, `Dish`.`vote_avg`, `Dish`.`vote_count`, `Dish`.`members_vote_avg`, `Dish`.`members_vote_count`, `Dish`.`industry_vote_avg`, `Dish`.`industry_vote_count`, `Dish`.`critics_vote_avg`, `Dish`.`critics_vote_count`, `Dish`.`last_review_date`, `Dish`.`review_count`, `Dish`.`is_divine`, `Dish`.`dish_image_filepath`, `Dish`.`dish_image_created` FROM `dishes` AS `Dish` WHERE `Dish`.`location_id` = (2397) 220
8SELECT dishes.vote_avg, reviews.*, users.*, profiles.image, profiles.image_small FROM dishes LEFT JOIN reviews ON dishes.id=reviews.dish_id LEFT JOIN users ON reviews.user_id=users.id LEFT JOIN profiles ON users.id=profiles.user_id WHERE dishes.id='3795' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1115
9SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `dishes` AS `Dish` ON (`Review`.`dish_id` = `Dish`.`id`) WHERE dish_id='3795' 110
10SELECT `Image`.*, `OriginalImage`.*, `DishImage`.`id` FROM `dish_images` AS `DishImage` LEFT JOIN `dishes` AS `Dish` ON (`DishImage`.`dish_id` = `Dish`.`id`) LEFT JOIN `images` AS `Image` ON (`DishImage`.`image_id` = `Image`.`id`) LEFT JOIN `images` AS `OriginalImage` ON (`DishImage`.`original_image_id` = `OriginalImage`.`id`) WHERE dish_id=3795 ORDER BY `Image`.`created` DESC LIMIT 1110
11SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2397' LIMIT 1110
12SELECT `Dish`.`id`, `Dish`.`user_id`, `Dish`.`name`, `Dish`.`location_id`, `Dish`.`disabled`, `Dish`.`created`, `Dish`.`modified`, `Dish`.`vote_avg`, `Dish`.`vote_count`, `Dish`.`members_vote_avg`, `Dish`.`members_vote_count`, `Dish`.`industry_vote_avg`, `Dish`.`industry_vote_count`, `Dish`.`critics_vote_avg`, `Dish`.`critics_vote_count`, `Dish`.`last_review_date`, `Dish`.`review_count`, `Dish`.`is_divine`, `Dish`.`dish_image_filepath`, `Dish`.`dish_image_created` FROM `dishes` AS `Dish` WHERE `Dish`.`location_id` = (2397) 220
13SELECT dishes.vote_avg, reviews.*, users.*, profiles.image, profiles.image_small FROM dishes LEFT JOIN reviews ON dishes.id=reviews.dish_id LEFT JOIN users ON reviews.user_id=users.id LEFT JOIN profiles ON users.id=profiles.user_id WHERE dishes.id='3794' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
14SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `dishes` AS `Dish` ON (`Review`.`dish_id` = `Dish`.`id`) WHERE dish_id='3794' 110
15SELECT `Image`.*, `OriginalImage`.*, `DishImage`.`id` FROM `dish_images` AS `DishImage` LEFT JOIN `dishes` AS `Dish` ON (`DishImage`.`dish_id` = `Dish`.`id`) LEFT JOIN `images` AS `Image` ON (`DishImage`.`image_id` = `Image`.`id`) LEFT JOIN `images` AS `OriginalImage` ON (`DishImage`.`original_image_id` = `OriginalImage`.`id`) WHERE dish_id=3794 ORDER BY `Image`.`created` DESC LIMIT 1110
16SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2390' LIMIT 1110
17SELECT `Dish`.`id`, `Dish`.`user_id`, `Dish`.`name`, `Dish`.`location_id`, `Dish`.`disabled`, `Dish`.`created`, `Dish`.`modified`, `Dish`.`vote_avg`, `Dish`.`vote_count`, `Dish`.`members_vote_avg`, `Dish`.`members_vote_count`, `Dish`.`industry_vote_avg`, `Dish`.`industry_vote_count`, `Dish`.`critics_vote_avg`, `Dish`.`critics_vote_count`, `Dish`.`last_review_date`, `Dish`.`review_count`, `Dish`.`is_divine`, `Dish`.`dish_image_filepath`, `Dish`.`dish_image_created` FROM `dishes` AS `Dish` WHERE `Dish`.`location_id` = (2390) 110
18SELECT dishes.vote_avg, reviews.*, users.*, profiles.image, profiles.image_small FROM dishes LEFT JOIN reviews ON dishes.id=reviews.dish_id LEFT JOIN users ON reviews.user_id=users.id LEFT JOIN profiles ON users.id=profiles.user_id WHERE dishes.id='3781' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
19SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `dishes` AS `Dish` ON (`Review`.`dish_id` = `Dish`.`id`) WHERE dish_id='3781' 110
20SELECT `Image`.*, `OriginalImage`.*, `DishImage`.`id` FROM `dish_images` AS `DishImage` LEFT JOIN `dishes` AS `Dish` ON (`DishImage`.`dish_id` = `Dish`.`id`) LEFT JOIN `images` AS `Image` ON (`DishImage`.`image_id` = `Image`.`id`) LEFT JOIN `images` AS `OriginalImage` ON (`DishImage`.`original_image_id` = `OriginalImage`.`id`) WHERE dish_id=3781 ORDER BY `Image`.`created` DESC LIMIT 1110
21SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2389' LIMIT 1110
22SELECT `Dish`.`id`, `Dish`.`user_id`, `Dish`.`name`, `Dish`.`location_id`, `Dish`.`disabled`, `Dish`.`created`, `Dish`.`modified`, `Dish`.`vote_avg`, `Dish`.`vote_count`, `Dish`.`members_vote_avg`, `Dish`.`members_vote_count`, `Dish`.`industry_vote_avg`, `Dish`.`industry_vote_count`, `Dish`.`critics_vote_avg`, `Dish`.`critics_vote_count`, `Dish`.`last_review_date`, `Dish`.`review_count`, `Dish`.`is_divine`, `Dish`.`dish_image_filepath`, `Dish`.`dish_image_created` FROM `dishes` AS `Dish` WHERE `Dish`.`location_id` = (2389) 110
23SELECT dishes.vote_avg, reviews.*, users.*, profiles.image, profiles.image_small FROM dishes LEFT JOIN reviews ON dishes.id=reviews.dish_id LEFT JOIN users ON reviews.user_id=users.id LEFT JOIN profiles ON users.id=profiles.user_id WHERE dishes.id='3780' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
24SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `dishes` AS `Dish` ON (`Review`.`dish_id` = `Dish`.`id`) WHERE dish_id='3780' 110
25SELECT `Image`.*, `OriginalImage`.*, `DishImage`.`id` FROM `dish_images` AS `DishImage` LEFT JOIN `dishes` AS `Dish` ON (`DishImage`.`dish_id` = `Dish`.`id`) LEFT JOIN `images` AS `Image` ON (`DishImage`.`image_id` = `Image`.`id`) LEFT JOIN `images` AS `OriginalImage` ON (`DishImage`.`original_image_id` = `OriginalImage`.`id`) WHERE dish_id=3780 ORDER BY `Image`.`created` DESC LIMIT 1110
26SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2130' LIMIT 1110
27SELECT `Dish`.`id`, `Dish`.`user_id`, `Dish`.`name`, `Dish`.`location_id`, `Dish`.`disabled`, `Dish`.`created`, `Dish`.`modified`, `Dish`.`vote_avg`, `Dish`.`vote_count`, `Dish`.`members_vote_avg`, `Dish`.`members_vote_count`, `Dish`.`industry_vote_avg`, `Dish`.`industry_vote_count`, `Dish`.`critics_vote_avg`, `Dish`.`critics_vote_count`, `Dish`.`last_review_date`, `Dish`.`review_count`, `Dish`.`is_divine`, `Dish`.`dish_image_filepath`, `Dish`.`dish_image_created` FROM `dishes` AS `Dish` WHERE `Dish`.`location_id` = (2130) 110
28SELECT dishes.vote_avg, reviews.*, users.*, profiles.image, profiles.image_small FROM dishes LEFT JOIN reviews ON dishes.id=reviews.dish_id LEFT JOIN users ON reviews.user_id=users.id LEFT JOIN profiles ON users.id=profiles.user_id WHERE dishes.id='3268' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1117
29SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `dishes` AS `Dish` ON (`Review`.`dish_id` = `Dish`.`id`) WHERE dish_id='3268' 110
30SELECT `Image`.*, `OriginalImage`.*, `DishImage`.`id` FROM `dish_images` AS `DishImage` LEFT JOIN `dishes` AS `Dish` ON (`DishImage`.`dish_id` = `Dish`.`id`) LEFT JOIN `images` AS `Image` ON (`DishImage`.`image_id` = `Image`.`id`) LEFT JOIN `images` AS `OriginalImage` ON (`DishImage`.`original_image_id` = `OriginalImage`.`id`) WHERE dish_id=3268 ORDER BY `Image`.`created` DESC LIMIT 1110
31SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) LEFT JOIN `users` AS `User` ON (`Dish`.`user_id` = `User`.`id`) LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`longitude` BETWEEN -117.528301498 AND -116.660898502 AND `Location`.`latitude` BETWEEN 32.2369985023 AND 33.1044014977 AND `Dish`.`disabled`=0 111
32SELECT `DishSet`.*, `DishSet`.`id` FROM `sets` AS `DishSet` LEFT JOIN `users` AS `User` ON (`DishSet`.`user_id` = `User`.`id`) WHERE `DishSet`.`name` <> "Must Try" AND `DishSet`.`count_dishes` > 0 ORDER BY `DishSet`.`modified` DESC LIMIT 5550