Comment 1 for bug 781220

Here is an example of SQL query as displayed in the administration console :

1) => select distinct id as HARDWARE_ID from hardware where id not in (select distinct HARDWARE_ID from groups_cache where ( ( GROUP_ID = 1847 OR GROUP_ID = 2731)))
2) => select distinct id as HARDWARE_ID from hardware where id not in (select distinct HARDWARE_ID from devices where ( ( NAME like 'DOWNLOAD' AND IVALUE IN IN (select id from download_enable where fileid=1288341377) )))

That query look correct as far as I can tell.

The result is :

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN (select id from download_enable where fileid=1288341377) ))) and id in (20,23' at line 1