query
	Img2ContentPath	Img2_contentPath
1	http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG2_10051500069612_C1C1_S01_JPG_50.JPG	http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG2_10051500069612_C1C1_S01_JPG_50.JPG

query
RESULTSET	query   IMG2CONTENTPATH 1 [empty string]
CACHED	false
EXECUTIONTIME	36
SQL	SELECT cImg2.imgPath + cImg2.ImgName + '_50' + cImg2.ImgExt AS Img2ContentPath FROM tbl_PRD_ProductImages p with (nolock) LEFT OUTER JOIN qry_ContentLookup cImg2 with (nolock) ON (p.Img2_ContentID = cImg2.contentid) WHERE p.FSL_TableCode = ? AND p.OwnerID = ? AND p.CatalogLevel = ? AND p.Code = ?;
SQLPARAMETERS	array 1 MFR 2 26 3 SKU 4 5150006961

query
	Img2ContentPath	Img2_FileExt	Img2_FileSize	Img2_comment	Img2_contentId	Img2_contentPath	Img2_uploadDate	imageCode	imageURL
1	http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG2_10051500069612_C1C1_S01_JPG_50.JPG	.JPG	228115	GS1 PRODUCT IMAGE	30184447	http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG2_10051500069612_C1C1_S01_JPG_50.JPG	2026-04-10 09:35:45.0	Img2	http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG2_10051500069612_C1C1_S01_JPG_50.JPG

query
RESULTSET	query   IMAGEURL IMG2_COMMENT IMG2_CONTENTID IMG2_FILEEXT IMG2_FILESIZE IMG2_UPLOADDATE
CACHED	false
EXECUTIONTIME	14
SQL	SELECT c.imgPath + fc.fileName AS imageURL , i.Img2_FileSize, i.Img2_FileExt, i.Img2_UploadDate, i.Img2_ContentID, i.Img2_Comment FROM tbl_PRD_ProductImages i with (nolock) INNER JOIN qry_ContentLookup c with (nolock) ON i.Img2_ContentID = c.ContentID INNER JOIN tbl_FSC_Content fc with (nolock) ON fc.contentId = c.contentId WHERE i.FSL_TableCode = ? AND i.OwnerID = 26 AND i.Code = '5150006961' AND i.CatalogLevel = 'SKU'
SQLPARAMETERS	array 1 MFR

query
RESULTSET	query   CONTENTID FILECONTENTHASH IMAGEURL IMGCAPTION IMGTYPE LEVEL PROVIDERURL SORTRANK 1 27211138 3F322D785E8B1038A0B28B053A2EE341 http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG1_10051500069612_C1C1_JPG_50.JPG GS1 PRODUCT IMAGE IMG1 SKU https://d2vppzocvtms05.cloudfront.net/media/D7C455BB-CDB8-4171-BAB472EBF9038DEF/7F036FB9-A126-4528-838A29F5D65E09AB/7399B41F-CFBB-4B74-B49CDA68F1AD359C/High_Res-10051500069612_C1C1_PIM.jpg 10 2 30184447 4BDBA3CE9DAE630B80764B34BE2A4002 http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG2_10051500069612_C1C1_S01_JPG_50.JPG GS1 PRODUCT IMAGE IMG2 SKU https://assetportal.jmsmucker.com/asset/7ef16a84-d865-4957-a83f-fc24a9a4d517/High_Res/10051500069612_C1C1_s01_PIM.jpg 20 3 28442734 886EC153EC23FBB91504AB4159F9B451 http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG3_10051500069612_D1CF_JPG_50.JPG GS1 PRODUCT IMAGE IMG3 SKU https://d2vppzocvtms05.cloudfront.net/media/D7C455BB-CDB8-4171-BAB472EBF9038DEF/37DCB9B7-ED9C-4C6C-ABFE4C98F1D5614F/83084654-B0DD-43DC-AE077C03ACD55857/High_Res-10051500069612_D1CF_PIM.jpg 30 4 28442737 E311302CE56AAD4E7018F89AFA0D5AFD http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG4_10051500069612_A1C0_JPG_50.JPG GS1 PRODUCT IMAGE IMG4 SKU https://d2vppzocvtms05.cloudfront.net/media/D7C455BB-CDB8-4171-BAB472EBF9038DEF/89385A33-482D-4810-8C37E7A65B17C0EC/CA71207A-ABAE-492A-BE76A1F0233A27E8/High_Res-10051500069612_A1C0_PIM.jpg 40 5 28442738 26F15658CE920148D5A533CB86F10705 http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG5_10051500069612_C1RM_JPG_50.JPG GS1 PRODUCT IMAGE IMG5 SKU https://d2vppzocvtms05.cloudfront.net/media/D7C455BB-CDB8-4171-BAB472EBF9038DEF/2F06EB60-BAC4-4C87-B9F633E62DD5A395/777728AA-F449-4961-AE407CD3B58B26C3/High_Res-10051500069612_C1RM_PIM.jpg 50 6 30184449 450083828DFF080063DCEF2300AC0CFD http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_MSTRPKG_10051500069612_C1RM_JPG_50.JPG GS1 PRODUCT IMAGE MSTR SKU https://assetportal.jmsmucker.com/asset/0ae9f0b6-0c9e-440a-bf9e-3d3342f4741c/High_Res/10051500069612_C1RM_PIM.jpg 50 7 30184450 AEC0A2ECAC8FC217E17505A1BFAC00FF http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_UNITPKG_10051500069612_C1R1_JPG_50.JPG GS1 PRODUCT IMAGE UNIT SKU https://assetportal.jmsmucker.com/asset/33dcb505-f22e-408d-85e4-9f38e7f73993/High_Res/10051500069612_C1R1_PIM.jpg 60 8 28442740 6A6F0FC43568FBAD4D64E6E3F8DD1A4E http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG6_10051500069612_C1L1_JPG_50.JPG GS1 PRODUCT IMAGE IMG6 SKU https://d2vppzocvtms05.cloudfront.net/media/D7C455BB-CDB8-4171-BAB472EBF9038DEF/70E92A85-9C4A-4953-97F03905649DD963/ABF85BD7-650C-417A-A9D04AA2B7F0D3D0/High_Res-10051500069612_C1L1_PIM.jpg 60 9 28442741 988586962D01D9108D68EEA7C55134D9 http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG7_10051500069612_C1R1_JPG_50.JPG GS1 PRODUCT IMAGE IMG7 SKU https://d2vppzocvtms05.cloudfront.net/media/D7C455BB-CDB8-4171-BAB472EBF9038DEF/CB641BD4-D38D-4B7A-BE9954F2DEF14C08/DC099E64-A265-40C5-A812CD6FCE5B957D/High_Res-10051500069612_C1R1_PIM.jpg 70 10 30184448 99D58C24A21DA6A2445A989862838B30 http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_SUBPKG_10051500069612_M2_JPG_50.JPG GS1 PRODUCT IMAGE SUB SKU https://assetportal.jmsmucker.com/asset/01402efe-7b14-4ca2-90b1-d4f4358126a9/High_Res/10051500069612_M2_PIM.jpg 70 11 28442743 8E8BCE886B0939FC47D132A42D1635E5 http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG8_10051500069612_C1LM_JPG_50.JPG GS1 PRODUCT IMAGE IMG8 SKU https://d2vppzocvtms05.cloudfront.net/media/D7C455BB-CDB8-4171-BAB472EBF9038DEF/D29C18C4-47EF-4991-BAB95C7CCC50F810/C647C489-8C7A-4EE1-867238D23A5C92EF/High_Res-10051500069612_C1LM_PIM.jpg 80 12 28442744 878BF45CC1E8D8F57B00E7AB02F3BAA2 http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG9_10051500069612_C1CM_JPG_50.JPG GS1 PRODUCT IMAGE IMG9 SKU https://d2vppzocvtms05.cloudfront.net/media/D7C455BB-CDB8-4171-BAB472EBF9038DEF/AFD3A989-3C28-493C-94DADF7E23029DB9/660D7EF8-4AF2-46B3-93DDF61B33B0109E/High_Res-10051500069612_C1CM_PIM.jpg 90 13 28442746 36CDE031D25EEE25102E12BF483A7D6C http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG10_10051500069612_M2_JPG_50.JPG GS1 PRODUCT IMAGE IMG10 SKU https://d2vppzocvtms05.cloudfront.net/media/D7C455BB-CDB8-4171-BAB472EBF9038DEF/EB5FA50B-4F2A-48C2-A98D34F683697CB2/9BBCE8A8-9758-43B7-A968C0E188819808/High_Res-10051500069612_M2_PIM.jpg 100
CACHED	false
EXECUTIONTIME	49
SQL	select case when i.imageCode = 'IMG1' then 10 when i.imageCode = 'IMG2' then 20 when i.imageCode = 'IMG3' then 30 when i.imageCode = 'IMG4' then 40 when i.imageCode = 'IMG5' then 50 when i.imageCode = 'IMG6' then 60 when i.imageCode = 'IMG7' then 70 when i.imageCode = 'IMG8' then 80 when i.imageCode = 'IMG9' then 90 when i.imageCode = 'IMG10' then 100 when i.imageCode = 'LABEL' then 45 when i.imageCode = 'MSTRPKG' then 50 when i.imageCode = 'UNITPKG' then 60 when i.imageCode = 'SUBPKG' then 70 when i.imageCode = 'OUTOFPACKAGE' then 80 else 200 end as sortRank, i.linkType as level, case when i.imageCode = 'MSTRPKG' then 'MSTR' when i.imageCode = 'SUBPKG' then 'SUB' when i.imageCode = 'UNITPKG' then 'UNIT' when i.imageCode = 'LABEL' then 'LBL' when i.imageCode = 'OUTOFPACKAGE' then 'OUTOFBOX' else upper( i.imageCode ) end as imgType, i.contentId, 'http://doclibrary.com/' + c.mainFolder + '/' + c.subFolder + '/' + c.fileName as imageURL, i.comment as imgCaption, fileContentHash, providerurl from tbl_PRD_Images i with (nolock) inner join tbl_PRD_SKus s with (nolock) on s.skuId = i.linkId and s.ownerId = i.ownerId and s.fsl_tablecode = i.ownerType and s.sku = ? inner join tbl_FSC_Content c with (nolock) on c.contentId = i.contentId where i.ownerId = ? and i.ownerType = ? and i.linkType = ? and i.fileExt in ( ?,?,?,?,?,?,? ) and i.imageCode in ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ) order by sortRank
SQLPARAMETERS	array 1 5150006961 2 26 3 MFR 4 SKU 5 .jpg 6 .jpeg 7 .png 8 .gif 9 .tif 10 tiff 11 .bmp 12 Img1 13 Img2 14 Img3 15 Img4 16 Img5 17 Img6 18 Img7 19 Img8 20 Img9 21 Img10 22 Label 23 MstrPkg 24 UnitPkg 25 SubPkg 26 OutOfPackage 27 FactPanel

