dat_sql.sql

SELECT submissions.*
FROM submission
INNER JOIN 
  (
    SELECT submission_id, max(id) as max_id
    FROM statuses
    GROUP BY submission_id
  ) sub_query
  ON submissions.id = sub_query.submission_id
INNER JOIN statuses
  ON statuses.id = sub_query.max_id
  AND statuses.status LIKE 'robots'