Distribuidores

Imprimir

España

ESPAÑA

Cambridge University Press

C/José Abascal, 56, 1.ª planta
28003 Madrid
Tel.: 913604565 - Fax: 913604570
E-mail: iberia@cambridge.org

 

INTERNACIONAL

CELESA
Laurel, 21
28005 Madrid - España
Tel.: 915170170 - Fax: : 915173481
E-mail: pedidos@celesa.com
http://www.celesa.com

 

Europa

ALEMANIA

Petersen Buchimport GmbH
Hamburger Straße 213
22083 Hamburg
Teléfono: +49 (0)4071003-0 Fax: +49 (0)4071003141
E-mail: karin.simon@petersen-buchimport.com
www.petersen-buchimport.com


AUSTRIA

Librería Hernández
Gentzgasse, 128
1180 Wien - Austria
Teléfono: +43 (0)14789259; Fax: +43 (0)1478925915

E-mail: libreria@libreria.at

Petersen Buchimport GmbH
Hamburger Straße 213
22083 Hamburg
Teléfono: +49 (0)4071003-0 Fax: +49 (0)4071003141 
E-mail: : karin.simon@petersen-buchimport.com
http://www.petersen-buchimport.com

BÉLGICA

Boekhandel Walry
Zwijnaardsesteenweg, 6
9000 Gent - Bélgica
Teléfono: +32 (0)92229167; Fax: +32 (0)92210356
E-mail: boekhandel@walry.be
http://www.walry.be/spaans

BOSNIA

Buybook
Radiceva 4
71000 Sarajevo
Bosnia & Herzegovina
Teléfono: +387 33 550 495; Fax: +387 33 550 496
E-mail: iris.kahvic@buybook.ba
www.buybook.ba

BULGARIA

Educational Centre
63, W. Gladstone str.
Sofia - Bulgaria
Teléfono: 359 (0)29809033; Fax: +359 (0)29809015
E-mail: office@educationalcentre.bg
http://www.educationalcentre.bg

Colibrí LTD
36, Ivan Vazov St.
1000 Sofia - Bulgaria
Teléfono:
+359 (0)9888781; Fax: +359 (0)9888781

E-mail: gpopov@colibri.bg
http://www.colibri.bg

CROACIA

Algoritam, LTD.
Harambasicéva, 19
10000 Zagreb - Croacia
Teléfono:
+385 (0)12359303/ +385 (0)12359302

Fax: +385 (0)12335955
E-mail: ana.dobricic@algoritam.hr
martina.kovacic@algoritam.hr

DINAMARCA

English Center
Borup Byvej 162
8920 Randers NV - Dinamarca
Teléfono:
+45 (0)86432246

E-mail: ec@englishcenter.dk
http://www.englishcenter.dk

Bierman & Bierman ApS
Vestergade 126 - DK
7200 Grindsted - Dinamarca
Teléfono: 75320288 Fax: 75321548

E-mail: mail@bierman.dk
http://www.bierman.dk

ESLOVAQUIA

Oxico jazykové knihy
Panónska cesta 6 851 01 Bratislava - Eslovaquia
Teléfono:
+421 (0)254410992/ +421 (0)54410993

Fax: +421(0) 254410994
E-mail: oxico@oxico.sk
http://www.oxico.sk

ESLOVENIA

Mladinska Knjiga Trgovina d.d.o.

Center Oxford Bookshop
Slovenska cesta, 29
1000 Ljubljana - Eslovenia
Teléfono:
+386 (0)15887514 ; Fax: +386 (0)15887 540

E-mail: marjeta.juvan@mk-trgovina.si
http://www.centeroxford.com

ESTONIA

Allecto Ltd
Juhkentali Str. 8
10132 Tallinn - Estonia
Teléfono:
+372(0)6277230; Fax:+372 (0)6277233

E-mail: allecto@allecto.ee

FINLANDIA

