SELECT DISTINCT(au.user_id), au.first_name, au.email, a.email as aff_email, a.name as aff_name, a.ident, ub.bet_id
				FROM affiliate_user as au
				LEFT JOIN user AS u ON au.user_id = u.affiliate_user_id
				LEFT JOIN affiliate AS a ON u.affiliate_id = a.affiliate_id
				LEFT JOIN user_bet AS ub ON u.user_id = ub.user_id
				WHERE au.created < now() - INTERVAL 2 HOUR
				AND au.created > now() - INTERVAL 3 HOUR
				ORDER BY ub.bet_id<br/>