davidmwt

SELECT Btd_posts.*, MATCH (Btd_posts.post_title) AGAINST (‘香港夾心照顧者’) as score
FROM Btd_posts
WHERE 1=1
AND ( ( Btd_posts.post_date >= ‘2018-02-22 00:00:00’
AND Btd_posts.post_date <= ‘2021-02-21 13:54:52’ ) )
AND Btd_posts.ID NOT IN (493)
AND Btd_posts.post_type IN (‘post’, ‘page’)
AND ((Btd_posts.post_status = ‘publish’
OR Btd_posts.post_status = ‘inherit’))
AND MATCH (Btd_posts.post_title) AGAINST (‘香港夾心照顧者’)
ORDER BY score DESC
LIMIT 0, 12

Just set it to max 12, but same result.

Thank you Ajay, it’s installed and find a clues here:

SELECT Btd_posts.ID
FROM Btd_posts
WHERE 1=1
AND Btd_posts.ID IN (585,690,692,694,9,517,686,688)
AND Btd_posts.post_type IN (‘post’, ‘page’)
AND ((Btd_posts.post_status = ‘publish’))
ORDER BY FIELD(Btd_posts.ID,585,690,692,694,9,517,686,688)
LIMIT 0, 5