Stockmann Akateeminen Kirjakauppa
Keskuskatu, 1
Helsinki Fin-00100 - Finlandia
Teléfono: +358 (0)91214213; Fax: +358 (0)91214440
E-mail: asiakaspalvelu@akateeminen.com
http://www.akateeminen.com

FRANCIA

SODIS
128 Avenue du Maréchal de Lattre de Tassigny
CS 30113
77405 Lagny Sur Marne Cedex – Francia
Teléfono: +33 (0)1 60 07 82 00 Fax: +33 (0)1 64 30 92 22
E-mail: portail@sodis.fr
www.sodis.fr

Attica
11, Rue Boussingault CS 51309
75214 París cedex 13 - Francia
Teléfono.: 149492731 - Fax: 148064785
E-mail: info@attica.fr
www.attica.fr

Librairie DECITRE
29, place Bellecour
69002 Lyon - Francia
Teléfono.: +33 (0) 4 26 68 00 13
E-mail: bellecour29@decitre.fr
www.decitre.fr

Librairie MOLLAT
15, rue Vital-Carles
33080 Bordeaux - Francia
Teléfono: +33 (0) 556564011
www.mollat.com

GRECIA

Express Publishing
9 Mac Millan Street
11144 Atenas - Grecia
Teléfono:
+30 (0)2102120800; Fax: +30 (0)2102015444

E-mail: eltconsultants@expresspublishing.gr
http://www.expresspublishing.gr

Express Publishing
173-175 Ethnikis Antistaseos St.
55134 Salónica - Grecia
Teléfono: +30 (0)2310477089/ 477086/ 471765;
Fax: +30 (0)2310476689
E-mail: expresspublis@the.forthnet.gr
http://www.expresspublishing.gr

HOLANDA

Practicum Educatief
H. A. Lorentzstraat, 112
331 EE Zwijndrecht - Holanda
Teléfono: +31 (0)786191111; Fax: +31 (0)786190502
E-mail: info@practicum-educatief.nl

Intertaal BV
Transistorstraat, 80
1322 CH Almere - Holanda
Teléfono: 
+31 (0)365471680; Fax: +31 (0)365471582

E-mail: klantenservice@intertaal.nl
http://www.intertaal.nl

El Rincón del Libro
Overtoom 8-8a
1054 HH Amsterdam
Países Bajos
Teléfono: +31 (0)205890971; Fax: +31 (0)653391235
E-mail: info@elrincondellibro.nl
http://www.elrincondellibro.nl

HUNGRÍA

Libra Books
Kölcsey u.2
1085 Budapest - Hungría
Teléfono: +36 (0)12675777; Fax: +36 (0)14830660
E-mail: libra@mail.datanet.hu
http://www.nyelvkonyvbolt.hu

IRLANDA

International Books
18 South Frederick Street
Dublin 2 - Ireland
Teléfono:
+353 (0)16799375; Fax: +353 (0)16799376

E-mail: info@internationalbooks.ie
http://www.internationalbooks.ie

ITALIA

Rizzoli Libri SpA Divisione Education
Via L. Battistotti Sassi, 11/A
20133 Milano - Italia

E-mail: UffcioCommerciale.Scuola@rizzolilibri.it

http://www.rizzolieducation.it

MACEDONIA

PROSVETNO DELO AD - Skopje
ul. "Dimitrie Cupovski", 15
1000 Skopje, R. Macedonia
Teléfono:
+389 02 3117 255; Fax: +389 02 3220 373

E-mail: nadica_m@prodelo.com.mk

POLONIA

Nowela Sp. Z.o.o.
Ul. Junikowska, 64
60-163 Poznan - Polonia
Teléfono:
+48 (0)618560295; Fax: +48 (0)618537715

E-mail: nowela@nowela.pl
http://www.nowela.pl

PORTUGAL

Cambridge University Press
C/José Abascal, 56, 1.ª planta
28003 Madrid
Tel.: 913604565 - Fax: 913604570
E-mail: iberia@cambridge.org

