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=243 AND (C.region_id=6 OR CS.subscription_id IN (36,37,38,39,40,41,42,76) ) GROUP BY C.company_id ORDER BY C.name ASC