blob: 5582f173be4da117d929569803fc9c40b2d3266d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
WITH users AS (
SELECT *
FROM ( VALUES ('Dennis'), ('Lam') ) AS _ (user_id)
)
SELECT track_id, name, artist
FROM track
JOIN (
SELECT track_id
FROM user_track
JOIN suser USING (user_id)
JOIN track USING (track_id)
JOIN lobby USING (lobby_id)
WHERE suser.user_name IN (SELECT * FROM users)
GROUP BY track_id
HAVING COUNT(track_id) = (SELECT COUNT(*) FROM users)
ORDER BY EXP(SUM(LN(score))) DESC
) AS _ USING (track_id)
;
|