REINO UNIDO

The European Bookshop
5 Warwick street
Londres W1B 5LU - Reino Unido
Teléfono.: 2077345259 - Fax: 2072871720
E-mail: mrg@esb.co.uk

LBOL. Language Books Online Ltd.
25 Pendle Road - Great Harwood
Blackburn BB6 7TN - Reino Unido
Tel.: 800 002 9992 / 1254 883798
Fax: 01254 883798
E-mail: enquiries@lbol.co.uk

REPÚBLICA CHECA

ILC Czechoslovakia, s.r.o.
Ripska 15a
627 00 Brno - Republica Checa
Teléfono:
+420 (0)545215669; Fax: +420 (0)545240889
E-mail: shop@ilc.cz
http://www.ilc.cz

RUMANÍA

Carturesti
13-15 Verona street, sector 1., Pc 010312
Bucharest - Rumanía
Teléfono:
+40 (0)213173459; Fax: +40 (0)213173459/ 61

E-mail: info@carturesti.ro
http://www.carturesti.ro

RUSIA

Britannia ELT
Metro Novokuznetskaya,
C/Bolshaya Tatarskaya, 7
115184 Moscú - Rusia
Teléfono:
+7 (0)4957862564 
E-mail: britannia41@britannia-elt.ru
http://www.britannia-elt.ru

SERBIA

Data Status
Milutina Milankovica 1/45

11000 Belgrade
Serbia
telefono: ++381 11 301 78 32
fax: ++381 11 301 78 35
e-mail: info@datastatus.rs
http://www.datastatus.rs  

SUECIA

Carpe Librum
Sodergatan, 5
334 31 Anderstorp - Suecia
Teléfono: 37117258
E-mail: eje.carpelibrum@gmail.com
www.carpelibrum.com

SPRÅKBOKHANDELN
Lilla Tvärgatan, 21
223 53 Lund - Suecia
Teléfono: 46128568 - Fax: 46146165
E-mail: info@sprakbokhandeln.se

LäroMedia Bokhandel Örebro AB
Ormestagatan 2. 702 83 Örebro - Suecia
Teléfono: 19206900 - Fax: 19206949
E-mail: info@laromedia.se
www.laromedia.se

SUIZA

AVA Verlagsauslieferung AG
Centralweg 16
8910 Affoltern am Albis – Suiza
Teléfono: +41 (0) 44 762 42 00; Fax: +41 (0) 44 762 42 10
Email: avainfo@ava.ch
www.ava.ch

LibRomania
Länggass-Str. 12
CH-3012 Berna - Suiza
Teléfono: +41 (0)313053030; Fax: +41 (0)313053031
E-mail: mail@libromania.ch
http://www.libromania.ch

Ibercultura
Baselstrasse 67
CH-6003 Luzern - Suiza
Teléfono:
+41 (0)412406617; Fax: +41 (0)412100806

E-mail: ibercultura@ibercultura.ch
http://www.ibercultura.ch

TURQUÍA

INKAS
Çobançeşme mahallesi Sanayi caddesi
Altay sokak No:8 34196
Yenibosna/İstanbul - Turquía
Tel.: 90 (0)2124961010; Fax: +90 (0)2124961011
E-mail: info@inkas.com.tr
http://www.inkas.com.tr

UCRANIA

TSP
47, Shotá Rustaveli
Kyiv, 01023, - Ucrania
Tel.:+380 (0)442843850; Fax: +380 (0)442843847
E-mail: victor@tsp-books.com
http://www.tsp-books.com

 

África

EGIPTO

OSIRIS Bookshop
P O Box 107, 50 Kasr EL NILE, Downtown.
Cairo 11511 - Egypt
Teléfonos: + 0020223961903 + 00201001423641
Fax: + 0020223911489
E-mail: a.ibrahim@osirisbookshop-eg.com

MARRUECOS

