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

APR Applied Pharma Research S.A.

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

Profile

APR Applied Pharma Research s.a. is an independent, international and integrated Healthcare Company headquartered in Switzerland with a subsidiary in Charlotte (NC, USA) and focused on three major areas: Delivering, Funding and Supporting Innovation in Healthcare.

In particular, APR develops and licenses innovative, value added and patented healthcare products and proprietary drug delivery systems primarily in the oral and topical fields;

APR also invests in companies or early stage innovative projects and provides a balanced mix of equity funding and/or financing together with APR’s development, scientific, technical, marketing, licensing and management skills and know how;

finally, APR supports biotech and pharmaceutical companies in the development of new pharmaceutical projects by providing on a contract basis added value, consultancy and R&D services under contract using a General Contractor approach.
APR has entered into licensing and partnership agreements with pharmaceutical companies in over 100 countries worldwide with international sales on a worldwide basis.

Partnering strategy/interests

APR is interested to evaluate any partnering opportunity with drug discovery as well as drug delivery companies focused in oral and topical products and interested to join forces and boost product development of new innovative drugs.

APR is also interested to evaluate in-licensing opportunities of promising early stage drug candidates in the oral, topical and transdermal areas.

Out-licensing

12,5 mg diclofenac K film coated immediate release tablets (OTC)

12,5 mg diclofenac K film coated immediate release tablets (OTC) More

2.5 mg and 5 mg Zolmitriptan ODF

Zolmitripan Oral Dispersible Film (ODF) is a a novel, non-mucoadhesive, fast dissolving oral dosage form of Zolmitriptan More

4 and 8 mg Ondansetron RapidFilm

4 and 8 mg Ondansetron ready for submission in EU (exp. Q4/08) using the proprietary RapidFilm drug delivery Technology securing fast dissolution in the oral cavity without the need of water More

5 and 10 mg Donepezil RapidFilm

5 and 10 mg Donepezil are under final development using the proprietary RapidFilm drug delivery Technology securing fast dissolution in the oral cavity without the need of water More

APR BioFilm

Biotechnology Product for Wound Healing More

APR Fastest for Migraine

The First Line of Therapy in Severe Migraine Attacks More

Cold Fleece Patch

Adhesive patch containing and delivering essential and balsamic oils for the symptomatic treatment of the common cold and nasal congestion More

Decongestant Cream Stick

Non grease, petroleum free, 3 ways usage decongestant cream More

Diclofenac potassium immediate release tablets 25 and 50 mg

25 and 50 mg diclofenac K film coated immediate release tablets More

Diclofenac potassium oral drops at 5%

The first pure, immediate release (Tmax in 13,68 min), completely palatable and free from aftertaste diclofenac potassium formulation in drops at 5% available on the market More

Diclofenac Sodium 25 mg. immediate release powder in Sachet

25mg dosage strenght for the OTC market More

Diclofenac Sodium 25 mg. immediate release tablets

25mg dosage strenght for the OTC market in film coated tablets More

Iron Supplement Chewable Tablets

Innovative CHEWABLE TABLETS Iron based More

Ketoprofen Patch

Adhesive Patch of 90 sq. cm. and containing as active ingredient 100 mg. of ketoprofen for the local treatment of traumatic injuries and extra-articular rheumatism More

Leg Health Gel, Spray and Tablets

The first combined treatment for an effective and natural answer to the wide-spread problem of leg fatigue, heaviness, ankle swelling and related capillary breackdown. More

Multilayered controlled release oral solid pharmaceutical forms

Multilayered controlled release oral solid pharmaceutical composition in tablet form suitable for oral administration comprising at least two layers containing active material in association with excipients and additives. More

RapidFilm Technology

RapidFilm: The solution for dissolving oral doses More

Sensitive Dehydrated Skins Cream

Hypoallergenic moisturizing cream for dermatitis and dehydrated skin espcially formulated for sensitive skin, thanks to the total absence of preservayives and perfumes More

Technology for Immediate release of oral forms based on Diclofenac

