BioAs founder of Cambridge Capital, Gary has been involved in all phases of the firm’s development since its founding in late 2007 and is responsible for the overall strategy and management of the company. Gary co-founded Ascendis Health Limited in 2008 which has grown to become the second largest provider of health products in Africa, and co-founded Bounty Brands (Pty) Ltd in 2014 and Marlin Homeware (Pty) Ltd in 201 ....
Education
Degrees
-
Notice (8): Trying to get property of non-object [APP/Template/Professionals/profile.ctp, line 220]
, Chartered Accountant,Code Context?><li><?php echo $ProfessionalEducationalQualsList->university->university_name.','; ?> <?php echo $ProfessionalEducationalQualsList->prof_degree.','; ?> <?php echo $ProfessionalEducationalQualsList->prof_field; ?>$viewFile = '/home/acquireprime/public_html/src/Template/Professionals/profile.ctp' $dataForView = [ 'Professional_id' => (int) 15052, 'ProfessionalExperiences' => object(Cake\ORM\ResultSet) { 'items' => [[maximum depth reached]] }, 'ProfessionalBoardSeats1' => object(Cake\ORM\ResultSet) { 'items' => [[maximum depth reached]] }, 'ProfessionalBoardSeats' => object(Cake\ORM\ResultSet) { 'items' => [[maximum depth reached]] }, 'ProfessionalEducationalQuals' => object(Cake\ORM\ResultSet) { 'items' => [ [maximum depth reached] ] }, 'companiesCount' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Companies.company_id AS `Companies__company_id`, Companies.company_name AS `Companies__company_name`, Companies.company_former_name_one AS `Companies__company_former_name_one`, Companies.company_former_name_two AS `Companies__company_former_name_two`, Companies.company_sector_id AS `Companies__company_sector_id`, Companies.company_entity_type_id AS `Companies__company_entity_type_id`, Companies.company_active_status AS `Companies__company_active_status`, Companies.company_ceased_year AS `Companies__company_ceased_year`, Companies.company_parent_id AS `Companies__company_parent_id`, Companies.company_parent_type AS `Companies__company_parent_type`, Companies.company_stock_exchange_id AS `Companies__company_stock_exchange_id`, Companies.company_symbol AS `Companies__company_symbol`, Companies.company_is_public AS `Companies__company_is_public`, Companies.company_ipo_year AS `Companies__company_ipo_year`, Companies.company_delisted_year AS `Companies__company_delisted_year`, Companies.company_description AS `Companies__company_description`, Companies.company_phone AS `Companies__company_phone`, Companies.company_fax AS `Companies__company_fax`, Companies.company_toll_free AS `Companies__company_toll_free`, Companies.company_url AS `Companies__company_url`, Companies.company_address AS `Companies__company_address`, Companies.company_city AS `Companies__company_city`, Companies.company_postal_code AS `Companies__company_postal_code`, Companies.company_state_id AS `Companies__company_state_id`, Companies.company_country_id AS `Companies__company_country_id`, Companies.company_employees AS `Companies__company_employees`, Companies.company_year_established AS `Companies__company_year_established`, Companies.company_last_updated AS `Companies__company_last_updated`, Companies.company_is_deleted AS `Companies__company_is_deleted`, Companies.admin_profile_date AS `Companies__admin_profile_date`, Companies.profile_image AS `Companies__profile_image`, Companies.profile_keywords AS `Companies__profile_keywords`, CompTrans.comp_transaction_id AS `CompTrans__comp_transaction_id`, CompTrans.company_id AS `CompTrans__company_id`, CompTrans.investment_announced_dt AS `CompTrans__investment_announced_dt`, CompTrans.exit_announced_dt AS `CompTrans__exit_announced_dt`, CompTrans.investment_closed_dt AS `CompTrans__investment_closed_dt`, CompTrans.exit_closed_dt AS `CompTrans__exit_closed_dt`, CompTrans.acquisition_type_id AS `CompTrans__acquisition_type_id`, CompTrans.exit_type_id AS `CompTrans__exit_type_id`, CompTrans.deal_value AS `CompTrans__deal_value`, CompTrans.inv_currency_id AS `CompTrans__inv_currency_id`, CompTrans.investment_revenue AS `CompTrans__investment_revenue`, CompTrans.investment_ebitda AS `CompTrans__investment_ebitda`, CompTrans.exit_value AS `CompTrans__exit_value`, CompTrans.exit_currency_id AS `CompTrans__exit_currency_id`, CompTrans.exit_revenue AS `CompTrans__exit_revenue`, CompTrans.exit_ebitda AS `CompTrans__exit_ebitda`, CompTrans.investment_annced_pr_link AS `CompTrans__investment_annced_pr_link`, CompTrans.investment_closed_pr_link AS `CompTrans__investment_closed_pr_link`, CompTrans.exit_annced_pr_link AS `CompTrans__exit_annced_pr_link`, CompTrans.exit_closed_pr_link AS `CompTrans__exit_closed_pr_link`, CompTrans.active_status AS `CompTrans__active_status`, CompTrans.parent_tran_id AS `CompTrans__parent_tran_id`, CompTrans.child_tran_id AS `CompTrans__child_tran_id`, CompInvestors.comp_tran_inv_id AS `CompInvestors__comp_tran_inv_id`, CompInvestors.comp_transaction_id AS `CompInvestors__comp_transaction_id`, CompInvestors.comp_tran_investor_id AS `CompInvestors__comp_tran_investor_id`, CompInvestors.comp_tran_investor_type AS `CompInvestors__comp_tran_investor_type`, CompInvestors.comp_investment_amount AS `CompInvestors__comp_investment_amount`, CompInvestors.comp_investment_stake AS `CompInvestors__comp_investment_stake`, CompInvestors.comp_investment_currency_id AS `CompInvestors__comp_investment_currency_id`, CompInvestors.comp_investment_position AS `CompInvestors__comp_investment_position`, CompInvestors.comp_investment_inv_ann_dt AS `CompInvestors__comp_investment_inv_ann_dt`, CompInvestors.comp_investment_inv_cl_dt AS `CompInvestors__comp_investment_inv_cl_dt`, CompInvestors.comp_investment_exit_ann_dt AS `CompInvestors__comp_investment_exit_ann_dt`, CompInvestors.comp_investment_exit_cl_dt AS `CompInvestors__comp_investment_exit_cl_dt`, CompInvestors.comp_investment_acqui_type_id AS `CompInvestors__comp_investment_acqui_type_id`, CompInvestors.comp_investment_exit_type_id AS `CompInvestors__comp_investment_exit_type_id`, CompInvestors.comp_invst_inv_ann_pr_link AS `CompInvestors__comp_invst_inv_ann_pr_link`, CompInvestors.comp_invst_inv_cl_pr_link AS `CompInvestors__comp_invst_inv_cl_pr_link`, CompInvestors.comp_invst_exit_ann_pr_link AS `CompInvestors__comp_invst_exit_ann_pr_link`, CompInvestors.comp_invst_exit_closed_pr_link AS `CompInvestors__comp_invst_exit_closed_pr_link`, InvestorProfessionals.professional_id AS `InvestorProfessionals__professional_id`, InvestorProfessionals.professional_company_id AS `InvestorProfessionals__professional_company_id`, InvestorProfessionals.professional_company_type AS `InvestorProfessionals__professional_company_type`, InvestorProfessionals.prof_name AS `InvestorProfessionals__prof_name`, InvestorProfessionals.prof_email AS `InvestorProfessionals__prof_email`, InvestorProfessionals.prof_designation AS `InvestorProfessionals__prof_designation`, InvestorProfessionals.prof_join_dt AS `InvestorProfessionals__prof_join_dt`, InvestorProfessionals.prof_bio AS `InvestorProfessionals__prof_bio`, InvestorProfessionals.prof_phone_number AS `InvestorProfessionals__prof_phone_number`, InvestorProfessionals.prof_fax AS `InvestorProfessionals__prof_fax`, InvestorProfessionals.prof_rank AS `InvestorProfessionals__prof_rank`, InvestorProfessionals.prof_board_seat AS `InvestorProfessionals__prof_board_seat`, InvestorProfessionals.prof_office_id AS `InvestorProfessionals__prof_office_id`, InvestorProfessionals.prof_function AS `InvestorProfessionals__prof_function`, InvestorProfessionals.prof_last_updated AS `InvestorProfessionals__prof_last_updated`, InvestorProfessionals.admin_profile_date AS `InvestorProfessionals__admin_profile_date`, InvestorProfessionals.profile_image AS `InvestorProfessionals__profile_image`, InvestorProfessionals.profile_keywords AS `InvestorProfessionals__profile_keywords`, InvestmentTargetCompany.company_id AS `InvestmentTargetCompany__company_id`, InvestmentTargetCompany.company_name AS `InvestmentTargetCompany__company_name`, InvestmentTargetCompany.company_former_name_one AS `InvestmentTargetCompany__company_former_name_one`, InvestmentTargetCompany.company_former_name_two AS `InvestmentTargetCompany__company_former_name_two`, InvestmentTargetCompany.company_sector_id AS `InvestmentTargetCompany__company_sector_id`, InvestmentTargetCompany.company_entity_type_id AS `InvestmentTargetCompany__company_entity_type_id`, InvestmentTargetCompany.company_active_status AS `InvestmentTargetCompany__company_active_status`, InvestmentTargetCompany.company_ceased_year AS `InvestmentTargetCompany__company_ceased_year`, InvestmentTargetCompany.company_parent_id AS `InvestmentTargetCompany__company_parent_id`, InvestmentTargetCompany.company_parent_type AS `InvestmentTargetCompany__company_parent_type`, InvestmentTargetCompany.company_stock_exchange_id AS `InvestmentTargetCompany__company_stock_exchange_id`, InvestmentTargetCompany.company_symbol AS `InvestmentTargetCompany__company_symbol`, InvestmentTargetCompany.company_is_public AS `InvestmentTargetCompany__company_is_public`, InvestmentTargetCompany.company_ipo_year AS `InvestmentTargetCompany__company_ipo_year`, InvestmentTargetCompany.company_delisted_year AS `InvestmentTargetCompany__company_delisted_year`, InvestmentTargetCompany.company_description AS `InvestmentTargetCompany__company_description`, InvestmentTargetCompany.company_phone AS `InvestmentTargetCompany__company_phone`, InvestmentTargetCompany.company_fax AS `InvestmentTargetCompany__company_fax`, InvestmentTargetCompany.company_toll_free AS `InvestmentTargetCompany__company_toll_free`, InvestmentTargetCompany.company_url AS `InvestmentTargetCompany__company_url`, InvestmentTargetCompany.company_address AS `InvestmentTargetCompany__company_address`, InvestmentTargetCompany.company_city AS `InvestmentTargetCompany__company_city`, InvestmentTargetCompany.company_postal_code AS `InvestmentTargetCompany__company_postal_code`, InvestmentTargetCompany.company_state_id AS `InvestmentTargetCompany__company_state_id`, InvestmentTargetCompany.company_country_id AS `InvestmentTargetCompany__company_country_id`, InvestmentTargetCompany.company_employees AS `InvestmentTargetCompany__company_employees`, InvestmentTargetCompany.company_year_established AS `InvestmentTargetCompany__company_year_established`, InvestmentTargetCompany.company_last_updated AS `InvestmentTargetCompany__company_last_updated`, InvestmentTargetCompany.company_is_deleted AS `InvestmentTargetCompany__company_is_deleted`, InvestmentTargetCompany.admin_profile_date AS `InvestmentTargetCompany__admin_profile_date`, InvestmentTargetCompany.profile_image AS `InvestmentTargetCompany__profile_image`, InvestmentTargetCompany.profile_keywords AS `InvestmentTargetCompany__profile_keywords`, Sector.id AS `Sector__id`, Sector.sector_name AS `Sector__sector_name`, Country.id AS `Country__id`, Country.country_name AS `Country__country_name`, State.id AS `State__id`, State.country_id AS `State__country_id`, State.state_name AS `State__state_name`, StockExchange.id AS `StockExchange__id`, StockExchange.exchange_name AS `StockExchange__exchange_name`, ProfileParent.id AS `ProfileParent__id`, ProfileParent.child_id AS `ProfileParent__child_id`, ProfileParent.child_type AS `ProfileParent__child_type`, ProfileParent.parent_id AS `ProfileParent__parent_id`, ProfileParent.parent_name AS `ProfileParent__parent_name`, ProfileParent.parent_type AS `ProfileParent__parent_type` FROM companies Companies INNER JOIN company_transactions CompTrans ON (parent_tran_id = :c0 AND Companies.company_id = (CompTrans.company_id)) INNER JOIN comp_transaction_investors CompInvestors ON CompTrans.comp_transaction_id = (CompInvestors.comp_transaction_id) INNER JOIN professionals InvestorProfessionals ON (CompInvestors.comp_tran_investor_type = :c1 AND CompInvestors.comp_tran_investor_id = (InvestorProfessionals.professional_id)) INNER JOIN companies InvestmentTargetCompany ON InvestmentTargetCompany.company_id = (CompTrans.company_id) LEFT JOIN sectors Sector ON Companies.company_sector_id = (Sector.id) LEFT JOIN countries Country ON Companies.company_country_id = (Country.id) LEFT JOIN states State ON Companies.company_state_id = (State.id) LEFT JOIN stock_exchanges StockExchange ON Companies.company_stock_exchange_id = (StockExchange.id) LEFT JOIN profile_parents ProfileParent ON (child_type = :c2 AND Companies.company_id = (ProfileParent.child_id)) WHERE (InvestorProfessionals.professional_id = :c3 AND InvestmentTargetCompany.company_is_deleted != :c4) ORDER BY CASE WHEN CompTrans.investment_closed_dt IS NOT NULL THEN CompTrans.investment_closed_dt ELSE CompTrans.investment_announced_dt END DESC', 'params' => [ [maximum depth reached] ], 'defaultTypes' => [ [maximum depth reached] ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ [maximum depth reached] ], 'matching' => [ [maximum depth reached] ], 'extraOptions' => [[maximum depth reached]], 'repository' => object(Admin\Model\Table\CompaniesTable) {} }, 'companies' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Companies.company_id AS `Companies__company_id`, Companies.company_name AS `Companies__company_name`, Companies.company_former_name_one AS `Companies__company_former_name_one`, Companies.company_former_name_two AS `Companies__company_former_name_two`, Companies.company_sector_id AS `Companies__company_sector_id`, Companies.company_entity_type_id AS `Companies__company_entity_type_id`, Companies.company_active_status AS `Companies__company_active_status`, Companies.company_ceased_year AS `Companies__company_ceased_year`, Companies.company_parent_id AS `Companies__company_parent_id`, Companies.company_parent_type AS `Companies__company_parent_type`, Companies.company_stock_exchange_id AS `Companies__company_stock_exchange_id`, Companies.company_symbol AS `Companies__company_symbol`, Companies.company_is_public AS `Companies__company_is_public`, Companies.company_ipo_year AS `Companies__company_ipo_year`, Companies.company_delisted_year AS `Companies__company_delisted_year`, Companies.company_description AS `Companies__company_description`, Companies.company_phone AS `Companies__company_phone`, Companies.company_fax AS `Companies__company_fax`, Companies.company_toll_free AS `Companies__company_toll_free`, Companies.company_url AS `Companies__company_url`, Companies.company_address AS `Companies__company_address`, Companies.company_city AS `Companies__company_city`, Companies.company_postal_code AS `Companies__company_postal_code`, Companies.company_state_id AS `Companies__company_state_id`, Companies.company_country_id AS `Companies__company_country_id`, Companies.company_employees AS `Companies__company_employees`, Companies.company_year_established AS `Companies__company_year_established`, Companies.company_last_updated AS `Companies__company_last_updated`, Companies.company_is_deleted AS `Companies__company_is_deleted`, Companies.admin_profile_date AS `Companies__admin_profile_date`, Companies.profile_image AS `Companies__profile_image`, Companies.profile_keywords AS `Companies__profile_keywords`, CompTrans.comp_transaction_id AS `CompTrans__comp_transaction_id`, CompTrans.company_id AS `CompTrans__company_id`, CompTrans.investment_announced_dt AS `CompTrans__investment_announced_dt`, CompTrans.exit_announced_dt AS `CompTrans__exit_announced_dt`, CompTrans.investment_closed_dt AS `CompTrans__investment_closed_dt`, CompTrans.exit_closed_dt AS `CompTrans__exit_closed_dt`, CompTrans.acquisition_type_id AS `CompTrans__acquisition_type_id`, CompTrans.exit_type_id AS `CompTrans__exit_type_id`, CompTrans.deal_value AS `CompTrans__deal_value`, CompTrans.inv_currency_id AS `CompTrans__inv_currency_id`, CompTrans.investment_revenue AS `CompTrans__investment_revenue`, CompTrans.investment_ebitda AS `CompTrans__investment_ebitda`, CompTrans.exit_value AS `CompTrans__exit_value`, CompTrans.exit_currency_id AS `CompTrans__exit_currency_id`, CompTrans.exit_revenue AS `CompTrans__exit_revenue`, CompTrans.exit_ebitda AS `CompTrans__exit_ebitda`, CompTrans.investment_annced_pr_link AS `CompTrans__investment_annced_pr_link`, CompTrans.investment_closed_pr_link AS `CompTrans__investment_closed_pr_link`, CompTrans.exit_annced_pr_link AS `CompTrans__exit_annced_pr_link`, CompTrans.exit_closed_pr_link AS `CompTrans__exit_closed_pr_link`, CompTrans.active_status AS `CompTrans__active_status`, CompTrans.parent_tran_id AS `CompTrans__parent_tran_id`, CompTrans.child_tran_id AS `CompTrans__child_tran_id`, CompInvestors.comp_tran_inv_id AS `CompInvestors__comp_tran_inv_id`, CompInvestors.comp_transaction_id AS `CompInvestors__comp_transaction_id`, CompInvestors.comp_tran_investor_id AS `CompInvestors__comp_tran_investor_id`, CompInvestors.comp_tran_investor_type AS `CompInvestors__comp_tran_investor_type`, CompInvestors.comp_investment_amount AS `CompInvestors__comp_investment_amount`, CompInvestors.comp_investment_stake AS `CompInvestors__comp_investment_stake`, CompInvestors.comp_investment_currency_id AS `CompInvestors__comp_investment_currency_id`, CompInvestors.comp_investment_position AS `CompInvestors__comp_investment_position`, CompInvestors.comp_investment_inv_ann_dt AS `CompInvestors__comp_investment_inv_ann_dt`, CompInvestors.comp_investment_inv_cl_dt AS `CompInvestors__comp_investment_inv_cl_dt`, CompInvestors.comp_investment_exit_ann_dt AS `CompInvestors__comp_investment_exit_ann_dt`, CompInvestors.comp_investment_exit_cl_dt AS `CompInvestors__comp_investment_exit_cl_dt`, CompInvestors.comp_investment_acqui_type_id AS `CompInvestors__comp_investment_acqui_type_id`, CompInvestors.comp_investment_exit_type_id AS `CompInvestors__comp_investment_exit_type_id`, CompInvestors.comp_invst_inv_ann_pr_link AS `CompInvestors__comp_invst_inv_ann_pr_link`, CompInvestors.comp_invst_inv_cl_pr_link AS `CompInvestors__comp_invst_inv_cl_pr_link`, CompInvestors.comp_invst_exit_ann_pr_link AS `CompInvestors__comp_invst_exit_ann_pr_link`, CompInvestors.comp_invst_exit_closed_pr_link AS `CompInvestors__comp_invst_exit_closed_pr_link`, InvestorProfessionals.professional_id AS `InvestorProfessionals__professional_id`, InvestorProfessionals.professional_company_id AS `InvestorProfessionals__professional_company_id`, InvestorProfessionals.professional_company_type AS `InvestorProfessionals__professional_company_type`, InvestorProfessionals.prof_name AS `InvestorProfessionals__prof_name`, InvestorProfessionals.prof_email AS `InvestorProfessionals__prof_email`, InvestorProfessionals.prof_designation AS `InvestorProfessionals__prof_designation`, InvestorProfessionals.prof_join_dt AS `InvestorProfessionals__prof_join_dt`, InvestorProfessionals.prof_bio AS `InvestorProfessionals__prof_bio`, InvestorProfessionals.prof_phone_number AS `InvestorProfessionals__prof_phone_number`, InvestorProfessionals.prof_fax AS `InvestorProfessionals__prof_fax`, InvestorProfessionals.prof_rank AS `InvestorProfessionals__prof_rank`, InvestorProfessionals.prof_board_seat AS `InvestorProfessionals__prof_board_seat`, InvestorProfessionals.prof_office_id AS `InvestorProfessionals__prof_office_id`, InvestorProfessionals.prof_function AS `InvestorProfessionals__prof_function`, InvestorProfessionals.prof_last_updated AS `InvestorProfessionals__prof_last_updated`, InvestorProfessionals.admin_profile_date AS `InvestorProfessionals__admin_profile_date`, InvestorProfessionals.profile_image AS `InvestorProfessionals__profile_image`, InvestorProfessionals.profile_keywords AS `InvestorProfessionals__profile_keywords`, InvestmentTargetCompany.company_id AS `InvestmentTargetCompany__company_id`, InvestmentTargetCompany.company_name AS `InvestmentTargetCompany__company_name`, InvestmentTargetCompany.company_former_name_one AS `InvestmentTargetCompany__company_former_name_one`, InvestmentTargetCompany.company_former_name_two AS `InvestmentTargetCompany__company_former_name_two`, InvestmentTargetCompany.company_sector_id AS `InvestmentTargetCompany__company_sector_id`, InvestmentTargetCompany.company_entity_type_id AS `InvestmentTargetCompany__company_entity_type_id`, InvestmentTargetCompany.company_active_status AS `InvestmentTargetCompany__company_active_status`, InvestmentTargetCompany.company_ceased_year AS `InvestmentTargetCompany__company_ceased_year`, InvestmentTargetCompany.company_parent_id AS `InvestmentTargetCompany__company_parent_id`, InvestmentTargetCompany.company_parent_type AS `InvestmentTargetCompany__company_parent_type`, InvestmentTargetCompany.company_stock_exchange_id AS `InvestmentTargetCompany__company_stock_exchange_id`, InvestmentTargetCompany.company_symbol AS `InvestmentTargetCompany__company_symbol`, InvestmentTargetCompany.company_is_public AS `InvestmentTargetCompany__company_is_public`, InvestmentTargetCompany.company_ipo_year AS `InvestmentTargetCompany__company_ipo_year`, InvestmentTargetCompany.company_delisted_year AS `InvestmentTargetCompany__company_delisted_year`, InvestmentTargetCompany.company_description AS `InvestmentTargetCompany__company_description`, InvestmentTargetCompany.company_phone AS `InvestmentTargetCompany__company_phone`, InvestmentTargetCompany.company_fax AS `InvestmentTargetCompany__company_fax`, InvestmentTargetCompany.company_toll_free AS `InvestmentTargetCompany__company_toll_free`, InvestmentTargetCompany.company_url AS `InvestmentTargetCompany__company_url`, InvestmentTargetCompany.company_address AS `InvestmentTargetCompany__company_address`, InvestmentTargetCompany.company_city AS `InvestmentTargetCompany__company_city`, InvestmentTargetCompany.company_postal_code AS `InvestmentTargetCompany__company_postal_code`, InvestmentTargetCompany.company_state_id AS `InvestmentTargetCompany__company_state_id`, InvestmentTargetCompany.company_country_id AS `InvestmentTargetCompany__company_country_id`, InvestmentTargetCompany.company_employees AS `InvestmentTargetCompany__company_employees`, InvestmentTargetCompany.company_year_established AS `InvestmentTargetCompany__company_year_established`, InvestmentTargetCompany.company_last_updated AS `InvestmentTargetCompany__company_last_updated`, InvestmentTargetCompany.company_is_deleted AS `InvestmentTargetCompany__company_is_deleted`, InvestmentTargetCompany.admin_profile_date AS `InvestmentTargetCompany__admin_profile_date`, InvestmentTargetCompany.profile_image AS `InvestmentTargetCompany__profile_image`, InvestmentTargetCompany.profile_keywords AS `InvestmentTargetCompany__profile_keywords`, Sector.id AS `Sector__id`, Sector.sector_name AS `Sector__sector_name`, Country.id AS `Country__id`, Country.country_name AS `Country__country_name`, State.id AS `State__id`, State.country_id AS `State__country_id`, State.state_name AS `State__state_name`, StockExchange.id AS `StockExchange__id`, StockExchange.exchange_name AS `StockExchange__exchange_name`, ProfileParent.id AS `ProfileParent__id`, ProfileParent.child_id AS `ProfileParent__child_id`, ProfileParent.child_type AS `ProfileParent__child_type`, ProfileParent.parent_id AS `ProfileParent__parent_id`, ProfileParent.parent_name AS `ProfileParent__parent_name`, ProfileParent.parent_type AS `ProfileParent__parent_type` FROM companies Companies INNER JOIN company_transactions CompTrans ON (parent_tran_id = :c0 AND Companies.company_id = (CompTrans.company_id)) INNER JOIN comp_transaction_investors CompInvestors ON CompTrans.comp_transaction_id = (CompInvestors.comp_transaction_id) INNER JOIN professionals InvestorProfessionals ON (CompInvestors.comp_tran_investor_type = :c1 AND CompInvestors.comp_tran_investor_id = (InvestorProfessionals.professional_id)) INNER JOIN companies InvestmentTargetCompany ON InvestmentTargetCompany.company_id = (CompTrans.company_id) LEFT JOIN sectors Sector ON Companies.company_sector_id = (Sector.id) LEFT JOIN countries Country ON Companies.company_country_id = (Country.id) LEFT JOIN states State ON Companies.company_state_id = (State.id) LEFT JOIN stock_exchanges StockExchange ON Companies.company_stock_exchange_id = (StockExchange.id) LEFT JOIN profile_parents ProfileParent ON (child_type = :c2 AND Companies.company_id = (ProfileParent.child_id)) WHERE (InvestorProfessionals.professional_id = :c3 AND InvestmentTargetCompany.company_is_deleted != :c4) ORDER BY CASE WHEN CompTrans.investment_closed_dt IS NOT NULL THEN CompTrans.investment_closed_dt ELSE CompTrans.investment_announced_dt END DESC LIMIT 2', 'params' => [ [maximum depth reached] ], 'defaultTypes' => [ [maximum depth reached] ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ [maximum depth reached] ], 'matching' => [ [maximum depth reached] ], 'extraOptions' => [[maximum depth reached]], 'repository' => object(Admin\Model\Table\CompaniesTable) {} }, 'coteam' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Professionals.professional_id AS `Professionals__professional_id`, Professionals.professional_company_id AS `Professionals__professional_company_id`, Professionals.professional_company_type AS `Professionals__professional_company_type`, Professionals.prof_name AS `Professionals__prof_name`, Professionals.prof_email AS `Professionals__prof_email`, Professionals.prof_designation AS `Professionals__prof_designation`, Professionals.prof_join_dt AS `Professionals__prof_join_dt`, Professionals.prof_bio AS `Professionals__prof_bio`, Professionals.prof_phone_number AS `Professionals__prof_phone_number`, Professionals.prof_fax AS `Professionals__prof_fax`, Professionals.prof_rank AS `Professionals__prof_rank`, Professionals.prof_board_seat AS `Professionals__prof_board_seat`, Professionals.prof_office_id AS `Professionals__prof_office_id`, Professionals.prof_function AS `Professionals__prof_function`, Professionals.prof_last_updated AS `Professionals__prof_last_updated`, Professionals.admin_profile_date AS `Professionals__admin_profile_date`, Professionals.profile_image AS `Professionals__profile_image`, Professionals.profile_keywords AS `Professionals__profile_keywords`, WorkingCompany.company_id AS `WorkingCompany__company_id`, WorkingCompany.company_name AS `WorkingCompany__company_name`, WorkingCompany.company_former_name_one AS `WorkingCompany__company_former_name_one`, WorkingCompany.company_former_name_two AS `WorkingCompany__company_former_name_two`, WorkingCompany.company_sector_id AS `WorkingCompany__company_sector_id`, WorkingCompany.company_entity_type_id AS `WorkingCompany__company_entity_type_id`, WorkingCompany.company_active_status AS `WorkingCompany__company_active_status`, WorkingCompany.company_ceased_year AS `WorkingCompany__company_ceased_year`, WorkingCompany.company_parent_id AS `WorkingCompany__company_parent_id`, WorkingCompany.company_parent_type AS `WorkingCompany__company_parent_type`, WorkingCompany.company_stock_exchange_id AS `WorkingCompany__company_stock_exchange_id`, WorkingCompany.company_symbol AS `WorkingCompany__company_symbol`, WorkingCompany.company_is_public AS `WorkingCompany__company_is_public`, WorkingCompany.company_ipo_year AS `WorkingCompany__company_ipo_year`, WorkingCompany.company_delisted_year AS `WorkingCompany__company_delisted_year`, WorkingCompany.company_description AS `WorkingCompany__company_description`, WorkingCompany.company_phone AS `WorkingCompany__company_phone`, WorkingCompany.company_fax AS `WorkingCompany__company_fax`, WorkingCompany.company_toll_free AS `WorkingCompany__company_toll_free`, WorkingCompany.company_url AS `WorkingCompany__company_url`, WorkingCompany.company_address AS `WorkingCompany__company_address`, WorkingCompany.company_city AS `WorkingCompany__company_city`, WorkingCompany.company_postal_code AS `WorkingCompany__company_postal_code`, WorkingCompany.company_state_id AS `WorkingCompany__company_state_id`, WorkingCompany.company_country_id AS `WorkingCompany__company_country_id`, WorkingCompany.company_employees AS `WorkingCompany__company_employees`, WorkingCompany.company_year_established AS `WorkingCompany__company_year_established`, WorkingCompany.company_last_updated AS `WorkingCompany__company_last_updated`, WorkingCompany.company_is_deleted AS `WorkingCompany__company_is_deleted`, WorkingCompany.admin_profile_date AS `WorkingCompany__admin_profile_date`, WorkingCompany.profile_image AS `WorkingCompany__profile_image`, WorkingCompany.profile_keywords AS `WorkingCompany__profile_keywords`, WorkingFirm.firm_id AS `WorkingFirm__firm_id`, WorkingFirm.firm_name AS `WorkingFirm__firm_name`, WorkingFirm.firm_former_name AS `WorkingFirm__firm_former_name`, WorkingFirm.firm_url AS `WorkingFirm__firm_url`, WorkingFirm.firm_email AS `WorkingFirm__firm_email`, WorkingFirm.firm_ownership_category_id AS `WorkingFirm__firm_ownership_category_id`, WorkingFirm.firm_funded AS `WorkingFirm__firm_funded`, WorkingFirm.firm_size_id AS `WorkingFirm__firm_size_id`, WorkingFirm.firm_established_year AS `WorkingFirm__firm_established_year`, WorkingFirm.firm_inv_status AS `WorkingFirm__firm_inv_status`, WorkingFirm.firm_visibility AS `WorkingFirm__firm_visibility`, WorkingFirm.firm_strategy_type AS `WorkingFirm__firm_strategy_type`, WorkingFirm.firm_parent_id AS `WorkingFirm__firm_parent_id`, WorkingFirm.firm_parent_type AS `WorkingFirm__firm_parent_type`, WorkingFirm.firm_addln_offices AS `WorkingFirm__firm_addln_offices`, WorkingFirm.firm_hq_region_id AS `WorkingFirm__firm_hq_region_id`, WorkingFirm.firm_aum AS `WorkingFirm__firm_aum`, WorkingFirm.firm_aum_currency_id AS `WorkingFirm__firm_aum_currency_id`, WorkingFirm.firm_comp_revenue_min AS `WorkingFirm__firm_comp_revenue_min`, WorkingFirm.firm_comp_revenue_max AS `WorkingFirm__firm_comp_revenue_max`, WorkingFirm.firm_comp_revenue_curr_id AS `WorkingFirm__firm_comp_revenue_curr_id`, WorkingFirm.firm_ebitda_min AS `WorkingFirm__firm_ebitda_min`, WorkingFirm.firm_ebitda_max AS `WorkingFirm__firm_ebitda_max`, WorkingFirm.firm_ebitda_curr_id AS `WorkingFirm__firm_ebitda_curr_id`, WorkingFirm.firm_inv_size_min AS `WorkingFirm__firm_inv_size_min`, WorkingFirm.firm_inv_size_max AS `WorkingFirm__firm_inv_size_max`, WorkingFirm.firm_inv_size_curr_id AS `WorkingFirm__firm_inv_size_curr_id`, WorkingFirm.firm_entr_value_min AS `WorkingFirm__firm_entr_value_min`, WorkingFirm.firm_entr_value_max AS `WorkingFirm__firm_entr_value_max`, WorkingFirm.firm_entr_value_curr_id AS `WorkingFirm__firm_entr_value_curr_id`, WorkingFirm.firm_description AS `WorkingFirm__firm_description`, WorkingFirm.firm_last_updated AS `WorkingFirm__firm_last_updated`, WorkingFirm.professional_count AS `WorkingFirm__professional_count`, WorkingFirm.admin_profile_date AS `WorkingFirm__admin_profile_date`, WorkingFirm.profile_image AS `WorkingFirm__profile_image`, WorkingFirm.profile_keywords AS `WorkingFirm__profile_keywords`, WorkingIbank.ibank_id AS `WorkingIbank__ibank_id`, WorkingIbank.ibank_name AS `WorkingIbank__ibank_name`, WorkingIbank.ibank_former_name AS `WorkingIbank__ibank_former_name`, WorkingIbank.ibank_url AS `WorkingIbank__ibank_url`, WorkingIbank.ibank_email AS `WorkingIbank__ibank_email`, WorkingIbank.ibank_description AS `WorkingIbank__ibank_description`, WorkingIbank.ibank_ownership_category_id AS `WorkingIbank__ibank_ownership_category_id`, WorkingIbank.ibank_size_id AS `WorkingIbank__ibank_size_id`, WorkingIbank.ibank_established_year AS `WorkingIbank__ibank_established_year`, WorkingIbank.ibank_inv_status AS `WorkingIbank__ibank_inv_status`, WorkingIbank.ibank_visibility AS `WorkingIbank__ibank_visibility`, WorkingIbank.ibank_strategy_type AS `WorkingIbank__ibank_strategy_type`, WorkingIbank.ibank_parent_id AS `WorkingIbank__ibank_parent_id`, WorkingIbank.ibank_parent_type AS `WorkingIbank__ibank_parent_type`, WorkingIbank.ibank_addln_offices AS `WorkingIbank__ibank_addln_offices`, WorkingIbank.ibank_hq_region_id AS `WorkingIbank__ibank_hq_region_id`, WorkingIbank.ibank_last_updated AS `WorkingIbank__ibank_last_updated`, WorkingIbank.professional_count AS `WorkingIbank__professional_count`, WorkingIbank.admin_profile_date AS `WorkingIbank__admin_profile_date`, WorkingIbank.profile_image AS `WorkingIbank__profile_image`, WorkingIbank.profile_keywords AS `WorkingIbank__profile_keywords`, WorkingLfirm.lfirm_id AS `WorkingLfirm__lfirm_id`, WorkingLfirm.lfirm_name AS `WorkingLfirm__lfirm_name`, WorkingLfirm.lfirm_former_name AS `WorkingLfirm__lfirm_former_name`, WorkingLfirm.lfirm_url AS `WorkingLfirm__lfirm_url`, WorkingLfirm.lfirm_email AS `WorkingLfirm__lfirm_email`, WorkingLfirm.lfirm_description AS `WorkingLfirm__lfirm_description`, WorkingLfirm.lfirm_ownership_category_id AS `WorkingLfirm__lfirm_ownership_category_id`, WorkingLfirm.lfirm_size_id AS `WorkingLfirm__lfirm_size_id`, WorkingLfirm.lfirm_established_year AS `WorkingLfirm__lfirm_established_year`, WorkingLfirm.lfirm_inv_status AS `WorkingLfirm__lfirm_inv_status`, WorkingLfirm.lfirm_visibility AS `WorkingLfirm__lfirm_visibility`, WorkingLfirm.lfirm_strategy_type AS `WorkingLfirm__lfirm_strategy_type`, WorkingLfirm.lfirm_parent_id AS `WorkingLfirm__lfirm_parent_id`, WorkingLfirm.lfirm_parent_type AS `WorkingLfirm__lfirm_parent_type`, WorkingLfirm.lfirm_addln_offices AS `WorkingLfirm__lfirm_addln_offices`, WorkingLfirm.lfirm_hq_region_id AS `WorkingLfirm__lfirm_hq_region_id`, WorkingLfirm.lfirm_last_updated AS `WorkingLfirm__lfirm_last_updated`, WorkingLfirm.professional_count AS `WorkingLfirm__professional_count`, WorkingLfirm.admin_profile_date AS `WorkingLfirm__admin_profile_date`, WorkingLfirm.profile_image AS `WorkingLfirm__profile_image`, WorkingLfirm.profile_keywords AS `WorkingLfirm__profile_keywords`, ProfOffice.id AS `ProfOffice__id`, ProfOffice.addtln_name AS `ProfOffice__addtln_name`, ProfOffice.addtln_comp_id AS `ProfOffice__addtln_comp_id`, ProfOffice.addtln_comp_type AS `ProfOffice__addtln_comp_type`, ProfOffice.addtln_is_hq AS `ProfOffice__addtln_is_hq`, ProfOffice.addtln_name1 AS `ProfOffice__addtln_name1`, ProfOffice.addtln_zip AS `ProfOffice__addtln_zip`, ProfOffice.addtln_address AS `ProfOffice__addtln_address`, ProfOffice.addtln_fax AS `ProfOffice__addtln_fax`, ProfOffice.addtln_city AS `ProfOffice__addtln_city`, ProfOffice.addtln_state_id AS `ProfOffice__addtln_state_id`, ProfOffice.addtln_country_id AS `ProfOffice__addtln_country_id`, ProfOffice.addtln_phone AS `ProfOffice__addtln_phone`, ProfOffice.addtln_status AS `ProfOffice__addtln_status`, ProfOffice.addtln_create_dt AS `ProfOffice__addtln_create_dt`, ProfOffice.addtln_update_dt AS `ProfOffice__addtln_update_dt` FROM professionals Professionals LEFT JOIN companies WorkingCompany ON (professional_company_type = :c0 AND WorkingCompany.company_id = (Professionals.professional_company_id)) LEFT JOIN firms WorkingFirm ON (professional_company_type = :c1 AND WorkingFirm.firm_id = (Professionals.professional_company_id)) LEFT JOIN ibanks WorkingIbank ON (professional_company_type = :c2 AND WorkingIbank.ibank_id = (Professionals.professional_company_id)) LEFT JOIN l_firms WorkingLfirm ON (professional_company_type = :c3 AND WorkingLfirm.lfirm_id = (Professionals.professional_company_id)) LEFT JOIN additional_offices ProfOffice ON Professionals.prof_office_id = (ProfOffice.id) WHERE (professional_company_type = :c4 AND professional_company_id = :c5) ORDER BY rand(), prof_name ASC LIMIT 7', 'params' => [ [maximum depth reached] ], 'defaultTypes' => [ [maximum depth reached] ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ [maximum depth reached] ], 'matching' => [[maximum depth reached]], 'extraOptions' => [[maximum depth reached]], 'repository' => object(Admin\Model\Table\ProfessionalsTable) {} }, 'professionals' => object(Admin\Model\Entity\Professional) { 'professional_id' => (int) 15052, 'professional_company_id' => (int) 688, 'professional_company_type' => (int) 2, 'prof_name' => 'Gary Shayne', 'prof_email' => '', 'prof_designation' => 'Founder', 'prof_join_dt' => (int) 2007, 'prof_bio' => 'As founder of Cambridge Capital, Gary has been involved in all phases of the firm’s development since its founding in late 2007 and is responsible for the overall strategy and management of the company. Gary co-founded Ascendis Health Limited in 2008 which has grown to become the second largest provider of health products in Africa, and co-founded Bounty Brands (Pty) Ltd in 2014 and Marlin Homeware (Pty) Ltd in 2016. He also serves on the board of a number of portfolio companies. Gary has a bold vision to grow Coast2Coast Capital into a leading global Investment company based on innovative ways of investing, seeking out opportunities in multiple sectors and building a global team of highly passionate, smart and experienced people. Gary’s passion for investing is a key driving force at Cambridge capital which has grown its on-balance sheet fund (currently at over USD700m) at a rate of over 80%/annum over the last 9 years and over 90%/annum over the last 3 years.Gary trained as a chartered accountant through KPMG and has a highly successful history in both entrepreneurial ventures and private equity. In his early 20’s he founded what went on to become one of the country’s largest independent accounting firms. In his late 20’s he established a telecommunications company, which was listed on the stock exchange and grew to become the largest service provider of mobile phone products in the country. Gary owned and ran a number of other businesses, including chemical manufacturing, bank IT outsourcing, internet tourism, and security printing before he ventured into private equity in his mid thirties.', 'prof_phone_number' => '', 'prof_fax' => '', 'prof_rank' => (int) 1, 'prof_board_seat' => null, 'prof_office_id' => (int) 715, 'prof_function' => 'Investment', 'prof_last_updated' => object(Cake\I18n\FrozenTime) {}, 'admin_profile_date' => null, 'profile_image' => 'Professionals2018-08-13-07-24-55.PNG', 'profile_keywords' => 'Gary Shayne', 'prof_office' => object(Admin\Model\Entity\AdditionalOffice) {}, 'professional_sectors' => [[maximum depth reached]], 'working_lfirm' => null, 'working_ibank' => null, 'working_firm' => object(Admin\Model\Entity\Firm) {}, 'working_company' => null, '[new]' => false, '[accessible]' => [ [maximum depth reached] ], '[dirty]' => [[maximum depth reached]], '[original]' => [[maximum depth reached]], '[virtual]' => [[maximum depth reached]], '[errors]' => [[maximum depth reached]], '[invalid]' => [[maximum depth reached]], '[repository]' => 'Admin.Professionals' } ] $Professional_id = (int) 15052 $ProfessionalExperiences = object(Cake\ORM\ResultSet) { 'items' => [] } $ProfessionalBoardSeats1 = object(Cake\ORM\ResultSet) { 'items' => [] } $ProfessionalBoardSeats = object(Cake\ORM\ResultSet) { 'items' => [] } $ProfessionalEducationalQuals = object(Cake\ORM\ResultSet) { 'items' => [ (int) 0 => object(Admin\Model\Entity\ProfessionalEducationalQual) {} ] } $companiesCount = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Companies.company_id AS `Companies__company_id`, Companies.company_name AS `Companies__company_name`, Companies.company_former_name_one AS `Companies__company_former_name_one`, Companies.company_former_name_two AS `Companies__company_former_name_two`, Companies.company_sector_id AS `Companies__company_sector_id`, Companies.company_entity_type_id AS `Companies__company_entity_type_id`, Companies.company_active_status AS `Companies__company_active_status`, Companies.company_ceased_year AS `Companies__company_ceased_year`, Companies.company_parent_id AS `Companies__company_parent_id`, Companies.company_parent_type AS `Companies__company_parent_type`, Companies.company_stock_exchange_id AS `Companies__company_stock_exchange_id`, Companies.company_symbol AS `Companies__company_symbol`, Companies.company_is_public AS `Companies__company_is_public`, Companies.company_ipo_year AS `Companies__company_ipo_year`, Companies.company_delisted_year AS `Companies__company_delisted_year`, Companies.company_description AS `Companies__company_description`, Companies.company_phone AS `Companies__company_phone`, Companies.company_fax AS `Companies__company_fax`, Companies.company_toll_free AS `Companies__company_toll_free`, Companies.company_url AS `Companies__company_url`, Companies.company_address AS `Companies__company_address`, Companies.company_city AS `Companies__company_city`, Companies.company_postal_code AS `Companies__company_postal_code`, Companies.company_state_id AS `Companies__company_state_id`, Companies.company_country_id AS `Companies__company_country_id`, Companies.company_employees AS `Companies__company_employees`, Companies.company_year_established AS `Companies__company_year_established`, Companies.company_last_updated AS `Companies__company_last_updated`, Companies.company_is_deleted AS `Companies__company_is_deleted`, Companies.admin_profile_date AS `Companies__admin_profile_date`, Companies.profile_image AS `Companies__profile_image`, Companies.profile_keywords AS `Companies__profile_keywords`, CompTrans.comp_transaction_id AS `CompTrans__comp_transaction_id`, CompTrans.company_id AS `CompTrans__company_id`, CompTrans.investment_announced_dt AS `CompTrans__investment_announced_dt`, CompTrans.exit_announced_dt AS `CompTrans__exit_announced_dt`, CompTrans.investment_closed_dt AS `CompTrans__investment_closed_dt`, CompTrans.exit_closed_dt AS `CompTrans__exit_closed_dt`, CompTrans.acquisition_type_id AS `CompTrans__acquisition_type_id`, CompTrans.exit_type_id AS `CompTrans__exit_type_id`, CompTrans.deal_value AS `CompTrans__deal_value`, CompTrans.inv_currency_id AS `CompTrans__inv_currency_id`, CompTrans.investment_revenue AS `CompTrans__investment_revenue`, CompTrans.investment_ebitda AS `CompTrans__investment_ebitda`, CompTrans.exit_value AS `CompTrans__exit_value`, CompTrans.exit_currency_id AS `CompTrans__exit_currency_id`, CompTrans.exit_revenue AS `CompTrans__exit_revenue`, CompTrans.exit_ebitda AS `CompTrans__exit_ebitda`, CompTrans.investment_annced_pr_link AS `CompTrans__investment_annced_pr_link`, CompTrans.investment_closed_pr_link AS `CompTrans__investment_closed_pr_link`, CompTrans.exit_annced_pr_link AS `CompTrans__exit_annced_pr_link`, CompTrans.exit_closed_pr_link AS `CompTrans__exit_closed_pr_link`, CompTrans.active_status AS `CompTrans__active_status`, CompTrans.parent_tran_id AS `CompTrans__parent_tran_id`, CompTrans.child_tran_id AS `CompTrans__child_tran_id`, CompInvestors.comp_tran_inv_id AS `CompInvestors__comp_tran_inv_id`, CompInvestors.comp_transaction_id AS `CompInvestors__comp_transaction_id`, CompInvestors.comp_tran_investor_id AS `CompInvestors__comp_tran_investor_id`, CompInvestors.comp_tran_investor_type AS `CompInvestors__comp_tran_investor_type`, CompInvestors.comp_investment_amount AS `CompInvestors__comp_investment_amount`, CompInvestors.comp_investment_stake AS `CompInvestors__comp_investment_stake`, CompInvestors.comp_investment_currency_id AS `CompInvestors__comp_investment_currency_id`, CompInvestors.comp_investment_position AS `CompInvestors__comp_investment_position`, CompInvestors.comp_investment_inv_ann_dt AS `CompInvestors__comp_investment_inv_ann_dt`, CompInvestors.comp_investment_inv_cl_dt AS `CompInvestors__comp_investment_inv_cl_dt`, CompInvestors.comp_investment_exit_ann_dt AS `CompInvestors__comp_investment_exit_ann_dt`, CompInvestors.comp_investment_exit_cl_dt AS `CompInvestors__comp_investment_exit_cl_dt`, CompInvestors.comp_investment_acqui_type_id AS `CompInvestors__comp_investment_acqui_type_id`, CompInvestors.comp_investment_exit_type_id AS `CompInvestors__comp_investment_exit_type_id`, CompInvestors.comp_invst_inv_ann_pr_link AS `CompInvestors__comp_invst_inv_ann_pr_link`, CompInvestors.comp_invst_inv_cl_pr_link AS `CompInvestors__comp_invst_inv_cl_pr_link`, CompInvestors.comp_invst_exit_ann_pr_link AS `CompInvestors__comp_invst_exit_ann_pr_link`, CompInvestors.comp_invst_exit_closed_pr_link AS `CompInvestors__comp_invst_exit_closed_pr_link`, InvestorProfessionals.professional_id AS `InvestorProfessionals__professional_id`, InvestorProfessionals.professional_company_id AS `InvestorProfessionals__professional_company_id`, InvestorProfessionals.professional_company_type AS `InvestorProfessionals__professional_company_type`, InvestorProfessionals.prof_name AS `InvestorProfessionals__prof_name`, InvestorProfessionals.prof_email AS `InvestorProfessionals__prof_email`, InvestorProfessionals.prof_designation AS `InvestorProfessionals__prof_designation`, InvestorProfessionals.prof_join_dt AS `InvestorProfessionals__prof_join_dt`, InvestorProfessionals.prof_bio AS `InvestorProfessionals__prof_bio`, InvestorProfessionals.prof_phone_number AS `InvestorProfessionals__prof_phone_number`, InvestorProfessionals.prof_fax AS `InvestorProfessionals__prof_fax`, InvestorProfessionals.prof_rank AS `InvestorProfessionals__prof_rank`, InvestorProfessionals.prof_board_seat AS `InvestorProfessionals__prof_board_seat`, InvestorProfessionals.prof_office_id AS `InvestorProfessionals__prof_office_id`, InvestorProfessionals.prof_function AS `InvestorProfessionals__prof_function`, InvestorProfessionals.prof_last_updated AS `InvestorProfessionals__prof_last_updated`, InvestorProfessionals.admin_profile_date AS `InvestorProfessionals__admin_profile_date`, InvestorProfessionals.profile_image AS `InvestorProfessionals__profile_image`, InvestorProfessionals.profile_keywords AS `InvestorProfessionals__profile_keywords`, InvestmentTargetCompany.company_id AS `InvestmentTargetCompany__company_id`, InvestmentTargetCompany.company_name AS `InvestmentTargetCompany__company_name`, InvestmentTargetCompany.company_former_name_one AS `InvestmentTargetCompany__company_former_name_one`, InvestmentTargetCompany.company_former_name_two AS `InvestmentTargetCompany__company_former_name_two`, InvestmentTargetCompany.company_sector_id AS `InvestmentTargetCompany__company_sector_id`, InvestmentTargetCompany.company_entity_type_id AS `InvestmentTargetCompany__company_entity_type_id`, InvestmentTargetCompany.company_active_status AS `InvestmentTargetCompany__company_active_status`, InvestmentTargetCompany.company_ceased_year AS `InvestmentTargetCompany__company_ceased_year`, InvestmentTargetCompany.company_parent_id AS `InvestmentTargetCompany__company_parent_id`, InvestmentTargetCompany.company_parent_type AS `InvestmentTargetCompany__company_parent_type`, InvestmentTargetCompany.company_stock_exchange_id AS `InvestmentTargetCompany__company_stock_exchange_id`, InvestmentTargetCompany.company_symbol AS `InvestmentTargetCompany__company_symbol`, InvestmentTargetCompany.company_is_public AS `InvestmentTargetCompany__company_is_public`, InvestmentTargetCompany.company_ipo_year AS `InvestmentTargetCompany__company_ipo_year`, InvestmentTargetCompany.company_delisted_year AS `InvestmentTargetCompany__company_delisted_year`, InvestmentTargetCompany.company_description AS `InvestmentTargetCompany__company_description`, InvestmentTargetCompany.company_phone AS `InvestmentTargetCompany__company_phone`, InvestmentTargetCompany.company_fax AS `InvestmentTargetCompany__company_fax`, InvestmentTargetCompany.company_toll_free AS `InvestmentTargetCompany__company_toll_free`, InvestmentTargetCompany.company_url AS `InvestmentTargetCompany__company_url`, InvestmentTargetCompany.company_address AS `InvestmentTargetCompany__company_address`, InvestmentTargetCompany.company_city AS `InvestmentTargetCompany__company_city`, InvestmentTargetCompany.company_postal_code AS `InvestmentTargetCompany__company_postal_code`, InvestmentTargetCompany.company_state_id AS `InvestmentTargetCompany__company_state_id`, InvestmentTargetCompany.company_country_id AS `InvestmentTargetCompany__company_country_id`, InvestmentTargetCompany.company_employees AS `InvestmentTargetCompany__company_employees`, InvestmentTargetCompany.company_year_established AS `InvestmentTargetCompany__company_year_established`, InvestmentTargetCompany.company_last_updated AS `InvestmentTargetCompany__company_last_updated`, InvestmentTargetCompany.company_is_deleted AS `InvestmentTargetCompany__company_is_deleted`, InvestmentTargetCompany.admin_profile_date AS `InvestmentTargetCompany__admin_profile_date`, InvestmentTargetCompany.profile_image AS `InvestmentTargetCompany__profile_image`, InvestmentTargetCompany.profile_keywords AS `InvestmentTargetCompany__profile_keywords`, Sector.id AS `Sector__id`, Sector.sector_name AS `Sector__sector_name`, Country.id AS `Country__id`, Country.country_name AS `Country__country_name`, State.id AS `State__id`, State.country_id AS `State__country_id`, State.state_name AS `State__state_name`, StockExchange.id AS `StockExchange__id`, StockExchange.exchange_name AS `StockExchange__exchange_name`, ProfileParent.id AS `ProfileParent__id`, ProfileParent.child_id AS `ProfileParent__child_id`, ProfileParent.child_type AS `ProfileParent__child_type`, ProfileParent.parent_id AS `ProfileParent__parent_id`, ProfileParent.parent_name AS `ProfileParent__parent_name`, ProfileParent.parent_type AS `ProfileParent__parent_type` FROM companies Companies INNER JOIN company_transactions CompTrans ON (parent_tran_id = :c0 AND Companies.company_id = (CompTrans.company_id)) INNER JOIN comp_transaction_investors CompInvestors ON CompTrans.comp_transaction_id = (CompInvestors.comp_transaction_id) INNER JOIN professionals InvestorProfessionals ON (CompInvestors.comp_tran_investor_type = :c1 AND CompInvestors.comp_tran_investor_id = (InvestorProfessionals.professional_id)) INNER JOIN companies InvestmentTargetCompany ON InvestmentTargetCompany.company_id = (CompTrans.company_id) LEFT JOIN sectors Sector ON Companies.company_sector_id = (Sector.id) LEFT JOIN countries Country ON Companies.company_country_id = (Country.id) LEFT JOIN states State ON Companies.company_state_id = (State.id) LEFT JOIN stock_exchanges StockExchange ON Companies.company_stock_exchange_id = (StockExchange.id) LEFT JOIN profile_parents ProfileParent ON (child_type = :c2 AND Companies.company_id = (ProfileParent.child_id)) WHERE (InvestorProfessionals.professional_id = :c3 AND InvestmentTargetCompany.company_is_deleted != :c4) ORDER BY CASE WHEN CompTrans.investment_closed_dt IS NOT NULL THEN CompTrans.investment_closed_dt ELSE CompTrans.investment_announced_dt END DESC', 'params' => [ ':c0' => [ [maximum depth reached] ], ':c1' => [ [maximum depth reached] ], ':c2' => [ [maximum depth reached] ], ':c3' => [ [maximum depth reached] ], ':c4' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Companies__company_id' => 'integer', 'Companies.company_id' => 'integer', 'company_id' => 'integer', 'Companies__company_name' => 'string', 'Companies.company_name' => 'string', 'company_name' => 'string', 'Companies__company_former_name_one' => 'string', 'Companies.company_former_name_one' => 'string', 'company_former_name_one' => 'string', 'Companies__company_former_name_two' => 'string', 'Companies.company_former_name_two' => 'string', 'company_former_name_two' => 'string', 'Companies__company_sector_id' => 'integer', 'Companies.company_sector_id' => 'integer', 'company_sector_id' => 'integer', 'Companies__company_entity_type_id' => 'integer', 'Companies.company_entity_type_id' => 'integer', 'company_entity_type_id' => 'integer', 'Companies__company_active_status' => 'integer', 'Companies.company_active_status' => 'integer', 'company_active_status' => 'integer', 'Companies__company_ceased_year' => 'integer', 'Companies.company_ceased_year' => 'integer', 'company_ceased_year' => 'integer', 'Companies__company_parent_id' => 'integer', 'Companies.company_parent_id' => 'integer', 'company_parent_id' => 'integer', 'Companies__company_parent_type' => 'integer', 'Companies.company_parent_type' => 'integer', 'company_parent_type' => 'integer', 'Companies__company_stock_exchange_id' => 'integer', 'Companies.company_stock_exchange_id' => 'integer', 'company_stock_exchange_id' => 'integer', 'Companies__company_symbol' => 'string', 'Companies.company_symbol' => 'string', 'company_symbol' => 'string', 'Companies__company_is_public' => 'integer', 'Companies.company_is_public' => 'integer', 'company_is_public' => 'integer', 'Companies__company_ipo_year' => 'integer', 'Companies.company_ipo_year' => 'integer', 'company_ipo_year' => 'integer', 'Companies__company_delisted_year' => 'integer', 'Companies.company_delisted_year' => 'integer', 'company_delisted_year' => 'integer', 'Companies__company_description' => 'text', 'Companies.company_description' => 'text', 'company_description' => 'text', 'Companies__company_phone' => 'string', 'Companies.company_phone' => 'string', 'company_phone' => 'string', 'Companies__company_fax' => 'string', 'Companies.company_fax' => 'string', 'company_fax' => 'string', 'Companies__company_toll_free' => 'string', 'Companies.company_toll_free' => 'string', 'company_toll_free' => 'string', 'Companies__company_url' => 'string', 'Companies.company_url' => 'string', 'company_url' => 'string', 'Companies__company_address' => 'string', 'Companies.company_address' => 'string', 'company_address' => 'string', 'Companies__company_city' => 'string', 'Companies.company_city' => 'string', 'company_city' => 'string', 'Companies__company_postal_code' => 'string', 'Companies.company_postal_code' => 'string', 'company_postal_code' => 'string', 'Companies__company_state_id' => 'integer', 'Companies.company_state_id' => 'integer', 'company_state_id' => 'integer', 'Companies__company_country_id' => 'integer', 'Companies.company_country_id' => 'integer', 'company_country_id' => 'integer', 'Companies__company_employees' => 'integer', 'Companies.company_employees' => 'integer', 'company_employees' => 'integer', 'Companies__company_year_established' => 'integer', 'Companies.company_year_established' => 'integer', 'company_year_established' => 'integer', 'Companies__company_last_updated' => 'datetime', 'Companies.company_last_updated' => 'datetime', 'company_last_updated' => 'datetime', 'Companies__company_is_deleted' => 'integer', 'Companies.company_is_deleted' => 'integer', 'company_is_deleted' => 'integer', 'Companies__admin_profile_date' => 'datetime', 'Companies.admin_profile_date' => 'datetime', 'admin_profile_date' => 'datetime', 'Companies__profile_image' => 'text', 'Companies.profile_image' => 'text', 'profile_image' => 'text', 'Companies__profile_keywords' => 'text', 'Companies.profile_keywords' => 'text', 'profile_keywords' => 'text', 'Sector__id' => 'integer', 'Sector.id' => 'integer', 'id' => 'integer', 'Sector__sector_name' => 'string', 'Sector.sector_name' => 'string', 'sector_name' => 'string', 'Country__id' => 'integer', 'Country.id' => 'integer', 'Country__country_name' => 'string', 'Country.country_name' => 'string', 'country_name' => 'string', 'State__id' => 'integer', 'State.id' => 'integer', 'State__country_id' => 'integer', 'State.country_id' => 'integer', 'country_id' => 'integer', 'State__state_name' => 'string', 'State.state_name' => 'string', 'state_name' => 'string', 'StockExchange__id' => 'integer', 'StockExchange.id' => 'integer', 'StockExchange__exchange_name' => 'string', 'StockExchange.exchange_name' => 'string', 'exchange_name' => 'string', 'ProfileParent__id' => 'integer', 'ProfileParent.id' => 'integer', 'ProfileParent__child_id' => 'integer', 'ProfileParent.child_id' => 'integer', 'child_id' => 'integer', 'ProfileParent__child_type' => 'integer', 'ProfileParent.child_type' => 'integer', 'child_type' => 'integer', 'ProfileParent__parent_id' => 'integer', 'ProfileParent.parent_id' => 'integer', 'parent_id' => 'integer', 'ProfileParent__parent_name' => 'string', 'ProfileParent.parent_name' => 'string', 'parent_name' => 'string', 'ProfileParent__parent_type' => 'integer', 'ProfileParent.parent_type' => 'integer', 'parent_type' => 'integer', 'CompanyProfessionals__professional_id' => 'integer', 'CompanyProfessionals.professional_id' => 'integer', 'professional_id' => 'integer', 'CompanyProfessionals__professional_company_id' => 'integer', 'CompanyProfessionals.professional_company_id' => 'integer', 'professional_company_id' => 'integer', 'CompanyProfessionals__professional_company_type' => 'integer', 'CompanyProfessionals.professional_company_type' => 'integer', 'professional_company_type' => 'integer', 'CompanyProfessionals__prof_name' => 'string', 'CompanyProfessionals.prof_name' => 'string', 'prof_name' => 'string', 'CompanyProfessionals__prof_email' => 'string', 'CompanyProfessionals.prof_email' => 'string', 'prof_email' => 'string', 'CompanyProfessionals__prof_designation' => 'string', 'CompanyProfessionals.prof_designation' => 'string', 'prof_designation' => 'string', 'CompanyProfessionals__prof_join_dt' => 'integer', 'CompanyProfessionals.prof_join_dt' => 'integer', 'prof_join_dt' => 'integer', 'CompanyProfessionals__prof_bio' => 'text', 'CompanyProfessionals.prof_bio' => 'text', 'prof_bio' => 'text', 'CompanyProfessionals__prof_phone_number' => 'string', 'CompanyProfessionals.prof_phone_number' => 'string', 'prof_phone_number' => 'string', 'CompanyProfessionals__prof_fax' => 'string', 'CompanyProfessionals.prof_fax' => 'string', 'prof_fax' => 'string', 'CompanyProfessionals__prof_rank' => 'integer', 'CompanyProfessionals.prof_rank' => 'integer', 'prof_rank' => 'integer', 'CompanyProfessionals__prof_board_seat' => 'integer', 'CompanyProfessionals.prof_board_seat' => 'integer', 'prof_board_seat' => 'integer', 'CompanyProfessionals__prof_office_id' => 'integer', 'CompanyProfessionals.prof_office_id' => 'integer', 'prof_office_id' => 'integer', 'CompanyProfessionals__prof_function' => 'string', 'CompanyProfessionals.prof_function' => 'string', 'prof_function' => 'string', 'CompanyProfessionals__prof_last_updated' => 'datetime', 'CompanyProfessionals.prof_last_updated' => 'datetime', 'prof_last_updated' => 'datetime', 'CompanyProfessionals__admin_profile_date' => 'datetime', 'CompanyProfessionals.admin_profile_date' => 'datetime', 'CompanyProfessionals__profile_image' => 'text', 'CompanyProfessionals.profile_image' => 'text', 'CompanyProfessionals__profile_keywords' => 'text', 'CompanyProfessionals.profile_keywords' => 'text', 'CompTrans__comp_transaction_id' => 'integer', 'CompTrans.comp_transaction_id' => 'integer', 'comp_transaction_id' => 'integer', 'CompTrans__company_id' => 'integer', 'CompTrans.company_id' => 'integer', 'CompTrans__investment_announced_dt' => 'datetime', 'CompTrans.investment_announced_dt' => 'datetime', 'investment_announced_dt' => 'datetime', 'CompTrans__exit_announced_dt' => 'datetime', 'CompTrans.exit_announced_dt' => 'datetime', 'exit_announced_dt' => 'datetime', 'CompTrans__investment_closed_dt' => 'datetime', 'CompTrans.investment_closed_dt' => 'datetime', 'investment_closed_dt' => 'datetime', 'CompTrans__exit_closed_dt' => 'datetime', 'CompTrans.exit_closed_dt' => 'datetime', 'exit_closed_dt' => 'datetime', 'CompTrans__acquisition_type_id' => 'integer', 'CompTrans.acquisition_type_id' => 'integer', 'acquisition_type_id' => 'integer', 'CompTrans__exit_type_id' => 'integer', 'CompTrans.exit_type_id' => 'integer', 'exit_type_id' => 'integer', 'CompTrans__deal_value' => 'string', 'CompTrans.deal_value' => 'string', 'deal_value' => 'string', 'CompTrans__inv_currency_id' => 'integer', 'CompTrans.inv_currency_id' => 'integer', 'inv_currency_id' => 'integer', 'CompTrans__investment_revenue' => 'string', 'CompTrans.investment_revenue' => 'string', 'investment_revenue' => 'string', 'CompTrans__investment_ebitda' => 'string', 'CompTrans.investment_ebitda' => 'string', 'investment_ebitda' => 'string', 'CompTrans__exit_value' => 'string', 'CompTrans.exit_value' => 'string', 'exit_value' => 'string', 'CompTrans__exit_currency_id' => 'integer', 'CompTrans.exit_currency_id' => 'integer', 'exit_currency_id' => 'integer', 'CompTrans__exit_revenue' => 'string', 'CompTrans.exit_revenue' => 'string', 'exit_revenue' => 'string', 'CompTrans__exit_ebitda' => 'string', 'CompTrans.exit_ebitda' => 'string', 'exit_ebitda' => 'string', 'CompTrans__investment_annced_pr_link' => 'string', 'CompTrans.investment_annced_pr_link' => 'string', 'investment_annced_pr_link' => 'string', 'CompTrans__investment_closed_pr_link' => 'string', 'CompTrans.investment_closed_pr_link' => 'string', 'investment_closed_pr_link' => 'string', 'CompTrans__exit_annced_pr_link' => 'string', 'CompTrans.exit_annced_pr_link' => 'string', 'exit_annced_pr_link' => 'string', 'CompTrans__exit_closed_pr_link' => 'string', 'CompTrans.exit_closed_pr_link' => 'string', 'exit_closed_pr_link' => 'string', 'CompTrans__active_status' => 'integer', 'CompTrans.active_status' => 'integer', 'active_status' => 'integer', 'CompTrans__parent_tran_id' => 'integer', 'CompTrans.parent_tran_id' => 'integer', 'parent_tran_id' => 'integer', 'CompTrans__child_tran_id' => 'integer', 'CompTrans.child_tran_id' => 'integer', 'child_tran_id' => 'integer', 'InvestmentTargetCompany__company_id' => 'integer', 'InvestmentTargetCompany.company_id' => 'integer', 'InvestmentTargetCompany__company_name' => 'string', 'InvestmentTargetCompany.company_name' => 'string', 'InvestmentTargetCompany__company_former_name_one' => 'string', 'InvestmentTargetCompany.company_former_name_one' => 'string', 'InvestmentTargetCompany__company_former_name_two' => 'string', 'InvestmentTargetCompany.company_former_name_two' => 'string', 'InvestmentTargetCompany__company_sector_id' => 'integer', 'InvestmentTargetCompany.company_sector_id' => 'integer', 'InvestmentTargetCompany__company_entity_type_id' => 'integer', 'InvestmentTargetCompany.company_entity_type_id' => 'integer', 'InvestmentTargetCompany__company_active_status' => 'integer', 'InvestmentTargetCompany.company_active_status' => 'integer', 'InvestmentTargetCompany__company_ceased_year' => 'integer', 'InvestmentTargetCompany.company_ceased_year' => 'integer', 'InvestmentTargetCompany__company_parent_id' => 'integer', 'InvestmentTargetCompany.company_parent_id' => 'integer', 'InvestmentTargetCompany__company_parent_type' => 'integer', 'InvestmentTargetCompany.company_parent_type' => 'integer', 'InvestmentTargetCompany__company_stock_exchange_id' => 'integer', 'InvestmentTargetCompany.company_stock_exchange_id' => 'integer', 'InvestmentTargetCompany__company_symbol' => 'string', 'InvestmentTargetCompany.company_symbol' => 'string', 'InvestmentTargetCompany__company_is_public' => 'integer', 'InvestmentTargetCompany.company_is_public' => 'integer', 'InvestmentTargetCompany__company_ipo_year' => 'integer', 'InvestmentTargetCompany.company_ipo_year' => 'integer', 'InvestmentTargetCompany__company_delisted_year' => 'integer', 'InvestmentTargetCompany.company_delisted_year' => 'integer', 'InvestmentTargetCompany__company_description' => 'text', 'InvestmentTargetCompany.company_description' => 'text', 'InvestmentTargetCompany__company_phone' => 'string', 'InvestmentTargetCompany.company_phone' => 'string', 'InvestmentTargetCompany__company_fax' => 'string', 'InvestmentTargetCompany.company_fax' => 'string', 'InvestmentTargetCompany__company_toll_free' => 'string', 'InvestmentTargetCompany.company_toll_free' => 'string', 'InvestmentTargetCompany__company_url' => 'string', 'InvestmentTargetCompany.company_url' => 'string', 'InvestmentTargetCompany__company_address' => 'string', 'InvestmentTargetCompany.company_address' => 'string', 'InvestmentTargetCompany__company_city' => 'string', 'InvestmentTargetCompany.company_city' => 'string', 'InvestmentTargetCompany__company_postal_code' => 'string', 'InvestmentTargetCompany.company_postal_code' => 'string', 'InvestmentTargetCompany__company_state_id' => 'integer', 'InvestmentTargetCompany.company_state_id' => 'integer', 'InvestmentTargetCompany__company_country_id' => 'integer', 'InvestmentTargetCompany.company_country_id' => 'integer', 'InvestmentTargetCompany__company_employees' => 'integer', 'InvestmentTargetCompany.company_employees' => 'integer', 'InvestmentTargetCompany__company_year_established' => 'integer', 'InvestmentTargetCompany.company_year_established' => 'integer', 'InvestmentTargetCompany__company_last_updated' => 'datetime', 'InvestmentTargetCompany.company_last_updated' => 'datetime', 'InvestmentTargetCompany__company_is_deleted' => 'integer', 'InvestmentTargetCompany.company_is_deleted' => 'integer', 'InvestmentTargetCompany__admin_profile_date' => 'datetime', 'InvestmentTargetCompany.admin_profile_date' => 'datetime', 'InvestmentTargetCompany__profile_image' => 'text', 'InvestmentTargetCompany.profile_image' => 'text', 'InvestmentTargetCompany__profile_keywords' => 'text', 'InvestmentTargetCompany.profile_keywords' => 'text', 'AcquiType__id' => 'integer', 'AcquiType.id' => 'integer', 'AcquiType__acquisition_name' => 'string', 'AcquiType.acquisition_name' => 'string', 'acquisition_name' => 'string', 'ExitType__id' => 'integer', 'ExitType.id' => 'integer', 'ExitType__exit_name' => 'string', 'ExitType.exit_name' => 'string', 'exit_name' => 'string', 'InvCurrency__id' => 'integer', 'InvCurrency.id' => 'integer', 'InvCurrency__currency_name' => 'string', 'InvCurrency.currency_name' => 'string', 'currency_name' => 'string', 'InvCurrency__currency_rate' => 'float', 'InvCurrency.currency_rate' => 'float', 'currency_rate' => 'float', 'ExitCurrency__id' => 'integer', 'ExitCurrency.id' => 'integer', 'ExitCurrency__currency_name' => 'string', 'ExitCurrency.currency_name' => 'string', 'ExitCurrency__currency_rate' => 'float', 'ExitCurrency.currency_rate' => 'float', 'CompInvestors__comp_tran_inv_id' => 'integer', 'CompInvestors.comp_tran_inv_id' => 'integer', 'comp_tran_inv_id' => 'integer', 'CompInvestors__comp_transaction_id' => 'integer', 'CompInvestors.comp_transaction_id' => 'integer', 'CompInvestors__comp_tran_investor_id' => 'integer', 'CompInvestors.comp_tran_investor_id' => 'integer', 'comp_tran_investor_id' => 'integer', 'CompInvestors__comp_tran_investor_type' => 'integer', 'CompInvestors.comp_tran_investor_type' => 'integer', 'comp_tran_investor_type' => 'integer', 'CompInvestors__comp_investment_amount' => 'string', 'CompInvestors.comp_investment_amount' => 'string', 'comp_investment_amount' => 'string', 'CompInvestors__comp_investment_stake' => 'string', 'CompInvestors.comp_investment_stake' => 'string', 'comp_investment_stake' => 'string', 'CompInvestors__comp_investment_currency_id' => 'integer', 'CompInvestors.comp_investment_currency_id' => 'integer', 'comp_investment_currency_id' => 'integer', 'CompInvestors__comp_investment_position' => 'string', 'CompInvestors.comp_investment_position' => 'string', 'comp_investment_position' => 'string', 'CompInvestors__comp_investment_inv_ann_dt' => 'datetime', 'CompInvestors.comp_investment_inv_ann_dt' => 'datetime', 'comp_investment_inv_ann_dt' => 'datetime', 'CompInvestors__comp_investment_inv_cl_dt' => 'datetime', 'CompInvestors.comp_investment_inv_cl_dt' => 'datetime', 'comp_investment_inv_cl_dt' => 'datetime', 'CompInvestors__comp_investment_exit_ann_dt' => 'datetime', 'CompInvestors.comp_investment_exit_ann_dt' => 'datetime', 'comp_investment_exit_ann_dt' => 'datetime', 'CompInvestors__comp_investment_exit_cl_dt' => 'datetime', 'CompInvestors.comp_investment_exit_cl_dt' => 'datetime', 'comp_investment_exit_cl_dt' => 'datetime', 'CompInvestors__comp_investment_acqui_type_id' => 'integer', 'CompInvestors.comp_investment_acqui_type_id' => 'integer', 'comp_investment_acqui_type_id' => 'integer', 'CompInvestors__comp_investment_exit_type_id' => 'integer', 'CompInvestors.comp_investment_exit_type_id' => 'integer', 'comp_investment_exit_type_id' => 'integer', 'CompInvestors__comp_invst_inv_ann_pr_link' => 'string', 'CompInvestors.comp_invst_inv_ann_pr_link' => 'string', 'comp_invst_inv_ann_pr_link' => 'string', 'CompInvestors__comp_invst_inv_cl_pr_link' => 'string', 'CompInvestors.comp_invst_inv_cl_pr_link' => 'string', 'comp_invst_inv_cl_pr_link' => 'string', 'CompInvestors__comp_invst_exit_ann_pr_link' => 'string', 'CompInvestors.comp_invst_exit_ann_pr_link' => 'string', 'comp_invst_exit_ann_pr_link' => 'string', 'CompInvestors__comp_invst_exit_closed_pr_link' => 'string', 'CompInvestors.comp_invst_exit_closed_pr_link' => 'string', 'comp_invst_exit_closed_pr_link' => 'string', 'InvestorProfessionals__professional_id' => 'integer', 'InvestorProfessionals.professional_id' => 'integer', 'InvestorProfessionals__professional_company_id' => 'integer', 'InvestorProfessionals.professional_company_id' => 'integer', 'InvestorProfessionals__professional_company_type' => 'integer', 'InvestorProfessionals.professional_company_type' => 'integer', 'InvestorProfessionals__prof_name' => 'string', 'InvestorProfessionals.prof_name' => 'string', 'InvestorProfessionals__prof_email' => 'string', 'InvestorProfessionals.prof_email' => 'string', 'InvestorProfessionals__prof_designation' => 'string', 'InvestorProfessionals.prof_designation' => 'string', 'InvestorProfessionals__prof_join_dt' => 'integer', 'InvestorProfessionals.prof_join_dt' => 'integer', 'InvestorProfessionals__prof_bio' => 'text', 'InvestorProfessionals.prof_bio' => 'text', 'InvestorProfessionals__prof_phone_number' => 'string', 'InvestorProfessionals.prof_phone_number' => 'string', 'InvestorProfessionals__prof_fax' => 'string', 'InvestorProfessionals.prof_fax' => 'string', 'InvestorProfessionals__prof_rank' => 'integer', 'InvestorProfessionals.prof_rank' => 'integer', 'InvestorProfessionals__prof_board_seat' => 'integer', 'InvestorProfessionals.prof_board_seat' => 'integer', 'InvestorProfessionals__prof_office_id' => 'integer', 'InvestorProfessionals.prof_office_id' => 'integer', 'InvestorProfessionals__prof_function' => 'string', 'InvestorProfessionals.prof_function' => 'string', 'InvestorProfessionals__prof_last_updated' => 'datetime', 'InvestorProfessionals.prof_last_updated' => 'datetime', 'InvestorProfessionals__admin_profile_date' => 'datetime', 'InvestorProfessionals.admin_profile_date' => 'datetime', 'InvestorProfessionals__profile_image' => 'text', 'InvestorProfessionals.profile_image' => 'text', 'InvestorProfessionals__profile_keywords' => 'text', 'InvestorProfessionals.profile_keywords' => 'text', 'CompCompany__company_id' => 'integer', 'CompCompany.company_id' => 'integer', 'CompCompany__company_name' => 'string', 'CompCompany.company_name' => 'string', 'CompCompany__company_former_name_one' => 'string', 'CompCompany.company_former_name_one' => 'string', 'CompCompany__company_former_name_two' => 'string', 'CompCompany.company_former_name_two' => 'string', 'CompCompany__company_sector_id' => 'integer', 'CompCompany.company_sector_id' => 'integer', 'CompCompany__company_entity_type_id' => 'integer', 'CompCompany.company_entity_type_id' => 'integer', 'CompCompany__company_active_status' => 'integer', 'CompCompany.company_active_status' => 'integer', 'CompCompany__company_ceased_year' => 'integer', 'CompCompany.company_ceased_year' => 'integer', 'CompCompany__company_parent_id' => 'integer', 'CompCompany.company_parent_id' => 'integer', 'CompCompany__company_parent_type' => 'integer', 'CompCompany.company_parent_type' => 'integer', 'CompCompany__company_stock_exchange_id' => 'integer', 'CompCompany.company_stock_exchange_id' => 'integer', 'CompCompany__company_symbol' => 'string', 'CompCompany.company_symbol' => 'string', 'CompCompany__company_is_public' => 'integer', 'CompCompany.company_is_public' => 'integer', 'CompCompany__company_ipo_year' => 'integer', 'CompCompany.company_ipo_year' => 'integer', 'CompCompany__company_delisted_year' => 'integer', 'CompCompany.company_delisted_year' => 'integer', 'CompCompany__company_description' => 'text', 'CompCompany.company_description' => 'text', 'CompCompany__company_phone' => 'string', 'CompCompany.company_phone' => 'string', 'CompCompany__company_fax' => 'string', 'CompCompany.company_fax' => 'string', 'CompCompany__company_toll_free' => 'string', 'CompCompany.company_toll_free' => 'string', 'CompCompany__company_url' => 'string', 'CompCompany.company_url' => 'string', 'CompCompany__company_address' => 'string', 'CompCompany.company_address' => 'string', 'CompCompany__company_city' => 'string', 'CompCompany.company_city' => 'string', 'CompCompany__company_postal_code' => 'string', 'CompCompany.company_postal_code' => 'string', 'CompCompany__company_state_id' => 'integer', 'CompCompany.company_state_id' => 'integer', 'CompCompany__company_country_id' => 'integer', 'CompCompany.company_country_id' => 'integer', 'CompCompany__company_employees' => 'integer', 'CompCompany.company_employees' => 'integer', 'CompCompany__company_year_established' => 'integer', 'CompCompany.company_year_established' => 'integer', 'CompCompany__company_last_updated' => 'datetime', 'CompCompany.company_last_updated' => 'datetime', 'CompCompany__company_is_deleted' => 'integer', 'CompCompany.company_is_deleted' => 'integer', 'CompCompany__admin_profile_date' => 'datetime', 'CompCompany.admin_profile_date' => 'datetime', 'CompCompany__profile_image' => 'text', 'CompCompany.profile_image' => 'text', 'CompCompany__profile_keywords' => 'text', 'CompCompany.profile_keywords' => 'text', 'CompFirm__firm_id' => 'integer', 'CompFirm.firm_id' => 'integer', 'firm_id' => 'integer', 'CompFirm__firm_name' => 'string', 'CompFirm.firm_name' => 'string', 'firm_name' => 'string', 'CompFirm__firm_former_name' => 'string', 'CompFirm.firm_former_name' => 'string', 'firm_former_name' => 'string', 'CompFirm__firm_url' => 'string', 'CompFirm.firm_url' => 'string', 'firm_url' => 'string', 'CompFirm__firm_email' => 'string', 'CompFirm.firm_email' => 'string', 'firm_email' => 'string', 'CompFirm__firm_ownership_category_id' => 'integer', 'CompFirm.firm_ownership_category_id' => 'integer', 'firm_ownership_category_id' => 'integer', 'CompFirm__firm_funded' => 'integer', 'CompFirm.firm_funded' => 'integer', 'firm_funded' => 'integer', 'CompFirm__firm_size_id' => 'integer', 'CompFirm.firm_size_id' => 'integer', 'firm_size_id' => 'integer', 'CompFirm__firm_established_year' => 'integer', 'CompFirm.firm_established_year' => 'integer', 'firm_established_year' => 'integer', 'CompFirm__firm_inv_status' => 'integer', 'CompFirm.firm_inv_status' => 'integer', 'firm_inv_status' => 'integer', 'CompFirm__firm_visibility' => 'integer', 'CompFirm.firm_visibility' => 'integer', 'firm_visibility' => 'integer', 'CompFirm__firm_strategy_type' => 'string', 'CompFirm.firm_strategy_type' => 'string', 'firm_strategy_type' => 'string', 'CompFirm__firm_parent_id' => 'integer', 'CompFirm.firm_parent_id' => 'integer', 'firm_parent_id' => 'integer', 'CompFirm__firm_parent_type' => 'integer', 'CompFirm.firm_parent_type' => 'integer', 'firm_parent_type' => 'integer', 'CompFirm__firm_addln_offices' => 'integer', 'CompFirm.firm_addln_offices' => 'integer', 'firm_addln_offices' => 'integer', 'CompFirm__firm_hq_region_id' => 'integer', 'CompFirm.firm_hq_region_id' => 'integer', 'firm_hq_region_id' => 'integer', 'CompFirm__firm_aum' => 'string', 'CompFirm.firm_aum' => 'string', 'firm_aum' => 'string', 'CompFirm__firm_aum_currency_id' => 'integer', 'CompFirm.firm_aum_currency_id' => 'integer', 'firm_aum_currency_id' => 'integer', 'CompFirm__firm_comp_revenue_min' => 'integer', 'CompFirm.firm_comp_revenue_min' => 'integer', 'firm_comp_revenue_min' => 'integer', 'CompFirm__firm_comp_revenue_max' => 'integer', 'CompFirm.firm_comp_revenue_max' => 'integer', 'firm_comp_revenue_max' => 'integer', 'CompFirm__firm_comp_revenue_curr_id' => 'integer', 'CompFirm.firm_comp_revenue_curr_id' => 'integer', 'firm_comp_revenue_curr_id' => 'integer', 'CompFirm__firm_ebitda_min' => 'integer', 'CompFirm.firm_ebitda_min' => 'integer', 'firm_ebitda_min' => 'integer', 'CompFirm__firm_ebitda_max' => 'integer', 'CompFirm.firm_ebitda_max' => 'integer', 'firm_ebitda_max' => 'integer', 'CompFirm__firm_ebitda_curr_id' => 'integer', 'CompFirm.firm_ebitda_curr_id' => 'integer', 'firm_ebitda_curr_id' => 'integer', 'CompFirm__firm_inv_size_min' => 'integer', 'CompFirm.firm_inv_size_min' => 'integer', 'firm_inv_size_min' => 'integer', 'CompFirm__firm_inv_size_max' => 'integer', 'CompFirm.firm_inv_size_max' => 'integer', 'firm_inv_size_max' => 'integer', 'CompFirm__firm_inv_size_curr_id' => 'integer', 'CompFirm.firm_inv_size_curr_id' => 'integer', 'firm_inv_size_curr_id' => 'integer', 'CompFirm__firm_entr_value_min' => 'integer', 'CompFirm.firm_entr_value_min' => 'integer', 'firm_entr_value_min' => 'integer', 'CompFirm__firm_entr_value_max' => 'integer', 'CompFirm.firm_entr_value_max' => 'integer', 'firm_entr_value_max' => 'integer', 'CompFirm__firm_entr_value_curr_id' => 'integer', 'CompFirm.firm_entr_value_curr_id' => 'integer', 'firm_entr_value_curr_id' => 'integer', 'CompFirm__firm_description' => 'text', 'CompFirm.firm_description' => 'text', 'firm_description' => 'text', 'CompFirm__firm_last_updated' => 'datetime', 'CompFirm.firm_last_updated' => 'datetime', 'firm_last_updated' => 'datetime', 'CompFirm__professional_count' => 'integer', 'CompFirm.professional_count' => 'integer', 'professional_count' => 'integer', 'CompFirm__admin_profile_date' => 'datetime', 'CompFirm.admin_profile_date' => 'datetime', 'CompFirm__profile_image' => 'text', 'CompFirm.profile_image' => 'text', 'CompFirm__profile_keywords' => 'text', 'CompFirm.profile_keywords' => 'text', 'CompLFirm__lfirm_id' => 'integer', 'CompLFirm.lfirm_id' => 'integer', 'lfirm_id' => 'integer', 'CompLFirm__lfirm_name' => 'string', 'CompLFirm.lfirm_name' => 'string', 'lfirm_name' => 'string', 'CompLFirm__lfirm_former_name' => 'string', 'CompLFirm.lfirm_former_name' => 'string', 'lfirm_former_name' => 'string', 'CompLFirm__lfirm_url' => 'string', 'CompLFirm.lfirm_url' => 'string', 'lfirm_url' => 'string', 'CompLFirm__lfirm_email' => 'string', 'CompLFirm.lfirm_email' => 'string', 'lfirm_email' => 'string', 'CompLFirm__lfirm_description' => 'text', 'CompLFirm.lfirm_description' => 'text', 'lfirm_description' => 'text', 'CompLFirm__lfirm_ownership_category_id' => 'integer', 'CompLFirm.lfirm_ownership_category_id' => 'integer', 'lfirm_ownership_category_id' => 'integer', 'CompLFirm__lfirm_size_id' => 'integer', 'CompLFirm.lfirm_size_id' => 'integer', 'lfirm_size_id' => 'integer', 'CompLFirm__lfirm_established_year' => 'string', 'CompLFirm.lfirm_established_year' => 'string', 'lfirm_established_year' => 'string', 'CompLFirm__lfirm_inv_status' => 'integer', 'CompLFirm.lfirm_inv_status' => 'integer', 'lfirm_inv_status' => 'integer', 'CompLFirm__lfirm_visibility' => 'integer', 'CompLFirm.lfirm_visibility' => 'integer', 'lfirm_visibility' => 'integer', 'CompLFirm__lfirm_strategy_type' => 'integer', 'CompLFirm.lfirm_strategy_type' => 'integer', 'lfirm_strategy_type' => 'integer', 'CompLFirm__lfirm_parent_id' => 'integer', 'CompLFirm.lfirm_parent_id' => 'integer', 'lfirm_parent_id' => 'integer', 'CompLFirm__lfirm_parent_type' => 'integer', 'CompLFirm.lfirm_parent_type' => 'integer', 'lfirm_parent_type' => 'integer', 'CompLFirm__lfirm_addln_offices' => 'integer', 'CompLFirm.lfirm_addln_offices' => 'integer', 'lfirm_addln_offices' => 'integer', 'CompLFirm__lfirm_hq_region_id' => 'integer', 'CompLFirm.lfirm_hq_region_id' => 'integer', 'lfirm_hq_region_id' => 'integer', 'CompLFirm__lfirm_last_updated' => 'datetime', 'CompLFirm.lfirm_last_updated' => 'datetime', 'lfirm_last_updated' => 'datetime', 'CompLFirm__professional_count' => 'integer', 'CompLFirm.professional_count' => 'integer', 'CompLFirm__admin_profile_date' => 'datetime', 'CompLFirm.admin_profile_date' => 'datetime', 'CompLFirm__profile_image' => 'text', 'CompLFirm.profile_image' => 'text', 'CompLFirm__profile_keywords' => 'text', 'CompLFirm.profile_keywords' => 'text', 'CompIBank__ibank_id' => 'integer', 'CompIBank.ibank_id' => 'integer', 'ibank_id' => 'integer', 'CompIBank__ibank_name' => 'string', 'CompIBank.ibank_name' => 'string', 'ibank_name' => 'string', 'CompIBank__ibank_former_name' => 'string', 'CompIBank.ibank_former_name' => 'string', 'ibank_former_name' => 'string', 'CompIBank__ibank_url' => 'string', 'CompIBank.ibank_url' => 'string', 'ibank_url' => 'string', 'CompIBank__ibank_email' => 'string', 'CompIBank.ibank_email' => 'string', 'ibank_email' => 'string', 'CompIBank__ibank_description' => 'text', 'CompIBank.ibank_description' => 'text', 'ibank_description' => 'text', 'CompIBank__ibank_ownership_category_id' => 'integer', 'CompIBank.ibank_ownership_category_id' => 'integer', 'ibank_ownership_category_id' => 'integer', 'CompIBank__ibank_size_id' => 'integer', 'CompIBank.ibank_size_id' => 'integer', 'ibank_size_id' => 'integer', 'CompIBank__ibank_established_year' => 'string', 'CompIBank.ibank_established_year' => 'string', 'ibank_established_year' => 'string', 'CompIBank__ibank_inv_status' => 'integer', 'CompIBank.ibank_inv_status' => 'integer', 'ibank_inv_status' => 'integer', 'CompIBank__ibank_visibility' => 'integer', 'CompIBank.ibank_visibility' => 'integer', 'ibank_visibility' => 'integer', 'CompIBank__ibank_strategy_type' => 'integer', 'CompIBank.ibank_strategy_type' => 'integer', 'ibank_strategy_type' => 'integer', 'CompIBank__ibank_parent_id' => 'integer', 'CompIBank.ibank_parent_id' => 'integer', 'ibank_parent_id' => 'integer', 'CompIBank__ibank_parent_type' => 'integer', 'CompIBank.ibank_parent_type' => 'integer', 'ibank_parent_type' => 'integer', 'CompIBank__ibank_addln_offices' => 'integer', 'CompIBank.ibank_addln_offices' => 'integer', 'ibank_addln_offices' => 'integer', 'CompIBank__ibank_hq_region_id' => 'integer', 'CompIBank.ibank_hq_region_id' => 'integer', 'ibank_hq_region_id' => 'integer', 'CompIBank__ibank_last_updated' => 'datetime', 'CompIBank.ibank_last_updated' => 'datetime', 'ibank_last_updated' => 'datetime', 'CompIBank__professional_count' => 'integer', 'CompIBank.professional_count' => 'integer', 'CompIBank__admin_profile_date' => 'datetime', 'CompIBank.admin_profile_date' => 'datetime', 'CompIBank__profile_image' => 'text', 'CompIBank.profile_image' => 'text', 'CompIBank__profile_keywords' => 'text', 'CompIBank.profile_keywords' => 'text', 'CompProfessional__professional_id' => 'integer', 'CompProfessional.professional_id' => 'integer', 'CompProfessional__professional_company_id' => 'integer', 'CompProfessional.professional_company_id' => 'integer', 'CompProfessional__professional_company_type' => 'integer', 'CompProfessional.professional_company_type' => 'integer', 'CompProfessional__prof_name' => 'string', 'CompProfessional.prof_name' => 'string', 'CompProfessional__prof_email' => 'string', 'CompProfessional.prof_email' => 'string', 'CompProfessional__prof_designation' => 'string', 'CompProfessional.prof_designation' => 'string', 'CompProfessional__prof_join_dt' => 'integer', 'CompProfessional.prof_join_dt' => 'integer', 'CompProfessional__prof_bio' => 'text', 'CompProfessional.prof_bio' => 'text', 'CompProfessional__prof_phone_number' => 'string', 'CompProfessional.prof_phone_number' => 'string', 'CompProfessional__prof_fax' => 'string', 'CompProfessional.prof_fax' => 'string', 'CompProfessional__prof_rank' => 'integer', 'CompProfessional.prof_rank' => 'integer', 'CompProfessional__prof_board_seat' => 'integer', 'CompProfessional.prof_board_seat' => 'integer', 'CompProfessional__prof_office_id' => 'integer', 'CompProfessional.prof_office_id' => 'integer', 'CompProfessional__prof_function' => 'string', 'CompProfessional.prof_function' => 'string', 'CompProfessional__prof_last_updated' => 'datetime', 'CompProfessional.prof_last_updated' => 'datetime', 'CompProfessional__admin_profile_date' => 'datetime', 'CompProfessional.admin_profile_date' => 'datetime', 'CompProfessional__profile_image' => 'text', 'CompProfessional.profile_image' => 'text', 'CompProfessional__profile_keywords' => 'text', 'CompProfessional.profile_keywords' => 'text', 'InvestorCurrency__id' => 'integer', 'InvestorCurrency.id' => 'integer', 'InvestorCurrency__currency_name' => 'string', 'InvestorCurrency.currency_name' => 'string', 'InvestorCurrency__currency_rate' => 'float', 'InvestorCurrency.currency_rate' => 'float', 'Investments__comp_tran_inv_id' => 'integer', 'Investments.comp_tran_inv_id' => 'integer', 'Investments__comp_transaction_id' => 'integer', 'Investments.comp_transaction_id' => 'integer', 'Investments__comp_tran_investor_id' => 'integer', 'Investments.comp_tran_investor_id' => 'integer', 'Investments__comp_tran_investor_type' => 'integer', 'Investments.comp_tran_investor_type' => 'integer', 'Investments__comp_investment_amount' => 'string', 'Investments.comp_investment_amount' => 'string', 'Investments__comp_investment_stake' => 'string', 'Investments.comp_investment_stake' => 'string', 'Investments__comp_investment_currency_id' => 'integer', 'Investments.comp_investment_currency_id' => 'integer', 'Investments__comp_investment_position' => 'string', 'Investments.comp_investment_position' => 'string', 'Investments__comp_investment_inv_ann_dt' => 'datetime', 'Investments.comp_investment_inv_ann_dt' => 'datetime', 'Investments__comp_investment_inv_cl_dt' => 'datetime', 'Investments.comp_investment_inv_cl_dt' => 'datetime', 'Investments__comp_investment_exit_ann_dt' => 'datetime', 'Investments.comp_investment_exit_ann_dt' => 'datetime', 'Investments__comp_investment_exit_cl_dt' => 'datetime', 'Investments.comp_investment_exit_cl_dt' => 'datetime', 'Investments__comp_investment_acqui_type_id' => 'integer', 'Investments.comp_investment_acqui_type_id' => 'integer', 'Investments__comp_investment_exit_type_id' => 'integer', 'Investments.comp_investment_exit_type_id' => 'integer', 'Investments__comp_invst_inv_ann_pr_link' => 'string', 'Investments.comp_invst_inv_ann_pr_link' => 'string', 'Investments__comp_invst_inv_cl_pr_link' => 'string', 'Investments.comp_invst_inv_cl_pr_link' => 'string', 'Investments__comp_invst_exit_ann_pr_link' => 'string', 'Investments.comp_invst_exit_ann_pr_link' => 'string', 'Investments__comp_invst_exit_closed_pr_link' => 'string', 'Investments.comp_invst_exit_closed_pr_link' => 'string', 'InvestingCompTran__comp_transaction_id' => 'integer', 'InvestingCompTran.comp_transaction_id' => 'integer', 'InvestingCompTran__company_id' => 'integer', 'InvestingCompTran.company_id' => 'integer', 'InvestingCompTran__investment_announced_dt' => 'datetime', 'InvestingCompTran.investment_announced_dt' => 'datetime', 'InvestingCompTran__exit_announced_dt' => 'datetime', 'InvestingCompTran.exit_announced_dt' => 'datetime', 'InvestingCompTran__investment_closed_dt' => 'datetime', 'InvestingCompTran.investment_closed_dt' => 'datetime', 'InvestingCompTran__exit_closed_dt' => 'datetime', 'InvestingCompTran.exit_closed_dt' => 'datetime', 'InvestingCompTran__acquisition_type_id' => 'integer', 'InvestingCompTran.acquisition_type_id' => 'integer', 'InvestingCompTran__exit_type_id' => 'integer', 'InvestingCompTran.exit_type_id' => 'integer', 'InvestingCompTran__deal_value' => 'string', 'InvestingCompTran.deal_value' => 'string', 'InvestingCompTran__inv_currency_id' => 'integer', 'InvestingCompTran.inv_currency_id' => 'integer', 'InvestingCompTran__investment_revenue' => 'string', 'InvestingCompTran.investment_revenue' => 'string', 'InvestingCompTran__investment_ebitda' => 'string', 'InvestingCompTran.investment_ebitda' => 'string', 'InvestingCompTran__exit_value' => 'string', 'InvestingCompTran.exit_value' => 'string', 'InvestingCompTran__exit_currency_id' => 'integer', 'InvestingCompTran.exit_currency_id' => 'integer', 'InvestingCompTran__exit_revenue' => 'string', 'InvestingCompTran.exit_revenue' => 'string', 'InvestingCompTran__exit_ebitda' => 'string', 'InvestingCompTran.exit_ebitda' => 'string', 'InvestingCompTran__investment_annced_pr_link' => 'string', 'InvestingCompTran.investment_annced_pr_link' => 'string', 'InvestingCompTran__investment_closed_pr_link' => 'string', 'InvestingCompTran.investment_closed_pr_link' => 'string', 'InvestingCompTran__exit_annced_pr_link' => 'string', 'InvestingCompTran.exit_annced_pr_link' => 'string', 'InvestingCompTran__exit_closed_pr_link' => 'string', 'InvestingCompTran.exit_closed_pr_link' => 'string', 'InvestingCompTran__active_status' => 'integer', 'InvestingCompTran.active_status' => 'integer', 'InvestingCompTran__parent_tran_id' => 'integer', 'InvestingCompTran.parent_tran_id' => 'integer', 'InvestingCompTran__child_tran_id' => 'integer', 'InvestingCompTran.child_tran_id' => 'integer' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'Sector' => [[maximum depth reached]], 'Country' => [[maximum depth reached]], 'State' => [[maximum depth reached]], 'StockExchange' => [[maximum depth reached]], 'ProfileParent' => [[maximum depth reached]], 'CompanyProfessionals' => [ [maximum depth reached] ], 'CompTrans' => [ [maximum depth reached] ], 'Investments' => [ [maximum depth reached] ] ], 'matching' => [ 'CompTrans' => [ [maximum depth reached] ] ], 'extraOptions' => [], 'repository' => object(Admin\Model\Table\CompaniesTable) {} } $companies = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Companies.company_id AS `Companies__company_id`, Companies.company_name AS `Companies__company_name`, Companies.company_former_name_one AS `Companies__company_former_name_one`, Companies.company_former_name_two AS `Companies__company_former_name_two`, Companies.company_sector_id AS `Companies__company_sector_id`, Companies.company_entity_type_id AS `Companies__company_entity_type_id`, Companies.company_active_status AS `Companies__company_active_status`, Companies.company_ceased_year AS `Companies__company_ceased_year`, Companies.company_parent_id AS `Companies__company_parent_id`, Companies.company_parent_type AS `Companies__company_parent_type`, Companies.company_stock_exchange_id AS `Companies__company_stock_exchange_id`, Companies.company_symbol AS `Companies__company_symbol`, Companies.company_is_public AS `Companies__company_is_public`, Companies.company_ipo_year AS `Companies__company_ipo_year`, Companies.company_delisted_year AS `Companies__company_delisted_year`, Companies.company_description AS `Companies__company_description`, Companies.company_phone AS `Companies__company_phone`, Companies.company_fax AS `Companies__company_fax`, Companies.company_toll_free AS `Companies__company_toll_free`, Companies.company_url AS `Companies__company_url`, Companies.company_address AS `Companies__company_address`, Companies.company_city AS `Companies__company_city`, Companies.company_postal_code AS `Companies__company_postal_code`, Companies.company_state_id AS `Companies__company_state_id`, Companies.company_country_id AS `Companies__company_country_id`, Companies.company_employees AS `Companies__company_employees`, Companies.company_year_established AS `Companies__company_year_established`, Companies.company_last_updated AS `Companies__company_last_updated`, Companies.company_is_deleted AS `Companies__company_is_deleted`, Companies.admin_profile_date AS `Companies__admin_profile_date`, Companies.profile_image AS `Companies__profile_image`, Companies.profile_keywords AS `Companies__profile_keywords`, CompTrans.comp_transaction_id AS `CompTrans__comp_transaction_id`, CompTrans.company_id AS `CompTrans__company_id`, CompTrans.investment_announced_dt AS `CompTrans__investment_announced_dt`, CompTrans.exit_announced_dt AS `CompTrans__exit_announced_dt`, CompTrans.investment_closed_dt AS `CompTrans__investment_closed_dt`, CompTrans.exit_closed_dt AS `CompTrans__exit_closed_dt`, CompTrans.acquisition_type_id AS `CompTrans__acquisition_type_id`, CompTrans.exit_type_id AS `CompTrans__exit_type_id`, CompTrans.deal_value AS `CompTrans__deal_value`, CompTrans.inv_currency_id AS `CompTrans__inv_currency_id`, CompTrans.investment_revenue AS `CompTrans__investment_revenue`, CompTrans.investment_ebitda AS `CompTrans__investment_ebitda`, CompTrans.exit_value AS `CompTrans__exit_value`, CompTrans.exit_currency_id AS `CompTrans__exit_currency_id`, CompTrans.exit_revenue AS `CompTrans__exit_revenue`, CompTrans.exit_ebitda AS `CompTrans__exit_ebitda`, CompTrans.investment_annced_pr_link AS `CompTrans__investment_annced_pr_link`, CompTrans.investment_closed_pr_link AS `CompTrans__investment_closed_pr_link`, CompTrans.exit_annced_pr_link AS `CompTrans__exit_annced_pr_link`, CompTrans.exit_closed_pr_link AS `CompTrans__exit_closed_pr_link`, CompTrans.active_status AS `CompTrans__active_status`, CompTrans.parent_tran_id AS `CompTrans__parent_tran_id`, CompTrans.child_tran_id AS `CompTrans__child_tran_id`, CompInvestors.comp_tran_inv_id AS `CompInvestors__comp_tran_inv_id`, CompInvestors.comp_transaction_id AS `CompInvestors__comp_transaction_id`, CompInvestors.comp_tran_investor_id AS `CompInvestors__comp_tran_investor_id`, CompInvestors.comp_tran_investor_type AS `CompInvestors__comp_tran_investor_type`, CompInvestors.comp_investment_amount AS `CompInvestors__comp_investment_amount`, CompInvestors.comp_investment_stake AS `CompInvestors__comp_investment_stake`, CompInvestors.comp_investment_currency_id AS `CompInvestors__comp_investment_currency_id`, CompInvestors.comp_investment_position AS `CompInvestors__comp_investment_position`, CompInvestors.comp_investment_inv_ann_dt AS `CompInvestors__comp_investment_inv_ann_dt`, CompInvestors.comp_investment_inv_cl_dt AS `CompInvestors__comp_investment_inv_cl_dt`, CompInvestors.comp_investment_exit_ann_dt AS `CompInvestors__comp_investment_exit_ann_dt`, CompInvestors.comp_investment_exit_cl_dt AS `CompInvestors__comp_investment_exit_cl_dt`, CompInvestors.comp_investment_acqui_type_id AS `CompInvestors__comp_investment_acqui_type_id`, CompInvestors.comp_investment_exit_type_id AS `CompInvestors__comp_investment_exit_type_id`, CompInvestors.comp_invst_inv_ann_pr_link AS `CompInvestors__comp_invst_inv_ann_pr_link`, CompInvestors.comp_invst_inv_cl_pr_link AS `CompInvestors__comp_invst_inv_cl_pr_link`, CompInvestors.comp_invst_exit_ann_pr_link AS `CompInvestors__comp_invst_exit_ann_pr_link`, CompInvestors.comp_invst_exit_closed_pr_link AS `CompInvestors__comp_invst_exit_closed_pr_link`, InvestorProfessionals.professional_id AS `InvestorProfessionals__professional_id`, InvestorProfessionals.professional_company_id AS `InvestorProfessionals__professional_company_id`, InvestorProfessionals.professional_company_type AS `InvestorProfessionals__professional_company_type`, InvestorProfessionals.prof_name AS `InvestorProfessionals__prof_name`, InvestorProfessionals.prof_email AS `InvestorProfessionals__prof_email`, InvestorProfessionals.prof_designation AS `InvestorProfessionals__prof_designation`, InvestorProfessionals.prof_join_dt AS `InvestorProfessionals__prof_join_dt`, InvestorProfessionals.prof_bio AS `InvestorProfessionals__prof_bio`, InvestorProfessionals.prof_phone_number AS `InvestorProfessionals__prof_phone_number`, InvestorProfessionals.prof_fax AS `InvestorProfessionals__prof_fax`, InvestorProfessionals.prof_rank AS `InvestorProfessionals__prof_rank`, InvestorProfessionals.prof_board_seat AS `InvestorProfessionals__prof_board_seat`, InvestorProfessionals.prof_office_id AS `InvestorProfessionals__prof_office_id`, InvestorProfessionals.prof_function AS `InvestorProfessionals__prof_function`, InvestorProfessionals.prof_last_updated AS `InvestorProfessionals__prof_last_updated`, InvestorProfessionals.admin_profile_date AS `InvestorProfessionals__admin_profile_date`, InvestorProfessionals.profile_image AS `InvestorProfessionals__profile_image`, InvestorProfessionals.profile_keywords AS `InvestorProfessionals__profile_keywords`, InvestmentTargetCompany.company_id AS `InvestmentTargetCompany__company_id`, InvestmentTargetCompany.company_name AS `InvestmentTargetCompany__company_name`, InvestmentTargetCompany.company_former_name_one AS `InvestmentTargetCompany__company_former_name_one`, InvestmentTargetCompany.company_former_name_two AS `InvestmentTargetCompany__company_former_name_two`, InvestmentTargetCompany.company_sector_id AS `InvestmentTargetCompany__company_sector_id`, InvestmentTargetCompany.company_entity_type_id AS `InvestmentTargetCompany__company_entity_type_id`, InvestmentTargetCompany.company_active_status AS `InvestmentTargetCompany__company_active_status`, InvestmentTargetCompany.company_ceased_year AS `InvestmentTargetCompany__company_ceased_year`, InvestmentTargetCompany.company_parent_id AS `InvestmentTargetCompany__company_parent_id`, InvestmentTargetCompany.company_parent_type AS `InvestmentTargetCompany__company_parent_type`, InvestmentTargetCompany.company_stock_exchange_id AS `InvestmentTargetCompany__company_stock_exchange_id`, InvestmentTargetCompany.company_symbol AS `InvestmentTargetCompany__company_symbol`, InvestmentTargetCompany.company_is_public AS `InvestmentTargetCompany__company_is_public`, InvestmentTargetCompany.company_ipo_year AS `InvestmentTargetCompany__company_ipo_year`, InvestmentTargetCompany.company_delisted_year AS `InvestmentTargetCompany__company_delisted_year`, InvestmentTargetCompany.company_description AS `InvestmentTargetCompany__company_description`, InvestmentTargetCompany.company_phone AS `InvestmentTargetCompany__company_phone`, InvestmentTargetCompany.company_fax AS `InvestmentTargetCompany__company_fax`, InvestmentTargetCompany.company_toll_free AS `InvestmentTargetCompany__company_toll_free`, InvestmentTargetCompany.company_url AS `InvestmentTargetCompany__company_url`, InvestmentTargetCompany.company_address AS `InvestmentTargetCompany__company_address`, InvestmentTargetCompany.company_city AS `InvestmentTargetCompany__company_city`, InvestmentTargetCompany.company_postal_code AS `InvestmentTargetCompany__company_postal_code`, InvestmentTargetCompany.company_state_id AS `InvestmentTargetCompany__company_state_id`, InvestmentTargetCompany.company_country_id AS `InvestmentTargetCompany__company_country_id`, InvestmentTargetCompany.company_employees AS `InvestmentTargetCompany__company_employees`, InvestmentTargetCompany.company_year_established AS `InvestmentTargetCompany__company_year_established`, InvestmentTargetCompany.company_last_updated AS `InvestmentTargetCompany__company_last_updated`, InvestmentTargetCompany.company_is_deleted AS `InvestmentTargetCompany__company_is_deleted`, InvestmentTargetCompany.admin_profile_date AS `InvestmentTargetCompany__admin_profile_date`, InvestmentTargetCompany.profile_image AS `InvestmentTargetCompany__profile_image`, InvestmentTargetCompany.profile_keywords AS `InvestmentTargetCompany__profile_keywords`, Sector.id AS `Sector__id`, Sector.sector_name AS `Sector__sector_name`, Country.id AS `Country__id`, Country.country_name AS `Country__country_name`, State.id AS `State__id`, State.country_id AS `State__country_id`, State.state_name AS `State__state_name`, StockExchange.id AS `StockExchange__id`, StockExchange.exchange_name AS `StockExchange__exchange_name`, ProfileParent.id AS `ProfileParent__id`, ProfileParent.child_id AS `ProfileParent__child_id`, ProfileParent.child_type AS `ProfileParent__child_type`, ProfileParent.parent_id AS `ProfileParent__parent_id`, ProfileParent.parent_name AS `ProfileParent__parent_name`, ProfileParent.parent_type AS `ProfileParent__parent_type` FROM companies Companies INNER JOIN company_transactions CompTrans ON (parent_tran_id = :c0 AND Companies.company_id = (CompTrans.company_id)) INNER JOIN comp_transaction_investors CompInvestors ON CompTrans.comp_transaction_id = (CompInvestors.comp_transaction_id) INNER JOIN professionals InvestorProfessionals ON (CompInvestors.comp_tran_investor_type = :c1 AND CompInvestors.comp_tran_investor_id = (InvestorProfessionals.professional_id)) INNER JOIN companies InvestmentTargetCompany ON InvestmentTargetCompany.company_id = (CompTrans.company_id) LEFT JOIN sectors Sector ON Companies.company_sector_id = (Sector.id) LEFT JOIN countries Country ON Companies.company_country_id = (Country.id) LEFT JOIN states State ON Companies.company_state_id = (State.id) LEFT JOIN stock_exchanges StockExchange ON Companies.company_stock_exchange_id = (StockExchange.id) LEFT JOIN profile_parents ProfileParent ON (child_type = :c2 AND Companies.company_id = (ProfileParent.child_id)) WHERE (InvestorProfessionals.professional_id = :c3 AND InvestmentTargetCompany.company_is_deleted != :c4) ORDER BY CASE WHEN CompTrans.investment_closed_dt IS NOT NULL THEN CompTrans.investment_closed_dt ELSE CompTrans.investment_announced_dt END DESC LIMIT 2', 'params' => [ ':c0' => [ [maximum depth reached] ], ':c1' => [ [maximum depth reached] ], ':c2' => [ [maximum depth reached] ], ':c3' => [ [maximum depth reached] ], ':c4' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Companies__company_id' => 'integer', 'Companies.company_id' => 'integer', 'company_id' => 'integer', 'Companies__company_name' => 'string', 'Companies.company_name' => 'string', 'company_name' => 'string', 'Companies__company_former_name_one' => 'string', 'Companies.company_former_name_one' => 'string', 'company_former_name_one' => 'string', 'Companies__company_former_name_two' => 'string', 'Companies.company_former_name_two' => 'string', 'company_former_name_two' => 'string', 'Companies__company_sector_id' => 'integer', 'Companies.company_sector_id' => 'integer', 'company_sector_id' => 'integer', 'Companies__company_entity_type_id' => 'integer', 'Companies.company_entity_type_id' => 'integer', 'company_entity_type_id' => 'integer', 'Companies__company_active_status' => 'integer', 'Companies.company_active_status' => 'integer', 'company_active_status' => 'integer', 'Companies__company_ceased_year' => 'integer', 'Companies.company_ceased_year' => 'integer', 'company_ceased_year' => 'integer', 'Companies__company_parent_id' => 'integer', 'Companies.company_parent_id' => 'integer', 'company_parent_id' => 'integer', 'Companies__company_parent_type' => 'integer', 'Companies.company_parent_type' => 'integer', 'company_parent_type' => 'integer', 'Companies__company_stock_exchange_id' => 'integer', 'Companies.company_stock_exchange_id' => 'integer', 'company_stock_exchange_id' => 'integer', 'Companies__company_symbol' => 'string', 'Companies.company_symbol' => 'string', 'company_symbol' => 'string', 'Companies__company_is_public' => 'integer', 'Companies.company_is_public' => 'integer', 'company_is_public' => 'integer', 'Companies__company_ipo_year' => 'integer', 'Companies.company_ipo_year' => 'integer', 'company_ipo_year' => 'integer', 'Companies__company_delisted_year' => 'integer', 'Companies.company_delisted_year' => 'integer', 'company_delisted_year' => 'integer', 'Companies__company_description' => 'text', 'Companies.company_description' => 'text', 'company_description' => 'text', 'Companies__company_phone' => 'string', 'Companies.company_phone' => 'string', 'company_phone' => 'string', 'Companies__company_fax' => 'string', 'Companies.company_fax' => 'string', 'company_fax' => 'string', 'Companies__company_toll_free' => 'string', 'Companies.company_toll_free' => 'string', 'company_toll_free' => 'string', 'Companies__company_url' => 'string', 'Companies.company_url' => 'string', 'company_url' => 'string', 'Companies__company_address' => 'string', 'Companies.company_address' => 'string', 'company_address' => 'string', 'Companies__company_city' => 'string', 'Companies.company_city' => 'string', 'company_city' => 'string', 'Companies__company_postal_code' => 'string', 'Companies.company_postal_code' => 'string', 'company_postal_code' => 'string', 'Companies__company_state_id' => 'integer', 'Companies.company_state_id' => 'integer', 'company_state_id' => 'integer', 'Companies__company_country_id' => 'integer', 'Companies.company_country_id' => 'integer', 'company_country_id' => 'integer', 'Companies__company_employees' => 'integer', 'Companies.company_employees' => 'integer', 'company_employees' => 'integer', 'Companies__company_year_established' => 'integer', 'Companies.company_year_established' => 'integer', 'company_year_established' => 'integer', 'Companies__company_last_updated' => 'datetime', 'Companies.company_last_updated' => 'datetime', 'company_last_updated' => 'datetime', 'Companies__company_is_deleted' => 'integer', 'Companies.company_is_deleted' => 'integer', 'company_is_deleted' => 'integer', 'Companies__admin_profile_date' => 'datetime', 'Companies.admin_profile_date' => 'datetime', 'admin_profile_date' => 'datetime', 'Companies__profile_image' => 'text', 'Companies.profile_image' => 'text', 'profile_image' => 'text', 'Companies__profile_keywords' => 'text', 'Companies.profile_keywords' => 'text', 'profile_keywords' => 'text', 'Sector__id' => 'integer', 'Sector.id' => 'integer', 'id' => 'integer', 'Sector__sector_name' => 'string', 'Sector.sector_name' => 'string', 'sector_name' => 'string', 'Country__id' => 'integer', 'Country.id' => 'integer', 'Country__country_name' => 'string', 'Country.country_name' => 'string', 'country_name' => 'string', 'State__id' => 'integer', 'State.id' => 'integer', 'State__country_id' => 'integer', 'State.country_id' => 'integer', 'country_id' => 'integer', 'State__state_name' => 'string', 'State.state_name' => 'string', 'state_name' => 'string', 'StockExchange__id' => 'integer', 'StockExchange.id' => 'integer', 'StockExchange__exchange_name' => 'string', 'StockExchange.exchange_name' => 'string', 'exchange_name' => 'string', 'ProfileParent__id' => 'integer', 'ProfileParent.id' => 'integer', 'ProfileParent__child_id' => 'integer', 'ProfileParent.child_id' => 'integer', 'child_id' => 'integer', 'ProfileParent__child_type' => 'integer', 'ProfileParent.child_type' => 'integer', 'child_type' => 'integer', 'ProfileParent__parent_id' => 'integer', 'ProfileParent.parent_id' => 'integer', 'parent_id' => 'integer', 'ProfileParent__parent_name' => 'string', 'ProfileParent.parent_name' => 'string', 'parent_name' => 'string', 'ProfileParent__parent_type' => 'integer', 'ProfileParent.parent_type' => 'integer', 'parent_type' => 'integer', 'CompanyProfessionals__professional_id' => 'integer', 'CompanyProfessionals.professional_id' => 'integer', 'professional_id' => 'integer', 'CompanyProfessionals__professional_company_id' => 'integer', 'CompanyProfessionals.professional_company_id' => 'integer', 'professional_company_id' => 'integer', 'CompanyProfessionals__professional_company_type' => 'integer', 'CompanyProfessionals.professional_company_type' => 'integer', 'professional_company_type' => 'integer', 'CompanyProfessionals__prof_name' => 'string', 'CompanyProfessionals.prof_name' => 'string', 'prof_name' => 'string', 'CompanyProfessionals__prof_email' => 'string', 'CompanyProfessionals.prof_email' => 'string', 'prof_email' => 'string', 'CompanyProfessionals__prof_designation' => 'string', 'CompanyProfessionals.prof_designation' => 'string', 'prof_designation' => 'string', 'CompanyProfessionals__prof_join_dt' => 'integer', 'CompanyProfessionals.prof_join_dt' => 'integer', 'prof_join_dt' => 'integer', 'CompanyProfessionals__prof_bio' => 'text', 'CompanyProfessionals.prof_bio' => 'text', 'prof_bio' => 'text', 'CompanyProfessionals__prof_phone_number' => 'string', 'CompanyProfessionals.prof_phone_number' => 'string', 'prof_phone_number' => 'string', 'CompanyProfessionals__prof_fax' => 'string', 'CompanyProfessionals.prof_fax' => 'string', 'prof_fax' => 'string', 'CompanyProfessionals__prof_rank' => 'integer', 'CompanyProfessionals.prof_rank' => 'integer', 'prof_rank' => 'integer', 'CompanyProfessionals__prof_board_seat' => 'integer', 'CompanyProfessionals.prof_board_seat' => 'integer', 'prof_board_seat' => 'integer', 'CompanyProfessionals__prof_office_id' => 'integer', 'CompanyProfessionals.prof_office_id' => 'integer', 'prof_office_id' => 'integer', 'CompanyProfessionals__prof_function' => 'string', 'CompanyProfessionals.prof_function' => 'string', 'prof_function' => 'string', 'CompanyProfessionals__prof_last_updated' => 'datetime', 'CompanyProfessionals.prof_last_updated' => 'datetime', 'prof_last_updated' => 'datetime', 'CompanyProfessionals__admin_profile_date' => 'datetime', 'CompanyProfessionals.admin_profile_date' => 'datetime', 'CompanyProfessionals__profile_image' => 'text', 'CompanyProfessionals.profile_image' => 'text', 'CompanyProfessionals__profile_keywords' => 'text', 'CompanyProfessionals.profile_keywords' => 'text', 'CompTrans__comp_transaction_id' => 'integer', 'CompTrans.comp_transaction_id' => 'integer', 'comp_transaction_id' => 'integer', 'CompTrans__company_id' => 'integer', 'CompTrans.company_id' => 'integer', 'CompTrans__investment_announced_dt' => 'datetime', 'CompTrans.investment_announced_dt' => 'datetime', 'investment_announced_dt' => 'datetime', 'CompTrans__exit_announced_dt' => 'datetime', 'CompTrans.exit_announced_dt' => 'datetime', 'exit_announced_dt' => 'datetime', 'CompTrans__investment_closed_dt' => 'datetime', 'CompTrans.investment_closed_dt' => 'datetime', 'investment_closed_dt' => 'datetime', 'CompTrans__exit_closed_dt' => 'datetime', 'CompTrans.exit_closed_dt' => 'datetime', 'exit_closed_dt' => 'datetime', 'CompTrans__acquisition_type_id' => 'integer', 'CompTrans.acquisition_type_id' => 'integer', 'acquisition_type_id' => 'integer', 'CompTrans__exit_type_id' => 'integer', 'CompTrans.exit_type_id' => 'integer', 'exit_type_id' => 'integer', 'CompTrans__deal_value' => 'string', 'CompTrans.deal_value' => 'string', 'deal_value' => 'string', 'CompTrans__inv_currency_id' => 'integer', 'CompTrans.inv_currency_id' => 'integer', 'inv_currency_id' => 'integer', 'CompTrans__investment_revenue' => 'string', 'CompTrans.investment_revenue' => 'string', 'investment_revenue' => 'string', 'CompTrans__investment_ebitda' => 'string', 'CompTrans.investment_ebitda' => 'string', 'investment_ebitda' => 'string', 'CompTrans__exit_value' => 'string', 'CompTrans.exit_value' => 'string', 'exit_value' => 'string', 'CompTrans__exit_currency_id' => 'integer', 'CompTrans.exit_currency_id' => 'integer', 'exit_currency_id' => 'integer', 'CompTrans__exit_revenue' => 'string', 'CompTrans.exit_revenue' => 'string', 'exit_revenue' => 'string', 'CompTrans__exit_ebitda' => 'string', 'CompTrans.exit_ebitda' => 'string', 'exit_ebitda' => 'string', 'CompTrans__investment_annced_pr_link' => 'string', 'CompTrans.investment_annced_pr_link' => 'string', 'investment_annced_pr_link' => 'string', 'CompTrans__investment_closed_pr_link' => 'string', 'CompTrans.investment_closed_pr_link' => 'string', 'investment_closed_pr_link' => 'string', 'CompTrans__exit_annced_pr_link' => 'string', 'CompTrans.exit_annced_pr_link' => 'string', 'exit_annced_pr_link' => 'string', 'CompTrans__exit_closed_pr_link' => 'string', 'CompTrans.exit_closed_pr_link' => 'string', 'exit_closed_pr_link' => 'string', 'CompTrans__active_status' => 'integer', 'CompTrans.active_status' => 'integer', 'active_status' => 'integer', 'CompTrans__parent_tran_id' => 'integer', 'CompTrans.parent_tran_id' => 'integer', 'parent_tran_id' => 'integer', 'CompTrans__child_tran_id' => 'integer', 'CompTrans.child_tran_id' => 'integer', 'child_tran_id' => 'integer', 'InvestmentTargetCompany__company_id' => 'integer', 'InvestmentTargetCompany.company_id' => 'integer', 'InvestmentTargetCompany__company_name' => 'string', 'InvestmentTargetCompany.company_name' => 'string', 'InvestmentTargetCompany__company_former_name_one' => 'string', 'InvestmentTargetCompany.company_former_name_one' => 'string', 'InvestmentTargetCompany__company_former_name_two' => 'string', 'InvestmentTargetCompany.company_former_name_two' => 'string', 'InvestmentTargetCompany__company_sector_id' => 'integer', 'InvestmentTargetCompany.company_sector_id' => 'integer', 'InvestmentTargetCompany__company_entity_type_id' => 'integer', 'InvestmentTargetCompany.company_entity_type_id' => 'integer', 'InvestmentTargetCompany__company_active_status' => 'integer', 'InvestmentTargetCompany.company_active_status' => 'integer', 'InvestmentTargetCompany__company_ceased_year' => 'integer', 'InvestmentTargetCompany.company_ceased_year' => 'integer', 'InvestmentTargetCompany__company_parent_id' => 'integer', 'InvestmentTargetCompany.company_parent_id' => 'integer', 'InvestmentTargetCompany__company_parent_type' => 'integer', 'InvestmentTargetCompany.company_parent_type' => 'integer', 'InvestmentTargetCompany__company_stock_exchange_id' => 'integer', 'InvestmentTargetCompany.company_stock_exchange_id' => 'integer', 'InvestmentTargetCompany__company_symbol' => 'string', 'InvestmentTargetCompany.company_symbol' => 'string', 'InvestmentTargetCompany__company_is_public' => 'integer', 'InvestmentTargetCompany.company_is_public' => 'integer', 'InvestmentTargetCompany__company_ipo_year' => 'integer', 'InvestmentTargetCompany.company_ipo_year' => 'integer', 'InvestmentTargetCompany__company_delisted_year' => 'integer', 'InvestmentTargetCompany.company_delisted_year' => 'integer', 'InvestmentTargetCompany__company_description' => 'text', 'InvestmentTargetCompany.company_description' => 'text', 'InvestmentTargetCompany__company_phone' => 'string', 'InvestmentTargetCompany.company_phone' => 'string', 'InvestmentTargetCompany__company_fax' => 'string', 'InvestmentTargetCompany.company_fax' => 'string', 'InvestmentTargetCompany__company_toll_free' => 'string', 'InvestmentTargetCompany.company_toll_free' => 'string', 'InvestmentTargetCompany__company_url' => 'string', 'InvestmentTargetCompany.company_url' => 'string', 'InvestmentTargetCompany__company_address' => 'string', 'InvestmentTargetCompany.company_address' => 'string', 'InvestmentTargetCompany__company_city' => 'string', 'InvestmentTargetCompany.company_city' => 'string', 'InvestmentTargetCompany__company_postal_code' => 'string', 'InvestmentTargetCompany.company_postal_code' => 'string', 'InvestmentTargetCompany__company_state_id' => 'integer', 'InvestmentTargetCompany.company_state_id' => 'integer', 'InvestmentTargetCompany__company_country_id' => 'integer', 'InvestmentTargetCompany.company_country_id' => 'integer', 'InvestmentTargetCompany__company_employees' => 'integer', 'InvestmentTargetCompany.company_employees' => 'integer', 'InvestmentTargetCompany__company_year_established' => 'integer', 'InvestmentTargetCompany.company_year_established' => 'integer', 'InvestmentTargetCompany__company_last_updated' => 'datetime', 'InvestmentTargetCompany.company_last_updated' => 'datetime', 'InvestmentTargetCompany__company_is_deleted' => 'integer', 'InvestmentTargetCompany.company_is_deleted' => 'integer', 'InvestmentTargetCompany__admin_profile_date' => 'datetime', 'InvestmentTargetCompany.admin_profile_date' => 'datetime', 'InvestmentTargetCompany__profile_image' => 'text', 'InvestmentTargetCompany.profile_image' => 'text', 'InvestmentTargetCompany__profile_keywords' => 'text', 'InvestmentTargetCompany.profile_keywords' => 'text', 'AcquiType__id' => 'integer', 'AcquiType.id' => 'integer', 'AcquiType__acquisition_name' => 'string', 'AcquiType.acquisition_name' => 'string', 'acquisition_name' => 'string', 'ExitType__id' => 'integer', 'ExitType.id' => 'integer', 'ExitType__exit_name' => 'string', 'ExitType.exit_name' => 'string', 'exit_name' => 'string', 'InvCurrency__id' => 'integer', 'InvCurrency.id' => 'integer', 'InvCurrency__currency_name' => 'string', 'InvCurrency.currency_name' => 'string', 'currency_name' => 'string', 'InvCurrency__currency_rate' => 'float', 'InvCurrency.currency_rate' => 'float', 'currency_rate' => 'float', 'ExitCurrency__id' => 'integer', 'ExitCurrency.id' => 'integer', 'ExitCurrency__currency_name' => 'string', 'ExitCurrency.currency_name' => 'string', 'ExitCurrency__currency_rate' => 'float', 'ExitCurrency.currency_rate' => 'float', 'CompInvestors__comp_tran_inv_id' => 'integer', 'CompInvestors.comp_tran_inv_id' => 'integer', 'comp_tran_inv_id' => 'integer', 'CompInvestors__comp_transaction_id' => 'integer', 'CompInvestors.comp_transaction_id' => 'integer', 'CompInvestors__comp_tran_investor_id' => 'integer', 'CompInvestors.comp_tran_investor_id' => 'integer', 'comp_tran_investor_id' => 'integer', 'CompInvestors__comp_tran_investor_type' => 'integer', 'CompInvestors.comp_tran_investor_type' => 'integer', 'comp_tran_investor_type' => 'integer', 'CompInvestors__comp_investment_amount' => 'string', 'CompInvestors.comp_investment_amount' => 'string', 'comp_investment_amount' => 'string', 'CompInvestors__comp_investment_stake' => 'string', 'CompInvestors.comp_investment_stake' => 'string', 'comp_investment_stake' => 'string', 'CompInvestors__comp_investment_currency_id' => 'integer', 'CompInvestors.comp_investment_currency_id' => 'integer', 'comp_investment_currency_id' => 'integer', 'CompInvestors__comp_investment_position' => 'string', 'CompInvestors.comp_investment_position' => 'string', 'comp_investment_position' => 'string', 'CompInvestors__comp_investment_inv_ann_dt' => 'datetime', 'CompInvestors.comp_investment_inv_ann_dt' => 'datetime', 'comp_investment_inv_ann_dt' => 'datetime', 'CompInvestors__comp_investment_inv_cl_dt' => 'datetime', 'CompInvestors.comp_investment_inv_cl_dt' => 'datetime', 'comp_investment_inv_cl_dt' => 'datetime', 'CompInvestors__comp_investment_exit_ann_dt' => 'datetime', 'CompInvestors.comp_investment_exit_ann_dt' => 'datetime', 'comp_investment_exit_ann_dt' => 'datetime', 'CompInvestors__comp_investment_exit_cl_dt' => 'datetime', 'CompInvestors.comp_investment_exit_cl_dt' => 'datetime', 'comp_investment_exit_cl_dt' => 'datetime', 'CompInvestors__comp_investment_acqui_type_id' => 'integer', 'CompInvestors.comp_investment_acqui_type_id' => 'integer', 'comp_investment_acqui_type_id' => 'integer', 'CompInvestors__comp_investment_exit_type_id' => 'integer', 'CompInvestors.comp_investment_exit_type_id' => 'integer', 'comp_investment_exit_type_id' => 'integer', 'CompInvestors__comp_invst_inv_ann_pr_link' => 'string', 'CompInvestors.comp_invst_inv_ann_pr_link' => 'string', 'comp_invst_inv_ann_pr_link' => 'string', 'CompInvestors__comp_invst_inv_cl_pr_link' => 'string', 'CompInvestors.comp_invst_inv_cl_pr_link' => 'string', 'comp_invst_inv_cl_pr_link' => 'string', 'CompInvestors__comp_invst_exit_ann_pr_link' => 'string', 'CompInvestors.comp_invst_exit_ann_pr_link' => 'string', 'comp_invst_exit_ann_pr_link' => 'string', 'CompInvestors__comp_invst_exit_closed_pr_link' => 'string', 'CompInvestors.comp_invst_exit_closed_pr_link' => 'string', 'comp_invst_exit_closed_pr_link' => 'string', 'InvestorProfessionals__professional_id' => 'integer', 'InvestorProfessionals.professional_id' => 'integer', 'InvestorProfessionals__professional_company_id' => 'integer', 'InvestorProfessionals.professional_company_id' => 'integer', 'InvestorProfessionals__professional_company_type' => 'integer', 'InvestorProfessionals.professional_company_type' => 'integer', 'InvestorProfessionals__prof_name' => 'string', 'InvestorProfessionals.prof_name' => 'string', 'InvestorProfessionals__prof_email' => 'string', 'InvestorProfessionals.prof_email' => 'string', 'InvestorProfessionals__prof_designation' => 'string', 'InvestorProfessionals.prof_designation' => 'string', 'InvestorProfessionals__prof_join_dt' => 'integer', 'InvestorProfessionals.prof_join_dt' => 'integer', 'InvestorProfessionals__prof_bio' => 'text', 'InvestorProfessionals.prof_bio' => 'text', 'InvestorProfessionals__prof_phone_number' => 'string', 'InvestorProfessionals.prof_phone_number' => 'string', 'InvestorProfessionals__prof_fax' => 'string', 'InvestorProfessionals.prof_fax' => 'string', 'InvestorProfessionals__prof_rank' => 'integer', 'InvestorProfessionals.prof_rank' => 'integer', 'InvestorProfessionals__prof_board_seat' => 'integer', 'InvestorProfessionals.prof_board_seat' => 'integer', 'InvestorProfessionals__prof_office_id' => 'integer', 'InvestorProfessionals.prof_office_id' => 'integer', 'InvestorProfessionals__prof_function' => 'string', 'InvestorProfessionals.prof_function' => 'string', 'InvestorProfessionals__prof_last_updated' => 'datetime', 'InvestorProfessionals.prof_last_updated' => 'datetime', 'InvestorProfessionals__admin_profile_date' => 'datetime', 'InvestorProfessionals.admin_profile_date' => 'datetime', 'InvestorProfessionals__profile_image' => 'text', 'InvestorProfessionals.profile_image' => 'text', 'InvestorProfessionals__profile_keywords' => 'text', 'InvestorProfessionals.profile_keywords' => 'text', 'CompCompany__company_id' => 'integer', 'CompCompany.company_id' => 'integer', 'CompCompany__company_name' => 'string', 'CompCompany.company_name' => 'string', 'CompCompany__company_former_name_one' => 'string', 'CompCompany.company_former_name_one' => 'string', 'CompCompany__company_former_name_two' => 'string', 'CompCompany.company_former_name_two' => 'string', 'CompCompany__company_sector_id' => 'integer', 'CompCompany.company_sector_id' => 'integer', 'CompCompany__company_entity_type_id' => 'integer', 'CompCompany.company_entity_type_id' => 'integer', 'CompCompany__company_active_status' => 'integer', 'CompCompany.company_active_status' => 'integer', 'CompCompany__company_ceased_year' => 'integer', 'CompCompany.company_ceased_year' => 'integer', 'CompCompany__company_parent_id' => 'integer', 'CompCompany.company_parent_id' => 'integer', 'CompCompany__company_parent_type' => 'integer', 'CompCompany.company_parent_type' => 'integer', 'CompCompany__company_stock_exchange_id' => 'integer', 'CompCompany.company_stock_exchange_id' => 'integer', 'CompCompany__company_symbol' => 'string', 'CompCompany.company_symbol' => 'string', 'CompCompany__company_is_public' => 'integer', 'CompCompany.company_is_public' => 'integer', 'CompCompany__company_ipo_year' => 'integer', 'CompCompany.company_ipo_year' => 'integer', 'CompCompany__company_delisted_year' => 'integer', 'CompCompany.company_delisted_year' => 'integer', 'CompCompany__company_description' => 'text', 'CompCompany.company_description' => 'text', 'CompCompany__company_phone' => 'string', 'CompCompany.company_phone' => 'string', 'CompCompany__company_fax' => 'string', 'CompCompany.company_fax' => 'string', 'CompCompany__company_toll_free' => 'string', 'CompCompany.company_toll_free' => 'string', 'CompCompany__company_url' => 'string', 'CompCompany.company_url' => 'string', 'CompCompany__company_address' => 'string', 'CompCompany.company_address' => 'string', 'CompCompany__company_city' => 'string', 'CompCompany.company_city' => 'string', 'CompCompany__company_postal_code' => 'string', 'CompCompany.company_postal_code' => 'string', 'CompCompany__company_state_id' => 'integer', 'CompCompany.company_state_id' => 'integer', 'CompCompany__company_country_id' => 'integer', 'CompCompany.company_country_id' => 'integer', 'CompCompany__company_employees' => 'integer', 'CompCompany.company_employees' => 'integer', 'CompCompany__company_year_established' => 'integer', 'CompCompany.company_year_established' => 'integer', 'CompCompany__company_last_updated' => 'datetime', 'CompCompany.company_last_updated' => 'datetime', 'CompCompany__company_is_deleted' => 'integer', 'CompCompany.company_is_deleted' => 'integer', 'CompCompany__admin_profile_date' => 'datetime', 'CompCompany.admin_profile_date' => 'datetime', 'CompCompany__profile_image' => 'text', 'CompCompany.profile_image' => 'text', 'CompCompany__profile_keywords' => 'text', 'CompCompany.profile_keywords' => 'text', 'CompFirm__firm_id' => 'integer', 'CompFirm.firm_id' => 'integer', 'firm_id' => 'integer', 'CompFirm__firm_name' => 'string', 'CompFirm.firm_name' => 'string', 'firm_name' => 'string', 'CompFirm__firm_former_name' => 'string', 'CompFirm.firm_former_name' => 'string', 'firm_former_name' => 'string', 'CompFirm__firm_url' => 'string', 'CompFirm.firm_url' => 'string', 'firm_url' => 'string', 'CompFirm__firm_email' => 'string', 'CompFirm.firm_email' => 'string', 'firm_email' => 'string', 'CompFirm__firm_ownership_category_id' => 'integer', 'CompFirm.firm_ownership_category_id' => 'integer', 'firm_ownership_category_id' => 'integer', 'CompFirm__firm_funded' => 'integer', 'CompFirm.firm_funded' => 'integer', 'firm_funded' => 'integer', 'CompFirm__firm_size_id' => 'integer', 'CompFirm.firm_size_id' => 'integer', 'firm_size_id' => 'integer', 'CompFirm__firm_established_year' => 'integer', 'CompFirm.firm_established_year' => 'integer', 'firm_established_year' => 'integer', 'CompFirm__firm_inv_status' => 'integer', 'CompFirm.firm_inv_status' => 'integer', 'firm_inv_status' => 'integer', 'CompFirm__firm_visibility' => 'integer', 'CompFirm.firm_visibility' => 'integer', 'firm_visibility' => 'integer', 'CompFirm__firm_strategy_type' => 'string', 'CompFirm.firm_strategy_type' => 'string', 'firm_strategy_type' => 'string', 'CompFirm__firm_parent_id' => 'integer', 'CompFirm.firm_parent_id' => 'integer', 'firm_parent_id' => 'integer', 'CompFirm__firm_parent_type' => 'integer', 'CompFirm.firm_parent_type' => 'integer', 'firm_parent_type' => 'integer', 'CompFirm__firm_addln_offices' => 'integer', 'CompFirm.firm_addln_offices' => 'integer', 'firm_addln_offices' => 'integer', 'CompFirm__firm_hq_region_id' => 'integer', 'CompFirm.firm_hq_region_id' => 'integer', 'firm_hq_region_id' => 'integer', 'CompFirm__firm_aum' => 'string', 'CompFirm.firm_aum' => 'string', 'firm_aum' => 'string', 'CompFirm__firm_aum_currency_id' => 'integer', 'CompFirm.firm_aum_currency_id' => 'integer', 'firm_aum_currency_id' => 'integer', 'CompFirm__firm_comp_revenue_min' => 'integer', 'CompFirm.firm_comp_revenue_min' => 'integer', 'firm_comp_revenue_min' => 'integer', 'CompFirm__firm_comp_revenue_max' => 'integer', 'CompFirm.firm_comp_revenue_max' => 'integer', 'firm_comp_revenue_max' => 'integer', 'CompFirm__firm_comp_revenue_curr_id' => 'integer', 'CompFirm.firm_comp_revenue_curr_id' => 'integer', 'firm_comp_revenue_curr_id' => 'integer', 'CompFirm__firm_ebitda_min' => 'integer', 'CompFirm.firm_ebitda_min' => 'integer', 'firm_ebitda_min' => 'integer', 'CompFirm__firm_ebitda_max' => 'integer', 'CompFirm.firm_ebitda_max' => 'integer', 'firm_ebitda_max' => 'integer', 'CompFirm__firm_ebitda_curr_id' => 'integer', 'CompFirm.firm_ebitda_curr_id' => 'integer', 'firm_ebitda_curr_id' => 'integer', 'CompFirm__firm_inv_size_min' => 'integer', 'CompFirm.firm_inv_size_min' => 'integer', 'firm_inv_size_min' => 'integer', 'CompFirm__firm_inv_size_max' => 'integer', 'CompFirm.firm_inv_size_max' => 'integer', 'firm_inv_size_max' => 'integer', 'CompFirm__firm_inv_size_curr_id' => 'integer', 'CompFirm.firm_inv_size_curr_id' => 'integer', 'firm_inv_size_curr_id' => 'integer', 'CompFirm__firm_entr_value_min' => 'integer', 'CompFirm.firm_entr_value_min' => 'integer', 'firm_entr_value_min' => 'integer', 'CompFirm__firm_entr_value_max' => 'integer', 'CompFirm.firm_entr_value_max' => 'integer', 'firm_entr_value_max' => 'integer', 'CompFirm__firm_entr_value_curr_id' => 'integer', 'CompFirm.firm_entr_value_curr_id' => 'integer', 'firm_entr_value_curr_id' => 'integer', 'CompFirm__firm_description' => 'text', 'CompFirm.firm_description' => 'text', 'firm_description' => 'text', 'CompFirm__firm_last_updated' => 'datetime', 'CompFirm.firm_last_updated' => 'datetime', 'firm_last_updated' => 'datetime', 'CompFirm__professional_count' => 'integer', 'CompFirm.professional_count' => 'integer', 'professional_count' => 'integer', 'CompFirm__admin_profile_date' => 'datetime', 'CompFirm.admin_profile_date' => 'datetime', 'CompFirm__profile_image' => 'text', 'CompFirm.profile_image' => 'text', 'CompFirm__profile_keywords' => 'text', 'CompFirm.profile_keywords' => 'text', 'CompLFirm__lfirm_id' => 'integer', 'CompLFirm.lfirm_id' => 'integer', 'lfirm_id' => 'integer', 'CompLFirm__lfirm_name' => 'string', 'CompLFirm.lfirm_name' => 'string', 'lfirm_name' => 'string', 'CompLFirm__lfirm_former_name' => 'string', 'CompLFirm.lfirm_former_name' => 'string', 'lfirm_former_name' => 'string', 'CompLFirm__lfirm_url' => 'string', 'CompLFirm.lfirm_url' => 'string', 'lfirm_url' => 'string', 'CompLFirm__lfirm_email' => 'string', 'CompLFirm.lfirm_email' => 'string', 'lfirm_email' => 'string', 'CompLFirm__lfirm_description' => 'text', 'CompLFirm.lfirm_description' => 'text', 'lfirm_description' => 'text', 'CompLFirm__lfirm_ownership_category_id' => 'integer', 'CompLFirm.lfirm_ownership_category_id' => 'integer', 'lfirm_ownership_category_id' => 'integer', 'CompLFirm__lfirm_size_id' => 'integer', 'CompLFirm.lfirm_size_id' => 'integer', 'lfirm_size_id' => 'integer', 'CompLFirm__lfirm_established_year' => 'string', 'CompLFirm.lfirm_established_year' => 'string', 'lfirm_established_year' => 'string', 'CompLFirm__lfirm_inv_status' => 'integer', 'CompLFirm.lfirm_inv_status' => 'integer', 'lfirm_inv_status' => 'integer', 'CompLFirm__lfirm_visibility' => 'integer', 'CompLFirm.lfirm_visibility' => 'integer', 'lfirm_visibility' => 'integer', 'CompLFirm__lfirm_strategy_type' => 'integer', 'CompLFirm.lfirm_strategy_type' => 'integer', 'lfirm_strategy_type' => 'integer', 'CompLFirm__lfirm_parent_id' => 'integer', 'CompLFirm.lfirm_parent_id' => 'integer', 'lfirm_parent_id' => 'integer', 'CompLFirm__lfirm_parent_type' => 'integer', 'CompLFirm.lfirm_parent_type' => 'integer', 'lfirm_parent_type' => 'integer', 'CompLFirm__lfirm_addln_offices' => 'integer', 'CompLFirm.lfirm_addln_offices' => 'integer', 'lfirm_addln_offices' => 'integer', 'CompLFirm__lfirm_hq_region_id' => 'integer', 'CompLFirm.lfirm_hq_region_id' => 'integer', 'lfirm_hq_region_id' => 'integer', 'CompLFirm__lfirm_last_updated' => 'datetime', 'CompLFirm.lfirm_last_updated' => 'datetime', 'lfirm_last_updated' => 'datetime', 'CompLFirm__professional_count' => 'integer', 'CompLFirm.professional_count' => 'integer', 'CompLFirm__admin_profile_date' => 'datetime', 'CompLFirm.admin_profile_date' => 'datetime', 'CompLFirm__profile_image' => 'text', 'CompLFirm.profile_image' => 'text', 'CompLFirm__profile_keywords' => 'text', 'CompLFirm.profile_keywords' => 'text', 'CompIBank__ibank_id' => 'integer', 'CompIBank.ibank_id' => 'integer', 'ibank_id' => 'integer', 'CompIBank__ibank_name' => 'string', 'CompIBank.ibank_name' => 'string', 'ibank_name' => 'string', 'CompIBank__ibank_former_name' => 'string', 'CompIBank.ibank_former_name' => 'string', 'ibank_former_name' => 'string', 'CompIBank__ibank_url' => 'string', 'CompIBank.ibank_url' => 'string', 'ibank_url' => 'string', 'CompIBank__ibank_email' => 'string', 'CompIBank.ibank_email' => 'string', 'ibank_email' => 'string', 'CompIBank__ibank_description' => 'text', 'CompIBank.ibank_description' => 'text', 'ibank_description' => 'text', 'CompIBank__ibank_ownership_category_id' => 'integer', 'CompIBank.ibank_ownership_category_id' => 'integer', 'ibank_ownership_category_id' => 'integer', 'CompIBank__ibank_size_id' => 'integer', 'CompIBank.ibank_size_id' => 'integer', 'ibank_size_id' => 'integer', 'CompIBank__ibank_established_year' => 'string', 'CompIBank.ibank_established_year' => 'string', 'ibank_established_year' => 'string', 'CompIBank__ibank_inv_status' => 'integer', 'CompIBank.ibank_inv_status' => 'integer', 'ibank_inv_status' => 'integer', 'CompIBank__ibank_visibility' => 'integer', 'CompIBank.ibank_visibility' => 'integer', 'ibank_visibility' => 'integer', 'CompIBank__ibank_strategy_type' => 'integer', 'CompIBank.ibank_strategy_type' => 'integer', 'ibank_strategy_type' => 'integer', 'CompIBank__ibank_parent_id' => 'integer', 'CompIBank.ibank_parent_id' => 'integer', 'ibank_parent_id' => 'integer', 'CompIBank__ibank_parent_type' => 'integer', 'CompIBank.ibank_parent_type' => 'integer', 'ibank_parent_type' => 'integer', 'CompIBank__ibank_addln_offices' => 'integer', 'CompIBank.ibank_addln_offices' => 'integer', 'ibank_addln_offices' => 'integer', 'CompIBank__ibank_hq_region_id' => 'integer', 'CompIBank.ibank_hq_region_id' => 'integer', 'ibank_hq_region_id' => 'integer', 'CompIBank__ibank_last_updated' => 'datetime', 'CompIBank.ibank_last_updated' => 'datetime', 'ibank_last_updated' => 'datetime', 'CompIBank__professional_count' => 'integer', 'CompIBank.professional_count' => 'integer', 'CompIBank__admin_profile_date' => 'datetime', 'CompIBank.admin_profile_date' => 'datetime', 'CompIBank__profile_image' => 'text', 'CompIBank.profile_image' => 'text', 'CompIBank__profile_keywords' => 'text', 'CompIBank.profile_keywords' => 'text', 'CompProfessional__professional_id' => 'integer', 'CompProfessional.professional_id' => 'integer', 'CompProfessional__professional_company_id' => 'integer', 'CompProfessional.professional_company_id' => 'integer', 'CompProfessional__professional_company_type' => 'integer', 'CompProfessional.professional_company_type' => 'integer', 'CompProfessional__prof_name' => 'string', 'CompProfessional.prof_name' => 'string', 'CompProfessional__prof_email' => 'string', 'CompProfessional.prof_email' => 'string', 'CompProfessional__prof_designation' => 'string', 'CompProfessional.prof_designation' => 'string', 'CompProfessional__prof_join_dt' => 'integer', 'CompProfessional.prof_join_dt' => 'integer', 'CompProfessional__prof_bio' => 'text', 'CompProfessional.prof_bio' => 'text', 'CompProfessional__prof_phone_number' => 'string', 'CompProfessional.prof_phone_number' => 'string', 'CompProfessional__prof_fax' => 'string', 'CompProfessional.prof_fax' => 'string', 'CompProfessional__prof_rank' => 'integer', 'CompProfessional.prof_rank' => 'integer', 'CompProfessional__prof_board_seat' => 'integer', 'CompProfessional.prof_board_seat' => 'integer', 'CompProfessional__prof_office_id' => 'integer', 'CompProfessional.prof_office_id' => 'integer', 'CompProfessional__prof_function' => 'string', 'CompProfessional.prof_function' => 'string', 'CompProfessional__prof_last_updated' => 'datetime', 'CompProfessional.prof_last_updated' => 'datetime', 'CompProfessional__admin_profile_date' => 'datetime', 'CompProfessional.admin_profile_date' => 'datetime', 'CompProfessional__profile_image' => 'text', 'CompProfessional.profile_image' => 'text', 'CompProfessional__profile_keywords' => 'text', 'CompProfessional.profile_keywords' => 'text', 'InvestorCurrency__id' => 'integer', 'InvestorCurrency.id' => 'integer', 'InvestorCurrency__currency_name' => 'string', 'InvestorCurrency.currency_name' => 'string', 'InvestorCurrency__currency_rate' => 'float', 'InvestorCurrency.currency_rate' => 'float', 'Investments__comp_tran_inv_id' => 'integer', 'Investments.comp_tran_inv_id' => 'integer', 'Investments__comp_transaction_id' => 'integer', 'Investments.comp_transaction_id' => 'integer', 'Investments__comp_tran_investor_id' => 'integer', 'Investments.comp_tran_investor_id' => 'integer', 'Investments__comp_tran_investor_type' => 'integer', 'Investments.comp_tran_investor_type' => 'integer', 'Investments__comp_investment_amount' => 'string', 'Investments.comp_investment_amount' => 'string', 'Investments__comp_investment_stake' => 'string', 'Investments.comp_investment_stake' => 'string', 'Investments__comp_investment_currency_id' => 'integer', 'Investments.comp_investment_currency_id' => 'integer', 'Investments__comp_investment_position' => 'string', 'Investments.comp_investment_position' => 'string', 'Investments__comp_investment_inv_ann_dt' => 'datetime', 'Investments.comp_investment_inv_ann_dt' => 'datetime', 'Investments__comp_investment_inv_cl_dt' => 'datetime', 'Investments.comp_investment_inv_cl_dt' => 'datetime', 'Investments__comp_investment_exit_ann_dt' => 'datetime', 'Investments.comp_investment_exit_ann_dt' => 'datetime', 'Investments__comp_investment_exit_cl_dt' => 'datetime', 'Investments.comp_investment_exit_cl_dt' => 'datetime', 'Investments__comp_investment_acqui_type_id' => 'integer', 'Investments.comp_investment_acqui_type_id' => 'integer', 'Investments__comp_investment_exit_type_id' => 'integer', 'Investments.comp_investment_exit_type_id' => 'integer', 'Investments__comp_invst_inv_ann_pr_link' => 'string', 'Investments.comp_invst_inv_ann_pr_link' => 'string', 'Investments__comp_invst_inv_cl_pr_link' => 'string', 'Investments.comp_invst_inv_cl_pr_link' => 'string', 'Investments__comp_invst_exit_ann_pr_link' => 'string', 'Investments.comp_invst_exit_ann_pr_link' => 'string', 'Investments__comp_invst_exit_closed_pr_link' => 'string', 'Investments.comp_invst_exit_closed_pr_link' => 'string', 'InvestingCompTran__comp_transaction_id' => 'integer', 'InvestingCompTran.comp_transaction_id' => 'integer', 'InvestingCompTran__company_id' => 'integer', 'InvestingCompTran.company_id' => 'integer', 'InvestingCompTran__investment_announced_dt' => 'datetime', 'InvestingCompTran.investment_announced_dt' => 'datetime', 'InvestingCompTran__exit_announced_dt' => 'datetime', 'InvestingCompTran.exit_announced_dt' => 'datetime', 'InvestingCompTran__investment_closed_dt' => 'datetime', 'InvestingCompTran.investment_closed_dt' => 'datetime', 'InvestingCompTran__exit_closed_dt' => 'datetime', 'InvestingCompTran.exit_closed_dt' => 'datetime', 'InvestingCompTran__acquisition_type_id' => 'integer', 'InvestingCompTran.acquisition_type_id' => 'integer', 'InvestingCompTran__exit_type_id' => 'integer', 'InvestingCompTran.exit_type_id' => 'integer', 'InvestingCompTran__deal_value' => 'string', 'InvestingCompTran.deal_value' => 'string', 'InvestingCompTran__inv_currency_id' => 'integer', 'InvestingCompTran.inv_currency_id' => 'integer', 'InvestingCompTran__investment_revenue' => 'string', 'InvestingCompTran.investment_revenue' => 'string', 'InvestingCompTran__investment_ebitda' => 'string', 'InvestingCompTran.investment_ebitda' => 'string', 'InvestingCompTran__exit_value' => 'string', 'InvestingCompTran.exit_value' => 'string', 'InvestingCompTran__exit_currency_id' => 'integer', 'InvestingCompTran.exit_currency_id' => 'integer', 'InvestingCompTran__exit_revenue' => 'string', 'InvestingCompTran.exit_revenue' => 'string', 'InvestingCompTran__exit_ebitda' => 'string', 'InvestingCompTran.exit_ebitda' => 'string', 'InvestingCompTran__investment_annced_pr_link' => 'string', 'InvestingCompTran.investment_annced_pr_link' => 'string', 'InvestingCompTran__investment_closed_pr_link' => 'string', 'InvestingCompTran.investment_closed_pr_link' => 'string', 'InvestingCompTran__exit_annced_pr_link' => 'string', 'InvestingCompTran.exit_annced_pr_link' => 'string', 'InvestingCompTran__exit_closed_pr_link' => 'string', 'InvestingCompTran.exit_closed_pr_link' => 'string', 'InvestingCompTran__active_status' => 'integer', 'InvestingCompTran.active_status' => 'integer', 'InvestingCompTran__parent_tran_id' => 'integer', 'InvestingCompTran.parent_tran_id' => 'integer', 'InvestingCompTran__child_tran_id' => 'integer', 'InvestingCompTran.child_tran_id' => 'integer' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'Sector' => [[maximum depth reached]], 'Country' => [[maximum depth reached]], 'State' => [[maximum depth reached]], 'StockExchange' => [[maximum depth reached]], 'ProfileParent' => [[maximum depth reached]], 'CompanyProfessionals' => [ [maximum depth reached] ], 'CompTrans' => [ [maximum depth reached] ], 'Investments' => [ [maximum depth reached] ] ], 'matching' => [ 'CompTrans' => [ [maximum depth reached] ] ], 'extraOptions' => [], 'repository' => object(Admin\Model\Table\CompaniesTable) {} } $coteam = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Professionals.professional_id AS `Professionals__professional_id`, Professionals.professional_company_id AS `Professionals__professional_company_id`, Professionals.professional_company_type AS `Professionals__professional_company_type`, Professionals.prof_name AS `Professionals__prof_name`, Professionals.prof_email AS `Professionals__prof_email`, Professionals.prof_designation AS `Professionals__prof_designation`, Professionals.prof_join_dt AS `Professionals__prof_join_dt`, Professionals.prof_bio AS `Professionals__prof_bio`, Professionals.prof_phone_number AS `Professionals__prof_phone_number`, Professionals.prof_fax AS `Professionals__prof_fax`, Professionals.prof_rank AS `Professionals__prof_rank`, Professionals.prof_board_seat AS `Professionals__prof_board_seat`, Professionals.prof_office_id AS `Professionals__prof_office_id`, Professionals.prof_function AS `Professionals__prof_function`, Professionals.prof_last_updated AS `Professionals__prof_last_updated`, Professionals.admin_profile_date AS `Professionals__admin_profile_date`, Professionals.profile_image AS `Professionals__profile_image`, Professionals.profile_keywords AS `Professionals__profile_keywords`, WorkingCompany.company_id AS `WorkingCompany__company_id`, WorkingCompany.company_name AS `WorkingCompany__company_name`, WorkingCompany.company_former_name_one AS `WorkingCompany__company_former_name_one`, WorkingCompany.company_former_name_two AS `WorkingCompany__company_former_name_two`, WorkingCompany.company_sector_id AS `WorkingCompany__company_sector_id`, WorkingCompany.company_entity_type_id AS `WorkingCompany__company_entity_type_id`, WorkingCompany.company_active_status AS `WorkingCompany__company_active_status`, WorkingCompany.company_ceased_year AS `WorkingCompany__company_ceased_year`, WorkingCompany.company_parent_id AS `WorkingCompany__company_parent_id`, WorkingCompany.company_parent_type AS `WorkingCompany__company_parent_type`, WorkingCompany.company_stock_exchange_id AS `WorkingCompany__company_stock_exchange_id`, WorkingCompany.company_symbol AS `WorkingCompany__company_symbol`, WorkingCompany.company_is_public AS `WorkingCompany__company_is_public`, WorkingCompany.company_ipo_year AS `WorkingCompany__company_ipo_year`, WorkingCompany.company_delisted_year AS `WorkingCompany__company_delisted_year`, WorkingCompany.company_description AS `WorkingCompany__company_description`, WorkingCompany.company_phone AS `WorkingCompany__company_phone`, WorkingCompany.company_fax AS `WorkingCompany__company_fax`, WorkingCompany.company_toll_free AS `WorkingCompany__company_toll_free`, WorkingCompany.company_url AS `WorkingCompany__company_url`, WorkingCompany.company_address AS `WorkingCompany__company_address`, WorkingCompany.company_city AS `WorkingCompany__company_city`, WorkingCompany.company_postal_code AS `WorkingCompany__company_postal_code`, WorkingCompany.company_state_id AS `WorkingCompany__company_state_id`, WorkingCompany.company_country_id AS `WorkingCompany__company_country_id`, WorkingCompany.company_employees AS `WorkingCompany__company_employees`, WorkingCompany.company_year_established AS `WorkingCompany__company_year_established`, WorkingCompany.company_last_updated AS `WorkingCompany__company_last_updated`, WorkingCompany.company_is_deleted AS `WorkingCompany__company_is_deleted`, WorkingCompany.admin_profile_date AS `WorkingCompany__admin_profile_date`, WorkingCompany.profile_image AS `WorkingCompany__profile_image`, WorkingCompany.profile_keywords AS `WorkingCompany__profile_keywords`, WorkingFirm.firm_id AS `WorkingFirm__firm_id`, WorkingFirm.firm_name AS `WorkingFirm__firm_name`, WorkingFirm.firm_former_name AS `WorkingFirm__firm_former_name`, WorkingFirm.firm_url AS `WorkingFirm__firm_url`, WorkingFirm.firm_email AS `WorkingFirm__firm_email`, WorkingFirm.firm_ownership_category_id AS `WorkingFirm__firm_ownership_category_id`, WorkingFirm.firm_funded AS `WorkingFirm__firm_funded`, WorkingFirm.firm_size_id AS `WorkingFirm__firm_size_id`, WorkingFirm.firm_established_year AS `WorkingFirm__firm_established_year`, WorkingFirm.firm_inv_status AS `WorkingFirm__firm_inv_status`, WorkingFirm.firm_visibility AS `WorkingFirm__firm_visibility`, WorkingFirm.firm_strategy_type AS `WorkingFirm__firm_strategy_type`, WorkingFirm.firm_parent_id AS `WorkingFirm__firm_parent_id`, WorkingFirm.firm_parent_type AS `WorkingFirm__firm_parent_type`, WorkingFirm.firm_addln_offices AS `WorkingFirm__firm_addln_offices`, WorkingFirm.firm_hq_region_id AS `WorkingFirm__firm_hq_region_id`, WorkingFirm.firm_aum AS `WorkingFirm__firm_aum`, WorkingFirm.firm_aum_currency_id AS `WorkingFirm__firm_aum_currency_id`, WorkingFirm.firm_comp_revenue_min AS `WorkingFirm__firm_comp_revenue_min`, WorkingFirm.firm_comp_revenue_max AS `WorkingFirm__firm_comp_revenue_max`, WorkingFirm.firm_comp_revenue_curr_id AS `WorkingFirm__firm_comp_revenue_curr_id`, WorkingFirm.firm_ebitda_min AS `WorkingFirm__firm_ebitda_min`, WorkingFirm.firm_ebitda_max AS `WorkingFirm__firm_ebitda_max`, WorkingFirm.firm_ebitda_curr_id AS `WorkingFirm__firm_ebitda_curr_id`, WorkingFirm.firm_inv_size_min AS `WorkingFirm__firm_inv_size_min`, WorkingFirm.firm_inv_size_max AS `WorkingFirm__firm_inv_size_max`, WorkingFirm.firm_inv_size_curr_id AS `WorkingFirm__firm_inv_size_curr_id`, WorkingFirm.firm_entr_value_min AS `WorkingFirm__firm_entr_value_min`, WorkingFirm.firm_entr_value_max AS `WorkingFirm__firm_entr_value_max`, WorkingFirm.firm_entr_value_curr_id AS `WorkingFirm__firm_entr_value_curr_id`, WorkingFirm.firm_description AS `WorkingFirm__firm_description`, WorkingFirm.firm_last_updated AS `WorkingFirm__firm_last_updated`, WorkingFirm.professional_count AS `WorkingFirm__professional_count`, WorkingFirm.admin_profile_date AS `WorkingFirm__admin_profile_date`, WorkingFirm.profile_image AS `WorkingFirm__profile_image`, WorkingFirm.profile_keywords AS `WorkingFirm__profile_keywords`, WorkingIbank.ibank_id AS `WorkingIbank__ibank_id`, WorkingIbank.ibank_name AS `WorkingIbank__ibank_name`, WorkingIbank.ibank_former_name AS `WorkingIbank__ibank_former_name`, WorkingIbank.ibank_url AS `WorkingIbank__ibank_url`, WorkingIbank.ibank_email AS `WorkingIbank__ibank_email`, WorkingIbank.ibank_description AS `WorkingIbank__ibank_description`, WorkingIbank.ibank_ownership_category_id AS `WorkingIbank__ibank_ownership_category_id`, WorkingIbank.ibank_size_id AS `WorkingIbank__ibank_size_id`, WorkingIbank.ibank_established_year AS `WorkingIbank__ibank_established_year`, WorkingIbank.ibank_inv_status AS `WorkingIbank__ibank_inv_status`, WorkingIbank.ibank_visibility AS `WorkingIbank__ibank_visibility`, WorkingIbank.ibank_strategy_type AS `WorkingIbank__ibank_strategy_type`, WorkingIbank.ibank_parent_id AS `WorkingIbank__ibank_parent_id`, WorkingIbank.ibank_parent_type AS `WorkingIbank__ibank_parent_type`, WorkingIbank.ibank_addln_offices AS `WorkingIbank__ibank_addln_offices`, WorkingIbank.ibank_hq_region_id AS `WorkingIbank__ibank_hq_region_id`, WorkingIbank.ibank_last_updated AS `WorkingIbank__ibank_last_updated`, WorkingIbank.professional_count AS `WorkingIbank__professional_count`, WorkingIbank.admin_profile_date AS `WorkingIbank__admin_profile_date`, WorkingIbank.profile_image AS `WorkingIbank__profile_image`, WorkingIbank.profile_keywords AS `WorkingIbank__profile_keywords`, WorkingLfirm.lfirm_id AS `WorkingLfirm__lfirm_id`, WorkingLfirm.lfirm_name AS `WorkingLfirm__lfirm_name`, WorkingLfirm.lfirm_former_name AS `WorkingLfirm__lfirm_former_name`, WorkingLfirm.lfirm_url AS `WorkingLfirm__lfirm_url`, WorkingLfirm.lfirm_email AS `WorkingLfirm__lfirm_email`, WorkingLfirm.lfirm_description AS `WorkingLfirm__lfirm_description`, WorkingLfirm.lfirm_ownership_category_id AS `WorkingLfirm__lfirm_ownership_category_id`, WorkingLfirm.lfirm_size_id AS `WorkingLfirm__lfirm_size_id`, WorkingLfirm.lfirm_established_year AS `WorkingLfirm__lfirm_established_year`, WorkingLfirm.lfirm_inv_status AS `WorkingLfirm__lfirm_inv_status`, WorkingLfirm.lfirm_visibility AS `WorkingLfirm__lfirm_visibility`, WorkingLfirm.lfirm_strategy_type AS `WorkingLfirm__lfirm_strategy_type`, WorkingLfirm.lfirm_parent_id AS `WorkingLfirm__lfirm_parent_id`, WorkingLfirm.lfirm_parent_type AS `WorkingLfirm__lfirm_parent_type`, WorkingLfirm.lfirm_addln_offices AS `WorkingLfirm__lfirm_addln_offices`, WorkingLfirm.lfirm_hq_region_id AS `WorkingLfirm__lfirm_hq_region_id`, WorkingLfirm.lfirm_last_updated AS `WorkingLfirm__lfirm_last_updated`, WorkingLfirm.professional_count AS `WorkingLfirm__professional_count`, WorkingLfirm.admin_profile_date AS `WorkingLfirm__admin_profile_date`, WorkingLfirm.profile_image AS `WorkingLfirm__profile_image`, WorkingLfirm.profile_keywords AS `WorkingLfirm__profile_keywords`, ProfOffice.id AS `ProfOffice__id`, ProfOffice.addtln_name AS `ProfOffice__addtln_name`, ProfOffice.addtln_comp_id AS `ProfOffice__addtln_comp_id`, ProfOffice.addtln_comp_type AS `ProfOffice__addtln_comp_type`, ProfOffice.addtln_is_hq AS `ProfOffice__addtln_is_hq`, ProfOffice.addtln_name1 AS `ProfOffice__addtln_name1`, ProfOffice.addtln_zip AS `ProfOffice__addtln_zip`, ProfOffice.addtln_address AS `ProfOffice__addtln_address`, ProfOffice.addtln_fax AS `ProfOffice__addtln_fax`, ProfOffice.addtln_city AS `ProfOffice__addtln_city`, ProfOffice.addtln_state_id AS `ProfOffice__addtln_state_id`, ProfOffice.addtln_country_id AS `ProfOffice__addtln_country_id`, ProfOffice.addtln_phone AS `ProfOffice__addtln_phone`, ProfOffice.addtln_status AS `ProfOffice__addtln_status`, ProfOffice.addtln_create_dt AS `ProfOffice__addtln_create_dt`, ProfOffice.addtln_update_dt AS `ProfOffice__addtln_update_dt` FROM professionals Professionals LEFT JOIN companies WorkingCompany ON (professional_company_type = :c0 AND WorkingCompany.company_id = (Professionals.professional_company_id)) LEFT JOIN firms WorkingFirm ON (professional_company_type = :c1 AND WorkingFirm.firm_id = (Professionals.professional_company_id)) LEFT JOIN ibanks WorkingIbank ON (professional_company_type = :c2 AND WorkingIbank.ibank_id = (Professionals.professional_company_id)) LEFT JOIN l_firms WorkingLfirm ON (professional_company_type = :c3 AND WorkingLfirm.lfirm_id = (Professionals.professional_company_id)) LEFT JOIN additional_offices ProfOffice ON Professionals.prof_office_id = (ProfOffice.id) WHERE (professional_company_type = :c4 AND professional_company_id = :c5) ORDER BY rand(), prof_name ASC LIMIT 7', 'params' => [ ':c0' => [ [maximum depth reached] ], ':c1' => [ [maximum depth reached] ], ':c2' => [ [maximum depth reached] ], ':c3' => [ [maximum depth reached] ], ':c4' => [ [maximum depth reached] ], ':c5' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Professionals__professional_id' => 'integer', 'Professionals.professional_id' => 'integer', 'professional_id' => 'integer', 'Professionals__professional_company_id' => 'integer', 'Professionals.professional_company_id' => 'integer', 'professional_company_id' => 'integer', 'Professionals__professional_company_type' => 'integer', 'Professionals.professional_company_type' => 'integer', 'professional_company_type' => 'integer', 'Professionals__prof_name' => 'string', 'Professionals.prof_name' => 'string', 'prof_name' => 'string', 'Professionals__prof_email' => 'string', 'Professionals.prof_email' => 'string', 'prof_email' => 'string', 'Professionals__prof_designation' => 'string', 'Professionals.prof_designation' => 'string', 'prof_designation' => 'string', 'Professionals__prof_join_dt' => 'integer', 'Professionals.prof_join_dt' => 'integer', 'prof_join_dt' => 'integer', 'Professionals__prof_bio' => 'text', 'Professionals.prof_bio' => 'text', 'prof_bio' => 'text', 'Professionals__prof_phone_number' => 'string', 'Professionals.prof_phone_number' => 'string', 'prof_phone_number' => 'string', 'Professionals__prof_fax' => 'string', 'Professionals.prof_fax' => 'string', 'prof_fax' => 'string', 'Professionals__prof_rank' => 'integer', 'Professionals.prof_rank' => 'integer', 'prof_rank' => 'integer', 'Professionals__prof_board_seat' => 'integer', 'Professionals.prof_board_seat' => 'integer', 'prof_board_seat' => 'integer', 'Professionals__prof_office_id' => 'integer', 'Professionals.prof_office_id' => 'integer', 'prof_office_id' => 'integer', 'Professionals__prof_function' => 'string', 'Professionals.prof_function' => 'string', 'prof_function' => 'string', 'Professionals__prof_last_updated' => 'datetime', 'Professionals.prof_last_updated' => 'datetime', 'prof_last_updated' => 'datetime', 'Professionals__admin_profile_date' => 'datetime', 'Professionals.admin_profile_date' => 'datetime', 'admin_profile_date' => 'datetime', 'Professionals__profile_image' => 'text', 'Professionals.profile_image' => 'text', 'profile_image' => 'text', 'Professionals__profile_keywords' => 'text', 'Professionals.profile_keywords' => 'text', 'profile_keywords' => 'text', 'WorkingCompany__company_id' => 'integer', 'WorkingCompany.company_id' => 'integer', 'company_id' => 'integer', 'WorkingCompany__company_name' => 'string', 'WorkingCompany.company_name' => 'string', 'company_name' => 'string', 'WorkingCompany__company_former_name_one' => 'string', 'WorkingCompany.company_former_name_one' => 'string', 'company_former_name_one' => 'string', 'WorkingCompany__company_former_name_two' => 'string', 'WorkingCompany.company_former_name_two' => 'string', 'company_former_name_two' => 'string', 'WorkingCompany__company_sector_id' => 'integer', 'WorkingCompany.company_sector_id' => 'integer', 'company_sector_id' => 'integer', 'WorkingCompany__company_entity_type_id' => 'integer', 'WorkingCompany.company_entity_type_id' => 'integer', 'company_entity_type_id' => 'integer', 'WorkingCompany__company_active_status' => 'integer', 'WorkingCompany.company_active_status' => 'integer', 'company_active_status' => 'integer', 'WorkingCompany__company_ceased_year' => 'integer', 'WorkingCompany.company_ceased_year' => 'integer', 'company_ceased_year' => 'integer', 'WorkingCompany__company_parent_id' => 'integer', 'WorkingCompany.company_parent_id' => 'integer', 'company_parent_id' => 'integer', 'WorkingCompany__company_parent_type' => 'integer', 'WorkingCompany.company_parent_type' => 'integer', 'company_parent_type' => 'integer', 'WorkingCompany__company_stock_exchange_id' => 'integer', 'WorkingCompany.company_stock_exchange_id' => 'integer', 'company_stock_exchange_id' => 'integer', 'WorkingCompany__company_symbol' => 'string', 'WorkingCompany.company_symbol' => 'string', 'company_symbol' => 'string', 'WorkingCompany__company_is_public' => 'integer', 'WorkingCompany.company_is_public' => 'integer', 'company_is_public' => 'integer', 'WorkingCompany__company_ipo_year' => 'integer', 'WorkingCompany.company_ipo_year' => 'integer', 'company_ipo_year' => 'integer', 'WorkingCompany__company_delisted_year' => 'integer', 'WorkingCompany.company_delisted_year' => 'integer', 'company_delisted_year' => 'integer', 'WorkingCompany__company_description' => 'text', 'WorkingCompany.company_description' => 'text', 'company_description' => 'text', 'WorkingCompany__company_phone' => 'string', 'WorkingCompany.company_phone' => 'string', 'company_phone' => 'string', 'WorkingCompany__company_fax' => 'string', 'WorkingCompany.company_fax' => 'string', 'company_fax' => 'string', 'WorkingCompany__company_toll_free' => 'string', 'WorkingCompany.company_toll_free' => 'string', 'company_toll_free' => 'string', 'WorkingCompany__company_url' => 'string', 'WorkingCompany.company_url' => 'string', 'company_url' => 'string', 'WorkingCompany__company_address' => 'string', 'WorkingCompany.company_address' => 'string', 'company_address' => 'string', 'WorkingCompany__company_city' => 'string', 'WorkingCompany.company_city' => 'string', 'company_city' => 'string', 'WorkingCompany__company_postal_code' => 'string', 'WorkingCompany.company_postal_code' => 'string', 'company_postal_code' => 'string', 'WorkingCompany__company_state_id' => 'integer', 'WorkingCompany.company_state_id' => 'integer', 'company_state_id' => 'integer', 'WorkingCompany__company_country_id' => 'integer', 'WorkingCompany.company_country_id' => 'integer', 'company_country_id' => 'integer', 'WorkingCompany__company_employees' => 'integer', 'WorkingCompany.company_employees' => 'integer', 'company_employees' => 'integer', 'WorkingCompany__company_year_established' => 'integer', 'WorkingCompany.company_year_established' => 'integer', 'company_year_established' => 'integer', 'WorkingCompany__company_last_updated' => 'datetime', 'WorkingCompany.company_last_updated' => 'datetime', 'company_last_updated' => 'datetime', 'WorkingCompany__company_is_deleted' => 'integer', 'WorkingCompany.company_is_deleted' => 'integer', 'company_is_deleted' => 'integer', 'WorkingCompany__admin_profile_date' => 'datetime', 'WorkingCompany.admin_profile_date' => 'datetime', 'WorkingCompany__profile_image' => 'text', 'WorkingCompany.profile_image' => 'text', 'WorkingCompany__profile_keywords' => 'text', 'WorkingCompany.profile_keywords' => 'text', 'WorkingFirm__firm_id' => 'integer', 'WorkingFirm.firm_id' => 'integer', 'firm_id' => 'integer', 'WorkingFirm__firm_name' => 'string', 'WorkingFirm.firm_name' => 'string', 'firm_name' => 'string', 'WorkingFirm__firm_former_name' => 'string', 'WorkingFirm.firm_former_name' => 'string', 'firm_former_name' => 'string', 'WorkingFirm__firm_url' => 'string', 'WorkingFirm.firm_url' => 'string', 'firm_url' => 'string', 'WorkingFirm__firm_email' => 'string', 'WorkingFirm.firm_email' => 'string', 'firm_email' => 'string', 'WorkingFirm__firm_ownership_category_id' => 'integer', 'WorkingFirm.firm_ownership_category_id' => 'integer', 'firm_ownership_category_id' => 'integer', 'WorkingFirm__firm_funded' => 'integer', 'WorkingFirm.firm_funded' => 'integer', 'firm_funded' => 'integer', 'WorkingFirm__firm_size_id' => 'integer', 'WorkingFirm.firm_size_id' => 'integer', 'firm_size_id' => 'integer', 'WorkingFirm__firm_established_year' => 'integer', 'WorkingFirm.firm_established_year' => 'integer', 'firm_established_year' => 'integer', 'WorkingFirm__firm_inv_status' => 'integer', 'WorkingFirm.firm_inv_status' => 'integer', 'firm_inv_status' => 'integer', 'WorkingFirm__firm_visibility' => 'integer', 'WorkingFirm.firm_visibility' => 'integer', 'firm_visibility' => 'integer', 'WorkingFirm__firm_strategy_type' => 'string', 'WorkingFirm.firm_strategy_type' => 'string', 'firm_strategy_type' => 'string', 'WorkingFirm__firm_parent_id' => 'integer', 'WorkingFirm.firm_parent_id' => 'integer', 'firm_parent_id' => 'integer', 'WorkingFirm__firm_parent_type' => 'integer', 'WorkingFirm.firm_parent_type' => 'integer', 'firm_parent_type' => 'integer', 'WorkingFirm__firm_addln_offices' => 'integer', 'WorkingFirm.firm_addln_offices' => 'integer', 'firm_addln_offices' => 'integer', 'WorkingFirm__firm_hq_region_id' => 'integer', 'WorkingFirm.firm_hq_region_id' => 'integer', 'firm_hq_region_id' => 'integer', 'WorkingFirm__firm_aum' => 'string', 'WorkingFirm.firm_aum' => 'string', 'firm_aum' => 'string', 'WorkingFirm__firm_aum_currency_id' => 'integer', 'WorkingFirm.firm_aum_currency_id' => 'integer', 'firm_aum_currency_id' => 'integer', 'WorkingFirm__firm_comp_revenue_min' => 'integer', 'WorkingFirm.firm_comp_revenue_min' => 'integer', 'firm_comp_revenue_min' => 'integer', 'WorkingFirm__firm_comp_revenue_max' => 'integer', 'WorkingFirm.firm_comp_revenue_max' => 'integer', 'firm_comp_revenue_max' => 'integer', 'WorkingFirm__firm_comp_revenue_curr_id' => 'integer', 'WorkingFirm.firm_comp_revenue_curr_id' => 'integer', 'firm_comp_revenue_curr_id' => 'integer', 'WorkingFirm__firm_ebitda_min' => 'integer', 'WorkingFirm.firm_ebitda_min' => 'integer', 'firm_ebitda_min' => 'integer', 'WorkingFirm__firm_ebitda_max' => 'integer', 'WorkingFirm.firm_ebitda_max' => 'integer', 'firm_ebitda_max' => 'integer', 'WorkingFirm__firm_ebitda_curr_id' => 'integer', 'WorkingFirm.firm_ebitda_curr_id' => 'integer', 'firm_ebitda_curr_id' => 'integer', 'WorkingFirm__firm_inv_size_min' => 'integer', 'WorkingFirm.firm_inv_size_min' => 'integer', 'firm_inv_size_min' => 'integer', 'WorkingFirm__firm_inv_size_max' => 'integer', 'WorkingFirm.firm_inv_size_max' => 'integer', 'firm_inv_size_max' => 'integer', 'WorkingFirm__firm_inv_size_curr_id' => 'integer', 'WorkingFirm.firm_inv_size_curr_id' => 'integer', 'firm_inv_size_curr_id' => 'integer', 'WorkingFirm__firm_entr_value_min' => 'integer', 'WorkingFirm.firm_entr_value_min' => 'integer', 'firm_entr_value_min' => 'integer', 'WorkingFirm__firm_entr_value_max' => 'integer', 'WorkingFirm.firm_entr_value_max' => 'integer', 'firm_entr_value_max' => 'integer', 'WorkingFirm__firm_entr_value_curr_id' => 'integer', 'WorkingFirm.firm_entr_value_curr_id' => 'integer', 'firm_entr_value_curr_id' => 'integer', 'WorkingFirm__firm_description' => 'text', 'WorkingFirm.firm_description' => 'text', 'firm_description' => 'text', 'WorkingFirm__firm_last_updated' => 'datetime', 'WorkingFirm.firm_last_updated' => 'datetime', 'firm_last_updated' => 'datetime', 'WorkingFirm__professional_count' => 'integer', 'WorkingFirm.professional_count' => 'integer', 'professional_count' => 'integer', 'WorkingFirm__admin_profile_date' => 'datetime', 'WorkingFirm.admin_profile_date' => 'datetime', 'WorkingFirm__profile_image' => 'text', 'WorkingFirm.profile_image' => 'text', 'WorkingFirm__profile_keywords' => 'text', 'WorkingFirm.profile_keywords' => 'text', 'WorkingIbank__ibank_id' => 'integer', 'WorkingIbank.ibank_id' => 'integer', 'ibank_id' => 'integer', 'WorkingIbank__ibank_name' => 'string', 'WorkingIbank.ibank_name' => 'string', 'ibank_name' => 'string', 'WorkingIbank__ibank_former_name' => 'string', 'WorkingIbank.ibank_former_name' => 'string', 'ibank_former_name' => 'string', 'WorkingIbank__ibank_url' => 'string', 'WorkingIbank.ibank_url' => 'string', 'ibank_url' => 'string', 'WorkingIbank__ibank_email' => 'string', 'WorkingIbank.ibank_email' => 'string', 'ibank_email' => 'string', 'WorkingIbank__ibank_description' => 'text', 'WorkingIbank.ibank_description' => 'text', 'ibank_description' => 'text', 'WorkingIbank__ibank_ownership_category_id' => 'integer', 'WorkingIbank.ibank_ownership_category_id' => 'integer', 'ibank_ownership_category_id' => 'integer', 'WorkingIbank__ibank_size_id' => 'integer', 'WorkingIbank.ibank_size_id' => 'integer', 'ibank_size_id' => 'integer', 'WorkingIbank__ibank_established_year' => 'string', 'WorkingIbank.ibank_established_year' => 'string', 'ibank_established_year' => 'string', 'WorkingIbank__ibank_inv_status' => 'integer', 'WorkingIbank.ibank_inv_status' => 'integer', 'ibank_inv_status' => 'integer', 'WorkingIbank__ibank_visibility' => 'integer', 'WorkingIbank.ibank_visibility' => 'integer', 'ibank_visibility' => 'integer', 'WorkingIbank__ibank_strategy_type' => 'integer', 'WorkingIbank.ibank_strategy_type' => 'integer', 'ibank_strategy_type' => 'integer', 'WorkingIbank__ibank_parent_id' => 'integer', 'WorkingIbank.ibank_parent_id' => 'integer', 'ibank_parent_id' => 'integer', 'WorkingIbank__ibank_parent_type' => 'integer', 'WorkingIbank.ibank_parent_type' => 'integer', 'ibank_parent_type' => 'integer', 'WorkingIbank__ibank_addln_offices' => 'integer', 'WorkingIbank.ibank_addln_offices' => 'integer', 'ibank_addln_offices' => 'integer', 'WorkingIbank__ibank_hq_region_id' => 'integer', 'WorkingIbank.ibank_hq_region_id' => 'integer', 'ibank_hq_region_id' => 'integer', 'WorkingIbank__ibank_last_updated' => 'datetime', 'WorkingIbank.ibank_last_updated' => 'datetime', 'ibank_last_updated' => 'datetime', 'WorkingIbank__professional_count' => 'integer', 'WorkingIbank.professional_count' => 'integer', 'WorkingIbank__admin_profile_date' => 'datetime', 'WorkingIbank.admin_profile_date' => 'datetime', 'WorkingIbank__profile_image' => 'text', 'WorkingIbank.profile_image' => 'text', 'WorkingIbank__profile_keywords' => 'text', 'WorkingIbank.profile_keywords' => 'text', 'WorkingLfirm__lfirm_id' => 'integer', 'WorkingLfirm.lfirm_id' => 'integer', 'lfirm_id' => 'integer', 'WorkingLfirm__lfirm_name' => 'string', 'WorkingLfirm.lfirm_name' => 'string', 'lfirm_name' => 'string', 'WorkingLfirm__lfirm_former_name' => 'string', 'WorkingLfirm.lfirm_former_name' => 'string', 'lfirm_former_name' => 'string', 'WorkingLfirm__lfirm_url' => 'string', 'WorkingLfirm.lfirm_url' => 'string', 'lfirm_url' => 'string', 'WorkingLfirm__lfirm_email' => 'string', 'WorkingLfirm.lfirm_email' => 'string', 'lfirm_email' => 'string', 'WorkingLfirm__lfirm_description' => 'text', 'WorkingLfirm.lfirm_description' => 'text', 'lfirm_description' => 'text', 'WorkingLfirm__lfirm_ownership_category_id' => 'integer', 'WorkingLfirm.lfirm_ownership_category_id' => 'integer', 'lfirm_ownership_category_id' => 'integer', 'WorkingLfirm__lfirm_size_id' => 'integer', 'WorkingLfirm.lfirm_size_id' => 'integer', 'lfirm_size_id' => 'integer', 'WorkingLfirm__lfirm_established_year' => 'string', 'WorkingLfirm.lfirm_established_year' => 'string', 'lfirm_established_year' => 'string', 'WorkingLfirm__lfirm_inv_status' => 'integer', 'WorkingLfirm.lfirm_inv_status' => 'integer', 'lfirm_inv_status' => 'integer', 'WorkingLfirm__lfirm_visibility' => 'integer', 'WorkingLfirm.lfirm_visibility' => 'integer', 'lfirm_visibility' => 'integer', 'WorkingLfirm__lfirm_strategy_type' => 'integer', 'WorkingLfirm.lfirm_strategy_type' => 'integer', 'lfirm_strategy_type' => 'integer', 'WorkingLfirm__lfirm_parent_id' => 'integer', 'WorkingLfirm.lfirm_parent_id' => 'integer', 'lfirm_parent_id' => 'integer', 'WorkingLfirm__lfirm_parent_type' => 'integer', 'WorkingLfirm.lfirm_parent_type' => 'integer', 'lfirm_parent_type' => 'integer', 'WorkingLfirm__lfirm_addln_offices' => 'integer', 'WorkingLfirm.lfirm_addln_offices' => 'integer', 'lfirm_addln_offices' => 'integer', 'WorkingLfirm__lfirm_hq_region_id' => 'integer', 'WorkingLfirm.lfirm_hq_region_id' => 'integer', 'lfirm_hq_region_id' => 'integer', 'WorkingLfirm__lfirm_last_updated' => 'datetime', 'WorkingLfirm.lfirm_last_updated' => 'datetime', 'lfirm_last_updated' => 'datetime', 'WorkingLfirm__professional_count' => 'integer', 'WorkingLfirm.professional_count' => 'integer', 'WorkingLfirm__admin_profile_date' => 'datetime', 'WorkingLfirm.admin_profile_date' => 'datetime', 'WorkingLfirm__profile_image' => 'text', 'WorkingLfirm.profile_image' => 'text', 'WorkingLfirm__profile_keywords' => 'text', 'WorkingLfirm.profile_keywords' => 'text', 'ProfOffice__id' => 'integer', 'ProfOffice.id' => 'integer', 'id' => 'integer', 'ProfOffice__addtln_name' => 'string', 'ProfOffice.addtln_name' => 'string', 'addtln_name' => 'string', 'ProfOffice__addtln_comp_id' => 'integer', 'ProfOffice.addtln_comp_id' => 'integer', 'addtln_comp_id' => 'integer', 'ProfOffice__addtln_comp_type' => 'integer', 'ProfOffice.addtln_comp_type' => 'integer', 'addtln_comp_type' => 'integer', 'ProfOffice__addtln_is_hq' => 'integer', 'ProfOffice.addtln_is_hq' => 'integer', 'addtln_is_hq' => 'integer', 'ProfOffice__addtln_name1' => 'string', 'ProfOffice.addtln_name1' => 'string', 'addtln_name1' => 'string', 'ProfOffice__addtln_zip' => 'string', 'ProfOffice.addtln_zip' => 'string', 'addtln_zip' => 'string', 'ProfOffice__addtln_address' => 'string', 'ProfOffice.addtln_address' => 'string', 'addtln_address' => 'string', 'ProfOffice__addtln_fax' => 'string', 'ProfOffice.addtln_fax' => 'string', 'addtln_fax' => 'string', 'ProfOffice__addtln_city' => 'string', 'ProfOffice.addtln_city' => 'string', 'addtln_city' => 'string', 'ProfOffice__addtln_state_id' => 'integer', 'ProfOffice.addtln_state_id' => 'integer', 'addtln_state_id' => 'integer', 'ProfOffice__addtln_country_id' => 'integer', 'ProfOffice.addtln_country_id' => 'integer', 'addtln_country_id' => 'integer', 'ProfOffice__addtln_phone' => 'string', 'ProfOffice.addtln_phone' => 'string', 'addtln_phone' => 'string', 'ProfOffice__addtln_status' => 'integer', 'ProfOffice.addtln_status' => 'integer', 'addtln_status' => 'integer', 'ProfOffice__addtln_create_dt' => 'datetime', 'ProfOffice.addtln_create_dt' => 'datetime', 'addtln_create_dt' => 'datetime', 'ProfOffice__addtln_update_dt' => 'datetime', 'ProfOffice.addtln_update_dt' => 'datetime', 'addtln_update_dt' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'WorkingCompany' => [[maximum depth reached]], 'WorkingFirm' => [[maximum depth reached]], 'WorkingIbank' => [[maximum depth reached]], 'WorkingLfirm' => [[maximum depth reached]], 'ProfOffice' => [[maximum depth reached]] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(Admin\Model\Table\ProfessionalsTable) {} } $professionals = object(Admin\Model\Entity\Professional) { 'professional_id' => (int) 15052, 'professional_company_id' => (int) 688, 'professional_company_type' => (int) 2, 'prof_name' => 'Gary Shayne', 'prof_email' => '', 'prof_designation' => 'Founder', 'prof_join_dt' => (int) 2007, 'prof_bio' => 'As founder of Cambridge Capital, Gary has been involved in all phases of the firm’s development since its founding in late 2007 and is responsible for the overall strategy and management of the company. Gary co-founded Ascendis Health Limited in 2008 which has grown to become the second largest provider of health products in Africa, and co-founded Bounty Brands (Pty) Ltd in 2014 and Marlin Homeware (Pty) Ltd in 2016. He also serves on the board of a number of portfolio companies. Gary has a bold vision to grow Coast2Coast Capital into a leading global Investment company based on innovative ways of investing, seeking out opportunities in multiple sectors and building a global team of highly passionate, smart and experienced people. Gary’s passion for investing is a key driving force at Cambridge capital which has grown its on-balance sheet fund (currently at over USD700m) at a rate of over 80%/annum over the last 9 years and over 90%/annum over the last 3 years.Gary trained as a chartered accountant through KPMG and has a highly successful history in both entrepreneurial ventures and private equity. In his early 20’s he founded what went on to become one of the country’s largest independent accounting firms. In his late 20’s he established a telecommunications company, which was listed on the stock exchange and grew to become the largest service provider of mobile phone products in the country. Gary owned and ran a number of other businesses, including chemical manufacturing, bank IT outsourcing, internet tourism, and security printing before he ventured into private equity in his mid thirties.', 'prof_phone_number' => '', 'prof_fax' => '', 'prof_rank' => (int) 1, 'prof_board_seat' => null, 'prof_office_id' => (int) 715, 'prof_function' => 'Investment', 'prof_last_updated' => object(Cake\I18n\FrozenTime) {}, 'admin_profile_date' => null, 'profile_image' => 'Professionals2018-08-13-07-24-55.PNG', 'profile_keywords' => 'Gary Shayne', 'prof_office' => object(Admin\Model\Entity\AdditionalOffice) {}, 'professional_sectors' => [], 'working_lfirm' => null, 'working_ibank' => null, 'working_firm' => object(Admin\Model\Entity\Firm) {}, 'working_company' => null, '[new]' => false, '[accessible]' => [ '*' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[invalid]' => [], '[repository]' => 'Admin.Professionals' } $layoutTitle = 'Gary Shayne' $layoutKeywords = 'Gary Shayne' $layoutDescription = 'As founder of Cambridge Capital, Gary has been involved in all phases of the firm’s development since its founding in late 2007 and is responsible for the overall strategy and management of the company. Gary co-founded Ascendis Health Limited in 2008 which has grown to become the second largest provider of health products in Africa, and co-founded Bounty Brands (Pty) Ltd in 2014 and Marlin Homeware (Pty) Ltd in 2016. He also serves on the board of a number of portfolio companies. Gary has a bold vision to grow Coast2Coast Capital into a leading global Investment company based on innovative ways of investing, seeking out opportunities in multiple sectors and building a global team of highly passionate, smart and experienced people. Gary’s passion for investing is a key driving force at Cambridge capital which has grown its on-balance sheet fund (currently at over USD700m) at a rate of over 80%/annum over the last 9 years and over 90%/annum over the last 3 years.Gary trained as a chartered accountant through KPMG and has a highly successful history in both entrepreneurial ventures and private equity. In his early 20’s he founded what went on to become one of the country’s largest independent accounting firms. In his late 20’s he established a telecommunications company, which was listed on the stock exchange and grew to become the largest service provider of mobile phone products in the country. Gary owned and ran a number of other businesses, including chemical manufacturing, bank IT outsourcing, internet tourism, and security printing before he ventured into private equity in his mid thirties.' $currWorkingCntrllrName = 'Firms' $currWorkingId = (int) 688 $WorkingName = 'Cambridge Capital (Pty) Ltd.' $ProfessionalEducationalQualsList = object(Admin\Model\Entity\ProfessionalEducationalQual) { 'id' => (int) 56, 'professional_id' => (int) 15052, 'prof_univ_id' => null, 'prof_degree' => 'Chartered Accountant', 'prof_field' => '', 'university' => null, '[new]' => false, '[accessible]' => [ '*' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[invalid]' => [], '[repository]' => 'Admin.ProfessionalEducationalQuals' } $key = (int) 0include - APP/Template/Professionals/profile.ctp, line 220 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 992 Cake\View\View::_render() - CORE/src/View/View.php, line 952 Cake\View\View::render() - CORE/src/View/View.php, line 587 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 611 Cake\Routing\Dispatcher::_invoke() - CORE/src/Routing/Dispatcher.php, line 120 Cake\Routing\Dispatcher::dispatch() - CORE/src/Routing/Dispatcher.php, line 87 [main] - ROOT/webroot/index.php, line 37