add remove split language chart show hidden hide
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
@sql
MAX(IF(m.name = 'name', m.value, NULL)) AS name,MAX(IF(m.name = 'color', m.value, NULL)) AS color
@sql
SELECT o.`id`
                    , o.`type`
                    , o.`description`, MAX(IF(m.name = 'name', m.value, NULL)) AS name,MAX(IF(m.name = 'color', m.value, NULL)) AS color
                   FROM object o
                   LEFT JOIN meta AS m
                    ON o.`id` = m.`object`
                   GROUP BY o.id
id type description name color
1 brand a adidas blue
2 project b null null
3 brand c telekom pink