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
Company details

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.

Profile

Innocoll is an international, specialty pharmaceutical and drug delivery company engaged in the research, development and manufacture of innovative collagen based medical products ulilizing the company's drug delivery technology platforms (CollaRx®and LiquiColl®). These technologies are fully biodegradable and designed for the localized, site-specific delivery of a wide variety of drugs and are specifically intended to minimize systemic exposure and associated side effects.

Localized delivery provides a way of targeting the optimum dose of a drug to precisely where it is needed, rather than distributing excessive and sometimes unnecessary concentrations throughout the body via the systemic circulation. Such delivery systems can enhance a drug's efficacy and reduce unwanted side effects compared to oral or intravenous administration, particularly when targeting poorly vascularized areas such as bone and chronically infected wounds. Localized delivery can also be used as an adjunct to systemic therapy, such as in the prevention of infection or management of pain.

The parent company, Innocoll Inc., has three operating divisions:

• Drug Delivery and R&D Division (Innocoll Technologies)

• Sales and Marketing Division (Innocoll Pharmaceuticals)

• Commercial Manufacturing Division (Syntacoll)

Innocoll Technologies is responsible for the development of new products based upon the proprietary CollaRx and Liquicoll technologies as well as research into new collagen-based pharmaceutical products and medical devices. Internal programs are focussed on treatment and prevention of surgical site infections, advanced wound care, post-operative pain management, prevention of surgical adhesions and oncology. We are also seeking co-development partnerships with pharmaceutical and biotechnology companies interested in using our technologies to develop first-line products or localized delivery line extensions of existing brands.

Innocoll Pharmaceuticals is responsible for establishing and overseeing collabrations with Innocoll's marketing partners. The lead marketed product, Gentamicin Surgical Implant (Collatamp G), is a leave-behind surgical implant indicated for the treatment and prevention of post operative infections. The product is promoted to surgeons across a broad range of surgical specialities, including orthopedic, thoracic, abdominal, and vascular procedures, where there is often increased risk of post-operative infection or where such infections can lead to severe complications. It is currently marketed in more than 30 territories under various trade names throughout most of Europe and other "rest-of-world" countries in Latin America, Middle East, Asia and Africa. Innocoll is also developing Collatamp G for the US market where it is currently in Phase 3 clinical trials for the prevention of surgical site infections and Phase 2 trials as a topical treatment for infected diabetic foot ulcers.

Syntacoll AG (Switzerland) is the holding company for Innocoll's two commercial manufacturing facilities, Syntacoll GmbH in Saal, Germany, and Syntacoll Pty in Midrand, South Africa. An additional manufacturing facility is planned at Innocoll Technologies HQ in Roscommon, Ireland.

Partnering strategy/interests

Out-license of internal pipeline products for the prevention of surgical site infections, treatment and prevention of infected diabetic foot ulcers, advanced wound care, prevention of surgical adhesions and oncology. Partnerships with pharmaceutical and biotechnology companies interested in localized drug delivery of their proprietary molecules.

Out-licensing

Advanced Wound Care Products

Collagen-based dressings for wound management More

Cogenzia®

Indicated for the treatment and prevention of diabetic foot ulcers. More

CollaRx® & LiquiColl® Technologies

Collagen-based biodegradable matrices for localized drug delivery More

Oncology Products

Gene targeting and localized delivery of anti-neoplastic agents More

Surgical Adhesion Barrier

Collagen-based adhesion barrier for the prevention of surgical adhesions More

R&D

To view this information, you must subscribe to Pharmalicensing Intelligence.

Deals

To view this information, you must subscribe to Pharmalicensing Intelligence.

Press Releases

Innocoll Provides Update of Regulatory and Partnering Activities for CollaGUARD® Adhesion Barrier and Launches New Product Website

(3rd Apr 2012) Innocoll Provides Update of Regulatory and Partnering Activities for CollaGUARD® Adhesion Barrier and Launches New Product Website More

Innocoll Announces Successful End-of-Phase 2 Meeting with FDA for XaraColl® and Agreement of the Phase 3 Program

(17th Feb 2012) Innocoll Announces Successful End-of-Phase 2 Meeting with FDA for XaraColl® and Agreement of the Phase 3 Program More

Innocoll Enters CollaGUARD® Distribution Partnership with Flynn Pharma Ltd in the UK and Inresa Arzneimittel GmbH in Germany

(1st Feb 2012) Innocoll Enters CollaGUARD® Distribution Partnership with Flynn Pharma Ltd in the UK and Inresa Arzneimittel GmbH in Germany More

Innocoll Enters Partnership with Merus Labs in Canada for the Distribution of CollaGUARD

(15th Nov 2011) ASHBURN, VA., November 15, 2011 /PRNewswire/ –– Innocoll Inc. announced it has entered into a License and Distribution Agreement with Merus Labs Inc. in Canada for CollaGUARD surgical adhesion barrier for the prevention of postoperative adhesions follow More

Innocoll Enters Partnership with Pioneer Pharma in China for the Distribution of CollaGUARD

(19th Oct 2011) Innocoll Enters Partnership with Pioneer Pharma in China for the Distribution of CollaGUARD More

Innocoll Announces European Approval for CollaGUARD®, Surgical Adhesion Barrier.

(11th Oct 2011) Innocoll Announces European Approval for CollaGUARD®, Surgical Adhesion Barrier. More

Innocoll Provides an Update on its range of Advanced Wound Care and Related Collagen-based Products

(19th Sep 2011) ASHBURN, VA., September 19, 2011 /PRNewswire/ –– Innocoll, Inc. announced the following update for its range of advanced wound care and related collagen-based products. More

Innocoll Announces Top-line Results from its Phase 2 Clinical Trial investigating XaraColl® for the Management of Post-operative Pain and Receives “Notice of Allowability” for XaraColl U.S. Patent App

(13th Sep 2011) ASHBURN, Va., September 13, 2011 /PRNewswire/ – Innocoll, Inc. announced top-line results from its phase 2 clinical trial investigating XaraColl for the management of post-operative pain and also announced it has received a “Notice of Allowability” for it More

Innocoll Submits SPA for CogenziaTM Phase III Clinical Trials for the Adjuvant Treatment of Diabetic Foot Infections

