select * from oxo_mydownloads_downloads WHERE url like '%%' AND submitter =1 AND status!=1 ORDER BY rand() LIMIT 10
10
'07/07/01
You're my best friend_0.2
hits:3 rating:0.0000 '07/07/01
45 -
(submitter) 1 -
(status) 0
hits:1 rating:0.0000 '07/07/01
68 -
(submitter) 1 -
(status) 0
hits:90 rating:2.0000 votes:1 '07/11/19
110 -
(submitter) 1 -
(status) 0
hits:97 rating:3.0000 votes:1 '07/11/19
104 -
(submitter) 1 -
(status) 3
hits:150 rating:5.5000 votes:2 '04/11/16
153 -
(submitter) 1 -
(status) 2
hits:98 rating:3.0000 votes:1 '07/12/13
156 -
(submitter) 1 -
(status) 0
hits:2 rating:0.0000 '13/06/01
20 -
(submitter) 1 -
(status) 0
hits:3 rating:0.0000 '07/07/01
80 -
(submitter) 1 -
(status) 0
hits:239 rating:3.0000 votes:1 '03/07/24
112 -
(submitter) 1 -
(status) 2
'07/07/01
Isn't she lovely_0.4.2
hits:2 rating:0.0000 '07/07/01
49 -
(submitter) 1 -
(status) 0