Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]

        if ($this->_init && !is_writable($this->settings['path'])) {
            $this->_init = false;
            trigger_error(sprintf(__('%s is not writable', true), $this->settings['path']), E_USER_WARNING);

FileEngine::__active() - CORE/cake/libs/cache/file.php, line 267
FileEngine::init() - CORE/cake/libs/cache/file.php, line 94
Cache::_buildEngine() - CORE/cake/libs/cache.php, line 151
Cache::config() - CORE/cake/libs/cache.php, line 126
include - /home/pharma/website/releases/20120317114903/cakephp/app/pharmalicensing/config/core.php, line 345
Configure::__loadBootstrap() - CORE/cake/libs/configure.php, line 391
Configure::getInstance() - CORE/cake/libs/configure.php, line 52
include - CORE/cake/bootstrap.php, line 38
[main] - /home/pharma/website/releases/20120317114903/cakephp/webroot/pharmalicensing/index.php, line 100

Companies

Companies
Browse

Companies

Displaying 1..10 of 41 - per page Next page
Order by

InnovUS

The Council for Scientific and Industrial Research (CSIR)

Biovax

BIOVAX is an Egyptian Joint Stock Company dedicated for providing the health care sectors with innovative, high quality and cost effective solutions to their unmet medical needs. More

APEX Pharma

Amoun Pharmaceutical

Alkan Pharma

Aspen Pharmacare Holdings

Pharmaplan Pty Ltd

South African pharmaceutical agency company More

EGD-PHARMA (Egyptian Group For Drug Trading)

Alliance Pharmaceuticals (South Africa)

Displaying 1..10 of 41 - per page Next page
Order by

Related Reports

Market Research Reports provided by reports.innovaro.com

SMEs in South Africa: highly mobile

Apr 2009 - 14 pages - $825

IP VPN Market Forecast in South Africa to 2016

Apr 2011 - 44 pages - $795

Insurance technology spending in South Africa to 2013

Jul 2009 - 32 pages - $895

Insurance Industry Technology Spending Forecast in South Africa to 2014

Jun 2010 - 53 pages - $995

IP VPN Market Forecast in Middle East and Africa to 2016

Apr 2011 - 44 pages - $795

Africa Oil To Acquire 100% Interest In Lion Energy: Africa Oil Will Consolidate Its Presence In East Africa – Deal Analysis From GlobalData

Mar 2011 - 10 pages - $500

Foodservice in South Africa to 2014

Jul 2011 - 45 pages - $495

Furniture and Floorcoverings Retailing in South Africa

May 2011 - 30 pages - $495

Tactical Trucks Market in Africa to 2021: Market Brief

Sep 2011 - 11 pages - $75

Financial Markets Technology Spending Forecast in South Africa to 2014

May 2010 - 70 pages - $995

Your selection

Geographic location: Africa del

Browse By

Industry sector: Academic/Research; Animal health; Biotechnology; Diagnostic; Drug delivery; Drug discovery; Medical device; Non-profit org./Government; Pharmaceutical; Research tools; Service
Therapeutic target: Accident and Trauma; Allergy; Blood and forming organs; Cardiovascular; Central Nervous System; Dermatological; Endocrinology; Gastrointestinal; Genetic disorders; Genito-urinary; Hospital and Surgery; Immune related disorders; Infectious diseases; Metabolism; Musculoskeletal; Oncology; Oral Health; Other therapeutic; Respiratory; Sensory organ
Geographic location: Algeria; Angola; Benin; Botswana; Burkina; Burundia; Cameroon; Cape Verde; Central African Republic; Chad; Congo; Djibouti; Egypt; Equatorial Guinea; Ethiopia; Gabon; Ghana; Guinea Bissau; Ivory Coast; Kenya; Lesotho; Liberia; Libya; Malawi; Mali; Mauritania; Morocco; Mozambique; Namibia; Niger; Nigeria; Rwanda; Sao Tome and Principe; Senegal; Sierra Leone; Somalia; South Africa; Sudan; Swaziland; Tanzania; The Gambia; Togo; Uganda; Zaire; Zambia; Zimbabwe

Products:	Partnering Search	Company Profiling	Pharmalicensing Intelligence	Reports	Comparision
In-licensing:	Latest records	Industry Sector	Therapeutic Target	Search	Profile your company	Pharma partnering
Out-licensing:	Latest records	Industry Sector	Therapeutic Target	Search	Profile your company	Pharma partnering
Companies:	Profiled companies	Industry Sector	Therapeutic Target	Geographic Location	Search	Add your company
Reports:	Biotechnology	Business Development	Management	Market & Sales	Medical Devices	Pharmaceuticals
News:	Deals & Alliances	Development	Financial Results	Financings	Intellectual Property	Regulatory
Events:	Pharma events	Calendar	Organizers	Featured events	Search
Articles:	Industrial Sector	Therapeutic Target	Articles date
Deals:	Industry Sector	Therapeutic Target	Deals Date	Search	Reports	Press releases
About us:	Our Audience	Case Studies	Newsletter	FAQ	Contact us	Site map

(website) 48 queries took 167 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `company`	27	27	2
2	DESCRIBE `condet`	17	17	2
3	DESCRIBE `countrycode`	4	4	1
4	DESCRIBE `person`	15	15	1
5	DESCRIBE `account`	29	29	1
6	DESCRIBE `product_legacy`	6	6	1
7	DESCRIBE `sales_people`	6	6	1
8	DESCRIBE `profile`	14	14	1
9	DESCRIBE `currencies`	7	7	1
10	DESCRIBE `update_rec`	7	7	1
11	DESCRIBE `user`	24	24	1
12	DESCRIBE `enquiry`	14	14	11
13	DESCRIBE `module_types`	6	6	1
14	DESCRIBE `dms_companies`	26	26	1
15	DESCRIBE `dms_releases`	10	10	1
16	DESCRIBE `dms_categories`	4	4	1
17	DESCRIBE `dms_clinical_areas`	4	4	1
18	DESCRIBE `dms_categories_dms_releases`	2	2	1
19	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	1
20	DESCRIBE `dms_releases_sites`	5	5	2
21	DESCRIBE `licopp`	23	23	2
22	DESCRIBE `development_statuses`	5	5	1
23	DESCRIBE `category`	14	14	1
24	DESCRIBE `categories_sites`	5	5	5
25	DESCRIBE `categorisation`	8	8	1
26	DESCRIBE `licopps_sites`	3	3	1
27	DESCRIBE `service`	15	15	1
28	DESCRIBE `press_release`	13	13	1
29	DESCRIBE `press_releases_sites`	5	5	6
30	DESCRIBE `story`	12	12	10
31	DESCRIBE `sites_stories`	5	5	9
32	DESCRIBE `story_assoc`	4	4	4
33	DESCRIBE `companies_sites`	3	3	8
34	DESCRIBE `categories_users`	2	2	4
35	DESCRIBE `authority`	3	3	10
36	DESCRIBE `sites_users`	5	5	4
37	DESCRIBE `products`	8	8	7
38	DESCRIBE `sites`	5	5	7
39	SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1	1	1	16
40	SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`parent` = 297 ORDER BY `Category`.`name` ASC	11	11	4
41	SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (527, 505, 303, 432, 319, 798, 453, 514, 298, 805, 534) ORDER BY `name` ASC	111	111	5
42	SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`parent` = 560 ORDER BY `Category`.`name` ASC	20	20	10
43	SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (1476, 561, 575, 582, 595, 603, 635, 616, 1477, 631, 641, 651, 562, 654, 662, 572, 1479, 670, 679, 689) ORDER BY `name` ASC	316	316	14
44	SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`parent` = 72 ORDER BY `Category`.`name` ASC	46	46	2
45	SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 89, 114, 115, 116, 118, 117) ORDER BY `name` ASC	0	0	0
46	SELECT c.lft, c.rgt FROM category c WHERE c.uid = 72	1	1	0
47	SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "2037" AND c.rgt >= "2130" AND c.level > 1 ORDER BY c.level	1	1	1
48	SELECT `Category`.`lft`, `Category`.`rgt`, `Category`.`uid` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`uid` = 72 LIMIT 1	1	1	0