(13th Jul 2010) Innocoll Submits SPA for CogenziaTM Phase III Clinical Trials for the Adjuvant Treatment of Diabetic Foot Infections More

Innocoll Announces Appointment of Anthony H. Wild Ph.D. to Chairman of the Board

(17th Jun 2010) Innocoll Announces Appointment of Anthony H. Wild Ph.D. to Chairman of the Board More

Innocoll Announces Provisional Findings from its Three Phase 2 Clinical Trials Investigating CollaRx(R) GENTAMICIN TOPICAL for the Treatment and Prevention of Diabetic Foot Infections

(18th Jun 2009) Innocoll Announces Provisional Findings from its Three Phase 2 Clinical Trials Investigating CollaRx(R) GENTAMICIN TOPICAL for the Treatment and Prevention of Diabetic Foot Infections More

Innocoll, Inc. Files 510 (k) application for CollaRx Lidocaine Sponge

(31st Mar 2009) Innocoll, Inc. Files 510 (k) application for CollaRx Lidocaine Sponge More

Innocoll Announces Dosing of Last Patient in Second US Phase 3 Clinical Trial to Investigate GENTAMICIN SURGICAL IMPLANT for Prevention of Surgical Site Infections in Colorectal Surgery Patients

(19th Mar 2009) Innocoll Announces Dosing of Last Patient in Second US Phase 3 Clinical Trial to Investigate GENTAMICIN SURGICAL IMPLANT for Prevention of Surgical Site Infections in Colorectal Surgery Patients More

Innocoll Announces Dosing of Last Patient in US Phase 3 Clinical Trial to Investigate GENTAMICIN SURGICAL IMPLANT for Prevention of Surgical Site Infections in Cardiac Surgery Patients

(16th Mar 2009) Innocoll Announces Dosing of Last Patient in US Phase 3 Clinical Trial to Investigate GENTAMICIN SURGICAL IMPLANT for Prevention of Surgical Site Infections in Cardiac Surgery Patients More

Innocoll Receives Fast Track Designation for Gentamicin Surgical Implant

(17th Nov 2008) Innocoll Receives Fast Track Designation for Gentamicin Surgical Implant More

BAXTER ANNOUNCES LICENSING AGREEMENT FOR INNOCOLL’S GENTAMICIN SURGICAL IMPLANT IN THE UNITED STATES

(25th Aug 2008) BAXTER ANNOUNCES LICENSING AGREEMENT FOR INNOCOLL’S GENTAMICIN SURGICAL IMPLANT IN THE UNITED STATES More

Innocoll Announces Dosing of Last Patient in US Phase 2 Clinical Trial to Investigate CollaRx® BUPIVACAINE SURGICAL IMPLANT for the Management of Post-operative Pain

(8th Aug 2008) Innocoll Announces Dosing of Last Patient in US Phase 2 Clinical Trial to Investigate CollaRx® BUPIVACAINE SURGICAL IMPLANT for the Management of Post-operative Pain More

Innocoll Announces Dosing of First Patient in a Third US Phase 2 Clinical Trial to Investigate CollaRx® BUPIVACAINE SURGICAL IMPLANT for the Management of Post-operative Pain

(28th Jul 2008) Innocoll Announces Dosing of First Patient in a Third US Phase 2 Clinical Trial to Investigate CollaRx® BUPIVACAINE SURGICAL IMPLANT for the Management of Post-operative Pain More

Innocoll Appoints Anthony H. Wild Ph.D. to Its Board of Directors

(21st Jul 2008) Innocoll Appoints Anthony H. Wild Ph.D. to Its Board of Directors More

Innocoll Announces Dosing of First Patient in US Phase 2 Clinical Trial to Investigate CollaRx® GENTAMICIN TOPICAL for the Prevention of Diabetic Foot Infections

(30th Apr 2008) Innocoll Announces Dosing of First Patient in US Phase 2 Clinical Trial to Investigate CollaRx® GENTAMICIN TOPICAL for the Prevention of Diabetic Foot Infections More

Innocoll Announces Dosing of First Patient in US Phase 2 Clinical Trial to Investigate CollaRx® GENTAMICIN TOPICAL for the Treatment of Moderately Infected Diabetic Foot Ulcers

(17th Apr 2008) Innocoll Announces Dosing of First Patient in US Phase 2 Clinical Trial to Investigate CollaRx® GENTAMICIN TOPICAL for the Treatment of Moderately Infected Diabetic Foot Ulcers More

Innocoll Announces Dosing of First Patient in a Second US Phase 2 Clinical Trial to Investigate CollaRx® BUPIVACAINE SURGICAL IMPLANT for the Management of Post-operative Pain

(13th Mar 2008) Innocoll Announces Dosing of First Patient in a Second US Phase 2 Clinical Trial to Investigate CollaRx® BUPIVACAINE SURGICAL IMPLANT for the Management of Post-operative Pain More

Innocoll Announces Dosing of First Patient in Second US Phase 3 Clinical Trial to Investigate CollaRx® GENTAMICIN SURGICAL IMPLANT for the Prevention of Surgical Site Infections

(19th Feb 2008) Innocoll Announces Dosing of First Patient in Second US Phase 3 Clinical Trial to Investigate CollaRx® GENTAMICIN SURGICAL IMPLANT for the Prevention of Surgical Site Infections More

Innocoll Announces Dosing of First Patient in US Phase 2 Clinical Trial to Investigate CollaRx® BUPIVACAINE SURGICAL IMPLANT for the Management of Post-operative Pain

(4th Jan 2008) Innocoll Announces Dosing of First Patient in US Phase 2 Clinical Trial to Investigate CollaRx® BUPIVACAINE SURGICAL IMPLANT for the Management of Post-operative Pain More

Innocoll Announces Dosing of First Patient in US Phase 3 Clinical Trial to Investigate CollaRx® GENTAMICIN SURGICAL IMPLANT for the Prevention of Surgical Site Infections in Cardiac Surgery Patien

(2nd Jan 2008) Innocoll Announces Dosing of First Patient in US Phase 3 Clinical Trial to Investigate CollaRx® GENTAMICIN SURGICAL IMPLANT for the Prevention of Surgical Site Infections in Cardiac Surgery Patients More

