select * from oxo_mydownloads_downloads WHERE url like '%%' AND submitter =1 AND status =0 ORDER BY rand() LIMIT 10
10
hits:19 rating:0.0000 '08/08/04
291 -
(submitter) 1 -
(status) 0
'92/05/18
You keep me hangin' on_0.1
hits:1 rating:0.0000 '92/05/18
55 -
(submitter) 1 -
(status) 0
285 -
(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/13
Songbirds_0.1.1_keyF?
hits:1 rating:0.0000 '07/06/13
35 -
(submitter) 1 -
(status) 0
hits:35 rating:0.0000 '07/06/13
40 -
(submitter) 1 -
(status) 0
'99/
For no one
hits:97 rating:6.0000 votes:2 '99/
148 -
(submitter) 1 -
(status) 0
hits:11 rating:0.0000 '08/03/02
296 -
(submitter) 1 -
(status) 0
'07/06/09
Mother Nature's son_0.2_keyF
hits:2 rating:0.0000 '07/06/09
28 -
(submitter) 1 -
(status) 0
'07/05/15
Mother Nature's Son
hits:167 rating:7.0000 votes:1 '07/05/15
91 -
(submitter) 1 -
(status) 0