SELECT tInfARCLogs.[date-calculated], tInfARCLogs.time, tInfARCLogs.ID, tInfARCLogs.[c-ip], tInfARCLogs.[s-sitename], tInfARCLogs.[cs-uri-stem], tInfARCLogs.[cs(User-Agent)], tInfARCLogs.[s-computername], tInfARCLogs.[s-ip], tInfARCLogs.[cs-method], tInfARCLogs.[cs-uri-query], tInfARCLogs.[s-port], tInfARCLogs.[cs-username], tInfARCLogs.[cs-version], tInfARCLogs.[cs(Cookie)], tInfARCLogs.[cs(Referer)], tInfARCLogs.[cs-host], tInfARCLogs.[sc-status], tInfARCLogs.[sc-substatus], tInfARCLogs.[sc-win32-status], tInfARCLogs.[sc-bytes], tInfARCLogs.[cs-bytes]
FROM tqDateARCLogsSimple, tInfARCLogs
WHERE (((tInfARCLogs.[date-calculated])>=[tqDateARCLogsSimple].[from] And (tInfARCLogs.[date-calculated])<=[tqDateARCLogsSimple].[to]) AND ((tInfARCLogs.[c-ip]) Is Null) AND ((tInfARCLogs.[s-sitename])<>"time") 
AND ((tInfARCLogs.[cs-uri-stem]) Not Like "/images/*" 
   And (tInfARCLogs.[cs-uri-stem]) Not Like "/DrArt/images/*" 
   And (tInfARCLogs.[cs-uri-stem]) Not Like "/_vti_bin/fpcount.exe/") 
AND ((tInfARCLogs.[cs(User-Agent)]) Not Like "*boitho.com/dcbot.html*" 
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "Mozilla/5.0+(compatible;+BecomeBot/2.3;+MSIE+6.0+compatible;++http://www.become.com/site_owners.html)"
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "Exabot*"
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "*girafabot*"
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "ia_archiver"
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "Gigabot/*"
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "snap.com+beta+crawler+v0"
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "SurveyBot*" 
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "*SBIder*" 
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "*Zyborg*" 
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "*Yahoo*" 
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "*Ask+Jeeves/Teoma*" 
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "*Googlebot*"
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "*msn.com/msnbot*")) 
OR (((tInfARCLogs.[date-calculated])>=[tqDateARCLogsSimple].[from] And (tInfARCLogs.[date-calculated])<=[tqDateARCLogsSimple].[to]) AND ((tInfARCLogs.[c-ip])<>"REDACTED" And (tInfARCLogs.[c-ip])<>REDACTED") AND ((tInfARCLogs.[s-sitename])<>"time") 
AND ((tInfARCLogs.[cs-uri-stem]) Not Like "/images/*" 
   And (tInfARCLogs.[cs-uri-stem]) Not Like "/DrArt/images/*" 
   And (tInfARCLogs.[cs-uri-stem]) Not Like "/_vti_bin/fpcount.exe/") 
AND ((tInfARCLogs.[cs(User-Agent)]) Not Like "*boitho.com/dcbot.html*"
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "Mozilla/5.0+(compatible;+BecomeBot/2.3;+MSIE+6.0+compatible;++http://www.become.com/site_owners.html)"
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "Exabot*"
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "*girafabot*"
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "ia_archiver"
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "Gigabot*"
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "snap.com+beta+crawler+v0"
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "SurveyBot*" 
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "*SBIder*" 
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "*Zyborg*" 
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "*Yahoo*" 
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "*Ask+Jeeves/Teoma*" 
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "*Googlebot*" 
   And (tInfARCLogs.[cs(User-Agent)]) Not Like "*msn.com/msnbot*"))
ORDER BY tInfARCLogs.[date-calculated], tInfARCLogs.time, tInfARCLogs.ID;