Navegação: Home Loja Almofadas Touch

Papelaria Flor e Ani

Suas Compras

Nenhuma compra registrada.


                     
Informação: Seu navegador não aceita cookies. Para colocar produtos em seu cesto e comprá-los você precisa habilitar os cookies.

Almofadas Touch feed

Lindas e divertidas almofadas com um toque que proporciona uma sensação relaxante e agradável.



Ordenar por:

Almofada Longa Gatinha Uatt

R$ 39,90


Nosso mais novo sucesso!!! Almofadinha enorme, pra deixar qualquer cantinho bem mais bacana!
[Detalhes do Produto...]

Almofada Pescoço Touch Preta Uatt

R$ 63,90


Almofofa, sua companheira de viagem. Macia e confortável!
[Detalhes do Produto...]


Almofada Pescoço Touch Vermelha Uatt

R$ 63,90


Almofofa, sua companheira de viagem. Macia e confortável!
[Detalhes do Produto...]

Porta Pijama Beijinho Ludi

R$ 29,90


Linda caixinha pra colocar sua foto e tudo que você quiser!
[Detalhes do Produto...]


Almofada Pescoço Touch Pink Uatt

R$ 63,90


Almofofa, sua companheira de viagem. Macia e confortável!
[Detalhes do Produto...]

Almofada Pescoço Touch Violeta Uatt

R$ 63,90


Almofofa, sua companheira de viagem. Macia e confortável!
[Detalhes do Produto...]


Almofada Controle Remoto Pai Uatt

R$ 29,90


Super novidade! Almofada com bolsos nas costas!
[Detalhes do Produto...]


  • «« Início
  • « Anterior
  • 1
  • Próximo »
  • Final »»


Mostrar #  
Resultados 1 - 7 de 7

Busca por Produtos

Loja On Line

Ofertas Especiais


Mais Procurados

Necessaire Florence 11017 Preta - TN
Necessaire Florence 11017 Preta - TN
R$ 41,90

Necessaire La Petite 11021 Verde - TN
Necessaire La Petite 11021 Verde - TN
R$ 56,90

Fone de ouvido Headphone Luxo - Uatt
Fone de ouvido Headphone Luxo - Uatt
R$ 119,90

Squeeze Corujinhas 600 ml - Uatt
Squeeze Corujinhas 600 ml - Uatt
R$ 53,90

Informações de Perfil

Application afterLoad: 0.001 seconds, 0.90 MB
Application afterInitialise: 0.047 seconds, 7.86 MB
Application afterRoute: 0.059 seconds, 8.37 MB
Application afterDispatch: 0.565 seconds, 17.27 MB
Application afterRender: 0.700 seconds, 19.36 MB

Consumo de Memória

20346672

