MSCRM, SQL and Localization

If you need to look at localized name of some attribute thru the SQL then check out next code

select l.* 
from MetadataSchema.LocalizedLabel l
 join MetadataSchema.Attribute a on l.objectid=a.AttributeId
 join MetadataSchema.Entity e on a.EntityId=e.EntityId  
where a.name= 'address1_city' and e.name='account'