Los libros perdidos (Libro + CD)

PDFImprimirE-mail

El amor brujo: la perdición de Falla (Libro + CD)

El amor brujo: la perdición de Falla (Libro + CD)
Ver imagen grande
Precio: €10,40 ISBN: 9788498488159

Serie de lecturas graduadas ambientadas en diferentes lugares de España e Hispanoamérica en las que el misterio es el verdadero protagonista de cada una de ellas. Una forma amena de practicar el español y de adquirir conocimientos sobre diversos aspectos culturales.

  • Colección: Lecturas de enigma y misterio
  • Niveles: A2/B1
  • Autores: Alicia González del Campo
  • Dirigido a: Jóvenes y adultos
Páginas: 56 Tamaño: 14 x 21 cm Peso: 110 gr
Formato: Rústica Año de publicación/reedición: 2018
  • Lectura especialmente dirigida a estudiantes jóvenes y adultos de los niveles A2 y B1.
  • Contiene una completa explotación didáctica, tanto de comprensión global del texto como de creación.
  • Dispone de un CD de audio con la lectura dramatizada para facilitar la comprensión auditiva.
  • Incorpora notas léxicas para que el estudiante pueda ir ampliando significativamente su vocabulario.
  • Sigue las directrices del Plan curricular del Instituto Cervantes.

Sinopsis:

2015. Max Strauss, un componente de la orquesta de cámara de Berlín, está en Granada con su compañía para celebrar el año Manuel de Falla. Allí conocerá a Candela, una bailarina gitana que participará con él en una misteriosa audición que repetirá la primera partitura musical de El amor brujo, creada por Manuel de Falla en 1915. Pronto comprenderán el poder del flamenco y lo que sucedió en Granada un siglo antes, cuando Falla liberó con su música una fuerza destructora y desconocida que trajo el mal al mundo y que en el año 2015 amenaza con regresar. Max y Candela descubrirán, gracias a las cartas que Falla escribió a sus amigos, el peligro que encierra su obra El amor brujo y la manera de vencer al terrorífico ser que saldrá de su música.

La historia transcurre en 2015, centenario del estreno de la obra El amor brujo, sin embargo hace un viaje al pasado a través de la correspondencia del músico y sus amistades.


Última actualización: Sunday, 05 April 2020 07:27

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.028 seconds, 5.28 MB
Application afterDispatch: 0.229 seconds, 8.68 MB
Application afterRender: 0.389 seconds, 14.49 MB

Memoria usada

15239328