(website) 48 queries took 167 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `company`

DESCRIBE `condet`

DESCRIBE `countrycode`

DESCRIBE `person`

DESCRIBE `account`

DESCRIBE `product_legacy`

DESCRIBE `sales_people`

DESCRIBE `profile`

DESCRIBE `currencies`

DESCRIBE `update_rec`

DESCRIBE `user`

DESCRIBE `enquiry`

DESCRIBE `module_types`

DESCRIBE `dms_companies`

DESCRIBE `dms_releases`

DESCRIBE `dms_categories`

DESCRIBE `dms_clinical_areas`

DESCRIBE `dms_categories_dms_releases`

DESCRIBE `dms_clinical_areas_dms_releases`

DESCRIBE `dms_releases_sites`

DESCRIBE `licopp`

DESCRIBE `development_statuses`

DESCRIBE `category`

DESCRIBE `categories_sites`

DESCRIBE `categorisation`

DESCRIBE `licopps_sites`

DESCRIBE `service`

DESCRIBE `press_release`

DESCRIBE `press_releases_sites`

DESCRIBE `story`

DESCRIBE `sites_stories`

DESCRIBE `story_assoc`

DESCRIBE `companies_sites`

DESCRIBE `categories_users`

DESCRIBE `authority`

DESCRIBE `sites_users`

DESCRIBE `products`

DESCRIBE `sites`

SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1

SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`parent` = 297 ORDER BY `Category`.`name` ASC

SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (527, 505, 303, 432, 319, 798, 453, 514, 298, 805, 534) ORDER BY `name` ASC

111

SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (1476, 561, 575, 582, 595, 603, 635, 616, 1477, 631, 641, 651, 562, 654, 662, 572, 1479, 670, 679, 689) ORDER BY `name` ASC

