Real estate services & holiday rentals with the personal touch: between Monaco, Nice, Cannes & St. Tropez. WordPress database error: [Disk full (/tmp/#sql_227_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]SELECT vcd_posts.*
FROM vcd_posts INNER JOIN vcd_postmeta ON ( vcd_posts.ID = vcd_postmeta.post_id ) JOIN vcd_icl_translations wpml_translations
ON vcd_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', vcd_posts.post_type)
WHERE 1=1 AND (
( vcd_postmeta.meta_key = '_wp_page_template' AND vcd_postmeta.meta_value = 'compare_listings.php' )
) AND vcd_posts.post_type = 'page' AND ((vcd_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'de'
AND vcd_posts.post_type IN ( 'e-landing-page','elementor_library' )
AND ( (
( SELECT COUNT(element_id)
FROM vcd_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM vcd_icl_translations t2
JOIN vcd_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 vcd_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','estate_property','estate_agent','e-landing-page','elementor_library','wpcf7_contact_form' ) ) OR vcd_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','estate_property','estate_agent','e-landing-page','elementor_library','wpcf7_contact_form' ) )
GROUP BY vcd_posts.ID
ORDER BY vcd_posts.menu_order, vcd_posts.post_title ASC
WordPress database error: [Disk full (/tmp/#sql_227_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]SELECT SQL_CALC_FOUND_ROWS vcd_posts.ID
FROM vcd_posts LEFT JOIN vcd_term_relationships ON (vcd_posts.ID = vcd_term_relationships.object_id) INNER JOIN vcd_postmeta ON ( vcd_posts.ID = vcd_postmeta.post_id ) JOIN vcd_icl_translations wpml_translations
ON vcd_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', vcd_posts.post_type)
WHERE 1=1 AND (
vcd_term_relationships.term_taxonomy_id IN (109)
) AND (
vcd_postmeta.meta_key = 'prop_featured'
) AND vcd_posts.post_type = 'estate_property' AND ((vcd_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'de'
AND vcd_posts.post_type IN ( 'e-landing-page','elementor_library' )
AND ( (
( SELECT COUNT(element_id)
FROM vcd_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM vcd_icl_translations t2
JOIN vcd_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 vcd_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','estate_property','estate_agent','e-landing-page','elementor_library','wpcf7_contact_form' ) ) OR vcd_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','estate_property','estate_agent','e-landing-page','elementor_library','wpcf7_contact_form' ) )
GROUP BY vcd_posts.ID
ORDER BY vcd_posts.menu_order, vcd_postmeta.meta_value DESC, vcd_posts.ID DESC
LIMIT 0, 20
Listings in Issambres
WordPress database error: [Disk full (/tmp/#sql_227_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]SELECT SQL_CALC_FOUND_ROWS vcd_posts.ID
FROM vcd_posts LEFT JOIN vcd_term_relationships ON (vcd_posts.ID = vcd_term_relationships.object_id) INNER JOIN vcd_postmeta ON ( vcd_posts.ID = vcd_postmeta.post_id ) JOIN vcd_icl_translations wpml_translations
ON vcd_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', vcd_posts.post_type)
WHERE 1=1 AND (
vcd_term_relationships.term_taxonomy_id IN (109)
) AND (
vcd_postmeta.meta_key = 'prop_featured'
) AND vcd_posts.post_type = 'estate_property' AND ((vcd_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'de'
AND vcd_posts.post_type IN ( 'e-landing-page','elementor_library' )
AND ( (
( SELECT COUNT(element_id)
FROM vcd_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM vcd_icl_translations t2
JOIN vcd_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 vcd_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','estate_property','estate_agent','e-landing-page','elementor_library','wpcf7_contact_form' ) ) OR vcd_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','estate_property','estate_agent','e-landing-page','elementor_library','wpcf7_contact_form' ) )
GROUP BY vcd_posts.ID
ORDER BY vcd_posts.menu_order, vcd_postmeta.meta_value DESC, vcd_posts.ID DESC
LIMIT 0, 70