Error:
Can't do SQL query - Unknown column 'cname' in 'order clause'
SELECT namemap.tow, namemap.info_hash as hash, namemap.seeds + ifnull(xbt_files.seeders, 0) as seeds, namemap.leechers + ifnull(xbt_files.leechers, 0) as leechers, namemap.finished + ifnull(xbt_files.completed, 0) as finished, namemap.filename, namemap.url, namemap.info, namemap.anonymous, namemap.approved, UNIX_TIMESTAMP( namemap.data ) as added, namemap.category as catid, namemap.size, namemap.external, namemap.uploader as upname, users.username as uploader, users.donor, users.id_level FROM namemap LEFT JOIN users ON users.id = namemap.uploader LEFT JOIN xbt_files ON namemap.info_hash = xbt_files.info_hashhex WHERE namemap.leechers+ifnull(xbt_files.leechers,0)+namemap.seeds+ifnull(xbt_files.seeders,0) > 0 AND namemap.approved='yes' ORDER BY cname ASC LIMIT 0,50
|
