Our philosophy

SELECT *, clave FROM lexington_traducciones

SELECT clave, valor FROM lexington_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 lexington_articulos 
					 WHERE slug_en = 'about-us' 
					

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

SELECT file_name FROM lexington_images_articulos WHERE parent_id = 24 ORDER BY orden

SELECT file_name FROM lexington_files_articulos WHERE parent_id = 24 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 lexington_articulos
					ORDER BY orden
					

SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'info_empresa'

SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'info_empresa'

SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'info_empresa'

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

	SELECT file_name, art.id AS aid
					FROM lexington_images_articulos img
					JOIN lexington_articulos art
						ON img.parent_id = art.id
					WHERE art.clave = 'info_empresa'

SELECT id, banner FROM lexington_articulos WHERE id = 3

SELECT id FROM lexington_articulos WHERE clave = 'inicio'

SELECT banner AS field FROM lexington_articulos WHERE clave = 'inicio'

SELECT titulo_en AS field FROM lexington_articulos WHERE clave = 'higher-moral'

SELECT art_en AS field FROM lexington_articulos WHERE clave = 'higher-moral'

	SELECT file_name, art.id AS aid
					FROM lexington_images_articulos img
					JOIN lexington_articulos art
						ON img.parent_id = art.id
					WHERE art.clave = 'higher-moral'

SELECT titulo_en AS field FROM lexington_articulos WHERE clave = 'passion'

SELECT art_en AS field FROM lexington_articulos WHERE clave = 'passion'

	SELECT file_name, art.id AS aid
					FROM lexington_images_articulos img
					JOIN lexington_articulos art
						ON img.parent_id = art.id
					WHERE art.clave = 'passion'

SELECT titulo_en AS field FROM lexington_articulos WHERE clave = 'clients-deal'

SELECT art_en AS field FROM lexington_articulos WHERE clave = 'clients-deal'

SELECT titulo_en AS field FROM lexington_articulos WHERE clave = 'financial-partners'

SELECT art_en AS field FROM lexington_articulos WHERE clave = 'financial-partners'

	SELECT file_name, art.id AS aid
					FROM lexington_images_articulos img
					JOIN lexington_articulos art
						ON img.parent_id = art.id
					WHERE art.clave = 'financial-partners'

SELECT slug_en AS field FROM lexington_articulos WHERE clave = 'contacto'