316

SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 89, 114, 115, 116, 118, 117) ORDER BY `name` ASC

SELECT c.lft, c.rgt FROM category c WHERE c.uid = 72

SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "2037" AND c.rgt >= "2130" AND c.level > 1 ORDER BY c.level

SELECT `Category`.`lft`, `Category`.`rgt`, `Category`.`uid` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`uid` = 72 LIMIT 1

(website_slave) 2 queries took 258 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`summary`, `Company`.`is_customer` FROM `company` AS `Company` INNER JOIN condet AS `ContactGeographicLocation` ON (`Company`.`condet_id` = `ContactGeographicLocation`.`uid`) INNER JOIN category AS `GeographicLocation` ON (`GeographicLocation`.`uid` = `ContactGeographicLocation`.`country` AND `GeographicLocation`.`lft` >= '2037' AND `GeographicLocation`.`rgt` <= '2130') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`GeographicLocation`.`lft` >= '2037') AND (`GeographicLocation`.`rgt` <= '2130')) AND `Company`.`is_live` = 'Y' GROUP BY `Company`.`uid` ORDER BY `Company`.`is_customer` DESC, `Company`.`viewed_counter` DESC, `Company`.`name` ASC LIMIT 10		10	10	130
2	SELECT COUNT(DISTINCT Company.uid) AS `count` FROM `company` AS `Company` INNER JOIN condet AS `ContactGeographicLocation` ON (`Company`.`condet_id` = `ContactGeographicLocation`.`uid`) INNER JOIN category AS `GeographicLocation` ON (`GeographicLocation`.`uid` = `ContactGeographicLocation`.`country` AND `GeographicLocation`.`lft` >= '2037' AND `GeographicLocation`.`rgt` <= '2130') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`GeographicLocation`.`lft` >= '2037') AND (`GeographicLocation`.`rgt` <= '2130')) AND `Company`.`is_live` = 'Y'		1	1	128

(website_slave) 2 queries took 258 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`summary`, `Company`.`is_customer` FROM `company` AS `Company` INNER JOIN condet AS `ContactGeographicLocation` ON (`Company`.`condet_id` = `ContactGeographicLocation`.`uid`) INNER JOIN category AS `GeographicLocation` ON (`GeographicLocation`.`uid` = `ContactGeographicLocation`.`country` AND `GeographicLocation`.`lft` >= '2037' AND `GeographicLocation`.`rgt` <= '2130') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`GeographicLocation`.`lft` >= '2037') AND (`GeographicLocation`.`rgt` <= '2130')) AND `Company`.`is_live` = 'Y' GROUP BY `Company`.`uid` ORDER BY `Company`.`is_customer` DESC, `Company`.`viewed_counter` DESC, `Company`.`name` ASC LIMIT 10

130

SELECT COUNT(DISTINCT Company.uid) AS `count` FROM `company` AS `Company` INNER JOIN condet AS `ContactGeographicLocation` ON (`Company`.`condet_id` = `ContactGeographicLocation`.`uid`) INNER JOIN category AS `GeographicLocation` ON (`GeographicLocation`.`uid` = `ContactGeographicLocation`.`country` AND `GeographicLocation`.`lft` >= '2037' AND `GeographicLocation`.`rgt` <= '2130') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`GeographicLocation`.`lft` >= '2037') AND (`GeographicLocation`.`rgt` <= '2130')) AND `Company`.`is_live` = 'Y'

128

(report) 1 query took 2 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `reports`		17	17	2

(report) 1 query took 2 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `reports`

(report_slave) 1 query took 9 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `MarketResearchReport`.`id`, `MarketResearchReport`.`slug`, `MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`, `MarketResearchReport`.`pages`, `MarketResearchReport`.`published`, `MarketResearchReport`.`net_price_usd`, `MarketResearchReport`.`active`, `MarketResearchReport`.`publisher_id`, `MarketResearchReport`.`views`, `MarketResearchReport`.`tags`, `MarketResearchReport`.`created`, `MarketResearchReport`.`modified` FROM `reports` AS `MarketResearchReport` WHERE `MarketResearchReport`.`active` = 1 AND MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Africa") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Africa") DESC , MarketResearchReport.published DESC LIMIT 10		10	10	9

(report_slave) 1 query took 9 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `MarketResearchReport`.`id`, `MarketResearchReport`.`slug`, `MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`, `MarketResearchReport`.`pages`, `MarketResearchReport`.`published`, `MarketResearchReport`.`net_price_usd`, `MarketResearchReport`.`active`, `MarketResearchReport`.`publisher_id`, `MarketResearchReport`.`views`, `MarketResearchReport`.`tags`, `MarketResearchReport`.`created`, `MarketResearchReport`.`modified` FROM `reports` AS `MarketResearchReport` WHERE `MarketResearchReport`.`active` = 1 AND MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Africa") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Africa") DESC , MarketResearchReport.published DESC LIMIT 10