https://screenrant.com/star-trek-every-lore-appearance-ranked/

Lore only appeared in four episodes of Star Trek: The Next Generation and two of Star Trek: Picard, but he certainly made his presence felt.