SELECT * FROM imms_document  WHERE folder ('/Non Clinical',descend) 
AND (LOWER (object_name) LIKE'%sum%' 
OR LOWER (object_name) LIKE '%report%' 
OR LOWER (object_name) LIKE '%text%' 
OR LOWER (object_name) LIKE '%mad%' 
OR LOWER (object_name) LIKE '%final%' 
OR LOWER (object_name) LIKE '%ctd%' 
OR LOWER (object_name) LIKE '%complete%'
OR object_name NOT LIKE'%TK%'
OR LOWER(object_name) NOT LIKE'%table%'
OR LOWER(object_name) NOT LIKE'%clin%'
OR LOWER(object_name) NOT LIKE'%food%'
OR LOWER(object_name) NOT LIKE'%urin%'
OR LOWER(object_name) NOT LIKE'%app%'
OR LOWER(object_name) NOT LIKE'%bod%'
OR LOWER(object_name) NOT LIKE'%org%'
OR LOWER(object_name) NOT LIKE'%cns%'
OR LOWER(object_name) NOT LIKE'%front%'
OR LOWER(object_name) NOT LIKE'%bdwt%'
OR LOWER(object_name) NOT LIKE'%haem%'
OR LOWER(object_name) NOT LIKE'%coag%'
OR LOWER(object_name) NOT LIKE'%eye%'
OR LOWER(object_name) NOT LIKE'%ecg%'
OR LOWER(object_name) NOT LIKE'%publishing%'
OR LOWER(object_name) NOT LIKE'%chem%'
OR LOWER(object_name) NOT LIKE'%sig%'
OR LOWER(object_name) NOT LIKE'%fig%'
OR LOWER(object_name) NOT LIKE'%serum%'
OR LOWER(object_name) NOT LIKE'%plasma%'
OR LOWER(object_name) NOT LIKE'%micro%'
OR LOWER(object_name) NOT LIKE'%gpsum%'
OR LOWER(object_name) NOT LIKE'%statement%')
AND "r_creation_date" >= DATE('01/01/2006') 
AND "r_creation_date" < DATE('01/01/2007')
AND LOWER(title) LIKE '%toxicity%'
AND object_name NOT LIKE'%PRF%'