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 5448 - per page Next page
Order by

Novartis Consumer Health, Inc.

Novartis Consumer Health is a world leader in self-medication products. The company welcomes the opportunity to review business opportunities for new products and technologies which bring innovations More

Alcon Research Ltd. a Novartis company

Alcon is the worldwide leader in the discovery, development and manufacture of innovative ophthalmic products and technologies. More

Ferndale Laboratories

Ferndale Laboratories is dedicated to discovering, developing and delivering unique, branded pharmaceuticals that provide therapeutic dermatology solutions to the under-served medical specialties. More

National Institutes of Health (NIH)

The NIH supports and conducts basic, clinical, and translational medical research, and investigates the causes, treatments, and cures for both common and rare diseases. More

EVOFEM Inc.

Women's Reproductive Health Solutions More

University of Nebraska Medical Center / UNeMed Corporation

Technology Marketing and Licensing for The University of Nebraska Medical Center More

Eloquest Healthcare, Inc.

Eloquest™ Healthcare, Inc. is a dermatology specialty company promoting a unique product portfolio designed to improve dermal outcomes within the hospital environment. More

Jaleva Pharmaceuticals LLC

Patented resin technology for the improvement of the delivery of topical medications to the skin. More

National Research Council Biotechnology Research Institute

NRC-BRI's Health and Bioprocess Sectors promote and conduct innovative collaborations, services and technology transfers with the biotechnology and pharmaceutical industries. More

Therapeutic Proteins Inc

Developer / supplier of biosimilar products More

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

Related Reports

Market Research Reports provided by reports.innovaro.com

Finmeccanica North America Inc.: SWOT Analysis & Company Profile

Feb 2011 - 16 pages - $99

QinetiQ North America, Inc.: SWOT Analysis & Company Profile

Feb 2011 - 15 pages - $99

Alenia North America Inc.: SWOT Analysis & Company Profile

Dec 2010 - 13 pages - $99

Nokia updates its approach to North America

Jun 2008 - 6 pages - $400

IP VPN Market Forecast in North America to 2016

Apr 2011 - 44 pages - $795

Excavators in North America to 2015: Market Databook

Nov 2011 - 20 pages - $500

Wealth Management Technology Spending in North America (Databook)

Aug 2007 - 16 pages - $1,295

Construction Tractors in North America to 2015: Market Databook

Nov 2011 - 21 pages - $500

Loaders in North America to 2015: Market Databook

Nov 2011 - 22 pages - $500

Confectionery in North America - Product Launch Quarterly

Oct 2010 - 333 pages - $1,295

Your selection

Geographic location: North America 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: Canada; USA

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

Products:

Partnering Search

Company Profiling

Pharmalicensing Intelligence

Intellectual Property

(website) 48 queries took 183 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `company`	27	27	1
2	DESCRIBE `condet`	17	17	6
3	DESCRIBE `countrycode`	4	4	4
4	DESCRIBE `person`	15	15	4
5	DESCRIBE `account`	29	29	5
6	DESCRIBE `product_legacy`	6	6	5
7	DESCRIBE `sales_people`	6	6	4
8	DESCRIBE `profile`	14	14	5
9	DESCRIBE `currencies`	7	7	2
10	DESCRIBE `update_rec`	7	7	3
11	DESCRIBE `user`	24	24	6
12	DESCRIBE `enquiry`	14	14	6
13	DESCRIBE `module_types`	6	6	4
14	DESCRIBE `dms_companies`	26	26	6
15	DESCRIBE `dms_releases`	10	10	8
16	DESCRIBE `dms_categories`	4	4	2
17	DESCRIBE `dms_clinical_areas`	4	4	2
18	DESCRIBE `dms_categories_dms_releases`	2	2	4
19	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	1
20	DESCRIBE `dms_releases_sites`	5	5	2
21	DESCRIBE `licopp`	23	23	18
22	DESCRIBE `development_statuses`	5	5	4
23	DESCRIBE `category`	14	14	1
24	DESCRIBE `categories_sites`	5	5	4
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	5
29	DESCRIBE `press_releases_sites`	5	5	21
30	DESCRIBE `story`	12	12	2
31	DESCRIBE `sites_stories`	5	5	1
32	DESCRIBE `story_assoc`	4	4	1
33	DESCRIBE `companies_sites`	3	3	1
34	DESCRIBE `categories_users`	2	2	1
35	DESCRIBE `authority`	3	3	1
36	DESCRIBE `sites_users`	5	5	2
37	DESCRIBE `products`	8	8	1
38	DESCRIBE `sites`	5	5	3
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	1
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	6
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	1
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	11
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	8
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` = 145 ORDER BY `Category`.`name` ASC	2	2	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 (198, 146) ORDER BY `name` ASC	64	64	2
46	SELECT c.lft, c.rgt FROM category c WHERE c.uid = 145	1	1	2
47	SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "2387" AND c.rgt >= "2520" AND c.level > 1 ORDER BY c.level	1	1	0
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` = 145 LIMIT 1	1	1	1

(website) 48 queries took 183 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 c.lft, c.rgt FROM category c WHERE c.uid = 145

SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "2387" AND c.rgt >= "2520" 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` = 145 LIMIT 1

(website_slave) 2 queries took 833 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` >= '2387' AND `GeographicLocation`.`rgt` <= '2520') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`GeographicLocation`.`lft` >= '2387') AND (`GeographicLocation`.`rgt` <= '2520')) 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	419
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` >= '2387' AND `GeographicLocation`.`rgt` <= '2520') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`GeographicLocation`.`lft` >= '2387') AND (`GeographicLocation`.`rgt` <= '2520')) AND `Company`.`is_live` = 'Y'		1	1	414

(website_slave) 2 queries took 833 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` >= '2387' AND `GeographicLocation`.`rgt` <= '2520') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`GeographicLocation`.`lft` >= '2387') AND (`GeographicLocation`.`rgt` <= '2520')) AND `Company`.`is_live` = 'Y' GROUP BY `Company`.`uid` ORDER BY `Company`.`is_customer` DESC, `Company`.`viewed_counter` DESC, `Company`.`name` ASC LIMIT 10

419

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` >= '2387' AND `GeographicLocation`.`rgt` <= '2520') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`GeographicLocation`.`lft` >= '2387') AND (`GeographicLocation`.`rgt` <= '2520')) AND `Company`.`is_live` = 'Y'

414

(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 13 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 ("North America") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("North America") DESC , MarketResearchReport.published DESC LIMIT 10		10	10	13

(report_slave) 1 query took 13 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 ("North America") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("North America") DESC , MarketResearchReport.published DESC LIMIT 10