SELECT C.*, CONVERT(GROUP_CONCAT(CS.subscription_id),CHAR) AS sub_ids, DATE_ADD(C.subscription_end,INTERVAL 1 MONTH) as subscription_end_ext, R.name as region_name FROM #__ecompany AS C INNER JOIN #__ecompany_categories AS CC ON C.company_id=CC.company_id INNER JOIN #__ecompany_subscriptions AS CS ON C.company_id=CS.company_id INNER JOIN #__eregion AS R ON C.region_id=R.region_id WHERE C.published=1 AND category_id=359 AND (C.region_id=45 OR CS.subscription_id IN (50,51,52,53,54,55,56,78) ) GROUP BY C.company_id ORDER BY C.name ASC