Recipes

select addrecipe.*, users.username,users.enabled from addrecipe LEFT JOIN users ON(users.username=addrecipe.recaddedby) WHERE addrecipe.recactivation='1' AND addrecipe.reccat='test' ORDER BY addrecipe.recipeid DESC LIMIT 0, 10