Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Stay current with the latest press releases from within the industry.
Release issued 19th January 2012
Norgine and APR, together with its joint venture partner Labtec, today announced that they have entered into an exclusive licensing agreement under which Norgine has acquired the commercialization rights in Europe and selected non-European countries in Middle East, Africa and Australasia, of SetofilmTM the ondansetron orally dispersible film strip developed by APR and Labtec. Financial terms of the deal were not disclosed.If you want to find out more about the company visit Labtec GmbH profile.
(11th August 2011) Labtec joins the CPHI/ICSE and Bio-Europe
(25th May 2011) Labtec opens Europe’s most modern GMP manufacturing facility for transdermal patches and oral films
(4th March 2011) Due to expansion: Labtec seeks Director Business Development & Licensing
(3rd December 2010) APR Applied Pharma Research ("APR") and Labtec GmbH ("Labtec") Announce Filing for Approval in Europe of Zolmitriptan Oral Dispersible Film (ODF)
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `press_release` | 13 | 13 | 1 | |
| 2 | DESCRIBE `company` | 27 | 27 | 1 | |
| 3 | DESCRIBE `condet` | 17 | 17 | 1 | |
| 4 | DESCRIBE `countrycode` | 4 | 4 | 0 | |
| 5 | DESCRIBE `person` | 15 | 15 | 5 | |
| 6 | DESCRIBE `account` | 29 | 29 | 1 | |
| 7 | DESCRIBE `product_legacy` | 6 | 6 | 1 | |
| 8 | DESCRIBE `sales_people` | 6 | 6 | 1 | |
| 9 | DESCRIBE `profile` | 14 | 14 | 1 | |
| 10 | DESCRIBE `currencies` | 7 | 7 | 1 | |
| 11 | DESCRIBE `update_rec` | 7 | 7 | 1 | |
| 12 | DESCRIBE `user` | 24 | 24 | 1 | |
| 13 | DESCRIBE `enquiry` | 14 | 14 | 1 | |
| 14 | DESCRIBE `module_types` | 6 | 6 | 1 | |
| 15 | DESCRIBE `dms_companies` | 26 | 26 | 1 | |
| 16 | DESCRIBE `dms_releases` | 10 | 10 | 1 | |
| 17 | DESCRIBE `dms_categories` | 4 | 4 | 1 | |
| 18 | DESCRIBE `dms_clinical_areas` | 4 | 4 | 1 | |
| 19 | DESCRIBE `dms_categories_dms_releases` | 2 | 2 | 0 | |
| 20 | DESCRIBE `dms_clinical_areas_dms_releases` | 2 | 2 | 0 | |
| 21 | DESCRIBE `dms_releases_sites` | 5 | 5 | 1 | |
| 22 | DESCRIBE `licopp` | 23 | 23 | 1 | |
| 23 | DESCRIBE `development_statuses` | 5 | 5 | 1 | |
| 24 | DESCRIBE `category` | 14 | 14 | 1 | |
| 25 | DESCRIBE `categories_sites` | 5 | 5 | 1 | |
| 26 | DESCRIBE `categorisation` | 8 | 8 | 2 | |
| 27 | DESCRIBE `licopps_sites` | 3 | 3 | 1 | |
| 28 | DESCRIBE `service` | 15 | 15 | 1 | |
| 29 | DESCRIBE `story` | 12 | 12 | 1 | |
| 30 | DESCRIBE `sites_stories` | 5 | 5 | 0 | |
| 31 | DESCRIBE `story_assoc` | 4 | 4 | 1 | |
| 32 | DESCRIBE `companies_sites` | 3 | 3 | 0 | |
| 33 | DESCRIBE `categories_users` | 2 | 2 | 0 | |
| 34 | DESCRIBE `authority` | 3 | 3 | 0 | |
| 35 | DESCRIBE `sites_users` | 5 | 5 | 0 | |
| 36 | DESCRIBE `press_releases_sites` | 5 | 5 | 1 | |
| 37 | DESCRIBE `sites` | 5 | 5 | 1 | |
| 38 | 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 | 0 | |
| 39 | SELECT `Press`.`uid`, `Press`.`slug`, `Press`.`company_id`, `Press`.`created`, `Press`.`lastmod`, `Press`.`issued`, `Press`.`headline`, `Press`.`summary`, `Press`.`body`, `Press`.`is_live`, `Press`.`is_attachment`, `Press`.`user_id`, `Press`.`viewed_counter`, `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`, `User`.`uid`, `User`.`email`, `User`.`name`, `User`.`password`, `User`.`lastlogin`, `User`.`currency`, `User`.`person`, `User`.`customer`, `User`.`operator`, `User`.`company`, `User`.`wantsmail`, `User`.`passwordclue`, `User`.`alias`, `User`.`username`, `User`.`person_id`, `User`.`condet_id`, `User`.`company_id`, `User`.`signup_date`, `User`.`alert_inlic`, `User`.`alert_outlic`, `User`.`alert_company`, `User`.`alert_events`, `User`.`alert_lasttime`, `User`.`stats_access`, `PressSite`.`id`, `PressSite`.`created`, `PressSite`.`modified`, `PressSite`.`press_release_id`, `PressSite`.`site_id` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`uid` = '1326985104_4f182f906aa9e' LIMIT 1 | 1 | 1 | 7 | |
| 40 | SELECT `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`.`story_id` = '1326985104_4f182f906aa9e' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | 0 | 0 | 0 | |
| 41 | SELECT `Press`.`uid`, `Press`.`slug`, `Press`.`headline`, `Press`.`body`, `Press`.`issued` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`company_id`='2629' AND `Press`.`is_live`=1 AND DATE(`Press`.`issued`) <= DATE(now()) AND `Press`.`uid` != "1326985104_4f182f906aa9e" ORDER BY `issued` DESC LIMIT 5 | 5 | 5 | 34 | |
| 42 | SELECT `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`.`story_id` IN ('1313056586_4e43a74a87809', '1308056707_4df75c83bab9d', '1306242776_4ddbaed886709', '1299241895_4d70dba744774', '1291373574_4cf8cc0667f5d') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | 42 | 42 | 0 | |
| 43 | SELECT Press.uid, Press.slug, Press.issued, Press.headline, Press.summary FROM press_release AS Press WHERE Press.is_live = 1 AND Press.issued <= now() GROUP BY Press.uid ORDER BY Press.issued DESC LIMIT 5 | 5 | 5 | 1 | |
| 44 | SELECT `Press`.`uid`, `Press`.`issued`, `Press`.`headline`, `Press`.`slug` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`is_live` = 1 AND DATE(`Press`.`issued`) <= DATE(now()) ORDER BY `Press`.`viewed_counter` DESC, `Press`.`issued` DESC LIMIT 5 | 5 | 5 | 72 | |
| 45 | SELECT Category.uid, Category.parent, Category.root, Category.name, Category.level, Category.lft, CASE Category.root WHEN '560' THEN 0 WHEN '297' THEN 1 ELSE CASE Category.uid WHEN '560' THEN 0 WHEN '297' THEN 1 ELSE NULL END END AS root_order FROM category AS RootCategory LEFT JOIN categorisation AS Categorisation ON Categorisation.category_id=RootCategory.uid AND Categorisation.story_id='1326985104_4f182f906aa9e' AND Categorisation.cat_type='R' LEFT JOIN category AS Category ON (Category.lft <= RootCategory.lft AND Category.rgt >= RootCategory.rgt AND Category.level > 0) WHERE Categorisation.id IS NOT NULL AND RootCategory.root IN (560, 297) GROUP BY Category.uid ORDER BY root_order,lft | 0 | 0 | 0 | |
| 46 | SELECT `Press`.`uid`, `Press`.`company_id`, `Press`.`viewed_counter` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`uid`="1326985104_4f182f906aa9e" AND `Press`.`is_live`>0 LIMIT 1 | 1 | 1 | 3 | |
| 47 | SELECT `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`.`story_id` = '1326985104_4f182f906aa9e' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | 0 | 0 | 2 | |
| 48 | SELECT COUNT(*) AS `count` FROM `press_release` AS `Press` WHERE `Press`.`uid` = '1326985104_4f182f906aa9e' | 1 | 1 | 1 | |
| 49 | SELECT COUNT(*) AS `count` FROM `press_release` AS `Press` WHERE `Press`.`uid` = '1326985104_4f182f906aa9e' | 1 | 1 | 0 | |
| 50 | UPDATE `press_release` SET `viewed_counter` = 666 WHERE `press_release`.`uid` = '1326985104_4f182f906aa9e' | 1 | 2 | ||
| 51 | SELECT `Press`.`uid` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`uid` = '1326985104_4f182f906aa9e' LIMIT 1 | 1 | 1 | 3 | |
| 52 | SELECT `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`.`story_id` = '1326985104_4f182f906aa9e' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | 0 | 0 | 0 | |
| 53 | SELECT `PressSite`.`id`, `PressSite`.`created`, `PressSite`.`modified`, `PressSite`.`press_release_id`, `PressSite`.`site_id` FROM `press_releases_sites` AS `PressSite` WHERE `site_id` = 1 AND `press_release_id` = '1326985104_4f182f906aa9e' | 1 | 1 | 0 | |
| 54 | DESCRIBE `statistics` | 7 | 7 | 1 | |
| 55 | SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'press' LIMIT 1 | 1 | 1 | 0 | |
| 56 | SELECT `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` = '1326985104_4f182f906aa9e' AND `company_id` = 2629 AND `module_type_id` = '9' AND `hit_date` = '2012-05-24' LIMIT 1 | 0 | 0 | 11 | |
| 57 | INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 2629, '1326985104_4f182f906aa9e', '9', '2012-05-24') | 1 | 0 | ||
| 58 | SELECT LAST_INSERT_ID() AS insertID | 1 | 1 | 0 |
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `reports` | 17 | 17 | 1 | |
| 2 | 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 ("APR Applied Pharma Research s.a., Labtec GmbH and Norgine BV Announce the Signature of an Exclusive Licensing Agreement under Which Norgine Will Market and Distribute Setofilm™") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("APR Applied Pharma Research `s`.`a`., Labtec GmbH and Norgine BV Announce the Signature of an Exclusive Licensing Agreement under Which Norgine Will Market and Distribute Setofilm™") DESC , MarketResearchReport.published DESC LIMIT 10 | 10 | 10 | 1 |