SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete create table items ( id serial, name varchar ); insert into items values (1, 'Item1'); create table item_fields ( id serial, item_id int4, en varchar, ko varchar, ru varchar ); create table "fields" (id serial, name varchar); insert into "fields" values (218, 'Key1'), (219, 'Key2'), (220, 'Key3'); insert into item_fields (id, item_id, en, ko, ru) values (218, 1, 'Field 1', '필드 1', 'Поле 1'), (219, 1, 'Field 1', '필드 1', 'Поле 2'), (220, 1, 'Field 1', '필드 1', 'Поле 3'); select i.name, min(ru) filter (where fi.id = 218) key1, min(ru) filter (where fi.id = 219) key2, min(ru) filter (where fi.id = 220) key3 from items i left join item_fields fi on i.id = fi.item_id and fi.id in (218, 219, 220) group by i.name, item_id