CREATE VIEW dbo.webMatDedup_TRI_LLO_PPP_Error_Report_O1 AS SELECT TOP (100) PERCENT zCheckwithingroup, zMatDedupID FROM dbo.ztMatDedup WHERE zConfirmed = 1 AND zActive = 1 AND (description LIKE '%[[]TRI]%' OR description LIKE '%[[]LLO]%' OR description LIKE '%[[]LLO%' OR LINK_CODE LIKE '%PPP%') AND isnull(zMatDedupID,'')<>''