Spanish Properties for sale - apartment or villa on Costa Blanca and Calida

Estoy de acuerdo

Utilizamos cookies propias y de terceros para realizar análisis de uso y de medición de nuestra web para mejorar nuestros servicios. Si continua navegando, consideramos que acepta su uso. Para obtener más información aquí.

Download our glossy MED Magazine for free

Medvilla Spanje
*
*
*

2019-12-06T00:04:29+00:00info1280 KbDatabase connected
2019-12-06T00:04:29+00:00sql1280 KbSELECT *, clave FROM medvilla_traducciones
2019-12-06T00:04:29+00:00sql4864 Kb SELECT id, clave, parent_id, titulo_en AS titulo, link_en AS link, slug_en AS slug, meta_key_en AS meta_key, meta_descr_en AS meta_descr, art_en AS text FROM medvilla_articulos WHERE slug_en = 'spanish-properties'
2019-12-06T00:04:29+00:00sql4864 Kb SELECT id, clave, titulo_en AS title, link_en AS link, slug_en AS slug, art_en AS text FROM medvilla_articulos WHERE parent_id = 2 ORDER BY orden
2019-12-06T00:04:29+00:00sql4864 KbSELECT file_name FROM medvilla_images_articulos WHERE parent_id = 2 ORDER BY orden
2019-12-06T00:04:29+00:00sql4864 KbSELECT file_name FROM medvilla_files_articulos WHERE parent_id = 2 ORDER BY orden
2019-12-06T00:04:29+00:00sql4864 Kb SELECT id, clave, link_en AS link, titulo_en AS titulo, slug_en AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos ORDER BY orden
2019-12-06T00:04:29+00:00sql4864 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'viviendas'
2019-12-06T00:04:29+00:00sql4864 Kb SELECT id, clave, link_en AS link, titulo_en AS titulo, slug_en AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos ORDER BY orden
2019-12-06T00:04:29+00:00sql4864 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'viviendas'
2019-12-06T00:04:29+00:00sql4864 KbSELECT *, titulo_en AS titulo, link_en AS link FROM medvilla_panoramicas ORDER BY orden
2019-12-06T00:04:29+00:00sql4864 KbSELECT nombre_en AS nombre, enlace_en AS enlace FROM medvilla_quicklinks2 ORDER BY orden
2019-12-06T00:04:29+00:00sql4864 Kb SELECT id, clave, link_en AS link, titulo_en AS titulo, slug_en AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos ORDER BY orden
2019-12-06T00:04:29+00:00sql4864 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'viviendas'
2019-12-06T00:04:29+00:00sql4864 Kb SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda, sup_parcela, sup_terrazas, precio_de_venta, precio_anterior, precio_desde, precio_consultar, fecha_creado, oferta, descripcion_en AS descripcion, intro_en as intro, piscina_id AS piscina, lat, lon, reservado, vendido, main.titulo_en AS titulo, loc.nombre AS localidad, tip.nombre_en AS tipo, cla.id AS clase_id, cla.nombre_en AS clase, cos.nombre_en AS costa , (SELECT img.file_name as file_name FROM medvilla_images_viviendas img WHERE img.parent_id = main.id ORDER BY img.orden ASC LIMIT 1) AS file_name FROM medvilla_viviendas main LEFT JOIN medvilla_localidades loc ON main.localidad_id = loc.id LEFT JOIN medvilla_tipos tip ON main.tipo_id = tip.id LEFT JOIN medvilla_clases cla ON main.clase_id = cla.id LEFT JOIN medvilla_costas cos ON main.costa_id = cos.id WHERE 1 = 1 ORDER BY main.id DESC
2019-12-06T00:04:30+00:00sql14592 Kb SELECT id, clave, link_en AS link, titulo_en AS titulo, slug_en AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos ORDER BY orden
2019-12-06T00:04:30+00:00sql14592 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'viviendas'
2019-12-06T00:04:30+00:00sql14592 Kb SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda, sup_parcela, sup_terrazas, precio_de_venta, precio_anterior, precio_desde, precio_consultar, fecha_creado, oferta, descripcion_en AS descripcion, intro_en as intro, piscina_id AS piscina, lat, lon, reservado, vendido, main.titulo_en AS titulo, loc.nombre AS localidad, tip.nombre_en AS tipo, cla.id AS clase_id, cla.nombre_en AS clase, cos.nombre_en AS costa , (SELECT img.file_name as file_name FROM medvilla_images_viviendas img WHERE img.parent_id = main.id ORDER BY img.orden ASC LIMIT 1) AS file_name FROM medvilla_viviendas main LEFT JOIN medvilla_localidades loc ON main.localidad_id = loc.id LEFT JOIN medvilla_tipos tip ON main.tipo_id = tip.id LEFT JOIN medvilla_clases cla ON main.clase_id = cla.id LEFT JOIN medvilla_costas cos ON main.costa_id = cos.id WHERE 1 = 1 AND (visible = 1) AND (precio_de_venta <= 250000) AND (localidad_id = 58) AND ( clase_id = 1 OR clase_id = 2) ORDER BY RAND()
2019-12-06T00:04:30+00:00sql14592 Kb SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda, sup_parcela, sup_terrazas, precio_de_venta, precio_anterior, precio_desde, precio_consultar, fecha_creado, oferta, descripcion_en AS descripcion, intro_en as intro, piscina_id AS piscina, lat, lon, reservado, vendido, main.titulo_en AS titulo, loc.nombre AS localidad, tip.nombre_en AS tipo, cla.id AS clase_id, cla.nombre_en AS clase, cos.nombre_en AS costa , (SELECT img.file_name as file_name FROM medvilla_images_viviendas img WHERE img.parent_id = main.id ORDER BY img.orden ASC LIMIT 1) AS file_name FROM medvilla_viviendas main LEFT JOIN medvilla_localidades loc ON main.localidad_id = loc.id LEFT JOIN medvilla_tipos tip ON main.tipo_id = tip.id LEFT JOIN medvilla_clases cla ON main.clase_id = cla.id LEFT JOIN medvilla_costas cos ON main.costa_id = cos.id WHERE 1 = 1 AND (visible = 1) AND (precio_de_venta <= 250000) AND (localidad_id = 58) AND ( clase_id = 1 OR clase_id = 2) ORDER BY RAND() LIMIT 0, 10
2019-12-06T00:04:30+00:00sql14592 Kb SELECT cos.nombre_en AS costa, loc.nombre AS localidad, loc.id AS localidad_id, loc.costa_id FROM medvilla_localidades loc LEFT JOIN medvilla_costas cos ON loc.costa_id = cos.id WHERE loc.id IN (SELECT DISTINCT localidad_id FROM medvilla_viviendas WHERE visible = 1) ORDER BY loc.costa_id, loc.nombre
2019-12-06T00:04:30+00:00sql14592 KbSELECT file_name FROM medvilla_files_articulos WHERE parent_id = 2 ORDER BY orden
2019-12-06T00:04:30+00:00sql14592 KbSELECT titulo_en AS field FROM medvilla_articulos WHERE clave = 'ebook-modal'
2019-12-06T00:04:30+00:00sql14592 KbSELECT art_en AS field FROM medvilla_articulos WHERE clave = 'ebook-modal'
2019-12-06T00:04:30+00:00sql14592 Kb SELECT file_name, art.id AS aid FROM medvilla_images_articulos img JOIN medvilla_articulos art ON img.parent_id = art.id WHERE art.clave = 'ebook-modal'