Appartement dans Marbella, Costa del Sol, Espagne

SELECT *, clave FROM immospanje_traducciones

SELECT clave, valor FROM immospanje_config

	SELECT id, clave, parent_id,
					titulo_fr AS titulo,
					link_fr AS link,
					slug_fr AS slug,
					meta_key_fr AS meta_key,
					meta_descr_fr AS meta_descr,
					art_fr AS text
					FROM immospanje_articulos 
					 WHERE slug_fr = 'maisons' 
					

	SELECT id, clave, 
					titulo_fr AS title,
					link_fr AS link,
					slug_fr AS slug,
					art_fr 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_fr AS link,  titulo_fr AS titulo,
					slug_fr 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_fr AS link,  titulo_fr AS titulo,
					slug_fr 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_fr AS titulo, link_fr AS link FROM immospanje_panoramicas ORDER BY orden

	SELECT main.*, titulo_fr AS titulo,
					main.descripcion_fr AS descripcion,
					loc.nombre as localidad, 
					-- loc.descr_fr AS descripcion_localidad,
					loc.costa_id,
					cla.nombre_fr as clase,
					tip.nombre_fr as tipo, 
					cos.nombre_fr as costa,
					zon.nombre as zona,
					pis.nombre_fr as piscina,
					jar.nombre_fr as jardin,
					ori.nombre_fr as orientacion,
					par.nombre_fr as parking,
					vis.nombre_fr 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 = 165571

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

SELECT id, nombre_fr as nombre FROM immospanje_opciones ORDER BY orden

SELECT main.*, main.descripcion_fr AS descripcion, 
                cos.nombre_fr AS costa,
                pais.nombre_fr 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_fr AS link,  titulo_fr AS titulo,
					slug_fr 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_fr AS descripcion, agente,
                    piscina_id AS piscina,
                    main.lat, main.lon, reservado, vendido,
                    main.titulo_fr AS titulo, loc.nombre AS localidad,
                    tip.nombre_fr AS tipo, cla.id AS clase_id,
                    cla.nombre_fr AS clase,
                    cos.nombre_fr 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 >= 632000) AND (precio_de_venta <= 948000) AND (main.id != 165571) ORDER BY main.score DESC LIMIT 3

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

SELECT art_fr 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_fr AS nombre FROM immospanje_costas WHERE id = 8

SELECT nombre_fr AS nombre FROM immospanje_tipos WHERE id = 1

SELECT nombre_nl AS nombre FROM immospanje_costas WHERE id = 8

SELECT nombre_nl AS nombre FROM immospanje_tipos WHERE id = 1

SELECT nombre_fr AS nombre FROM immospanje_costas WHERE id = 8

SELECT nombre_fr AS nombre FROM immospanje_tipos WHERE id = 1

SELECT nombre_en AS nombre FROM immospanje_costas WHERE id = 8

SELECT nombre_en AS nombre FROM immospanje_tipos WHERE id = 1

SELECT nombre_nl AS nombre FROM immospanje_costas WHERE id = 8

SELECT nombre_nl AS nombre FROM immospanje_tipos WHERE id = 1

SELECT nombre_en AS nombre FROM immospanje_costas WHERE id = 8

SELECT nombre_en AS nombre FROM immospanje_tipos WHERE id = 1