SELECT `users`.*, `twitts`.* FROM `twitts` LEFT JOIN `users` ON `twitts`.`user`=`users`.`id` WHERE MATCH(`twitts`.`msg`) AGAINST('#php' IN BOOLEAN MODE) ORDER BY `twitts`.`time` DESC LIMIT 0, 5 SELECT `users`.*, `twitts`.* FROM `twitts` LEFT JOIN `users` ON `twitts`.`user`=`users`.`id` WHERE MATCH(`twitts`.`msg`) AGAINST('#php' IN BOOLEAN MODE) ORDER BY `twitts`.`time` DESC LIMIT 0, 5