SELECT ff.*,
       COUNT(reviewGood.id) AS reviewCountGood,
       COUNT(reviewBad.id) AS reviewCountBad
FROM
  (SELECT `t`.`id`,
          `t`.`name`,
          `t`.`sirname`,
          `t`.`sex`,
          `t`.`date_create`,
          `t`.`image_path`,
          current_rating
   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`
   WHERE (`t`.`username` <> 'admin')
     AND (`t`.`type_user`='lawyer')
     AND (`t`.`del_flag`=0)-- AND (`t`.`id` IN (26044,
 --                     7903))
 -- ORDER BY    relUserRating.`current_rating` DESC
 ) ff
LEFT JOIN `tb_review` `reviewGood` ON (`ff`.`id` = `reviewGood`.`id_user_whom`)
AND (`reviewGood`.`goodbad`='good')
LEFT JOIN `tb_review` `reviewBad` ON (`ff`.`id` = `reviewBad`.`id_user_whom`)
AND (`reviewBad`.`goodbad`='bad')
GROUP BY `ff`.`id`
ORDER BY `reviewCountGood` DESC,
         ff.current_rating DESC -- limit 15