SELECT `telekomblog_cat_providers`.`id_provider`, `telekomblog_cat_providers`.`provider_code`, `telekomblog_cat_providers`.`name`, `telekomblog_cat_providers`.`rate`, (`telekomblog_cat_providers`.`rate` + 0.2*COUNT(`rates`.`date`)) AS `new_rate` FROM `telekomblog_cat_provider_city_link` INNER JOIN `telekomblog_cat_providers` ON `telekomblog_cat_provider_city_link`.`id_provider` = `telekomblog_cat_providers`.`id_provider` LEFT JOIN `telekomblog_cat_rates` AS `rates` ON `rates`.`id_provider` = `telekomblog_cat_providers`.`id_provider` WHERE `telekomblog_cat_provider_city_link`.`id_city` = 324 AND `telekomblog_cat_providers`.`is_deleted` = 0 GROUP BY `telekomblog_cat_providers`.`id_provider` ORDER BY `name`;