sql = SELECT f.rowid AS rowid1, fv.rowid AS rowid2, f.description AS desc1, fv.description AS desc2, f.OrderBy, fv.OrderBy, COUNT(*) AS total FROM SB_CatalogFilter f WITH (NOLOCK) INNER JOIN SB_CatalogFilter_Values fv WITH (NOLOCK) ON f.sb_id = fv.sb_id AND f.RowID = fv.CatalogFilter_RowID INNER JOIN SB_CatalogFilter_PropertiesAndValuesForProduct fpvp WITH (NOLOCK) ON f.sb_id = fpvp.sb_id AND fpvp.CatalogFilter_Values_RowID = fv.RowID AND fpvp.CatalogFilter_RowID = f.RowID INNER JOIN ( SELECT DISTINCT PicID FROM Cat_GalleryPic a WITH (NOLOCK) WHERE a.sb_id = 471170 AND (a.isShow IS NULL OR a.isShow <> 0) AND a.t1 = 4 AND a.t2 = 24 UNION SELECT DISTINCT b.PicID FROM Cat_ProductToCategories b WITH (NOLOCK) LEFT JOIN Cat_GalleryPic d WITH (NOLOCK) ON b.sb_id = d.sb_id AND b.PicID = d.PicID AND b.t1 = d.t1 AND b.t2 = d.t2 WHERE b.sb_id = 471170 AND b.t1 = 4 AND b.t2 = 24 AND (d.isShow IS NULL OR d.isShow <> 0)) validPics ON validPics.PicID = fpvp.Product_RowID INNER JOIN SB_CatalogFilter_PropertiesAndValuesForProduct s1 WITH (NOLOCK) ON s1.sb_id = 471170 AND s1.CatalogFilter_rowid = 1155 AND s1.CatalogFilter_Values_rowid = 18776 AND s1.Product_RowID = fpvp.Product_RowID WHERE f.sb_id = 471170 AND f.rowid <> 1155 GROUP BY f.rowid, fv.rowid, f.description, fv.description, f.OrderBy, fv.OrderBy ORDER BY f.OrderBy, f.rowid, fv.OrderBy