SELECT * FROM (SELECT a.ds_epc_hex AS EPCHex ,bl.id_biz_location      AS BizLocationID ,bl.na_friendly      AS BizLocation ,bl.ds_biz_location_type AS BizLocationType ,CASE WHEN bl.ds_biz_location_type = 'Door'    THEN (SELECT id_biz_location FROM biz_location WHERE id_biz_location = bl.id_biz_location_fk)    ELSE bl.id_biz_location END AS Bl_Aux_ID ,CASE WHEN bl.ds_biz_location_type = 'Door'    THEN (SELECT na_friendly FROM biz_location WHERE id_biz_location = bl.id_biz_location_fk)    ELSE bl.na_friendly END AS Bl_Aux ,CASE WHEN bl.ds_biz_location_type = 'Door'    THEN 'Cabinet'    ELSE bl.ds_biz_location_type END AS Bl_Aux_Type ,CASE WHEN DATEDIFF(DAY, GETDATE(), l.dt_expiry) < 1          THEN 1 WHEN DATEDIFF(DAY, GETDATE(), l.dt_expiry) BETWEEN 1 AND 30   THEN 2 WHEN DATEDIFF(DAY, GETDATE(), l.dt_expiry) BETWEEN 31 AND 60  THEN 3 WHEN DATEDIFF(DAY, GETDATE(), l.dt_expiry) BETWEEN 61 AND 90  THEN 4 WHEN DATEDIFF(DAY, GETDATE(), l.dt_expiry) BETWEEN 91 AND 180 THEN 5 WHEN DATEDIFF(DAY, GETDATE(), l.dt_expiry) > 180              THEN 6 END AS ExpiryID ,CASE WHEN DATEDIFF(DAY, GETDATE(), l.dt_expiry) < 1          THEN 'Vencido' WHEN DATEDIFF(DAY, GETDATE(), l.dt_expiry) BETWEEN 1 AND 30   THEN '0 à 30' WHEN DATEDIFF(DAY, GETDATE(), l.dt_expiry) BETWEEN 31 AND 60  THEN '31 à 60' WHEN DATEDIFF(DAY, GETDATE(), l.dt_expiry) BETWEEN 61 AND 90  THEN '61 à 90' WHEN DATEDIFF(DAY, GETDATE(), l.dt_expiry) BETWEEN 91 AND 180 THEN '91 à 180' WHEN DATEDIFF(DAY, GETDATE(), l.dt_expiry) > 180              THEN 'acima de 180' END AS Expiry ,CONVERT(VARCHAR(10), lot.dt_expiry, 103) AS DtExpiry ,pt.id_product_type AS ProductTypeID ,pt.ds_product_type AS ProductType ,pt.ds_reference    AS Reference ,d.id_disposition   AS DispositionID ,d.na_friendly      AS Disposition ,d.ds_uri           AS DispositionURI ,sup.id_supplier    AS SupplierID ,sup.ds_friendly    AS Supplier ,dis.id_distributor AS DistributorID ,dis.ds_distributor AS Distributor ,lot.id_lot         AS LotID ,lot.na_lot         AS Lot ,cas.dt_write       AS DtWrite FROM CURRENT_ASSET_STATE cas JOIN asset a         ON cas.id_asset_fk =        a.id_asset JOIN lot l           ON a.id_lot_fk =            l.id_lot JOIN product_type pt ON a.id_product_type_fk =   pt.id_product_type JOIN biz_location bl ON cas.id_biz_location_fk = bl.id_biz_location JOIN disposition d   ON cas.id_disposition_fk =  d.id_disposition JOIN distributor dis ON a.id_distributor_fk =    dis.id_distributor JOIN supplier sup    ON pt.id_supplier_fk =      sup.id_supplier JOIN lot lot         ON a.id_lot_fk =            lot.id_lot WHERE bl.fl_active = 1 AND bl.ds_biz_location_type IN ('Area', 'Door') AND bl.fl_is_internal = 'True' AND bl.id_biz_location IN (SELECT blu.id_biz_location_fk FROM biz_location_users blu WHERE blu.id_aspnet_user_fk = '0a12a04c-2030-4fa2-9e73-ffb38ce6b41c')) ds