| 1 | SELECT `SuccessHistory`.`success_history_id`, `SuccessHistory`.`initial_name`, `SuccessHistory`.`arrival_year`, `SuccessHistory`.`departure_year`, `SuccessHistory`.`member_status`, `SuccessHistory`.`display_in_home`, `SuccessHistory`.`employee_photo`, `Institute`.`ins_title`, `Location`.`loc_title`, `SuccessHistory`.`institute_id`, `SuccessHistory`.`loc_id`, `SuccessHistory`.`other_institute` FROM `dev2_global_new`.`sjs_success_histories` AS `SuccessHistory` LEFT JOIN `dev2_global_new`.`sjs_institutes` AS `Institute` ON (`SuccessHistory`.`institute_id` = `Institute`.`ins_id`) LEFT JOIN `dev2_global_new`.`sjs_locations` AS `Location` ON (`SuccessHistory`.`loc_id` = `Location`.`loc_id`) WHERE `SuccessHistory`.`member_status` = 'Active' ORDER BY `SuccessHistory`.`arrival_year` desc LIMIT 4 | | 4 | 4 | 1 |