-- Regular sets: Map setID to tier

SELECT *

FROM (

VALUES

('1', 'ultimate'),

('2', 'common'),

('3', 'ultimate'),

('4', 'legendary'),

('5', 'rare'),

('6', 'rare'),

('7', 'rare'),

('8', 'legendary'),

('9', 'rare'),

('10', 'rare'),

('11', 'rare'),

('12', 'legendary'),

('13', 'rare'),

('14', 'common'),

('15', 'rare'),

('16', 'rare'),

('17', 'rare'),

('18', 'rare'),

('19', 'rare'),

('20', 'legendary'),

('21', 'rare'),

('22', 'common'),

('23', 'legendary'),

('24', 'rare'),

('25', 'rare'),

('26', 'common'),

('27', 'ultimate'),

('28', 'legendary'),

('29', 'rare'),

('30', 'rare'),

('31', 'legendary'),