query
RESULTSET	query   CONTENTID IMAGEURL IMGCAPTION IMGTYPE LEVEL SORTRANK
CACHED	false
EXECUTIONTIME	263
SQL	select 10 as sortrank, 'SKU' as level, 'IMG1' as imgtype, Img1_ContentID as contentid, cl.imgPath + c.fileName AS imageURL, Img1_Comment as imgCaption from tbl_PRD_ProductImages prd inner join qry_ContentLookup cl with (nolock) on prd.Img1_ContentID = cl.ContentID and cl.ContentID <> 755 and cl.ImgExt in ( '.jpg','.jpeg','.png','.gif','.tif','tiff','.bmp' ) inner join tbl_FSC_Content c on c.contentId = cl.contentId where CatalogLevel = 'sku' and Code = '5150006961' and ownerid = 26 and fsl_tablecode = 'MFR' union select 20 as sortrank, 'SKU' as level, 'IMG2' as imgtype, Img2_ContentID as contentid, cl.imgPath + c.fileName AS imageURL, Img2_Comment as imgCaption from tbl_PRD_ProductImages prd with (nolock) inner join qry_ContentLookup cl on prd.Img2_ContentID = cl.ContentID and cl.ContentID <> 755 and cl.ImgExt in ( '.jpg','.jpeg','.png','.gif','.tif','tiff','.bmp' ) inner join tbl_FSC_Content c on c.contentId = cl.contentId where CatalogLevel = 'sku' and Code = '5150006961' and ownerid = 26 and fsl_tablecode = 'MFR' union select 30 as sortrank, 'SKU' as level, 'IMG3' as imgtype, Img3_ContentID as contentid, cl.imgPath + c.fileName AS imageURL, Img3_Comment as imgCaption from tbl_PRD_ProductImages prd with (nolock) inner join qry_ContentLookup cl on prd.Img3_ContentID = cl.ContentID and cl.ContentID <> 755 and cl.ImgExt in ( '.jpg','.jpeg','.png','.gif','.tif','tiff','.bmp' ) inner join tbl_FSC_Content c on c.contentId = cl.contentId where CatalogLevel = 'sku' and Code = '5150006961' and ownerid = 26 and fsl_tablecode = 'MFR' union select 40 as sortrank, 'SKU' as level, 'IMG4' as imgtype, Img4_ContentID as contentid, cl.imgPath + c.fileName AS imageURL, Img4_Comment as imgCaption from tbl_PRD_ProductImages prd with (nolock) inner join qry_ContentLookup cl on prd.Img4_ContentID = cl.ContentID and cl.ContentID <> 755 and cl.ImgExt in ( '.jpg','.jpeg','.png','.gif','.tif','tiff','.bmp' ) inner join tbl_FSC_Content c on c.contentId = cl.contentId where CatalogLevel = 'sku' and Code = '5150006961' and ownerid = 26 and fsl_tablecode = 'MFR' union select 50 as sortrank, 'SKU' as level, 'IMG5' as imgtype, Img5_ContentID as contentid, cl.imgPath + c.fileName AS imageURL, Img5_Comment as imgCaption from tbl_PRD_ProductImages prd with (nolock) inner join qry_ContentLookup cl on prd.Img5_ContentID = cl.ContentID and cl.ContentID <> 755 and cl.ImgExt in ( '.jpg','.jpeg','.png','.gif','.tif','tiff','.bmp' ) inner join tbl_FSC_Content c on c.contentId = cl.contentId where CatalogLevel = 'sku' and Code = '5150006961' and ownerid = 26 and fsl_tablecode = 'MFR' union select 60 as sortrank, 'SKU' as level, 'IMG6' as imgtype, Img6_ContentID as contentid, cl.imgPath + c.fileName AS imageURL, Img6_Comment as imgCaption from tbl_PRD_ProductImages prd with (nolock) inner join qry_ContentLookup cl on prd.Img6_ContentID = cl.ContentID and cl.ContentID <> 755 and cl.ImgExt in ( '.jpg','.jpeg','.png','.gif','.tif','tiff','.bmp' ) inner join tbl_FSC_Content c on c.contentId = cl.contentId where CatalogLevel = 'sku' and Code = '5150006961' and ownerid = 26 and fsl_tablecode = 'MFR' union select 70 as sortrank, 'SKU' as level, 'IMG7' as imgtype, Img7_ContentID as contentid, cl.imgPath + c.fileName AS imageURL, Img7_Comment as imgCaption from tbl_PRD_ProductImages prd with (nolock) inner join qry_ContentLookup cl on prd.Img7_ContentID = cl.ContentID and cl.ContentID <> 755 and cl.ImgExt in ( '.jpg','.jpeg','.png','.gif','.tif','tiff','.bmp' ) inner join tbl_FSC_Content c on c.contentId = cl.contentId where CatalogLevel = 'sku' and Code = '5150006961' and ownerid = 26 and fsl_tablecode = 'MFR' union select 80 as sortrank, 'SKU' as level, 'IMG8' as imgtype, Img8_ContentID as contentid, cl.imgPath + c.fileName AS imageURL, Img8_Comment as imgCaption from tbl_PRD_ProductImages prd with (nolock) inner join qry_ContentLookup cl on prd.Img8_ContentID = cl.ContentID and cl.ContentID <> 755 and cl.ImgExt in ( '.jpg','.jpeg','.png','.gif','.tif','tiff','.bmp' ) inner join tbl_FSC_Content c on c.contentId = cl.contentId where CatalogLevel = 'sku' and Code = '5150006961' and ownerid = 26 and fsl_tablecode = 'MFR' union select 90 as sortrank, 'SKU' as level, 'IMG9' as imgtype, Img9_ContentID as contentid, cl.imgPath + c.fileName AS imageURL, Img9_Comment as imgCaption from tbl_PRD_ProductImages prd with (nolock) inner join qry_ContentLookup cl on prd.Img9_ContentID = cl.ContentID and cl.ContentID <> 755 and cl.ImgExt in ( '.jpg','.jpeg','.png','.gif','.tif','tiff','.bmp' ) inner join tbl_FSC_Content c on c.contentId = cl.contentId where CatalogLevel = 'sku' and Code = '5150006961' and ownerid = 26 and fsl_tablecode = 'MFR' union select 100 as sortrank, 'SKU' as level, 'IMG10' as imgtype, Img10_ContentID as contentid, cl.imgPath + c.fileName AS imageURL, Img10_Comment as imgCaption from tbl_PRD_ProductImages prd with (nolock) inner join qry_ContentLookup cl on prd.Img10_ContentID = cl.ContentID and cl.ContentID <> 755 and cl.ImgExt in ( '.jpg','.jpeg','.png','.gif','.tif','tiff','.bmp' ) inner join tbl_FSC_Content c on c.contentId = cl.contentId where CatalogLevel = 'sku' and Code = '5150006961' and ownerid = 26 and fsl_tablecode = 'MFR' union select 45 as sortrank, 'SKU' as level, 'LBL' as imgtype, Label_ContentID as contentid, cl.imgPath + c.fileName AS imageURL, Label_Comment as imgCaption from tbl_PRD_ProductImages prd with (nolock) inner join qry_ContentLookup cl on prd.Label_ContentID = cl.ContentID and cl.ContentID <> 755 and cl.ImgExt in ( '.jpg','.jpeg','.png','.gif','.tif','tiff','.bmp' ) inner join tbl_FSC_Content c on c.contentId = cl.contentId where CatalogLevel = 'sku' and Code = '5150006961' and ownerid = 26 and fsl_tablecode = 'MFR' union select 50 as sortrank, 'SKU' as level, 'MSTR' as imgtype, MstrPkg_ContentID as contentid, cl.imgPath + c.fileName AS imageURL, MstrPkg_Comment as imgCaption from tbl_PRD_ProductImages prd with (nolock) inner join qry_ContentLookup cl on prd.MstrPkg_ContentID = cl.ContentID and cl.ContentID <> 755 and cl.ImgExt in ( '.jpg','.jpeg','.png','.gif','.tif','tiff','.bmp' ) inner join tbl_FSC_Content c on c.contentId = cl.contentId where CatalogLevel = 'sku' and Code = '5150006961' and ownerid = 26 and fsl_tablecode = 'MFR' union select 60 as sortrank, 'SKU' as level, 'UNIT' as imgtype, UnitPkg_ContentID as contentid, cl.imgPath + c.fileName AS imageURL, UnitPkg_Comment as imgCaption from tbl_PRD_ProductImages prd with (nolock) inner join qry_ContentLookup cl on prd.UnitPkg_ContentID = cl.ContentID and cl.ContentID <> 755 and cl.ImgExt in ( '.jpg','.jpeg','.png','.gif','.tif','tiff','.bmp' ) inner join tbl_FSC_Content c on c.contentId = cl.contentId where CatalogLevel = 'sku' and Code = '5150006961' and ownerid = 26 and fsl_tablecode = 'MFR' union select 70 as sortrank, 'SKU' as level, 'SUB' as imgtype, SubPkg_ContentID as contentid, cl.imgPath + c.fileName AS imageURL, SubPkg_Comment as imgCaption from tbl_PRD_ProductImages prd with (nolock) inner join qry_ContentLookup cl on prd.SubPkg_ContentID = cl.ContentID and cl.ContentID <> 755 and cl.ImgExt in ( '.jpg','.jpeg','.png','.gif','.tif','tiff','.bmp' ) inner join tbl_FSC_Content c on c.contentId = cl.contentId where CatalogLevel = 'sku' and Code = '5150006961' and ownerid = 26 and fsl_tablecode = 'MFR' union select 80 as sortrank, 'SKU' as level, 'OUTOFBOX' as imgtype, SubPkg_ContentID as contentid, cl.imgPath + c.fileName AS imageURL, SubPkg_Comment as imgCaption from tbl_PRD_ProductImages prd with (nolock) inner join qry_ContentLookup cl on prd.OutOfPackage_ContentID = cl.ContentID and cl.ContentID <> 755 and cl.ImgExt in ( '.jpg','.jpeg','.png','.gif','.tif','tiff','.bmp' ) inner join tbl_FSC_Content c on c.contentId = cl.contentId where CatalogLevel = 'sku' and Code = '5150006961' and ownerid = 26 and fsl_tablecode = 'MFR' order by sortrank

