Howdy Eric,

My SQL is awful, but my first thought was a DISTINCT inside the 
GROUP_CONCAT. A quick google turned this up:

https://stackoverflow.com/questions/3083499/mysql-distinct-on-a-group-concat

Maybe it gets you closer?

Yours,
Kevin



On 10/29/21 10:02, Eric Lease Morgan wrote:
> On Oct 29, 2021, at 9:54 AM, Mike Rylander <[log in to unmask]> wrote:
> 
>>   SELECT b.identifier,
>>          GROUP_CONCAT( e.entity,  '; ' ) AS entities,
>>          GROUP_CONCAT( k.keyword, '; ' ) AS keywords
>>   FROM bibliographics AS b
>>   LEFT JOIN entities  AS e ON e.identifier = b.identifier
>>   LEFT JOIN keywords  AS k ON k.identifier = b.identifier
>>   GROUP BY b.identifier
> H
> Thank you for the prompt reply. I tried that, but I get the same sort of output:
> 
> identifier = american-authors
>    entities = bible; clemens; emerson; emerson; howells; irving; little women; mark twain; mark twain's; new york; poe; the innocents abroad; uncle tom's cabin
>    keywords = york; york; york; york; york; york; york; york; york; york; york; york; york
> 
> --
> Eric M.
>