Nitpickers Guide(s) by Phil Farrand. He did two guides for TNG, including the entire series and Generations. A book for TOS, including all six movies, and partial book for DS9. I believe no further books were made because in the mid 1990s some companies were kitting skittish about unauthorized books prompting law-suits, even though the Guides were protected by Fair Use the publisher was still uneasy.