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

Companies

Companies

Displaying 1..10 of 619 - per page Next page
Order by
KHIDI, provides various services on technology transfer. KHIDI will license and commercialise several technologies of KHIDI's client companies via collaboration with overseas partners. More
INNOPHARMAX is a specialty pharmaceutical company focused in the treatment of infectious diseases,immunology and oncology via DDS technology to improve safety & effectivene of currently available drug More
Discover MORE! Cerca Insights is a Malaysian based CRO focused on behavioural pharmacology More
Bonac Corporation of Japan is a research oriented company with a focus in nucleic acid chemistry. Bonac has developed a novel proprietary platform technology for RNAi. More
Lyka Labs Limited is one of the pioneers in the field of manufacturing of Pharmaceutical Formulations and Active Pharmaceuticals Ingredients (APIs) across various Therapeutic Segments More
Displaying 1..10 of 619 - 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 26 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `company`27271
2DESCRIBE `condet`17171
3DESCRIBE `countrycode`440
4DESCRIBE `person`15151
5DESCRIBE `account`29291
6DESCRIBE `product_legacy`661
7DESCRIBE `sales_people`660
8DESCRIBE `profile`14141
9DESCRIBE `currencies`771
10DESCRIBE `update_rec`771
11DESCRIBE `user`24241
12DESCRIBE `enquiry`14141
13DESCRIBE `module_types`660
14DESCRIBE `dms_companies`26261
15DESCRIBE `dms_releases`10101
16DESCRIBE `dms_categories`441
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`14141
24DESCRIBE `categories_sites`550
25DESCRIBE `categorisation`881
26DESCRIBE `licopps_sites`330
27DESCRIBE `service`15151
28DESCRIBE `press_release`13131
29DESCRIBE `press_releases_sites`551
30DESCRIBE `story`12121
31DESCRIBE `sites_stories`550
32DESCRIBE `story_assoc`440
33DESCRIBE `companies_sites`331
34DESCRIBE `categories_users`220
35DESCRIBE `authority`330
36DESCRIBE `sites_users`550
37DESCRIBE `products`881
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 1110
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 11110
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 1111110
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` = 560 ORDER BY `Category`.`name` ASC 20200
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 (1476, 561, 575, 582, 595, 603, 635, 616, 1477, 631, 641, 651, 562, 654, 662, 572, 1479, 670, 679, 689) ORDER BY `name` ASC 3163161
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` = 46 ORDER BY `Category`.`name` ASC 23230
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 (47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 704, 61, 62, 63, 64, 65, 66, 67, 68) ORDER BY `name` ASC 000
46SELECT c.lft, c.rgt FROM category c WHERE c.uid = 46110
47SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "2131" AND c.rgt >= "2178" AND c.level > 1 ORDER BY c.level 110
48SELECT `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` = 46 LIMIT 1110
(website_slave) 2 queries took 243 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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` >= '2131' AND `GeographicLocation`.`rgt` <= '2178') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`GeographicLocation`.`lft` >= '2131') AND (`GeographicLocation`.`rgt` <= '2178')) AND `Company`.`is_live` = 'Y' GROUP BY `Company`.`uid` ORDER BY `Company`.`is_customer` DESC, `Company`.`viewed_counter` DESC, `Company`.`name` ASC LIMIT 101010120
2SELECT 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` >= '2131' AND `GeographicLocation`.`rgt` <= '2178') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`GeographicLocation`.`lft` >= '2131') AND (`GeographicLocation`.`rgt` <= '2178')) AND `Company`.`is_live` = 'Y' 11123
(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 ("Asia") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Asia") DESC , MarketResearchReport.published DESC LIMIT 1010101