[ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ] [ + ]
Vartype: string
Length: 2306
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>All students must study mathematics. However, the number of mathematics credits required will depend on the studentâs intended major. Tutoring services are available from the Mathematics Department for all students who require extra instruction.</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', ' 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 a.id != '595'
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', '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.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>All students must study mathematics. However, the number of mathematics credits required will depend on the studentâs intended major. Tutoring services are available from the Mathematics Department for all students who require extra instruction.</p>')
								
							)
							OR
							(
								a.id IN ('')
							)
						)
					
			GROUP BY
				a.id
		 ORDER BY score DESC LIMIT 0, 3
Vartype: string
Length: 0