gototopgototop

Editorial Ezcurra

Gestión Procesal y Administrativa (Tomo III)
Ver imagen grande


Gestión Procesal y Administrativa (Tomo III)
Precio: 38,00 €



Edición 2017

Programa

D) Procedimiento Penal.

Tema 43. El sistema procesal penal de la Ley de Enjuiciamiento Criminal: Principio del juez imparcial, separación de instrucción y enjuiciamiento. Principios del proceso penal. Competencia objetiva y funcional. Aforamientos y privilegios procesales. Inmunidad de jurisdicción. La competencia territorial. La inhibición de oficio y a instancia de parte; cuestiones de competencia territorial.

Tema 44. Las partes en el proceso penal: Ministerio Fiscal; acusador particular; perjudicado y acción popular; acusador privado. El ejercicio de la acción penal: de oficio o a instancia de parte. Denuncia; querella; atestado. Extinción de la acción penal: especial referencia a la renuncia. El ejercicio de la acción civil: el actor civil. El ofrecimiento de acciones. Extinción de la acción civil. El investigado o encausado. La rebeldía. El responsable civil. Representación y defensa de las partes. Defensa de oficio y beneficio de justicia gratuita.

Tema 45. El Sumario: Incoación del proceso. Las actuaciones de la Policía Judicial. Comprobación del delito: Cuerpo del delito. Identificación del presunto delincuente. La inspección ocular. Declaraciones testificales. Prueba pericial y su valor. Prueba documental. Piezas de convicción.

Tema 46. Las medidas cautelares personales en el proceso penal. La citación judicial. La detención. La prisión provisional. La libertad provisional. Las fianzas en el proceso penal. Medidas limitadoras de derechos fundamentales: Pruebas biológicas; entrada y registro en lugar cerrado; intervención de comunicaciones postales, telegráficas, telefónicas e informáticas. Especial mención a las entregas controladas y a la figura del agente encubierto.

Tema 47. El denominado período intermedio; auto de conclusión del sumario; eventual revocación del auto y nuevas diligencias y resoluciones. El sobreseimiento y sus clases. El auto de apertura del juicio oral. Los artículos de previo pronunciamiento. Las calificaciones provisionales de las partes. Conformidad del acusado.

Tema 48. La prueba en el proceso penal. Medios de prueba. Proposición, admisión o denegación; prueba anticipada; proposición en el acto del juicio; prueba acordada «ex officio». El juicio oral. La suspensión del juicio oral: causas y consecuencias.

Tema 49. El procedimiento abreviado: Información de derechos, prueba anticipada. Conclusión de la fase instructora, la conformidad por reconocimiento de hechos. La fase de juicio oral: Admisión de pruebas, señalamiento del juicio e información a la víctima. Celebración del juicio oral, especialidades. La sentencia; especialidades: a) sentencia oral; b) conformidad de las partes sobre la firmeza inicial de la sentencia; c) principio acusatorio, d) notificación. Los recursos contra las resoluciones procesales en el ámbito del procedimiento abreviado: a) Los recursos contra las resoluciones judiciales b) Los recursos contra las resoluciones del Letrado de la Administración de Justicia. Ejecución de sentencias.

Tema 50. Procedimiento para el enjuiciamiento rápido de determinados delitos: Ámbito de aplicación. Actuaciones de la Policía Judicial. Diligencias urgentes ante el Juzgado de guardia; instrucción y conclusión. Preparación y desarrollo del juicio oral. Sentencia.

Tema 51. El proceso ante el Tribunal del Jurado. Competencia. Composición y constitución del Jurado: Estatuto jurídico de los jurados; su selección. La fase de instrucción y la fase intermedia. La fase de juicio oral: trámites precedentes: Designación del Magistrado-Ponente; cuestiones previas; auto de hechos justiciables; celebración del juicio oral: La vista; suspensión del juicio oral. Posible disolución del Jurado: sus causas. El veredicto: Determinación del objeto del veredicto, deliberación y veredicto; instrucción a los jurados; deliberación y votación; acta. Sentencia.

