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` = 369 AND
`telekomblog_cat_providers`.`is_deleted` = 0
GROUP BY `telekomblog_cat_providers`.`id_provider`
ORDER BY `name`;