What is going on with my user and max date query?
I've tried to rid of the excessive parentheses and backticks so I've got the next query: 

  SELECT 
    t1.uid,
    t1.LogDate AS touchdate
  FROM      ref_source_page_log_report AS t1
  LEFT JOIN ref_source_page_log_report AS t2 
         ON t1.uid = t2.uid 
        AND ( t1.LogDate &lt; t2.LogDate OR
            ( t1.LogDate = t2.LogDate AND t1.id &lt; t2.id ))
                 -- Here was the problem: ^^^^^^^^^^^^^ (uids instead of ids)
  WHERE t2.uid IS NULL
  LIMIT 10000