[SELECT flat.*,mapObject.Name as town,flatType.Name as typeName, provider.ID as providerID,provider.Name as providerName, flat=>\parms\price\minPrice as minPrice, flat=>\parms\price\maxPrice as maxPrice,currency.Name as currencyName,priceType.Name as priceTypeName, flat->\parms\flat\location as location, status.Name as statusName, flat->\parms\flat\releaseDate as releaseDate, flat->\parms\page\body as body FROM \flat\variant\% as flat, \users\% as provider, \MapObjects\% as mapObject,\parms\flat\type\% as flatType, \parms\price\currency\% , \parms\price\type\% as priceType , \parms\flat\status\% as status WHERE flat=>provider AND flat=>mapObject AND flat=>flatType AND flat=>currency AND flat=>priceType AND flat=>status AND flat.ID=66380]Дом в Феодосии