Golden Visa

SELECT *, clave FROM lexington_traducciones

SELECT clave, valor FROM lexington_config

	SELECT id, clave, parent_id, privado, formulario,
					titulo_nl AS titulo, banner,
					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 lexington_articulos 
					 WHERE slug_nl = 'golden-visa-i-spanje' 
					

	SELECT id, clave, 
					titulo_nl AS title,
					link_nl AS link,
					slug_nl AS slug,
					art_nl AS text,
					meta_descr_nl 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 = 22
					ORDER BY orden
					

SELECT file_name FROM lexington_images_articulos WHERE parent_id = 22 ORDER BY orden

SELECT file_name FROM lexington_files_articulos WHERE parent_id = 22 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 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 = 'visa-oro'

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

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

	SELECT id, clave, 
					titulo_nl AS title,
					link_nl AS link,
					slug_nl AS slug,
					art_nl AS text,
					meta_descr_nl 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 = 22
					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 = 'visa-oro'

SELECT id FROM lexington_articulos WHERE clave = 'visa-oro'

SELECT banner AS field FROM lexington_articulos WHERE clave = 'visa-oro'

SELECT titulo_nl AS field FROM lexington_articulos WHERE clave = 'investment'

SELECT art_nl AS field FROM lexington_articulos WHERE clave = 'investment'

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

SELECT titulo_nl AS field FROM lexington_articulos WHERE clave = 'resident'

SELECT art_nl AS field FROM lexington_articulos WHERE clave = 'resident'

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

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