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

Companies

Eyeforpharma

Related Reports

Market Research Reports provided by reports.innovaro.com

Head office

Eyeforpharma
45 Whitechapel Road
Black Lion House, 3rd Floor
London
E1 1DU
United Kingdom

Related categories

Industry sector
Service / Event management

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

(website) 67 queries took 315 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `company`27273
2DESCRIBE `condet`17172
3DESCRIBE `countrycode`443
4DESCRIBE `person`15154
5DESCRIBE `account`29294
6DESCRIBE `product_legacy`663
7DESCRIBE `sales_people`663
8DESCRIBE `profile`14143
9DESCRIBE `currencies`773
10DESCRIBE `update_rec`771
11DESCRIBE `user`24241
12DESCRIBE `enquiry`14142
13DESCRIBE `module_types`662
14DESCRIBE `dms_companies`26264
15DESCRIBE `dms_releases`10102
16DESCRIBE `dms_categories`441
17DESCRIBE `dms_clinical_areas`441
18DESCRIBE `dms_categories_dms_releases`224
19DESCRIBE `dms_clinical_areas_dms_releases`221
20DESCRIBE `dms_releases_sites`551
21DESCRIBE `licopp`23231
22DESCRIBE `development_statuses`552
23DESCRIBE `category`14141
24DESCRIBE `categories_sites`551
25DESCRIBE `categorisation`882
26DESCRIBE `licopps_sites`334
27DESCRIBE `service`15152
28DESCRIBE `press_release`13134
29DESCRIBE `press_releases_sites`557
30DESCRIBE `story`121215
31DESCRIBE `sites_stories`556
32DESCRIBE `story_assoc`441
33DESCRIBE `companies_sites`334
34DESCRIBE `categories_users`2221
35DESCRIBE `authority`338
36DESCRIBE `sites_users`557
37DESCRIBE `products`8831
38DESCRIBE `sites`553
39SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 11113
40SELECT `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`, `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`, `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`, `Account`.`uid`, `Account`.`company_id`, `Account`.`product`, `Account`.`maxlic`, `Account`.`maxpress`, `Account`.`maxjob`, `Account`.`uselic`, `Account`.`usepress`, `Account`.`usejob`, `Account`.`subscribed`, `Account`.`renewal`, `Account`.`priceover`, `Account`.`maxevent`, `Account`.`useevent`, `Account`.`profile`, `Account`.`maxserv`, `Account`.`useserv`, `Account`.`promotion`, `Account`.`maxilic`, `Account`.`useilic`, `Account`.`site_id`, `Account`.`budget`, `Account`.`vat_number`, `Account`.`sales_person_id`, `Account`.`cc_number`, `Account`.`cc_expiry_date`, `Account`.`ipay_client_id`, `Account`.`ipay_account_id`, `Account`.`terms_accepted`, `Profile`.`uid`, `Profile`.`company_id`, `Profile`.`update_id`, `Profile`.`body`, `Profile`.`formed`, `Profile`.`stock_symbol`, `Profile`.`stock_exchange`, `Profile`.`ownership`, `Profile`.`employees`, `Profile`.`annualrep`, `Profile`.`turnover`, `Profile`.`turnyear`, `Profile`.`currency_id`, `Profile`.`needs`, `DmsCompany`.`id`, `DmsCompany`.`company_id`, `DmsCompany`.`name`, `DmsCompany`.`url`, `DmsCompany`.`email`, `DmsCompany`.`founded`, `DmsCompany`.`address`, `DmsCompany`.`zip`, `DmsCompany`.`city`, `DmsCompany`.`state`, `DmsCompany`.`country`, `DmsCompany`.`region`, `DmsCompany`.`primary_phone`, `DmsCompany`.`secondary_phone`, `DmsCompany`.`abstract`, `DmsCompany`.`summary`, `DmsCompany`.`management`, `DmsCompany`.`primary_parent_company`, `DmsCompany`.`secondary_parent_company`, `DmsCompany`.`subsidiary_names`, `DmsCompany`.`exchanges`, `DmsCompany`.`is_public`, `DmsCompany`.`is_dead`, `DmsCompany`.`last_changed`, `DmsCompany`.`created`, `DmsCompany`.`modified`, `CompanySite`.`id`, `CompanySite`.`company_id`, `CompanySite`.`site_id` FROM `company` AS `Company` LEFT JOIN `condet` AS `Contact` ON (`Company`.`condet_id` = `Contact`.`uid`) LEFT JOIN `person` AS `PrimaryContact` ON (`PrimaryContact`.`public`="Y" AND `PrimaryContact`.`company_primary_contact` = 1 AND `Company`.`person_id` = `PrimaryContact`.`uid`) LEFT JOIN `account` AS `Account` ON (`Account`.`company_id` = `Company`.`uid`) LEFT JOIN `profile` AS `Profile` ON (`Profile`.`company_id` = `Company`.`uid`) LEFT JOIN `dms_companies` AS `DmsCompany` ON (`DmsCompany`.`company_id` = `Company`.`uid`) LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND `Company`.`uid` = 3337 LIMIT 1116
41SELECT `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` = 15737 113
42SELECT `Country`.`uid`, `Country`.`country`, `Country`.`eu_member`, `Country`.`isocode` FROM `countrycode` AS `Country` WHERE `Country`.`uid` = 44 1111
43SELECT `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`.`public`="Y" AND `PrimaryContact`.`company_primary_contact` = 1 AND `PrimaryContact`.`uid` = -1 001
44SELECT `Account`.`uid`, `Account`.`company_id`, `Account`.`product`, `Account`.`maxlic`, `Account`.`maxpress`, `Account`.`maxjob`, `Account`.`uselic`, `Account`.`usepress`, `Account`.`usejob`, `Account`.`subscribed`, `Account`.`renewal`, `Account`.`priceover`, `Account`.`maxevent`, `Account`.`useevent`, `Account`.`profile`, `Account`.`maxserv`, `Account`.`useserv`, `Account`.`promotion`, `Account`.`maxilic`, `Account`.`useilic`, `Account`.`site_id`, `Account`.`budget`, `Account`.`vat_number`, `Account`.`sales_person_id`, `Account`.`cc_number`, `Account`.`cc_expiry_date`, `Account`.`ipay_client_id`, `Account`.`ipay_account_id`, `Account`.`terms_accepted` FROM `account` AS `Account` WHERE `Account`.`company_id` = 3337 002
45SELECT `Profile`.`uid`, `Profile`.`company_id`, `Profile`.`update_id`, `Profile`.`body`, `Profile`.`formed`, `Profile`.`stock_symbol`, `Profile`.`stock_exchange`, `Profile`.`ownership`, `Profile`.`employees`, `Profile`.`annualrep`, `Profile`.`turnover`, `Profile`.`turnyear`, `Profile`.`currency_id`, `Profile`.`needs` FROM `profile` AS `Profile` WHERE `Profile`.`company_id` = 3337 002
46SELECT `DmsCompany`.`id`, `DmsCompany`.`company_id`, `DmsCompany`.`name`, `DmsCompany`.`url`, `DmsCompany`.`email`, `DmsCompany`.`founded`, `DmsCompany`.`address`, `DmsCompany`.`zip`, `DmsCompany`.`city`, `DmsCompany`.`state`, `DmsCompany`.`country`, `DmsCompany`.`region`, `DmsCompany`.`primary_phone`, `DmsCompany`.`secondary_phone`, `DmsCompany`.`abstract`, `DmsCompany`.`summary`, `DmsCompany`.`management`, `DmsCompany`.`primary_parent_company`, `DmsCompany`.`secondary_parent_company`, `DmsCompany`.`subsidiary_names`, `DmsCompany`.`exchanges`, `DmsCompany`.`is_public`, `DmsCompany`.`is_dead`, `DmsCompany`.`last_changed`, `DmsCompany`.`created`, `DmsCompany`.`modified` FROM `dms_companies` AS `DmsCompany` WHERE `DmsCompany`.`company_id` = 3337 001
47SELECT `CompanySite`.`id`, `CompanySite`.`company_id`, `CompanySite`.`site_id` FROM `companies_sites` AS `CompanySite` WHERE `CompanySite`.`company_id` = 3337 113
48SELECT `Service`.`id`, `Service`.`slug`, `Service`.`headline`, `Service`.`detail`, `Service`.`contact_id`, `Service`.`company_id` FROM `service` AS `Service` WHERE `Service`.`is_live` = 1 AND `Service`.`company_id` = (3337) ORDER BY `Service`.`headline` ASC 001
49SELECT `RegionalOffice`.`uid`, `RegionalOffice`.`address`, `RegionalOffice`.`street1`, `RegionalOffice`.`street2`, `RegionalOffice`.`city`, `RegionalOffice`.`district`, `RegionalOffice`.`postcode`, `RegionalOffice`.`telswitch`, `RegionalOffice`.`teldirect`, `RegionalOffice`.`cellphone`, `RegionalOffice`.`fax`, `RegionalOffice`.`faxdirect`, `RegionalOffice`.`email`, `RegionalOffice`.`url`, `RegionalOffice`.`country`, `RegionalOffice`.`office`, `RegionalOffice`.`company_id` FROM `condet` AS `RegionalOffice` WHERE `RegionalOffice`.`company_id` = (3337) ORDER BY `RegionalOffice`.`office` ASC 001
50SELECT `SecondaryContact`.`uid`, `SecondaryContact`.`salutation`, `SecondaryContact`.`forename`, `SecondaryContact`.`surname`, `SecondaryContact`.`nickname`, `SecondaryContact`.`postfix`, `SecondaryContact`.`jobtitle`, `SecondaryContact`.`company_id`, `SecondaryContact`.`company_primary_contact`, `SecondaryContact`.`department`, `SecondaryContact`.`condet_id`, `SecondaryContact`.`assistant_id`, `SecondaryContact`.`notes_id`, `SecondaryContact`.`user_id`, `SecondaryContact`.`public` FROM `person` AS `SecondaryContact` WHERE `SecondaryContact`.`company_primary_contact` = 0 AND `SecondaryContact`.`public`="y" AND `SecondaryContact`.`company_id` = (3337) ORDER BY `SecondaryContact`.`surname` ASC 006
51SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent` 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`=146 OR `Category`.`parent`=198 ORDER BY `Category`.`parent` ASC, `Category`.`name` ASC 77775
52SELECT `Inlicensing`.`uid`, `Inlicensing`.`slug`, `Inlicensing`.`title`, `Inlicensing`.`shortdesc`, `Inlicensing`.`is_anon`, `Inlicensing`.`contact_id` FROM `licopp` AS `Inlicensing` LEFT JOIN `person` AS `Person` ON (`Inlicensing`.`contact_id` = `Person`.`uid`) LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Inlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `update_rec` AS `UpdateRecord` ON (`Inlicensing`.`update_id` = `UpdateRecord`.`uid`) LEFT JOIN `company` AS `Company` ON (`Inlicensing`.`company_id` = `Company`.`uid`) LEFT JOIN `licopps_sites` AS `InlicensingSite` ON (`InlicensingSite`.`licopp_id` = `Inlicensing`.`uid`) WHERE `InlicensingSite`.`site_id` = 1 AND `Inlicensing`.`is_out` <> "Y" AND `Inlicensing`.`is_anon` = 'n' AND `Inlicensing`.`company_id` = 3337 ORDER BY `Inlicensing`.`title` ASC 006
53SELECT `Outlicensing`.`uid`, `Outlicensing`.`slug`, `Outlicensing`.`title`, `Outlicensing`.`shortdesc`, `Outlicensing`.`is_anon`, `Outlicensing`.`contact_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` = 1 AND `Outlicensing`.`is_out` = 'Y' AND `Outlicensing`.`is_anon` = 'n' AND `Outlicensing`.`company_id` = 3337 ORDER BY `Outlicensing`.`title` ASC 002
54SELECT `Deal`.`uid`, `Deal`.`slug`, `Deal`.`created`, `Deal`.`lastmod`, `Deal`.`issued`, `Deal`.`author`, `Deal`.`author_email`, `Deal`.`headline`, `Deal`.`summary`, `Deal`.`body`, `Deal`.`is_live`, `Deal`.`viewed_counter`, `DealSite`.`id`, `DealSite`.`story_id`, `DealSite`.`created`, `DealSite`.`modified`, `DealSite`.`site_id` FROM `story` AS `Deal` inner JOIN story_assoc AS `DealAssoc` ON (`DealAssoc`.`story_id`=`Deal`.`uid` AND `DealAssoc`.`assoc_id`="3337" AND `DealAssoc`.`type`="company") LEFT JOIN `sites_stories` AS `DealSite` ON (`DealSite`.`story_id` = `Deal`.`uid`) WHERE `DealSite`.`site_id` = 1 AND `Deal`.`is_live` = 1 005
55SELECT `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`.`company_id` = 3337 AND `Press`.`is_live` = 1 ORDER BY `Press`.`issued` DESC 0035
56SELECT c.uid, c.name, c.root FROM category c INNER JOIN category cc ON cc.uid = c.clan INNER JOIN categorisation ctg ON ctg.category_id = c.uid AND ctg.cat_type = "C" WHERE ctg.company_id = 3337 AND c.restricted IS NULL ORDER BY cc.name, c.level 1111
57SELECT `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` = 1 AND `Category`.`uid` = 541 ORDER BY `par`.`lft` ASC 224
58SELECT `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` = (541) ORDER BY `name` ASC 001
59SELECT com.uid, com.slug, com.name, sum(c.level) AS score FROM company com INNER JOIN categorisation ctg ON ctg.company_id = com.uid AND ctg.cat_type = "C" INNER JOIN categorisation ctg2 ON ctg.category_id = ctg2.category_id AND ctg2.company_id = 3337 AND ctg2.cat_type = "C" INNER JOIN category c ON ctg.category_id = c.uid WHERE com.uid <> 3337 AND com.is_live = "Y" AND com.is_customer = "Y" AND c.root = 560 GROUP BY com.uid, com.name ORDER BY score DESC, com.viewed_counter DESC LIMIT 5 003
60SELECT Authority.user_id FROM authority AS Authority WHERE company_id = 3337 ORDER BY primary_user DESC002
61SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1112
62UPDATE company SET viewed_counter = viewed_counter + 1 WHERE uid = 3337 110
63DESCRIBE `statistics`771
64SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'company' LIMIT 1115
65SELECT `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` = '3337' AND `company_id` = 3337 AND `module_type_id` = '2' AND `hit_date` = '2012-05-17' LIMIT 1003
66INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 3337, '3337', '2', '2012-05-17')11
67SELECT LAST_INSERT_ID() AS insertID111
(default) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)
(report) 2 queries took 2 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 ("Eyeforpharma") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Eyeforpharma") DESC , MarketResearchReport.published DESC LIMIT 10001