I don't know if this will do exactly what you want at the edges, but you
can use subqueries in a straightforward way:
SELECT es.identifier, es.entities, ks.keywords
FROM
(SELECT b.identifier AS identifier,
GROUP_CONCAT( e.entity, '; ' ) AS entities
FROM bibliographics AS b
LEFT J
If you know that the keywords and entities don't have any commas in them
then the following is an alternative to subqueries:
SELECT b.identifier,
replace(GROUP_CONCAT(distinct e.entity), ',', '; ') AS entities,
replace(GROUP_CONCAT( distinct k.keyword), ',', '; ') AS keywords
You could use something like rclone to mount the S3 bucket locally. This
is not always ideal, but in many circumstances it works well enough.
Howard
hdi...@brynmawr.edu
On 1/7/22 12:48 PM, Chris Mayo wrote:
Hi all,
I've recently become caretaker for a large audio archive, both physical and
d
