Navegação: Home

Papelaria Flor e Ani

Suas Compras

Nenhuma compra registrada.

Papelaria Floreani

                     

Produtos em Destaque

Mochila Savage 13018 Marrom - TN
Mochila Savage 13018 Marrom - TN
R$ 249,90

Capa p/ Netbook Confetes - Uatt
Capa p/ Netbook Confetes - Uatt
R$ 48,90

Jogo de Bilhar Mini Mesa de Sinuca - Uatt
Jogo de Bilhar Mini Mesa de Sinuca - Uatt
R$ 179,90

Caneca mixer Mistura Tudo - Uatt
Caneca mixer Mistura Tudo - Uatt
R$ 88,90

Mouse Pad gel Corujinhas - Uatt
Mouse Pad gel Corujinhas - Uatt
R$ 31,90

Mouse Pad gel Vaquinha - Uatt
Mouse Pad gel Vaquinha - Uatt
R$ 31,90

Mochila Piton 1390 - TN
Mochila Piton 1390 - TN
R$ 239,90

Plastificadora 2401 220v. - Menno
Plastificadora 2401 220v. - Menno
R$ 399,90

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

 

Busca por Produtos

Loja On Line

Ofertas Especiais


Mais Procurados

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

Painel Mural de Fotos Teen Rosa 40x73 - Geguton
Painel Mural de Fotos Teen Rosa 40x73 - Geguton
R$ 69,90

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

Cofre 20 EK 20x31x20cm - Menno
Cofre 20 EK 20x31x20cm - Menno
R$ 279,90

Informações de Perfil

Application afterLoad: 0.000 seconds, 0.89 MB
Application afterInitialise: 0.082 seconds, 7.84 MB
Application afterRoute: 0.092 seconds, 8.36 MB
Application afterDispatch: 0.450 seconds, 10.26 MB
Application afterRender: 1.417 seconds, 18.72 MB

Consumo de Memória

19676016

337 queries armazenadas no log

  1. DELETE
      FROM jos_session
      WHERE ( time < '1490267359' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = '7c696fd9f8d14301c71f75092cad2fea'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '7c696fd9f8d14301c71f75092cad2fea','1490270959','','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 <= '2017-03-23 12:09:19' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-03-23 12:09:19' )   )    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='22382'
  26. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1371
  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`='1371'
  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`=1371
  31. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1371'
      AND (start_date<='1490270959' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  32. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1371
  33. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270959' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  34. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1371'
  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=1371
      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=1371
  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='1371'
  40. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1371
  41. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1371
  42. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='7894935075867'
  43. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=687
  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`='687'
  45. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=687
  46. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='687'
      AND (start_date<='1490270959' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  47. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=687
  48. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270959' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  49. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='687'
  50. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=687
      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=687
  52. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='687'
  53. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=687
  54. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=687
  55. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='7895391109509MA'
  56. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1426
  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`='1426'
  58. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1426
  59. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1426'
      AND (start_date<='1490270959' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  60. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1426
  61. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270959' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  62. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1426'
  63. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1426
      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=1426
  65. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1426'
  66. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1426
  67. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1426
  68. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='7897075820557'
  69. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1315
  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`='1315'
  71. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1315
  72. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1315'
      AND (start_date<='1490270959' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  73. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1315
  74. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270959' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  75. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1315'
  76. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1315
      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=1315
  78. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1315'
  79. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1315
  80. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1315
  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='22980'
  161. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1433
  162. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1433
  163. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1433'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1433
  165. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1433'
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1433
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  168. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1433
  169. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1433'
  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='7895391109295bg'
  171. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1401
  172. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1401
  173. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1401'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  174. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1401
  175. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  176. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1401'
  177. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1401
      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=1401
  179. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1401'
  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='7894935004607'
  181. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=644
  182. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=644
  183. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='644'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  184. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=644
  185. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  186. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='644'
  187. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=644
      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=644
  189. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='644'
  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='7895391109745'
  191. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1410
  192. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1410
  193. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1410'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  194. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1410
  195. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  196. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1410'
  197. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1410
      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=1410
  199. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1410'
  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='20059'
  201. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1200
  202. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1200
  203. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1200'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  204. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1200
  205. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  206. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1200'
  207. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1200
      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=1200
  209. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1200'
  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='7895391109318vd'
  211. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1411
  212. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1411
  213. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1411'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  214. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1411
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  216. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1411'
  217. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1411
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  218. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1411
  219. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1411'
  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='7895391109691mr'
  222. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1404
  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`='1404'
  224. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1404
  225. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1404'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  226. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1404
  227. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  228. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1404'
  229. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1404
      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=1404
  231. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1404'
  232. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1404
  233. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1404
  234. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='17840'
  235. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=788
  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`='788'
  237. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=788
  238. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='788'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  239. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=788
  240. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  241. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='788'
  242. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=788
      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=788
  244. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='788'
  245. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=788
  246. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=788
  247. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='19657'
  248. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1215
  249. 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`='1215'
  250. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1215
  251. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1215'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  252. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1215
  253. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  254. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1215'
  255. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1215
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  256. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1215
  257. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1215'
  258. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1215
  259. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1215
  260. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='21347'
  261. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1367
  262. 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`='1367'
  263. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1367
  264. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1367'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  265. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1367
  266. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  267. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1367'
  268. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1367
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  269. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1367
  270. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1367'
  271. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1367
  272. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1367
  273. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='20778'
  274. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1447
  275. 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`='1447'
  276. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1447
  277. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1447'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  278. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1447
  279. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  280. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1447'
  281. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1447
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  282. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1447
  283. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1447'
  284. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1447
  285. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1447
  286. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='19827'
  287. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1376
  288. 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`='1376'
  289. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1376
  290. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1376'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  291. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1376
  292. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  293. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1376'
  294. 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
  295. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1376
  296. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1376'
  297. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1376
  298. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1376
  299. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='7895391108205'
  300. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1361
  301. 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`='1361'
  302. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1361
  303. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1361'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  304. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1361
  305. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  306. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1361'
  307. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1361
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  308. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1361
  309. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1361'
  310. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1361
  311. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1361
  312. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='7897075818875'
  313. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1328
  314. 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`='1328'
  315. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1328
  316. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1328'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  317. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1328
  318. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  319. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1328'
  320. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1328
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  321. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1328
  322. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1328'
  323. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1328
  324. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1328
  325. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='7895391109288pr'
  326. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1407
  327. 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`='1407'
  328. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1407
  329. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1407'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  330. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1407
  331. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1490270960' OR start_date=0)
      AND (end_date>='1490225760' OR end_date=0)
      AND product_discount_id=discount_id
  332. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1407'
  333. 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
  334. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1407
  335. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1407'
  336. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1407
  337. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1407

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