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

Companies

Companies

Displaying 1..10 of 59 - per page Next page
Order by
Specialty pharmaceutical and drug delivery company engaged in the research and manufacture of collagen-based technologies for local drug delivery, surgical implants, advanced wound care and oncology. More
NYCOMED Regional Business Development, new; near to market presciption drugs for region Northern Europe More
Ferndale Laboratories is dedicated to discovering, developing and delivering unique, branded pharmaceuticals that provide therapeutic dermatology solutions to the under-served medical specialties. More
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
Technology Marketing and Licensing for The University of Nebraska Medical Center More
Eloquestâ„¢ Healthcare, Inc. is a dermatology specialty company promoting a unique product portfolio designed to improve dermal outcomes within the hospital environment. More
Patented resin technology for the improvement of the delivery of topical medications to the skin. More
Medical School - Teaching Hospital - Research Institution More
Inven2 AS identifies, protects and commercialises inventions and discoveries of the University of Oslo, Oslo University Hospital and other health enterprises in the south-east of Norway. More
CrystecPharma applies the latest supercritical fluid (SCF) technologies to improve the design and performance of medicines More
Displaying 1..10 of 59 - per page Next page
Order by

Related Reports

© Copyright 1998-2012 Innovaro Europe Ltd Innovaro Corporation All rights reserved. Terms and Conditions | Contact us

(website) 48 queries took 800 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `company`272723
2DESCRIBE `condet`171745
3DESCRIBE `countrycode`445
4DESCRIBE `person`151535
5DESCRIBE `account`292918
6DESCRIBE `product_legacy`6665
7DESCRIBE `sales_people`663
8DESCRIBE `profile`1414225
9DESCRIBE `currencies`776
10DESCRIBE `update_rec`7724
11DESCRIBE `user`24246
12DESCRIBE `enquiry`14145
13DESCRIBE `module_types`6625
14DESCRIBE `dms_companies`262619
15DESCRIBE `dms_releases`101061
16DESCRIBE `dms_categories`445
17DESCRIBE `dms_clinical_areas`443
18DESCRIBE `dms_categories_dms_releases`225
19DESCRIBE `dms_clinical_areas_dms_releases`223
20DESCRIBE `dms_releases_sites`5519
21DESCRIBE `licopp`232311
22DESCRIBE `development_statuses`5524
23DESCRIBE `category`14144
24DESCRIBE `categories_sites`5513
25DESCRIBE `categorisation`884
26DESCRIBE `licopps_sites`3314
27DESCRIBE `service`151525
28DESCRIBE `press_release`13139
29DESCRIBE `press_releases_sites`5518
30DESCRIBE `story`12123
31DESCRIBE `sites_stories`5521
32DESCRIBE `story_assoc`443
33DESCRIBE `companies_sites`331
34DESCRIBE `categories_users`221
35DESCRIBE `authority`3316
36DESCRIBE `sites_users`553
37DESCRIBE `products`882
38DESCRIBE `sites`5513
39SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1111
40SELECT `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 11111
41SELECT `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 1111111
42SELECT `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` = 1476 ORDER BY `Category`.`name` ASC 14141
43SELECT `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 (1962, 1963, 1964, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1975, 1976) ORDER BY `name` ASC 002
44SELECT `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` = 1 ORDER BY `Category`.`name` ASC 881
45SELECT `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 (72, 46, 69, 212, 2, 119, 145, 244) ORDER BY `name` ASC 1871874
46SELECT c.lft, c.rgt FROM category c WHERE c.uid = 1476111
47SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "2779" AND c.rgt >= "2808" AND c.level > 1 ORDER BY c.level 111
48SELECT `TherapeuticTarget`.`lft`, `TherapeuticTarget`.`rgt`, `TherapeuticTarget`.`uid` FROM `category` AS `TherapeuticTarget` LEFT JOIN `category` AS `Parent` ON (`TherapeuticTarget`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `TherapeuticTarget`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `TherapeuticTarget`.`uid` = 1476 LIMIT 1112
(website_slave) 2 queries took 1347 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`summary`, `Company`.`is_customer` FROM `company` AS `Company` INNER JOIN categorisation AS `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Company`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'C') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '2779' AND `TherapeuticTarget`.`rgt` <= '2808') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`TherapeuticTarget`.`lft` >= 2779) AND (`TherapeuticTarget`.`rgt` <= 2808)) AND `Company`.`is_live` = 'Y' GROUP BY `Company`.`uid` ORDER BY `Company`.`is_customer` DESC, `Company`.`viewed_counter` DESC, `Company`.`name` ASC LIMIT 101010769
2SELECT COUNT(DISTINCT Company.uid) AS `count` FROM `company` AS `Company` INNER JOIN categorisation AS `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Company`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'C') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '2779' AND `TherapeuticTarget`.`rgt` <= '2808') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`TherapeuticTarget`.`lft` >= 2779) AND (`TherapeuticTarget`.`rgt` <= 2808)) AND `Company`.`is_live` = 'Y' 11578
(default) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)
(report) 1 query took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `reports`17171
(report_slave) 1 query took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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 ("Accident and Trauma") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Accident and Trauma") DESC , MarketResearchReport.published DESC LIMIT 1010101