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 Cat_GalleryPic a WITH (NOLOCK) ON a.sb_id = 471170 AND a.PicID = fpvp.Product_RowID AND (a.isShow IS NULL OR a.isShow <> 0) INNER JOIN SB_CatalogFilter_PropertiesAndValuesForProduct s1 WITH (NOLOCK) ON s1.sb_id = 471170 AND s1.CatalogFilter_rowid = 867 AND s1.CatalogFilter_Values_rowid = 12127 AND s1.Product_RowID = fpvp.Product_RowID WHERE f.sb_id = 471170 AND f.rowid <> 867 GROUP BY f.rowid, fv.rowid, f.description, fv.description, f.OrderBy, fv.OrderBy ORDER BY f.OrderBy, f.rowid, fv.OrderBy