RSS Feeds
Search

Out-licensing

Early stage controlled dose measuring device capable of delivering oral medications in any therapeutic area.

Innovaro Pharmalicensing
This newly developed dose measuring technology comprises of a thin foil that dissolves readily in the mouth thereby administering the exact dosage of certain medications.

Full description

Here at Innovaro Pharmalicensing we are looking to identify partner companies that can develop this oral dose technology further.

The technology offers an alternative option to current oral medications such as hard pills and capsules that are difficult to swallow; this makes its good option for either paediatric or geriatric medication. For best use the technology should be developed using a gelatine matrix that is easy to dissolve. The subsequent foils can be coloured and flavoured therefore making them more appealing for small children.

There is no therapeutic limitation to the technology; it can be used to incorporate medications that are either taken at regular intervals or in emergency doses.

 

Development status

Early Stage

Type of business relationship sought

The client is looking to out-license this technology or sell it completely, to any companies within the EU or the US with the appropriate capabilities.

Related reports

Market Research Reports provided by reports.innovaro.com
Company Financials: Depomed, Inc.
Jan 2010 - $75
Oral Herpes - Pipeline Review, Q4 2010
Nov 2010 - 50 pages - $500
Erosive Oral Lichen Planus - Pipeline Review, Q4 2010
Nov 2010 - 50 pages - $500
Leading Drug Delivery Companies and Technologies
Jun 2008 - 175 pages - $3,835
Drug Delivery Innovations Driving Improved Patient Compliance
Jul 2011 - 147 pages - $3,835
Oral Cancer - Pipeline Review, Q4 2010
Dec 2010 - 26 pages - $500
Innovations in Oral Solid Drug Delivery
Apr 2010 - 347 pages - $3,835
R&D Trends: HIV - An active pipeline faces fierce competition in the HIV market
Mar 2011 - 55 pages - $3,800
Premenstrual Syndrome - Pipeline Review, Q2 2011
May 2011 - 33 pages - $500
Lip And Oral Cavity Cancer - Pipeline Review, Q2 2011
Apr 2011 - 61 pages - $500
More Related Market Research Reports >>>

Clients in focus...

Get the Flash Player to see this rotator.

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

