My table:

```
id  | request |  subject     | date
1   |    5    |      1       |  576677
2   |    2    |      3       |  576698 
3   |    5    |      1       |  576999 
4   |    2    |      3       |  586999

```

Need to select unique records by two columns(request,subject) with showing last inserted id's. 

My query:

```
SELECT *,MAX(id) 
FROM `tbl` 
GROUP BY CONCAT(`request_id`, `subject_id`) 
HAVING (COUNT(`request_id`)>1 order by MAX(id) desc

```

But results:

```
id  | request |  subject     | date
2   |    2    |      3       |  576698 
1   |    5    |      1       |  576677

```

How to get records with id's 3 and 4 ?