Cervantes Librería
4, Calle Derna - Place Pietri
10.000 Rabat, Hassan - Marruecos
Teléfono: 614977753
E-mail: cervanteslibreria.rabat@gmail.com

 

SUDÁFRICA

Protea Boekhuis
Burnettstraat, 1067
0083 Hatfield, Pretoria, Gauteng - Sudáfrica
Teléfono: +27 (0)12 362 1563
Fax: +27 (0)86 577 3151
E-mail: orders@proteaboekhuis.co.za
http://www.proteaboekhuis.co.za

 

 

 

 

 

 

Ciudad Real SARL (librería)
Residence La Palmier Imm 17, Appt 8 Avenue Oqba

Agdal - Rabat - Marruecos
Teléfono: +212 (0)537681088 / GSM 0669727245
E-mail: ciudad-real@swissmail.org

Asia

 

CHINA

Beijing Publications Import & Export Corporation
#235 Street Wangfujing, Room 608
Beijing, China 73 Naesudong, Jongrogu
Tel: +8610 6512 6910; Fax: +8610 6512 6930
gaojing_bpiec@126.com

COREA

Kyobo Book Centre Co., Ltd
8 FL, Kyobo Book Building
73 Naesudong, Jongrogu
110-873 Seoul - Korea
Teléfono: Tel: +82 (0)31563875; Fax: +82 (0)5029875731
E-mail: jhl@kyobobook.co.kr
http://www.kyobobook.co.kr/index.laf

Pioli Spain & latin America Center
Hyundai Plaza 501, Geumjeong-dong 873-1, 
Gunpo, Gyeonggi-do 04551, Korea 
Teléfono: +82 (0)7087676708; Fax: +82 (0)7087676709
E-mail:  pioli@naver.com

http://www.pioli.co.kr

 

FILIPINAS

Abiva Publishing House
851 G. Araneta Avenue,
1113 Quezon City - Filipinas
Teléfono: +(632) 740-6674/ (632) 712-0245;
Fax: +(632) 712-0486;
E-mail: ellatandoc@abiva.com.ph
http://www.abiva.com.ph

 HONG KONG

Transglobal Publishers Service Ltd
27-E Shield Industrial Centre
84 Chat Wan Kok Street 
Tauen Wan New Territories 
Hong Kong
Tel: +852 2413 5322; Fax: +852 2413 7049 
E-mail: info@transglobal.com

ISRAEL

Dykler Libros
Allenby, 81
Tel-Aviv 65134 - Israel
Teléfono: 
+972 (0)35660939; Fax: +972 (0)35602250

E-mail: libros@netvision.net.il

Alberto Rentería
Rishon Letzion - Israel
Teléfono: +972 (0)548820542
E-mail:  albertoren@yahoo.com

JAPÓN

Interspain, LTD
102-0085
Gloria Hatsuho Buld. 402,
4-2 Rokubancho, Chiyodaku, Tokyo - Japón
Teléfono:
+81 (0)364268805; Fax: +81 (0)335118498
E-mail: interspain@interspain.jp
http://www.interspain.jp

United Publishers Services Ltd.
1-32-5 Higashi-shinagawa
Shinagawa-ku, Tokio 140-0002
Teléfono: 354797251 - Fax: 354797307
E-mail: info@ups.co.jp

 

LÍBANO

Géraldine Maalouf
Rabieh, rue Principale, Bloc B
P.O. Box 88 Brumana - Libano
Teléfono: 
+961 (0)3335555; Fax: +961 (0)4808203

E-mail: dinamaalouf@hotmail.com

 

TINTA NEGRA
120, Pharaon Street.Mar Mikhael
Beirut.Lebanon
Teléfono: +961 (0)1570027 

MALASIA

Piefke Trading Malaysia
14 E, Mewah Court Condo
Jalan Bukit Indah
43000 Kajang
Teléfono: +60 16 3141 089; Fax: +44 2031630698
E-mail: info@piefke-trading.com
http://www.piefke-trading.com

