USE wowapi

SELECT
    aucid,
    COUNT(retrieval_date) AS 'seen count',
    owner,
    bid/10000 AS 'gold cost',
    it.name,
    CASE timeleft
        WHEN 0 THEN '<30min'
        WHEN 1 THEN '<2h'
        WHEN 2 THEN '<12h'
        WHEN 2 THEN '<48h'
    END
FROM auctions
JOIN itembasic it ON auctions.item = it.id
WHERE it.quality =4 AND faction=1 AND bid/10000>50000
GROUP BY aucid,owner,bid,it.name,timeleft
ORDER BY 3 DESC, name ASC,timeleft DESC