CREATE PROCEDURE Search
	-- Add the parameters for the stored procedure here
	@id int,
	@FirstName varchar(20),
	@LastName varchar(20),
	@TelNumber varchar(30),
	@Skype varchar(50),
	@Email varchar(50),
	@Vk varchar(50),
	@Status varchar(50),
	@Additionaly varbinary(MAX)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	select 
		FullUserInfo.UserID, FullUserInfo.Email, FullUserInfo.FirstName,
		FullUserInfo.LastName, FullUserInfo.ImgURL, FullUserInfo.Password ,
		FullUserInfo.Skype, FullUserInfo.Status, FullUserInfo.TelNumber,
		FullUserInfo.Vk,FullUserInfo.Additionally,
		COUNT(Photos.PhotoId ) as PhotosCount, 
		COUNT(Photos.AlbumID) as AlbumsCount
from FullUserInfo left join Photos
  on FullUserInfo.UserID =Photos.UserID  
  where FullUserInfo.UserID like @Id + '%' 
  or FullUserInfo.FirstName like @FirstName + '%'
  or FullUserInfo.LastName like @LastName + '%'
  or FullUserInfo.Email like @Email + '%'
  or FullUserInfo.Vk like @Vk + '%'
  or FullUserInfo.Skype like @Skype + '%'
  or FullUserInfo.TelNumber like @TelNumber + '%'
  or FullUserInfo.Status like @Status + '%'
  or FullUserInfo.Additionally like @Additionaly + '%'