Tema 52. La tutela judicial ante los Juzgados de violencia sobre la mujer. Especialidades procesales. Pérdida de la competencia objetiva de los juzgados civiles cuando se produzcan actos de violencia sobre la mujer. Medidas judiciales de protección y de seguridad de las víctimas.

Tema 53. El procedimiento de Responsabilidad Penal del Menor. Principios reguladores. Las fases del procedimiento. Sentencia y régimen de recursos. Principios generales en la ejecución de las medidas.

Tema 54. Tramitación del juicio sobre delitos leves. Convocatoria de la vista de juicio sobre delitos leves. Sistema de recursos a las sentencias dictadas en juicios sobre delitos leves. La ejecución de la sentencia de delitos leves: Aspectos penales y civiles.

Tema 55. Régimen general de recursos en el proceso penal. Los recursos no devolutivos: Reforma y súplica. Recursos devolutivos: La apelación en el proceso ordinario y en el procedimiento abreviado; El recurso de queja contra la inadmisión de otro recurso y como sustitutivo de la apelación. El recurso de casación penal. La revisión penal. El recurso de rescisión de la sentencia dictada contra reos ausentes. Los recursos contra las resoluciones del Letrado de la Administración de Justicia.

Tema 56. La ejecución de sentencias penales. Los Juzgados y Tribunales sentenciadores; Juzgados de Vigilancia Penitenciaria y Administración Penitenciaria: Sus respectivas funciones. Recursos contra las resoluciones de la Administración Penitenciaria y de los Juzgados de Vigilancia Penitenciaria. Tasación de costas. La ejecución civil en el proceso penal.

E) Procedimiento Contencioso Administrativo y Laboral.

Tema 57. Breve referencia del recurso contencioso-administrativo. Organización de la jurisdicción contenciosa-administrativa.

Tema 58. Recurso contencioso-administrativo: Capacidad procesal, legitimación, representación y defensa. Actos impugnables.

Tema 59. Recurso contencioso-administrativo: Diligencias preliminares. Interposición del recurso y reclamación del expediente. Emplazamiento de los demandados y admisión del recurso.

Tema 60. Recurso contencioso-administrativo: Demanda y contestación. Alegaciones previas. Prueba. Vista y conclusiones. Sentencias. Otros medios de terminación del procedimiento.

Tema 61. El procedimiento abreviado en el ámbito contencioso-administrativo.

Tema 62. Los recursos en el proceso contencioso administrativo. Los recursos contra las resoluciones del Letrado de la Administración de Justicia.

Tema 63. Procedimientos especiales: Procedimientos para la protección de los derechos fundamentales de las personas. Cuestión de ilegalidad. Procedimientos en los casos de suspensión administrativa previa de acuerdos.

Tema 64. Disposiciones comunes a los procedimientos contencioso-administrativos: Plazos. Medidas cautelares. Incidentes e invalidez de actos procesales. costas procesales. Ejecución de sentencias.

Tema 65. El proceso laboral: Principios que lo informan. Competencia objetiva y territorial. Cuestiones de competencia. Representación y defensa en el procedimiento laboral. Fondo de Garantía Salarial. Justicia gratuita.

Tema 66. La evitación del proceso: Conciliación previa y reclamación administrativa previa. El proceso ordinario: Demanda, conciliación y juicio. Recursos: de suplicación y de casación para la unificación de doctrina; disposiciones comunes a ambos recursos.

Tema 67. Procesos especiales: Despidos, Seguridad Social, Conflictos Colectivos, Impugnación de los convenios colectivos. Tutela de derechos fundamentales.

F) Normativa sobre Derecho Mercantil.

Tema 68. El Concurso de acreedores. Concepto de concurso sus clases, la competencia objetiva y territorial. El administrador concursal. Aspectos procesales: Procedimiento ordinario y procedimiento abreviado; las secciones del concurso; el incidente concursal. Los recursos.




Cesta de compra

Su compra Su carro está vacío.

Boletín

Suscríbase a nuestro boletín gratuito de novedades bibliográficas



