Lexington Realty agencja nieruchomości na Costa Blanca, Alicante, Santa Pola, Gran Alacant
Nieruchomości 1 - 18 / 453
Nieruchomości 1 - 18 / 453
2025-02-13T17:53:20+01:00 | info | Database connected | |
2025-02-13T17:53:20+01:00 | sql | 15 ms | SELECT *, clave FROM lexington_traducciones |
2025-02-13T17:53:20+01:00 | sql | 0 ms | SELECT clave, valor FROM lexington_config |
2025-02-13T17:53:20+01:00 | sql | 0 ms | SELECT id, clave, parent_id, privado, formulario, titulo_pl AS titulo, banner, link_pl AS link, slug_pl AS slug, meta_key_pl AS meta_key, meta_descr_pl AS meta_descr, art_pl AS text FROM lexington_articulos WHERE slug_pl = 'sprzedaz-mieszkan' |
2025-02-13T17:53:20+01:00 | sql | 0 ms | SELECT id, clave, titulo_pl AS title, link_pl AS link, slug_pl AS slug, art_pl AS text, meta_descr_pl 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 = 11 ORDER BY orden |
2025-02-13T17:53:20+01:00 | sql | 0 ms | SELECT file_name FROM lexington_images_articulos WHERE parent_id = 11 ORDER BY orden |
2025-02-13T17:53:20+01:00 | sql | 0 ms | SELECT file_name FROM lexington_files_articulos WHERE parent_id = 11 ORDER BY orden |
2025-02-13T17:53:20+01:00 | sql | 2 ms | SELECT *, id, clave, link_pl AS link, titulo_pl AS titulo, slug_pl AS slug, header_menu, footer_menu, parent_id, orden FROM lexington_articulos ORDER BY orden |
2025-02-13T17:53:20+01:00 | sql | 0 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 = 'viviendas-apartamentos' |
2025-02-13T17:53:20+01:00 | sql | 0 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 = 'viviendas-apartamentos' |
2025-02-13T17:53:20+01:00 | sql | 0 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 = 'viviendas-apartamentos' |
2025-02-13T17:53:20+01:00 | sql | 0 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 = 'viviendas-apartamentos' |
2025-02-13T17:53:20+01:00 | sql | 166 ms | SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda, sup_parcela, precio_de_venta, main.fecha_creado, precio_desde, descripcion_pl AS descripcion, piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones, lat, lon, reservado, vendido, reducido, agente, main.titulo_pl AS titulo, loc.nombre AS localidad, tip.nombre_pl AS tipo, cla.id AS clase_id, cla.nombre_pl AS clase, cos.nombre_pl 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 ((tipo_id = 1 OR tipo_id = 2 OR tipo_id = 3)) AND (visible = 1) ORDER BY main.id DESC |
2025-02-13T17:53:20+01:00 | sql | 115 ms | SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda, sup_parcela, precio_de_venta, main.fecha_creado, precio_desde, descripcion_pl AS descripcion, piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones, lat, lon, reservado, vendido, reducido, agente, main.titulo_pl AS titulo, loc.nombre AS localidad, tip.nombre_pl AS tipo, cla.id AS clase_id, cla.nombre_pl AS clase, cos.nombre_pl 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 ((tipo_id = 1 OR tipo_id = 2 OR tipo_id = 3)) AND (visible = 1) ORDER BY main.id DESC LIMIT 0, 18 |
2025-02-13T17:53:20+01:00 | sql | 1 ms | SELECT meta_descr_pl AS field FROM lexington_articulos WHERE clave = 'inicio' |
2025-02-13T17:53:20+01:00 | sql | 0 ms | SELECT art_pl AS field FROM lexington_articulos WHERE clave = 'inicio' |
2025-02-13T17:53:20+01:00 | sql | 1 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 = 'viviendas-apartamentos' |
2025-02-13T17:53:20+01:00 | sql | 0 ms | SELECT id, nombre_pl AS nombre FROM lexington_costas ORDER BY orden |
2025-02-13T17:53:20+01:00 | sql | 6 ms | 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 |
2025-02-13T17:53:20+01:00 | sql | 4 ms | SELECT id, nombre_pl AS nombre FROM lexington_tipos c WHERE c.id IN (SELECT DISTINCT tipo_id FROM lexington_viviendas WHERE visible = 1) ORDER BY nombre |
2025-02-13T17:53:20+01:00 | sql | 76 ms | SELECT id, referencia AS nombre FROM lexington_viviendas c WHERE visible = 1 ORDER BY nombre |