I'm trying to figure out a way to write my query so that I don't return results of all the same insightsource when querying out a limit of 5. I want to have unique insightsources returned.
Attached is an example of my dataset. As you can see they are all clumped together and I may have 20+ insightsources all concurrent.
Here is my current query
select title, link, date_format(regdate,'%h:%i:%s %p') as createDate, ins.name as sourceName
from insights i
inner join insightsources ins on i.insightsource = ins.id
order by i.id desc