gototopgototop

Editorial Ezcurra

Administración Local

Ordenado por:
Ayudantes tributarios de SUMA Ayudantes tributarios de SUMA
Curso on line para la convocatoria de 22 plazas (BOE 18-XII-2017) [Detalles del Producto...]
190,00 €


Cursos on line para el tercer examen de Intervención-Tesorería y Cursos on line para el tercer examen de Intervención-Tesorería y
Cursos on line para Intervención-Tesorería y Secretarios de Entrada [Detalles del Producto...]

Secretarios de Entrada Secretarios de Entrada
Edición 2019: Adenda con los temas no incluidos en el Programa de Secretarios-Interventores [Detalles del Producto...]
60,00 €

Secretarios-Interventores Secretarios-Interventores
Edición: noviembre de 2018. El Temario completo (144 temas) se desarrolla en cuatro libros impresos en papel [Detalles del Producto...]
180,00 €

Supuestos de Gestión Presupuestaria y Financiera de las EE.LL. Supuestos de Gestión Presupuestaria y Financiera de las EE.LL.
Obra impresa en papel de 310 páginas Edición 2015 [Detalles del Producto...]
38,00 €

Supuestos prácticos de Contabilidad de Costes Supuestos prácticos de Contabilidad de Costes
Obra impresa en papel de 330 páginas. Edición 2017 [Detalles del Producto...]
38,00 €

Supuestos prácticos de Contabilidad Pública Local Supuestos prácticos de Contabilidad Pública Local
Obra impresa en papel de 362 páginas. Edición 2016 [Detalles del Producto...]
38,00 €

Supuestos Prácticos de Régimen Local Supuestos Prácticos de Régimen Local
Obra en papel de 546 páginas Edición 2018 [Detalles del Producto...]
48,00 €

Supuestos Prácticos de Tributación y Recaudación Local Supuestos Prácticos de Tributación y Recaudación Local
Obra en papel de 554 páginas Edición 2017 [Detalles del Producto...]
48,00 €



Técnicos de Admón. Gral. de las Corporaciones Locales Técnicos de Admón. Gral. de las Corporaciones Locales
El programa completo se desarrolla en tres tomos en papel, con un total de más de 1.700 páginas. Cada uno de los ellos contiene 40 temas [Detalles del Producto...]
144,00 €


  • «« Inicio
  • « Anterior
  • 1
  • Siguiente »
  • Final »»


Mostrar #  
Resultados 1 - 13 de 13

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 Local

Perfíl de la información

Application afterLoad: 0.001 seconds, 0.40 MB
Application afterInitialise: 0.083 seconds, 3.14 MB
Application afterRoute: 0.094 seconds, 3.53 MB
Application afterDispatch: 0.333 seconds, 13.04 MB
Application afterRender: 0.368 seconds, 14.03 MB

Memoria usada

14777568

