Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the acf domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/oms-smart.de/vcd.oms-smart.de/wp-includes/functions.php on line 6121
Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the updraftplus domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/oms-smart.de/vcd.oms-smart.de/wp-includes/functions.php on line 6121
Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the wprentals-core domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/oms-smart.de/vcd.oms-smart.de/wp-includes/functions.php on line 6121
Notice: Die Funktion _load_textdomain_just_in_time wurde fehlerhaft aufgerufen. Das Laden der Übersetzung für die Domain wprentals wurde zu früh ausgelöst. Das ist normalerweise ein Hinweis auf Code im Plugin oder Theme, der zu früh läuft. Übersetzungen sollten mit der Aktion init oder später geladen werden. Weitere Informationen: Debugging in WordPress (engl.). (Diese Meldung wurde in Version 6.7.0 hinzugefügt.) in /var/www/vhosts/oms-smart.de/vcd.oms-smart.de/wp-includes/functions.php on line 6121
WordPress-Datenbank-Fehler: [Disk full (/tmp/#sql_227_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `vcd_options`
WordPress-Datenbank-Fehler: [Disk full (/tmp/#sql_227_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `vcd_options`
WordPress-Datenbank-Fehler: [Disk full (/tmp/#sql_227_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `vcd_options`
CANNES-MANDELIEU, VILLA «ROSANNA» – MaisonAzur
WordPress-Datenbank-Fehler: [Disk full (/tmp/#sql_227_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `vcd_options`
WordPress-Datenbank-Fehler: [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 = 'user_dashboard_my_reservations.php' )
) AND vcd_posts.post_type = 'page' AND ((vcd_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'de' 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 = 'de'
) = 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 = 'de'
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-Datenbank-Fehler: [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 = 'user_dashboard_my_bookings.php' )
) AND vcd_posts.post_type = 'page' AND ((vcd_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'de' 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 = 'de'
) = 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 = 'de'
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-Datenbank-Fehler: [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 = 'user_dashboard.php' )
) AND vcd_posts.post_type = 'page' AND ((vcd_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'de' 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 = 'de'
) = 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 = 'de'
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-Datenbank-Fehler: [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 = 'user_dashboard_profile.php' )
) AND vcd_posts.post_type = 'page' AND ((vcd_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'de' 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 = 'de'
) = 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 = 'de'
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-Datenbank-Fehler: [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 = 'advanced_search_results.php' )
) AND vcd_posts.post_type = 'page' AND ((vcd_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'de' 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 = 'de'
) = 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 = 'de'
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-Datenbank-Fehler: [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 LEFT JOIN vcd_term_relationships ON (vcd_posts.ID = vcd_term_relationships.object_id)
WHERE 1=1 AND (
vcd_term_relationships.term_taxonomy_id IN (74)
) AND vcd_posts.post_type = 'nav_menu_item' AND ((vcd_posts.post_status = 'publish'))
GROUP BY vcd_posts.ID
ORDER BY vcd_posts.menu_order ASC
WordPress-Datenbank-Fehler: [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 = 'terms_conditions.php' )
) AND vcd_posts.post_type = 'page' AND ((vcd_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'de' 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 = 'de'
) = 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 = 'de'
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
Zu Fuß zum Ort, Meer Nähe, in gepflegter Villenlage liegt dieses schöne Haus mit privatem Pool auf einem komplett gezäunten Grundstück. Schöner Blick auf das Meer und die Umgebung bis hin zu den Bergen. Die sehr gepflegte helle Villa verfügt über 3 schöne Schlafzimmer, darunter ein großes Masterzimmer mit Dressing und ensuite Badezimmer. 2 Zimmer im OG und ein weiteres Bad., sep. WC. Top renovierte Bäder. Auf der Wohnebene befindet sich eine offene gut ausgestattete neue moderne Küche, schöner Esstisch. Im Wohnbereich große Sofas, TV. Von überall haben Sie einen Austritt auf die mehreren Terrassen, die einen Blick auf das Meer und die Landschaft freigeben. Auf der Terrasse vor der Küche befindet sich ein großer Esstisch, auf der Terrasse vor dem Wohnbereich haben Sie gemütliche Loungesessel. Der Pool ist kindersicher mit Tor gezäunt. 4-6 Sonnenliegen stehen Ihnen zur Verfügung. 2-3 Parkplätze. Elektrisches Gate. Einkaufsmöglichkeiten und Restaurants sind in wenigen Minuten auch zu Fuß erreichbar. Ein sehr schönes gepflegtes Haus für Ihre Familie.
Ca 1.500 m2, gezäunt, schönes Grundstück mit Sonnenterrassen, Steingarten
Lage
Zu Fuß zum Ort mit allen Einkaufsmöglichkeiten, Restaurants und Bars, Hanglage von Cannes-Mandelieu mit wunderschönem Blick. In Meernähe.
Pool
Privater Pool ca 7 m, kindersicher gezäunt, mit komfortablen Sonnenliegen, Sonnenschirme
Terrasse
Große Terrasse vor dem Haus mit Eßtisch, Loungemöbel
Schlafzimmer insgesamt
4 mit Ventilatoren
Schlafzimmer 1
EG, großes Masterzimmer mit enszit Badezimmer, Großes Doppelbett 180 cm, es kann ein Kinderbett oder Zustellbett dazu gestellt werden
Schlafzimmer 2
Doppelbett. teilt sich Bad mit SZ 3
Schlafzimmer 3
Doppelbett. teilt sich Bad mit SZ 2
Badezimmer/WC
2 Badezimmer, 2 WCs
Wohnbereich
Schöner heller Wohnbereich mit Austritt auf die tolle Terrasse. TV
Küche
Große voll ausgestattete Küche mit allem, was man braucht, Kaffeemaschine Nespresso
Spülmaschine
Ja
BBQ
Ja
Waschmaschine
Ja
Internet
Ja
Kinderfreundlich
Ja
Haustier
Auf Anfrage
Klimaanlage
Nein, Ventilatoren in den Schlafzimmern
Parken
Komfortabel, elektrisches Tor
Inklusive
Nebenkosten (Wasser und Strom, Gas), Wäsche und Handtücher
Kaution
Ja
Fragen?
+33606590623
View more
Availability
Juli 2025
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
August 2025
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
September 2025
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Oktober 2025
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
November 2025
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Dezember 2025
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Januar 2026
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Februar 2026
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
März 2026
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
April 2026
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Mai 2026
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Juni 2026
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Juli 2026
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
August 2026
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
September 2026
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Oktober 2026
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
November 2026
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Dezember 2026
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Januar 2027
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Februar 2027
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
März 2027
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
April 2027
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Mai 2027
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Juni 2027
M
D
M
D
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
available booked
On the Map
4 Reviews
Posted on 27 August 2024
( 5 of 5)
Sehr schön gewesen unser Urlaub. Danke an den netten Eigentümer für alles, danke an die Agentur für die unkomplizierte Abwicklung.
Posted on 6 Juli 2023
( 5 of 5)
Netter Empfang durch den Eigentümer, das Haus war tipptopp sauber und alles liebevoll vorbereitet. Uns hat es super gefallen, wir möchten das Haus wärmstens empfehlen.
Posted on 1 September 2022
( 5 of 5)
Wir haben uns in dem Haus wohl gefühlt und haben alles sehr sauber und ordentlich vorgefunden. Das Haus ist hübsch und zweckmäßig eingerichtet. Alle Utensilien die im Alltag gebraucht werden sind vorhanden. Der Eigentümer ist ein sehr nettes Paar und hat uns herzlichst empfangen. Gab uns gute Tipps und das Gefühl uns jederzeit behilflich zu sein ohne sich aufzudrängen.Perfekt!!
Auch ihnen liebe Frau Andres vielen Dank für die unkomplizierte Buchung und perfekte Empfehlung.
Posted on 25 Juli 2022
( 5 of 5)
Wunderbares Haus, sehr gepflegt. Gute Ausstattung. Uns hat es an nichts gefehlt! Sehr zu empfehlen. Familie M aus Deutschland
WordPress-Datenbank-Fehler: [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 = 'de' 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 = 'de'
) = 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 = 'de'
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
This site is registered on wpml.org as a development site. Switch to a production site key to remove this banner.
(4)
0 0
WordPress-Datenbank-Fehler: [Disk full (/tmp/#sql_227_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `vcd_postmeta`
WordPress-Datenbank-Fehler: [Disk full (/tmp/#sql_227_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `vcd_postmeta`
