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

        if ($this->_init && !is_writable($this->settings['path'])) {
            $this->_init = false;
            trigger_error(sprintf(__('%s is not writable', true), $this->settings['path']), E_USER_WARNING);

FileEngine::__active() - CORE/cake/libs/cache/file.php, line 267
FileEngine::init() - CORE/cake/libs/cache/file.php, line 94
Cache::_buildEngine() - CORE/cake/libs/cache.php, line 151
Cache::config() - CORE/cake/libs/cache.php, line 126
include - /home/pharma/website/releases/20120317114903/cakephp/app/pharmalicensing/config/core.php, line 345
Configure::__loadBootstrap() - CORE/cake/libs/configure.php, line 391
Configure::getInstance() - CORE/cake/libs/configure.php, line 52
include - CORE/cake/bootstrap.php, line 38
[main] - /home/pharma/website/releases/20120317114903/cakephp/webroot/pharmalicensing/index.php, line 100

Companies

Companies
Browse

Companies

Displaying 1..10 of 394 - per page Next page
Order by

APR Applied Pharma Research S.A.

APR is a private, independent, integrated Healhcare Company focused on Delivering, Funding and Supporting Innovation in Healthcare. More

Laboratorios Dermatologicos Darier, S.A. de C.V

Darier Laboratories is a vertically integrated specialty pharmaceutical company that develops, manufactures, markets, and sells therapies and technologies exclusively in dermatology. More

Innocoll, Inc.

Specialty pharmaceutical and drug delivery company engaged in the research and manufacture of collagen-based technologies for local drug delivery, surgical implants, advanced wound care and oncology. More

Amarin Technologies S.A.

Amarin is engaged in the development of innovative pharmaceutical products using its proprietary topical and transdermal drug delivery technologies and know-how. More

Alliance Pharmaceuticals (UK)

Alliance pharmaceuticals is a dynamic UK pharmaceutical company with a successful acquisition and partnership track record More

Labtec GmbH

Labtec GmbH provides innovative Product Development and Manufacturing Services all over the world. More

Ferndale Laboratories

Ferndale Laboratories is dedicated to discovering, developing and delivering unique, branded pharmaceuticals that provide therapeutic dermatology solutions to the under-served medical specialties. More

One Nucleus

One Nucleus is a membership organisation for international life science and healthcare companies, based in Cambridge and London UK, the heart of Europe’s largest life science cluster More

National Institutes of Health (NIH)

The NIH supports and conducts basic, clinical, and translational medical research, and investigates the causes, treatments, and cures for both common and rare diseases. More

Almirall

Almirall researches, develops, produces and markets proprietary R&D medicines and those under licence with the aim of improving people's health and well-being. More

Displaying 1..10 of 394 - per page Next page
Order by

Related Reports

Market Research Reports provided by reports.innovaro.com

Deals and alliances in dermatological diseases

Jun 2006 - 434 pages - $2,495

The Dermatology Market Outlook to 2016

Jul 2011 - 96 pages - $3,835

Medicis Pharmaceutical Corporation: Premium Company Profile

Dec 2007 - 49 pages - $495

The World Dermatological Market Outlook 2010-2024

Nov 2009 - 142 pages - $2,350

The Worldwide Market for Prescription Dermatological Drugs, 5th Edition

Feb 2006 - 332 pages - $3,900

Prescription Dermatological Drugs: Worldwide Market, 6th Edition

Jan 2008 - 330 pages - $4,200

Clinical Trial Recruitment in Dermatology - Most Trials Focus on Atopic Dermatitis While Acne Vulgaris Has Highest Patient Numbers

Oct 2011 - 89 pages - $3,500

Dermatological Drugs: World Market 2011-2026

Nov 2010 - 189 pages - $2,350

Market for Prescription Dermatological Drugs, 7th Edition, The

Jan 2010 - 250 pages - $3,900

Company Financials: QLT, Inc.

Jan 2010 - $75

Your selection

Therapeutic target: Dermatological del

Browse By

Industry sector: Academic/Research; Animal health; Biotechnology; Diagnostic; Drug delivery; Drug discovery; Medical device; Non-profit org./Government; Pharmaceutical; Research tools; Service
Therapeutic target: Acne; Actinic keratosis; Alopecia; Bacterial infection; Burns; Chronic idiopathic urticaria; Cosmetic procedures; Dermal ulcers; Dermatitis, allergic; Dermatitis, atopic; Dermatological (other); Dermatosis; Eczema; Fungal infection; Hirsutism; Human B19 parvovirus; Hyperkeratosis; Ichthyosis; Impetigo; Insect bite; Keloids; Lupus; Male pattern baldness; Paget's disease; Photodamage; Pruritis; Psoriasis; Scleroderma; Shingles; Skin infection (other); Ulcer, diabetic; Urticaria; Wound healing
Geographic location: Africa; Asia; Australia/New Zealand; Central America; Europe; Near & Far East; North America; South America

Products:	Partnering Search	Company Profiling	Pharmalicensing Intelligence	Reports	Comparision
In-licensing:	Latest records	Industry Sector	Therapeutic Target	Search	Profile your company	Pharma partnering
Out-licensing:	Latest records	Industry Sector	Therapeutic Target	Search	Profile your company	Pharma partnering
Companies:	Profiled companies	Industry Sector	Therapeutic Target	Geographic Location	Search	Add your company
Reports:	Biotechnology	Business Development	Management	Market & Sales	Medical Devices	Pharmaceuticals
News:	Deals & Alliances	Development	Financial Results	Financings	Intellectual Property	Regulatory
Events:	Pharma events	Calendar	Organizers	Featured events	Search
Articles:	Industrial Sector	Therapeutic Target	Articles date
Deals:	Industry Sector	Therapeutic Target	Deals Date	Search	Reports	Press releases
About us:	Our Audience	Case Studies	Newsletter	FAQ	Contact us	Site map

Products:

Partnering Search

Company Profiling

Pharmalicensing Intelligence

Intellectual Property

(website) 48 queries took 170 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `company`	27	27	8
2	DESCRIBE `condet`	17	17	2
3	DESCRIBE `countrycode`	4	4	1
4	DESCRIBE `person`	15	15	2
5	DESCRIBE `account`	29	29	2
6	DESCRIBE `product_legacy`	6	6	2
7	DESCRIBE `sales_people`	6	6	1
8	DESCRIBE `profile`	14	14	10
9	DESCRIBE `currencies`	7	7	3
10	DESCRIBE `update_rec`	7	7	4
11	DESCRIBE `user`	24	24	3
12	DESCRIBE `enquiry`	14	14	4
13	DESCRIBE `module_types`	6	6	4
14	DESCRIBE `dms_companies`	26	26	2
15	DESCRIBE `dms_releases`	10	10	1
16	DESCRIBE `dms_categories`	4	4	10
17	DESCRIBE `dms_clinical_areas`	4	4	2
18	DESCRIBE `dms_categories_dms_releases`	2	2	2
19	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	1
20	DESCRIBE `dms_releases_sites`	5	5	1
21	DESCRIBE `licopp`	23	23	5
22	DESCRIBE `development_statuses`	5	5	1
23	DESCRIBE `category`	14	14	1
24	DESCRIBE `categories_sites`	5	5	1
25	DESCRIBE `categorisation`	8	8	3
26	DESCRIBE `licopps_sites`	3	3	4
27	DESCRIBE `service`	15	15	3
28	DESCRIBE `press_release`	13	13	1
29	DESCRIBE `press_releases_sites`	5	5	1
30	DESCRIBE `story`	12	12	4
31	DESCRIBE `sites_stories`	5	5	7
32	DESCRIBE `story_assoc`	4	4	1
33	DESCRIBE `companies_sites`	3	3	1
34	DESCRIBE `categories_users`	2	2	2
35	DESCRIBE `authority`	3	3	1
36	DESCRIBE `sites_users`	5	5	2
37	DESCRIBE `products`	8	8	2
38	DESCRIBE `sites`	5	5	12
39	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	2
40	SELECT `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	11	11	7
41	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 (527, 505, 303, 432, 319, 798, 453, 514, 298, 805, 534) ORDER BY `name` ASC	111	111	14
42	SELECT `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` = 603 ORDER BY `Category`.`name` ASC	33	33	1
43	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 (604, 1810, 1811, 612, 1812, 1813, 1814, 1815, 1816, 614, 610, 1817, 609, 605, 1819, 1820, 2052, 1821, 1822, 1823, 1825, 1828, 1829, 1831, 1832, 606, 607, 1833, 1834, 608, 1818, 611, 615) ORDER BY `name` ASC	0	0	4
44	SELECT `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` = 1 ORDER BY `Category`.`name` ASC	8	8	5
45	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 (72, 46, 69, 212, 2, 119, 145, 244) ORDER BY `name` ASC	187	187	1
46	SELECT c.lft, c.rgt FROM category c WHERE c.uid = 603	1	1	12
47	SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "3165" AND c.rgt >= "3232" AND c.level > 1 ORDER BY c.level	1	1	2
48	SELECT `TherapeuticTarget`.`lft`, `TherapeuticTarget`.`rgt`, `TherapeuticTarget`.`uid` FROM `category` AS `TherapeuticTarget` LEFT JOIN `category` AS `Parent` ON (`TherapeuticTarget`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `TherapeuticTarget`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `TherapeuticTarget`.`uid` = 603 LIMIT 1	1	1	5

(website) 48 queries took 170 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `company`

DESCRIBE `condet`

DESCRIBE `countrycode`

DESCRIBE `person`

DESCRIBE `account`

DESCRIBE `product_legacy`

DESCRIBE `sales_people`

DESCRIBE `profile`

DESCRIBE `currencies`

DESCRIBE `update_rec`

DESCRIBE `user`

DESCRIBE `enquiry`

DESCRIBE `module_types`

DESCRIBE `dms_companies`

DESCRIBE `dms_releases`

DESCRIBE `dms_categories`

DESCRIBE `dms_clinical_areas`

DESCRIBE `dms_categories_dms_releases`

DESCRIBE `dms_clinical_areas_dms_releases`

DESCRIBE `dms_releases_sites`

DESCRIBE `licopp`

DESCRIBE `development_statuses`

DESCRIBE `category`

DESCRIBE `categories_sites`

DESCRIBE `categorisation`

DESCRIBE `licopps_sites`

DESCRIBE `service`

DESCRIBE `press_release`

DESCRIBE `press_releases_sites`

DESCRIBE `story`

DESCRIBE `sites_stories`

DESCRIBE `story_assoc`

DESCRIBE `companies_sites`

DESCRIBE `categories_users`

DESCRIBE `authority`

DESCRIBE `sites_users`

DESCRIBE `products`

DESCRIBE `sites`

SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1

SELECT `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

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 (527, 505, 303, 432, 319, 798, 453, 514, 298, 805, 534) ORDER BY `name` ASC

111

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 (604, 1810, 1811, 612, 1812, 1813, 1814, 1815, 1816, 614, 610, 1817, 609, 605, 1819, 1820, 2052, 1821, 1822, 1823, 1825, 1828, 1829, 1831, 1832, 606, 607, 1833, 1834, 608, 1818, 611, 615) ORDER BY `name` ASC

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 (72, 46, 69, 212, 2, 119, 145, 244) ORDER BY `name` ASC

187

SELECT c.lft, c.rgt FROM category c WHERE c.uid = 603

SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "3165" AND c.rgt >= "3232" AND c.level > 1 ORDER BY c.level

SELECT `TherapeuticTarget`.`lft`, `TherapeuticTarget`.`rgt`, `TherapeuticTarget`.`uid` FROM `category` AS `TherapeuticTarget` LEFT JOIN `category` AS `Parent` ON (`TherapeuticTarget`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `TherapeuticTarget`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `TherapeuticTarget`.`uid` = 603 LIMIT 1

(website_slave) 2 queries took 3072 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`summary`, `Company`.`is_customer` FROM `company` AS `Company` INNER JOIN categorisation AS `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Company`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'C') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '3165' AND `TherapeuticTarget`.`rgt` <= '3232') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`TherapeuticTarget`.`lft` >= 3165) AND (`TherapeuticTarget`.`rgt` <= 3232)) AND `Company`.`is_live` = 'Y' GROUP BY `Company`.`uid` ORDER BY `Company`.`is_customer` DESC, `Company`.`viewed_counter` DESC, `Company`.`name` ASC LIMIT 10		10	10	1422
2	SELECT COUNT(DISTINCT Company.uid) AS `count` FROM `company` AS `Company` INNER JOIN categorisation AS `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Company`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'C') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '3165' AND `TherapeuticTarget`.`rgt` <= '3232') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`TherapeuticTarget`.`lft` >= 3165) AND (`TherapeuticTarget`.`rgt` <= 3232)) AND `Company`.`is_live` = 'Y'		1	1	1650

