SELECT *
  FROM produkt_kategorien k
  CROSS JOIN (SELECT *
  FROM produkte p
  WHERE p.kategorie = k.kategorie
  ORDER BY popularitaet
  LIMIT 3
  ) top_produkte