341 queries armazenadas no log

  1. DELETE
      FROM jos_session
      WHERE ( time < '1524732015' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = '866b0d25dfe7dbd938fd9ed6e20c2d6d'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '866b0d25dfe7dbd938fd9ed6e20c2d6d','1524735615','','0','1','0' )
  4. SELECT *
      FROM jos_components
      WHERE parent = 0
  5. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  6. SELECT name,player_id,ripper_id,postreplace
      FROM jos_avr_tags
  7. SELECT name,player_id,ripper_id,postreplace
      FROM jos_avr_tags
  8. SELECT *
      FROM `jos_rsfirewall_configuration`
  9. SELECT *
      FROM jos_rsfirewall_hashes
      WHERE `type`='1.5.8'
  10. SELECT *
      FROM jos_rsfirewall_hashes
      WHERE `type`='1.5.8'
  11. SELECT *
      FROM jos_rsfirewall_hashes
      WHERE `type`='protect'
  12. SELECT *
      FROM jos_rsfirewall_hashes
      WHERE `type`='protect'
  13. 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
  14. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 76)
      ORDER BY menuid DESC
      LIMIT 0, 1
  15. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  16. 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'
  17. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  18. 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`);
  19. SELECT module_id, module_name
      FROM jos_vm_module
      ORDER BY module_name
  20. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  21. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  22. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  23. 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`=17
     
      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'
  24. SELECT category_id, category_name
      FROM jos_vm_category
      WHERE category_id='17'
  25. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='17'
  26. 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='17'
      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
  27. 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='17'
      AND jos_vm_category.category_id='17'
  28. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  29. 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`=17
     
      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_category_xref`.`product_list` ASC
      LIMIT 0, 20
  30. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=405
  31. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='405'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  32. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=405
  33. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  34. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='405'
  35. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  36. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=405
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  37. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=405
  38. 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
  39. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='405'
  40. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=405
  41. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=405
      AND `file_is_image`=1
      AND `file_published`=1
  42. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=405
  43. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  44. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=405
      AND `file_is_image`=0
      AND `file_published`=1
  45. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='405'
  46. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  47. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=405
  48. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=405
  49. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=410
  50. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='410'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  51. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=410
  52. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  53. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='410'
  54. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=410
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  55. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=410
  56. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='410'
  57. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=410
  58. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=410
      AND `file_is_image`=1
      AND `file_published`=1
  59. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=410
  60. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  61. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=410
      AND `file_is_image`=0
      AND `file_published`=1
  62. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='410'
  63. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  64. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=410
  65. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=410
  66. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=760
  67. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='760'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  68. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=760
  69. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  70. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='760'
  71. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=760
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  72. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=760
  73. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='760'
  74. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=760
  75. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=760
      AND `file_is_image`=1
      AND `file_published`=1
  76. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=760
  77. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  78. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=760
      AND `file_is_image`=0
      AND `file_published`=1
  79. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='760'
  80. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  81. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=760
  82. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=760
  83. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=824
  84. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='824'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  85. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=824
  86. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  87. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='824'
  88. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=824
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  89. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=824
  90. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='824'
  91. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=824
  92. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=824
      AND `file_is_image`=1
      AND `file_published`=1
  93. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=824
  94. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  95. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=824
      AND `file_is_image`=0
      AND `file_published`=1
  96. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='824'
  97. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  98. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=824
  99. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=824
  100. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1062
  101. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1062'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  102. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1062
  103. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  104. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1062'
  105. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1062
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  106. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1062
  107. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1062'
  108. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1062
  109. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1062
      AND `file_is_image`=1
      AND `file_published`=1
  110. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1062
  111. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  112. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1062
      AND `file_is_image`=0
      AND `file_published`=1
  113. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1062'
  114. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  115. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1062
  116. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1062
  117. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1063
  118. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1063'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  119. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1063
  120. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  121. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1063'
  122. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1063
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  123. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1063
  124. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1063'
  125. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1063
  126. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1063
      AND `file_is_image`=1
      AND `file_published`=1
  127. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1063
  128. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  129. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1063
      AND `file_is_image`=0
      AND `file_published`=1
  130. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1063'
  131. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  132. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1063
  133. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1063
  134. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=283
  135. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='283'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  136. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=283
  137. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  138. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='283'
  139. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=283
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  140. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=283
  141. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='283'
  142. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=283
  143. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=283
      AND `file_is_image`=1
      AND `file_published`=1
  144. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=283
      AND `file_is_image`=0
      AND `file_published`=1
  145. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='283'
  146. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  147. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=283
  148. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=283
  149. 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 = 76 OR mm.menuid = 0 )
      ORDER BY position, ordering
  150. SELECT DISTINCT product_sku, product_desc
      FROM jos_vm_product
      WHERE (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')
      AND vendor_id='1'
      AND jos_vm_product.product_publish='Y'
      AND jos_vm_product.product_special='Y'
      ORDER BY RAND()
      LIMIT 0, 4
  151. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='7895391109271PR'
  152. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1417
  153. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='1417'
  154. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1417
  155. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1417'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  156. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1417
  157. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  158. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1417'
  159. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1417
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  160. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1417
  161. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1417'
  162. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1417
  163. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1417
  164. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='7895391109318vd'
  165. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1411
  166. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='1411'
  167. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1411
  168. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1411'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  169. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1411
  170. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  171. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1411'
  172. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1411
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  173. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1411
  174. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1411'
  175. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1411
  176. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1411
  177. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='22980'
  178. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1433
  179. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='1433'
  180. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1433
  181. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1433'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  182. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1433
  183. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  184. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1433'
  185. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1433
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  186. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1433
  187. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1433'
  188. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1433
  189. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1433
  190. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='21847'
  191. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1444
  192. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='1444'
  193. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1444
  194. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1444'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  195. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1444
  196. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  197. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1444'
  198. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1444
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  199. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1444
  200. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1444'
  201. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1444
  202. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1444
  203. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='0'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  204. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='69'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  205. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='17'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  206. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='103'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  207. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='30'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  208. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='28'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  209. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='105'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  210. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='66'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  211. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='73'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  212. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='74'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  213. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='75'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  214. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='106'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  215. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='62'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  216. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='15'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  217. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='101'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  218. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='97'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  219. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='102'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  220. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='100'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  221. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='99'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  222. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='98'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  223. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='39'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  224. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='89'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  225. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='85'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  226. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='104'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  227. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='88'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  228. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='86'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  229. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='87'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  230. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='58'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  231. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='107'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  232. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='116'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  233. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='110'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  234. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='115'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  235. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='112'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  236. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='111'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  237. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='109'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  238. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='108'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  239. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='113'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  240. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='114'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  241. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='59'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  242. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='79'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  243. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='32'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  244. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='33'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  245. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='36'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  246. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='38'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  247. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='37'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  248. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='72'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  249. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='40'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  250. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='61'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  251. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='47'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  252. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='78'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  253. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='84'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  254. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='46'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  255. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='83'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  256. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='16'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  257. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='55'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  258. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='29'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  259. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='41'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  260. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='25'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  261. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='56'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  262. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='26'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  263. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='27'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  264. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='21'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  265. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='22'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  266. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='23'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  267. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='24'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  268. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='45'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  269. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='65'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  270. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='57'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  271. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='94'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  272. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='90'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  273. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='95'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  274. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='93'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  275. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='92'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  276. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='91'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  277. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='80'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  278. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='31'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  279. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='44'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  280. 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
  281. SELECT DISTINCT product_sku
      FROM jos_vm_product
      WHERE product_parent_id=''
      AND vendor_id='1'
      AND jos_vm_product.product_publish='Y' 
      AND product_special = 'Y' 
      ORDER BY RAND()
      LIMIT 6
  282. SELECT product_id, product_name, product_parent_id, product_thumb_image,product_s_desc, product_full_image
      FROM jos_vm_product
      WHERE product_sku='7894935088065'
  283. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=638
  284. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=638
  285. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='638'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  286. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=638
  287. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  288. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='638'
  289. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=638
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  290. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=638
  291. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='638'
  292. SELECT product_id, product_name, product_parent_id, product_thumb_image,product_s_desc, product_full_image
      FROM jos_vm_product
      WHERE product_sku='21447'
  293. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1440
  294. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1440
  295. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1440'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  296. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1440
  297. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  298. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1440'
  299. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1440
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  300. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1440
  301. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1440'
  302. SELECT product_id, product_name, product_parent_id, product_thumb_image,product_s_desc, product_full_image
      FROM jos_vm_product
      WHERE product_sku='22639'
  303. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1435
  304. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1435
  305. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1435'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  306. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1435
  307. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  308. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1435'
  309. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1435
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  310. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1435
  311. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1435'
  312. SELECT product_id, product_name, product_parent_id, product_thumb_image,product_s_desc, product_full_image
      FROM jos_vm_product
      WHERE product_sku='7895391108205'
  313. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1361
  314. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1361
  315. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1361'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  316. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1361
  317. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  318. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1361'
  319. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1361
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  320. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1361
  321. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1361'
  322. SELECT product_id, product_name, product_parent_id, product_thumb_image,product_s_desc, product_full_image
      FROM jos_vm_product
      WHERE product_sku='16943'
  323. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=340
  324. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=340
  325. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='340'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  326. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=340
  327. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  328. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='340'
  329. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=340
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  330. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=340
  331. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='340'
  332. SELECT product_id, product_name, product_parent_id, product_thumb_image,product_s_desc, product_full_image
      FROM jos_vm_product
      WHERE product_sku='18625'
  333. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1321
  334. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1321
  335. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1321'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  336. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1321
  337. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1524735615' OR start_date=0)
      AND (end_date>='1524699360' OR end_date=0)
      AND product_discount_id=discount_id
  338. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1321'
  339. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1321
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  340. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1321
  341. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1321'

4 queries em modo de compatibilidade armazenadas no log

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

      FROM jos_core_acl_aro_groups AS g1

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

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

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

      FROM jos_core_acl_aro_groups AS g1

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

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft

Arquivos de Idioma carregados

Untranslated Strings Diagnostic

Nenhum

Untranslated Strings Designer

Nenhum