mysqli_report(MYSQLI_REPORT_OFF);
, либо, что более правильно, использовать try ... catch.WITH `cte` (`id`, `price`, `date`, `row`) AS (
SELECT `good`, `price`, `date`, ROW_NUMBER() OVER `win`
FROM `item_good_supplies`
WHERE `good` IN('23068', '21805', '23204', '22493', '21813', '21802', '23845')
WINDOW `win` AS (
PARTITION BY `good`
ORDER BY `date` DESC
)
)
SELECT `id`, `price`, `date`
FROM `cte`
WHERE `row` = 1
SELECT `t`.`id_thing`, `t`.`data`, JSON_ARRAYAGG(`n`.`note`) AS `all_notes`
FROM `things` AS `t`
LEFT JOIN `notes` AS `n` ON `n`.`id_thing` = `t`.`id_thing`
GROUP BY `t`.`id_thing`, `t`.`data`