WITH total88 AS (
SELECT t1.id, t4.Description AS prod, t3.Description, t2.Code, t1.Percentage, t2.Description AS [Accessory], t1.AccessoryID, t1.ProfilOption, t1.BooksGroups_ID, t1.Profil, t1.Ordinal, ISNULL(t3.IsSoldOut, 0) AS IsSoldOut, t2.Code2 AS [Code2], t4.Category_ID
FROM...