select * from oxo_mydownloads_downloads WHERE url like '%%' AND submitter =1 AND status!=1 ORDER BY rand() LIMIT 20
20
'13/05/30
You look so bright
hits:52 rating:4.5000 votes:2 '13/05/30
165 -
(submitter) 1 -
(status) 0
hits:90 rating:2.0000 votes:1 '07/11/19
110 -
(submitter) 1 -
(status) 0
'07/06/30
Can't take my eyes off you
hits:147 rating:3.0000 votes:1 '07/06/30
94 -
(submitter) 1 -
(status) 2
'99/
For no one
hits:97 rating:6.0000 votes:2 '99/
148 -
(submitter) 1 -
(status) 0
'07/06/20
Message in a bottle_0.2
hits:3 rating:0.0000 '07/06/20
63 -
(submitter) 1 -
(status) 0
19 - (submitter) 1 - (status) 0
'07/06/09
I'm looking through you_0.2 d28
hits:1 rating:0.0000 '07/06/09
26 -
(submitter) 1 -
(status) 0
'07/06/28
Please Please Me_0.1_noV
hits:4 rating:0.0000 '07/06/28
79 -
(submitter) 1 -
(status) 0
hits:39 rating:0.0000 '07/06/13
39 -
(submitter) 1 -
(status) 0
hits:193 rating:0.0000 '07/12/02
121 -
(submitter) 1 -
(status) 2
'11/03/02
Now we're going out_Iidabashi space
hits:33 rating:0.0000 '11/03/02
172 -
(submitter) 1 -
(status) 2
hits:93 rating:4.0000 votes:1 '07/03/10
2 -
(submitter) 1 -
(status) 0
'07/07/01
Isn't she lovely_0.4.1
hits:4 rating:0.0000 '07/07/01
48 -
(submitter) 1 -
(status) 0
'07/07/01
You're my best friend_0.2
hits:3 rating:0.0000 '07/07/01
45 -
(submitter) 1 -
(status) 0
hits:37 rating:0.0000 '07/06/13
42 -
(submitter) 1 -
(status) 0
'07/06/13
The logical song_0.1
hits:4 rating:0.0000 '07/06/13
32 -
(submitter) 1 -
(status) 0
hits:1 rating:0.0000 '07/07/01
68 -
(submitter) 1 -
(status) 0
hits:234 rating:4.8000 votes:5 comments:1 '07/12/24
160 -
(submitter) 1 -
(status) 2
'07/07/01
I saw her standing there_0.1_noV
hits:19 rating:0.0000 '07/07/01
78 -
(submitter) 1 -
(status) 0
hits:102 rating:2.5000 votes:4 comments:2 '07/12/13
159 -
(submitter) 1 -
(status) 0