query
RESULTSET	query   IMGCOMMENTS IMGURL PRODID SHORTDESC 1 [empty string] http://doclibrary.com/generic/UTL/clearpixel.gif 174522 All Products 2 [empty string] http://doclibrary.com/generic/UTL/clearpixel.gif 120335 Jam 3 [empty string] http://doclibrary.com/generic/UTL/clearpixel.gif 120336 Jelly
CACHED	false
EXECUTIONTIME	80
SQL	SELECT distinct p.prodID, p.shortDesc , coalesce( ( select top 1 'http://doclibrary.com/' + c.mainFolder + '/' + c.subFolder + '/' + c.fileName from tbl_PRD_Images i with (nolock) inner join tbl_FSC_Content c with (nolock) on c.contentId = i.contentId where i.linkId = p.prodId and i.linkType = 'PRD' and i.imageCode = 'IMG1' and i.ownerId = p.ownerId and i.ownerType = p.fsl_tablecode order by i.uploadDate ), 'http://doclibrary.com/generic/UTL/clearpixel.gif' ) as imgURL , ( select top 1 i.comment from tbl_PRD_Images i with (nolock) where i.linkId = p.prodId and i.linkType = 'PRD' and i.imageCode = 'IMG1' and i.ownerId = p.ownerId and i.ownerType = p.fsl_tablecode order by i.uploadDate ) as imgComments FROM tbl_PRD_Products p , tbl_PRD_SKUs s LEFT OUTER JOIN tbl_PRD_CustomerSkus cs ON s.sku = cs.sku AND cs.LinkType = 'sku' AND cs.OwnerID = 26 AND cs.FSL_TableCode = 'MFR' WHERE p.OwnerID = 26 AND p.FSL_TableCode = 'MFR' AND p.unpublishDate >= {d '2026-04-17'} AND p.inactive = 0 AND {d '2026-04-17'} >= p.publishdate AND p.ProdID = s.ProdID AND s.OwnerID = 26 AND s.FSL_TableCode = 'MFR' AND s.inactive = '0' AND s.discontinued = 'N' AND (s.unpublishDate >= {d '2026-04-17'} AND {d '2026-04-17'} >= s.publishdate) AND (rtrim(s.PrivateLabelType) = '' OR s.PrivateLabelType IS NULL OR s.PrivateLabelType = 'MFR') AND (p.product LIKE ? OR p.shortdesc LIKE ? OR p.longdesc LIKE ? OR s.sku LIKE ? OR s.skuDesc LIKE ? OR cs.customerSku LIKE ? ) ORDER BY p.shortDesc
SQLPARAMETERS	array 1 %JELLY% 2 %JELLY% 3 %JELLY% 4 %JELLY% 5 %JELLY% 6 %JELLY%

query
RESULTSET	query   IMGURL PRODID SHORTDESC 1 [empty string] 174522 All Products 2 [empty string] 120335 Jam 3 [empty string] 120336 Jelly
CACHED	false
EXECUTIONTIME	90
SQL	SELECT distinct p.prodID, p.shortDesc , imgURL = (SELECT TOP 1 c.imgPath + c.ImgName + '_100' + c.ImgExt AS imageURL FROM tbl_PRD_ProductImages i inner join qry_ContentLookup c ON i.Img1_ContentID = c.ContentID WHERE i.OwnerID = 26 AND i.FSL_TableCode = 'MFR' AND i.Code = p.product AND i.CatalogLevel = 'PRD' ORDER BY i.Img1_UploadDate) FROM tbl_PRD_Products p , tbl_PRD_SKUs s LEFT OUTER JOIN tbl_PRD_CustomerSkus cs ON s.sku = cs.sku AND cs.LinkType = 'sku' AND cs.OwnerID = 26 AND cs.FSL_TableCode = 'MFR' WHERE p.OwnerID = 26 AND p.FSL_TableCode = 'MFR' AND p.unpublishDate >= {d '2026-04-17'} AND p.inactive = 0 AND {d '2026-04-17'} >= p.publishdate AND p.ProdID = s.ProdID AND s.OwnerID = 26 AND s.FSL_TableCode = 'MFR' AND s.inactive = '0' AND s.discontinued = 'N' AND (s.unpublishDate >= {d '2026-04-17'} AND {d '2026-04-17'} >= s.publishdate) AND (rtrim(s.PrivateLabelType) = '' OR s.PrivateLabelType IS NULL OR s.PrivateLabelType = 'MFR') AND (p.product LIKE ? OR p.shortdesc LIKE ? OR p.longdesc LIKE ? OR s.sku LIKE ? OR s.skuDesc LIKE ? OR cs.customerSku LIKE ? ) ORDER BY p.shortDesc
SQLPARAMETERS	array 1 %JELLY% 2 %JELLY% 3 %JELLY% 4 %JELLY% 5 %JELLY% 6 %JELLY%

query
RESULTSET	query   IMGURL MAXORDERQTY PRD_CONTENTID SKU SKUDESC SKUID 1 http://doclibrary.com/MFR26/PRD/GS1_10051500001629_PRODUCT_IMG1_10051500001629_L2_JPG.JPG [empty string] 29030435 5150000162 Smucker's 32 Ounce Grape Jelly 12 Count Case 23865 2 http://doclibrary.com/MFR26/PRD/GS1_10051500001629_PRODUCT_IMG1_10051500001629_L2_JPG.JPG [empty string] 29030435 5150000162 Smucker's 32 Ounce Grape Jelly 12 Count Case 23865 3 http://doclibrary.com/MFR26/PRD/GS1_10051500001629_PRODUCT_IMG1_10051500001629_L2_JPG.JPG [empty string] 29030435 5150000162 Smucker's 32 Ounce Grape Jelly 12 Count Case 23865 4 [empty string] [empty string] [empty string] 5150000326 SM 4 LB CURRANT JELLY 1874596 5 [empty string] [empty string] [empty string] 5150000326 SM 4 LB CURRANT JELLY 1874596 6 [empty string] [empty string] [empty string] 5150000326 SM 4 LB CURRANT JELLY 1874596 7 [empty string] [empty string] [empty string] 5150000326 SM 4 LB CURRANT JELLY 1874596 8 [empty string] [empty string] [empty string] 5150000326 SM 4 LB CURRANT JELLY 1874596 9 [empty string] [empty string] [empty string] 5150000328 SM 4 LB GRAPE JELLY 23861 10 [empty string] [empty string] [empty string] 5150000328 SM 4 LB GRAPE JELLY 23861 11 [empty string] [empty string] [empty string] 5150000328 SM 4 LB GRAPE JELLY 23861 12 [empty string] [empty string] [empty string] 5150000328 SM 4 LB GRAPE JELLY 23861 13 [empty string] [empty string] [empty string] 5150000328 SM 4 LB GRAPE JELLY 23861 14 http://doclibrary.com/MFR26/PRD/GS1_10051500003388_PRODUCT_IMG1_10051500003388_A1CB_JPG.JPG [empty string] 23679615 5150000338 Smucker's 10 Tin Grape Jelly 23856 15 http://doclibrary.com/MFR26/PRD/GS1_10051500003388_PRODUCT_IMG1_10051500003388_A1CB_JPG.JPG [empty string] 23679615 5150000338 Smucker's 10 Tin Grape Jelly 23856 16 http://doclibrary.com/MFR26/PRD/GS1_10051500003388_PRODUCT_IMG1_10051500003388_A1CB_JPG.JPG [empty string] 23679615 5150000338 Smucker's 10 Tin Grape Jelly 23856 17 http://doclibrary.com/MFR26/PRD/GS1_10051500003388_PRODUCT_IMG1_10051500003388_A1CB_JPG.JPG [empty string] 23679615 5150000338 Smucker's 10 Tin Grape Jelly 23856 18 http://doclibrary.com/MFR26/PRD/GS1_10051500003388_PRODUCT_IMG1_10051500003388_A1CB_JPG.JPG [empty string] 23679615 5150000338 Smucker's 10 Tin Grape Jelly 23856 19 http://doclibrary.com/MFR26/PRD/GS1_10051500006907_PRODUCT_IMG1_00051500006900_C1C1_JPG.JPG [empty string] 24823653 5150000690 Smucker's 18 Ounce Apple Jelly 1873527 20 [empty string] [empty string] [empty string] 5150000693 Smucker's 18 Ounce Grape Jelly 1873529 21 [empty string] [empty string] [empty string] 5150000693 Smucker's 18 Ounce Grape Jelly 1873529 22 http://doclibrary.com/MFR26/PRD/GS1_10051500006969_PRODUCT_IMG1_00051500006962_C1C1_JPG.JPG [empty string] 24824027 5150000696 Smucker's 18 Ounce Strawberry Jelly 12 Count Case 3586020 23 http://doclibrary.com/MFR26/PRD/GS1_00051500007600_PRODUCT_IMG1_00051500007600_D1CF_JPG.JPG [empty string] 27802995 5150000760 Smucker's 1/2 Ounce Apple Jelly Plastic 200 Count Case 23885 24 http://doclibrary.com/MFR26/PRD/GS1_00051500007600_PRODUCT_IMG1_00051500007600_D1CF_JPG.JPG [empty string] 27802995 5150000760 Smucker's 1/2 Ounce Apple Jelly Plastic 200 Count Case 23885 25 http://doclibrary.com/MFR26/PRD/GS1_00051500007600_PRODUCT_IMG1_00051500007600_D1CF_JPG.JPG [empty string] 27802995 5150000760 Smucker's 1/2 Ounce Apple Jelly Plastic 200 Count Case 23885 26 http://doclibrary.com/MFR26/PRD/GS1_00051500007600_PRODUCT_IMG1_00051500007600_D1CF_JPG.JPG [empty string] 27802995 5150000760 Smucker's 1/2 Ounce Apple Jelly Plastic 200 Count Case 23885 27 http://doclibrary.com/MFR26/PRD/GS1_00051500007600_PRODUCT_IMG1_00051500007600_D1CF_JPG.JPG [empty string] 27802995 5150000760 Smucker's 1/2 Ounce Apple Jelly Plastic 200 Count Case 23885 28 http://doclibrary.com/MFR26/PRD/GS1_00051500007600_PRODUCT_IMG1_00051500007600_D1CF_JPG.JPG [empty string] 27802995 5150000760 Smucker's 1/2 Ounce Apple Jelly Plastic 200 Count Case 23885 29 http://doclibrary.com/MFR26/PRD/GS1_00051500007648_PRODUCT_IMG1_00051500007648_C1C1_JPG.JPG [empty string] 24775519 5150000764 SMUCKER 1/2 OUNCE GRAPE JELLY PLASTIC 200 Count Case 23888 30 http://doclibrary.com/MFR26/PRD/GS1_00051500007648_PRODUCT_IMG1_00051500007648_C1C1_JPG.JPG [empty string] 24775519 5150000764 SMUCKER 1/2 OUNCE GRAPE JELLY PLASTIC 200 Count Case 23888 31 http://doclibrary.com/MFR26/PRD/GS1_00051500007648_PRODUCT_IMG1_00051500007648_C1C1_JPG.JPG [empty string] 24775519 5150000764 SMUCKER 1/2 OUNCE GRAPE JELLY PLASTIC 200 Count Case 23888 32 http://doclibrary.com/MFR26/PRD/GS1_00051500007648_PRODUCT_IMG1_00051500007648_C1C1_JPG.JPG [empty string] 24775519 5150000764 SMUCKER 1/2 OUNCE GRAPE JELLY PLASTIC 200 Count Case 23888 33 http://doclibrary.com/MFR26/PRD/GS1_00051500007648_PRODUCT_IMG1_00051500007648_C1C1_JPG.JPG [empty string] 24775519 5150000764 SMUCKER 1/2 OUNCE GRAPE JELLY PLASTIC 200 Count Case 23888 34 http://doclibrary.com/MFR26/PRD/GS1_00051500007648_PRODUCT_IMG1_00051500007648_C1C1_JPG.JPG [empty string] 24775519 5150000764 SMUCKER 1/2 OUNCE GRAPE JELLY PLASTIC 200 Count Case 23888 35 http://doclibrary.com/MFR26/PRD/GS1_00051500007655_PRODUCT_IMG1_00051500007655_C8N1_JPG.JPG [empty string] 27803837 5150000765 Smucker's 1/2 Ounce Mixed Fruit Jelly Plastic 200 Count Case 23889 36 http://doclibrary.com/MFR26/PRD/GS1_00051500007655_PRODUCT_IMG1_00051500007655_C8N1_JPG.JPG [empty string] 27803837 5150000765 Smucker's 1/2 Ounce Mixed Fruit Jelly Plastic 200 Count Case 23889 37 http://doclibrary.com/MFR26/PRD/GS1_00051500007655_PRODUCT_IMG1_00051500007655_C8N1_JPG.JPG [empty string] 27803837 5150000765 Smucker's 1/2 Ounce Mixed Fruit Jelly Plastic 200 Count Case 23889 38 http://doclibrary.com/MFR26/PRD/GS1_00051500007655_PRODUCT_IMG1_00051500007655_C8N1_JPG.JPG [empty string] 27803837 5150000765 Smucker's 1/2 Ounce Mixed Fruit Jelly Plastic 200 Count Case 23889 39 http://doclibrary.com/MFR26/PRD/GS1_00051500007655_PRODUCT_IMG1_00051500007655_C8N1_JPG.JPG [empty string] 27803837 5150000765 Smucker's 1/2 Ounce Mixed Fruit Jelly Plastic 200 Count Case 23889 40 http://doclibrary.com/MFR26/PRD/GS1_00051500007655_PRODUCT_IMG1_00051500007655_C8N1_JPG.JPG [empty string] 27803837 5150000765 Smucker's 1/2 Ounce Mixed Fruit Jelly Plastic 200 Count Case 23889 41 http://doclibrary.com/MFR26/PRD/GS1_00051500007655_PRODUCT_IMG1_00051500007655_C8N1_JPG.JPG [empty string] 27803837 5150000765 Smucker's 1/2 Ounce Mixed Fruit Jelly Plastic 200 Count Case 23889 42 http://doclibrary.com/MFR26/PRD/GS1_10051500022082_PRODUCT_IMG1_10051500022082_C1C1_JPG.JPG [empty string] 28018785 5150002208 Smucker's 12 Ounce Grape Jelly 1873547 43 http://doclibrary.com/MFR26/PRD/GS1_10051500022082_PRODUCT_IMG1_10051500022082_C1C1_JPG.JPG [empty string] 28018785 5150002208 Smucker's 12 Ounce Grape Jelly 1873547 44 http://doclibrary.com/MFR26/PRD/GS1_10051500022082_PRODUCT_IMG1_10051500022082_C1C1_JPG.JPG [empty string] 28018785 5150002208 Smucker's 12 Ounce Grape Jelly 1873547 45 http://doclibrary.com/MFR26/PRD/GS1_10051500022082_PRODUCT_IMG1_10051500022082_C1C1_JPG.JPG [empty string] 28018785 5150002208 Smucker's 12 Ounce Grape Jelly 1873547 46 http://doclibrary.com/MFR26/PRD/GS1_10051500022150_PRODUCT_IMG1_10051500022150_A1C0_JPG.JPG [empty string] 28038617 5150002215 Smucker's 12 Ounce Strawberry Jelly 1873551 47 http://doclibrary.com/MFR26/PRD/GS1_10051500022150_PRODUCT_IMG1_10051500022150_A1C0_JPG.JPG [empty string] 28038617 5150002215 Smucker's 12 Ounce Strawberry Jelly 1873551 48 http://doclibrary.com/MFR26/PRD/GS1_00051500026458_PRODUCT_IMG1_00051500026458_C1C1_JPG.JPG [empty string] 25736490 5150002645 SMUCKER .5 OUNCE CASH N CARRY GRAPE JELLY PORTION CONTROL 200 Count Case 2304402 49 http://doclibrary.com/MFR26/PRD/GS1_00051500029855_PRODUCT_IMG1_00051500029855_C1C1_JPG.JPG [empty string] 24776309 5150002985 SMUCKER 1/2 OUNCE CASH AND CARRY MIXED FRUIT JELLY PLASTIC 200 Count Case 2774670 50 http://doclibrary.com/MFR26/PRD/GS1_30051500057118_PRODUCT_IMG1_30051500057118_M8_JPG.JPG [empty string] 30152794 5150005711 Smucker's 20 Ounce Squeeze Grape Jelly 1873580 51 http://doclibrary.com/MFR26/PRD/GS1_30051500057118_PRODUCT_IMG1_30051500057118_M8_JPG.JPG [empty string] 30152794 5150005711 Smucker's 20 Ounce Squeeze Grape Jelly 1873580 52 http://doclibrary.com/MFR26/PRD/GS1_30051500057118_PRODUCT_IMG1_30051500057118_M8_JPG.JPG [empty string] 30152794 5150005711 Smucker's 20 Ounce Squeeze Grape Jelly 1873580 53 http://doclibrary.com/MFR26/PRD/GS1_30051500057118_PRODUCT_IMG1_30051500057118_M8_JPG.JPG [empty string] 30152794 5150005711 Smucker's 20 Ounce Squeeze Grape Jelly 1873580 54 http://doclibrary.com/MFR26/PRD/GS1_30051500057118_PRODUCT_IMG1_30051500057118_M8_JPG.JPG [empty string] 30152794 5150005711 Smucker's 20 Ounce Squeeze Grape Jelly 1873580 55 http://doclibrary.com/MFR26/PRD/GS1_30051500057118_PRODUCT_IMG1_30051500057118_M8_JPG.JPG [empty string] 30152794 5150005711 Smucker's 20 Ounce Squeeze Grape Jelly 1873580 56 http://doclibrary.com/MFR26/PRD/GS1_10051500081133_PRODUCT_IMG1_10051500081133_A1C0_JPG.JPG [empty string] 29309422 5150008113 Smucker's 48 Ounce Grape Jelly 6 Count Case 3708516 57 http://doclibrary.com/MFR26/PRD/GS1_10051500081133_PRODUCT_IMG1_10051500081133_A1C0_JPG.JPG [empty string] 29309422 5150008113 Smucker's 48 Ounce Grape Jelly 6 Count Case 3708516 58 http://doclibrary.com/MFR26/PRD/GS1_10051500081164_PRODUCT_IMG1_10051500081164_C1C1_JPG.JPG [empty string] 27803456 5150008116 Smucker's 48 Ounce Mint Apple Jelly 6 Count Case 3703111 59 http://doclibrary.com/MFR26/PRD/GS1_10051500081164_PRODUCT_IMG1_10051500081164_C1C1_JPG.JPG [empty string] 27803456 5150008116 Smucker's 48 Ounce Mint Apple Jelly 6 Count Case 3703111 60 http://doclibrary.com/MFR26/PRD/GS1_10051500102517_PRODUCT_IMG1_10051500102517_C1C1_JPG.JPG [empty string] 24775979 5150010251 SM 48 OZ GRAPE JELLY GLASS 1873582 61 http://doclibrary.com/MFR26/PRD/GS1_10051500102517_PRODUCT_IMG1_10051500102517_C1C1_JPG.JPG [empty string] 24775979 5150010251 SM 48 OZ GRAPE JELLY GLASS 1873582 62 http://doclibrary.com/MFR26/PRD/GS1_00051500108512_PRODUCT_IMG1_00051500108512_D1CF_JPG.JPG [empty string] 24775466 5150010851 SMUCKER 15.5 OUNCE LOW SUGAR GRAPE JELLY 8 COUNT 2434887 63 http://doclibrary.com/MFR26/PRD/GS1_00051500210499_PRODUCT_IMG1_00051500210499_C1C1_JPG.JPG [empty string] 24498714 5150021049 SMUCKER .5 OUNCE GRAPE JELLY PLASTIC 400 COUNT 2471002 64 http://doclibrary.com/MFR26/PRD/GS1_00051500210499_PRODUCT_IMG1_00051500210499_C1C1_JPG.JPG [empty string] 24498714 5150021049 SMUCKER .5 OUNCE GRAPE JELLY PLASTIC 400 COUNT 2471002 65 http://doclibrary.com/MFR26/PRD/GS1_00051500210499_PRODUCT_IMG1_00051500210499_C1C1_JPG.JPG [empty string] 24498714 5150021049 SMUCKER .5 OUNCE GRAPE JELLY PLASTIC 400 COUNT 2471002 66 http://doclibrary.com/MFR26/PRD/GS1_00051500210499_PRODUCT_IMG1_00051500210499_C1C1_JPG.JPG [empty string] 24498714 5150021049 SMUCKER .5 OUNCE GRAPE JELLY PLASTIC 400 COUNT 2471002 67 http://doclibrary.com/MFR26/PRD/GS1_00051500210499_PRODUCT_IMG1_00051500210499_C1C1_JPG.JPG [empty string] 24498714 5150021049 SMUCKER .5 OUNCE GRAPE JELLY PLASTIC 400 COUNT 2471002
CACHED	false
EXECUTIONTIME	148
SQL	SELECT s.skuid, s.sku, s.MaxOrderQty, s.skudesc , case when c.contentId is not null then 'http://doclibrary.com/' + c.mainFolder + '/' + c.subFolder + '/' + c.fileName else null end as imgURL , c.contentId as PRD_ContentId FROM tbl_PRD_Skus s LEFT OUTER JOIN tbl_PRD_CustomerSkus cs ON s.sku = cs.sku AND cs.LinkType = 'sku' AND cs.OwnerID = 26 AND cs.FSL_TableCode = 'MFR' left outer join tbl_PRD_Images i with (nolock) on i.linkId = s.skuId and i.linkType = 'SKU' and i.imageCode = 'IMG1' and i.ownerId = s.ownerId and i.ownertype = s.fsl_tablecode left outer join tbl_FSC_Content c with (nolock) on c.contentId = i.contentId WHERE s.OwnerID = ? AND s.FSL_TableCode = ? AND s.inactive = '0' AND s.ProdID = ? AND (rtrim(s.PrivateLabelType) = '' OR s.PrivateLabelType IS NULL OR s.PrivateLabelType = 'MFR') AND (s.sku LIKE ? OR s.skudesc LIKE ? OR cs.customerSku LIKE ? ) and s.discontinued = 'N' ORDER BY s.sortrank, s.sku, s.skuDesc
SQLPARAMETERS	array 1 26 2 MFR 3 120336 4 %JELLY% 5 %JELLY% 6 %JELLY%

query
RESULTSET	query   IMGURL MAXORDERQTY PRD_CONTENTID SKU SKUDESC SKUID 1 [empty string] [empty string] 3738416 5150000162 Smucker's 32 Ounce Grape Jelly 12 Count Case 23865 2 [empty string] [empty string] 3738416 5150000162 Smucker's 32 Ounce Grape Jelly 12 Count Case 23865 3 [empty string] [empty string] 3738416 5150000162 Smucker's 32 Ounce Grape Jelly 12 Count Case 23865 4 [empty string] [empty string] 3738564 5150000326 SM 4 LB CURRANT JELLY 1874596 5 [empty string] [empty string] 3738564 5150000326 SM 4 LB CURRANT JELLY 1874596 6 [empty string] [empty string] 3738564 5150000326 SM 4 LB CURRANT JELLY 1874596 7 [empty string] [empty string] 3738564 5150000326 SM 4 LB CURRANT JELLY 1874596 8 [empty string] [empty string] 3738564 5150000326 SM 4 LB CURRANT JELLY 1874596 9 [empty string] [empty string] 3738449 5150000328 SM 4 LB GRAPE JELLY 23861 10 [empty string] [empty string] 3738449 5150000328 SM 4 LB GRAPE JELLY 23861 11 [empty string] [empty string] 3738449 5150000328 SM 4 LB GRAPE JELLY 23861 12 [empty string] [empty string] 3738449 5150000328 SM 4 LB GRAPE JELLY 23861 13 [empty string] [empty string] 3738449 5150000328 SM 4 LB GRAPE JELLY 23861 14 [empty string] [empty string] 3625942 5150000338 Smucker's 10 Tin Grape Jelly 23856 15 [empty string] [empty string] 3625942 5150000338 Smucker's 10 Tin Grape Jelly 23856 16 [empty string] [empty string] 3625942 5150000338 Smucker's 10 Tin Grape Jelly 23856 17 [empty string] [empty string] 3625942 5150000338 Smucker's 10 Tin Grape Jelly 23856 18 [empty string] [empty string] 3625942 5150000338 Smucker's 10 Tin Grape Jelly 23856 19 [empty string] [empty string] 3376481 5150000690 Smucker's 18 Ounce Apple Jelly 1873527 20 [empty string] [empty string] 3681899 5150000693 Smucker's 18 Ounce Grape Jelly 1873529 21 [empty string] [empty string] 3681899 5150000693 Smucker's 18 Ounce Grape Jelly 1873529 22 [empty string] [empty string] [empty string] 5150000696 Smucker's 18 Ounce Strawberry Jelly 12 Count Case 3586020 23 [empty string] [empty string] 3250117 5150000760 Smucker's 1/2 Ounce Apple Jelly Plastic 200 Count Case 23885 24 [empty string] [empty string] 3250117 5150000760 Smucker's 1/2 Ounce Apple Jelly Plastic 200 Count Case 23885 25 [empty string] [empty string] 3250117 5150000760 Smucker's 1/2 Ounce Apple Jelly Plastic 200 Count Case 23885 26 [empty string] [empty string] 3250117 5150000760 Smucker's 1/2 Ounce Apple Jelly Plastic 200 Count Case 23885 27 [empty string] [empty string] 3250117 5150000760 Smucker's 1/2 Ounce Apple Jelly Plastic 200 Count Case 23885 28 [empty string] [empty string] 3250117 5150000760 Smucker's 1/2 Ounce Apple Jelly Plastic 200 Count Case 23885 29 [empty string] [empty string] 3738567 5150000764 SMUCKER 1/2 OUNCE GRAPE JELLY PLASTIC 200 Count Case 23888 30 [empty string] [empty string] 3738567 5150000764 SMUCKER 1/2 OUNCE GRAPE JELLY PLASTIC 200 Count Case 23888 31 [empty string] [empty string] 3738567 5150000764 SMUCKER 1/2 OUNCE GRAPE JELLY PLASTIC 200 Count Case 23888 32 [empty string] [empty string] 3738567 5150000764 SMUCKER 1/2 OUNCE GRAPE JELLY PLASTIC 200 Count Case 23888 33 [empty string] [empty string] 3738567 5150000764 SMUCKER 1/2 OUNCE GRAPE JELLY PLASTIC 200 Count Case 23888 34 [empty string] [empty string] 3738567 5150000764 SMUCKER 1/2 OUNCE GRAPE JELLY PLASTIC 200 Count Case 23888 35 [empty string] [empty string] 3372205 5150000765 Smucker's 1/2 Ounce Mixed Fruit Jelly Plastic 200 Count Case 23889 36 [empty string] [empty string] 3372205 5150000765 Smucker's 1/2 Ounce Mixed Fruit Jelly Plastic 200 Count Case 23889 37 [empty string] [empty string] 3372205 5150000765 Smucker's 1/2 Ounce Mixed Fruit Jelly Plastic 200 Count Case 23889 38 [empty string] [empty string] 3372205 5150000765 Smucker's 1/2 Ounce Mixed Fruit Jelly Plastic 200 Count Case 23889 39 [empty string] [empty string] 3372205 5150000765 Smucker's 1/2 Ounce Mixed Fruit Jelly Plastic 200 Count Case 23889 40 [empty string] [empty string] 3372205 5150000765 Smucker's 1/2 Ounce Mixed Fruit Jelly Plastic 200 Count Case 23889 41 [empty string] [empty string] 3372205 5150000765 Smucker's 1/2 Ounce Mixed Fruit Jelly Plastic 200 Count Case 23889 42 [empty string] [empty string] 3626093 5150002208 Smucker's 12 Ounce Grape Jelly 1873547 43 [empty string] [empty string] 3626093 5150002208 Smucker's 12 Ounce Grape Jelly 1873547 44 [empty string] [empty string] 3626093 5150002208 Smucker's 12 Ounce Grape Jelly 1873547 45 [empty string] [empty string] 3626093 5150002208 Smucker's 12 Ounce Grape Jelly 1873547 46 [empty string] [empty string] 3508114 5150002215 Smucker's 12 Ounce Strawberry Jelly 1873551 47 [empty string] [empty string] 3508114 5150002215 Smucker's 12 Ounce Strawberry Jelly 1873551 48 [empty string] [empty string] 3507976 5150002645 SMUCKER .5 OUNCE CASH N CARRY GRAPE JELLY PORTION CONTROL 200 Count Case 2304402 49 [empty string] [empty string] 3615755 5150002985 SMUCKER 1/2 OUNCE CASH AND CARRY MIXED FRUIT JELLY PLASTIC 200 Count Case 2774670 50 [empty string] [empty string] 3738549 5150005711 Smucker's 20 Ounce Squeeze Grape Jelly 1873580 51 [empty string] [empty string] 3738549 5150005711 Smucker's 20 Ounce Squeeze Grape Jelly 1873580 52 [empty string] [empty string] 3738549 5150005711 Smucker's 20 Ounce Squeeze Grape Jelly 1873580 53 [empty string] [empty string] 3738549 5150005711 Smucker's 20 Ounce Squeeze Grape Jelly 1873580 54 [empty string] [empty string] 3738549 5150005711 Smucker's 20 Ounce Squeeze Grape Jelly 1873580 55 [empty string] [empty string] 3738549 5150005711 Smucker's 20 Ounce Squeeze Grape Jelly 1873580 56 [empty string] [empty string] [empty string] 5150008113 Smucker's 48 Ounce Grape Jelly 6 Count Case 3708516 57 [empty string] [empty string] [empty string] 5150008113 Smucker's 48 Ounce Grape Jelly 6 Count Case 3708516 58 [empty string] [empty string] [empty string] 5150008116 Smucker's 48 Ounce Mint Apple Jelly 6 Count Case 3703111 59 [empty string] [empty string] [empty string] 5150008116 Smucker's 48 Ounce Mint Apple Jelly 6 Count Case 3703111 60 [empty string] [empty string] 3642181 5150010251 SM 48 OZ GRAPE JELLY GLASS 1873582 61 [empty string] [empty string] 3642181 5150010251 SM 48 OZ GRAPE JELLY GLASS 1873582 62 [empty string] [empty string] 3520202 5150010851 SMUCKER 15.5 OUNCE LOW SUGAR GRAPE JELLY 8 COUNT 2434887 63 [empty string] [empty string] 2893342 5150021049 SMUCKER .5 OUNCE GRAPE JELLY PLASTIC 400 COUNT 2471002 64 [empty string] [empty string] 2893342 5150021049 SMUCKER .5 OUNCE GRAPE JELLY PLASTIC 400 COUNT 2471002 65 [empty string] [empty string] 2893342 5150021049 SMUCKER .5 OUNCE GRAPE JELLY PLASTIC 400 COUNT 2471002 66 [empty string] [empty string] 2893342 5150021049 SMUCKER .5 OUNCE GRAPE JELLY PLASTIC 400 COUNT 2471002 67 [empty string] [empty string] 2893342 5150021049 SMUCKER .5 OUNCE GRAPE JELLY PLASTIC 400 COUNT 2471002
CACHED	false
EXECUTIONTIME	259
SQL	SELECT s.skuid, s.sku, s.MaxOrderQty, s.skudesc , imgURL = COALESCE((SELECT top 1 c.imgPath + c.ImgName + '__100' + c.ImgExt AS imageURL),'') , i.Img1_ContentID as PRD_ContentID FROM tbl_PRD_Skus s LEFT OUTER JOIN tbl_PRD_CustomerSkus cs ON s.sku = cs.sku AND cs.LinkType = 'sku' AND cs.OwnerID = 26 AND cs.FSL_TableCode = 'MFR' LEFT OUTER JOIN tbl_PRD_ProductImages i ON i.OwnerID = ? AND i.FSL_TableCode = ? AND i.linkID = s.skuid AND i.CatalogLevel = 'SKU' LEFT OUTER JOIN qry_ContentLookup c ON i.Img1_ContentID = c.ContentID WHERE s.OwnerID = ? AND s.FSL_TableCode = ? AND s.inactive = '0' AND s.ProdID = ? AND (rtrim(s.PrivateLabelType) = '' OR s.PrivateLabelType IS NULL OR s.PrivateLabelType = 'MFR') AND (s.sku LIKE ? OR s.skudesc LIKE ? OR cs.customerSku LIKE ? ) and s.discontinued = 'N' ORDER BY s.sortrank, s.sku, s.skuDesc
SQLPARAMETERS	array 1 26 2 MFR 3 26 4 MFR 5 120336 6 %JELLY% 7 %JELLY% 8 %JELLY%

query
RESULTSET	query   CATEGORY IMG1CONTENTPATH IMG1_COMMENT IMG1_CONTENTID IMG1_FILEEXT IMG1_FILESIZE IMG1_UPLOADDATE IMG2CONTENTPATH IMG2_COMMENT IMG2_CONTENTID IMG2_FILEEXT IMG2_FILESIZE IMG2_UPLOADDATE IMGEXT IMGEXT IMGNAME IMGNAME IMGPATH IMGPATH SKU SKUDESC SKUID 1 Frozen Handheld http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG1_10051500069612_C1C1_JPG_100.JPG GS1 PRODUCT IMAGE 27211138 .JPG 186882 2026-04-10 09:35:45.0 http://doclibrary.com/MFR26/PRD/GS1_10051500069612_PRODUCT_IMG2_10051500069612_C1C1_S01_JPG_100.JPG GS1 PRODUCT IMAGE 30184447 .JPG 228115 2026-04-10 09:35:45.0 .JPG .JPG GS1_10051500069612_PRODUCT_IMG1_10051500069612_C1C1_JPG GS1_10051500069612_PRODUCT_IMG1_10051500069612_C1C1_JPG http://doclibrary.com/MFR26/PRD/ http://doclibrary.com/MFR26/PRD/ 5150006961 2.6 OZ PEANUT BUTTER & STRAWBERRY JAM ON WHEAT BREAD 2100129
CACHED	false
EXECUTIONTIME	40
SQL	SELECT s.skuid, s.sku, s.skuDesc , c.category , coalesce( IMG1.imgPath, 'http://doclibrary.com/generic/UTL/' ) as imgPath , coalesce( IMG1.imgName, 'clearpixel' ) as imgName , coalesce( IMG1.imgExt, '.gif' ) as imgExt , coalesce( IMG1.contentPath, 'http://doclibrary.com/generic/UTL/clearpixel.gif' ) as IMG1ContentPath , IMG1.IMG1_fileSize , IMG1.IMG1_fileExt , IMG1.IMG1_uploadDate , IMG1.IMG1_contentId , IMG1.IMG1_comment , coalesce( IMG2.imgPath, 'http://doclibrary.com/generic/UTL/' ) as imgPath , coalesce( IMG2.imgName, 'clearpixel' ) as imgName , coalesce( IMG2.imgExt, '.gif' ) as imgExt , coalesce( IMG2.contentPath, 'http://doclibrary.com/generic/UTL/clearpixel.gif' ) as IMG2ContentPath , IMG2.IMG2_fileSize , IMG2.IMG2_fileExt , IMG2.IMG2_uploadDate , IMG2.IMG2_contentId , IMG2.IMG2_comment FROM tbl_PRD_Skus s with (nolock) left outer join ( select i_IMG1.ownerId as ownerId, i_IMG1.ownerType as ownerType, i_IMG1.linkId as skuId, 'http://doclibrary.com/' + c_IMG1.mainFolder + '/' + c_IMG1.subFolder + '/' as imgPath, left( c_IMG1.fileName, len( c_IMG1.fileName ) - len ( i_IMG1.fileExt ) ) as imgName, i_IMG1.fileExt as imgExt, 'http://doclibrary.com/' + c_IMG1.mainFolder + '/' + c_IMG1.subFolder + '/' + left( c_IMG1.fileName, len( c_IMG1.fileName ) - len ( i_IMG1.fileExt ) ) + '_100' + i_IMG1.fileExt as contentPath ,i_IMG1.fileExt as IMG1_fileExt ,i_IMG1.fileSize as IMG1_fileSize ,i_IMG1.contentId as IMG1_contentId ,i_IMG1.uploadDate as IMG1_uploadDate ,i_IMG1.comment as IMG1_comment from tbl_PRD_Images as i_IMG1 with (nolock) inner join tbl_FSC_Content as c_IMG1 with (nolock) on c_IMG1.contentId = i_IMG1.contentId where i_IMG1.linkType = 'SKU' and i_IMG1.imageCode = ? ) as IMG1 on IMG1.skuId = s.skuId and IMG1.ownerId = s.ownerId and IMG1.ownerType = s.fsl_tablecode left outer join ( select i_IMG2.ownerId as ownerId, i_IMG2.ownerType as ownerType, i_IMG2.linkId as skuId, 'http://doclibrary.com/' + c_IMG2.mainFolder + '/' + c_IMG2.subFolder + '/' as imgPath, left( c_IMG2.fileName, len( c_IMG2.fileName ) - len ( i_IMG2.fileExt ) ) as imgName, i_IMG2.fileExt as imgExt, 'http://doclibrary.com/' + c_IMG2.mainFolder + '/' + c_IMG2.subFolder + '/' + left( c_IMG2.fileName, len( c_IMG2.fileName ) - len ( i_IMG2.fileExt ) ) + '_100' + i_IMG2.fileExt as contentPath ,i_IMG2.fileExt as IMG2_fileExt ,i_IMG2.fileSize as IMG2_fileSize ,i_IMG2.contentId as IMG2_contentId ,i_IMG2.uploadDate as IMG2_uploadDate ,i_IMG2.comment as IMG2_comment from tbl_PRD_Images as i_IMG2 with (nolock) inner join tbl_FSC_Content as c_IMG2 with (nolock) on c_IMG2.contentId = i_IMG2.contentId where i_IMG2.linkType = 'SKU' and i_IMG2.imageCode = ? ) as IMG2 on IMG2.skuId = s.skuId and IMG2.ownerId = s.ownerId and IMG2.ownerType = s.fsl_tablecode , tbl_PRD_Products p , tbl_PRD_Categories c WHERE s.OwnerID = ? AND s.FSL_TableCode = ? AND s.inactive = 0 AND s.sku = ? AND s.prodid = p.prodid AND p.categoryid = c.categoryid AND (s.unpublishDate >= {d '2026-04-17'} AND {d '2026-04-17'} >= s.publishdate) Order By s.skuDesc;
SQLPARAMETERS	array 1 IMG1 2 IMG2 3 26 4 MFR 5 5150006961

query
RESULTSET	query   CATEGORY IMG1CONTENTPATH IMG1_COMMENT IMG1_CONTENTID IMG1_FILEEXT IMG1_FILESIZE IMG1_UPLOADDATE IMG2CONTENTPATH IMG2_COMMENT IMG2_CONTENTID IMG2_FILEEXT IMG2_FILESIZE IMG2_UPLOADDATE IMGEXT IMGEXT IMGNAME IMGNAME IMGPATH IMGPATH SKU SKUDESC SKUID 1 Frozen Handheld [empty string] GS1 PRODUCT IMAGE 3773852 .JPG 1584177 2018-02-19 12:56:00.0 [empty string] GS1 PRODUCT IMAGE 3773853 .JPG 1139718 2018-02-19 12:56:00.0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5150006961 2.6 OZ PEANUT BUTTER & STRAWBERRY JAM ON WHEAT BREAD 2100129
CACHED	false
EXECUTIONTIME	41
SQL	SELECT s.skuid, s.sku, s.skuDesc , c.category , cImg1.imgPath, cImg1.ImgName, cImg1.ImgExt , cImg1.imgPath + cImg1.ImgName + '_100' + cImg1.ImgExt AS Img1ContentPath , s_img.Img1_FileSize, s_img.Img1_FileExt, s_img.Img1_UploadDate, s_img.Img1_ContentID, s_img.Img1_Comment , cImg2.imgPath, cImg2.ImgName, cImg2.ImgExt , cImg2.imgPath + cImg2.ImgName + '_100' + cImg2.ImgExt AS Img2ContentPath , s_img.Img2_FileSize, s_img.Img2_FileExt, s_img.Img2_UploadDate, s_img.Img2_ContentID, s_img.Img2_Comment FROM tbl_PRD_Skus s with (nolock) LEFT OUTER JOIN tbl_PRD_ProductImages s_img with (nolock) ON (s.skuId = s_img.linkID AND s_img.CatalogLevel = ? AND s_img.OwnerID = ? AND s_img.FSL_TableCode = ?) LEFT OUTER JOIN qry_ContentLookup cImg1 with (nolock) ON (s_img.Img1_ContentID = cImg1.contentid) LEFT OUTER JOIN qry_ContentLookup cImg2 with (nolock) ON (s_img.Img2_ContentID = cImg2.contentid) , tbl_PRD_Products p , tbl_PRD_Categories c WHERE s.OwnerID = ? AND s.FSL_TableCode = ? AND s.inactive = 0 AND s.sku = ? AND s.prodid = p.prodid AND p.categoryid = c.categoryid AND (s.unpublishDate >= {d '2026-04-17'} AND {d '2026-04-17'} >= s.publishdate) Order By s.skuDesc;
SQLPARAMETERS	array 1 SKU 2 26 3 MFR 4 26 5 MFR 6 5150006961

120336