SELECT MT.mediaid, MR.created_at
  FROM Playlist_Detail PD
  LEFT JOIN Media_Tags MT ON MT.tag_name = PD.tag_name
  LEFT JOIN (
    SELECT mediaid, MAX(created_at) AS created_at
    FROM Media_Request
    WHERE userid = 1364
    GROUP BY mediaid
  ) MR ON MR.mediaid = MT.mediaid
  WHERE PD.playlistid = 38;

20997   2015-09-21 13:53:45
20987   2015-09-21 14:19:57
21049   2015-09-21 13:00:17
20935   2015-09-21 12:11:12
20979   2015-09-21 10:22:58
20913   2015-09-21 15:16:38
21037   2015-09-21 06:31:11
21025   2015-09-20 14:03:40
20894   2015-09-21 06:54:18
21038   2015-09-21 09:12:43
21047   2015-09-21 13:32:34
22971   2015-09-21 07:48:30
21074   2015-09-21 15:31:45
20994   2015-09-21 05:31:59
20947   2015-09-21 12:28:10
20916   2015-09-21 14:08:40
20951   2015-09-21 03:19:44
20926   2015-09-21 01:57:20
21013   2015-09-20 14:30:12
21015   2015-09-21 02:57:20
20885   2015-09-21 09:53:08
20912   2015-09-21 16:11:19
20884   2015-09-21 09:57:20
20911   2015-09-21 12:36:31
21027   2015-09-20 22:27:36
20948   2015-09-21 01:48:26
20991   2015-09-21 09:21:06
20983   2015-09-20 21:11:38
20978   2015-09-21 11:01:01
20992   2015-09-21 07:57:28
21075   2015-09-21 02:23:11
20940   2015-09-21 09:48:28
20986   2015-09-21 15:38:29
21058   2015-09-21 12:04:04
20976   2015-09-20 22:16:43
21053   2015-09-21 11:20:40
20934   2015-09-21 13:10:52
20972   2015-09-21 15:34:30
21021   2015-09-21 11:05:34
21028   2015-09-20 01:39:54
21024   2015-09-21 16:54:04
21083   2015-09-21 07:34:49
21061   2015-09-21 06:12:05
21059   2015-09-20 21:20:14
20922   2015-09-21 16:36:09
20952   2015-09-21 05:00:00
20905   2015-09-21 12:20:30
21017   2015-09-21 04:05:38
21076   2015-09-21 06:53:43
21018   2015-09-21 14:13:43
20937   2015-09-21 14:25:04
21031   2015-09-21 12:51:02
21001   2015-09-19 20:40:51
21078   2015-09-21 03:25:26
20943   2015-09-20 19:17:54
20965   2015-09-21 01:41:35
21022   2015-09-21 08:11:48
20955   2015-09-21 10:04:54
21067   2015-09-21 10:34:28
21026   2015-09-21 00:49:55
21016   2015-09-21 08:03:45
20901   2015-09-21 10:18:31
21069   2015-09-20 23:24:36
21051   2015-09-21 14:46:22
20880   2015-09-21 06:49:02
20920   2015-09-20 22:18:33
21065   2015-09-21 13:43:58
20996   2015-09-21 01:16:57
20998   2015-09-21 16:42:14
21008   2015-09-21 15:58:20
21006   2015-09-21 02:37:35
21045   2015-09-21 14:16:56
21012   2015-09-21 11:32:43
20980   2015-09-20 09:56:54
21079   2015-09-21 16:46:04
20914   2015-09-21 10:11:04
20919   2015-09-21 09:43:24
20959   2015-09-21 06:11:40
20903   2015-09-21 13:28:50
20910   2015-09-21 01:46:36
21054   2015-09-20 15:03:12
20888   2015-09-21 15:41:23
21081   2015-09-21 04:40:12
21010   2015-09-21 07:20:02
20956   2015-09-21 03:17:29
27665   2015-09-21 06:00:16
21064   2015-09-21 02:08:42
21060   2015-09-20 23:40:54
20960   2015-09-21 07:53:42
20949   2015-09-21 14:02:30
21040   2015-09-21 16:39:35
20953   2015-09-21 11:16:28
20927   2015-09-20 23:49:04
21052   2015-09-21 15:25:16
20973   2015-09-21 16:22:45
21080   2015-09-21 15:53:11
20988   2015-09-21 01:40:47
20906   2015-09-21 14:52:44
21020   2015-09-21 16:27:53
20886   2015-09-21 14:32:39
21062   2015-09-21 12:40:41
21082   2015-09-21 09:38:55
20938   2015-09-21 02:53:19
21034   2015-09-21 09:30:45
20930   2015-09-21 01:39:19
20902   2015-09-21 06:17:16
20893   2015-09-20 22:28:21
20974   2015-09-21 00:44:23
20944   2015-09-21 15:10:08
20932   2015-09-21 14:49:02
20989   2015-09-21 08:15:17
20939   2015-09-21 06:03:56
20970   2015-09-21 11:49:02
21019   2015-09-21 08:45:04
21035   2015-09-20 08:29:05
20975   2015-09-21 08:33:26
21057   2015-09-21 14:32:51
21063   2015-09-21 01:27:00
21048   2015-09-21 14:56:21
21041   2015-09-21 16:15:45
21005   2015-09-21 13:26:14
21077   2015-09-21 11:36:54
20933   2015-09-21 04:36:15
20936   2015-09-20 14:48:06
21072   2015-09-20 04:10:40
20942   2015-09-19 15:50:53
20967   2015-09-21 07:57:38
20896   2015-09-20 18:12:11
20891   2015-09-21 06:52:54
21042   2015-09-21 09:28:11
20900   2015-09-21 04:20:20
20924   2015-09-21 16:33:16
20964   2015-09-21 15:28:10
21002   2015-09-21 04:35:53
20981   2015-09-21 01:37:34
20917   2015-09-20 21:54:18
20915   2015-09-21 15:12:48
20929   2015-09-21 02:23:27
20962   2015-09-21 14:05:47
20966   2015-09-21 14:38:02
20921   2015-09-21 15:00:31
21003   2015-09-21 11:24:41
21029   2015-09-21 15:05:27
21073   2015-09-21 06:40:06
20928   2015-09-21 06:49:12
20957   2015-09-21 12:50:52
20941   2015-09-21 03:37:41
20977   2015-09-21 04:48:10
21004   2015-09-21 16:50:01
20968   2015-09-21 13:05:41
21068   2015-09-21 12:50:31
20999   2015-09-21 13:39:48
20898   2015-09-21 13:46:52
20890   2015-09-21 08:27:25
21014   2015-09-21 10:28:28
20990   2015-09-21 08:48:08
21009   2015-09-21 07:00:13
20923   2015-09-20 04:05:16
20925   2015-09-21 00:35:37
20982   2015-09-21 06:52:08
21071   2015-09-21 01:31:46
20961   2015-09-21 00:21:39
20969   2015-09-21 01:38:10
20985   2015-09-21 03:41:28
20963   2015-09-21 16:02:24
20889   2015-09-21 03:33:26
21085   2015-09-21 12:45:43
20892   2015-09-21 10:00:53
21023   2015-09-20 07:00:37
21007   2015-09-21 13:50:20
20993   2015-09-21 05:16:38
20904   2015-09-20 21:29:56
20984   2015-09-21 04:26:41
20899   2015-09-21 16:20:15
20950   2015-09-21 10:30:42
21039   2015-09-21 01:00:30
20908   2015-09-21 11:01:11
20897   2015-09-21 12:00:27
21032   2015-07-27 15:49:00
21084   2015-09-09 07:52:02
20909   2015-09-21 05:27:35
21044   2015-09-21 11:13:07
20954   2015-09-21 04:30:54
21050   2015-09-21 11:09:39
21011   2015-09-21 08:51:00
21055   2015-09-21 13:22:04
20918   2015-09-21 01:36:26
21033   2015-09-21 06:03:46
20881   2015-09-21 01:42:05
21066   2015-09-21 15:19:54
21036   2015-09-21 14:28:36
20945   2015-09-21 05:55:55
20931   2015-09-21 04:40:29
21000   2015-09-21 10:55:43
21056   2015-09-21 02:47:43
20995   2015-09-21 00:44:51
21046   2015-09-21 07:03:38
20883   2015-09-21 16:06:35
20971   2015-09-21 03:02:33
21043   2015-09-21 01:49:43
20946   2015-09-21 03:44:04
20882   2015-09-21 15:10:15
20958   2015-09-21 08:29:58
20895   2015-09-20 04:56:26
20887   2015-09-21 06:53:17
20907   2015-09-21 11:53:45
22975   2015-09-21 15:48:05
23001   2015-09-21 10:38:05
23012   2015-09-21 13:17:00