Code: Select all
could not execute query [ select distinct TOP (@p0) guideprogr0_.GuideProgramId as GuidePro1_160_, guideprogr0_.Version as Version160_, guideprogr0_.Id as Id160_, guideprogr0_.GuideChannelId as GuideCha4_160_, guideprogr0_.Title as Title160_, guideprogr0_.StartTime as StartTime160_, guideprogr0_.StopTime as StopTime160_, guideprogr0_.StartTimeUtc as StartTim8_160_, guideprogr0_.StopTimeUtc as StopTime9_160_, guideprogr0_.SubTitle as SubTitle160_, guideprogr0_.Description as Descrip11_160_, guideprogr0_.Category as Category160_, guideprogr0_.IsRepeat as IsRepeat160_, guideprogr0_.IsPremiere as IsPremiere160_, guideprogr0_.VideoAspect as VideoAs15_160_, guideprogr0_.SeriesNumber as SeriesN16_160_, guideprogr0_.EpisodeNumberDisplay as Episode17_160_, guideprogr0_.EpisodeNumber as Episode18_160_, guideprogr0_.EpisodeNumberTotal as Episode19_160_, guideprogr0_.EpisodePart as Episode20_160_, guideprogr0_.EpisodePartTotal as Episode21_160_, guideprogr0_.Rating as Rating160_, guideprogr0_.StarRating as StarRating160_, guideprogr0_.Source as Source160_, guideprogr0_.PreviouslyAiredTime as Previou25_160_, guideprogr0_.SeriesId as SeriesId160_, guideprogr0_.IsSeriesTermination as IsSerie27_160_, guideprogr0_.LastModifiedTime as LastMod28_160_, guideprogr0_.IsDeleted as IsDeleted160_ from GuideProgram guideprogr0_ inner join GuideProgramWordFragment wordfragme1_ on guideprogr0_.Id=wordfragme1_.GuideProgramIntId inner join WordFragment wordfragme2_ on wordfragme1_.WordFragmentId=wordfragme2_.WordFragmentId where guideprogr0_.IsDeleted=0 and (wordfragme2_.Fragment like @p1 or wordfragme2_.Fragment like @p2 or wordfragme2_.Fragment like @p3 or wordfragme2_.Fragment like @p4) and (guideprogr0_.Title like @p5) and (guideprogr0_.GuideChannelId in (@p6 , @p7)) and guideprogr0_.StopTimeUtc>=@p8 order by guideprogr0_.StartTimeUtc ] Name:p1 - Value:the% Name:p2 - Value:big% Name:p3 - Value:bang% Name:p4 - Value:theory% Name:p5 - Value:%The Big Bang Theory% Name:p7 - Value:21/04/2015 11:26:11 Name:p6_0_ - Value:cfd47610-3698-42d1-b0e0-2d9e475ef1bc Name:p6_1_ - Value:3ad26c04-3e82-44d7-9c18-74102f0ec0b8 [SQL: select distinct TOP (@p0) guideprogr0_.GuideProgramId as GuidePro1_160_, guideprogr0_.Version as Version160_, guideprogr0_.Id as Id160_, guideprogr0_.GuideChannelId as GuideCha4_160_, guideprogr0_.Title as Title160_, guideprogr0_.StartTime as StartTime160_, guideprogr0_.StopTime as StopTime160_, guideprogr0_.StartTimeUtc as StartTim8_160_, guideprogr0_.StopTimeUtc as StopTime9_160_, guideprogr0_.SubTitle as SubTitle160_, guideprogr0_.Description as Descrip11_160_, guideprogr0_.Category as Category160_, guideprogr0_.IsRepeat as IsRepeat160_, guideprogr0_.IsPremiere as IsPremiere160_, guideprogr0_.VideoAspect as VideoAs15_160_, guideprogr0_.SeriesNumber as SeriesN16_160_, guideprogr0_.EpisodeNumberDisplay as Episode17_160_, guideprogr0_.EpisodeNumber as Episode18_160_, guideprogr0_.EpisodeNumberTotal as Episode19_160_, guideprogr0_.EpisodePart as Episode20_160_, guideprogr0_.EpisodePartTotal as Episode21_160_, guideprogr0_.Rating as Rating160_, guideprogr0_.StarRating as StarRating160_, guideprogr0_.Source as Source160_, guideprogr0_.PreviouslyAiredTime as Previou25_160_, guideprogr0_.SeriesId as SeriesId160_, guideprogr0_.IsSeriesTermination as IsSerie27_160_, guideprogr0_.LastModifiedTime as LastMod28_160_, guideprogr0_.IsDeleted as IsDeleted160_ from GuideProgram guideprogr0_ inner join GuideProgramWordFragment wordfragme1_ on guideprogr0_.Id=wordfragme1_.GuideProgramIntId inner join WordFragment wordfragme2_ on wordfragme1_.WordFragmentId=wordfragme2_.WordFragmentId where guideprogr0_.IsDeleted=0 and (wordfragme2_.Fragment like @p1 or wordfragme2_.Fragment like @p2 or wordfragme2_.Fragment like @p3 or wordfragme2_.Fragment like @p4) and (guideprogr0_.Title like @p5) and (guideprogr0_.GuideChannelId in (@p6 , @p7)) and guideprogr0_.StopTimeUtc>=@p8 order by guideprogr0_.StartTimeUtc]