I have two tables that I am attempting to join in MySQL:

reviews:

```
|  review_id  |  comment       |  reviewer_id  | user_id  |
-----------------------------------------------------------
|  1          |  some text.    |  501          | 100      |    
|  2          |  lorem ipsum   |  606          | 100      |
|  3          |  blah blah.    |  798          | 120      |
|  4          |  foo bar!      |  798          | 133      |
-----------------------------------------------------------

```

review\_status:

```
 |  review_id  |  status  | timestamp   |
 ----------------------------------------
 |  1          |  10      | 1364507521  |
 |  1          |  101     | 1364508057  |
 |  2          |  100     | 1364509033  |
 |  1          |  150     | 1364509149  |
 |  2          |  120     | 1364509283  |
 |  2          |  122     | 1364855948  |
 |  3          |  120     | 1364509283  |
 |  3          |  122     | 1364855948  |
 |  1          |  110     | 1364855945  |
 |  4          |  100     | 1364509283  |
 |  4          |  115     | 1364855948  |
 |  4          |  210     | 1364855945  |
 ----------------------------------------

```

What I WANT is a result that looks something like this:

result

```
 | review_id | comment     |  reviewer_id | user_id | status | timestamp  |
 --------------------------------------------------------------------------
 | 1         | some text.  |  501         | 100     | 200    | 1364855945 | 
 | 2         | lorem ipsum |  606         | 120     | 122    | 1364855948 |
 --------------------------------------------------------------------------

```

I'm after: 1) The newest entry from the review\_status table 2) A certain range of status codes (100 - 199 in this case) 3) And multiple user\_id's from the review table.

This is currently my query, that I can't get to work for the life of me:

```
SELECT r.review_id, r.comment, r.reviewer_id, r.user_id
FROM reviews AS r 
INNER JOIN 
   (SELECT s.status, max(s.timestamp)
    FROM review_status AS s
    WHERE s.status < 200
    AND s.status > 99;
    GROUP BY s.review_id) AS r_s
ON r.review_id = r_s.review_id
WHERE r.user_id IN (100,120);

```

Any help is greatly appreciated! Thanks.