WordPress database error: [Unknown column 'tb3.status' in 'on clause']
SELECT SQL_CALC_FOUND_ROWS x7P1O6soI_posts.*, min(CAST(CASE WHEN IFNULL(tb.adult_price, 0) = 0 THEN tb.price ELSE tb.adult_price END AS DECIMAL) ) as st_price FROM x7P1O6soI_posts JOIN x7P1O6soI_icl_translations wpml_translations ON x7P1O6soI_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', x7P1O6soI_posts.post_type) INNER JOIN x7P1O6soI_st_room_availability as tb ON x7P1O6soI_posts.ID = tb.parent_id AND status = 'available' INNER JOIN x7P1O6soI_hotel_room as tb3 ON (tb.post_id = tb3.post_id and tb3.`status` IN ('publish', 'private')) INNER JOIN x7P1O6soI_st_hotel as tb2 ON x7P1O6soI_posts.ID = tb2.post_id WHERE 1=1 AND x7P1O6soI_posts.post_type = 'st_hotel' AND ((x7P1O6soI_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND x7P1O6soI_posts.post_type IN ('post','page','attachment','wp_block','product','product_variation','st_hotel','hotel_room','st_activity','st_tours','st_cars','st_rental','wpcf7_contact_form','mc4wp-form' ) ) OR x7P1O6soI_posts.post_type NOT IN ('post','page','attachment','wp_block','product','product_variation','st_hotel','hotel_room','st_activity','st_tours','st_cars','st_rental','wpcf7_contact_form','mc4wp-form' ) ) AND tb.check_in >= 1579910400 AND tb.check_out <= 1579996800 AND CAST(tb2.hotel_booking_period AS UNSIGNED) <= 0 GROUP BY x7P1O6soI_posts.ID ORDER BY tb2.is_featured desc LIMIT 0, 12

No hotel found

No hotels found.

Get Updates & More

Thoughtful thoughts to your inbox