WebController.php#1026defaultdb1.06msselectavg(value_for_money) as avg_value_for_money,
count(*) as count_ratings,
avg(rating) as avg_rating,
avg(cleanliness) as avg_cleanliness,
avg(facilities) as avg_facilities,
avg(comfort) as avg_comfort,
avg(location) as avg_location,
avg(hotel_staff) as avg_hotel_staff
from `ratings` whereexists (select*from `bookings` where `ratings`.`booking_id` = `bookings`.`id` and `hotel_id` ='350') limit 1
search-bar.blade.php#2defaultdb25.53msSELECT name,
COALESCE(MAX(address), "--") AS address
FROM (
(SELECT name, NULLAS address FROM cities WHERE deleted_at ISNULL)
UNION
(SELECT name, NULLAS address FROM states WHERE deleted_at ISNULL)
UNION
(SELECT name, address FROM hotels WHERE deleted_at ISNULL)
UNION
(SELECT name, address FROM hotels_b2b
JOIN hotels_b2b_additional_info ON hotels_b2b.HotelID = hotels_b2b_additional_info.hotelid
WHERE hotels_b2b_additional_info.selectStatus !=2AND hotels_b2b_additional_info.selectStatus != "")
UNION
(SELECT cityName AS name, NULLAS address FROM hotels_b2b)
UNION
(SELECT destinationName AS name, NULLAS address FROM hotels_b2b)
UNION
(SELECT cityName AS name, NULLAS address FROM hotels_b2b_city)
UNION
(SELECT cityLongName AS name, NULLAS address FROM hotels_b2b_city)
UNION
(SELECT stateCode AS name, NULLAS address FROM hotels_b2b)
) AS combined_data
GROUPBY name