SELECT `t`.`id`,
       `t`.`name`,
       `t`.`sirname`,
       `t`.`sex`,
       `t`.`date_create`,
       `t`.`image_path`,
       COUNT(reviewGood.id) AS reviewCountGood,
       COUNT(reviewBad.id) AS reviewCountBad
FROM `tb_user` `t`
LEFT JOIN `tb_online` `online` ON `t`.`id` = `online`.`id_user`
LEFT JOIN `tb_pro_lawyer` `relProLawyer` ON `t`.`id` = `relProLawyer`.`id_lawyer`
LEFT JOIN `tb_user_rating` `relUserRating` ON `t`.`id` = `relUserRating`.`id_user`
LEFT JOIN `tb_info` ON `t`.`id` = `tb_info`.`id_user`
LEFT JOIN `tb_profile_lawyer` `relProfileLawyer` ON `t`.`id` = `relProfileLawyer`.`id_user`
LEFT JOIN `tb_user_rev_quest` ON `t`.`id` = `tb_user_rev_quest`.`id_user`
LEFT JOIN `tb_status` ON `relProfileLawyer`.`id_status` = `tb_status`.`id`
LEFT JOIN `tb_country` ON `relProfileLawyer`.`id_country` = `tb_country`.`id`
LEFT JOIN `tb_city` ON `relProfileLawyer`.`id_city` = `tb_city`.`id`
LEFT JOIN `tb_review` `reviewGood` ON (`t`.`id` = `reviewGood`.`id_user_whom`)
AND (`reviewGood`.`goodbad`='good')
LEFT JOIN `tb_review` `reviewBad` ON (`t`.`id` = `reviewBad`.`id_user_whom`)
AND (`reviewBad`.`goodbad`='bad')
WHERE (`t`.`username` <> 'admin')
  AND (`t`.`type_user`='lawyer')
  AND (`t`.`del_flag`=0)
  AND (`t`.`id` IN (26044,
                    7903))
GROUP BY `t`.`id`
ORDER BY `current_rating` DESC,
         `reviewCountGood` DESC