347 queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'r7jvvk0ts4l0b0qifjbqvp87o0'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1550829153' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'r7jvvk0ts4l0b0qifjbqvp87o0'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'r7jvvk0ts4l0b0qifjbqvp87o0','1550830053','','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 COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  21. SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) AS num_rows
      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_category_xref`.`category_id`=3
     
      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'
  22. SELECT category_id, category_name
      FROM jos_vm_category
      WHERE category_id='3'
  23. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='3'
  24. SELECT category_id, category_thumb_image, category_child_id,category_name
      FROM jos_vm_category,jos_vm_category_xref
      WHERE jos_vm_category_xref.category_parent_id='3'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      AND jos_vm_category.vendor_id='1'
      AND jos_vm_category.category_publish='Y'
      ORDER BY jos_vm_category.list_order, jos_vm_category.category_name ASC
  25. 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='3'
      AND jos_vm_category.category_id='3'
  26. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  27. 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
  28. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  29. 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
  30. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  31. 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_category_xref`.`category_id`=3
     
      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, 100
  32. 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
  33. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  34. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 116
  35. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=116
  36. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='116'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  37. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=116
  38. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  39. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='116'
  40. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  41. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=116
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  42. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=116
  43. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='116'
  44. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=116
  45. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=116
      AND `file_is_image`=1
      AND `file_published`=1
  46. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=116
  47. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  48. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=116
      AND `file_is_image`=0
      AND `file_published`=1
  49. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='116'
  50. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  51. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=116
  52. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=116
  53. 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
  54. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  55. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 124
  56. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=124
  57. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='124'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  58. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=124
  59. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  60. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='124'
  61. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  62. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  63. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  64. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  65. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='124'
  66. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 124
  67. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  68. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  69. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  70. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  71. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=124
      AND `file_is_image`=1
      AND `file_published`=1
  72. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=124
  73. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  74. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=124
      AND `file_is_image`=0
      AND `file_published`=1
  75. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='124'
  76. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  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= 3
  78. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  79. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 88
  80. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=88
  81. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='88'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  82. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=88
  83. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  84. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='88'
  85. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=88
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  86. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=88
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  87. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=88
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  88. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=88
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  89. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='88'
  90. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 88
  91. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=88
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  92. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=88
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  93. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=88
  94. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=88
      AND `file_is_image`=1
      AND `file_published`=1
  95. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=88
  96. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  97. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=88
      AND `file_is_image`=0
      AND `file_published`=1
  98. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='88'
  99. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  100. 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
  101. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  102. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 9
  103. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9
  104. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  105. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9
  106. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  107. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9'
  108. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  109. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9
  110. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9'
  111. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9
  112. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9
      AND `file_is_image`=1
      AND `file_published`=1
  113. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9
  114. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  115. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9
      AND `file_is_image`=0
      AND `file_published`=1
  116. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9'
  117. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  118. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9
  119. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9
  120. 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
  121. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  122. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 8
  123. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=8
  124. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='8'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  125. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8
  126. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  127. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='8'
  128. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  129. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=8
  130. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='8'
  131. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=8
  132. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=8
      AND `file_is_image`=1
      AND `file_published`=1
  133. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8
  134. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  135. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=8
      AND `file_is_image`=0
      AND `file_published`=1
  136. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='8'
  137. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  138. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=8
  139. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=8
  140. 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
  141. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  142. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 80
  143. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=80
  144. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='80'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  145. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=80
  146. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  147. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='80'
  148. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=80
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  149. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=80
  150. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='80'
  151. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=80
  152. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=80
      AND `file_is_image`=1
      AND `file_published`=1
  153. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=80
  154. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  155. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=80
      AND `file_is_image`=0
      AND `file_published`=1
  156. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='80'
  157. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  158. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=80
  159. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=80
  160. 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
  161. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  162. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 95
  163. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=95
  164. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='95'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  165. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=95
  166. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  167. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='95'
  168. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=95
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  169. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=95
  170. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='95'
  171. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=95
  172. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=95
      AND `file_is_image`=1
      AND `file_published`=1
  173. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=95
  174. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  175. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=95
      AND `file_is_image`=0
      AND `file_published`=1
  176. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='95'
  177. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  178. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=95
  179. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=95
  180. 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
  181. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  182. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 86
  183. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=86
  184. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='86'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  185. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=86
  186. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  187. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='86'
  188. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=86
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  189. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=86
  190. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='86'
  191. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=86
  192. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=86
      AND `file_is_image`=1
      AND `file_published`=1
  193. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=86
  194. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  195. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=86
      AND `file_is_image`=0
      AND `file_published`=1
  196. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='86'
  197. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  198. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=86
  199. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=86
  200. 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
  201. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  202. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 30
  203. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=30
  204. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='30'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  205. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=30
  206. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  207. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='30'
  208. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=30
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  209. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=30
  210. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='30'
  211. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=30
  212. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=30
      AND `file_is_image`=1
      AND `file_published`=1
  213. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=30
  214. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  215. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=30
      AND `file_is_image`=0
      AND `file_published`=1
  216. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='30'
  217. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  218. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=30
  219. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=30
  220. 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
  221. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  222. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 64
  223. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=64
  224. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='64'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  225. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=64
  226. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  227. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='64'
  228. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=64
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  229. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=64
  230. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='64'
  231. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=64
  232. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=64
      AND `file_is_image`=1
      AND `file_published`=1
  233. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=64
  234. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  235. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=64
      AND `file_is_image`=0
      AND `file_published`=1
  236. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='64'
  237. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  238. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=64
  239. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=64
  240. 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
  241. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  242. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 79
  243. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=79
  244. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='79'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  245. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=79
  246. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  247. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='79'
  248. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=79
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  249. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=79
  250. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='79'
  251. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=79
  252. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=79
      AND `file_is_image`=1
      AND `file_published`=1
  253. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=79
  254. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  255. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=79
      AND `file_is_image`=0
      AND `file_published`=1
  256. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='79'
  257. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  258. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=79
  259. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=79
  260. 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
  261. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  262. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 43
  263. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=43
  264. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='43'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  265. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=43
  266. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  267. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='43'
  268. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=43
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  269. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=43
  270. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='43'
  271. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=43
  272. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=43
      AND `file_is_image`=1
      AND `file_published`=1
  273. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=43
  274. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  275. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=43
      AND `file_is_image`=0
      AND `file_published`=1
  276. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='43'
  277. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  278. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=43
  279. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=43
  280. 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
  281. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  282. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 7
  283. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7
  284. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  285. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7
  286. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  287. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7'
  288. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  289. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7
  290. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7'
  291. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7
  292. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7
      AND `file_is_image`=1
      AND `file_published`=1
  293. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7
  294. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  295. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7
      AND `file_is_image`=0
      AND `file_published`=1
  296. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7'
  297. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  298. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7
  299. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7
  300. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 0)
      ORDER BY menuid DESC
      LIMIT 0, 1
  301. 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
  302. 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
  303. 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
  304. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (25)
  305. 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
  306. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  307. 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
  308. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (10)
  309. 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
  310. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (27)
  311. 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
  312. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (11)
  313. 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
  314. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (12)
  315. 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
  316. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (14)
  317. 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
  318. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (2)
  319. 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
  320. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (26)
  321. 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
  322. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (5)
  323. 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
  324. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (13)
  325. 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
  326. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (4)
  327. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  328. SELECT *
      FROM `jos_jnews_lists`
      WHERE `id` IN ( 17 )
      AND `published` = 1
  329. 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
  330. 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
  331. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  332. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 30
  333. 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
  334. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  335. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 8
  336. 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
  337. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  338. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 64
  339. 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
  340. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  341. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 7
  342. 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
  343. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  344. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 80
  345. 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
  346. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (10)
  347. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 90

