SELECT `bussiness`.*, "nagpur" as `city`, GROUP_CONCAT(DISTINCT bussiness_category_mapping.category_id) as sub_category_ids, GROUP_CONCAT(DISTINCT bussiness_tag_mapping.tag_id) as tag_ids, count(bussiness_comments.bussiness_id) as comment, avg(bussiness_comments.rating) as rating FROM `bussiness` LEFT JOIN `bussiness_category_mapping` ON `bussiness`.`ID`=`bussiness_category_mapping`.`bussiness_id` LEFT JOIN `bussiness_tag_mapping` ON `bussiness`.`ID`=`bussiness_tag_mapping`.`bussiness_id` LEFT JOIN `category_mapping` ON `category_mapping`.`category_id`=`bussiness_category_mapping`.`category_id` LEFT JOIN `category` ON `category`.`ID` = `category_mapping`.`category_id` LEFT JOIN `city` ON `city`.`id` = `bussiness`.`city_id` LEFT JOIN `bussiness_comments` ON `bussiness`.`ID` = `bussiness_comments`.`bussiness_id` WHERE `bussiness`.`status` = 'Enable' AND `bussiness`.`city_id` = '8' AND `bussiness`.`ID` = '15743' AND `bussiness`.`city_id` = '8' GROUP BY `bussiness`.`ID` ORDER BY `bussiness`.`title` DESC LIMIT 1 Pandit Prasad

Pandit Prasad

  • +(91)-9850081492, 9405234133.
  • 222 Ramnarayan Chandak Vihar Saipul, Bijapur Road, Solapur Ho, Near Mahalaxmi Mandir, Solapur - 413
        

69    

Opening Hours

Mon 10:00 am - 7:00 pm
Tue 10:00 am - 7:00 pm
Wed 10:00 am - 7:00 pm
Thu 10:00 am - 7:00 pm
Fri 10:00 am - 7:00 pm
Sat 10:00 am - 7:00 pm
Sun Closed

photo gallery

Video





Comments & rating 0 0 Reviews

Top