I got 2 tables of recipes, and recipe\_ratings   

and I don't know how to get the AVG(rating\_value) from recipe\_rating   

and join them   

Recipes table (get '\*') and join it with AVG(recipe\_value)   

order by date\_posted