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

Companies

Companies

Displaying 1..10 of 272 - per page Next page
Order by
Zambon Company SpA is a privately-held multinational pharmaceutical and chemical company that looks for in-licensing products in late stage development or already in the market.. More
Alliance pharmaceuticals is a dynamic UK pharmaceutical company with a successful acquisition and partnership track record More
Labtec GmbH provides innovative Product Development and Manufacturing Services all over the world. More
One of the leading manufacturer of Antihemorrhoidal and Female Health Care Products in Germany 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
One Nucleus is a membership organisation for international life science and healthcare companies, based in Cambridge and London UK, the heart of Europe’s largest life science cluster 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
Women's Reproductive Health Solutions More
DESMA PHARMA Group manufactures and markets proprietary, branded, ethical and OTC products in more than 40 countries worldwide and we constantly increase our business by acquisition of mature brands. More
Ramot at Tel Aviv University Ltd, is the technology transfer company of Tel Aviv University (TAU). More
Displaying 1..10 of 272 - 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 80 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `company`27271
2DESCRIBE `condet`17172
3DESCRIBE `countrycode`441
4DESCRIBE `person`15151
5DESCRIBE `account`29292
6DESCRIBE `product_legacy`662
7DESCRIBE `sales_people`661
8DESCRIBE `profile`14142
9DESCRIBE `currencies`771
10DESCRIBE `update_rec`771
11DESCRIBE `user`24241
12DESCRIBE `enquiry`14145
13DESCRIBE `module_types`661
14DESCRIBE `dms_companies`26263
15DESCRIBE `dms_releases`10103
16DESCRIBE `dms_categories`440
17DESCRIBE `dms_clinical_areas`441
18DESCRIBE `dms_categories_dms_releases`220
19DESCRIBE `dms_clinical_areas_dms_releases`220
20DESCRIBE `dms_releases_sites`551
21DESCRIBE `licopp`23231
22DESCRIBE `development_statuses`550
23DESCRIBE `category`14142
24DESCRIBE `categories_sites`550
25DESCRIBE `categorisation`880
26DESCRIBE `licopps_sites`330
27DESCRIBE `service`15151
28DESCRIBE `press_release`13131
29DESCRIBE `press_releases_sites`550
30DESCRIBE `story`12121
31DESCRIBE `sites_stories`550
32DESCRIBE `story_assoc`441
33DESCRIBE `companies_sites`3310
34DESCRIBE `categories_users`220
35DESCRIBE `authority`330
36DESCRIBE `sites_users`550
37DESCRIBE `products`889
38DESCRIBE `sites`551
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` = 631 ORDER BY `Category`.`name` ASC 660
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 (2123, 2124, 2126, 1583, 2122, 2125) ORDER BY `name` ASC 44440
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 883
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 1871871
46SELECT c.lft, c.rgt FROM category c WHERE c.uid = 6311111
47SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "3361" AND c.rgt >= "3462" 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` = 631 LIMIT 1115
(website_slave) 2 queries took 954 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` >= '3361' AND `TherapeuticTarget`.`rgt` <= '3462') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`TherapeuticTarget`.`lft` >= 3361) AND (`TherapeuticTarget`.`rgt` <= 3462)) AND `Company`.`is_live` = 'Y' GROUP BY `Company`.`uid` ORDER BY `Company`.`is_customer` DESC, `Company`.`viewed_counter` DESC, `Company`.`name` ASC LIMIT 101010362
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` >= '3361' AND `TherapeuticTarget`.`rgt` <= '3462') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`TherapeuticTarget`.`lft` >= 3361) AND (`TherapeuticTarget`.`rgt` <= 3462)) AND `Company`.`is_live` = 'Y' 11592
(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 2 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 ("Genito-urinary") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Genito-urinary") DESC , MarketResearchReport.published DESC LIMIT 1010102