Innocoll Announces Dosing of First Patient in US Phase 2 Clinical Trial to Investigate CollaRx® GENTAMICIN TOPICAL for the Treatment of Mildly Infected Diabetic Foot Ulcers

(18th Dec 2007) Innocoll Announces Dosing of First Patient in US Phase 2 Clinical Trial to Investigate CollaRx® GENTAMICIN TOPICAL for the Treatment of Mildly Infected Diabetic Foot Ulcers More

Innocoll Announces Closing of $30 Million Equity Financing Investment

(17th Dec 2007) Innocoll Announces Closing of $30 Million Equity Financing Investment More

Innocoll Receives "Intends to Grant" Notices from the European Patent Office for Two European Patent Applications Related to Novel Wound Healing, Biosurgery and Drug Delivery Applications

(28th Nov 2007) Innocoll Receives "Intends to Grant" Notices from the European Patent Office for Two European Patent Applications Related to Novel Wound Healing, Biosurgery and Drug Delivery Applications of its CollaRx® Technology More

Innocoll Files Investigational New Drug Application for its CollaRx® BUPIVACAINE TOPICAL for the Treatment of Painful Chronic Skin Ulcers and Burns

(17th Oct 2007) Innocoll Files Investigational New Drug Application for its CollaRx® BUPIVACAINE TOPICAL for the Treatment of Painful Chronic Skin Ulcers and Burns More

Innocoll Provides a Progress Update on its Clinical Development Programs and Specialty Pharmaceutical Operations

(26th Sep 2007) Innocoll Provides a Progress Update on its Clinical Development Programs and Specialty Pharmaceutical Operations More

INNOCOLL ENTERS INTO COLLABORATION WITH TGR BIOSCIENCES FOR DEVELOPMENT OF A NOVEL WOUND HEALING PRODUCT

(12th Sep 2007) INNOCOLL ENTERS INTO COLLABORATION WITH TGR BIOSCIENCES FOR DEVELOPMENT OF A NOVEL WOUND HEALING PRODUCT More

Innocoll, Inc. and Bourne Partners Announce Joint Venture to Build Leading U.S. Advanced Wound Care Business - Formation of CollMED Laboratories, Inc.

(10th Sep 2007) Innocoll, Inc. and Bourne Partners Announce Joint Venture to Build Leading U.S. Advanced Wound Care Business - Formation of CollMED Laboratories, Inc. More

Innocoll Agrees the Sale of its CollaRx® GENTAMICIN SURGICAL IMPLANT and European Sales and Marketing Infrastructure

(6th Sep 2007) Innocoll Agrees the Sale of its CollaRx® GENTAMICIN SURGICAL IMPLANT and European Sales and Marketing Infrastructure to EUSA Pharma More

Health Canada Approves Innocoll's CollaRx® GENTAMICIN SURGICAL IMPLANT

(8th Aug 2007) Health Canada Approves Innocoll's CollaRx® GENTAMICIN SURGICAL IMPLANT More

Innocoll Announces Filing of Investigational New Drug Application

(6th Jun 2007) Innocoll Announces Filing of Investigational New Drug Application for its CollaRx® GENTAMICIN SURGICAL IMPLANT for the Prevention of Surgical Site Infections More

Innocoll Announces Outcome of FDA Meeting to Commence Phase 3 Development of its CollaRx® GENTAMICIN SURGICAL IMPLANT for the Prevention of Surgical Site Infections

(24th Apr 2007) Innocoll Announces Outcome of FDA Meeting to Commence Phase 3 Development of its CollaRx® GENTAMICIN SURGICAL IMPLANT for the Prevention of Surgical Site Infections More

Innocoll Files CollaRx® GENTAMICIN SURGICAL IMPLANT in Australia

(11th Apr 2007) Innocoll Files CollaRx® GENTAMICIN SURGICAL IMPLANT in Australia More

Innocoll Receives FDA Approval to Commence Phase 2 Clinical Development with its CollaRx® BUPIVACAINE IMPLANT for the Management of Post-operative Pain

(4th Apr 2007) Innocoll Receives FDA Approval to Commence Phase 2 Clinical Development with its CollaRx® BUPIVACAINE IMPLANT for the Management of Post-operative Pain More

Innocoll Files US and Irish Patent Applications for its CollaRx® BUPIVACAINE IMPLANT for the Management of Post-operative Pain

(29th Mar 2007) Innocoll Files US and Irish Patent Applications for its CollaRx® BUPIVACAINE IMPLANT for the Management of Post-operative Pain More

Innocoll Files CollaRx® GENTAMICIN SURGICAL IMPLANT in Canada and Receives Canadian Medical Devices Conformity Assessment System (CMDCAS) Certification

(23rd Mar 2007) Innocoll Files CollaRx® GENTAMICIN SURGICAL IMPLANT in Canada and Receives Canadian Medical Devices Conformity Assessment System (CMDCAS) Certification More

Innocoll Announces Filing of Investigational New Drug Application for its CollaRx® BUPIVACAINE IMPLANT for the Management of Post-operative Pain

(1st Mar 2007) Innocoll Announces Filing of Investigational New Drug Application for its CollaRx® BUPIVACAINE IMPLANT for the Management of Post-operative Pain More

Innocoll Receives BfArM Approval for a New Version of its CollaRx® Gentamicin Surgical Implant in Germany

(5th Feb 2007) Innocoll Receives BfArM Approval for a New Version of its CollaRx® Gentamicin Surgical Implant in Germany More

Innocoll Receives FDA Approval to Commence a Phase 2 Clinical Trial for the Topical Treatment of Infected Diabetic Foot Ulcers with its CollaRx® GENTAMICIN

(22nd Jan 2007) Innocoll Receives FDA Approval to Commence a Phase 2 Clinical Trial for the Topical Treatment of Infected Diabetic Foot Ulcers with its CollaRx® GENTAMICIN More

Innocoll Announces Expansion of the Distribution Partnership for its CollaRx® GENTAMICIN SURGICAL IMPLANT with BurnsAdler to Include Brazil,Dominican Republic and Mexico

(17th Jan 2007) Innocoll Announces Expansion of the Distribution Partnership for its CollaRx® GENTAMICIN SURGICAL IMPLANT with BurnsAdler to Include Brazil , Dominican Republic and Mexico More

Innocoll Announces Investigational New Drug Application Filing for its CollaRx Gentamicin as a Topical Treatment for Infected Diabetic Foot Ulcers

(9th Nov 2006) Innocoll Announces Investigational New Drug Application Filing for its CollaRx Gentamicin as a Topical Treatment for Infected Diabetic Foot Ulcers More

INNOCOLL, INC. RECEIVES FDA APPROVAL FOR CollaGUARD™, A COLLAGEN-BASED ADVANCED WOUND CARE PRODUCT

(12th Oct 2006) Innocoll, Inc. announced that its wholly-owned subsidiary, Innocoll Pharmaceuticals, has received US 510k approval for CollaGUARD™, an advanced wound care product based on Innocoll's proprietary CollaRx™ membrane technology. More

Innocoll Announces a Distribution Partnership for Central and South America and the Caribbean for its CollaRx™ GENTAMICIN SURGICAL IMPLANT

(1st Aug 2006) Innocoll Announces a Distribution Partnership for Central and South America and the Caribbean for its CollaRx™ GENTAMICIN SURGICAL IMPLANT More

Innocoll Announces Launch of a New Version of its CollaRx GENTAMICIN SURGICAL IMPLANT Specially Designed for Use in Cardiac Surgery

(26th Apr 2006) Innocoll, Inc. announced its sales and marketing subsidiary, Innocoll Pharmaceuticals Ltd., has launched a new version of its CollaRx Gentamicin Surgical Implant that is specially designed for maximum convenience and ease of use in cardiac surgery. More

Innocoll Announces Additional Distribution Arrangements in the Middle East and the Commonwealth of Independent States for CollaRx GENTAMICIN SURGICAL IMPLANT

(4th Apr 2006) Innocoll, Inc. announced it has recently signed distribution arrangements for its CollaRx GENTAMICIN SURGICAL IMPLANT in Iraq, Iran, Syria, Kazakhstan, Azerbaijan, Georgia, Uzbekistan, Tajikistan and Turkmenistan. More

Innocoll Announces a Distribution Agreement in the Russian Federation for

(30th Mar 2006) Innocoll, Inc. announced its sales and marketing subsidiary, Innocoll Pharmaceuticals Ltd., has recently signed a distribution agreement for its CollaRx GENTAMICIN SURGICAL IMPLANT in the Russian Federation. More

Innocoll Announces Initiation of Phase IIA Clinical Study of Bupivacaine Collagen Sponge

(28th Mar 2006) Innocoll, Inc. announced today that its Drug Delivery Division, Innocoll Technologies Ltd., has initiated a Phase IIA clinical study on the Bupivacaine collagen sponge under development for the management of post-operative pain following moderate/maj More

Innocoll Announces Approval to Promote its CollaRx GENTAMICIN SURGICAL IMPLANT in Norway

(7th Mar 2006) Innocoll, Inc. announced its sales and marketing subsidiary, Innocoll Pharmaceuticals Ltd., has obtained approval to promote its GENTAMICIN SURGICAL IMPLANT in Norway. More

Innocoll Announces Additional Distribution Agreements in the Middle East for CollaRx GENTAMICIN SURGICAL IMPLANT

(2nd Feb 2006) Innocoll, Inc. announced its sales and marketing subsidiary, Innocoll Pharmaceuticals Ltd., has recently signed two additional distribution agreements for its CollaRx GENTAMICIN SURGICAL IMPLANT in Yemen and Jordan. More

Innocoll Announces First Asian Distribution Agreement for CollaRx GENTAMICIN SURGICAL IMPLANT in Hong Kong

(27th Jan 2006) Innocoll, Inc. announced its sales and marketing subsidiary, Innocoll Pharmaceuticals Ltd., has recently signed a distribution agreement for its CollaRx GENTAMICIN SURGICAL IMPLANT in Hong Kong with Greyon Healthcare Company Ltd. More

INNOCOLL, INC. FILES US 510K FOR CollaGUARD™, A COLLAGEN-BASED ADVANCED WOUND CARE PRODUCT

(20th Dec 2005) Innocoll, Inc. announced that its wholly-owned subsidiary, Innocoll Pharmaceuticals, has filed a US 510k application for CollaGUARD™, an advanced wound care product based on Innocoll's proprietary CollaRx™ membrane technology. More

INNOCOLL ANNOUNCES NEW DISTRIBUTION AGREEMENTS FOR CollaRx GENTAMICIN SURGICAL IMPLANT

(12th Dec 2005) Innocoll, Inc. announced it's sales and marketing subsidiary, has recently signed distribution agreements for it's CollaRx GENTAMICIN SURGICAL IMPLANT in five additional territories; Turkey, Greece, Romania, Bulgaria, Bulgaria, and Nigeria. More

INNOCOLL, INC. ENTERS INTO AGREEMENT WITH MEDEXIS FOR DEVELOPMENT OF A WOUND HEALING PRODUCT

(8th Sep 2005) Innocoll, Inc. announced that its subsidiary, Innocoll Technologies, entered into an agreement with Medexis SA for development of a wound healing product. More

INNOCOLL, INC. ENTERS INTO AGREEMENT WITH SURGICAL-IOC FOR DEVELOPMENT OF ADHESION BARRIER PRODUCT

(28th Jul 2005) Innocoll, Inc. announced that its subsidiary, Innocoll Technologies, has entered into a development and distribution agreement with Surgical-IOC for the development of an adhesion barrier product based on Innocoll's CollaRx™ technology. More

INNOCOLL, INC. ANNOUNCES ACQUISITION OF MARKETING RIGHTS TO COLLARX GENTAMICIN SURGICAL IMPLANT

(14th Jul 2005) Innocoll, Inc. announced it has recently signed an agreement with Essex Chemie AG, an affiliated company of Schering-Plough Corporation (NYSE: SGP), under which it will obtain marketing rights to GENTAMICIN SURGICAL IMPLANT. More

More press releases

Senior management

To view this information, you must subscribe to Pharmalicensing Intelligence.

Related Reports

Market Research Reports provided by reports.innovaro.com

Innocoll, Inc. - Product Pipeline Review - Q4 2010

Nov 2010 - 39 pages - $500

Innocoll Technologies Ltd - Product Pipeline Analysis

Mar 2011 - 24 pages - $750

