SELECT h.name, h.type AS star, h.rating_details, h.currency, h.address, h.hotel_type, h.faq,
            ht.name AS hotel_type_name, hp.gallery, hp.title, hp.description, hp.content, c.name AS city, c.id AS city_id, c.domestic, COALESCE(c.country2, 'Iran') AS country, h.lat, h.lang
            FROM hotel h
            JOIN hotel_type ht ON h.hotel_type = ht.id
            JOIN hotel_page hp ON hp.hotel_id = h.id
            JOIN cities c ON h.city = c.id
            WHERE h.id = 2696