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 > Umraniye, TR
Adjust search
Results 1-1 of 1 dish:
  • Safari distance from Umraniye, TR (aka within 100 miles)
no image add yours
Default Dish Image
Avg. Review
Kuzu Kelle at Bayramoglu Ziyafet Sofrasi

Ümraniye, Atatürk, Alemdağ, 18, Umraniye, TR (0 miles away)

Lezzeti enfes. Görünümü mükemmel. Yedikten sonra biraz ağırlaşabilirsiniz. more…   [1 review]

Tags: kuzu  kelle  edit

(dishola_development) 16 queries took 21 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SET NAMES 'UTF8'00
2DESCRIBE `blogbuzz`25251
3DESCRIBE `blogbuzz_votes`551
4DESCRIBE `blogbuzz_comments`661
5DESCRIBE `blogbuzz_dishes`330
6SELECT * FROM locations_lookup WHERE locality_name='Umraniye' AND (administrative_area='TR' OR country_name_code='TR') LIMIT 0,11114
7SELECT `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name`, (((acos(sin((37.9*pi()/180)) * sin((Location.latitude*pi()/180)) + cos((37.9*pi()/180)) * cos((Location.latitude*pi()/180)) * cos(((30.1833 - 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 28.7376283409 AND 31.6289716591 AND `Location`.`latitude` BETWEEN 36.4543283409 AND 39.3456716591 AND `Dish`.`disabled`=0 ORDER BY `last_review_date` DESC LIMIT 5111
8SELECT `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` = 1750 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 220
9SELECT `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` = 1750 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 111
10SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1217' LIMIT 1110
11SELECT `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` = (1217) 110
12SELECT 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='1750' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
13SELECT 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='1750' 110
14SELECT `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=1750 ORDER BY `Image`.`created` DESC LIMIT 1001
15SELECT 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 28.7376283409 AND 31.6289716591 AND `Location`.`latitude` BETWEEN 36.4543283409 AND 39.3456716591 AND `Dish`.`disabled`=0 110
16SELECT `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