search

onecrayon / api.ashes.live

Backend API for a fan-developed deckbuilder and community website for the card game Ashes Reborn
ISC License
13 stars 3 forks source link

Request: Sort published decks by "most cloned" #106

Open onecrayon opened 5 months ago

onecrayon commented 5 months ago

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.