Innocoll Inc.-Therapeutic Competitors Report

Nov 2010 - 58 pages - $600

Innocoll Inc.-Detailed Product Pipeline

Jul 2010 - 42 pages - $750

Innocoll Inc.-Deals & Alliances Report

Nov 2010 - 30 pages - $600

Diabetic Foot Ulcers - Pipeline Review, Q1 2011

Mar 2011 - 53 pages - $500

Inguinal Hernia Global Clinical Trials Review, Q2, 2011

Jun 2011 - 54 pages - $1,000

Surgical Wound Infection Global Clinical Trials Review, Q1, 2011

Apr 2011 - 51 pages - $1,000

Hernia Global Clinical Trials Review, H2, 2011

Oct 2011 - 98 pages - $1,000

Advanced Wound Management Pipeline Technology and Market Forecasts to 2015

Oct 2009 - 47 pages - $2,000

Contact details

Ms Veronica Kelly
Marketing Executive
Innocoll Pharmaceuticals

Contact directly

Head office

Innocoll, Inc.
Midland Innovations Centre
Dublin Road
Athlone
Co. Westmeath
Ireland

Visit website

Contact head office

Company figures

Formed: 2004
Number of employees: 90

Related categories

Industry sector: Animal health / Medical device; Animal health / Pharmaceutical; Biotechnology / Gene therapy; Drug delivery / Topical; Drug delivery / Parenteral / Implant; Drug delivery / Parenteral / Sustained release; Drug delivery / Topical / Dermatological; Drug discovery / Bioinformatics; Medical device / Therapeutic device; Medical device / Therapeutic medical equipment / Surgical products; Pharmaceutical / Prescription; Pharmaceutical / OTC/Non-Prescription; Pharmaceutical / Generics
Therapeutic target: Accident and Trauma / Bone fractures; Accident and Trauma / Burns; Accident and Trauma / Hemorraghic trauma; Accident and Trauma / Tissue grafting; Accident and Trauma / Wound closure/surgical adhesive; Accident and Trauma / Wound/ulcer healing; Cardiovascular / Treatments / Cardiovascular surgery; Cardiovascular / Cardiovascular disorder (other) / Diabetic cardiovascular disease; Central Nervous System / Pain / Anesthesia; Central Nervous System / Pain / Pain management general; Central Nervous System / Pain / Pain, back upper/lower; Central Nervous System / Pain / Pain, chronic; Central Nervous System / Pain / Pain, inflammatory; Dermatological; Dermatological / Wound healing; Dermatological / Burns; Dermatological / Ulcer, diabetic; Hospital and Surgery / Adhesion; Hospital and Surgery / Anesthesia; Hospital and Surgery / Bleeding; Hospital and Surgery / Infection control; Hospital and Surgery / Surgery (other); Hospital and Surgery / Tissue grafting; Hospital and Surgery / Wound closure; Metabolism / Diabetic complications; Musculoskeletal / Trauma, physical; Musculoskeletal / Skeletal / Bone repair/regeneration; Oncology / Bladder cancer; Oncology / Bone cancer; Oncology / Brain cancer; Oncology / Breast cancer; Oncology / Colorectal cancer; Oncology / Colorectal cancer; Oncology / Colorectal cancer; Oncology / Ovarian cancer; Oncology / Prostate cancer; Oncology / Treatments / Chemotherapy; Oncology / Cancer side effects / Metastasis; Oncology / Colorectal cancer / Rectal cancer

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

