I have two tables of which are:

```
threads {
 `id` int(11) PRIMARY KEY
 `by` int(11)
 `forum` int(11)
 `title` text 
 `content` text
 `date_added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP }

views {
 `thread_id` int(11)
 `forum_id` int(11)
 `user_id` int(11)
 `time_viewed` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP }

```

My aim is to select the threads with the most views, in order, using these two tables.

I tried researching but i can't even wrap my head around how to do this in SQL.