"SELECT d.timestamp, u.name, f.rtid, f.transaction, f.uid FROM {history_winners} AS hw JOIN {draws} AS d ON (hw.did = d.did) JOIN {fortune} AS f ON (hw.fid = f.fid) JOIN {users} AS u ON (f.uid = u.uid) GROUP BY d.timestamp, f.uid, f.rtid"