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); SELECT e.entry_id, f.id, e.starred, f.value FROM entries e INNER JOIN fields f USING(entry_id) INNER JOIN ( SELECT entry_id, MAX(id) max_id FROM fields GROUP BY entry_id ) max_fields ON max_id = f.id