List<Shopping> data = lookDB.Shopping.Where(x => x.Photos.Count > 0).OrderByDescending(x => x.Id).Take(4).ToList();

CREATE PROCEDURE SelectForSubscribes
	(  
    @Id  int
)
AS
BEGIN
	SELECT shp.Id
      ,shp.UserId
      ,shp.Name
      ,shp.inCountry
      ,shp.inCity
      ,shp.Date
      ,shp.description
      ,shp.recommendations
      ,shp.transport
  FROM [dbo].[Shopping] shp

INNER JOIN Subscribes sc
ON sc.OnSubscribe =shp.UserId

where sc.WhoSubscribe =  @Id order by shp.Id  DESC 

  List<Shopping> data = lookDB.Shopping.Join(lookDB.Subscribes, shp => shp.UserId, sc => sc.OnSubscribe, (shp, sc) => new { shp, sc }).Where(y => y.sc.WhoSubscribe == UserId).Where(x => x.shp.Photos.Count > 0).OrderByDescending(x => x.shp.Id).Take(4).ToList();