[ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ]
Vartype: string
Length: 1138
SELECT
				a.*,
				(SELECT COUNT(*) FROM kb_comment c WHERE c.articleid = a.id) as numcomment,
				(SELECT IF( AVG(r.score) != '', ROUND(AVG(r.score), 2), '0.00' ) FROM kb_rating r WHERE r.articleid = a.id) as rating
				, 0 AS score
			FROM
				kb_article a,
				kb_article_category ac
			WHERE
				ac.categoryid IN ('16', ' 29', ' 30', ' 31', ' 32', ' 37', ' 38', ' 39', ' 40', ' 42', ' 43', ' 45', ' 50', ' 54', ' 13', ' 18', ' 66', ' 68', ' 69', ' 70', ' 26', ' 27', ' 72', ' 73', ' 74', ' 75', ' 76', ' 28', ' 79', ' 81', ' 14', ' 15', ' 82', ' 83', ' 35', ' 36', ' 17', ' 84', ' 85', ' 34', ' 86', ' 87', ' 58', ' 89', ' 90', ' 91', ' 92', ' 94', ' 95', ' 59', ' 11', ' 2', ' 25', ' 4', ' 7', ' 8', ' 9', ' 88', ' 5', ' 77', ' 1', ' 24', ' 3', ' 100', ' 104', ' 105', ' 106', ' 107', ' 103', ' 101', ' 64', ' 108', ' 109', ' 110', ' 98', ' 97', ' 78', ' 6', ' 10', ' 80')
			AND
				a.id = ac.articleid
			AND ac.categoryid = '50'
AND a.approved = 1
AND a.visible = 1 AND ac.visible = 1
AND ( a.sdate IS NULL OR a.sdate <= NOW() ) AND ( a.edate IS NULL OR a.edate >= NOW() )
			GROUP BY
				a.id
		 ORDER BY a.title ASC LIMIT 0, 20
Vartype: string
Length: 0