Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement