SELECT uact.user_id uid FROM user_ad_click_time uact LEFT JOIN user_payment_time upt ON upt.trace_id = uact.trace_id WHERE TIMESTAMPDIFF( MINUTE, uact.click_time, upt.pay_time )<=5