SQLize Online / PHPize Online  /  SQLtest Online

create table entries ( entry_id int primary key, starred int ); insert into entries values (1, 0), (2, 0), (3, 1); create table fields ( id int primary key, entry_id int, value int, foreign key (entry_id) references entries(entry_id) ); insert into fields values (1, 1, 1), (2, 1, 0), (3, 2, 1), (4, 3, 0); WITH data AS ( SELECT e.entry_id, f.id, e.starred, f.value, row_number() over (partition by e.entry_id order by id DESC) rn FROM entries e INNER JOIN fields f USING(entry_id) ) SELECT entry_id, id, starred, value FROM data WHERE rn = 1 ;