SELECT DISTINCT p.m_model FROM brodit_products p WHERE LOWER(p.m_make) = 'samsung' AND p.m_active = 'Y' ORDER BY CASE p.m_model WHEN 'Galaxy S24 SM-S921B/DS' THEN '001' WHEN 'Galaxy S24+ SM-S926B/DS' THEN '002' WHEN 'Galaxy S24 Ultra SM-S928B/DS' THEN '003' WHEN 'Galaxy S23 SM-S911B/DS' THEN '004' WHEN 'Galaxy S23+ SM-S916B/DS' THEN '005' WHEN 'Galaxy S23 Ultra SM-S918B/DS' THEN '006' WHEN 'Galaxy S22 5G SM-S901B/SM-S901B/DS' THEN '007' WHEN 'Galaxy S22+ 5G (SM-S906B/SM-S906B/DS)' THEN '008' WHEN 'Galaxy S22 Ultra 5G (SM-S908B/SM-S908B/DS)' THEN '009' WHEN 'Galaxy S21 5G SM-G991B/SM-G991B/DS' THEN '010' WHEN 'Galaxy S21+ 5G SM-G996B/SM-G996B/DS' THEN '011' WHEN 'Galaxy S21 Ultra 5G SM-G9988/DS' THEN '012' WHEN 'Galaxy S20 4G, 5G (SM-G981B/SM-G981F)' THEN '013' WHEN 'Galaxy S20 Plus 5G (SM-G986B/SM-G986F)' THEN '014' WHEN 'Galaxy S20 Ultra 5G (SM-G988B)' THEN '015' WHEN 'Galaxy S20 FE (SM-G780/SM-G781)' THEN '016' WHEN 'Galaxy S10' THEN '017' WHEN 'Galaxy S10+' THEN '018' WHEN 'Galaxy S10e' THEN '019' WHEN 'Galaxy S9' THEN '020' WHEN 'Galaxy S9+' THEN '021' WHEN 'Galaxy S8' THEN '022' WHEN 'Galaxy S8+' THEN '023' WHEN 'Galaxy S8 Active' THEN '024' WHEN 'Galaxy S7' THEN '025' WHEN 'Galaxy S7 Active' THEN '026' WHEN 'Galaxy S7 Edge' THEN '027' WHEN 'Galaxy S6' THEN '028' WHEN 'Galaxy S6 Active' THEN '029' WHEN 'Galaxy S6 edge' THEN '030' WHEN 'Galaxy S6 edge+' THEN '031' WHEN 'Galaxy S4 GT-I9505' THEN '032' WHEN 'Galaxy S4 GT-I9506' THEN '033' WHEN 'Galaxy S4 Active GT-I9295' THEN '034' WHEN 'Galaxy S4 Mini GT-I9195' THEN '035' WHEN 'Galaxy S III (T-Mobile USA SGH-T999)' THEN '036' WHEN 'Galaxy S III (Sprint SPH-L710)' THEN '037' WHEN 'Galaxy S III (Verizon SCH-i535)' THEN '038' WHEN 'Galaxy S III i9300' THEN '039' WHEN 'Galaxy S III i9305' THEN '040' WHEN 'Galaxy S III Mini GT-i8190' THEN '041' WHEN 'Galaxy A10 (SM-A105)' THEN '042' WHEN 'Galaxy A10e (SM-A1024)' THEN '043' WHEN 'Galaxy A20e (SM-A202)' THEN '044' WHEN 'Galaxy A3 (2016)' THEN '045' WHEN 'Galaxy A3 (2017)' THEN '046' WHEN 'Galaxy A3 SM-A300' THEN '047' WHEN 'Galaxy A32 5G SM-A326U1/DS' THEN '048' WHEN 'Galaxy A34 5G' THEN '049' WHEN 'Galaxy A40 (SM-A405)' THEN '050' WHEN 'Galaxy A41 (SM-A415F)' THEN '051' WHEN 'Galaxy A5 (2016)' THEN '052' WHEN 'Galaxy A5 (2017)' THEN '053' WHEN 'Galaxy A5 SM-A500' THEN '054' WHEN 'Galaxy A50 (SM-A505)' THEN '055' WHEN 'Galaxy A51 SM-A515F/DSN' THEN '056' WHEN 'Galaxy A52 SM-A52F/DS' THEN '057' WHEN 'Galaxy A52S 5G SM-A528B. SM-A528B/DS' THEN '058' WHEN 'Galaxy A53 5G SM-A536B/DS' THEN '059' WHEN 'Galaxy A7 2018 (SM-A750)' THEN '060' WHEN 'Galaxy A70 (SM-A705)' THEN '061' WHEN 'Galaxy A72 SM-A725F/DS' THEN '062' WHEN 'Galaxy A8 (2018)' THEN '063' WHEN 'Galaxy Alpha' THEN '064' WHEN 'Galaxy J3' THEN '065' WHEN 'Galaxy J3 (2016)' THEN '066' WHEN 'Galaxy J3 (2018)' THEN '067' WHEN 'Galaxy J3 2017 (J330F, J330G)' THEN '068' WHEN 'Galaxy J3 SM-J327A' THEN '069' WHEN 'Galaxy J4+ (SM-J415)' THEN '070' WHEN 'Galaxy J5 (2016)' THEN '071' WHEN 'Galaxy J5 (2017)' THEN '072' WHEN 'Galaxy J7 (2017) Sm-J730F' THEN '073' WHEN 'Galaxy Note 10 SM-N970' THEN '074' WHEN 'Galaxy Note 10+ 5G' THEN '075' WHEN 'Galaxy Note 10+ SM-N975' THEN '076' WHEN 'Galaxy Note 10.1 (2014 Edition) SM-P6000' THEN '077' WHEN 'Galaxy Note 10.1 (2014 Edition) SM-P6050' THEN '078' WHEN 'Galaxy Note 20 5G' THEN '079' WHEN 'Galaxy Note 20 Ultra 5G' THEN '080' WHEN 'Galaxy Note 3 Neo' THEN '081' WHEN 'Galaxy Note 3 Neo Duos' THEN '082' WHEN 'Galaxy Note 3 SM-N9005' THEN '083' WHEN 'Galaxy Note 4' THEN '084' WHEN 'Galaxy Note 5' THEN '085' WHEN 'Galaxy Note 8' THEN '086' WHEN 'Galaxy Note 8.0 GT-N5110' THEN '087' WHEN 'Galaxy Note 8.0 GT-N5120' THEN '088' WHEN 'Galaxy Note 9' THEN '089' WHEN 'Galaxy Note II GT-N7100' THEN '090' WHEN 'Galaxy Note PRO 12.2 4G SM-P905' THEN '091' WHEN 'Galaxy Note PRO 12.2 Wi-Fi SM-P900' THEN '092' WHEN 'Galaxy S Duos 2 S7582' THEN '093' WHEN 'Galaxy S5' THEN '094' WHEN 'Galaxy S5 Active' THEN '095' WHEN 'Galaxy S5 Mini SM-G800F' THEN '096' WHEN 'Galaxy S5 Mini SM-G800H' THEN '097' WHEN 'Galaxy Tab 10.1 GT-P7500' THEN '098' WHEN 'Galaxy Tab 10.1 SCH-I905' THEN '099' WHEN 'Galaxy Tab 2 10.1' THEN '100' WHEN 'Galaxy Tab 2 7.0' THEN '101' WHEN 'Galaxy Tab 3 10.1 GT-P5200' THEN '102' WHEN 'Galaxy Tab 3 10.1 GT-P5210' THEN '103' WHEN 'Galaxy Tab 3 10.1 GT-P5220' THEN '104' WHEN 'Galaxy Tab 3 7.0 SM-T210' THEN '105' WHEN 'Galaxy Tab 3 7.0 SM-T2110' THEN '106' WHEN 'Galaxy Tab 3 8.0 SM-T310' THEN '107' WHEN 'Galaxy Tab 3 8.0 SM-T315' THEN '108' WHEN 'Galaxy Tab 3 Lite' THEN '109' WHEN 'Galaxy Tab 4 10.1 SM-T530' THEN '110' WHEN 'Galaxy Tab 4 10.1 SM-T531' THEN '111' WHEN 'Galaxy Tab 4 10.1 SM-T535' THEN '112' WHEN 'Galaxy Tab 4 7.0 SM-T230' THEN '113' WHEN 'Galaxy Tab 4 7.0 SM-T231' THEN '114' WHEN 'Galaxy Tab 4 7.0 SM-T235' THEN '115' WHEN 'Galaxy Tab 4 8.0 SM-T335' THEN '116' WHEN 'Galaxy Tab 7.0 Plus GT-P6200' THEN '117' WHEN 'Galaxy Tab 7.7 GT-P6800' THEN '118' WHEN 'Galaxy Tab 8.9 GT-P7300' THEN '119' WHEN 'Galaxy Tab A 10.1 (2016) SM-T580/SM-T585' THEN '120' WHEN 'Galaxy Tab A 10.1 (2019) SM-T510/SM-T515' THEN '121' WHEN 'Galaxy Tab A 10.5 SM-T590/SM-T595' THEN '122' WHEN 'Galaxy Tab A 7.0 (2016) SM-T280/SM-T285' THEN '123' WHEN 'Galaxy Tab A 8.0 (2015) SM-T350' THEN '124' WHEN 'Galaxy Tab A 8.0 (2017) SM-T380' THEN '125' WHEN 'Galaxy Tab A 8.0 (2018 SM-T387)' THEN '126' WHEN 'Galaxy Tab A 8.0 (2019 SM-T290/SM-T295)' THEN '127' WHEN 'Galaxy Tab A 8.4 (2020) SM-T307' THEN '128' WHEN 'Galaxy Tab A9 SM-X110/SM-X115' THEN '129' WHEN 'Galaxy Tab A9+ 10.9 SM-X210' THEN '130' WHEN 'Galaxy Tab A9+ 11 SM-X210/SM-X215 LTE/SM-X216 5G' THEN '131' WHEN 'Galaxy Tab A 9.7' THEN '132' WHEN 'Galaxy Tab A7 10.4 (2020) SM-T500/SM-T505' THEN '133' WHEN 'Galaxy Tab A7 Lite SM-T220/SM-T225' THEN '134' WHEN 'Galaxy Tab A8 SM-X200/205' THEN '135' WHEN 'Galaxy Tab Active 2 SM-T390/SM-T395' THEN '136' WHEN 'Galaxy Tab Active 3 SM-T570/SM-T575' THEN '137' WHEN 'Galaxy Tab Active 4 Pro SM-T630/SM-T636' THEN '138' WHEN 'Galaxy Tab Active 5 SM-X300/SM-X306B' THEN '139' WHEN 'Galaxy Tab Active 8.0 SM-T365' THEN '140' WHEN 'Galaxy Tab Active Pro T540/T545/T547/T547U' THEN '141' WHEN 'Galaxy Tab E 8.0' THEN '142' WHEN 'Galaxy Tab E 9.6' THEN '143' WHEN 'Galaxy Tab GT-P1000' THEN '144' WHEN 'Galaxy Tab PRO 10.1 LTE SM-T525' THEN '145' WHEN 'Galaxy Tab PRO 10.1 SM-T520' THEN '146' WHEN 'Galaxy Tab PRO 12.2 4G SM-T905' THEN '147' WHEN 'Galaxy Tab PRO 12.2 Wi-Fi SM-T900' THEN '148' WHEN 'Galaxy Tab PRO 8.4 SM-T320' THEN '149' WHEN 'Galaxy Tab PRO 8.4 SM-T325' THEN '150' WHEN 'Galaxy Tab S 10.5 SM-T800' THEN '151' WHEN 'Galaxy Tab S 10.5 SM-T805' THEN '152' WHEN 'Galaxy Tab S 8.4 SM-T700' THEN '153' WHEN 'Galaxy Tab S 8.4 SM-T705' THEN '154' WHEN 'Galaxy Tab S2 8.0 SM-T713 /SM-T719' THEN '155' WHEN 'Galaxy Tab S2 9.7 SM-T810/SM-T813/SM-T815/SM-T819' THEN '156' WHEN 'Galaxy Tab S3 9.7 SM-T820/SM-T825' THEN '157' WHEN 'Galaxy Tab S4 10.5 SM-T830/SM-T835' THEN '158' WHEN 'Galaxy Tab S5e 10.5 SM-T720/SM-T725' THEN '159' WHEN 'Galaxy Tab S6 10.5 SM-T860/SM-T865' THEN '160' WHEN 'Galaxy Tab S6 Lite SM-P610/SM-P615' THEN '161' WHEN 'Galaxy Tab S7 FE SM-T733' THEN '162' WHEN 'Galaxy Tab S8 SM-X700' THEN '163' WHEN 'Galaxy Xcover 7' THEN '164' WHEN 'Galaxy Xcover 6 Pro' THEN '165' WHEN 'Galaxy Xcover 5' THEN '166' WHEN 'Galaxy Xcover 4' THEN '167' WHEN 'Galaxy XCover 4s' THEN '168' WHEN 'Galaxy Xcover 3' THEN '169' WHEN 'Galaxy Xcover 2' THEN '170' WHEN 'Galaxy Xcover Pro SM-G715' THEN '171' WHEN 'Galaxy Z Fold3 5G' THEN '172' WHEN 'Galaxy Z Fold4 5G' THEN '173' WHEN 'Galaxy Z Fold5' THEN '174' WHEN 'Galaxy Tab S9 FE SM-X51x' THEN '175' WHEN 'Xcover 271 GT-B2710' THEN '176' WHEN 'Xcover 550 SM-B550' THEN '177' WHEN 'S7710' THEN '178' WHEN 'SGH-B2100' THEN '179' WHEN 'Galaxy S III (AT&T SGH-i747)' THEN '180' ELSE 999 END ;