SINGAPUR

Las Lilas 
Blk 102F Pasir Panjang Road
180B Bencoolen Street #08-01/02/05
The Bencoolen (Office Tower)
Singapore 189648
Teléfono: +65 6333 3484
E-mail: enquiries@laslilasschool.com
http://www.laslilasschool.com

Piefke Trading 
14 E, Mewah Court Condo
Jalan Bukit Indah
43000 Kajang Malaysia
Teléfono: +60 16 3141 089; Fax: +44 2031630698
E-mail: info@piefke-trading.com
http://www.piefke-trading.com

TAILANDIA

Piefke Trading
Langsuan Road, Lumpini, Patumwan
10330 Bangkok, Thailand
Tel.: 0060 (0) 16 3141 089
info@piefke-trading.com
 
TAIWÁN

Caves Books Ltd
5F, #207, Ti-Ding Ave. Sec.1, Nei-Hu District
Taipei 11494 - Taiwan
Teléfono: 
+886 (0)287925001; Fax: +886 (0)287925026

E-mail: cathy@cavesbooks.com.tw
http://www.cavesbooks.com.tw

Sunny Publishing CO. (Sunny Books)
1F., No 72, Sec. 1, Xinhai Rd., Da’an Dist.,
Taipei City 106 - Taiwan (R.O.C.)
Teléfono: 886-2-2362-8269 - Fax: 886-2-2362-8259
E-mail: sunny.publish@msa.hinet.net
http://www.centralbook.com.tw 

EDICIONES CATAY LTD. 佳台書店
97-7, Dadun 18th street
Taichung 40758, Taiwan
Tel: +886 961 598 069
Email: edicionescatay@gmail.com
http://www.edicionescatay.com

VIETNAM

Thu Trang Piefke
Room 205, Block A, DOI CAN street,
LIEU GIAI ward, BA DINH district,
Hanoi, Vietnam
Teléfono: 00841639579796
E-mail: info@piefke-trading.com
http://www.piefke-trading.com

 

 



América

BRASIL

DISAL S.A.
Avenida Marginal Direita Do Tietê, 800
Vila Jaguara
05118-100 - São Paulo - SP
Teléfono: 11 3226-3111

E-mail: comercial@disal.com.br
http://www.disal.com.br

Letraviva
Av. Rebouças, 1986
CEP-05402-300 S
ão Paulo - Brasil
Teléfono:
+55 (0)1130887992; Fax: +55 (0)1130887992

Email: letraviva@letraviva.com.br
http://www.letraviva.com.br

CANADÁ


Tilley Education

34 Armstrong Ave

Georgetown, ON L7G 4R9
Teléfono: 905-873-2750 - Toll Free: 866-379-9645
E-mail: orders@gtwcanada.com


Cambridge University Press
Customer Service - 100 Brook Hill Drive

West Nyack, NY 10994-2133 - Estados Unidos
Teléfono: 8008727423; Fax: 8453484545
E-mail: orders@cambridge.org
http://www.cambridge.org/cambridgespanish

 

ESTADOS UNIDOS

Cambridge University Press
Customer Service - 100 Brook Hill Drive
West Nyack, NY 10994-2133 - Estados Unidos
Teléfono: 8008727423; Fax: 8453484545
E-mail: orders@cambridge.org
www.cambridge.org/cambridgespanish

 

 

Lia Editora Ltda.
Rua Caraibas, 544 - 83-A Perdizes
São Paulo - SP - Brasil. CEP 05020-000
Teléfono:
+55 (0)1138681178; Fax: +55 (0)1136724604

E-mail: lialibros@lialibros.com.br
http://www.lialibros.com.br

Librería Importaçao Comércio e Serviços Ltda.
Rua Alagoas, 1407 - Savassi

30.110-110 Belo Horizonte (MG) - Brasil
Teléfono: +55 (0) 3132251935
E-mail: libreria@libre.com.br
http://www.libre.com.br

 



