select `members`.*, `academic_ranks`.`name` as `acadename`, `degrees`.`name` as `degreesname` from `members` leftjoin `academic_ranks` on `members`.`academic_ranks` = `academic_ranks`.`id` leftjoin `degrees` on `members`.`degree` = `degrees`.`id` where `members`.`status` =3orderby SUBSTRING_INDEX(members.name, ' ', -1) ASC
select `members`.*, `academic_ranks`.`name` as `acadename`, `degrees`.`name` as `degreesname` from `members` leftjoin `academic_ranks` on `members`.`academic_ranks` = `academic_ranks`.`id` leftjoin `degrees` on `members`.`degree` = `degrees`.`id` where `members`.`status` =2orderby SUBSTRING_INDEX(members.name, ' ', -1) ASC
select `members`.*, `academic_ranks`.`name` as `acadename`, `degrees`.`name` as `degreesname` from `members` leftjoin `academic_ranks` on `members`.`academic_ranks` = `academic_ranks`.`id` leftjoin `degrees` on `members`.`degree` = `degrees`.`id` where `members`.`status` =4orderby SUBSTRING_INDEX(members.name, ' ', -1) ASC
select `members`.*, `same_authorsables`.`same_authors_id` as `pivot_same_authors_id`, `same_authorsables`.`members_id` as `pivot_members_id`, `same_authorsables`.`same_authors_type` as `pivot_same_authors_type` from `members` innerjoin `same_authorsables` on `members`.`id` = `same_authorsables`.`members_id` where `same_authorsables`.`same_authors_id` in (1134, 1135, 1137) and `same_authorsables`.`same_authors_type` ='App\Models\Prints'