a guest Jul 11th, 2018 62 Never
- select forum_thread.thread_id, forum_thread.title, forum_thread.locked, forum_post.timestamp, forum_thread.nick, forum_post.text, forum_post.nick as usernick, forum_read.timestamp as userstamp
- from forum_thread inner join forum_post on forum_thread.latest_post=forum_post.post_id left join forum_read on forum_thread.thread_id=forum_read.thread_id and forum_read.nick=\"$nick\"
- where match(text) against ('$searchquery' in boolean mode) ORDER BY forum_post.timestamp DESC $limit";
RAW Paste Data