Nyheter | Lexington Realty
Lexington Realty dedicated estate agency in Costa Blanca

Nyheter

Up date on the Spanish property market

Up date on the Spanish property market

9 October 2020

2025-02-13T17:52:44+01:00info
Database connected
2025-02-13T17:52:44+01:00sql7 ms
SELECT *, clave FROM lexington_traducciones
2025-02-13T17:52:44+01:00sql1 ms
SELECT clave, valor FROM lexington_config
2025-02-13T17:52:44+01:00sql1 ms
	SELECT id, clave, parent_id, privado, formulario,
					titulo_se AS titulo, banner,
					link_se AS link,
					slug_se AS slug,
					meta_key_se AS meta_key,
					meta_descr_se AS meta_descr,
					art_se AS text
					FROM lexington_articulos 
					 WHERE slug_se = 'nyheter' 
					
2025-02-13T17:52:44+01:00sql0 ms
	SELECT id, clave, 
					titulo_se AS title,
					link_se AS link,
					slug_se AS slug,
					art_se AS text,
					meta_descr_se 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 = 15
					ORDER BY orden
					
2025-02-13T17:52:44+01:00sql0 ms
SELECT file_name FROM lexington_images_articulos WHERE parent_id = 15 ORDER BY orden
2025-02-13T17:52:44+01:00sql0 ms
SELECT file_name FROM lexington_files_articulos WHERE parent_id = 15 ORDER BY orden
2025-02-13T17:52:44+01:00sql3 ms
 	SELECT *, id, clave, link_se AS link,  titulo_se AS titulo,
					slug_se AS slug, header_menu, footer_menu, parent_id, orden
					FROM lexington_articulos
					ORDER BY orden
					
2025-02-13T17:52:44+01:00sql0 ms
SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'noticias'
2025-02-13T17:52:44+01:00sql0 ms
SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'noticias'
2025-02-13T17:52:44+01:00sql0 ms
SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'noticias'
2025-02-13T17:52:44+01:00sql2 ms
	SELECT id,
					titulo_se AS titulo,
					descr_se 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
					
2025-02-13T17:52:44+01:00sql0 ms
	SELECT id,
					titulo_se AS titulo,
					descr_se 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 0, 6 
2025-02-13T17:52:44+01:00sql0 ms
	SELECT id, fecha,
					titulo_se AS titulo,
					descr_se AS descripcion
					FROM lexington_noticias main
					WHERE 1 = 1
					 AND id = 12
					
					ORDER BY fecha DESC
                    LIMIT 1
					
2025-02-13T17:52:44+01:00sql0 ms
SELECT parent_id, file_name FROM lexington_images_noticias WHERE parent_id = 12 ORDER BY orden
2025-02-13T17:52:44+01:00sql0 ms
SELECT meta_descr_se AS field FROM lexington_articulos WHERE clave = 'inicio'
2025-02-13T17:52:44+01:00sql0 ms
SELECT art_se AS field FROM lexington_articulos WHERE clave = 'inicio'
2025-02-13T17:52:44+01:00sql0 ms
	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 = 'noticias'