Sälj din fastighet utan kompromiss

SELECT *, clave FROM lexington_traducciones

SELECT clave, valor FROM lexington_config

	SELECT id, clave, parent_id, privado, formulario,
					titulo_se AS titulo, banner,
					link_se AS link,
					slug_se AS slug,
					meta_key_se AS meta_key,
					meta_descr_se AS meta_descr,
					art_se AS text
					FROM lexington_articulos 
					 WHERE slug_se = 'salja' 
					

	SELECT id, clave, 
					titulo_se AS title,
					link_se AS link,
					slug_se AS slug,
					art_se AS text,
					meta_descr_se 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 = 13
					ORDER BY orden
					

SELECT file_name FROM lexington_images_articulos WHERE parent_id = 13 ORDER BY orden

SELECT file_name FROM lexington_files_articulos WHERE parent_id = 13 ORDER BY orden

 	SELECT *, id, clave, link_se AS link,  titulo_se AS titulo,
					slug_se 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 = 'vender'

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

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

	SELECT id, clave, 
					titulo_se AS title,
					link_se AS link,
					slug_se AS slug,
					art_se AS text,
					meta_descr_se 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 = 13
					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 = 'vender'

SELECT id FROM lexington_articulos WHERE clave = 'vender'

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

SELECT titulo_se AS field FROM lexington_articulos WHERE clave = 'sell-with'

SELECT art_se AS field FROM lexington_articulos WHERE clave = 'sell-with'

	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 = 'sell-with'

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