Lägenhet i Finestrat - Återförsäljning

SELECT *, clave FROM penthouses_traducciones

SELECT clave, valor FROM penthouses_config

	SELECT id, clave, parent_id, privado, formulario,
					titulo_sv AS titulo, banner,
					link_sv AS link,
					slug_sv AS slug,
					meta_key_sv AS meta_key,
					meta_descr_sv AS meta_descr,
					art_sv AS text
					FROM penthouses_articulos 
					 WHERE slug_sv = 'fastigheter' 
					

	SELECT id, clave, 
					titulo_sv AS title,
					link_sv AS link,
					slug_sv AS slug,
					art_sv AS text,
					meta_descr_sv AS meta,
					(SELECT img.file_name as file_name
        FROM penthouses_images_articulos img
        WHERE img.parent_id = main.id
        ORDER BY img.orden ASC
        LIMIT 1) AS file_name 
					FROM penthouses_articulos main
					WHERE parent_id = 2
					ORDER BY orden
					

SELECT file_name FROM penthouses_images_articulos WHERE parent_id = 2 ORDER BY orden

SELECT * FROM penthouses_files_articulos WHERE parent_id = 2 ORDER BY orden

 	SELECT *, id, clave, link_sv AS link,  titulo_sv AS titulo,
					slug_sv AS slug, header_menu, footer_menu, parent_id, orden
					FROM penthouses_articulos
					ORDER BY orden
					

SELECT slug_en, slug_dk, slug_no, slug_sv, slug_ic, slug_de FROM penthouses_articulos WHERE clave = 'viviendas'

SELECT slug_en, slug_dk, slug_no, slug_sv, slug_ic, slug_de FROM penthouses_articulos WHERE clave = 'viviendas'

	SELECT main.id AS main_id, main.*, titulo_sv AS titulo,
					main.descripcion_sv AS descripcion,
					loc.nombre as localidad, cos.provincia, main.fecha_creado,
					loc.costa_id,
					zon.nombre as zona,
					loc.codigo_postal AS codigo_postal,
					cla.nombre_sv as clase,
					tip.nombre_sv as tipo,
					cos.nombre_sv as costa,
					pis.nombre_sv as piscina,
					jar.nombre_sv as jardin,
					ori.nombre_sv as orientacion,
					par.nombre_sv as parking,
					vis.nombre_sv as vistas
					FROM penthouses_viviendas main
					LEFT JOIN penthouses_localidades loc
						ON main.localidad_id = loc.id
					LEFT JOIN penthouses_zonas zon
						ON main.zona_id = zon.id
					LEFT OUTER JOIN penthouses_costas cos
						ON loc.costa_id = cos.id
					LEFT JOIN penthouses_clases cla
						ON main.clase_id = cla.id
					LEFT JOIN penthouses_tipos tip
						ON main.tipo_id = tip.id
					LEFT JOIN penthouses_piscinas pis
						ON main.piscina_id = pis.id
					LEFT JOIN penthouses_jardines jar
						ON main.jardin_id = jar.id
					LEFT JOIN penthouses_orientaciones ori
						ON main.orientacion_id = ori.id
					LEFT JOIN penthouses_parkings par
						ON main.parking_id = par.id
					LEFT JOIN penthouses_vistas vis
						ON main.vista_id = vis.id

					WHERE main.id = 2687

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'in' AND used != 2

SELECT nombre, descripcion_sv AS descripcion FROM penthouses_localidades WHERE id = 29

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'precio' AND used != 2

SELECT parent_id, file_name FROM penthouses_images_viviendas WHERE parent_id = 2687 ORDER BY orden

SELECT parent_id, file_name FROM penthouses_files_viviendas WHERE parent_id = 2687 ORDER BY orden

SELECT id, nombre_sv as nombre FROM penthouses_opciones ORDER BY orden

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'pendiente' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'nuevo' AND used != 2