(website_slave) 2 queries took 3072 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`summary`, `Company`.`is_customer` FROM `company` AS `Company` INNER JOIN categorisation AS `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Company`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'C') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '3165' AND `TherapeuticTarget`.`rgt` <= '3232') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`TherapeuticTarget`.`lft` >= 3165) AND (`TherapeuticTarget`.`rgt` <= 3232)) AND `Company`.`is_live` = 'Y' GROUP BY `Company`.`uid` ORDER BY `Company`.`is_customer` DESC, `Company`.`viewed_counter` DESC, `Company`.`name` ASC LIMIT 10

1422

SELECT COUNT(DISTINCT Company.uid) AS `count` FROM `company` AS `Company` INNER JOIN categorisation AS `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Company`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'C') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '3165' AND `TherapeuticTarget`.`rgt` <= '3232') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`TherapeuticTarget`.`lft` >= 3165) AND (`TherapeuticTarget`.`rgt` <= 3232)) AND `Company`.`is_live` = 'Y'

1650

(report) 1 query took 3 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `reports`		17	17	3

(report) 1 query took 3 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `reports`

(report_slave) 1 query took 11 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	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 ("Dermatological") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Dermatological") DESC , MarketResearchReport.published DESC LIMIT 10		10	10	11

(report_slave) 1 query took 11 ms

Query

Error

Affected

Num. rows

Took (ms)

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 ("Dermatological") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Dermatological") DESC , MarketResearchReport.published DESC LIMIT 10