SELECT gidNews,PublishDate,date(N.CreatedOn) as CreatedOn,N.Headline,N.Summary,N.Height,N.Width,MediaOutlet,group_concat(Edition) as Edition,PageNo,PageNoRange,MastHead,NewsPosition,SizeofArticle,S.Supplement as Supplement,ChildNews,Journalist,Agency FROM iNews N JOIN (iNews_Edition NE,iEdition E,iMediaOutlet MO ,iNews_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 (iJournalist J) ON (N.gidJournalist=J.gidJournalist) LEFT JOIN (Agency A) ON (N.gidAgency=A.gidAgency) where N.gidNews='023286fdA4420A4ffbA9839A1c23c95cf4ed' AND N.Status != '-1'

      

| 01st January 1970 Edition: Journalist: | Pg:

All form fields are required.

Your Email id Recipient’s Email Ids [separated by comma (,)] News you want to share

Summary:
...
Date: Thursday , January 01, 1970
Publication:
Edition: , Page No: , Location: , Size(sq.cms):

Comment Box