- €€€€
Buscar en TUDESTINO
Select destinationAndalusiaProvince of CadizAlcala de los GazulesAlcala del ValleAlgarAlgecirasAlgodonalesArcos de la FronteraBarbateLos Caños de MecaZahara de los AtunesZahoraBenalup-Casas ViejasBenaocazBornosCadiz cityCastellar de la FronteraChiclana de la FronteraChipionaConil de la FronteraEl BosqueEl GastorEl Puerto de Santa MariaEsperaGrazalemaBenamahomaJerez de la FronteraJimena de la FronteraLa Linea de la ConcepciónLos BarriosPalmonesMedina SidoniaOlveraPaterna de RiveraPrado del ReyPuerto RealPuerto SerranoRotaSan FernandoSan Jose del ValleSan Martin del TesorilloSan RoqueSotograndeSanlucar de BarramedaSetenil de las BodegasTarifaTorre AlhaquimeTrebujenaUbriqueVejer de la FronteraEl PalmarVillaluenga del RosarioVillamartínZahara de la SierraProvince of MalagaArdalesBenalmadenaCasaresEsteponaFuengirolaMalaga CityManilvaMarbellaNerjaRondaSan Pedro de AlcantaraTorremolinosTorrox costaVelez- MalagaProvince of SevilleSeville City
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) 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) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (2164,2237,2241,2243,2244,2247,2249,2250,2253,2254,2258,2260,2262,2276,2278,2280,2282,2284,2286,2288,2308,2310,2312,2314,2318,2322,2324,2326,2328,2391,2393,2395,2399,2401,2403,2405,2411,2413,2415,2417,2419,2421,2423,2425,2427,2429,2431,2433,2435,2437,2439,2441,2443,2445,2447,2449,2454,2457,2471,2473,2477,2479,2482,2484,2488,2489,2507,2510,2515,2523,2524,2526,2534,2535,2536,2541,2543,2545,2561,2562,2568,2569,2573,2581,2582,2583,2585,2586,2589,2590,2593,2598,2602,2610,2611,2615,2617,2624,12561,22261,22525)
) AND (
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '1' )
OR
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '0' )
OR
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '' )
) AND wp_posts.post_type = 'listing' 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','listing','acf-field-group','cookielawinfo','g','comarcas' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','listing','acf-field-group','cookielawinfo','g','comarcas' ) ) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value DESC, RAND() DESC LIMIT 0, 10
