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,ChildNews,Journalist,Agency FROM News N JOIN (News_Edition NE,iEdition E,iMediaOutlet MO) ON (NE.NewsId=N.gidNews AND E.gidEdition=NE.EditionId AND MO.gidMediaOutlet=N.gidMediaOutlet) LEFT JOIN (NewsPosition NP) ON (NP.gidNewsPosition=N.gidNewsPosition) LEFT JOIN (iJournalist J) ON (N.gidJournalist=J.gidJournalist) LEFT JOIN (Agency A) ON (N.gidAgency=A.gidAgency) where N.gidNews='a62fbc6e305222189a49f0a2ad19890a562e94c0' AND N.Status != -'1'

News Detail
powered by bluebytes  
Highlight KeywordsRemove Highlight      Share News      Export Options       PDF      JPEG       Advance PDF      

All form fields are required.

Welspun Investing Rs 600cr in Gujarat
Anjar: Welspun India said on Wednesday that it is investing Rs 600 crore for setting up a faci­lity for manufacturing carpets, area rugs and carpet tiles here, marking the leading global home textile firm's foray into flooring solu­tions segment. "We are expanding our product portfolio by forayi...
Date: Thursday , December 15, 2016
Publication: The Economic Times, Agency: Bureau
Edition: Ahmedabad, Page No: 3, Location: Bottom-Right, Size(sq.cms): 25