Есть запрос:
CODE (sql):
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT torrents.seeders, torrents.karma, torrents.banned, torrents.languages, torrents.leechers, torrents.info_hash, torrents.filename, UNIX_TIMESTAMP() - UNIX_TIMESTAMP(torrents.last_action) AS lastseed, torrents.name, torrents.owner, torrents.save_as, torrents.descr, torrents.size, torrents.added, torrents.views, torrents.hits, torrents.times_completed, torrents.id, torrents.type, torrents.imdb, torrents.new, torrents.numfiles, torrents.image1, torrents.image2, torrents.image3, torrents.image4, categories.id, categories.name AS cat_name, users.id, users.class, users.username " . ($CURUSER ? ", (SELECT COUNT(*) FROM karma WHERE type='torrent' AND value = torrents.id AND user = $CURUSER[id]) AS canrate" : "") . " FROM torrents LEFT JOIN categories ON torrents.category = categories.id LEFT JOIN users ON torrents.owner = users.id WHERE torrents.id = $id