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=254 AND (C.region_id=4 OR CS.subscription_id IN (22,23,24,25,26,27,28,74) ) GROUP BY C.company_id ORDER BY C.name ASC