(website) 172 queries took 141 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `company`	27	27	2
2	DESCRIBE `condet`	17	17	8
3	DESCRIBE `countrycode`	4	4	1
4	DESCRIBE `person`	15	15	4
5	DESCRIBE `account`	29	29	3
6	DESCRIBE `product_legacy`	6	6	7
7	DESCRIBE `sales_people`	6	6	1
8	DESCRIBE `profile`	14	14	1
9	DESCRIBE `currencies`	7	7	1
10	DESCRIBE `update_rec`	7	7	1
11	DESCRIBE `user`	24	24	1
12	DESCRIBE `enquiry`	14	14	1
13	DESCRIBE `module_types`	6	6	1
14	DESCRIBE `dms_companies`	26	26	1
15	DESCRIBE `dms_releases`	10	10	1
16	DESCRIBE `dms_categories`	4	4	0
17	DESCRIBE `dms_clinical_areas`	4	4	0
18	DESCRIBE `dms_categories_dms_releases`	2	2	0
19	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	0
20	DESCRIBE `dms_releases_sites`	5	5	0
21	DESCRIBE `licopp`	23	23	1
22	DESCRIBE `development_statuses`	5	5	0
23	DESCRIBE `category`	14	14	1
24	DESCRIBE `categories_sites`	5	5	0
25	DESCRIBE `categorisation`	8	8	1
26	DESCRIBE `licopps_sites`	3	3	1
27	DESCRIBE `service`	15	15	1
28	DESCRIBE `press_release`	13	13	1
29	DESCRIBE `press_releases_sites`	5	5	0
30	DESCRIBE `story`	12	12	1
31	DESCRIBE `sites_stories`	5	5	0
32	DESCRIBE `story_assoc`	4	4	0
33	DESCRIBE `companies_sites`	3	3	0
34	DESCRIBE `categories_users`	2	2	0
35	DESCRIBE `authority`	3	3	0
36	DESCRIBE `sites_users`	5	5	0
37	DESCRIBE `products`	8	8	1
38	DESCRIBE `sites`	5	5	0
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	0
40	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`, `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` = 4754 LIMIT 1	1	1	2
41	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` = 26507	1	1	0
42	SELECT `Country`.`uid`, `Country`.`country`, `Country`.`eu_member`, `Country`.`isocode` FROM `countrycode` AS `Country` WHERE `Country`.`uid` = 22	1	1	0
43	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`.`public`="Y" AND `PrimaryContact`.`company_primary_contact` = 1 AND `PrimaryContact`.`uid` = 28540	1	1	0
44	SELECT `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` = 4754	1	1	0
45	SELECT `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` = 4754	1	1	0
46	SELECT `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` = 4754	1	1	0
47	SELECT `CompanySite`.`id`, `CompanySite`.`company_id`, `CompanySite`.`site_id` FROM `companies_sites` AS `CompanySite` WHERE `CompanySite`.`company_id` = 4754	2	2	0
48	SELECT `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` = (4754) ORDER BY `Service`.`headline` ASC	0	0	0
49	SELECT `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` = (4754) ORDER BY `RegionalOffice`.`office` ASC	0	0	0
50	SELECT `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` = (4754) ORDER BY `SecondaryContact`.`surname` ASC	0	0	0
51	SELECT `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	77	77	0
52	SELECT `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` = 4754 ORDER BY `Inlicensing`.`title` ASC	0	0	1
53	SELECT `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` = 4754 ORDER BY `Outlicensing`.`title` ASC	5	5	1
54	SELECT `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`="4754" 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	5	5	5
55	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 ('376586', '394038', '376587', '376031', '340338') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE `Categorisation`.`cat_type` = "S"	17	17	0
56	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`.`company_id` = 4754 AND `Press`.`is_live` = 1 ORDER BY `Press`.`issued` DESC	59	59	40
57	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 ('1333447334_4f7acaa66741b', '1329480732_4f3e441cc2e60', '1328089169_4f290851cf01d', '1321358440_4ec25468ba113', '1319018074_4e9e9e5a8039f', '1318322688_4e940200e8576', '1316421690_4e77003a954e1', '1315822331_4e6ddafbde22c', '1279018066_4c3c44520c86c', '1276764622_4c19e1ce8b967', '1245314795_4a39feeb85832', '1238491789_49d1e28d55125', '1238427145_49d0e609afe9d', '1237198794_49be27ca282d3', '1226917833_492147c95b612', '1219670524_48b2b1fccefa8', '1218187155_489c0f93b3166', '1217238176_488d94a09e96e', '1216640572_4884763c4be80', '1209542481_48182751e8cd2', '1208418472_480700a86a196', '1205407970_47d910e21d7f8', '1203427546_47bad8da5a3cf', '1199441511_477e0667ec52b', '1199264431_477b52af134e0', '1197977948_4767b15ce309c', '1197886885_47664da5b004f', '1196253024_474d5f605210b', '1192614707_4715db33a803d', '1190807612_46fa483c8bcda', '1189597572_46e7d18475ae3', '1189425646_46e531eec48d4', '1189079165_46dfe87d132d4', '1186572766_46b9a9de93551', '1181131942_4666a4a623442', '1177417278_462df63e30942', '1176305293_461cfe8d7a654', '1175687745_46139241d4b6c', '1175170066_460bac1263c7e', '1174653290_4603c96ab6b40', '1172751613_45e6c4fd4820e', '1170680431_45c72a6fc39d6', '1169473571_45b4c02304e24', '1169044137_45ae32a995add', '1163092311_4553615713892', '1160664951_452e577778d54', '1154431272_44cf39282ff54', '1146053276_444f629c348f4', '1144151020_44325bec62c37', '1143720996_442bcc245013c', '1143550703_442932efac277', '1141733264_440d779004194', '1138900622_43e23e8ed4209', '1138364966_43da1226d9ff4', '1138290986_43d8f12b00378', '1138290112_43d8edc0600bf', '1126538978_43259ee2ced43', '1126101106_431ef07300785', '1121683314_42db8772a479d') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	103	103	1
58	SELECT 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 = 4754 AND c.restricted IS NULL ORDER BY cc.name, c.level	52	52	0
59	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` = 1 AND `Category`.`uid` = 1964 ORDER BY `par`.`lft` ASC	2	2	0
60	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` = (1964) ORDER BY `name` ASC	0	0	0
61	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` = 1 AND `Category`.`uid` = 1965 ORDER BY `par`.`lft` ASC	2	2	0
62	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` = (1965) ORDER BY `name` ASC	0	0	0
63	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` = 1 AND `Category`.`uid` = 1968 ORDER BY `par`.`lft` ASC	2	2	0
64	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` = (1968) ORDER BY `name` ASC	0	0	0
65	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` = 1 AND `Category`.`uid` = 1973 ORDER BY `par`.`lft` ASC	2	2	0
66	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` = (1973) ORDER BY `name` ASC	0	0	0
67	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` = 1 AND `Category`.`uid` = 1975 ORDER BY `par`.`lft` ASC	2	2	0
68	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` = (1975) ORDER BY `name` ASC	0	0	0
69	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` = 1 AND `Category`.`uid` = 1976 ORDER BY `par`.`lft` ASC	2	2	1
70	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` = (1976) ORDER BY `name` ASC	0	0	0
71	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` = 1 AND `Category`.`uid` = 510 ORDER BY `par`.`lft` ASC	2	2	0
72	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` = (510) ORDER BY `name` ASC	0	0	0
73	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` = 1 AND `Category`.`uid` = 513 ORDER BY `par`.`lft` ASC	2	2	1
74	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` = (513) ORDER BY `name` ASC	0	0	0
75	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` = 1 AND `Category`.`uid` = 309 ORDER BY `par`.`lft` ASC	2	2	0
76	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` = (309) ORDER BY `name` ASC	0	0	0
77	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` = 1 AND `Category`.`uid` = 1851 ORDER BY `par`.`lft` ASC	3	3	0
78	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` = (1851) ORDER BY `name` ASC	0	0	0
79	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` = 1 AND `Category`.`uid` = 1857 ORDER BY `par`.`lft` ASC	3	3	0
80	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` = (1857) ORDER BY `name` ASC	0	0	0
81	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` = 1 AND `Category`.`uid` = 596 ORDER BY `par`.`lft` ASC	3	3	0
82	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` = (596) ORDER BY `name` ASC	0	0	0
83	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` = 1 AND `Category`.`uid` = 597 ORDER BY `par`.`lft` ASC	3	3	0
84	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` = (597) ORDER BY `name` ASC	0	0	0
85	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` = 1 AND `Category`.`uid` = 1938 ORDER BY `par`.`lft` ASC	3	3	0
86	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` = (1938) ORDER BY `name` ASC	0	0	0
87	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` = 1 AND `Category`.`uid` = 1940 ORDER BY `par`.`lft` ASC	3	3	0
88	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` = (1940) ORDER BY `name` ASC	0	0	0
89	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` = 1 AND `Category`.`uid` = 1941 ORDER BY `par`.`lft` ASC	3	3	0
90	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` = (1941) ORDER BY `name` ASC	0	0	0
91	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` = 1 AND `Category`.`uid` = 603 ORDER BY `par`.`lft` ASC	1	1	0
92	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` = (603) ORDER BY `name` ASC	33	33	0
93	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` = 1 AND `Category`.`uid` = 615 ORDER BY `par`.`lft` ASC	2	2	0
94	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` = (615) ORDER BY `name` ASC	0	0	0
95	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` = 1 AND `Category`.`uid` = 1812 ORDER BY `par`.`lft` ASC	2	2	0
96	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` = (1812) ORDER BY `name` ASC	0	0	0
97	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` = 1 AND `Category`.`uid` = 1818 ORDER BY `par`.`lft` ASC	2	2	0
98	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` = (1818) ORDER BY `name` ASC	0	0	5
99	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` = 1 AND `Category`.`uid` = 379 ORDER BY `par`.`lft` ASC	2	2	0
100	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` = (379) ORDER BY `name` ASC	2	2	0
101	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` = 1 AND `Category`.`uid` = 356 ORDER BY `par`.`lft` ASC	3	3	0
102	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` = (356) ORDER BY `name` ASC	0	0	0
103	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` = 1 AND `Category`.`uid` = 360 ORDER BY `par`.`lft` ASC	3	3	0
104	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` = (360) ORDER BY `name` ASC	0	0	0
105	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` = 1 AND `Category`.`uid` = 380 ORDER BY `par`.`lft` ASC	3	3	0
106	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` = (380) ORDER BY `name` ASC	12	12	0
107	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` = 1 AND `Category`.`uid` = 305 ORDER BY `par`.`lft` ASC	2	2	0
108	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` = (305) ORDER BY `name` ASC	0	0	0
109	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` = 1 AND `Category`.`uid` = 1614 ORDER BY `par`.`lft` ASC	2	2	0
110	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` = (1614) ORDER BY `name` ASC	0	0	0
111	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` = 1 AND `Category`.`uid` = 1615 ORDER BY `par`.`lft` ASC	2	2	0
112	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` = (1615) ORDER BY `name` ASC	0	0	0
113	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` = 1 AND `Category`.`uid` = 1616 ORDER BY `par`.`lft` ASC	2	2	0
114	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` = (1616) ORDER BY `name` ASC	0	0	0
115	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` = 1 AND `Category`.`uid` = 1619 ORDER BY `par`.`lft` ASC	2	2	0
116	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` = (1619) ORDER BY `name` ASC	0	0	0
117	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` = 1 AND `Category`.`uid` = 1620 ORDER BY `par`.`lft` ASC	2	2	0
118	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` = (1620) ORDER BY `name` ASC	0	0	0
119	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` = 1 AND `Category`.`uid` = 1621 ORDER BY `par`.`lft` ASC	2	2	0
120	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` = (1621) ORDER BY `name` ASC	0	0	0
121	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` = 1 AND `Category`.`uid` = 1622 ORDER BY `par`.`lft` ASC	2	2	0
122	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` = (1622) ORDER BY `name` ASC	0	0	0
123	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` = 1 AND `Category`.`uid` = 454 ORDER BY `par`.`lft` ASC	2	2	0
124	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` = (454) ORDER BY `name` ASC	17	17	0
125	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` = 1 AND `Category`.`uid` = 317 ORDER BY `par`.`lft` ASC	3	3	0
126	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` = (317) ORDER BY `name` ASC	0	0	0
127	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` = 1 AND `Category`.`uid` = 1713 ORDER BY `par`.`lft` ASC	2	2	1
128	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` = (1713) ORDER BY `name` ASC	0	0	0
129	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` = 1 AND `Category`.`uid` = 1751 ORDER BY `par`.`lft` ASC	2	2	0
130	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` = (1751) ORDER BY `name` ASC	0	0	0
131	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` = 1 AND `Category`.`uid` = 1730 ORDER BY `par`.`lft` ASC	3	3	0
132	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` = (1730) ORDER BY `name` ASC	0	0	0
133	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` = 1 AND `Category`.`uid` = 1511 ORDER BY `par`.`lft` ASC	2	2	0
134	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` = (1511) ORDER BY `name` ASC	0	0	0
135	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` = 1 AND `Category`.`uid` = 1512 ORDER BY `par`.`lft` ASC	2	2	0
136	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` = (1512) ORDER BY `name` ASC	4	4	0
137	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` = 1 AND `Category`.`uid` = 1513 ORDER BY `par`.`lft` ASC	2	2	0
138	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` = (1513) ORDER BY `name` ASC	9	9	0
139	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` = 1 AND `Category`.`uid` = 1514 ORDER BY `par`.`lft` ASC	2	2	0
140	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` = (1514) ORDER BY `name` ASC	7	7	0
141	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` = 1 AND `Category`.`uid` = 1518 ORDER BY `par`.`lft` ASC	2	2	0
142	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` = (1518) ORDER BY `name` ASC	5	5	0
143	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` = 1 AND `Category`.`uid` = 1518 ORDER BY `par`.`lft` ASC	2	2	0
144	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` = (1518) ORDER BY `name` ASC	5	5	0
145	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` = 1 AND `Category`.`uid` = 1518 ORDER BY `par`.`lft` ASC	2	2	0
146	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` = (1518) ORDER BY `name` ASC	5	5	0
147	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` = 1 AND `Category`.`uid` = 1539 ORDER BY `par`.`lft` ASC	2	2	0
148	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` = (1539) ORDER BY `name` ASC	0	0	0
149	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` = 1 AND `Category`.`uid` = 1543 ORDER BY `par`.`lft` ASC	2	2	0
150	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` = (1543) ORDER BY `name` ASC	2	2	0
151	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` = 1 AND `Category`.`uid` = 573 ORDER BY `par`.`lft` ASC	3	3	0
152	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` = (573) ORDER BY `name` ASC	0	0	0
153	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` = 1 AND `Category`.`uid` = 1534 ORDER BY `par`.`lft` ASC	3	3	0
154	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` = (1534) ORDER BY `name` ASC	0	0	0
155	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` = 1 AND `Category`.`uid` = 1545 ORDER BY `par`.`lft` ASC	3	3	0
156	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` = (1545) ORDER BY `name` ASC	0	0	0
157	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` = 1 AND `Category`.`uid` = 299 ORDER BY `par`.`lft` ASC	2	2	0
158	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` = (299) ORDER BY `name` ASC	0	0	0
159	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` = 1 AND `Category`.`uid` = 300 ORDER BY `par`.`lft` ASC	2	2	0
160	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` = (300) ORDER BY `name` ASC	0	0	0
161	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` = 1 AND `Category`.`uid` = 301 ORDER BY `par`.`lft` ASC	2	2	0
162	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` = (301) ORDER BY `name` ASC	0	0	0
163	SELECT Authority.user_id FROM authority AS Authority WHERE company_id = 4754 ORDER BY primary_user DESC	3	3	0
164	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
165	UPDATE company SET viewed_counter = viewed_counter + 1 WHERE uid = 4754	1		21
166	DESCRIBE `statistics`	7	7	8
167	SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'company' LIMIT 1	1	1	6
168	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` = '4754' AND `company_id` = 4754 AND `module_type_id` = '2' AND `hit_date` = '2012-05-17' LIMIT 1	1	1	2
169	SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10676048	1	1	1
170	SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10676048	1	1	1
171	SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10676048	1	1	0
172	UPDATE `statistics` SET `id` = 10676048, `module_type_id` = '2', `company_id` = 4754, `business_object_id` = '4754', `count` = 4, `hit_date` = '2012-05-17', `is_aggregated` = 0 WHERE `statistics`.`id` = 10676048	1		0

