SELECT DISTINCT (SELECT (SELECT room_price.orginal_price as orginal_price FROM `room_price` WHERE room_price.room_id = room.id AND room_price.from_date <= 1749081909 AND room_price.to_date >= 1749081909 ORDER BY room_price.id DESC LIMIT 1) AS orginal_price FROM `room` WHERE room.hotelid = hotel.id ORDER BY price ASC LIMIT 1 ) as orginal_price, (SELECT (SELECT room_price.price as price FROM `room_price` WHERE room_price.room_id = room.id AND room_price.from_date <= 1749081909 AND room_price.to_date >= 1749081909 ORDER BY room_price.id DESC LIMIT 1) AS price FROM `room` WHERE room.hotelid = hotel.id ORDER BY price ASC LIMIT 1 ) as min_price, (SELECT (SELECT ( 100 - 100 * room_price.price / room_price.orginal_price) AS discount FROM `room_price` WHERE room_price.room_id = room.id AND room_price.from_date <= 1749081909 AND room_price.to_date >= 1749081909 ORDER BY room_price.id DESC limit 1 ) AS discount FROM `room` WHERE room.hotelid = hotel.id ORDER BY discount DESC LIMIT 1 ) as discount, (SELECT hotel_page.alias FROM `hotel_page` WHERE hotel_page.hotel_id=hotel.id LIMIT 1) as url, (SELECT COUNT(`totalprice`) as sell_value FROM `reserve` WHERE `hotelid`=hotel.id AND `status`=1 AND `paid` = 1) as sell_count, (SELECT SUM(`totalprice`) as sell_value FROM `reserve` WHERE `hotelid`=hotel.id AND `status`=1 AND `paid` = 1) as sell_value, hotel.rating_details as ratings, hotel.id as id, hotel.type as hotel_grade, hotel.image as hotel_image, hotel.name as hotel_name, hotel.address as address, cities.name as city_name, cities.id as city_id, (SELECT extra_fields_values.value FROM `extra_fields_values` WHERE `hotel_id` = hotel.id AND extra_fields_values.item_id=114 LIMIT 1) as darya,(SELECT extra_fields_values.value FROM `extra_fields_values` WHERE `hotel_id` = hotel.id AND extra_fields_values.item_id=1 LIMIT 1) as haram,(SELECT extra_fields_values.value FROM `extra_fields_values` WHERE `hotel_id` = hotel.id AND extra_fields_values.item_id=25 LIMIT 1) as estakhr,(SELECT extra_fields_values.value FROM `extra_fields_values` WHERE `hotel_id` = hotel.id AND extra_fields_values.item_id=51 LIMIT 1) as shop,(SELECT extra_fields_values.value FROM `extra_fields_values` WHERE `hotel_id` = hotel.id AND extra_fields_values.item_id=10 LIMIT 1) as wifi,(SELECT extra_fields_values.value FROM `extra_fields_values` WHERE `hotel_id` = hotel.id AND extra_fields_values.item_id=22 LIMIT 1) as service_irani,(SELECT extra_fields_values.value FROM `extra_fields_values` WHERE `hotel_id` = hotel.id AND extra_fields_values.item_id=21 LIMIT 1) as service_farangi,(SELECT extra_fields_values.value FROM `extra_fields_values` WHERE `hotel_id` = hotel.id AND extra_fields_values.item_id=35 LIMIT 1) as parking,(SELECT extra_fields_values.value FROM `extra_fields_values` WHERE `hotel_id` = hotel.id AND extra_fields_values.item_id=29 LIMIT 1) as restaurant,(SELECT extra_fields_values.value FROM `extra_fields_values` WHERE `hotel_id` = hotel.id AND extra_fields_values.item_id=31 LIMIT 1) as kafishop,(SELECT extra_fields_values.value FROM `extra_fields_values` WHERE `hotel_id` = hotel.id AND extra_fields_values.item_id=34 LIMIT 1) as varzeshi,(SELECT extra_fields_values.value FROM `extra_fields_values` WHERE `hotel_id` = hotel.id AND extra_fields_values.item_id=30 LIMIT 1) as room24,(SELECT extra_fields_values.value FROM `extra_fields_values` WHERE `hotel_id` = hotel.id AND extra_fields_values.item_id=38 LIMIT 1) as koodakan,(SELECT extra_fields_values.value FROM `extra_fields_values` WHERE `hotel_id` = hotel.id AND extra_fields_values.item_id=12 LIMIT 1) as amanat,(SELECT extra_fields_values.value FROM `extra_fields_values` WHERE `hotel_id` = hotel.id AND extra_fields_values.item_id=24 LIMIT 1) as fastinternet FROM `hotel`, `cities` WHERE cities.id = hotel.city AND (`notwork` IS NULL OR `notwork`=0)  AND (hotel.city = 10)  ORDER BY hotel.public_order ASC