Librairie Michel Fortin Inc.
3714, rue Saint-Denis
Montréal  (Québec)
H2X 3L7 - Canadá
Teléfono: +1 (0) 5148495719, poste 28
Sans frais: 1-877-849-5719, poste 28
Fax:
+1 (0) 5148490845
E-mail: mfortin@librairiemichelfortin.com
http://www.librairiemichelfortin.com






MÉXICO

Highlands Books, SA de CV 
Pvda. José de San Martín No. 2207
Col. Unidad Chihuahua
C.P. 31214 Chihuahua, Chih.

Teléfono/Fax:
+(52) 614-437-2727

Lada SIN COSTO: 01800-777-8182
E-mail: info@hbooks.com.mx
E-mail: pedidos@hbooks.com.mx 
http://www.hbooks.mx

  

Oceanía

AUSTRALIA

Intext Book Company
13-15 Station Street
East
Kew Vic 3102- Australia
Teléfono
: + 61-3-9857-0030; Fax:+61-3-9857-0031

E-mail: customerservice@intextbook.com.au
http://www.languageint.com.au

 

 

Protea Boekhuis

Perfíl de la información

Application afterLoad: 0.000 seconds, 0.33 MB
Application afterInitialise: 0.020 seconds, 2.09 MB
Application afterRoute: 0.027 seconds, 5.28 MB
Application afterDispatch: 0.157 seconds, 6.48 MB
Application afterRender: 0.401 seconds, 13.71 MB

Memoria usada

14421632

