Alright so i'm trying to do a complex select in which i: Get All Ip's where they have the provided section # and then get the list of sections that those ip's specify ordered by the count of the number of those sections. Here is what I've written so far, it doesnt seem to work: SELECT Episode_ID, count(Episode_ID) FROM tracker WHERE Episode_ID IN (SELECT Episode_ID FROM tracker WHERE IP IN (SELECT IP FROM tracker WHERE Episode_ID = 33)) ORDER BY count(Episode_ID); Code (markup): edit: the 33 in the code is just a same ID, it could be any number