""" <pre class="jdatabasequery">\n SELECT DISTINCT a.*,comp.company_name AS company_name, comp.contact AS contact, comp.phone AS phone, comp.cell AS cell, comp.fax AS fax, comp.email AS email, comp.id_country, a.id_activity,codet.name AS country\n FROM `uesu_esubcontratacion_enqueries` AS a\n LEFT JOIN uesu_esubcontratacion_enquery_companies AS comp ON comp.id = a.id_enquery_company\n LEFT OUTER JOIN uesu_esubcontratacion_countries AS co ON co.id = comp.id_country\n LEFT OUTER JOIN uesu_esubcontratacion_country_details AS codet ON (co.id = codet.id_country AND codet.language = "es-ES")\n LEFT OUTER JOIN `uesu_esubcontratacion_activities` AS ac ON (ac.id = a.id_activity)\n LEFT JOIN uesu_users AS created_by ON created_by.id = a.created_by\n WHERE a.state = 1 AND a.in_directory = 1\n ORDER BY created desc</pre> """
Oportunidades de negocio en Subcontex Gipuzkoa
A continuación, se muestran algunas oportunidades de negocio conseguidas como ejemplo de oportunidades que se envían a las empresas asociadas a Subcontex Gipuzkoa.
