getNews

		SELECT
			news.newsId, news.classId, spareVideo, news.title, news.serviceLevel aLevel, news.mediaId, news.tencentMediaId, news.contentType, news.times, news.content, news.authLevel, news.authorInfo, news.addPerson,
			bos.thumbUrl,
			cos.imageUrl tencentThumbUrl,
			hits.hits,
			cls.className, cls.serviceLevel cLevel,
			sum(case when comment.score = 1 then 1 else 0 end) s1cnt,
			sum(case when comment.score = 2 then 1 else 0 end) s2cnt,
			sum(case when comment.score = 3 then 1 else 0 end) s3cnt,
			sum(case when comment.score = 4 then 1 else 0 end) s4cnt,
			count(comment.recid) total
		FROM
			_webnews news
			
			INNER JOIN _webnews_classes cls
			ON news.classid = cls.classid
			
			left join cms_videos_bos bos
			on bos.mediaid = news.mediaid
			and bos.state = 'PUBLISHED'
			
			left join cms_videos_cos cos
			on cos.fileid = news.tencentMediaId
			and cos.state = 2
			
			LEFT JOIN _webnews_hits hits
			ON hits.newsid = news.newsid
			
			LEFT JOIN _webnews_comment comment
			ON comment.newsid = news.newsid
		WHERE
			news.isDelete !=1
			and news.auditing = 1
			AND news.newsid = '33762092'

Array
(
    [newsId] => 33762092
    [classId] => 330
    [spareVideo] => 
    [title] => 全赢理念之 策略与周期
    [aLevel] => 10
    [mediaId] => mda-ifkh9mcqgn18ckbj
    [tencentMediaId] => 7447398156758455523
    [contentType] => 3
    [times] => 2018-06-21
    [content] => <hr />
<p>&nbsp;</p>
    [authLevel] => 0
    [authorInfo] => 
    [addPerson] => 2011196
    [thumbUrl] => /mda-ifkh9mcqgn18ckbj/mda-ifkh9mcqgn18ckbj.jpg
    [tencentThumbUrl] => /a90f09c5vodtransbj1253941541/314088377447398156758455523/snapshot/1529554303_457185601.100_0.jpg
    [hits] => 85825
    [className] => 全赢理念
    [cLevel] => -1
    [s1cnt] => 21
    [s2cnt] => 0
    [s3cnt] => 0
    [s4cnt] => 951
    [total] => 972
)