select addrecipe.* , users.username,users.enabled from addrecipe LEFT JOIN users ON(users.username=addrecipe.recaddedby) where addrecipe.recactivation='1' order by addrecipe.recipeid desc LIMIT 10