New pharmaceutical compositions for oral use containing diclofenac together with alkali metal carbonates and bicarbonates and particular flavouring substances. More

In-licensing

Oral, Topical or Transdermal products in any therapeutical area

APR is interested to in-license new early stage, innovative and patent protected products/technologies (preferably off patent or close to expiry) for oral, topical or transdermal administration More

Services

Dermo-cosmetic formulations

Wide and well established experience in the development of dermo-cosmetic formulations such as gels, creams, vegetable masks, lotions, cleansers, etc.

Fast release oral formulations

Wide and well established experience in the development of oral fast release formulations such as tablets, granulates, liquids, etc. using also taste masking technology when required.

Fast/Slow release oral formulations

Wide and well established experience in the development of oral multilayered controlled release formulations in tablets form.

Topical formulations

Wide and well established experience in the development of topical formulations such as gels, creams, patches, etc.

R&D

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

Partnerships

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

Deals

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

Press Releases

APR Applied Pharma Research ("APR") and Labtec GmbH ("Labtec") announce the European approval of Zolmitriptan Oral Dispersible Film (ODF)

(1st Mar 2012) APR and Labtec announce to have received on February 8th, 2012, the marketing authorization through a decentralized procedure (DCP) in 15 European countries of Zolmitriptan ODF, a film strip formulation containing 2.5mg and 5mg Zolmitriptan . It is their More

APR Applied Pharma Research s.a. , Labtec GmbH and Norgine announce the signature of an exclusive licensing agreement under which Norgine will market and distribute Setofilm(TM)

(18th Jan 2012) Norgine and APR, together with its joint venture partner Labtec, today announced that they have entered into an exclusive licensing agreement under which Norgine has acquired the commercialization rights in Europe and selected non-European countries in Mi More

APR Applied Pharma Research s.a. and Labtec GmbH announce Ondansetron Oral Dispersible Film (“ODF”) is now available for licensing in Europe and selected non European countries

(13th Jun 2011) APR and Labtec have regained the marketing and commercialization rights of Ondansetron Oral Dispersible Film (“ODF”) together with the brand name “Setofilm®” after the termination of the former license agreement with the French Company BioAlliance which h More

Galen Partners Invests in Nautilus Neurosciences, Inc.: Funding to Provide Growth Capital for the Launch of CAMBIA(TM)

(13th Apr 2010) Nautilus Neurosciences, a neurology-focused specialty pharmaceutical company headquartered in NJ (USA), announced that it received an investment from Galen Partners to support the growth of the company, and the upcoming launch of CAMBIA (TM) More

APR Applied Pharma Research s.a. (“APR”) and Labtec GmbH (“Labtec”) announce the European Approval of Ondansetron RapidFilm™, co-developed with MonoSol Rx

(23rd Mar 2010) Balerna (Switzerland), Langenfeld (Germany) and Warren (New Jersey) More

APR Applied Pharma Research SA. announces the signature of an exclusive licensing agreement with SciClone Pharmaceuticals Inc. for Ondansetron Rapidfilm™ for China and Vietnam

(28th Jul 2009) SciClone Pharmaceuticals Expands Portfolio by Licensing Ondansetron RapidFilmTM for Chinese Market

FOSTER CITY, CA and BALERNA, SWITZERLAND, July 27, 2009 More

Abdi Ibrahim , APR and Labtec GmbH have entered into an exclusive licensing agreement under which Abdi Ibrahim has the exclusive rights to market Ondansetron Rapidfilm® in Turkey.

(24th Jun 2009) APR and the leading pharmaceutical company in Turkey Abdi Ibrahim have entered into an exclusive license agreement for the promotion, distribution and marketing of Ondansetron Rapidfilm® in Turkey; terms of the deal were not disclosed. More

FDA has approved Cambia™, Potassium Diclofenac Powder for Oral Solution for the treatment of acute migraine attacks with or without aura, originally developed by APR Applied Pharma Research SA (APR)

(22nd Jun 2009) FDA has approved Cambia™, Potassium Diclofenac Powder for Oral Solution for the treatment of acute migraine attacks with or without aura, originally developed by APR Applied Pharma Research SA (APR) using the patented Dynamic Buffering Technology (DBT). More