(website) 87 queries took 3292 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `licopp`23231
2DESCRIBE `company`27271
3DESCRIBE `condet`17178
4DESCRIBE `countrycode`441
5DESCRIBE `person`15151
6DESCRIBE `account`29291
7DESCRIBE `product_legacy`668
8DESCRIBE `sales_people`661
9DESCRIBE `profile`14141
10DESCRIBE `currencies`771
11DESCRIBE `update_rec`773
12DESCRIBE `user`24243
13DESCRIBE `enquiry`14142
14DESCRIBE `module_types`6615
15DESCRIBE `dms_companies`26267
16DESCRIBE `dms_releases`101017
17DESCRIBE `dms_categories`441
18DESCRIBE `dms_clinical_areas`441
19DESCRIBE `dms_categories_dms_releases`225
20DESCRIBE `dms_clinical_areas_dms_releases`223
21DESCRIBE `dms_releases_sites`555
22DESCRIBE `development_statuses`5521
23DESCRIBE `category`14142
24DESCRIBE `categories_sites`5517
25DESCRIBE `categorisation`881
26DESCRIBE `licopps_sites`331
27DESCRIBE `service`15151
28DESCRIBE `press_release`131326
29DESCRIBE `press_releases_sites`558
30DESCRIBE `story`12121
31DESCRIBE `sites_stories`554
32DESCRIBE `story_assoc`449
33DESCRIBE `companies_sites`335
34DESCRIBE `categories_users`223
35DESCRIBE `authority`331
36DESCRIBE `sites_users`557
37DESCRIBE `sites`551
38SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 2 LIMIT 1112
39SELECT `Outlicensing`.`uid`, `Outlicensing`.`slug`, `Outlicensing`.`company_id`, `Outlicensing`.`update_id`, `Outlicensing`.`title`, `Outlicensing`.`shortdesc`, `Outlicensing`.`mechanism`, `Outlicensing`.`body`, `Outlicensing`.`contact_id`, `Outlicensing`.`otherinfo`, `Outlicensing`.`patent`, `Outlicensing`.`change_time`, `Outlicensing`.`devstatus`, `Outlicensing`.`url`, `Outlicensing`.`flags`, `Outlicensing`.`is_anon`, `Outlicensing`.`is_out`, `Outlicensing`.`active`, `Outlicensing`.`viewed_counter`, `Outlicensing`.`created`, `Outlicensing`.`external_id`, `Outlicensing`.`md5`, `Outlicensing`.`patent_number`, `Person`.`uid`, `Person`.`salutation`, `Person`.`forename`, `Person`.`surname`, `Person`.`nickname`, `Person`.`postfix`, `Person`.`jobtitle`, `Person`.`company_id`, `Person`.`company_primary_contact`, `Person`.`department`, `Person`.`condet_id`, `Person`.`assistant_id`, `Person`.`notes_id`, `Person`.`user_id`, `Person`.`public`, `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name`, `DevelopmentStatus`.`display_order`, `DevelopmentStatus`.`created`, `DevelopmentStatus`.`modified`, `UpdateRecord`.`uid`, `UpdateRecord`.`created`, `UpdateRecord`.`last_change`, `UpdateRecord`.`last_changed_by`, `UpdateRecord`.`revision`, `UpdateRecord`.`change_credit`, `UpdateRecord`.`expiry`, `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`condet_id`, `Company`.`person_id`, `Company`.`billing_id`, `Company`.`parent`, `Company`.`has_children`, `Company`.`notes_id`, `Company`.`contact_status`, `Company`.`last_contacted`, `Company`.`profile_id`, `Company`.`account_id`, `Company`.`summary`, `Company`.`is_customer`, `Company`.`change_time`, `Company`.`flags`, `Company`.`is_anon`, `Company`.`is_resource`, `Company`.`satellite`, `Company`.`no_dms`, `Company`.`is_live`, `Company`.`viewed_counter`, `Company`.`created`, `Company`.`last_disabled`, `Company`.`no_trial`, `Company`.`trial_notification_sent`, `OutlicensingSite`.`id`, `OutlicensingSite`.`licopp_id`, `OutlicensingSite`.`site_id` FROM `licopp` AS `Outlicensing` LEFT JOIN `person` AS `Person` ON (`Outlicensing`.`contact_id` = `Person`.`uid`) LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Outlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `update_rec` AS `UpdateRecord` ON (`Outlicensing`.`update_id` = `UpdateRecord`.`uid`) LEFT JOIN `company` AS `Company` ON (`Outlicensing`.`company_id` = `Company`.`uid`) LEFT JOIN `licopps_sites` AS `OutlicensingSite` ON (`OutlicensingSite`.`licopp_id` = `Outlicensing`.`uid`) WHERE `OutlicensingSite`.`site_id` = 2 AND `Outlicensing`.`uid` = 19246 AND `Outlicensing`.`is_out` = 'Y' LIMIT 11115
40SELECT `Person`.`uid`, `Person`.`salutation`, `Person`.`forename`, `Person`.`surname`, `Person`.`nickname`, `Person`.`postfix`, `Person`.`jobtitle`, `Person`.`company_id`, `Person`.`company_primary_contact`, `Person`.`department`, `Person`.`condet_id`, `Person`.`assistant_id`, `Person`.`notes_id`, `Person`.`user_id`, `Person`.`public` FROM `person` AS `Person` WHERE `Person`.`uid` = 47739 111
41SELECT `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name`, `DevelopmentStatus`.`display_order`, `DevelopmentStatus`.`created`, `DevelopmentStatus`.`modified` FROM `development_statuses` AS `DevelopmentStatus` WHERE `DevelopmentStatus`.`id` = 9 113
42SELECT `UpdateRecord`.`uid`, `UpdateRecord`.`created`, `UpdateRecord`.`last_change`, `UpdateRecord`.`last_changed_by`, `UpdateRecord`.`revision`, `UpdateRecord`.`change_credit`, `UpdateRecord`.`expiry` FROM `update_rec` AS `UpdateRecord` WHERE `UpdateRecord`.`uid` = 8634 111
43SELECT `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`condet_id`, `Company`.`person_id`, `Company`.`billing_id`, `Company`.`parent`, `Company`.`has_children`, `Company`.`notes_id`, `Company`.`contact_status`, `Company`.`last_contacted`, `Company`.`profile_id`, `Company`.`account_id`, `Company`.`summary`, `Company`.`is_customer`, `Company`.`change_time`, `Company`.`flags`, `Company`.`is_anon`, `Company`.`is_resource`, `Company`.`satellite`, `Company`.`no_dms`, `Company`.`is_live`, `Company`.`viewed_counter`, `Company`.`created`, `Company`.`last_disabled`, `Company`.`no_trial`, `Company`.`trial_notification_sent` FROM `company` AS `Company` WHERE `Company`.`uid` = 1139 112
44SELECT `Contact`.`uid`, `Contact`.`address`, `Contact`.`street1`, `Contact`.`street2`, `Contact`.`city`, `Contact`.`district`, `Contact`.`postcode`, `Contact`.`telswitch`, `Contact`.`teldirect`, `Contact`.`cellphone`, `Contact`.`fax`, `Contact`.`faxdirect`, `Contact`.`email`, `Contact`.`url`, `Contact`.`country`, `Contact`.`office`, `Contact`.`company_id` FROM `condet` AS `Contact` WHERE `Contact`.`uid` = 1139 111
45SELECT `PrimaryContact`.`uid`, `PrimaryContact`.`salutation`, `PrimaryContact`.`forename`, `PrimaryContact`.`surname`, `PrimaryContact`.`nickname`, `PrimaryContact`.`postfix`, `PrimaryContact`.`jobtitle`, `PrimaryContact`.`company_id`, `PrimaryContact`.`company_primary_contact`, `PrimaryContact`.`department`, `PrimaryContact`.`condet_id`, `PrimaryContact`.`assistant_id`, `PrimaryContact`.`notes_id`, `PrimaryContact`.`user_id`, `PrimaryContact`.`public` FROM `person` AS `PrimaryContact` WHERE `PrimaryContact`.`company_primary_contact` = 1 AND `PrimaryContact`.`uid` = 30440 113
46SELECT `OutlicensingSite`.`id`, `OutlicensingSite`.`licopp_id`, `OutlicensingSite`.`site_id` FROM `licopps_sites` AS `OutlicensingSite` WHERE `OutlicensingSite`.`licopp_id` = 19246 228
47SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Categorisation`.`id`, `Categorisation`.`company_id`, `Categorisation`.`buysell`, `Categorisation`.`category_id`, `Categorisation`.`browse_category_id`, `Categorisation`.`cat_type`, `Categorisation`.`story_id`, `Categorisation`.`network_id` FROM `category` AS `Category` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`company_id` = 19246 AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC 13133
48SELECT `Category`.`uid`, `Category`.`name`, `Category`.`root` FROM `category` AS `Category` INNER JOIN categorisation AS `Categorisation` ON (`Categorisation`.`category_id` = `Category`.`uid`) 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` = 2 AND `cat_type` = 'L' AND `company_id` = '19246' ORDER BY `Category`.`name` ASC, `Category`.`level` ASC 13134
49SELECT `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, 582, 595, 319, 562, 332, 654, 320, 342, 2063, 298, 679, 333) ORDER BY `name` ASC 1211212
50SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 2 AND `Category`.`uid` = 1476 ORDER BY `par`.`lft` ASC 114
51SELECT `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` = (1476) ORDER BY `name` ASC 14141
52SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 2 AND `Category`.`uid` = 582 ORDER BY `par`.`lft` ASC 118
53SELECT `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` = (582) ORDER BY `name` ASC 10101
54SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 2 AND `Category`.`uid` = 595 ORDER BY `par`.`lft` ASC 117
55SELECT `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` = (595) ORDER BY `name` ASC 992
56SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 2 AND `Category`.`uid` = 319 ORDER BY `par`.`lft` ASC 116
57SELECT `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` = (319) ORDER BY `name` ASC 13135
58SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 2 AND `Category`.`uid` = 562 ORDER BY `par`.`lft` ASC 111
59SELECT `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` = (562) ORDER BY `name` ASC 771
60SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 2 AND `Category`.`uid` = 332 ORDER BY `par`.`lft` ASC 447
61SELECT `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` = (332) ORDER BY `name` ASC 002
62SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 2 AND `Category`.`uid` = 654 ORDER BY `par`.`lft` ASC 117
63SELECT `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` = (654) ORDER BY `name` ASC 24241
64SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 2 AND `Category`.`uid` = 320 ORDER BY `par`.`lft` ASC 227
65SELECT `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` = (320) ORDER BY `name` ASC 991
66SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 2 AND `Category`.`uid` = 342 ORDER BY `par`.`lft` ASC 3310
67SELECT `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` = (342) ORDER BY `name` ASC 002
68SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 2 AND `Category`.`uid` = 2063 ORDER BY `par`.`lft` ASC 221
69SELECT `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` = (2063) ORDER BY `name` ASC 001
70SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 2 AND `Category`.`uid` = 298 ORDER BY `par`.`lft` ASC 114
71SELECT `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` = (298) ORDER BY `name` ASC 666
72SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 2 AND `Category`.`uid` = 679 ORDER BY `par`.`lft` ASC 112
73SELECT `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` = (679) ORDER BY `name` ASC 29296
74SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 2 AND `Category`.`uid` = 333 ORDER BY `par`.`lft` ASC 444
75SELECT `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` = (333) ORDER BY `name` ASC 0011
76SELECT l.uid, l.slug, l.title, l.shortdesc, sum(c.level) AS score FROM licopp l INNER JOIN categorisation ctg ON ctg.company_id = l.uid AND ctg.cat_type = "L" INNER JOIN categorisation ctg2 ON ctg.category_id = ctg2.category_id AND ctg2.company_id = "19246" AND ctg2.cat_type = "L" INNER JOIN category c ON ctg.category_id = c.uid WHERE l.uid <> 19246 AND c.root = 560 GROUP BY l.uid, l.title, l.shortdesc ORDER BY score DESC, l.viewed_counter DESC LIMIT 5 552823
77SELECT Authority.user_id FROM authority AS Authority WHERE company_id = 1139 ORDER BY primary_user DESC1126
78SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 2 LIMIT 1118
79UPDATE licopp SET viewed_counter = viewed_counter + 1 WHERE uid = 19246 153
80SELECT `Outlicensing`.`company_id` FROM `licopp` AS `Outlicensing` LEFT JOIN `licopps_sites` AS `OutlicensingSite` ON (`OutlicensingSite`.`licopp_id` = `Outlicensing`.`uid`) WHERE `OutlicensingSite`.`site_id` = 2 AND `Outlicensing`.`uid` = 19246 LIMIT 1112
81DESCRIBE `statistics`773
82SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'outlicensing' LIMIT 1110
83SELECT `Statistic`.`id`, `Statistic`.`module_type_id`, `Statistic`.`company_id`, `Statistic`.`business_object_id`, `Statistic`.`count`, `Statistic`.`hit_date`, `Statistic`.`is_aggregated`, `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `statistics` AS `Statistic` LEFT JOIN `module_types` AS `ModuleType` ON (`Statistic`.`module_type_id` = `ModuleType`.`id`) WHERE `business_object_id` = '19246' AND `company_id` = 1139 AND `module_type_id` = '4' AND `hit_date` = '2012-02-23' LIMIT 1113
84SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 9972174 1118
85SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 9972174 117
86SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 9972174 111
87UPDATE `statistics` SET `id` = 9972174, `module_type_id` = '4', `company_id` = 1139, `business_object_id` = '19246', `count` = 4, `hit_date` = '2012-02-23', `is_aggregated` = 0 WHERE `statistics`.`id` = 997217411
(default) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)
(report) 2 queries took 5 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `reports`17171
2SELECT `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 ("Early stage controlled dose measuring device capable of delivering oral medications in any therapeutic area.") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Early stage controlled dose measuring device capable of delivering oral medications in any therapeutic area.") DESC , MarketResearchReport.published DESC LIMIT 1010104