You must provide a recipe_id Resize Amount cannot be larger than 99999 SELECT RecipeName as title, RecipeDesc as description, servSuggestions as serving_suggestion, unitPerSrv as serving_size , servings as number_servings, unitMeasure as serving_size_uom , RecipeYield as yield, yieldTip as yield_tip , prepTime as prep_time, bakeTime as cook_time, cooldownTime as cooldown_time, holdingTime as holding_time , image as image_url, customFld_1 as related_skus , calories, fat as total_fat, fat_pdv , saturatedfat as saturated_fat, saturatedfat_pdv as saturated_fat_pdv , transfat as trans_fat, transfat_pdv as trans_fat_pdv, cholesterol, cholesterol_pdv , sodium, sodium_pdv, potassium, potassium_pdv, carbs as total_carb, carbs_pdv as total_carb_pdv , fiber as dietary_diber, sugar as sugars, protein, vitamina as vitamin_a, vitaminc as vitamin_c , calcium, iron, recipeId, mfr_Id, keywords, nutritionText , '' as pdf_url FROM tbl_REC_Items i left outer join qrySecureImageFullPathLookup qryImageFullPathLookup t on t.imageId = i.recipeImage WHERE recipeId = AND unpublishDate >= #CreateODBCDate(Now())# AND #CreateODBCDate(Now())# >= publishdate SELECT IngredientRank as step, Cast( IngredientQuantity as varchar ) as qty, IngredientMeasurement as qty_uom, IngredientDescription as text, measureType, Cast( IngredientQuantity2 as varchar ) as qty_2, IngredientMeasurement2 as qty_uom_2 FROM tbl_REC_Ingredients WHERE recipeId = ORDER BY IngredientRank Asc SELECT sku FROM tbl_REC_Products p with (nolock) inner join tbl_PRD_Skus s with (nolock) on s.skuid = p.linkId and p.linkType = 'SKU' WHERE p.recipeId = ORDER BY s.sku SELECT InstructionStep as step, InstructionText as text FROM tbl_REC_Instructions WHERE recipeId = ORDER BY InstructionStep asc