Optimise Model function?

[eluser]Dam1an[/eluser]
Have you tried with a join? Something like...

Code:

SELECT `companies`.`id`, `companies`.`name`, COUNT(`coupons`.`id`) AS `coupon_count`
FROM `companies`
JOIN `coupons` ON `companies`.`id` = `coupons`.`company`
WHERE `featured` = 1