SELECT DISTINCT summary.info_hash AS hash, summary.seeds, summary.leechers, summary.finished AS finished, summary.dlbytes AS dwned, namemap.id, namemap.filename, namemap.file_view, namemap.url, namemap.info, namemap.anonymous, summary.speed, UNIX_TIMESTAMP( namemap.DATA ) AS added, namemap.size, namemap.external, namemap.uploader AS upname, users.username AS uploader, prefixcolor, suffixcolor

FROM category_namemap, summary

LEFT JOIN namemap ON summary.info_hash = namemap.info_hash

LEFT JOIN users ON users.id = namemap.uploader

LEFT JOIN users_level ON users.id_level = users_level.id

WHERE 1 =1

AND category_namemap.torrent_hash = summary.info_hash

AND category_namemap.category_id

IN ( 66 )

AND namemap.filename LIKE '%%'

AND namemap.info_hash = summary.info_hash

ORDER BY id DESC LIKE 0,10

 

SELECT * FROM country_map