CREATE TABLE board.dbo.board (
  id_board BIGINT IDENTITY
 ,id VARCHAR(64) NULL
 ,url VARCHAR(255) NULL
 ,title VARCHAR(512) NULL
 ,price MONEY NULL
 ,time DATETIME NULL
 ,phone VARCHAR(64) NULL
 ,person VARCHAR(128) NULL
 ,person_type VARCHAR(64) NULL
 ,city VARCHAR(64) NULL
 ,metro VARCHAR(64) NULL
 ,address VARCHAR(255) NULL
 ,description TEXT NULL
 ,nedvigimost_type VARCHAR(64) NULL
 ,source VARCHAR(128) NULL
 ,shape GEOMETRY NULL
 ,parameters VARCHAR(MAX) NULL
 ,vid VARCHAR(255) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE CLUSTERED INDEX IDX_board
ON board.dbo.board (id_board)
ON [PRIMARY]
GO


CREATE TABLE board.dbo.parameter (
  id_parameter BIGINT IDENTITY
 ,id VARCHAR(64) NULL
 ,name VARCHAR(255) NULL
 ,value VARCHAR(255) NULL
) ON [PRIMARY]
GO

CREATE INDEX IDX_parameter
ON board.dbo.parameter (id)
ON [PRIMARY]
GO


SELECT board.id_board,phone ,'№ '+board.id +'<br>'  ,url ,person_type 
  ,nedvigimost_type,person ,phone  ,nedvijimost_type  ,parameter_per.value ,city +'<br>'+ metro +'<br>'+ address ,price,CONVERT(varchar,time,104) ,person+'<br>'+phone 
 ,' '+title+' <br> ' + CONVERT(varchar(512), description) ,source 
  FROM board.dbo.board board LEFT JOIN 
  board.dbo.parameter parameter_per ON 
        (parameter_per.id=board.id and parameter_per.NAME='Вид' and parameter_per.value='В')
WHERE board.id<>0 AND board.id_board<>0 
  GROUP BY board.id_board,phone ,'№ '+board.id +'<br>' ,url ,person_type  ,nedvigimost_type ,person  ,phone ,nedvigimost_type
 ,parameter_per.value ,city +'<br>'+ metro +'<br>'+ address ,price ,CONVERT(varchar,time,104) ,person+'<br>'+phone
  ,' '+title+' <br> ' + CONVERT(varchar(512), description) ,source