Pontinian Islands
The beautiful Pontinian Islands consist of Ponza, Palmarola, Ventotene, Zannone, Gavi and Santo Stefano and are located half way between Rome and Naples, outside of the Gulf of Gaeta.
| Country name | Italy |
|---|
SELECT wp974_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp974_postmeta price_meta2 WHERE price_meta2.post_id=wp974_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2020-06-01:2022-06-01' LIMIT 1), 0) accommodation_price FROM wp974_posts INNER JOIN wp974_postmeta ON ( wp974_posts.ID = wp974_postmeta.post_id ) JOIN wp974_icl_translations wpml_translations
ON wp974_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp974_posts.post_type) LEFT JOIN wp974_icl_translations wpml_translations_default ON wpml_translations_default.trid = wpml_translations.trid AND wpml_translations_default.source_language_code IS NULL WHERE 1=1 AND (
( wp974_postmeta.meta_key = 'accommodation_location_post_id' AND wp974_postmeta.meta_value IN ('809') )
) AND wp974_posts.post_type = 'accommodation' AND ((wp974_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp974_posts.post_type IN ('post','page','attachment','wp_block','location','accommodation','acf-field-group','product','product_variation','wpcf7_contact_form','mc4wp-form' ) ) OR wp974_posts.post_type NOT IN ('post','page','attachment','wp_block','location','accommodation','acf-field-group','product','product_variation','wpcf7_contact_form','mc4wp-form' ) ) GROUP BY wp974_posts.ID HAVING 1=1 ORDER BY wp974_posts.post_title ASC
