SELECT course_status.*, client.course_status FROM `course_status` JOIN client ON (client.id = course_status.client_id) WHERE course_status.client_id=3 ORDER by `course_status`.`datetime` DESC