Select
[ResearchUnit££] as [ResearchUnit],
[ResearchUnit long name],
Laboratory,
[Department description],
Responsible as [Unit Responsible],
Description as [Unit description],
Activity,
[Img£#£], Didascalia as [_Photo:] ,
Laboratory as [Laboratory£],
[Area of Interest],
Equipments,
Services,
[Training and Study],
[Img2£#£], Didascalia2 as [_Photo2:],
[Work Opportunities], Networks,
URL, [URL-2], [URL-3],
[Related web sites],
[ImgLogo£#£],
[Researchunit££],
id_ResearchUnit as [id_ResearchUnit3],
[ID_LAB££],
id_ResearchUnit
from [UnitadiRicerca-vista-en] WHERE ([id_lab]=7) ORDER BY Laboratory+' '+ResearchUnit;
