altho not an answer to your question, you might want to start using table name aliases, to make queries more readable.
so instead of: SELECT dsclient_logs.ev_id,dsclient_ logs.type,to_timestamp(dsclient_logs.ev_time) as timestamp,dsclient_logs.category,dsclient_logs.error,dsclient_logs.ev_text,dsclient_logs.userid,dsclient_logs.ex_long,dsclient_logs.client_ex_long,dsclient_logs.ex_text,backup_sets.set_name,customer.company_name,customer.account_num FROM dsclient_logs INNER JOIN connection_log ON dsclient_logs.ex_long = connection_log.session_id AND dsclient_logs.userid = connection_log.dsbox_snum INNER JOIN backup_sets ON connection_log.set_id = backup_sets.set_id INNER JOIN customer ON connection_log.account_num = customer.account_num ORDER BY dsclient_logs.ev_id desc LIMIT 100 you would do: SELECT dsl.*, sb.set_name, c.company_name, c.account_num FROM dsclient_logs dsl INNER JOIN connection_log cl ON dsl.ex_long = cl.session_id AND dsl.userid = cl.dsbox_snum INNER JOIN backup_sets bs ON cl.set_id = bs.set_id INNER JOIN customer c ON cl.account_num = c.account_num ORDER BY dsl.ev_id desc LIMIT 100 etc.
