Individual File Downloads
- user warning: Table 'usr_web8_1.download_count' doesn't exist
query: SELECT COUNT(*) FROM (SELECT download_count.dcid AS dcid
FROM download_count download_count
LEFT JOIN files files_download_count ON download_count.fid = files_download_count.fid
WHERE (SELECT COUNT(dc.fid) FROM download_count dc WHERE dc.fid = files_download_count.fid) > '0'
) count_alias in /var/www/web8/html/sites/all/modules/views/includes/view.inc on line 805.
- user warning: Table 'usr_web8_1.download_count' doesn't exist
query: SELECT download_count.dcid AS dcid,
files_download_count.filename AS files_download_count_filename,
files_download_count.filepath AS files_download_count_filepath,
files_download_count.fid AS files_download_count_fid,
files_download_count.filemime AS files_download_count_filemime,
files_download_count.filesize AS files_download_count_filesize,
download_count.ip_address AS download_count_ip_address,
download_count.referrer AS download_count_referrer,
download_count.timestamp AS download_count_timestamp,
(SELECT COUNT(dc.fid) FROM download_count dc WHERE dc.fid = files_download_count.fid) AS files_download_count_downloads
FROM download_count download_count
LEFT JOIN files files_download_count ON download_count.fid = files_download_count.fid
WHERE (SELECT COUNT(dc.fid) FROM download_count dc WHERE dc.fid = files_download_count.fid) > '0'
ORDER BY files_download_count_downloads DESC
LIMIT 0, 25 in /var/www/web8/html/sites/all/modules/views/includes/view.inc on line 810.