select sku from products_brands_link where sku IN("10AWAL-1930","10AWAL-2480","10AWAL-2493","10AWAL-2504","1C-BS-HP","2B","2BN","3B-HP","5A","5AN","5AVG","5B","5BKF","5BN","61035","75H","7A","7AN","806M","836","845161","890161","9709TP","9711GS","A3C14X6SR-C","AACJSE","ADP-20","ADP-30","AML-25","APC-33","AX-0110-00","AX-0112-00","AX-0113-00","AX-0114-00","AX-0116-00","AX-20","AX-25L","AX-38","B-1030","B-250QB","B-300F","B-50","B-790","B032","B1000","B10EC2S","B10RES7","B10UV1","B1220","B12EC2S","B12RES7","B12UV1","B1330","B13EC2S","B13RES7","B13UV1","B14EC2S","B14RES7","B14UV1","B16EC2S","B16RES7","B16UV1","B200QB","BA-0108-00","BA-0110-00","BA-0112-00","BA-0113-00","BA-0114-00","BA-0115-00","BA-0116-00","BA-0118-00","BA-0308-00","BA-0310-00","BA-0312-00","BA-0313-00","BA-0314-00","BA-0316-00","BA-0318-00","BB-1322-00","BC-1030","BC-150S","BC-830","BC-930","BC890","BCM-10","BD16EMAD","BD16GB4","BD18EMAD2","BD20EMADUV","BD22EMADUV","BD22G2","BD22GB3","BD22GB4UV","BD24EMAD","BD24G10","BD26RBG","BDA-IT-B","BDA-TS","BDP-IT","BE-0108-00","BE-0110-00","BE-0112-00","BE-0113-00","BE-0114-00","BE-0116-00","BE-0118-00","BE-0310-00","BE-0312-00","BE-0313-00","BE-0314-00","BE-0315-00","BE-0316-00","BE-0318-00","BEATBOY","BEATBUDDY","BH-5510-BK","BING-BONGS","BLUNTS","BR-1120-00","BR-1122-00","BR-1322-00","BRR","BT-1","BTLMINI","C-150S","C-830","C-930","C1000","C2A528-201","CABPRO-S","CATTAILS-MINI","CB-TDP","CCA-5","CCB520-914","CFDS5A","CFDS5B","CGC-03BK","CH-70","CH-80","CH-830","CH-830S","CH1000","CHAMELEON-BLK","CHAMELEON-WHT","CJCOM","CJDR","CJEFL","CL68","CL945B","CM1-E605-DCB","CM1-E824S-WG","COLLIDERS","COMETS","COMMANDMESHKIT","CROSSOVERS-POLYJINGLE","CROSSOVERSII","CS-0118-10","CS-1320-10","CS1-E625-BSD","CS1450","CS755","CS865","CUBEX","CY-8","D-50","D-730S","D-790","D-930","D003","D004","D1000N","D1000SN","D2000","D2000BR","D75","D900","DADK","DAP-3","DAP-3X","DATK","DB-30","DB-60","DB-90","DB22","DKP137-MRK","DMP925SPC227","DMP925SPC260","DPR500-PB616","DR-670","DRUM-CARE-KIT","DS550","DS55U","DS750","DT-52R","DTX400K","DTX500K","DTX522K","DTX550K","DW-101SP","DW-2000","DW-2002","DW-3000","DW-3002","DW-3500T","DW-3700","DW-3900","DW-4002","DW-5000","DW-5000AD","DW-5300","DW-8000","DW-9000","DW-EC2205DS","DW-FP-KIT-BG","DW-FP-KIT-RV","DW-PERFORMANCE2","DW-SM201","DW10","EAD10","EBDL","EC-10M","ES-0010-00","ES-0012-00","ES-0013-00","ES-0014-00","ES-0016-00","ESA1465SC","ESF11-STAGE3-11233","ETP-EC2SCLR-F","ETP-EC2SCLR-R","ETP-EC2SCLR-S","ETP-G2CLR-R","EXL725SPC249","EXS1BG","EXX725SC21-RSG1","EXX725SC31","EXX725SC31-RSG1","EXX725SC702","EXX725SC702-RSG1","EXX725SC91","EXX725SC91-RSG1","EXX725SPC21","EXX725SPC31","EXX725SPC717","F3007","F37-SNARE","F507EXTREME","F507STAGE1","FA099-0543-000","FATBASTARDS","FBH535AW","FBH565AW","FBH595AW","FCP1050","FCP1050R","FCS1050","FKEY","FORGEKIT","FP7210A","FP8215","FP9410","FSCJCB","FSCJLC","FSCJUV","FSCJW","FSCJWM","FW923XPC327","FX12","GCLMSP","GE3825W","GM2F5PP","GMOF5","GP-RTT1","GRIPDISC","GROOVPAD","GROOVPAD-SKYGLO","H-150S","H-790","H-830","H-890","H-930","H1000","H2000","H900","HC-5AS-GRIP","HC-5BS-GRIP","HC-ROCK-GRIP","HC03BW","HC03W","HC33BW","HC73BWN","HCL-79","HD-1","HD-3","HD9","HEAL1465","HH-5X","HH205","HH35S","HH75W","HH905","HH905D","HH905N","HHBUSHWHACKERS","HHCATTAILS","HHCYCLOPS","HHDREAMCATCHERS","HHFANTOM","HHRHINO","HHRODEORIDER","HHS14X55C","HHSABERTOOTH","HK-2460-00","HM-A-GRIP","HM-B-GRIP","HP200B","HP200P","HP200PTW","HP30","HP600D","HP600DB","HP600DTW","HP600DTWB","HP900PN","HP900PSN","HP900PSV","HP900PSWN","HP900PWN","HP910LS","HP910LSW","HPD-20","HS03W","HS840","HT10S","HT130","HT430N","HT530B","HT730","HT730B","HWP-830","HWP-930","IE52KH6W-BOW","IP52KH6HC-BK-A","IP52KH6HC-HBK","IP52KH6NB-BOB","JAZZ-BRUSH","KD-A22-BD","KDB-200","KDM2","KEO-CYM-TAM","KIDP","KR-MINI","KR55PRO","KT-10","L-RODS","LHD-52","LMP1465F","LMP1465SC263","LMP1480SC227","LMPR1455SC431","LMPR1480SC726","LP1428NY","LP234C","LP441T-L","LP441T-M","LP441T-S","LPA1331CB","LSP146-WSS","LST1455H","M1330R","M4CB3","M4HP4","MCM1","MCT924XEDPC834","MCX1465SC800","MDT764PC704","MDY-10U","MDY-12","METAL","MF-3022-00","MP-CWH","MR1450","MS40DR","MULTIPADCLAMP","MUS1350M224","MUS1455M224","MVB3","MVB4","MVT1","MVT2","NE-1","NE-10","NITROKIT","NITROMESHKIT","NORD-DRUM","NSS1455","OHA1465STN","OP-TD1C","ORB-X-25W","ORB-X-30B","P-530","P-830","P-920","P-922","P-930","P-932","P121TW","P2002C","P3-1120-C2","P3-1322-10","P3-1324-BP","P7-0114-C2","P7-0314-C2","P900","PAC-10FC","PANP-1020","PBC-512TF","PBL-10","PBL-20","PBP","PBRSB-16-694","PBRSB-24-694","PBRSB-32-694","PBRSB-40-694","PBRSB-48-694","PBRSB-60-694","PBRSP-24-693","PBRSP-32-693","PBRSP-40-693","PBRSP-48-693","PBT-60","PC-8","PC-CB900","PCB-1030","PCJ-AWCSC652","PCJ-AWCSC657","PCWB-200A","PDS-10","PEARLVBAPINK","PFB-100610","PFR-14C","PGA-20","PGA50SF","PJH-10SH","PJW-140R508","PM-01","PM-03","PM-10","PM-100","PM-30","PM-TB4","PM-TB6","PMTBG","PP-1410-BE","PP-52","PPD-52","PPS-51","PPS-52","PPS-81","PRB-C20E","PRB-HW20","PRT-10","PS-0110-00","PS-0112-00","PS-0113-00","PS-0114-00","PS-0116-00","PS-0308-00","PS-0310-00","PS-0312-00","PS-0313-00","PS-0314-00","PS-0316-00","PS-0318-00","PS-1122-00","PS-1320-00","PS-1322-00","PS-1324-00","PTAMAL","PTM-10SH","PTT13","PW2BW","PW747W-R40","PWB-100511","PWB-100513","PWB-100DX521","PWB-100DX523","PWB-67","QCB22","QHC7","QS1HBK","QT-14SD","R5AAG","RAS1455","RBH535AW","RBH565AW","RBH595AW","RDH-100","RDH-120","RDP2561BLG","RDP2F56WBLG","RDT-SHV","REPAIRKIT","RF924","RFB1450","RFP924PC195","RHS-1R-2","RLS1455","RMH14X7NS","RMP-5","ROCK","ROCK-N","ROCKNVG","ROCKVG","RS505CC31","RS505CC707","RS525SCC31","RS525SCC706","RS525SCC729","RS525SCC91","RS525WFCC31","RSG-1","RT-30K","RT-MICS","RT500PLB","RTRTH1","RUTE","RUTE606","RW105","S-1030","S-150S","S-830","S-930","S52KH5C","SA-0114-00","SANDMAN","SBD-1055","SBS1455CR","SBS1455HA","SBS1455RB","SBX0F57NW","SBX2F57HA","SBX2F57NW","SBX2F57PW","SBX2F57RB","SC-0053","SC-1410WSS","SC-4248","SC-4400","SC-4402","SC-4420","SC-4420S","SC-4425B-1","SC-4425MB","SC-4471","SC-6608","SC-8CS","SC-9608","SC-BDHG","SC-CFL-4","SC-DPP","SC-DPTO","SC-DSDH","SC-DSLBE","SC-DSTO","SC-DTK","SC-FFT","SC-GDCP","SC-GDKBCO","SC-GPHP-4B","SC-GPHP-4C","SC-GPHP-4W","SC-GPHP-5B","SC-GPHP-5C","SC-GPHP-5W","SC-GPHP-6B","SC-GPHP-6C","SC-GPHP-6W","SC-GRSMC","SC-GRSSMC","SC-HF-PK","SC-HML1","SC-HML127","SC-HML34","SC-HML78","SC-HR1","SC-PC10","SC-PC13","SC-PTO","SC-RTL","SC-RTS","SC-SBE","SC-SDH","SC-USS","SCB2FS5","SCL-DSH1","SCL-DSH2","SCL-MIA","SCN2F5","SCN2FS5","SD1","SD12","SD2340","SDC","SEF11-1465SDW-13076","SFXCC08","SFXCC10","SG52KH6C-CSV","SG52KH6C-DB","SH01","SHAKER","SIH1","SIH2","SK52H","SK62HZBNS","SKM","SL52S","SM-1","SM-30","SMF11-STAGE2-11229","SN-0010-00","SN-0012-00","SN-0013-00","SN-0014-00","SN-0016-00","SN-1020-00","SN-1022-00","SPD-1W","SPD-30","SPD-S","SPD-SX","SPLIT-BRUSH","SPT-6PK","SRBLA","SS1455SBC","SSB360","SSF11","STB-BBK","STC-BBKD","STINGERS","STR","STRIKEKIT","SURGEMESHKIT","T-2531","T-890","T-900","TAB-208P-WD","TC-STK-29","TC-TAJ10","TC-TFAJ-10","TC-TFAJ-12","TC2000","TD-08R","TD-11K","TD-11KV","TD-12K","TD-12KVS","TD-12KXS","TD-12R","TD-15K","TD-15KV","TD-17K-LS","TD-17KVS","TD-17KVXS","TD-1DMK","TD-1K","TD-1KPX-S","TD-1KV","TD-25K-S","TD-30KS","TD-30KVS","TD-3KS","TD-3KWS","TD-4K2","TD-4KS","TD-4KX2","TD-4KXS","TD-50KV","TD-6K","TD-6KVF","TD-6KVS","TD-6KXS","TD-9K2","TD-9KS","TD-9KX","TD-9KX2","TDSB","TH-88B","TH-88S","TH-900I","TH945B","TIMBALES","TJR7","TM-1","TM-2","TM-6PRO","TM40","TM50","TMP047","TMP047RLS","TMP0F4","TMROCK","TR-09","TT14SO1","TTL10","TUNE-BOT","TUNE-BOT-GIG","TWAX","TX5AW-FG","TX5BW-FG","TXGKAWW","TXMP420XW-AG","TXPCW-RE","UGB620-2","UGB815-2","VA-0112-00","VA-0113-00","VB825P49","VBA826EXB479","VEP5AW","VEP5BW","VF-HB","VH3AW","VH7AN","VHP5AW","VICPACK","VKB1","VL52KS-DMF","VOLCAKICK","VSAS","VSHM","VSMFW","W575","WAVES","WD-X","WEDGIEKEY","WL-230A","XCARB-5A","XCARB-5B","XCARB-7A","Z5ACBU","Z5ACG","Z5ACP","Z5ACS","Z5ACWDGG","Z5ACWDGP","Z5ACWDGY","Z5ACWWRD","ZASJD","ZASJD2","ZASMM-ZLD","ZHH","ZSIGN1","ZT3255") AND brands_id=∨der=0