SELECT movieProductCompany,moviePublishCompany,movieCast,substring(moviecrew,1,10) as moviecrew,movieDate,substring(movieIntro,0,10) as movieIntro,movieAwards,movieOfficialsites,'' as movieTrivia,(select top 1 photoID from moviePhoto b where b.movieID = a.movieID and b.available=1 and b.photoType = 1) as photogallery,(select top 1 photoID from moviePhoto b where b.movieID = a.movieID and b.available=1 and b.photoType = 2) as poster,(select top 1 photoID from moviePhoto b where b.movieID = a.movieID and b.available=1 and b.photoType = 3) as wallpaper,(select top 1 rtrim(photoURL) from moviePhoto b where b.movieID = a.movieID and b.available=1 and (b.photostatus = 1 or b.photoStatus=4)) as keyphotourl,movieID,movieChineseName as movieCName,'' as movieEName,(select top 1 [mtID] from [movieTrailer] b where b.[movieID] = a.movieID) as mtid,schname,(select top 1 photoID from moviePhoto b where b.movieID = a.movieID and b.available=1 and b.photoType >3 and b.photoType<7) as cover,movieType,movieDirector,movieWriter FROM movie a WHERE a.movieID = 536153查询数据的时候发现错误，请检查您的查询代码是否正确。