WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a581.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_options`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a582.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_favethemes_insights`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a584.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_postmeta`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a585.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_postmeta`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a586.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_postmeta`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a588.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a589.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a58a.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a58b.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a58c.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a58d.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a58e.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a58f.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a590.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a591.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

Luxury 400 M² Villa In Scenic Sithonia - European.realestate

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a594.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a595.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a596.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

Advanced
Search

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a597.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

For Sale

Luxury 400 M² Villa In Scenic Sithonia

  • €1.200.000

Overview

Property ID: EU-266676
  • Villa
  • Property Type
  • 400
  • Area Size
  • 2000
  • Land Area
  • 4
  • Bedrooms
  • 5
  • Bathrooms
  • 1989
  • Year Built

Description


Stunning 2-Storey Villa for Sale in Sithonia, Chalkidiki

Are you on the lookout for a dream property in Greece? Look no further! This magnificent 2-storey villa, boasting a generous 400 square meters of space, is now on the market in the picturesque area of Sithonia, Chalkidiki. It’s not just a house; it’s your new home away from home.

Inside the Villa: Room to Breathe and Relax

The ground floor layout is designed for comfort and functionality, featuring a spacious living room, a well-equipped kitchen, a convenient shower room with a WC, and a storeroom that’s perfect for storing all your vacation essentials. It’s an ideal space for both relaxation and entertaining friends and family.

Head up to the first floor, where you’ll find four cozy bedrooms and an additional living room. You also get another bathroom plus another shower WC, giving everyone plenty of space to unwind after a long day at the beach. Imagine waking up in your bedroom, opening the window, and being greeted by stunning views of the sea, mountains, and lush forests. Pure bliss!

Outdoor Enjoyment: More Than Just a View

But it doesn’t stop with the interior. Step outside, and you’ll find a lovely barbecue area—perfect for sizzling up some Mediterranean delights while enjoying evenings under the stars. The property also includes a beautifully landscaped garden that provides both beauty and a space for kids and pets to play.

Advertisment

For those summer heat waves, there is air conditioning to keep the villa cool, and a fireplace to keep you warm during those cooler months. And yes, the furniture is included in the sale, making your move-in process that much easier.

Additional Features You’ll Love

This villa also comes with a convenient parking space, ensuring you never have to worry about finding a spot after a long day out. With everything this property offers, it truly encapsulates what island living is all about.

Important Information

It’s essential to note that the details of this listing are based solely on information provided by the property owner and are subject to change. To view the property, you’ll need to provide your ID and tax number, as outlined in the demonstration agreement in accordance with Law 4072/2012. Also, keep in mind that the map provided gives a general idea of the location, not the exact spot.

Ready to cruise into paradise? Don’t miss out on this extraordinary opportunity in Chalkidiki. For more information, or to arrange a viewing, contact us today. Your Mediterranean dream home awaits!

Address

Open on Google Maps
  • Address: Sithonia, Chalkidiki, Macedonia, Greece
  • Zip/Postal Code: 63081
  • Country: Greece

Details

Updated on July 6, 2025 at 3:03 am
  • Property ID EU-266676
  • Price €1.200.000
  • Property Size 400 m²
  • Land Area 2000 m²
  • Bedrooms 4
  • Rooms 2
  • Bathrooms 5
  • Year Built 1989
  • Property Type Villa
  • Property Status For Sale
  • Ref. number 10910

Mortgage Estimation

Schedule a Tour

Tour Type

Similar Listings

For Sale
  • €1.700.000

Spacious 480 M² Villa For Sale In Attica

Paiania, Athens - East, Attica, Greece
  • 480 m²
  • 3500 m²
  • Beds: 5
  • Baths: 3
  • Villa
Details
Grekodom
17 hours ago
For Sale
  • €600.000

Spacious 240m² Villa On The Scenic Athos Peninsula

Aristotle, Chalkidiki, Macedonia, Greece
  • 240 m²
  • 3500 m²
  • Beds: 4
  • Baths: 4
  • Villa
Details
Grekodom
17 hours ago
For Sale
  • €355.000

Charming 80 M² Villa In Crete For Your Dream Getaway

Agios Nikolaos, Lasithi Prefecture, Crete, Greece
  • 80 m²
  • 350 m²
  • Beds: 2
  • Baths: 5
  • Villa
Details
Grekodom
18 hours ago
For Sale
  • €660.000

Stunning 178 M² Villa In The Heart Of Peloponnese

Githeio, Lakonia, Peloponnisos, Greece
  • 178 m²
  • 3100 m²
  • Beds: 3
  • Baths: 5
  • Villa
Details
Grekodom
2 days ago
Disclaimer: Please note that this property listing is an automatically generated advertisement. The descriptions have been rewritten by our AI agent and should not be considered official property particulars. While European.realestate requires all advertisers to provide accurate information, we do not independently verify the details and cannot accept liability for any inaccuracies. Always contact the listing agent directly for the most accurate and up-to-date information about the property. We strongly recommend obtaining independent legal advice before proceeding with any property purchase.

Notice something incorrect? Help us improve by reporting any issues. You can let us know what you've found by clicking here: Report a problem.

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a59b.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a59c.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-690599-19a59d.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-266676"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC