select prd.product, sku.skuid, prd.prodid from tbl_prd_skus sku inner join tbl_prd_products prd on prd.prodid = sku.prodid where sku.ownerid = and sku.fsl_tablecode = and sku.sku = select fieldname from tbl_rec_customflds where ownerid = and fsl_tablecode = and label like select fieldname from tbl_rec_customflds where ownerid = and fsl_tablecode = and label like select distinct 0 as rownumber, recipeid, recipename, RecipeDesc, img.ImgPath + img.ImgName + '_100' + img.ImgExt as imageURL from tbl_rec_items rec left outer join qryImageLookup img on rec.RecipeImage = img.ImageID where rec.mfr_id = and getdate() >= publishdate and getdate() <= unpublishdate and ( #qrySkuCustomFlds.fieldname# like or 1 = 2 ) and ( #qryPrdCustomFlds.fieldname# like or 1 = 2 ) and 1 = 2 order by recipename select distinct 0 as rownumber, rec.recipeid, rec.recipename, rec.RecipeDesc, img.ImgPath + img.ImgName + '_100' + img.ImgExt as imageURL from tbl_rec_items rec inner join tbl_rec_products rp on rp.recipeid = rec.recipeid and ( ( rp.linkid = and linktype = 'sku' ) or ( rp.linkid = and linktype = 'prd' ) ) left outer join qryImageLookup img on rec.RecipeImage = img.ImageID where rec.mfr_id = and getdate() >= rec.publishdate and getdate() <= rec.unpublishdate order by recipename

No recipes found

 #_lowerPagerDisplay#