report-one-ip.xql
DB Query file
Related Files
- packages/download/www/admin/report-one-ip.xql
- packages/download/www/admin/report-one-ip.tcl
- packages/download/www/admin/report-one-ip.adp
- packages/download/www/admin/report-one-ip-postgresql.xql
- packages/download/www/admin/report-one-ip-oracle.xql
[ hide source ] | [ make this the default ]
File Contents
<?xml version="1.0"?>
<queryset>
<fullquery name="users_to_spam">
<querytext>
select distinct user_id
from download_downloads_repository d
where d.repository_id = :repository_id
and d.download_ip = :download_ip
[ad_dimensional_sql $dimensional where]
</querytext>
</fullquery>
</queryset>