Understanding the INSERT INTO...ON DUPLICATE KEY UPDATE Statement

How to Update a Table Based on the Results of a Previous Query Using MariaDB and Correlated Subqueries

Optimizing Derived-Subquery Performance: Pulling Distinct Records into a Group Concat()