select contentId, mainFolder, subFolder, fileName, '' imageURL, '' statusCode, '' gtin from tbl_FSC_Content where fileName like 'GS1%' and subfolder = 'PRD' and mainFolder = '#url.ownerType##url.ownerId#' select distinct gtin from qmd_content where statusCode <> '200 OK' order by gtin select s.skuId, s.sku from tbl_PRD_Skus s inner join tbl_PRD_Packaging p on p.linkId = s.skuId and p.linkType = 'SKU' and p.ownerId = s.ownerId and p.fsl_tablecode = s.fsl_tablecode where p.scc14 = and p.ownerId = and p.fsl_tablecode =

GTIN: #htmleditformat( GTIN )#, SKU: #htmleditformat( qmd_sku.sku )#