select
    t1.user_id as uid
from user_ad_click_time t1
left join user_payment_time t2
on t1.user_id = t2.user_id and t1.trace_id = t2.trace_id
where timestampdiff(minute, t1.click_time, t2.pay_time) <= 5
order by uid desc