SELECT * FROM recipes WHERE id IN ( SELECT recipe_id FROM (
  SELECT recipe_id, COUNT(*) AS favCount FROM user_favorites
  WHERE liked_at >= @week_timestamp
  GROUP BY recipe_id
  ORDER BY favCount DESC 
) AS top_recipes )