BioAlliance Pharma Files for European Marketing Authorization for Ondansetron RapidFilm in Supportive Care in Cancer

(16th Feb 2009) BioAlliance Pharma Files for European Marketing Authorization for Ondansetron RapidFilm in Supportive Care in Cancer More

APR and Fidia have received IND approval from FDA for a new NSAID Matrix Patch product

(17th Nov 2008) Applied Pharma Research sa (APR), and Fidia Farmaceutici SpA (Fidia) today announced that the U.S. Food and Drug Administration (FDA) has accepted the Investigational New Drug (IND) application for the development of a 140mg Diclofenac Sodium Matrix More

APR Applied Pharma Research SA., together with its joint venture partner Labtec GmbH, announce the signature of an exclusive licensing agreement with BioAlliance Pharma SA. for Ondansetron RapidFilm

(4th Aug 2008) APR Applied Pharma Research SA., together with its joint venture partner Labtec GmbH, announce the signature of an exclusive licensing agreement with BioAlliance Pharma SA. for Ondansetron RapidFilm™ for Europe More

APR Applied Pharma Research s.a. (

(15th Apr 2008) The new APR website, www.apr.ch comes after a series of major development steps of the company, from the launch of the new laboratory in Balerna, just one year ago More

APR Applied Pharma Research sa & Labtec GmbH announce the successful completion of the pilot bioequivalence study of Donepezil RapidFilm™ further confirming the validity of this technology

(30th Jan 2008) APR Applied Pharma Research sa & Labtec GmbH announce the successful completion of the pilot bioequivalence study of Donepezil RapidFilm™ further confirming the validity of this technology More

APR Applied Pharma Research sa ("APR") and Labtec GmbH ("Labtec") announce the successful completion of the Pivotal Bioequivalence study for their proprietary Ondansetron RapidFilm™

(14th Jan 2008) APR Applied Pharma Research sa ("APR") and Labtec GmbH ("Labtec") announce the successful completion of the Pivotal Bioequivalence study for their proprietary Ondansetron RapidFilm™ More

APR Applied Pharma Research s.a. opens US office in Charlotte, North Carolina

(6th Sep 2007) APR Applied Pharma Research s.a. opens US office in Charlotte, North Carolina More

APR Applied Pharma Research s.a. announces a New Drug Application has been initiated for its Immediate Release Diclofenac-K 50mg Sachet for Migraine by its US licensee ProEthic Pharmaceuticals Inc.

(4th Jul 2007) APR Applied Pharma Research s.a. announces a New Drug Application has been initiated for its Immediate Release Diclofenac-K 50mg Sachet for Migraine by its US licensee ProEthic Pharmaceuticals Inc. More

SANOFI-AVENTIS launches in the Belgian Market an innovative balsamic decongestant cream for Cough & Cold developed by APR Applied Pharma Research SA.

(13th Apr 2007) SANOFI-AVENTIS launches in the Belgian Market an innovative balsamic decongestant cream for Cough & Cold developed by APR Applied Pharma Research SA. More

APR Applied Pharma Research s.a. and Labtec GmbH announce positive results of the Ondansetron RapidFilm™ pilot bioequivalence study. Submission of registration dossier anticipated for Q4/2007

(1st Mar 2007) APR has entered into a new strategic partnership with Labtec on the development and licensing of the RapidFilm™, an oral rapid-dissolving film technology. More

APR Applied Pharma Research s.a. has successfully completed the development of Veloderm, an innovative biotech wound dressing and transferred the worldwide marketing rights to Medestea Internazionale.

(1st Feb 2007) APR has successfully designed and completed the development of Veloderm, an innovative Biotechnology device for wound healing and licensed to Medestea the exclusive worldwide marketing rights More

APR announces Successful US Phase III Trial results for its original migraine product

(9th Jan 2007) APR announces today successful Phase III clinical trial results for PRO-513, its product candidate for the treatment of migraine headaches licensed in 2005 to the Montgomery (Alabama) based ProEthic Pharmaceuticals, Inc. More

APR Applied Pharma Research s.a. (

(14th Mar 2006) APR of Switzerland and Labtec of Germany have signed a new strategic Cooperation and Partnership Agreement for the development and licensing of the RapidFilm™ Drug Delivery Technology More

Endo Licenses Topical Ketoprofen Patch for US and Canada

(14th Mar 2005) Endo announced today that it has entered into an agreement with ProEthic to commercialize the Ketoprofen Patch developed by APR More

APR's Patented Diclofenac 25 mg OTC Immediate Release tablets launched in New Zealand by Douglas Pharmaceuticals Ltd.

(23rd Sep 2004) Diclofenac Potassium 25 mg film-coated tablets, recently approved by MEDSAFE in New Zealand as OTC medication, have been launched in New Zealand by Douglas Pharmaceuticals Ltd., under the license of APR. More

APR Applied Pharma Research SA and Novartis Pharma AG have signed a global license agreement, following successful clinical trials programme, for use of APR's quick release diclofenac delivery system.

(9th Sep 2004) Applied Pharma Research s.a. (APR) has entered a global (except USA and Canada) and exclusive Licence Agreement with Novartis Pharma AG for the further development and marketing of a modified, immediate release formulation of Diclofenac Potassium. More

APR new site now available on the web at www.apr.ch

(27th Feb 2004) APR Applied Pharma Research SA, Switzerland, launches totally renewed web site. More

Ketoprofen Patch clinical efficacy to be officially presented to the rheumatologists associations in USA and France

(13th Oct 2003) APR Applied Pharma Research will soon present results of the phase III efficacy trials with ketoprofen patch in the treatment of tendinites and ankle sprains at the annual meetings of the American College of Rheumatology and of the French Society of More

APR Applied Pharma Research and ProEthic sign licensing agreement for the marketing of a Ketoprofen Patch in USA

(8th Apr 2003) ProEthic Laboratories, LLC and Applied Pharma Research have signed a licensing agreement for a once-daily transdermal version of ketoprofen, a member of the NSAID class of drugs that also includes the popular Celebrex and Vioxx brands. More

European Patent granted to APR Drug Delivery Technology for the preparation of granulates for stable aqueous dispersions of hydrophobic substances.

(27th Mar 2003) On January 15th 2003, the European Patent Office has granted final patent protection (EP 1275377A1) to APR's proprietary technology for the preparation of granulates containing liposoluble substances. More

APR PUBLISHES VERY SUCCESSFUL CLINICAL RESULTS ON TISSUE ABSORPTION AND DISTRIBUTION OF KETOPROFEN PATCH IN PATIENTS UNDERGOING KNEE ARTHROSCOPY OR ENDOSCOPIC CARPAL LIGAMENT RELEASE

(24th Feb 2003) The Swiss based Drug Delivery Company APR Applied Pharma Research has recently published very successful results on tissue absorption and distribution of ketoprofen TDS patch. More

European Patent granted for APR Imemdiate Release Technology

(11th Jun 2002) APR receives European Patent Protection for its proprietary technology for immediate release of Diclofenac More

Zambon Group and APR Applied Pharma Research sign Strategic Alliance

(12th Feb 2002) Zambon and APR have recently signed a Strategic Alliance and License Agreement for the further development and marketing of innovative patented consumer oriented products in patch form. More

Cold Fleece Patch successfully launched in the major European Countries

(22nd Jan 2002) The Cold Fleece Patch, jointly developed by APR Applied Pharma Research of Switzerland and Labtec GmbH of Germany has been successfully launched in the major EU countries during the last Quarter of 2001. More

APR has filed a new patent application for the preparation of stable aqueous dispersions of Hydrophobic substances, particularly Megestrol Acetate for the treatment of cachexia in patients with AIDS.

(10th Sep 2001) APR has patented a new process and technology for the preparation of granulates containing liposoluble and hydrphobic drugs, preferably Megestrol Acetate, which shows a rapid, stable water dispersibility without precipitation or flocculation. More

APR has submitted for registration the Diclofenac K 5% Oral Drops File in The Netherlands

(3rd Sep 2001) In early August, APR has applied for registration of its patented product in Oral Drops containing Diclofenac Potassium at 5% concentration; registration approval is expected during the 1Q2002. A MRP in the EU will follow the Dutch approval. More

Partnership Agreement between Labtec GmbH and APR for a new NSAID Patch

(14th Jul 2000) The German R&D Company Labtec GmbH and the Swiss R&D Company APR Applied Pharma Research S.A. have recently partnered together for the further development, registration and licensing out of a high tech., top of the art NSAID topical patch for More

APR announces launch of 50mg diclofenac potassium sachet formulation in Italy by Novartis Farma S.p.A.

(12th Jul 2000) APR Applied Pharma Research announces a 50mg diclofenac potassium sachet for drinkable solution, developed according to its new patented drug delivery technology useful to improve efficacy and safety of fast acting formulations containing diclofenac More

The first technology for immediate, bioregulated release of diclofenac in new pharmaceutical forms

(16th Apr 1999) APR Applied Pharma Research has reported in vitro and in vivo successful results to validate and support its new proprietary drug delivery technology to improve efficacy and safety of fast acting formulations containing diclofenac as its main active More

More press releases

Related Reports

Market Research Reports provided by reports.innovaro.com

Applied Extrusion Technologies, Inc.: SWOT Analysis & Company Profile

Nov 2010 - 13 pages - $99

Applied Biosystems Group: SWOT Analysis & Company Profile

Feb 2010 - 19 pages - $99

Applied Energetics, Inc.: SWOT Analysis & Company Profile

Dec 2010 - 24 pages - $99

Applied Materials, Inc.: SWOT Analysis & Company Profile

Sep 2010 - 24 pages - $99

Applied Science Products, Inc.: SWOT Analysis & Company Profile

Feb 2011 - 20 pages - $99

Applied Industrial Technologies, Inc.: SWOT Analysis & Company Profile

Jan 2011 - 26 pages - $99

Applied Industrial Technologies Inc - SWOT Analysis

May 2010 - 28 pages - $125

Applied Materials, Inc. - SWOT Analysis

May 2010 - 34 pages - $125

Applied Geomechanics Inc. - Company Capsule

Nov 2011 - 7 pages - $75

Applied Geotechnical Engineering Ltd - Company Capsule

Nov 2011 - 7 pages - $75

Contact details

Mr Paolo Galfetti
CEO

Contact directly

Full contact list

Head office

APR Applied Pharma Research S.A.
Via Corti 5
Balerna
6828
Switzerland

Visit website

Contact head office

Full offices list

Company figures

Formed: 1990
Annual Turnover: 10'000'000 (2009)
Number of employees: 31

Related categories

Industry sector: Drug delivery / Oral solid; Drug delivery / Topical; Drug delivery / Oral solid / Tablet; Drug delivery / Oral solid / Sustained Release; Drug delivery / Oral liquid / Suspension; Drug delivery / Oral liquid / Syrup; Drug delivery / Systemic / Transdermal system; Pharmaceutical / Prescription; Pharmaceutical / OTC/Non-Prescription; Pharmaceutical / Generics; Pharmaceutical / Personal Care; Service / Clinical research; Service / Product development; Service / Regulatory affairs
Therapeutic target: Cardiovascular; Central Nervous System; Central Nervous System / Pain / Pain management general; Central Nervous System / Pain / Pain, acute; Central Nervous System / Pain / Pain, back upper/lower; Central Nervous System / Pain / Pain, cancer; Central Nervous System / Pain / Pain, inflammatory; Dermatological; Gastrointestinal; Infectious diseases; Infectious diseases / Diseases / Infection, viral (other); Infectious diseases / Bacteria or virus / Herpes simplex virus; Infectious diseases / Diseases / HIV; Metabolism; Musculoskeletal; Musculoskeletal / Back pain; Musculoskeletal / Skeletal / Arthritis (non-specific); Musculoskeletal / Skeletal / Rheumatoid arthritis; Musculoskeletal / Skeletal / Rheumatic disorders (other); Oncology; Oncology / Cancer (other); Respiratory

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) 143 queries took 2013 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `company`	27	27	12
2	DESCRIBE `condet`	17	17	7
3	DESCRIBE `countrycode`	4	4	1
4	DESCRIBE `person`	15	15	1
5	DESCRIBE `account`	29	29	1
6	DESCRIBE `product_legacy`	6	6	1
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	0
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	1
17	DESCRIBE `dms_clinical_areas`	4	4	1
18	DESCRIBE `dms_categories_dms_releases`	2	2	0
19	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	1
20	DESCRIBE `dms_releases_sites`	5	5	1
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	1
25	DESCRIBE `categorisation`	8	8	1
26	DESCRIBE `licopps_sites`	3	3	5
27	DESCRIBE `service`	15	15	1
28	DESCRIBE `press_release`	13	13	1
29	DESCRIBE `press_releases_sites`	5	5	1
30	DESCRIBE `story`	12	12	4
31	DESCRIBE `sites_stories`	5	5	1
32	DESCRIBE `story_assoc`	4	4	9
33	DESCRIBE `companies_sites`	3	3	1
34	DESCRIBE `categories_users`	2	2	1
35	DESCRIBE `authority`	3	3	1
36	DESCRIBE `sites_users`	5	5	1
37	DESCRIBE `products`	8	8	1
38	DESCRIBE `sites`	5	5	11
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	8
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` = 381 LIMIT 1	1	1	4
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` = 381	1	1	1
42	SELECT `Country`.`uid`, `Country`.`country`, `Country`.`eu_member`, `Country`.`isocode` FROM `countrycode` AS `Country` WHERE `Country`.`uid` = 41	1	1	2
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` = 3	1	1	1
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` = 381	1	1	1
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` = 381	1	1	6
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` = 381	1	1	1
47	SELECT `CompanySite`.`id`, `CompanySite`.`company_id`, `CompanySite`.`site_id` FROM `companies_sites` AS `CompanySite` WHERE `CompanySite`.`company_id` = 381	2	2	1
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` = (381) ORDER BY `Service`.`headline` ASC	4	4	1
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` = (381) ORDER BY `RegionalOffice`.`office` ASC	1	1	1
50	SELECT `Country`.`uid`, `Country`.`country`, `Country`.`eu_member`, `Country`.`isocode` FROM `countrycode` AS `Country` WHERE `Country`.`uid` = 180	1	1	1
51	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` = (381) ORDER BY `SecondaryContact`.`surname` ASC	3	3	1
52	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	1
53	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` = 381 ORDER BY `Inlicensing`.`title` ASC	1	1	3
54	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` = 381 ORDER BY `Outlicensing`.`title` ASC	19	19	5
55	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`="381" 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	4	4	41
56	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 ('1013638964_3c6ae7344b176', '1049788177_3e927f110f255', '1089797271_40f4fc973575b', '1101293534_41a467de95304') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE `Categorisation`.`cat_type` = "S"	30	30	1
57	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` = 381 AND `Press`.`is_live` = 1 ORDER BY `Press`.`issued` DESC	37	37	248
58	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 ('1330609688_4f4f7e18cd689', '1326893322_4f16c90a1054c', '1308060708_4df76c248ed8b', '1271166370_4bc475a2dca44', '1269378003_4ba92bd36ca16', '1248764590_4a6ea2aea243b', '1246007348_4a4490347bb8e', '1245692674_4a3fc302a9a57', '1234870246_499a9fe686ae1', '1226928237_4921706dda7ea', '1218015746_489972023cada', '1208278599_4804de474ae72', '1201709587_47a0a21334720', '1200311931_478b4e7b43490', '1189085248_46e00040399b4', '1183542008_468b6af8e537b', '1176471787_461f88ebb113a', '1172766581_45e6ff75d6fdb', '1170345564_45c20e5cc5a90', '1168331554_45a3532213973', '1142010519_4411b297dad17', '1110804985_423589f90d60c', '1095943087_4152c3af0c8e8', '1094742172_4140709c0af22', '1077877144_403f1998a5ade', '1066043242_3f8a876a670b0', '1049790189_3e9286ed8bbd5', '1048772107_3e82fe0b1e4ef', '1046103531_3e5a45ebd10b6', '1020689404_3cd67bfcdaf2f', '1013417399_3c6785b72fa05', '1011262214_3c46a306a4548', '999013338_3b8bbbda35687', '998927891_3b8a6e13929ec', '963586279_396f28e7dae69', '963409313_396c75a104427', '924263314_37172392cd961') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	264	264	29
59	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 = 381 AND c.restricted IS NULL ORDER BY cc.name, c.level	37	37	1
60	SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`uid` = 582 ORDER BY `par`.`lft` ASC	1	1	2
61	SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` = (582) ORDER BY `name` ASC	10	10	0
62	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` = 595 ORDER BY `par`.`lft` ASC	1	1	0
63	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` = (595) ORDER BY `name` ASC	9	9	0
64	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
65	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
66	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` = 1936 ORDER BY `par`.`lft` ASC	3	3	1
67	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` = (1936) ORDER BY `name` ASC	0	0	1
68	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
69	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
70	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` = 1939 ORDER BY `par`.`lft` ASC	3	3	1
71	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` = (1939) ORDER BY `name` ASC	0	0	0
72	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
73	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
74	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` = 739 ORDER BY `par`.`lft` ASC	3	3	0
75	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` = (739) ORDER BY `name` ASC	0	0	0
76	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	1
77	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
78	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` = 320 ORDER BY `par`.`lft` ASC	2	2	0
79	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` = (320) ORDER BY `name` ASC	9	9	1
80	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
81	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
82	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` = 321 ORDER BY `par`.`lft` ASC	3	3	5
83	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` = (321) ORDER BY `name` ASC	9	9	0
84	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` = 340 ORDER BY `par`.`lft` ASC	3	3	0
85	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` = (340) ORDER BY `name` ASC	0	0	0
86	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` = 349 ORDER BY `par`.`lft` ASC	3	3	0
87	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` = (349) ORDER BY `name` ASC	0	0	0
88	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` = 351 ORDER BY `par`.`lft` ASC	3	3	0
89	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` = (351) ORDER BY `name` ASC	0	0	1
90	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` = 378 ORDER BY `par`.`lft` ASC	3	3	0
91	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` = (378) ORDER BY `name` ASC	0	0	0
92	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` = 616 ORDER BY `par`.`lft` ASC	1	1	0
93	SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` = (616) ORDER BY `name` ASC	28	28	0
94	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` = 562 ORDER BY `par`.`lft` ASC	1	1	0
95	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` = (562) ORDER BY `name` ASC	7	7	0
96	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` = 567 ORDER BY `par`.`lft` ASC	3	3	0
97	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` = (567) ORDER BY `name` ASC	0	0	0
98	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` = 1668 ORDER BY `par`.`lft` ASC	3	3	0
99	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` = (1668) ORDER BY `name` ASC	0	0	1
100	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` = 1669 ORDER BY `par`.`lft` ASC	3	3	0
101	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` = (1669) ORDER BY `name` ASC	0	0	1
102	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` = 654 ORDER BY `par`.`lft` ASC	1	1	0
103	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` = (654) ORDER BY `name` ASC	24	24	0
104	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` = 662 ORDER BY `par`.`lft` ASC	1	1	0
105	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` = (662) ORDER BY `name` ASC	21	21	4
106	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` = 1726 ORDER BY `par`.`lft` ASC	2	2	0
107	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` = (1726) ORDER BY `name` ASC	0	0	1
108	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` = 663 ORDER BY `par`.`lft` ASC	3	3	0
109	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` = (663) ORDER BY `name` ASC	0	0	0
110	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` = 665 ORDER BY `par`.`lft` ASC	3	3	0
111	SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` = (665) ORDER BY `name` ASC	0	0	0
112	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` = 666 ORDER BY `par`.`lft` ASC	3	3	1
113	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` = (666) ORDER BY `name` ASC	0	0	2
114	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` = 572 ORDER BY `par`.`lft` ASC	1	1	79
115	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` = (572) ORDER BY `name` ASC	28	28	4
116	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` = 574 ORDER BY `par`.`lft` ASC	2	2	7
117	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` = (574) ORDER BY `name` ASC	0	0	2
118	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	2
119	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	1
120	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	1
121	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	9
122	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	1
123	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
124	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` = 302 ORDER BY `par`.`lft` ASC	2	2	7
125	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` = (302) ORDER BY `name` ASC	0	0	1
126	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` = 679 ORDER BY `par`.`lft` ASC	1	1	2
127	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` = (679) ORDER BY `name` ASC	29	29	15
128	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` = 537 ORDER BY `par`.`lft` ASC	2	2	5
129	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` = (537) ORDER BY `name` ASC	0	0	0
130	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` = 553 ORDER BY `par`.`lft` ASC	2	2	0
131	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` = (553) ORDER BY `name` ASC	0	0	0
132	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` = 557 ORDER BY `par`.`lft` ASC	2	2	0
133	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` = (557) ORDER BY `name` ASC	0	0	0
134	SELECT Authority.user_id FROM authority AS Authority WHERE company_id = 381 ORDER BY primary_user DESC	1	1	1
135	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
136	UPDATE company SET viewed_counter = viewed_counter + 1 WHERE uid = 381	1		1374
137	DESCRIBE `statistics`	7	7	1
138	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	9
139	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` = '381' AND `company_id` = 381 AND `module_type_id` = '2' AND `hit_date` = '2012-05-17' LIMIT 1	1	1	3
140	SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10676185	1	1	1
141	SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10676185	1	1	2
142	SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10676185	1	1	13
143	UPDATE `statistics` SET `id` = 10676185, `module_type_id` = '2', `company_id` = 381, `business_object_id` = '381', `count` = 4, `hit_date` = '2012-05-17', `is_aggregated` = 0 WHERE `statistics`.`id` = 10676185	1		15

(website) 143 queries took 2013 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` = 381 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` = 381

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

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

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

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

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

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

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

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

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` = (381) 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` = 381 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` = 381 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`="381" 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` = 381 AND `Press`.`is_live` = 1 ORDER BY `Press`.`issued` DESC

248

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 ('1330609688_4f4f7e18cd689', '1326893322_4f16c90a1054c', '1308060708_4df76c248ed8b', '1271166370_4bc475a2dca44', '1269378003_4ba92bd36ca16', '1248764590_4a6ea2aea243b', '1246007348_4a4490347bb8e', '1245692674_4a3fc302a9a57', '1234870246_499a9fe686ae1', '1226928237_4921706dda7ea', '1218015746_489972023cada', '1208278599_4804de474ae72', '1201709587_47a0a21334720', '1200311931_478b4e7b43490', '1189085248_46e00040399b4', '1183542008_468b6af8e537b', '1176471787_461f88ebb113a', '1172766581_45e6ff75d6fdb', '1170345564_45c20e5cc5a90', '1168331554_45a3532213973', '1142010519_4411b297dad17', '1110804985_423589f90d60c', '1095943087_4152c3af0c8e8', '1094742172_4140709c0af22', '1077877144_403f1998a5ade', '1066043242_3f8a876a670b0', '1049790189_3e9286ed8bbd5', '1048772107_3e82fe0b1e4ef', '1046103531_3e5a45ebd10b6', '1020689404_3cd67bfcdaf2f', '1013417399_3c6785b72fa05', '1011262214_3c46a306a4548', '999013338_3b8bbbda35687', '998927891_3b8a6e13929ec', '963586279_396f28e7dae69', '963409313_396c75a104427', '924263314_37172392cd961') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC

264

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 = 381 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` = 582 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` = (582) 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

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

135

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

136

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

1374

137

DESCRIBE `statistics`

138

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

139

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

140

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

141

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

142

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

143

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

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