Order by column count of another table

Databases
1

Hi,

Is it possible to order by a 2nd query count?
I am displaying one mysql table with a standard select query, but I need to order the results by the number of votes each listing has (which is from a 2nd table “votes”)
Is this possibe?

Thanks

2

Yes, join the two tables, group by the first table’s id, and order by COUNT(*)

3

Thanks. Can I grab an example?

4

Scratch that, got it :slight_smile: