我有两张桌子:服装和react .我需要展示特定用户在过go 48小时内喜欢特定服装的前6套服装,然后是其他服装.这很管用,但我从第二个查询中得到了重复的衣服,我再次重复了这些衣服.我想确认一下这套衣服.id是唯一的.
如何删除这些副本?
(select outfit.id,
outfit.title,
ro.type,
ro.outfit_id,
ro.sub,
ro.created_at as reaction_created_at,
0 as priority
from outfit
left join reaction_outfit ro on outfit.id = ro.outfit_id
where ro.sub = '123' and ro.created_at >= (NOW() - INTERVAL '48 hours')
order by reaction_created_at desc nulls last LIMIT 6)
union
(select outfit.id,
outfit.title,
ro.type,
ro.outfit_id,
ro.sub,
ro.created_at as reaction_created_at,
1 as priority
from outfit
left join reaction_outfit ro on outfit.id = ro.outfit_id
where is_public = true
order by outfit.created_at desc)
order by priority, outfit_created_at desc;
Postgres 13.2版