Navegação: Home

Papelaria Flor e Ani

Suas Compras

Nenhuma compra registrada.

Papelaria Floreani

                     

Produtos em Destaque

Kit sushi coração - Uatt
Kit sushi coração - Uatt
R$ 81,90

Pau de selfie Monopod preto - Uatt
Pau de selfie Monopod preto - Uatt
R$ 39,90

Copo canudo perfeitos - Uatt
Copo canudo perfeitos - Uatt
R$ 43,90

Caneca c/ tampa Luxo - Uatt
Caneca c/ tampa Luxo - Uatt
R$ 48,90

Necessaire Savage c/ alça 11018 Marrom - TN
Necessaire Savage c/ alça 11018 Marrom - TN
R$ 74,90

Capa p/ Notebook 14" Diva - Uatt
Capa p/ Notebook 14
R$ 49,90

Caneca Corujinhas - Uatt
Caneca Corujinhas - Uatt
R$ 47,90

Lancheira Escolar Barbie Portal Secreto 063521-43 - Sestini
Lancheira Escolar Barbie Portal Secreto 063521-43 - Sestini
R$ 99,90

Copo Termico Você me faz tão bem - Uatt
Copo Termico Você me faz tão bem - Uatt
R$ 42,90

 

Busca por Produtos

Loja On Line

Ofertas Especiais


Mais Procurados

Caneca Caneconserva Seja Livre - Uatt
Caneca Caneconserva Seja Livre - Uatt
R$ 53,90

Caneca de Formatura Formando - Uatt
Caneca de Formatura Formando - Uatt
R$ 54,90

Porta-Lápis Ônibus Londres - Geguton
Porta-Lápis Ônibus Londres - Geguton
R$ 37,90

Copo canudo perfeitos - Uatt
Copo canudo perfeitos - Uatt
R$ 43,90

Informações de Perfil

Application afterLoad: 0.000 seconds, 0.89 MB
Application afterInitialise: 0.051 seconds, 7.85 MB
Application afterRoute: 0.056 seconds, 8.36 MB
Application afterDispatch: 0.075 seconds, 10.27 MB
Application afterRender: 0.283 seconds, 18.71 MB

Consumo de Memória

19667952

