BREADBOARD 2 STRIP 2.1X6.4IN 830 TIE POINTS - 9830N1

SELECT w.ID, w.SKU, w.PART_NO, w.SAYAL_PART_NO, w.SUB_PART_NO, w.CAT1, w.DESCRIPTION, w.DESCRIPTION2, w.ON_ORDER, w.LIST_P, w.REG_P, w.ALL_TOT, w.ON_HAND, w.QTY2, w.QTY3, w.QTY4, w.QTY5, w.QTY6, w.QTY7, w.QTY8, w.ACTION, w.REGULAR, w.SF, w.C, w.MFG, w.VENDOR, w.CIMG2, w.CLASS, w.SUB_CLASS, w.DFLAG, w.LFLAG, w.PERBAG, w.CDESCR, m.COMPANY_NAME, c.ID as CID, sc.ID as SCID, sc.CLASS_DESCR, sc.SUB_CLASS_DESCR, sc.GIDX, SPY.SHOPIFY, (w.ALL_TOT-w.ON_HAND) as StoreQTY, d.WEIGHT, CASE WHEN w.SFLAG = 'N' THEN 'N' ELSE 'Y' END AS SFLAG, /* was once used to over-ride reg price rhb.20210428 CASE WHEN ef.GroupEMAIL = 1 THEN ef.RegPrice ELSE 0 END AS 'REG_P', */ Specs.DOCPATH, Specs.MSDSPATH, Specs.MEMO, Specs.MEMO1 FROM webinv3 as w LEFT JOIN Classmast as c ON w.CLASS = c.CLASS LEFT JOIN Sclassmast as sc ON (w.CLASS = sc.CLASS) AND (w.SUB_CLASS = sc.SUB_CLASS) LEFT JOIN MFR_DIST_LINKS as m ON w.MFG = m.MFR LEFT JOIN Eflyer2003 as ef ON w.SKU = ef.SKU LEFT JOIN Specs ON w.SKU = Specs.SKU LEFT JOIN Dimensions as d ON w.SKU = d.SKU LEFT JOIN ( SELECT ZY.SKU, 'Y' AS SHOPIFY FROM webinv3 as ZY WHERE ZY.SFLAG <> 'N' AND ZY.SF not like 'EX' /*AND ZY.mfg not like 'mmFLUKE'*/ AND ZY.mfg not like 'CHANNL' AND ZY.mfg not like 'BEATS' AND ZY.CDESCR not like '%REFURB%' AND ZY.ALL_TOT > 0 ) AS SPY ON w.SKU = SPY.SKU WHERE w.SKU = :search_term BREADBOARD 2 STRIP 2.1X6.4IN 830 TIE POINTS - 9830N1 - SAYAL Electronics