Immobilien Alicante Costa Blanca

SELECT *, clave FROM lexington_traducciones

SELECT clave, valor FROM lexington_config

	SELECT id, clave, parent_id, privado, formulario,
					titulo_de AS titulo, banner,
					link_de AS link,
					slug_de AS slug,
					meta_key_de AS meta_key,
					meta_descr_de AS meta_descr,
					art_de AS text
					FROM lexington_articulos 
					WHERE clave = 'inicio'
					

	SELECT id, clave, 
					titulo_de AS title,
					link_de AS link,
					slug_de AS slug,
					art_de AS text,
					meta_descr_de AS meta,
					(SELECT img.file_name as file_name
        FROM lexington_images_articulos img
        WHERE img.parent_id = main.id
        ORDER BY img.orden ASC
        LIMIT 1) AS file_name 
					FROM lexington_articulos main
					WHERE parent_id = 1
					ORDER BY orden
					

SELECT file_name FROM lexington_images_articulos WHERE parent_id = 1 ORDER BY orden

SELECT file_name FROM lexington_files_articulos WHERE parent_id = 1 ORDER BY orden

 	SELECT *, id, clave, link_de AS link,  titulo_de AS titulo,
					slug_de AS slug, header_menu, footer_menu, parent_id, orden
					FROM lexington_articulos
					ORDER BY orden
					

SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'inicio'

SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'inicio'

SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'inicio'

SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'inicio'

  SELECT *, titulo_de AS titulo, descr_de AS descripcion, link_de AS link 
                    FROM lexington_panoramicas 
                    ORDER BY orden

SELECT id FROM lexington_viviendas WHERE destacado = 1 AND visible = 1

					SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda,
					sup_parcela, precio_de_venta, main.fecha_creado, precio_desde,
					descripcion_de AS descripcion,
					piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones,
					 
					
					lat, lon, reservado, vendido, reducido, agente,
					main.titulo_de AS titulo, 
					loc.nombre AS localidad,
					tip.nombre_de AS tipo, 
					cla.id AS clase_id, cla.nombre_de AS clase,
					cos.nombre_de AS costa, loc.costa_id,
					opciones_json,
					
						(SELECT img.file_name as file_name
						FROM lexington_images_viviendas img
						WHERE img.parent_id = main.id
						ORDER BY img.orden ASC, img.id ASC
						LIMIT 1) AS file_name
					FROM lexington_viviendas main
					LEFT JOIN lexington_localidades loc ON main.localidad_id = loc.id
					LEFT JOIN lexington_zonas zon ON main.zona_id = zon.id
					LEFT JOIN lexington_tipos tip ON main.tipo_id = tip.id
					LEFT JOIN lexington_clases cla ON main.clase_id = cla.id
					LEFT OUTER JOIN lexington_costas cos ON loc.costa_id = cos.id
					WHERE 1 = 1
		 AND ( main.id = 8331 OR  main.id = 11940 OR  main.id = 11991 OR  main.id = 12129 OR  main.id = 12304 OR  main.id = 12343) ORDER BY main.id DESC

					SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda,
					sup_parcela, precio_de_venta, main.fecha_creado, precio_desde,
					descripcion_de AS descripcion,
					piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones,
					 
					
					lat, lon, reservado, vendido, reducido, agente,
					main.titulo_de AS titulo, 
					loc.nombre AS localidad,
					tip.nombre_de AS tipo, 
					cla.id AS clase_id, cla.nombre_de AS clase,
					cos.nombre_de AS costa, loc.costa_id,
					opciones_json,
					
						(SELECT img.file_name as file_name
						FROM lexington_images_viviendas img
						WHERE img.parent_id = main.id
						ORDER BY img.orden ASC, img.id ASC
						LIMIT 1) AS file_name
					FROM lexington_viviendas main
					LEFT JOIN lexington_localidades loc ON main.localidad_id = loc.id
					LEFT JOIN lexington_zonas zon ON main.zona_id = zon.id
					LEFT JOIN lexington_tipos tip ON main.tipo_id = tip.id
					LEFT JOIN lexington_clases cla ON main.clase_id = cla.id
					LEFT OUTER JOIN lexington_costas cos ON loc.costa_id = cos.id
					WHERE 1 = 1
		 AND ( main.id = 8331 OR  main.id = 11940 OR  main.id = 11991 OR  main.id = 12129 OR  main.id = 12304 OR  main.id = 12343) ORDER BY main.id DESC LIMIT 0, 18 

SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (opciones_json LIKE '%"65"%')

SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (opciones_json LIKE '%"83"%')

SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (clase_id = 1)

SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (localidad_id = 2)

SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (localidad_id = 5)

SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (localidad_id = 18)

					SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda,
					sup_parcela, precio_de_venta, main.fecha_creado, precio_desde,
					descripcion_de AS descripcion,
					piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones,
					 
					
					lat, lon, reservado, vendido, reducido, agente,
					main.titulo_de AS titulo, 
					loc.nombre AS localidad,
					tip.nombre_de AS tipo, 
					cla.id AS clase_id, cla.nombre_de AS clase,
					cos.nombre_de AS costa, loc.costa_id,
					opciones_json,
					
						(SELECT img.file_name as file_name
						FROM lexington_images_viviendas img
						WHERE img.parent_id = main.id
						ORDER BY img.orden ASC, img.id ASC
						LIMIT 1) AS file_name
					FROM lexington_viviendas main
					LEFT JOIN lexington_localidades loc ON main.localidad_id = loc.id
					LEFT JOIN lexington_zonas zon ON main.zona_id = zon.id
					LEFT JOIN lexington_tipos tip ON main.tipo_id = tip.id
					LEFT JOIN lexington_clases cla ON main.clase_id = cla.id
					LEFT OUTER JOIN lexington_costas cos ON loc.costa_id = cos.id
					WHERE 1 = 1
		 AND (visible = 1) ORDER BY main.id DESC LIMIT 8

	SELECT loc.id AS id, loc.nombre, COUNT(*) AS count
					FROM lexington_viviendas viv
					LEFT JOIN lexington_localidades loc
						ON viv.localidad_id = loc.id 
					GROUP BY loc.nombre
					ORDER BY count DESC

				

	SELECT id,
					titulo_de AS titulo,
					descr_de AS descripcion,
					fecha
					
		, (SELECT img.file_name as file_name
		FROM lexington_images_noticias img
		WHERE img.parent_id = main.id
		ORDER BY img.orden ASC
		LIMIT 1) AS img
					FROM lexington_noticias main
					 WHERE fecha <= '2025-02-13' 
					ORDER BY fecha DESC
					 LIMIT 3

  
                    SELECT main.*, mensaje_de AS mensaje,
                    pais.nombre_de AS pais,
                    
                    (SELECT img.file_name as file_name
                    FROM lexington_images_testimonios img
                    WHERE img.parent_id = main.id
                    ORDER BY img.orden ASC
                    LIMIT 1) AS file_name
                    FROM lexington_testimonios main
                    LEFT OUTER JOIN lexington_paises pais
                    ON main.pais_id = pais.id
                    AND mensaje_de != ''
                     ORDER BY RAND() 
                     LIMIT 2 
                    

	SELECT file_name, art.id AS aid
					FROM lexington_images_articulos img
					JOIN lexington_articulos art
						ON img.parent_id = art.id
					WHERE art.clave = 'inicio'

SELECT id, nombre_de AS nombre FROM lexington_costas ORDER BY orden

                    SELECT id, nombre AS nombre 
                    FROM lexington_localidades  c
                    WHERE c.id IN (SELECT DISTINCT localidad_id FROM lexington_viviendas WHERE visible = 1)
                    ORDER BY nombre

                    SELECT id, nombre_de AS nombre 
                    FROM lexington_tipos  c
                    WHERE c.id IN (SELECT DISTINCT tipo_id FROM lexington_viviendas WHERE visible = 1)
                    ORDER BY nombre

                    SELECT id, referencia AS nombre 
                    FROM lexington_viviendas  c
                    WHERE visible = 1
                    ORDER BY nombre

	SELECT file_name, art.id AS aid
					FROM lexington_images_articulos img
					JOIN lexington_articulos art
						ON img.parent_id = art.id
					WHERE art.clave = 'inicio'