85 queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = 's09efuts8bfcor4entsmsrtp16'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1586064450' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 's09efuts8bfcor4entsmsrtp16'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 's09efuts8bfcor4entsmsrtp16','1586066250','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  8. SELECT id, folder, element, published, TYPE, params, CONCAT_WS('/',folder,element) AS lookup, name
     
      FROM jos_comprofiler_plugin
     
      WHERE published = 1
      AND access IN (0)
      AND TYPE = 'user'
     
      ORDER BY ordering
  9. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  10. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 5)
      ORDER BY menuid DESC
      LIMIT 0, 1
  11. SELECT m.*
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 5 OR mm.menuid = 0 )
      ORDER BY m.POSITION, m.ordering
  12. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  13. SELECT *
      FROM `jos_rsform_config`
  14. SELECT m1.id
      FROM jos_menu AS m1
      INNER JOIN jos_menu AS m2
      ON (m1.id = m2.parent
      AND m2.id = '5')
      WHERE m1.published = 1  
      AND m1.access = 0
      ORDER BY m1.ordering
  15. SELECT *
      FROM jos_menu AS m
      WHERE m.menutype='Botones' && m.parent = 0
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  16. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '57'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  17. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '61'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  18. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '62'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  19. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '63'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  20. SELECT *
      FROM jos_jcalpro2_config
  21. SELECT unix_timestamp( '2020-04-05 05:57:30');
  22. SELECT name
      FROM jos_jcalpro2_themes
      WHERE published= '1'
  23. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'registered'
  24. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 4
      AND g1.lft <11
      GROUP BY g1.name
      ORDER BY g1.lft
  25. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  26. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
  27. SELECT id, name
      FROM jos_core_acl_aro_groups;
  28. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
  29. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 14
      AND g1.lft <19
      GROUP BY g1.name
      ORDER BY g1.lft
  30. SELECT id, name
      FROM jos_core_acl_aro_groups;
  31. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
  32. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 14
      AND g1.lft <19
      GROUP BY g1.name
      ORDER BY g1.lft
  33. SELECT id, name
      FROM jos_core_acl_aro_groups;
  34. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
  35. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 14
      AND g1.lft <19
      GROUP BY g1.name
      ORDER BY g1.lft
  36. SELECT id, name
      FROM jos_core_acl_aro_groups;
  37. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
  38. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 14
      AND g1.lft <19
      GROUP BY g1.name
      ORDER BY g1.lft
  39. SELECT id, name
      FROM jos_core_acl_aro_groups;
  40. SELECT
                    cat_id, level
           
      FROM
                    jos_jcalpro2_categories
  41. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
  42. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
  43. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  44. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
  45. SELECT id, name
      FROM jos_core_acl_aro_groups;
  46. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
  47. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
  48. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  49. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
  50. SELECT id, name
      FROM jos_core_acl_aro_groups;
  51. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
  52. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
  53. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  54. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
  55. SELECT id, name
      FROM jos_core_acl_aro_groups;
  56. SELECT
                    cal_id, level
           
      FROM
                    jos_jcalpro2_calendars
  57. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
  58. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
  59. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  60. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
  61. SELECT id, name
      FROM jos_core_acl_aro_groups;
  62. SELECT e.*, DATE_FORMAT( e.start_date, '%Y%m%d' ) AS DATE, c.cat_id, c.cat_name, c.color, c.description AS cat_desc
      FROM jos_jcalpro2_events AS e
      LEFT JOIN jos_jcalpro2_categories AS c
      ON e.cat=c.cat_id  
      LEFT JOIN jos_jcalpro2_calendars AS cal
      ON e.cal_id=cal.cal_id
      WHERE (    ( e.start_date <= '2020-04-01 00:00:00'
      AND e.end_date >= '2020-04-30 23:59:59'
      AND e.end_date != '2038-01-18 00:00:00'
      AND e.end_date != '0000-00-00 00:00:01'
      AND e.end_date != '9999-12-01 00:00:00')  OR ((e.start_date >= '2020-04-01 00:00:00'
      AND e.start_date < '2020-04-30 23:59:59')  
      AND (e.end_date = '2038-01-18 00:00:00' OR e.end_date = '0000-00-00 00:00:01' OR e.end_date = '9999-12-01 00:00:00'))   OR ( e.start_date > '2020-04-01 00:00:00'
      AND e.start_date <= '2020-04-30 23:59:59')  OR ( e.end_date > '2020-04-01 00:00:00'
      AND e.end_date <= '2020-04-30 23:59:59' ) )
      AND c.published = '1'
      AND e.published = '1'
      AND cal.published='1'
      AND approved = '1'
      AND e.cat IN (2)
      AND e.cal_id IN (1)
      AND (e.private IN ('0', '2') OR (e.owner_id = '0'
      AND e.private = '1'))
      ORDER BY start_date,title ASC
  63. SELECT e.*, DATE_FORMAT( e.session_up, '%Y%m%d' ) AS DATE, c.name AS cat_name
                           
      FROM jos_illbethere_sessions AS e
                           
      LEFT JOIN jos_illbethere_categories AS c
                           
      ON c.cat_id = e.cat_id
                           
      WHERE e.published = '1'
      ORDER BY e.session_up, e.title ASC
  64. SELECT m1.id
      FROM jos_menu AS m1
      INNER JOIN jos_menu AS m2
      ON (m1.id = m2.parent
      AND m2.id = '5')
      WHERE m1.published = 1  
      AND m1.access = 0
      ORDER BY m1.ordering
  65. SELECT *
      FROM jos_menu AS m
      WHERE m.menutype='Destacados' && m.parent = 0
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  66. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '120'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  67. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '121'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  68. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '122'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  69. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '123'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  70. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '87'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  71. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '92'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  72. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '98'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  73. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '90'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  74. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '99'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  75. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '89'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  76. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '64'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  77. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '94'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  78. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '95'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  79. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '96'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  80. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '97'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  81. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  82. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                   
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  83. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  84. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  85. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`

4 legado de las queries identificadas

  1. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  2. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

      ORDER BY g1.lft
  3. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  4. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft

Archivos de idioma cargados

Sin traducir las cadenas de diagnóstico

Ninguno

Sin traducir las cadenas de diseñador

Ninguno