E.g. something like:
SELECT COUNT(*), source_id, MAX(title) FROM deck WHERE source_id IN (
SELECT id FROM deck WHERE is_public IS TRUE and is_preconstructed IS FALSE
) GROUP BY source_id ORDER BY COUNT(*) DESC;
Gives a peek at what decks people are copying.