SELECT slug_en, slug_dk, slug_no, slug_sv, slug_ic, slug_de FROM penthouses_articulos WHERE clave = 'viviendas'

					SELECT main.id AS main_id, referencia, dormitorios, banos, 
					sup_vivienda, sup_parcela, piscina_id,
					precio_de_venta, main.fecha_creado, precio_desde,
					descripcion_sv AS descripcion,
					piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones,
					 
					
					lat, lon, reservado, vendido, reducido,
					main.titulo_sv AS titulo, 
					loc.nombre AS localidad,
					tip.nombre_sv AS tipo, 
					cla.id AS clase_id, cla.nombre_sv AS clase,
					cos.nombre_sv AS costa,
					opciones_json,
					
						(SELECT img.file_name as file_name
						FROM penthouses_images_viviendas img
						WHERE img.parent_id = main.id
						ORDER BY img.orden ASC, img.id ASC
						LIMIT 1) AS file_name
					FROM penthouses_viviendas main
					LEFT JOIN penthouses_localidades loc ON main.localidad_id = loc.id
					LEFT JOIN penthouses_zonas zon ON main.zona_id = zon.id
					LEFT JOIN penthouses_tipos tip ON main.tipo_id = tip.id
					LEFT JOIN penthouses_clases cla ON main.clase_id = cla.id
					LEFT JOIN penthouses_costas cos ON loc.costa_id = cos.id
					WHERE 1 = 1
		 AND (precio_de_venta >= 295200) AND (precio_de_venta <= 442800) AND (main.id != 2687) AND (visible = 1) ORDER BY RAND() LIMIT 3

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'in' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'in' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'in' AND used != 2

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

SELECT nombre_sv AS nombre FROM penthouses_costas WHERE id = 1

SELECT nombre_sv AS nombre FROM penthouses_tipos WHERE id = 1

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'in' AND used != 2

SELECT nombre_en AS nombre FROM penthouses_costas WHERE id = 1

SELECT nombre_en AS nombre FROM penthouses_tipos WHERE id = 1

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'in' AND used != 2

SELECT nombre_dk AS nombre FROM penthouses_costas WHERE id = 1

SELECT nombre_dk AS nombre FROM penthouses_tipos WHERE id = 1

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'in' AND used != 2

SELECT nombre_no AS nombre FROM penthouses_costas WHERE id = 1

SELECT nombre_no AS nombre FROM penthouses_tipos WHERE id = 1

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'in' AND used != 2

SELECT nombre_sv AS nombre FROM penthouses_costas WHERE id = 1

SELECT nombre_sv AS nombre FROM penthouses_tipos WHERE id = 1

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'in' AND used != 2

SELECT nombre_ic AS nombre FROM penthouses_costas WHERE id = 1

SELECT nombre_ic AS nombre FROM penthouses_tipos WHERE id = 1

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'in' AND used != 2

SELECT nombre_de AS nombre FROM penthouses_costas WHERE id = 1

SELECT nombre_de AS nombre FROM penthouses_tipos WHERE id = 1

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'in' AND used != 2

SELECT nombre_en AS nombre FROM penthouses_costas WHERE id = 1

SELECT nombre_en AS nombre FROM penthouses_tipos WHERE id = 1

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'in' AND used != 2

SELECT nombre_dk AS nombre FROM penthouses_costas WHERE id = 1

SELECT nombre_dk AS nombre FROM penthouses_tipos WHERE id = 1

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'in' AND used != 2

SELECT nombre_no AS nombre FROM penthouses_costas WHERE id = 1

SELECT nombre_no AS nombre FROM penthouses_tipos WHERE id = 1

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'in' AND used != 2

SELECT nombre_ic AS nombre FROM penthouses_costas WHERE id = 1

SELECT nombre_ic AS nombre FROM penthouses_tipos WHERE id = 1

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'in' AND used != 2

SELECT nombre_de AS nombre FROM penthouses_costas WHERE id = 1

SELECT nombre_de AS nombre FROM penthouses_tipos WHERE id = 1

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'in' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'volver' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'descargar_pdf' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'descargar_pdf' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'compartir' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'compartir' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'video' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'fotos' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'referencia' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'dormitorios' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'banos' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'vivienda' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'certificado_energia' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'especificaciones' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'piscina' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'superficies' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'sup_vivienda' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'solicitar_mas_info_sobre_esta_propiedad' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'nombre' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'email' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'telefono' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'mensaje' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'acepto_privacidad' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'enviar' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'localizacion_vivienda' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'viviendas_similares' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'precio' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'precio' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'precio' AND used != 2

UPDATE penthouses_traducciones SET used = 1 WHERE clave = 'derechos_reservados' AND used != 2