SELECT DISTINCT U1.user_id uid FROM user_ad_click_time U1 JOIN user_payment_time U2 WHERE TIMESTAMPDIFF(MINUTE,click_time ,pay_time ) <5 AND U1.trace_id =U2.trace_id ORDER BY uid