• The table does not have FULLTEXT index to support this query|Gdn_Database|Query|select * from ( select match(d.Name, d.Body) against(:Search0 in boolean mode) as `Relevance`, d.DiscussionID as `PrimaryID`, d.Name as `Title`, d.Body as `Summary`, d.Format as `Format`, d.CategoryID as `CategoryID`, d.Score as `Score`, concat('/discussion/', d.DiscussionID) as `Url`, d.DateInserted as `DateInserted`, d.InsertUserID as `UserID`, 'Discussion' as `RecordType` from GDN_Discussion d where d.CategoryID in ('-1', '1201', '631', '233', '553', '1', '15', '97', '3', '69', '240', '378', '1044', '159', '112', '1119', '107', '340', '37', '4', '416', '141', '1218', '18', '474', '743', '45', '16', '12', '1122', '33', '64', '1121', '39', '505', '2', '14', '538', '252', '92', '8', '21', '376', '1220', '99', '1219', '1217', '6', '41', '966', '965', '19', '53', '25', '58', '917', '55', '54', '52', '20', '478', '7', '967', '29', '1214', '1140', '56', '76', '13', '27', '57', '1209', '40', '38', '887', '888', '892', '889', '676', '1204', '1227', '28', '32', '11', '336', '455', '1207', '1228', '24', '1208', '9', '23', '1206', '1222', '1142', '1143', '44', '42', '26', '1224', '271', '1223', '43', '1221', '46', '10', '36', '741', '893', '1120', '88', '1213', '59', '60', '61', '62', '63', '1116', '760', '1013', '1202', '983', '1117', '1225', '47', '1118', '34', '31', '5', '224', '30', '35', '1229', '50', '48', '49', '51') and match(d.Name, d.Body) against (:Search1 in boolean mode) union all select match(c.Body) against(:Search2 in boolean mode) as `Relevance`, c.CommentID as `PrimaryID`, d.Name as `Title`, c.Body as `Summary`, c.Format as `Format`, d.CategoryID as `CategoryID`, c.Score as `Score`, concat('/discussion/comment/', c.CommentID, '/#Comment_', c.CommentID) as `Url`, c.DateInserted as `DateInserted`, c.InsertUserID as `UserID`, 'Comment' as `RecordType` from GDN_Comment c join GDN_Discussion d on d.DiscussionID = c.DiscussionID where d.CategoryID in ('-1', '1201', '631', '233', '553', '1', '15', '97', '3', '69', '240', '378', '1044', '159', '112', '1119', '107', '340', '37', '4', '416', '141', '1218', '18', '474', '743', '45', '16', '12', '1122', '33', '64', '1121', '39', '505', '2', '14', '538', '252', '92', '8', '21', '376', '1220', '99', '1219', '1217', '6', '41', '966', '965', '19', '53', '25', '58', '917', '55', '54', '52', '20', '478', '7', '967', '29', '1214', '1140', '56', '76', '13', '27', '57', '1209', '40', '38', '887', '888', '892', '889', '676', '1204', '1227', '28', '32', '11', '336', '455', '1207', '1228', '24', '1208', '9', '23', '1206', '1222', '1142', '1143', '44', '42', '26', '1224', '271', '1223', '43', '1221', '46', '10', '36', '741', '893', '1120', '88', '1213', '59', '60', '61', '62', '63', '1116', '760', '1013', '1202', '983', '1117', '1225', '47', '1118', '34', '31', '5', '224', '30', '35', '1229', '50', '48', '49', '51') and match(c.Body) against (:Search3 in boolean mode) ) s order by s.DateInserted desc limit 20

No results for #split.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!