Rabeprazole, an anti-ulcer drug is currently only available in tablet form; our clients however have a patent that allows for the delivery of Rabeprazole as an injection. The method specifically provides a stabilized pharmaceutically acceptable dosage form of proton pump inhibitors and a lyophilized (freeze dried) injection of Rabeprazole.
As the patent covers the EU market and Turkey, our clients are looking for a partner with a European presence (excluding Portugal) to either acquire or out-license this novel patent.
Â
Either an acquisition or out-licensing agreement will be considered by the client from a partner who is either based or has a presence in Europe.
Innovaro Pharmalicensing.com - the leading global resource for partnering, licensing, and business development.
View profile| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `licopp` | 23 | 23 | 2 | |
| 2 | DESCRIBE `company` | 27 | 27 | 2 | |
| 3 | DESCRIBE `condet` | 17 | 17 | 3 | |
| 4 | DESCRIBE `countrycode` | 4 | 4 | 5 | |
| 5 | DESCRIBE `person` | 15 | 15 | 13 | |
| 6 | DESCRIBE `account` | 29 | 29 | 7 | |
| 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 | 11 | |
| 13 | DESCRIBE `enquiry` | 14 | 14 | 2 | |
| 14 | DESCRIBE `module_types` | 6 | 6 | 1 | |
| 15 | DESCRIBE `dms_companies` | 26 | 26 | 12 | |
| 16 | DESCRIBE `dms_releases` | 10 | 10 | 3 | |
| 17 | DESCRIBE `dms_categories` | 4 | 4 | 1 | |
| 18 | DESCRIBE `dms_clinical_areas` | 4 | 4 | 2 | |
| 19 | DESCRIBE `dms_categories_dms_releases` | 2 | 2 | 2 | |
| 20 | DESCRIBE `dms_clinical_areas_dms_releases` | 2 | 2 | 0 | |
| 21 | DESCRIBE `dms_releases_sites` | 5 | 5 | 2 | |
| 22 | DESCRIBE `development_statuses` | 5 | 5 | 13 | |
| 23 | DESCRIBE `category` | 14 | 14 | 8 | |
| 24 | DESCRIBE `categories_sites` | 5 | 5 | 6 | |
| 25 | DESCRIBE `categorisation` | 8 | 8 | 9 | |
| 26 | DESCRIBE `licopps_sites` | 3 | 3 | 1 | |
| 27 | DESCRIBE `service` | 15 | 15 | 6 | |
| 28 | DESCRIBE `press_release` | 13 | 13 | 15 | |
| 29 | DESCRIBE `press_releases_sites` | 5 | 5 | 2 | |
| 30 | DESCRIBE `story` | 12 | 12 | 2 | |
| 31 | DESCRIBE `sites_stories` | 5 | 5 | 8 | |
| 32 | DESCRIBE `story_assoc` | 4 | 4 | 1 | |
| 33 | DESCRIBE `companies_sites` | 3 | 3 | 2 | |
| 34 | DESCRIBE `categories_users` | 2 | 2 | 1 | |
| 35 | DESCRIBE `authority` | 3 | 3 | 1 | |
| 36 | DESCRIBE `sites_users` | 5 | 5 | 1 | |
| 37 | DESCRIBE `sites` | 5 | 5 | 16 | |
| 38 | SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 2 LIMIT 1 | 1 | 1 | 1 | |
| 39 | SELECT `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` = 19250 AND `Outlicensing`.`is_out` = 'Y' LIMIT 1 | 1 | 1 | 8 | |
| 40 | SELECT `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` = 47741 | 1 | 1 | 0 | |
| 41 | SELECT `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name`, `DevelopmentStatus`.`display_order`, `DevelopmentStatus`.`created`, `DevelopmentStatus`.`modified` FROM `development_statuses` AS `DevelopmentStatus` WHERE `DevelopmentStatus`.`id` = 9 | 1 | 1 | 1 | |
| 42 | SELECT `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` = 8643 | 1 | 1 | 1 | |
| 43 | SELECT `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 | 1 | 1 | 1 | |
| 44 | SELECT `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 | 1 | 1 | 7 | |
| 45 | SELECT `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 | 1 | 1 | 3 | |
| 46 | SELECT `OutlicensingSite`.`id`, `OutlicensingSite`.`licopp_id`, `OutlicensingSite`.`site_id` FROM `licopps_sites` AS `OutlicensingSite` WHERE `OutlicensingSite`.`licopp_id` = 19250 | 2 | 2 | 2 | |
| 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`.`company_id` = 19250 AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | 6 | 6 | 1 | |
| 48 | SELECT `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` = '19250' ORDER BY `Category`.`name` ASC, `Category`.`level` ASC | 6 | 6 | 1 | |
| 49 | SELECT `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 (319, 616, 357, 353, 624, 1808) ORDER BY `name` ASC | 54 | 54 | 1 | |
| 50 | SELECT `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 | 1 | 1 | 1 | |
| 51 | SELECT `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 | 13 | 13 | 3 | |
| 52 | SELECT `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` = 616 ORDER BY `par`.`lft` ASC | 1 | 1 | 11 | |
| 53 | SELECT `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` = (616) ORDER BY `name` ASC | 28 | 28 | 1 | |
| 54 | SELECT `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` = 357 ORDER BY `par`.`lft` ASC | 3 | 3 | 6 | |
| 55 | SELECT `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` = (357) ORDER BY `name` ASC | 0 | 0 | 1 | |
| 56 | SELECT `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` = 353 ORDER BY `par`.`lft` ASC | 2 | 2 | 8 | |
| 57 | SELECT `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` = (353) ORDER BY `name` ASC | 13 | 13 | 1 | |
| 58 | SELECT `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` = 624 ORDER BY `par`.`lft` ASC | 2 | 2 | 0 | |
| 59 | SELECT `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` = (624) ORDER BY `name` ASC | 0 | 0 | 7 | |
| 60 | SELECT `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` = 1808 ORDER BY `par`.`lft` ASC | 2 | 2 | 3 | |
| 61 | SELECT `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` = (1808) ORDER BY `name` ASC | 0 | 0 | 11 | |
| 62 | SELECT 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 = "19250" AND ctg2.cat_type = "L" INNER JOIN category c ON ctg.category_id = c.uid WHERE l.uid <> 19250 AND c.root = 560 GROUP BY l.uid, l.title, l.shortdesc ORDER BY score DESC, l.viewed_counter DESC LIMIT 5 | 5 | 5 | 138 | |
| 63 | SELECT Authority.user_id FROM authority AS Authority WHERE company_id = 1139 ORDER BY primary_user DESC | 1 | 1 | 1 | |
| 64 | SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 2 LIMIT 1 | 1 | 1 | 5 | |
| 65 | UPDATE licopp SET viewed_counter = viewed_counter + 1 WHERE uid = 19250 | 1 | 7 | ||
| 66 | SELECT `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` = 19250 LIMIT 1 | 1 | 1 | 1 | |
| 67 | DESCRIBE `statistics` | 7 | 7 | 2 | |
| 68 | SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'outlicensing' LIMIT 1 | 1 | 1 | 1 | |
| 69 | 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` = '19250' AND `company_id` = 1139 AND `module_type_id` = '4' AND `hit_date` = '2012-02-23' LIMIT 1 | 1 | 1 | 2 | |
| 70 | SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 9971486 | 1 | 1 | 1 | |
| 71 | SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 9971486 | 1 | 1 | 3 | |
| 72 | SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 9971486 | 1 | 1 | 1 | |
| 73 | UPDATE `statistics` SET `id` = 9971486, `module_type_id` = '4', `company_id` = 1139, `business_object_id` = '19250', `count` = 5, `hit_date` = '2012-02-23', `is_aggregated` = 0 WHERE `statistics`.`id` = 9971486 | 1 | 2 |
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `reports` | 17 | 17 | 2 | |
| 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 ("EU patent for the preparation of an injectable form of anti-ulcer drug Rabeprazole") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("EU patent for the preparation of an injectable form of anti-ulcer drug Rabeprazole") DESC , MarketResearchReport.published DESC LIMIT 10 | 10 | 10 | 15 |