string(1813) "SELECT SQL_CALC_FOUND_ROWS jfsdkl_2_posts.ID
FROM jfsdkl_2_posts JOIN jfsdkl_2_icl_translations wpml_translations
ON jfsdkl_2_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', jfsdkl_2_posts.post_type)
WHERE 1=1 AND jfsdkl_2_posts.post_type = 'vintage_whaton_posts' AND ((jfsdkl_2_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND jfsdkl_2_posts.post_type IN ( 'vintage_gallery','wpcf7_contact_form' )
AND ( (
( SELECT COUNT(element_id)
FROM jfsdkl_2_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM jfsdkl_2_icl_translations t2
JOIN jfsdkl_2_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR p.post_status = 'private' OR
( p.post_type='attachment' AND p.post_status = 'inherit' )
)
) = 0 ) )
) ) AND jfsdkl_2_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','vintage_room_posts','vintage_eat_posts','vintage_whaton_posts','vintage_spa_posts','vintage_gallery','vintage_press','vintage_offers','wpcf7_contact_form' ) ) OR jfsdkl_2_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','vintage_room_posts','vintage_eat_posts','vintage_whaton_posts','vintage_spa_posts','vintage_gallery','vintage_press','vintage_offers','wpcf7_contact_form' ) )
ORDER BY jfsdkl_2_posts.menu_order, jfsdkl_2_posts.post_date DESC
LIMIT 0, 8"
Enjoy our delicious cocktail of the month overlooking Lisbon’s sunset.
In need of a moment of relaxation? Take advantage of our Seasonal Special Spa Offer.
During Santos Populares, every corner of the city features grilled sardines, traditional music, and dancing in the streets.
8 Marvila is Lisbon’s latest creative hub, turning 11 former wine warehouses into an eclectic mix of entertainment, arts and boutique shopping.
Calouste Gulbenkian is one of Lisbon’s best kept secrets.
Discover our favourite spots, from classic Art Deco venues to more avant-garde spaces.
One of the hippest neighbourhoods in Lisbon, Príncipe Real is only a 5 minute walk from The Lumiares.
Tucked away between Santos and Santa Catarina, Rua da Silva, known to locals as Green Street is well worth a visit.