SELECT date(N.CreatedOn) CreatedOn,gidNews,PublishDate,N.Headline,N.Summary,MediaOutlet,group_concat(Edition) as Edition,PageNo,PageNoRange,N.Height,N.Width,MastHead,NewsPosition,SizeofArticle,S.Supplement as Supplement,ChildNews,Journalist,Agency FROM News N JOIN (News_Edition NE,Edition E,MediaOutlet MO,News_Supplement NS) ON (NE.NewsId=N.gidNews AND E.gidEdition=NE.EditionId AND MO.gidMediaOutlet=N.gidMediaOutlet AND N.gidNews=NS.NewsId) LEFT JOIN (NewsPosition NP) ON (NP.gidNewsPosition=N.gidNewsPosition) LEFT JOIN (iSupplements S) ON (S.gidSupplement=NS.gidSupplments) LEFT JOIN (Journalist J) ON (N.gidJournalist=J.gidJournalist) LEFT JOIN (Agency A) ON (N.gidAgency=A.gidAgency) where N.gidNews='f66b6c68A83eaA439fAae69A5eee68dbae48' AND N.Status != -'1'

News Detail
powered by bluebytes  
 

View in Multi Page Format