Garantias
Navegação: Home Garantias

Papelaria Flor e Ani

Suas Compras

Mostrar Cesto
Nenhuma compra registrada.

                     

Garantias

As garantias variam de acordo com cada fabricante, na qual o cliente deve enviar o produto que apresentou defeito a Papelaria Flor e Ani com frete PAGO (por conta do cliente), e irá recebe-lo após a troca ou conserto também com frete PAGO (Por conta da Papelaria Flor e Ani).

A papelaria Flor e Ani trabalha dentro da legislação de defesa do consumidor, com prazos e demais condições de garantias obedecendo o CDC Brasileiro.

Para maiores informações entre em contato conosco.

 

Busca por Produtos

Loja On Line

Ofertas Especiais


Mais Procurados

Caneca c/ porta copos Milk and Cookie - Uatt
Caneca c/ porta copos Milk and Cookie - Uatt
R$ 36,90

Mochila Mountain 13009 Marrom - TN
Mochila Mountain 13009 Marrom - TN
R$ 276,90

Mochila L Amour 13022 preta - TN
Mochila L Amour 13022 preta - TN
R$ 332,90

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

Informações de Perfil

Application afterLoad: 0.000 seconds, 0.90 MB
Application afterInitialise: 0.042 seconds, 7.86 MB
Application afterRoute: 0.050 seconds, 8.37 MB
Application afterDispatch: 0.067 seconds, 10.28 MB
Application afterRender: 0.218 seconds, 18.46 MB

Consumo de Memória

19396384

219 queries armazenadas no log

  1. DELETE
      FROM jos_session
      WHERE ( time < '1534516356' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = '9aa36f6eddee6dccc80bae080d0dcece'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '9aa36f6eddee6dccc80bae080d0dcece','1534519956','','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 = 29)
      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 = 95
      AND (  ( a.created_by = 0 )    OR  ( a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-08-17 15:32:36' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-08-17 15:32:36' )   )    OR  ( a.state = -1 )  )
  16. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='95'
  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 = 29 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='22557'
  26. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1366
  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`='1366'
  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`=1366
  31. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1366'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  32. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1366
  33. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  34. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1366'
  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=1366
      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=1366
  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='1366'
  40. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1366
  41. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1366
  42. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='7895391109509MR'
  43. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1425
  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`='1425'
  45. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1425
  46. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1425'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  47. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1425
  48. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  49. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1425'
  50. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1425
      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=1425
  52. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1425'
  53. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1425
  54. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1425
  55. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='7895391109776'
  56. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1409
  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`='1409'
  58. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1409
  59. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1409'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  60. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1409
  61. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  62. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1409'
  63. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1409
      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=1409
  65. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1409'
  66. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1409
  67. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1409
  68. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='21847'
  69. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1444
  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`='1444'
  71. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1444
  72. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1444'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  73. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1444
  74. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  75. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1444'
  76. 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
  77. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1444
  78. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1444'
  79. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1444
  80. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1444
  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='18409'
  161. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=448
  162. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=448
  163. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='448'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=448
  165. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='448'
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=448
      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=448
  169. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='448'
  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='19827'
  171. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1376
  172. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1376
  173. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1376'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  174. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1376
  175. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  176. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1376'
  177. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1376
      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=1376
  179. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1376'
  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='7899650103598'
  181. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1432
  182. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1432
  183. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1432'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  184. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1432
  185. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  186. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1432'
  187. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1432
      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=1432
  189. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1432'
  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='21349'
  191. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=594
  192. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=594
  193. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='594'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  194. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=594
  195. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  196. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='594'
  197. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=594
      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=594
  199. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='594'
  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='19825'
  201. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1448
  202. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1448
  203. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1448'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  204. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1448
  205. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  206. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1448'
  207. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1448
      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=1448
  209. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1448'
  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='7895391109288mr'
  211. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1408
  212. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1408
  213. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1408'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  214. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1408
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1534519956' OR start_date=0)
      AND (end_date>='1534462560' OR end_date=0)
      AND product_discount_id=discount_id
  216. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1408'
  217. 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
  218. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1408
  219. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1408'

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