SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete create table items ( id serial primary key, name varchar ); insert into items values (1, 'Item1'); create table item_fields ( id serial primary key, item_id int4, en varchar, ko varchar, ru varchar, CONSTRAINT item_fields_fk FOREIGN KEY (item_id) REFERENCES items(id) ); create table "fields" (id serial primary key, 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 ; explain 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 ;