Downloads

SELECT *, clave FROM droom_traducciones

SELECT clave, valor FROM droom_config

	SELECT id, clave, parent_id, privado, formulario,
					titulo_en AS titulo, banner,
					link_en AS link,
					slug_en AS slug,
					video,
					meta_key_en AS meta_key,
					meta_descr_en AS meta_descr,
					art_en AS text
					FROM droom_articulos 
					 WHERE slug_en = 'downloads' 
					

	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 droom_images_articulos img
        WHERE img.parent_id = main.id
        ORDER BY img.orden ASC
        LIMIT 1) AS file_name 
					FROM droom_articulos main
					WHERE parent_id = 32
					ORDER BY orden
					

SELECT file_name FROM droom_images_articulos WHERE parent_id = 32 ORDER BY orden

SELECT * FROM droom_files_articulos WHERE parent_id = 32 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 droom_articulos
					ORDER BY orden
					

SELECT slug_es, slug_en, slug_nl FROM droom_articulos WHERE clave = 'descargas'

SELECT slug_es, slug_en, slug_nl FROM droom_articulos WHERE clave = 'descargas'

        SELECT equ.*, car.nombre_en AS cargo,
        equ.id AS main_id,
        equ.idioma_id AS idiomas
        
        , (SELECT img.file_name as file_name
        FROM droom_images_equipo img
        WHERE img.parent_id = equ.id
        ORDER BY img.orden ASC, img.id ASC
        LIMIT 1) AS file_name 
        FROM droom_equipo equ
        LEFT OUTER JOIN droom_cargos car
            ON equ.cargo_id = car.id
        

	SELECT file_name, art.id AS aid
					FROM droom_images_articulos img
					JOIN droom_articulos art
						ON img.parent_id = art.id
					WHERE art.clave = 'descargas'

UPDATE droom_traducciones SET used = 1 WHERE clave = 'espana' AND used != 2

UPDATE droom_traducciones SET used = 1 WHERE clave = 'descarga' AND used != 2

UPDATE droom_traducciones SET used = 1 WHERE clave = 'descarga_revista' AND used != 2

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

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

SELECT art_en AS art_sin FROM droom_traducciones WHERE clave = 'politica_privacidad'

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

UPDATE droom_traducciones SET used = 1 WHERE clave = 'empresa' AND used != 2

SELECT art_en AS art_sin FROM droom_traducciones WHERE clave = 'empresa'

UPDATE droom_traducciones SET used = 1 WHERE clave = 'contactenos' AND used != 2

UPDATE droom_traducciones SET used = 1 WHERE clave = 'espana' AND used != 2

UPDATE droom_traducciones SET used = 1 WHERE clave = 'horario' AND used != 2

UPDATE droom_traducciones SET used = 1 WHERE clave = 'lunes' AND used != 2

UPDATE droom_traducciones SET used = 1 WHERE clave = 'viernes' AND used != 2

SELECT art_en AS art_sin FROM droom_traducciones WHERE clave = 'horario'

UPDATE droom_traducciones SET used = 1 WHERE clave = 'nuestro_equipo' AND used != 2