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='d35acc5bA5f84A4d9bAb0c6A379717702e8e' AND N.Status != -'1'

News Detail
powered by bluebytes  

View in Multi Page Format

All form fields are required.

Welspun Enterprises expands road sector portfolio
Infrastructure arm of Welspun Group, Welspun Enterprises Ltd (WEL), formerly known as Welspun Projects Ltd, announced expanding its operations in the infrastructure sector by acquiring two road projects from Delhi-based MBL Infrastruc­tures Ltd (MBL)....
Date: Wednesday , July 26, 2017
Publication: The Hindu Business Line, Agency: Bureau
Edition: Delhi/Kolkata, Page No: 3, Location: Bottom-Left, Size(sq.cms): 130