330 queries armazenadas no log

  1. DELETE
      FROM jos_session
      WHERE ( time < '1537472202' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = '90c73640ed840ce1a53413dc1a368a33'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '90c73640ed840ce1a53413dc1a368a33','1537475802','','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 = 1)
      ORDER BY menuid DESC
      LIMIT 0, 1
  15. SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access 
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = cc.section
      AND s.scope = "content"
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE a.id = 93
      AND (  ( a.created_by = 0 )    OR  ( a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-09-20 20:36:42' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-09-20 20:36:42' )   )    OR  ( a.state = -1 )  )
  16. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='93'
  17. SELECT g.*
      FROM jos_core_acl_aro_groups AS g
      INNER JOIN jos_core_acl_groups_aro_map AS gm
      ON gm.group_id = g.id
      INNER JOIN jos_core_acl_aro AS ao
      ON ao.id = gm.aro_id
      WHERE ao.value='62'
      ORDER BY g.id
  18. SELECT id, parent_id, value, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=23
  19. 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 = 1 OR mm.menuid = 0 )
      ORDER BY position, ordering
  20. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  21. 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'
  22. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  23. 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`);
  24. 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
  25. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='23288'
  26. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1438
  27. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='1438'
  28. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  29. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  30. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1438
  31. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1438'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  32. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1438
  33. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  34. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1438'
  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=1438
      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=1438
  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='1438'
  40. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1438
  41. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1438
  42. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='20975'
  43. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1364
  44. 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`='1364'
  45. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1364
  46. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1364'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  47. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1364
  48. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  49. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1364'
  50. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1364
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  51. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1364
  52. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1364'
  53. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1364
  54. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1364
  55. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='7894935097111'
  56. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1326
  57. 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`='1326'
  58. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1326
  59. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1326'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  60. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1326
  61. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  62. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1326'
  63. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1326
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  64. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1326
  65. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1326'
  66. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1326
  67. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1326
  68. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='21351'
  69. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1319
  70. 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`='1319'
  71. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1319
  72. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1319'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  73. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1319
  74. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  75. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1319'
  76. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1319
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  77. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1319
  78. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1319'
  79. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1319
  80. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1319
  81. 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
  82. 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
  83. 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
  84. 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
  85. 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
  86. 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
  87. 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
  88. 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
  89. 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
  90. 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
  91. 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
  92. 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
  93. 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
  94. 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
  95. 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
  96. 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
  97. 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
  98. 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
  99. 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
  100. 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
  101. 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
  102. 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
  103. 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
  104. 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
  105. 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
  106. 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
  107. 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
  108. 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
  109. 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
  110. 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
  111. 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
  112. 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
  113. 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
  114. 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
  115. 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
  116. 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
  117. 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
  118. 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
  119. 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
  120. 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
  121. 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
  122. 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
  123. 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
  124. 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
  125. 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
  126. 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
  127. 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
  128. 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
  129. 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
  130. 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
  131. 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
  132. 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
  133. 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
  134. 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
  135. 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
  136. 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
  137. 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
  138. 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
  139. 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
  140. 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
  141. 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
  142. 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
  143. 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
  144. 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
  145. 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
  146. 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
  147. 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
  148. 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
  149. 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
  150. 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
  151. 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
  152. 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
  153. 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
  154. 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
  155. 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
  156. 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
  157. 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
  158. 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
  159. 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
  160. SELECT product_id, product_name, product_parent_id, product_thumb_image,product_s_desc, product_full_image
      FROM jos_vm_product
      WHERE product_sku='20058'
  161. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=461
  162. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=461
  163. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='461'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=461
  165. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='461'
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=461
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  168. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=461
  169. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='461'
  170. 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'
  171. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=638
  172. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=638
  173. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='638'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  174. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=638
  175. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  176. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='638'
  177. 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
  178. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=638
  179. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='638'
  180. SELECT product_id, product_name, product_parent_id, product_thumb_image,product_s_desc, product_full_image
      FROM jos_vm_product
      WHERE product_sku='20329'
  181. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1449
  182. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1449
  183. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1449'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  184. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1449
  185. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  186. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1449'
  187. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1449
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  188. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1449
  189. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1449'
  190. SELECT product_id, product_name, product_parent_id, product_thumb_image,product_s_desc, product_full_image
      FROM jos_vm_product
      WHERE product_sku='7895391109288pr'
  191. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1407
  192. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1407
  193. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1407'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  194. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1407
  195. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  196. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1407'
  197. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1407
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  198. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1407
  199. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1407'
  200. SELECT product_id, product_name, product_parent_id, product_thumb_image,product_s_desc, product_full_image
      FROM jos_vm_product
      WHERE product_sku='7895391109271PR'
  201. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1417
  202. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1417
  203. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1417'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  204. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1417
  205. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  206. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1417'
  207. 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
  208. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1417
  209. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1417'
  210. SELECT product_id, product_name, product_parent_id, product_thumb_image,product_s_desc, product_full_image
      FROM jos_vm_product
      WHERE product_sku='7895391109141'
  211. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1424
  212. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1424
  213. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1424'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  214. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1424
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  216. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1424'
  217. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1424
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  218. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1424
  219. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1424'
  220. SELECT DISTINCT product_sku
      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, 9
  221. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='21341'
  222. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1320
  223. 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`='1320'
  224. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1320
  225. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1320'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  226. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1320
  227. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  228. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1320'
  229. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1320
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  230. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1320
  231. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1320'
  232. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1320
  233. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1320
  234. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='22718'
  235. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1441
  236. 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`='1441'
  237. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1441
  238. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1441'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  239. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1441
  240. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  241. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1441'
  242. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1441
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  243. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1441
  244. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1441'
  245. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1441
  246. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1441
  247. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='21351'
  248. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1319
  249. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1319
  250. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1319'
  251. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1319
  252. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1319
  253. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='23191'
  254. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1436
  255. 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`='1436'
  256. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1436
  257. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1436'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  258. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1436
  259. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  260. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1436'
  261. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1436
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  262. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1436
  263. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1436'
  264. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1436
  265. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1436
  266. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='7895391109288mr'
  267. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1408
  268. 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`='1408'
  269. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1408
  270. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1408'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  271. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1408
  272. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  273. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1408'
  274. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1408
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  275. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1408
  276. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1408'
  277. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1408
  278. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1408
  279. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='20051'
  280. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1204
  281. 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`='1204'
  282. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1204
  283. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1204'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  284. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1204
  285. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  286. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1204'
  287. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1204
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  288. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1204
  289. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1204'
  290. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1204
  291. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1204
  292. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='22398'
  293. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1365
  294. 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`='1365'
  295. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1365
  296. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1365'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  297. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1365
  298. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  299. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1365'
  300. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1365
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  301. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1365
  302. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1365'
  303. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1365
  304. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1365
  305. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='7899650103390'
  306. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1429
  307. 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`='1429'
  308. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1429
  309. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1429'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  310. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1429
  311. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  312. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1429'
  313. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1429
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  314. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1429
  315. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1429'
  316. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1429
  317. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1429
  318. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='21450'
  319. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1369
  320. 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`='1369'
  321. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1369
  322. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1369'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  323. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1369
  324. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1537475802' OR start_date=0)
      AND (end_date>='1537400160' OR end_date=0)
      AND product_discount_id=discount_id
  325. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1369'
  326. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1369
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  327. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1369
  328. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1369'
  329. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1369
  330. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1369

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