SELECT *,FLOOR(`t`.`rateSumm` / `commentsCount`) AS `rate`
FROM (SELECT `i`.`id`,
`i`.`logoLink`,`i`.`hide_info`,`i`.`name`,`i`.`number`,`i`.`nameext`,`i`.`date`,`i`.`timework`,`i`.`site`,`i`.`site_active_status`,`i`.`email`,`i`.`email_active_status`,
`c`.`id` AS `city_id`,`c`.`name` AS `city`,`v`.`firmRating`,
`i`.`addr`,`i`.`phone`,`i`.`info`,`i`.`director`,`i`.`yurname`,`i`.`comment`,`i`.`place_date`,`p`.`id` AS `period_id`,`p`.`days` AS `period_days`,
IF(`u`.`tariffId` >= 3,1,0) AS `priority`,
COUNT(`fc`.`id`) AS `commentsCount`, SUM(`fc`.`rate`) AS `rateSumm`
FROM `firms` AS `i`
LEFT JOIN `usersFirmsLink` AS `ufl` ON  `ufl`.`firmId` = `i`.`id`
LEFT JOIN `users` AS `u` ON `u`.`id` = `ufl`.`userId`
INNER JOIN `sp_city` AS `c` ON `c`.`id` = `i`.`city`
INNER JOIN `sp_item_place_periods` AS `p` ON `p`.`id` = `i`.`period_status`
INNER JOIN `firmsSubcatsLink` AS `v` ON  `v`.`firmId` = `i`.`id`
LEFT JOIN `firmsComments` AS `fc` ON  `fc`.`firmId` = `i`.`id`
LEFT JOIN `sp_item_offices` AS `o` ON `o`.`item_id` = `i`.`id`
WHERE `moderated` = "1"
GROUP BY `i`.`id`) AS `t`
ORDER BY `t`.`date` DESC,`t`.`rateSumm` DESC, `t`.`name` ASC,`t`.`priority` DESC