SELECT
				c.*
				 , cm.contact_value AS email
			FROM  ((
        	SELECT
        		c.contact_id AS `company_id`,
        		c.search_name AS `company_name`
        		,c.contact_id

        	FROM contacts AS c
         LEFT JOIN projects as p on (c.contact_id = p.company_id  AND p.is_deleted = "0") WHERE c.is_deleted="0"  AND (c.contact_type="company") AND p.project_id = :project_id GROUP BY c.contact_id  order by c.search_name limit 50) UNION ALL (
        	SELECT
        		c.contact_id AS `company_id`,
        		c.search_name AS `company_name`
        		,c.contact_id

        	FROM contacts AS c
         WHERE c.is_deleted="0"  AND (c.contact_type="company") AND c.contact_type = "company" AND c.is_deleted = "0"
			GROUP BY c.contact_id
			ORDER BY c.search_name
		 LIMIT 50)) AS c
			 LEFT JOIN contacts_means_of_contact AS cm ON (c.contact_id = cm.contact_id AND means_type="email" AND is_default="1")
			LIMIT 50