Joomla : Editorial Ezcurra

Usted está aquí  : Inicio > Administración de Justicia > Gestión Procesal y Administrativa (Tomo III)

Perfíl de la información

Application afterLoad: 0.002 seconds, 0.37 MB
Application afterInitialise: 0.075 seconds, 4.73 MB
Application afterRoute: 0.085 seconds, 5.34 MB
Application afterDispatch: 0.359 seconds, 19.84 MB
Application afterRender: 0.445 seconds, 21.37 MB

Memoria usada

22526200

113 queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = '0spk8g5vutoum300rd9217hl52'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1555690563' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '0spk8g5vutoum300rd9217hl52'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '0spk8g5vutoum300rd9217hl52','1555691463','','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 m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  8. SELECT *
      FROM `jos_jnews_xonfig`
  9. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  10. 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'
  11. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  12. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  13. 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
  14. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  15. 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
  16. 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`);
  17. SELECT module_id, module_name
      FROM jos_vm_module
      ORDER BY module_name
  18. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  19. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  20. SELECT *
      FROM `jos_vm_product`
      WHERE `product_id`=120
      AND `product_publish`='Y'
  21. SELECT product_sku, related_products
      FROM jos_vm_product,jos_vm_product_relations
      WHERE jos_vm_product_relations.product_id='120'
      AND product_publish='Y'
      AND FIND_IN_SET(jos_vm_product.product_id, REPLACE(related_products, '|', ',' ))
      LIMIT 0, 4
  22. SELECT cx.category_id, category_flypage
      FROM jos_vm_category c, jos_vm_product_category_xref cx
      WHERE product_id = '120'
      AND c.category_id=cx.category_id
      LIMIT 0,1
  23. 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='10'
      AND jos_vm_category.category_id='10'
  24. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  25. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 10
  26. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (10)
  27. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  28. SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `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`)
      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`.`category_id`=`jos_vm_category`.`category_id`
     
      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`.`product_name` ASC
      LIMIT 0, 2000
  29. 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`='44'
  30. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 44
  31. 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`='119'
  32. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 119
  33. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 0)
      ORDER BY menuid DESC
      LIMIT 0, 1
  34. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='10'
  35. SELECT manufacturer_id
      FROM jos_vm_product_mf_xref
      WHERE product_id='120'
  36. SELECT mf_name,jos_vm_manufacturer.manufacturer_id
      FROM jos_vm_product_mf_xref,jos_vm_manufacturer
      WHERE product_id='120'
      AND jos_vm_manufacturer.manufacturer_id=jos_vm_product_mf_xref.manufacturer_id
  37. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=120
  38. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='120'
      AND (start_date<='1555691463' OR start_date=0)
      AND (end_date>='1555630560' OR end_date=0)
      AND product_discount_id=discount_id
  39. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=120
  40. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555691463' OR start_date=0)
      AND (end_date>='1555630560' OR end_date=0)
      AND product_discount_id=discount_id
  41. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='120'
  42. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  43. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=120
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  44. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=120
  45. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='120'
  46. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=120
  47. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=120
      AND `file_is_image`=1
      AND `file_published`=1
  48. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=120
  49. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  50. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=120
      AND `file_is_image`=0
      AND `file_published`=1
  51. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='120'
  52. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  53. SELECT attribute_value
      FROM jos_vm_product_attribute
      WHERE `product_id` = '0'
      AND attribute_name='download'
  54. SELECT DISTINCT file_id, file_mimetype, file_title, file_name
      FROM `jos_vm_product_files`
      WHERE file_product_id = '0'
      AND file_published = '1'
      AND file_is_image = '0'
  55. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='120'
  56. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='120'
  57. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 120
  58. SELECT jos_vm_vendor.vendor_name
      FROM jos_vm_product, jos_vm_vendor
      WHERE jos_vm_product.product_id='120'
      AND jos_vm_vendor.vendor_id=jos_vm_product.vendor_id
  59. SELECT *
      FROM jos_vm_product_product_type_xref
      WHERE product_id='120'
  60. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=120
  61. SELECT product_id, attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='120'
  62. SELECT product_id, attribute
      FROM jos_vm_product
      WHERE product_id='120'
  63. SELECT product_id, custom_attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='120'
  64. SELECT product_id, custom_attribute
      FROM jos_vm_product
      WHERE product_id='120'
  65. SELECT product_id,product_name
      FROM jos_vm_product
      WHERE product_parent_id='120'
      AND product_publish='Y'
  66. SELECT `payment_method_id`
      FROM `jos_vm_payment_method`
      WHERE `payment_class`='ps_paypal_api'
      AND `payment_enabled`='Y'
  67. 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.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 0 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  68. SELECT category_id, category_description, category_name,category_child_id AS cid, category_parent_id AS pid,list_order, category_publish
                                                   
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category.category_publish='Y'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
  69. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 25
  70. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (25)
  71. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 3
  72. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  73. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 10
  74. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (10)
  75. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 27
  76. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (27)
  77. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 11
  78. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (11)
  79. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 12
  80. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (12)
  81. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 14
  82. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (14)
  83. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 2
  84. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (2)
  85. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 26
  86. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (26)
  87. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 5
  88. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (5)
  89. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 13
  90. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (13)
  91. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 4
  92. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (4)
  93. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  94. SELECT *
      FROM `jos_jnews_lists`
      WHERE `id` IN ( 17 )
      AND `published` = 1
  95. SELECT p.product_id, p.product_sales AS sales, p.product_parent_id, p.product_name, c.category_id, c.category_flypage
      FROM jos_vm_product p, jos_vm_product_category_xref pc, jos_vm_category c
      WHERE p.product_publish='Y'
      AND pc.product_id = p.product_id
      AND pc.category_id = c.category_id
      AND p.product_sales > 0
      GROUP BY p.product_id
      ORDER BY sales DESC, p.product_name  
      LIMIT 0, 6
  96. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 3
  97. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  98. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 30
  99. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 3
  100. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  101. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 8
  102. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 3
  103. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  104. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 7
  105. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 3
  106. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  107. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 64
  108. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 3
  109. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  110. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 80
  111. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 10
  112. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (10)
  113. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 90

113 legado de las queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = '0spk8g5vutoum300rd9217hl52'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1555690563' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '0spk8g5vutoum300rd9217hl52'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '0spk8g5vutoum300rd9217hl52','1555691463','','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 m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  8. SELECT *
      FROM `jos_jnews_xonfig`
  9. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  10. 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'
  11. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  12. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  13. 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
  14. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  15. 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
  16. 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`);
  17. SELECT module_id, module_name
      FROM jos_vm_module
      ORDER BY module_name
  18. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  19. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  20. SELECT *
      FROM `jos_vm_product`
      WHERE `product_id`=120
      AND `product_publish`='Y'
  21. SELECT product_sku, related_products
      FROM jos_vm_product,jos_vm_product_relations
      WHERE jos_vm_product_relations.product_id='120'
      AND product_publish='Y'
      AND FIND_IN_SET(jos_vm_product.product_id, REPLACE(related_products, '|', ',' ))
      LIMIT 0, 4
  22. SELECT cx.category_id, category_flypage
      FROM jos_vm_category c, jos_vm_product_category_xref cx
      WHERE product_id = '120'
      AND c.category_id=cx.category_id
      LIMIT 0,1
  23. 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='10'
      AND jos_vm_category.category_id='10'
  24. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  25. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 10
  26. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (10)
  27. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  28. SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `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`)
      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`.`category_id`=`jos_vm_category`.`category_id`
     
      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`.`product_name` ASC
      LIMIT 0, 2000
  29. 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`='44'
  30. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 44
  31. 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`='119'
  32. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 119
  33. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 0)
      ORDER BY menuid DESC
      LIMIT 0, 1
  34. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='10'
  35. SELECT manufacturer_id
      FROM jos_vm_product_mf_xref
      WHERE product_id='120'
  36. SELECT mf_name,jos_vm_manufacturer.manufacturer_id
      FROM jos_vm_product_mf_xref,jos_vm_manufacturer
      WHERE product_id='120'
      AND jos_vm_manufacturer.manufacturer_id=jos_vm_product_mf_xref.manufacturer_id
  37. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=120
  38. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='120'
      AND (start_date<='1555691463' OR start_date=0)
      AND (end_date>='1555630560' OR end_date=0)
      AND product_discount_id=discount_id
  39. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=120
  40. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555691463' OR start_date=0)
      AND (end_date>='1555630560' OR end_date=0)
      AND product_discount_id=discount_id
  41. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='120'
  42. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  43. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=120
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  44. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=120
  45. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='120'
  46. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=120
  47. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=120
      AND `file_is_image`=1
      AND `file_published`=1
  48. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=120
  49. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  50. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=120
      AND `file_is_image`=0
      AND `file_published`=1
  51. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='120'
  52. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  53. SELECT attribute_value
      FROM jos_vm_product_attribute
      WHERE `product_id` = '0'
      AND attribute_name='download'
  54. SELECT DISTINCT file_id, file_mimetype, file_title, file_name
      FROM `jos_vm_product_files`
      WHERE file_product_id = '0'
      AND file_published = '1'
      AND file_is_image = '0'
  55. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='120'
  56. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='120'
  57. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 120
  58. SELECT jos_vm_vendor.vendor_name
      FROM jos_vm_product, jos_vm_vendor
      WHERE jos_vm_product.product_id='120'
      AND jos_vm_vendor.vendor_id=jos_vm_product.vendor_id
  59. SELECT *
      FROM jos_vm_product_product_type_xref
      WHERE product_id='120'
  60. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=120
  61. SELECT product_id, attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='120'
  62. SELECT product_id, attribute
      FROM jos_vm_product
      WHERE product_id='120'
  63. SELECT product_id, custom_attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='120'
  64. SELECT product_id, custom_attribute
      FROM jos_vm_product
      WHERE product_id='120'
  65. SELECT product_id,product_name
      FROM jos_vm_product
      WHERE product_parent_id='120'
      AND product_publish='Y'
  66. SELECT `payment_method_id`
      FROM `jos_vm_payment_method`
      WHERE `payment_class`='ps_paypal_api'
      AND `payment_enabled`='Y'
  67. 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.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 0 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  68. SELECT category_id, category_description, category_name,category_child_id AS cid, category_parent_id AS pid,list_order, category_publish
                                                   
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category.category_publish='Y'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
  69. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 25
  70. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (25)
  71. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 3
  72. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  73. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 10
  74. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (10)
  75. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 27
  76. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (27)
  77. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 11
  78. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (11)
  79. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 12
  80. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (12)
  81. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 14
  82. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (14)
  83. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 2
  84. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (2)
  85. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 26
  86. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (26)
  87. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 5
  88. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (5)
  89. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 13
  90. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (13)
  91. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 4
  92. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (4)
  93. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  94. SELECT *
      FROM `jos_jnews_lists`
      WHERE `id` IN ( 17 )
      AND `published` = 1
  95. SELECT p.product_id, p.product_sales AS sales, p.product_parent_id, p.product_name, c.category_id, c.category_flypage
      FROM jos_vm_product p, jos_vm_product_category_xref pc, jos_vm_category c
      WHERE p.product_publish='Y'
      AND pc.product_id = p.product_id
      AND pc.category_id = c.category_id
      AND p.product_sales > 0
      GROUP BY p.product_id
      ORDER BY sales DESC, p.product_name  
      LIMIT 0, 6
  96. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 3
  97. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  98. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 30
  99. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 3
  100. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  101. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 8
  102. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 3
  103. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  104. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 7
  105. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 3
  106. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  107. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 64
  108. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 3
  109. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  110. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 80
  111. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 10
  112. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (10)
  113. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 90

Archivos de idioma cargados

Sin traducir las cadenas de diagnóstico

Ninguno

Sin traducir las cadenas de diseñador

Ninguno