sql 20170918

SELECT * FROM  t_fb_widget_attr WHERE value <> 'form-control';SELECT *  FROM t_fb_widget WHERE id = '33f1259c-2616-490b-9a17-dd0c7775e06c';

Select     a.OrderLineNo as FLINENOTEXT,    a.SKU as FSKUTEXT,    d.Descr_C as FSKUDESCRTEXT,    d.Descr_E as FSKUDESCRTEXT_EN,    a.PackID as FPACKIDTEXT,    f.DEFAULTREPORTUOM as UOM,    T.DESCR as FUOMTEXT,    T.Qty as FQTYTEXT,    g.Location as FLOCIDTEXT,    h.PickZone as PLANTOZONE_TEXT,    c.LotAtt01 as FLOTATT01TEXT,    c.LotAtt02 as FLOTATT02TEXT,    c.LotAtt03 as FLOTATT03TEXT,    c.LotAtt04 as FLOTATT04TEXT,    c.LotAtt05 as FLOTATT05TEXT,    c.LotAtt06 as FLOTATT06TEXT,    c.LotAtt07 as FLOTATT07TEXT,    c.LotAtt08 as FLOTATT08TEXT,    c.LotAtt09 as FLOTATT09TEXT,    c.LotAtt10 as FLOTATT10TEXT,    c.LotAtt11 as FLOTATT11TEXT,    c.LotAtt12 as FLOTATT12TEXT,    a.UserDefine1 as DETAILUDF01TEXT,    a.UserDefine2 as DETAILUDF02TEXT,    a.UserDefine3 as DETAILUDF03TEXT,    a.UserDefine4 as DETAILUDF04TEXT,    a.UserDefine5 as DETAILUDF05TEXT,    e.UserDefine1 as HEADERUDF01TEXT,    e.UserDefine2 as HEADERUDF02TEXT,    e.UserDefine3 as HEADERUDF03TEXT,    e.UserDefine4 as HEADERUDF04TEXT,    e.UserDefine5 as HEADERUDF05TEXT,    a.Notes as FNOTESTEXT,    e.Notes as HEADERNOTESTEXT,    e.SOReference1 as REF01_TEXT,    e.SOReference2 as REF02_TEXT,    e.SOReference3 as REF03_TEXT,    e.SOReference4 as REF04_TEXT,    e.SOReference5 as REF05_TEXT,    d.Alternate_SKU1,    d.Alternate_SKU2,     d.Alternate_SKU3,     d.Alternate_SKU4,     d.Alternate_SKU5,    isnull(sum(g.Qty_Each)/T.Qty,0) as FQTYREQTEXT,    isnull(sum(g.Cubic),0) as FCUBICTEXT,    isnull(sum(g.GrossWeight),0) as FGROSSWTEXT,    e.OrderNo as ORDERNOTEXT,    e.CustomerID as CUSTOMERIDTEXT,    e.Door as DOORTEXT,    e.ConsigneeID as CONSIGNEEIDTEXT,    e.ConsigneeName as CONSIGNEENAMETEXT,    e.C_Address1 as CADDRESS1TEXT,    e.C_Contact as CCONTACT1TEXT,    e.C_Tel1 as CTELTEXT,    e.CarrierID as CARRIERTEXT,    e.CarrierName as SOCARRIERNAME,    e.CarrierAddress1 as CARRIERADDTEXT,    e.CarrierContact as CARRIERCONTEXT,    e.CarrierTel1 as CARRIERTELTEXT,    convert(char(16),e.RequiredDeliveryTime,120) as REQUIREDDELIVERYTIME,    convert(char(16),e.LastShipmentTime,120) as SHIPMENTTIMETEXT,    t1.CodeName_C as ORDERTYPE,    i.AlternativeSKU as UDFFIELD01,    i.AlternativeDescr_C as UDFFIELD02,    i.AlternativeDescr_E as UDFFIELD03,    i.UDF1 as UDFFIELD04,    e.EDITWHO as UDFFIELD05,    f.Descr_C as UDFFIELD06,    e.IssuePartyID as UDFFIELD07,    e.I_Address1 as UDFFIELD08,    e.H_EDI_01 as UDFFIELD09,    e.H_EDI_02 as UDFFIELD10,    e.H_EDI_03 as UDFFIELD11,    e.H_EDI_04 as UDFFIELD12,    e.H_EDI_05 as UDFFIELD13,    e.H_EDI_06 as UDFFIELD14,    e.H_EDI_07 as UDFFIELD15,    e.H_EDI_08 as UDFFIELD16,    e.H_EDI_09 as UDFFIELD17,    e.H_EDI_10 as UDFFIELD18,    d.SKU_Group1 as UDFFIELD19,    d.SKU_Group2 as UDFFIELD20,    d.SKU_Group3 as UDFFIELD21,    d.SKU_Group4 as UDFFIELD22,    d.SKU_Group5 as UDFFIELD23,    a.D_EDI_01 as UDFFIELD24,    a.D_EDI_02 as UDFFIELD25,    a.D_EDI_03 as UDFFIELD26,    a.D_EDI_04 as UDFFIELD27,    a.D_EDI_05 as UDFFIELD28,    a.D_EDI_06 as UDFFIELD29,    a.D_EDI_07 as UDFFIELD30,    a.D_EDI_08 as UDFFIELD31,    a.D_EDI_09 as UDFFIELD32,    a.D_EDI_10 as UDFFIELD33,    e.addtime as UDFFIELD34 From     ACT_Allocation_Details g LEFT JOIN DOC_Order_DETAILS a  on g.OrderNo = a.OrderNo AND g.OrderLineNO = a.OrderLineNo     LEFT OUTER JOIN BAS_Customer f ON f.CustomerID = a.CustomerID     LEFT JOIN BAS_SKU d ON d.customerid=a.customerid and d.sku=a.sku     LEFT JOIN INV_LOT_ATT c ON g.LotNum = c.LotNum     LEFT JOIN DOC_Order_Header e ON e.OrderNo =a.OrderNo     left join VIEW_COD_SO_TYP t1 on e.OrderType = t1.code     LEFT JOIN VIEW_UOM T on f.DEFAULTREPORTUOM = T.UOM and d.PACKID = T.PACKID     LEFT JOIN BAS_Location h ON g.Location =h.LocationID     left join BAS_AlternativeSKU i ON i.customerid=a.customerid and i.sku=a.sku and i.AlternativeCustomerID=e.ConsigneeID  Where g.OrderNo = 'J1107140013' and g.status >= '40' and  g.status <= '80' GROUP BY A.OrderLineNo,a.SKU,d.Descr_C,d.Descr_E,a.PackID,T.DESCR,T.Qty,a.QtyOrdered_EACH,    c.LotAtt01,c.LotAtt02,c.LotAtt03,c.LotAtt04,c.LotAtt05,c.LotAtt06,c.LotAtt07,c.LotAtt08,    c.LotAtt09,c.LotAtT10,c.LotAtt11,c.LotAtt12,e.SOReference1,e.SOReference2,e.SOReference3,    e.SOReference4,e.SOReference5,a.UserDefine1,a.UserDefine2,a.UserDefine3,a.UserDefine4,    a.UserDefine5,e.UserDefine1,e.UserDefine2,e.UserDefine3,e.UserDefine4,e.UserDefine5,    d.Alternate_SKU1,d.Alternate_SKU2, d.Alternate_SKU3, d.Alternate_SKU4, d.Alternate_SKU5,    e.Notes,a.Notes,e.OrderNo,t1.CodeName_C,e.CustomerID,e.ConsigneeID,e.ConsigneeName,    e.C_Address1,e.C_Contact,e.C_Tel1,e.CarrierID,e.CarrierName,e.CarrierAddress1,e.CarrierContact,    e.CarrierTel1,e.RequiredDeliveryTime,E.LastShipmentTime,g.Location,h.PickZone,f.DEFAULTREPORTUOM,    e.Door  ,i.AlternativeSKU,i.AlternativeDescr_C,i.AlternativeDescr_E,i.UDF1,e.EDITWHO,f.Descr_C,    e.IssuePartyID,e.I_Address1,e.H_EDI_01,e.H_EDI_02,e.H_EDI_03,e.H_EDI_04,e.H_EDI_05,e.H_EDI_06,    e.H_EDI_07,e.H_EDI_08,e.H_EDI_09,e.H_EDI_10,d.SKU_Group1,d.SKU_Group2,d.SKU_Group3,d.SKU_Group4,    d.SKU_Group5,a.D_EDI_01,a.D_EDI_02,a.D_EDI_03,a.D_EDI_04,a.D_EDI_05,a.D_EDI_06,a.D_EDI_07,    a.D_EDI_08,a.D_EDI_09,a.D_EDI_10,e.addtime  order by a.Orderlineno