select d.registered_name, de.agl_akc_title_prefix, agl_registered_name_raw, agl_akc_title_suffix, d.updated_at from dogs2 d
  join dogs_extra_information2 de ON d.id = de.dog_id
  join entrant_classes ec ON ec.dog_id = d.id AND ec.class_id = 8
where d.updated_at > '2018-01-10 19:12:52'