(website) 172 queries took 141 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 `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` = 4754 LIMIT 1

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` = 26507

SELECT `Country`.`uid`, `Country`.`country`, `Country`.`eu_member`, `Country`.`isocode` FROM `countrycode` AS `Country` WHERE `Country`.`uid` = 22

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`.`public`="Y" AND `PrimaryContact`.`company_primary_contact` = 1 AND `PrimaryContact`.`uid` = 28540

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

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

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

SELECT `CompanySite`.`id`, `CompanySite`.`company_id`, `CompanySite`.`site_id` FROM `companies_sites` AS `CompanySite` WHERE `CompanySite`.`company_id` = 4754

SELECT `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` = (4754) ORDER BY `Service`.`headline` ASC

SELECT `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` = (4754) ORDER BY `RegionalOffice`.`office` ASC

SELECT `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` = (4754) ORDER BY `SecondaryContact`.`surname` ASC

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

SELECT `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` = 4754 ORDER BY `Inlicensing`.`title` ASC

SELECT `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` = 4754 ORDER BY `Outlicensing`.`title` ASC

SELECT `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`="4754" 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

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`.`company_id` = 4754 AND `Press`.`is_live` = 1 ORDER BY `Press`.`issued` DESC

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 ('1333447334_4f7acaa66741b', '1329480732_4f3e441cc2e60', '1328089169_4f290851cf01d', '1321358440_4ec25468ba113', '1319018074_4e9e9e5a8039f', '1318322688_4e940200e8576', '1316421690_4e77003a954e1', '1315822331_4e6ddafbde22c', '1279018066_4c3c44520c86c', '1276764622_4c19e1ce8b967', '1245314795_4a39feeb85832', '1238491789_49d1e28d55125', '1238427145_49d0e609afe9d', '1237198794_49be27ca282d3', '1226917833_492147c95b612', '1219670524_48b2b1fccefa8', '1218187155_489c0f93b3166', '1217238176_488d94a09e96e', '1216640572_4884763c4be80', '1209542481_48182751e8cd2', '1208418472_480700a86a196', '1205407970_47d910e21d7f8', '1203427546_47bad8da5a3cf', '1199441511_477e0667ec52b', '1199264431_477b52af134e0', '1197977948_4767b15ce309c', '1197886885_47664da5b004f', '1196253024_474d5f605210b', '1192614707_4715db33a803d', '1190807612_46fa483c8bcda', '1189597572_46e7d18475ae3', '1189425646_46e531eec48d4', '1189079165_46dfe87d132d4', '1186572766_46b9a9de93551', '1181131942_4666a4a623442', '1177417278_462df63e30942', '1176305293_461cfe8d7a654', '1175687745_46139241d4b6c', '1175170066_460bac1263c7e', '1174653290_4603c96ab6b40', '1172751613_45e6c4fd4820e', '1170680431_45c72a6fc39d6', '1169473571_45b4c02304e24', '1169044137_45ae32a995add', '1163092311_4553615713892', '1160664951_452e577778d54', '1154431272_44cf39282ff54', '1146053276_444f629c348f4', '1144151020_44325bec62c37', '1143720996_442bcc245013c', '1143550703_442932efac277', '1141733264_440d779004194', '1138900622_43e23e8ed4209', '1138364966_43da1226d9ff4', '1138290986_43d8f12b00378', '1138290112_43d8edc0600bf', '1126538978_43259ee2ced43', '1126101106_431ef07300785', '1121683314_42db8772a479d') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC

103

SELECT 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 = 4754 AND c.restricted IS NULL ORDER BY cc.name, c.level

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` = 1 AND `Category`.`uid` = 1964 ORDER BY `par`.`lft` 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` = (1964) ORDER BY `name` ASC

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

SELECT Authority.user_id FROM authority AS Authority WHERE company_id = 4754 ORDER BY primary_user DESC

164

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

165

UPDATE company SET viewed_counter = viewed_counter + 1 WHERE uid = 4754

166

DESCRIBE `statistics`

167

SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'company' LIMIT 1

168

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` = '4754' AND `company_id` = 4754 AND `module_type_id` = '2' AND `hit_date` = '2012-05-17' LIMIT 1

169

SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10676048

170

SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10676048

171

SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10676048

172

UPDATE `statistics` SET `id` = 10676048, `module_type_id` = '2', `company_id` = 4754, `business_object_id` = '4754', `count` = 4, `hit_date` = '2012-05-17', `is_aggregated` = 0 WHERE `statistics`.`id` = 10676048

(report) 2 queries took 2 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 ("Innocoll, Inc.") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Innocoll, Inc.") DESC , MarketResearchReport.published DESC LIMIT 10		10	10	1

(report) 2 queries took 2 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `reports`

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