select * from oxo_mydownloads_downloads WHERE url like '%%' AND submitter =1 AND status!=2 ORDER BY rand() LIMIT 10
10
hits:17 rating:6.0000 votes:1 '08/07/14
201 -
(submitter) 1 -
(status) 1
hits:15 rating:5.0000 votes:1 '08/04/03
186 -
(submitter) 1 -
(status) 1
hits:232 rating:0.0000 '07/12/03
135 -
(submitter) 1 -
(status) 1
'07/06/09
Mother Nature's son_0.2_keyF
hits:2 rating:0.0000 '07/06/09
28 -
(submitter) 1 -
(status) 0
hits:95 rating:2.0000 votes:1 '07/12/03
134 -
(submitter) 1 -
(status) 1
hits:278 rating:4.8000 votes:5 '07/12/03
136 -
(submitter) 1 -
(status) 1
hits:99 rating:3.0000 votes:1 '07/11/25
115 -
(submitter) 1 -
(status) 1
'07/06/17
Ziggy stardust_0.2 d28
hits:3 rating:0.0000 '07/06/17
54 -
(submitter) 1 -
(status) 1
hits:103 rating:0.0000 '07/12/03
123 -
(submitter) 1 -
(status) 1
'09/04/30
2009-04-21 7-42-54
hits:24 rating:7.0000 votes:1 '09/04/30
216 -
(submitter) 1 -
(status) 1