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 News_OY 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='8760cc28A3fceA40afA818eA2558fd7b623f' AND N.Status != '-1'
News Detail
Thursday , November 15, 2018
Return Keep changing on asset so need to rebalancing
Publication: Dainik Bhaskar (Hindi),
Agency: Bureau ,
Edition: Chandigarh/ Chandigarh/ Chandigarh/ Chandigarh/ Chandigarh/ Chandigarh/ Chandigarh/ Chandigarh/ Chandigarh/ Chandigarh/ Chandigarh/ Chandigarh, Page No: 7,
Height:
27,
Width:
7,
Size(sq.cms): 189
|
|
|
|
Hide
|
|
|
|
|
|
|