SELECT *, clave FROM immospanje_traducciones

SELECT clave, valor FROM immospanje_config

	SELECT id, clave, parent_id,
					titulo_nl AS titulo,
					link_nl AS link,
					slug_nl AS slug,
					meta_key_nl AS meta_key,
					meta_descr_nl AS meta_descr,
					art_nl AS text
					FROM immospanje_articulos 
					 WHERE slug_nl = 'huis-kopen-in-spanje' 
					

	SELECT id, clave, 
					titulo_nl AS title,
					link_nl AS link,
					slug_nl AS slug,
					art_nl AS text
					FROM immospanje_articulos
					WHERE parent_id = 10
					ORDER BY orden
					

SELECT file_name FROM immospanje_images_articulos WHERE parent_id = 10 ORDER BY orden

SELECT file_name FROM immospanje_files_articulos WHERE parent_id = 10 ORDER BY orden

 	SELECT *, id, clave, link_nl AS link,  titulo_nl AS titulo,
					slug_nl 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 = 'localidades'

 	SELECT *, id, clave, link_nl AS link,  titulo_nl AS titulo,
					slug_nl 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 = 'localidades'

SELECT *, titulo_nl AS titulo, link_nl AS link FROM immospanje_panoramicas ORDER BY orden

	SELECT loc.*, loc.corto_nl AS corto, 
					loc.descripcion_nl AS descripcion,
					cos.nombre_nl AS costa
					FROM immospanje_localidades loc
					LEFT OUTER JOIN immospanje_costas cos
						ON loc.costa_id = cos.id
					WHERE loc.id = '1'

	SELECT parent_id, file_name 
					FROM immospanje_images_localidades 
					WHERE parent_id = 1 
					ORDER BY orden

SELECT id FROM immospanje_articulos WHERE clave = 'localidades'

SELECT file_name FROM immospanje_images_articulos WHERE parent_id = 10 ORDER BY orden

 	SELECT *, id, clave, link_nl AS link,  titulo_nl AS titulo,
					slug_nl 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 = 'localidades'

                    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_nl AS descripcion, agente,
                    piscina_id AS piscina,
                    main.lat, main.lon, reservado, vendido,
                    main.titulo_nl AS titulo, loc.nombre AS localidad,
                    tip.nombre_nl AS tipo, cla.id AS clase_id,
                    cla.nombre_nl AS clase,
                    cos.nombre_nl 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 (visible = 1) AND (main.localidad_id = 1) ORDER BY score DESC

                    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_nl AS descripcion, agente,
                    piscina_id AS piscina,
                    main.lat, main.lon, reservado, vendido,
                    main.titulo_nl AS titulo, loc.nombre AS localidad,
                    tip.nombre_nl AS tipo, cla.id AS clase_id,
                    cla.nombre_nl AS clase,
                    cos.nombre_nl 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 (visible = 1) AND (main.localidad_id = 1) ORDER BY score DESC LIMIT 0, 15 

SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl 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 = 9

                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 13916
                    ORDER BY orden
                     LIMIT 3 
                    

SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl 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 = 8

                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 16233
                    ORDER BY orden
                     LIMIT 3 
                    

SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl 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 = 20

                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 20957
                    ORDER BY orden
                     LIMIT 3 
                    

SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl 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 = 1

                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 18359
                    ORDER BY orden
                     LIMIT 3 
                    

SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl 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 = 1

                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 18118
                    ORDER BY orden
                     LIMIT 3 
                    

SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl 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 = 20

                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 20680
                    ORDER BY orden
                     LIMIT 3 
                    

SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl 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 = 20

                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 21016
                    ORDER BY orden
                     LIMIT 3 
                    

SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl 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 = 9

                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 14065
                    ORDER BY orden
                     LIMIT 3 
                    

SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl 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 = 20

                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 21030
                    ORDER BY orden
                     LIMIT 3 
                    

SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl 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 = 20

                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 20661
                    ORDER BY orden
                     LIMIT 3 
                    

SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl 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 = 5

                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 1569
                    ORDER BY orden
                     LIMIT 3 
                    

SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl 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 = 20

                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 21253
                    ORDER BY orden
                     LIMIT 3 
                    

SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl 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 = 9

                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 14088
                    ORDER BY orden
                     LIMIT 3 
                    

SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl 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 = 8

                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 18590
                    ORDER BY orden
                     LIMIT 3 
                    

SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl 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 = 20

                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 20553
                    ORDER BY orden
                     LIMIT 3 
                    

	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 = 'localidades'

SELECT slug_nl AS field FROM immospanje_articulos WHERE clave = 'viviendas'

                    SELECT id, nombre_nl AS nombre 
                    FROM immospanje_clases  c
                    WHERE c.id IN (SELECT DISTINCT clase_id FROM immospanje_viviendas WHERE visible = 1)
                    ORDER BY nombre

                    SELECT id, nombre_nl AS nombre 
                    FROM immospanje_tipos  c
                    WHERE c.id IN (SELECT DISTINCT tipo_id FROM immospanje_viviendas WHERE visible = 1)
                    ORDER BY nombre

                    SELECT id, nombre AS nombre 
                    FROM immospanje_localidades  c
                    WHERE c.id IN (SELECT DISTINCT localidad_id FROM immospanje_viviendas WHERE visible = 1)
                    ORDER BY nombre

SELECT titulo_nl AS field FROM immospanje_articulos WHERE clave = 'newsletter'

SELECT art_nl AS field FROM immospanje_articulos WHERE clave = 'newsletter'