158 queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'mj2cchht0r19bt0oi9ol74f2o1'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1586069873' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'mj2cchht0r19bt0oi9ol74f2o1'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'mj2cchht0r19bt0oi9ol74f2o1','1586071673','','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 = 4)
      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 = 4 OR mm.menuid = 0 )
      ORDER BY m.POSITION, m.ordering
  12. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  13. 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'
  14. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  15. 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`);
  16. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  17. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  18. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  19. SELECT *, (SELECT COUNT(*)
      FROM `jos_vm_product` AS cp
      WHERE `cp`.`product_parent_id` = `jos_vm_product`.`product_id`
      AND `product_in_stock` > 0) AS childrens_with_stock
      FROM `jos_vm_product`
      WHERE `product_id`=675
      AND `product_publish`='Y'
  20. SELECT product_sku, product_name, related_products
      FROM jos_vm_product,jos_vm_product_relations
      WHERE jos_vm_product_relations.product_id='675'
      AND product_publish='Y'
      AND FIND_IN_SET(jos_vm_product.product_id, REPLACE(related_products, '|', ',' ))
      LIMIT 0, 4
  21. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='9788498482300'
  22. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=384
  23. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='384'
  24. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  25. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='9788498481167'
  26. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=447
  27. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='447'
  28. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='9788498483741'
  29. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=449
  30. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='449'
  31. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='9788498484359'
  32. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=548
  33. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='548'
  34. SELECT id
      FROM jos_plugins
      WHERE element = 'legacy'
      AND published = 0
  35. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  36. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='129'
      AND jos_vm_category.category_id='129'
  37. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='4'
      AND jos_vm_category.category_id='4'
  38. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  39. SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`jos_vm_category`.`category_id`,     `jos_vm_product`.`product_id`, `product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_sku`, `product_url`, `product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`, `jos_vm_category_xref`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category_xref`.`category_child_id`
     
      AND `jos_vm_product_category_xref`.`category_id` IN (129)
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`cdate` DESC
      LIMIT 0, 2000
  40. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='551'
  41. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='129'
  42. SELECT manufacturer_id
      FROM jos_vm_product_mf_xref
      WHERE product_id='675'
  43. SELECT mf_name,jos_vm_manufacturer.manufacturer_id
      FROM jos_vm_product_mf_xref,jos_vm_manufacturer
      WHERE product_id='675'
      AND jos_vm_manufacturer.manufacturer_id=jos_vm_product_mf_xref.manufacturer_id
  44. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=675
  45. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='675'
      AND (start_date<='1586071673' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  46. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=675
  47. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1586071673' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  48. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='675'
  49. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  50. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=675
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  51. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=675
  52. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=675
  53. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=675
      AND `file_is_image`=1
      AND `file_published`=1
  54. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=675
  55. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  56. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=675
      AND `file_is_image`=0
      AND `file_published`=1
  57. SELECT attribute_value
      FROM jos_vm_product_attribute
      WHERE `product_id` = '675'
      AND attribute_name='download'
  58. SELECT DISTINCT file_id, file_mimetype, file_title, file_name
      FROM `jos_vm_product_files`
      WHERE file_product_id = '675'
      AND file_published = '1'
      AND file_is_image = '0'
  59. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='675'
  60. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='675'
  61. SELECT jos_vm_vendor.vendor_name
      FROM jos_vm_product, jos_vm_vendor
      WHERE jos_vm_product.product_id='675'
      AND jos_vm_vendor.vendor_id=jos_vm_product.vendor_id
  62. SELECT *
      FROM jos_vm_product_product_type_xref
      WHERE product_id='675'
  63. SELECT *
      FROM jos_vm_product_product_type_xref
      LEFT JOIN jos_vm_product_type USING (product_type_id)
      WHERE product_id='675'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  64. SELECT *
      FROM jos_vm_product_type_1
      WHERE product_id='675'
  65. SELECT *
      FROM jos_vm_product_type_parameter
      WHERE product_type_id=1
      ORDER BY parameter_list_order
  66. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='675'
  67. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=675
  68. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=675
  69. SELECT product_id, attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='675'
  70. SELECT product_id, attribute
      FROM jos_vm_product
      WHERE product_id='675'
  71. SELECT product_id, custom_attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='675'
  72. SELECT product_id, custom_attribute
      FROM jos_vm_product
      WHERE product_id='675'
  73. SELECT product_id,product_name
      FROM jos_vm_product
      WHERE product_parent_id='675'
      AND product_publish='Y'
      ORDER BY child_list ASC
  74. SELECT `t`.`id`, `t`.`tag`  
      FROM `jos_vm_tags` AS t
      INNER JOIN `jos_vm_tags_products` AS ta
      ON `t`.`id` = `ta`.`tag_id`
      WHERE `ta`.`product_id` = 675
  75. SELECT `payment_method_id`
      FROM `jos_vm_payment_method`
      WHERE `payment_class`='ps_paypal_api'
      AND `payment_enabled`='Y'
  76. SELECT category_id, `jos_vm_category`.*
      FROM `jos_vm_category`
      WHERE `category_id`=129
  77. SELECT product_thumb_image
      FROM jos_vm_product
      WHERE product_id  = '675'
  78. SELECT product_thumb_image
      FROM jos_vm_product
      WHERE product_id  = '675'
  79. SELECT product_name
      FROM jos_vm_product
      WHERE product_id = '675'
  80. SELECT product_name
      FROM jos_vm_product
      WHERE product_id = '675'
  81. SELECT COUNT(*)
      FROM jos_vm_product_category_xref
      WHERE product_id = '675'
  82. SELECT COUNT(*)
      FROM jos_vm_product_category_xref
      WHERE product_id = '675'
  83. SELECT category_id
      FROM jos_vm_product_category_xref
      WHERE product_id = '675'
  84. SELECT category_id
      FROM jos_vm_product_category_xref
      WHERE product_id = '675'
  85. SELECT category_publish, category_flypage
      FROM jos_vm_category
      WHERE category_id = '129'
  86. SELECT category_publish, category_flypage
      FROM jos_vm_category
      WHERE category_id = '129'
  87. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  88. SELECT *
      FROM `jos_rsform_config`
  89. SELECT m1.id
      FROM jos_menu AS m1
      INNER JOIN jos_menu AS m2
      ON (m1.id = m2.parent
      AND m2.id = '4')
      WHERE m1.published = 1  
      AND m1.access = 0
      ORDER BY m1.ordering
  90. 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
  91. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '57'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  92. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '61'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  93. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '62'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  94. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '63'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  95. SELECT *
      FROM jos_jcalpro2_config
  96. SELECT unix_timestamp( '2020-04-05 07:27:53');
  97. SELECT name
      FROM jos_jcalpro2_themes
      WHERE published= '1'
  98. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'registered'
  99. 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
  100. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  101. 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
  102. SELECT id, name
      FROM jos_core_acl_aro_groups;
  103. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
  104. 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
  105. SELECT id, name
      FROM jos_core_acl_aro_groups;
  106. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
  107. 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
  108. SELECT id, name
      FROM jos_core_acl_aro_groups;
  109. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
  110. 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
  111. SELECT id, name
      FROM jos_core_acl_aro_groups;
  112. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
  113. 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
  114. SELECT id, name
      FROM jos_core_acl_aro_groups;
  115. SELECT
                    cat_id, level
           
      FROM
                    jos_jcalpro2_categories
  116. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
  117. 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
  118. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  119. 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
  120. SELECT id, name
      FROM jos_core_acl_aro_groups;
  121. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
  122. 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
  123. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  124. 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
  125. SELECT id, name
      FROM jos_core_acl_aro_groups;
  126. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
  127. 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
  128. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  129. 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
  130. SELECT id, name
      FROM jos_core_acl_aro_groups;
  131. SELECT
                    cal_id, level
           
      FROM
                    jos_jcalpro2_calendars
  132. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
  133. 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
  134. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  135. 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
  136. SELECT id, name
      FROM jos_core_acl_aro_groups;
  137. 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
  138. 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
  139. SELECT m1.id
      FROM jos_menu AS m1
      INNER JOIN jos_menu AS m2
      ON (m1.id = m2.parent
      AND m2.id = '4')
      WHERE m1.published = 1  
      AND m1.access = 0
      ORDER BY m1.ordering
  140. 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
  141. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '120'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  142. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '121'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  143. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '122'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  144. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '123'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  145. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '87'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  146. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '92'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  147. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '98'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  148. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '90'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  149. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '99'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  150. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '89'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  151. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '64'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  152. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '94'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  153. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '95'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  154. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '96'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  155. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '97'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  156. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.id = 119
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 4 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  157. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.id = 164
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 4 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  158. 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