Beispiel:
let sql = `SELECT
JSON_OBJECT("id", a.id,
"apero_date", a.apero_date,
"image", a.image,
"topics", JSON_OBJECTAGG(b.name, b.description)) as aperos
FROM ${this.tableName} as a JOIN ${this.tableNameSecond} as b ON a.id = b.aperoId
GROUP BY b.aperoId`;
VirtualApéro
Kommentare