SELECT SQL_CALC_FOUND_ROWS wp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_postmeta price_meta2 WHERE price_meta2.post_id=wpml_translations_default.element_id AND price_meta2.meta_key='_accommodation_min_price:2026-04-22:2028-04-22' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wpml_translations_default.element_id AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) LEFT JOIN wp_icl_translations wpml_translations_default ON wpml_translations_default.trid = wpml_translations.trid AND (wpml_translations_default.source_language_code IS NULL OR wpml_translations.source_language_code IS NULL)
WHERE 1=1 AND (
wp_postmeta.meta_key = 'accommodation_capienza_minima'
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','location','accommodation','tour','acf-field-group','wpcf7_contact_form','mec-events','mec_calendars','mc4wp-form','popup' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','location','accommodation','tour','acf-field-group','wpcf7_contact_form','mec-events','mec_calendars','mc4wp-form','popup' ) )
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_postmeta.meta_value+0 DESC
LIMIT 9, 9
Hotel business Via Aurelia Antica 415 - 10065 - Roma (RM)
13 Meeting rooms
30 - 600 People
307 Rooms
From €
Located a stone's throw from the Vatican, our hotel meets the needs of both business travelers, with its 13 meeting rooms and free wi-fi, and tourists.
Resort Località Torre Mezza Praia SS18 - 88022 - Acconia di Curinga (CZ)
3 Meeting rooms
30 - 300 People
518 Rooms
From €
Falkensteiner Club Funimation Garden Calabria is a resort with 518 rooms (of which 218 renovated) just 14 km from Lamezia Terme airport with 3 meeting rooms for a total capacity of 380 people. Numerous services and activities.
Hotel Riva del Mandracchio, 4 - 34124 - Trieste (TS)
9 Meeting rooms
30 - 320 People
144 Rooms
From €
Savoia Excelsior Palace, a historic hotel on Trieste’s waterfront, blends timeless elegance with breathtaking sea views. Opened in 1911, it embodies Mitteleuropean charm with modern comforts.
Restaurant Strada Statale 379 di Egnazia e delle Terme di Torre Canne - 72015 - Fasano (BR)
3 Meeting rooms
30 - 500 People
16 Rooms
From €
Exclusive Puglia venue for meetings, gala dinners, team-building and corporate events, with versatile indoor and outdoor spaces in an authentic masseria.
Hotel business Via Bonfadini 1- 31021 - Mogliano Veneto (TV)
10 Meeting rooms
26 - 500 People
203 Rooms
From €
10-minute drive from Venice airport and 20 minutes from the center of Venice.
203 rooms, 10 modular meeting rooms, at the ground floor and all with natural light, 2 restaurants, 2 outdoor event spaces, 500 free parking spaces
Fioraio Bianchi Caffè is an unprecedented location where private and corporate events can be held in a cozy and convivial atmosphere, adaptable to different needs
Space for events Via Ancona, 11/A - 10152 - Torino (TO)
4 Meeting rooms
25 - 1095 People
From €
La Centrale, located in the Nuvola Lavazza complex, is an impressive space created within the former power plant in the Aurora neighborhood. The architectural renovation project preserved and enhanced the original 1897 structure, maintaining its majestic industrial architecture intact, enhanced by the large wrought-iron windows overlooking the city. Today, it is a symbol of Turin's cultural dynamism and houses: The Space, the Indoor Terrace, the Conference Rooms, the Foyer, and the Grand Foyer. Over the years, La Centrale has hosted national and international events: conventions, meetings, trade fairs, exhibitions, concerts, product launches, press conferences, and private events.