347 legado de las queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'r7jvvk0ts4l0b0qifjbqvp87o0'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1550829153' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'r7jvvk0ts4l0b0qifjbqvp87o0'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'r7jvvk0ts4l0b0qifjbqvp87o0','1550830053','','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 COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  21. SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) AS num_rows
      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_category_xref`.`category_id`=3
     
      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'
  22. SELECT category_id, category_name
      FROM jos_vm_category
      WHERE category_id='3'
  23. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='3'
  24. SELECT category_id, category_thumb_image, category_child_id,category_name
      FROM jos_vm_category,jos_vm_category_xref
      WHERE jos_vm_category_xref.category_parent_id='3'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      AND jos_vm_category.vendor_id='1'
      AND jos_vm_category.category_publish='Y'
      ORDER BY jos_vm_category.list_order, jos_vm_category.category_name ASC
  25. 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='3'
      AND jos_vm_category.category_id='3'
  26. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  27. 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
  28. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  29. 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
  30. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  31. 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_category_xref`.`category_id`=3
     
      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, 100
  32. 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
  33. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  34. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 116
  35. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=116
  36. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='116'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  37. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=116
  38. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  39. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='116'
  40. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  41. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=116
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  42. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=116
  43. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='116'
  44. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=116
  45. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=116
      AND `file_is_image`=1
      AND `file_published`=1
  46. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=116
  47. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  48. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=116
      AND `file_is_image`=0
      AND `file_published`=1
  49. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='116'
  50. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  51. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=116
  52. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=116
  53. 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
  54. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  55. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 124
  56. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=124
  57. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='124'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  58. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=124
  59. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  60. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='124'
  61. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  62. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  63. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  64. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  65. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='124'
  66. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 124
  67. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  68. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  69. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  70. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  71. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=124
      AND `file_is_image`=1
      AND `file_published`=1
  72. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=124
  73. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  74. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=124
      AND `file_is_image`=0
      AND `file_published`=1
  75. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='124'
  76. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  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= 3
  78. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  79. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 88
  80. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=88
  81. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='88'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  82. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=88
  83. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  84. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='88'
  85. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=88
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  86. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=88
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  87. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=88
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  88. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=88
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  89. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='88'
  90. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 88
  91. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=88
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  92. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=88
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  93. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=88
  94. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=88
      AND `file_is_image`=1
      AND `file_published`=1
  95. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=88
  96. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  97. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=88
      AND `file_is_image`=0
      AND `file_published`=1
  98. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='88'
  99. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  100. 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
  101. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  102. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 9
  103. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9
  104. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  105. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9
  106. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  107. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9'
  108. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  109. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9
  110. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9'
  111. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9
  112. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9
      AND `file_is_image`=1
      AND `file_published`=1
  113. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9
  114. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  115. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9
      AND `file_is_image`=0
      AND `file_published`=1
  116. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9'
  117. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  118. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9
  119. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9
  120. 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
  121. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  122. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 8
  123. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=8
  124. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='8'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  125. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8
  126. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  127. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='8'
  128. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  129. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=8
  130. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='8'
  131. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=8
  132. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=8
      AND `file_is_image`=1
      AND `file_published`=1
  133. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8
  134. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  135. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=8
      AND `file_is_image`=0
      AND `file_published`=1
  136. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='8'
  137. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  138. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=8
  139. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=8
  140. 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
  141. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  142. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 80
  143. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=80
  144. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='80'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  145. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=80
  146. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  147. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='80'
  148. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=80
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  149. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=80
  150. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='80'
  151. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=80
  152. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=80
      AND `file_is_image`=1
      AND `file_published`=1
  153. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=80
  154. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  155. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=80
      AND `file_is_image`=0
      AND `file_published`=1
  156. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='80'
  157. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  158. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=80
  159. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=80
  160. 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
  161. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  162. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 95
  163. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=95
  164. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='95'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  165. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=95
  166. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  167. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='95'
  168. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=95
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  169. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=95
  170. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='95'
  171. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=95
  172. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=95
      AND `file_is_image`=1
      AND `file_published`=1
  173. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=95
  174. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  175. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=95
      AND `file_is_image`=0
      AND `file_published`=1
  176. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='95'
  177. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  178. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=95
  179. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=95
  180. 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
  181. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  182. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 86
  183. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=86
  184. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='86'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  185. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=86
  186. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  187. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='86'
  188. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=86
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  189. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=86
  190. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='86'
  191. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=86
  192. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=86
      AND `file_is_image`=1
      AND `file_published`=1
  193. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=86
  194. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  195. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=86
      AND `file_is_image`=0
      AND `file_published`=1
  196. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='86'
  197. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  198. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=86
  199. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=86
  200. 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
  201. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  202. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 30
  203. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=30
  204. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='30'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  205. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=30
  206. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  207. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='30'
  208. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=30
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  209. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=30
  210. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='30'
  211. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=30
  212. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=30
      AND `file_is_image`=1
      AND `file_published`=1
  213. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=30
  214. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  215. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=30
      AND `file_is_image`=0
      AND `file_published`=1
  216. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='30'
  217. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  218. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=30
  219. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=30
  220. 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
  221. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  222. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 64
  223. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=64
  224. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='64'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  225. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=64
  226. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  227. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='64'
  228. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=64
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  229. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=64
  230. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='64'
  231. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=64
  232. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=64
      AND `file_is_image`=1
      AND `file_published`=1
  233. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=64
  234. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  235. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=64
      AND `file_is_image`=0
      AND `file_published`=1
  236. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='64'
  237. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  238. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=64
  239. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=64
  240. 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
  241. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  242. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 79
  243. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=79
  244. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='79'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  245. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=79
  246. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  247. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='79'
  248. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=79
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  249. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=79
  250. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='79'
  251. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=79
  252. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=79
      AND `file_is_image`=1
      AND `file_published`=1
  253. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=79
  254. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  255. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=79
      AND `file_is_image`=0
      AND `file_published`=1
  256. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='79'
  257. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  258. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=79
  259. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=79
  260. 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
  261. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  262. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 43
  263. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=43
  264. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='43'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  265. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=43
  266. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  267. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='43'
  268. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=43
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  269. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=43
  270. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='43'
  271. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=43
  272. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=43
      AND `file_is_image`=1
      AND `file_published`=1
  273. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=43
  274. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  275. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=43
      AND `file_is_image`=0
      AND `file_published`=1
  276. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='43'
  277. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  278. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=43
  279. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=43
  280. 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
  281. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  282. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 7
  283. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7
  284. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  285. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7
  286. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550830053' OR start_date=0)
      AND (end_date>='1550792160' OR end_date=0)
      AND product_discount_id=discount_id
  287. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7'
  288. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  289. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7
  290. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7'
  291. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7
  292. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7
      AND `file_is_image`=1
      AND `file_published`=1
  293. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7
  294. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  295. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7
      AND `file_is_image`=0
      AND `file_published`=1
  296. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7'
  297. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  298. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7
  299. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7
  300. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 0)
      ORDER BY menuid DESC
      LIMIT 0, 1
  301. 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
  302. 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
  303. 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
  304. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (25)
  305. 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
  306. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  307. 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
  308. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (10)
  309. 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
  310. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (27)
  311. 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
  312. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (11)
  313. 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
  314. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (12)
  315. 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
  316. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (14)
  317. 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
  318. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (2)
  319. 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
  320. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (26)
  321. 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
  322. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (5)
  323. 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
  324. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (13)
  325. 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
  326. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (4)
  327. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  328. SELECT *
      FROM `jos_jnews_lists`
      WHERE `id` IN ( 17 )
      AND `published` = 1
  329. 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
  330. 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
  331. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  332. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 30
  333. 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
  334. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  335. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 8
  336. 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
  337. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  338. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 64
  339. 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
  340. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  341. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 7
  342. 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
  343. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  344. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 80
  345. 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
  346. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (10)
  347. 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