Feb 3, 2025
0
Level 2
FullText search and OrderBy
When I do a search and sort the result with latest() it outputs 2 results, but if I remove latest() it outputs 3 results, why?
select * from `applications` where exists (select * from `application_titles` where `applications`.`id` = `application_titles`.`application_id` and match (`title_ru`) against ('Buy' in natural language mode)) and `applications`.`deleted_at` is null order by `created_at` desc;
Please or to participate in this conversation.