Main title on panoramic photo

SELECT *, clave FROM books_traducciones

SELECT clave, valor FROM books_config

	SELECT id, clave, parent_id, privado, formulario,
					titulo_en AS titulo, banner,
					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 books_articulos 
					WHERE clave = 'inicio'
					

	SELECT id, clave, 
					titulo_en AS title,
					link_en AS link,
					slug_en AS slug,
					art_en AS text,
					meta_descr_en AS meta,
					(SELECT img.file_name as file_name
        FROM books_images_articulos img
        WHERE img.parent_id = main.id
        ORDER BY img.orden ASC
        LIMIT 1) AS file_name 
					FROM books_articulos main
					WHERE parent_id = 1
					ORDER BY orden
					

SELECT file_name FROM books_images_articulos WHERE parent_id = 1 ORDER BY orden

SELECT * FROM books_files_articulos WHERE parent_id = 1 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 books_articulos
					ORDER BY orden
					

SELECT slug_en FROM books_articulos WHERE clave = 'inicio'

SELECT slug_en FROM books_articulos WHERE clave = 'inicio'

SELECT slug_en FROM books_articulos WHERE clave = 'inicio'

					SELECT main.id AS main_id, referencia, dormitorios, banos, 
					sup_vivienda, sup_parcela, piscina_id,
					precio_de_venta, main.fecha_creado, precio_desde,
					descripcion_en AS descripcion,
					piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones,
					 
					
					lat, lon, reservado, vendido, reducido,
					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,
					opciones_json,
					
						(SELECT img.file_name as file_name
						FROM books_images_viviendas img
						WHERE img.parent_id = main.id
						ORDER BY img.orden ASC, img.id ASC
						LIMIT 1) AS file_name
					FROM books_viviendas main
					LEFT JOIN books_localidades loc ON main.localidad_id = loc.id
					LEFT JOIN books_zonas zon ON main.zona_id = zon.id
					LEFT JOIN books_tipos tip ON main.tipo_id = tip.id
					LEFT JOIN books_clases cla ON main.clase_id = cla.id
					LEFT JOIN books_costas cos ON loc.costa_id = cos.id
					WHERE 1 = 1
		 AND (visible = 1) AND (destacado = 1) ORDER BY main.id DESC LIMIT 6

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

	SELECT file_name, art.id AS aid
					FROM books_images_articulos img
					JOIN books_articulos art
						ON img.parent_id = art.id
					WHERE art.clave = 'inicio'

	SELECT file_name, art.id AS aid
					FROM books_images_articulos img
					JOIN books_articulos art
						ON img.parent_id = art.id
					WHERE art.clave = 'inicio'

UPDATE books_traducciones SET used = 1 WHERE clave = 'slogan' AND used != 2

SELECT art_en AS field FROM books_articulos WHERE clave = 'newsletter'

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

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

UPDATE books_traducciones SET used = 1 WHERE clave = 'sitemap' AND used != 2

UPDATE books_traducciones SET used = 1 WHERE clave = 'siguenos_online' AND used != 2

UPDATE books_traducciones SET used = 1 WHERE clave = 'todos_derechos' AND used != 2