[ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ]
Vartype: string
Length: 2304
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
				, ROUND(MATCH(a.title, a.content) AGAINST ('<p>Every student is required to take 48 credits in the General Studies Program. In addition to providing a more well-rounded educational experience, these courses also help develop a studentâs critical thinking, social, and problem-solving skills.</p>'), 2) 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', ' 80', ' 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')
			AND
				a.id = ac.articleid
			AND a.id != '592'
AND 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', '80', '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')
AND a.approved = 1
AND ( a.sdate IS NULL OR a.sdate <= NOW() ) AND ( a.edate IS NULL OR a.edate >= NOW() )

						AND
						(
							(
								MATCH(a.title, a.content) AGAINST ('<p>Every student is required to take 48 credits in the General Studies Program. In addition to providing a more well-rounded educational experience, these courses also help develop a studentâs critical thinking, social, and problem-solving skills.</p>')
								
							)
							OR
							(
								a.id IN ('')
							)
						)
					
			GROUP BY
				a.id
		 ORDER BY score DESC LIMIT 0, 3
Vartype: string
Length: 0