0rich.com
[MYSQL] JSON_ARRAYAGG join group by duplicates
SELECT accomodation.* , JSON_ARRAYAGG( JSON_OBJECT( 'id', accomodation_images.id, 'image_url', accomodation_images.image_url ) ) AS images , JSON_ARRAYAGG( JSON_OBJECT( 'id', room.id, 'image_url', roo…
영리치