select distinct r.recipe, b.recipeId, p.packageId,p.description from batch b, recipes r, products p where b.recipeId = r.recipeId and b.recipeId = p.recipeId and b.packageId = p.packageId and stage = 10 and date(timestamp )= current_date() order by b.timestamp desc