con un DB così
codice:
Tabella users
+----+------+
| id | name  |
+----+------+

Tabella mancanti
+------+-----+
| user | fig |
+------+-----+

Tabella doppie
+------+-----+
| user | fig |
+------+-----+
Usa questa query
codice:
SELECT
    users.name AS user_name,
    c.u AS user_id,
    COUNT(c.u) AS n_figurine
FROM
    users,
    (SELECT
        d.user AS u
    FROM
        doppie AS d,
        mancanti AS m
    WHERE
        m.fig=d.fig
        AND m.user=1
    ) AS c
WHERE
    users.id=c.u
GROUP BY c.u
ORDER BY n_figurine DESC