Detached Villa in Benalmádena, , Spain

SELECT *, clave FROM immospanje_traducciones

SELECT clave, valor FROM immospanje_config

	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 immospanje_articulos 
					 WHERE slug_en = 'properties' 
					

	SELECT id, clave, 
					titulo_en AS title,
					link_en AS link,
					slug_en AS slug,
					art_en AS text
					FROM immospanje_articulos
					WHERE parent_id = 2
					ORDER BY orden
					

SELECT file_name FROM immospanje_images_articulos WHERE parent_id = 2 ORDER BY orden

SELECT file_name FROM immospanje_files_articulos WHERE parent_id = 2 ORDER BY orden

 	SELECT *, id, clave, link_en AS link,  titulo_en AS titulo,
					slug_en AS slug, header_menu, footer_menu, parent_id, orden
					FROM immospanje_articulos
					ORDER BY orden
					

SELECT slug_nl, slug_fr, slug_en FROM immospanje_articulos WHERE clave = 'viviendas'

 	SELECT *, id, clave, link_en AS link,  titulo_en AS titulo,
					slug_en AS slug, header_menu, footer_menu, parent_id, orden
					FROM immospanje_articulos
					ORDER BY orden
					

SELECT slug_nl, slug_fr, slug_en FROM immospanje_articulos WHERE clave = 'viviendas'

SELECT *, titulo_en AS titulo, link_en AS link FROM immospanje_panoramicas ORDER BY orden

	SELECT main.*, titulo_en AS titulo,
					main.descripcion_en AS descripcion,
					loc.nombre as localidad, 
					-- loc.descr_en AS descripcion_localidad,
					loc.costa_id,
					cla.nombre_en as clase,
					tip.nombre_en as tipo, 
					cos.nombre_en as costa,
					zon.nombre as zona,
					pis.nombre_en as piscina,
					jar.nombre_en as jardin,
					ori.nombre_en as orientacion,
					par.nombre_en as parking,
					vis.nombre_en as vistas
					FROM immospanje_viviendas main
					LEFT JOIN immospanje_localidades loc
						ON main.localidad_id = loc.id
					LEFT JOIN immospanje_costas cos
						ON loc.costa_id = cos.id
					LEFT JOIN immospanje_clases cla
						ON main.clase_id = cla.id
					LEFT JOIN immospanje_zonas zon
						ON main.zona_id = zon.id
					LEFT JOIN immospanje_tipos tip
						ON main.tipo_id = tip.id
					LEFT JOIN immospanje_piscinas pis
						ON main.piscina_id = pis.id
					LEFT JOIN immospanje_jardines jar
						ON main.jardin_id = jar.id
					LEFT JOIN immospanje_orientaciones ori
						ON main.orientacion_id = ori.id
					LEFT JOIN immospanje_parkings par
						ON main.parking_id = par.id
					LEFT JOIN immospanje_vistas vis
						ON main.vista_id = vis.id
						
					WHERE main.id = 165755

SELECT parent_id, file_name FROM immospanje_images_viviendas WHERE parent_id = 165755 ORDER BY orden

SELECT id, nombre_en as nombre FROM immospanje_opciones ORDER BY orden

SELECT main.*, main.descripcion_en AS descripcion, 
                cos.nombre_en AS costa,
                pais.nombre_en AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 3

 	SELECT *, id, clave, link_en AS link,  titulo_en AS titulo,
					slug_en AS slug, header_menu, footer_menu, parent_id, orden
					FROM immospanje_articulos
					ORDER BY orden
					

SELECT slug_nl, slug_fr, slug_en FROM immospanje_articulos WHERE clave = 'viviendas'

                    SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda,
                    sup_parcela, precio_de_venta, precio_anterior, precio_desde, main.fecha_creado AS fecha_creado,
                    main.descripcion_en AS descripcion, agente,
                    piscina_id AS piscina,
                    main.lat, main.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,
                    age.nombre_comercial AS agente_nombre, age.telefono AS agente_telefono, age.email AS agente_email,
                    age.logo AS agente_logo,
                    
                        (SELECT img.file_name as file_name
                        FROM immospanje_images_viviendas img
                        WHERE img.parent_id = main.id
                        ORDER BY img.orden ASC
                        LIMIT 1) AS file_name
                    FROM immospanje_viviendas main
                    LEFT JOIN immospanje_localidades loc ON main.localidad_id = loc.id
                    LEFT JOIN immospanje_tipos tip ON main.tipo_id = tip.id
                    LEFT JOIN immospanje_clases cla ON main.clase_id = cla.id
                    LEFT JOIN immospanje_costas cos ON loc.costa_id = cos.id
                    LEFT JOIN immospanje_agentes age ON main.agente_id = age.id
                    WHERE 1 = 1
         AND (precio_de_venta >= 2560000) AND (precio_de_venta <= 3840000) AND (main.id != 165755) ORDER BY main.score DESC LIMIT 3

SELECT meta_descr_en AS field FROM immospanje_articulos WHERE clave = 'inicio'

SELECT art_en AS field FROM immospanje_articulos WHERE clave = 'inicio'

	SELECT file_name, art.id AS aid
					FROM immospanje_images_articulos img
					JOIN immospanje_articulos art
						ON img.parent_id = art.id
					WHERE art.clave = 'viviendas'

SELECT nombre_en AS nombre FROM immospanje_costas WHERE id = 0

SELECT nombre_en AS nombre FROM immospanje_tipos WHERE id = 5

SELECT nombre_nl AS nombre FROM immospanje_costas WHERE id = 0

SELECT nombre_nl AS nombre FROM immospanje_tipos WHERE id = 5

SELECT nombre_fr AS nombre FROM immospanje_costas WHERE id = 0

SELECT nombre_fr AS nombre FROM immospanje_tipos WHERE id = 5

SELECT nombre_en AS nombre FROM immospanje_costas WHERE id = 0

SELECT nombre_en AS nombre FROM immospanje_tipos WHERE id = 5

SELECT nombre_nl AS nombre FROM immospanje_costas WHERE id = 0

SELECT nombre_nl AS nombre FROM immospanje_tipos WHERE id = 5

SELECT nombre_fr AS nombre FROM immospanje_costas WHERE id = 0

SELECT nombre_fr AS nombre FROM immospanje_tipos WHERE id = 5