Re: Select first record of each ID mysql5.6

[Peter Brawley]

Rather than t1.sort=1, you want the minimum t.sort, which can be got with MIN() and requires Group By eg ...

SELECT t1.id, t1.foreign_id, t1.small_path, MIN(t1.sort) as 'sort', t2.title
FROM stivagallery_plugin_gallery t1  
JOIN stivagallery_galleries      t2 ON t1.foreign_id = t2.id
GROUP BY t1.id, t1.foreign_id, t1.small_path, t2.title
ORDER BY t1.foreign_id;

BTW do NOT use comma joins, they went out with quill pens, use JOIN ON... syntax as above.