Perfect Petzzz
Navegação: Home Loja Perfect Petzzz

Papelaria Flor e Ani

Suas Compras

Mostrar Cesto
Nenhuma compra registrada.

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

Perfect Petzzz feed

Perfect Petzzz são brinquedos de pelúcia eletrônicos que simulam filhotes de cães e gatos com um impressionante movimento de respiração, assim como os detalhes de suas respectivas características físicas.

Sucesso de vendas em diversos países, os Perfect Petzzz se tornam cada vez mais o iten ideal para presentear os apaixonados por animais. 
 

Os filhotes de cães e gatos Perfect Petzzz são tão parecido com uma estimação de verdade que  todos irão se surpreender ! 

Os seus filhos vão amar!! 



Ordenar por:

Perfect Petzzz Border Collie

R$ 199,00


Filhote Perfect Petzzz - Border Collie
[Detalhes do Produto...]

Perfect Petzzz Gorilla

R$ 99,00


Filhote Perfect Petzzz - Gorilla
[Detalhes do Produto...]


Perfect Petzzz Panda

R$ 199,00


Filhote Perfect Petzzz - Panda
[Detalhes do Produto...]

Perfect Petzzz Dachshund

R$ 199,00


Filhote Perfect Petzzz - Dachshund
[Detalhes do Produto...]


Perfect Petzzz Yorkie Shire

R$ 199,00


Filhote Perfect Petzzz - Yorkie Shire
[Detalhes do Produto...]

Perfect Petzzz Gato Orange Tabby

R$ 199,00


Filhote Perfect Petzzz - Gato Orange Tabby
[Detalhes do Produto...]


Perfect Petzzz Gato Siames

R$ 199,00


Filhote Perfect Petzzz - Gato Siames
[Detalhes do Produto...]

Perfect Petzzz Boxer

R$ 199,00


Filhote Perfect Petzzz - Boxer
[Detalhes do Produto...]



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


Mostrar #  
Resultados 1 - 8 de 8

Busca por Produtos

Loja On Line

Ofertas Especiais


Mais Procurados

Painel Mural de fotos Estrelas Prata 40x73 - Geguton
Painel Mural de fotos Estrelas Prata 40x73 - Geguton
R$ 59,90

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

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

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

Informações de Perfil

Application afterLoad: 0.001 seconds, 0.90 MB
Application afterInitialise: 0.114 seconds, 7.85 MB
Application afterRoute: 0.126 seconds, 8.37 MB
Application afterDispatch: 0.508 seconds, 17.30 MB
Application afterRender: 0.808 seconds, 19.39 MB

Consumo de Memória

20382216

360 queries armazenadas no log

  1. DELETE
      FROM jos_session
      WHERE ( time < '1550326713' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = '84a3f8aa0adb3206549973a042087be0'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '84a3f8aa0adb3206549973a042087be0','1550330313','','0','1','0' )
  4. SELECT *
      FROM jos_components
      WHERE parent = 0
  5. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  6. SELECT name,player_id,ripper_id,postreplace
      FROM jos_avr_tags
  7. SELECT name,player_id,ripper_id,postreplace
      FROM jos_avr_tags
  8. SELECT *
      FROM `jos_rsfirewall_configuration`
  9. SELECT *
      FROM jos_rsfirewall_hashes
      WHERE `type`='1.5.8'
  10. SELECT *
      FROM jos_rsfirewall_hashes
      WHERE `type`='1.5.8'
  11. SELECT *
      FROM jos_rsfirewall_hashes
      WHERE `type`='protect'
  12. SELECT *
      FROM jos_rsfirewall_hashes
      WHERE `type`='protect'
  13. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  14. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 76)
      ORDER BY menuid DESC
      LIMIT 0, 1
  15. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  16. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
               
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  17. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  18. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  19. SELECT module_id, module_name
      FROM jos_vm_module
      ORDER BY module_name
  20. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  21. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  22. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  23. SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) AS num_rows
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=25
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
  24. SELECT category_id, category_name
      FROM jos_vm_category
      WHERE category_id='25'
  25. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='25'
  26. SELECT category_id, category_thumb_image, category_child_id,category_name
      FROM jos_vm_category,jos_vm_category_xref
      WHERE jos_vm_category_xref.category_parent_id='25'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      AND jos_vm_category.vendor_id='1'
      AND jos_vm_category.category_publish='Y'
      ORDER BY jos_vm_category.list_order, jos_vm_category.category_name ASC
  27. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  28. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='25'
      AND jos_vm_category.category_id='25'
  29. SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=25
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product_category_xref`.`product_list` ASC
      LIMIT 0, 20
  30. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=115
  31. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='115'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  32. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=115
  33. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  34. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='115'
  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=115
      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=115
  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='115'
  40. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=115
  41. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=115
      AND `file_is_image`=1
      AND `file_published`=1
  42. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=115
  43. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  44. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=115
      AND `file_is_image`=0
      AND `file_published`=1
  45. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='115'
  46. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  47. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=115
  48. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=115
  49. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=353
  50. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='353'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  51. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=353
  52. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  53. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='353'
  54. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=353
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  55. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=353
  56. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='353'
  57. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=353
  58. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=353
      AND `file_is_image`=1
      AND `file_published`=1
  59. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=353
  60. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  61. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=353
      AND `file_is_image`=0
      AND `file_published`=1
  62. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='353'
  63. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  64. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=353
  65. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=353
  66. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=350
  67. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='350'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  68. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=350
  69. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  70. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='350'
  71. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=350
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  72. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=350
  73. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='350'
  74. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=350
  75. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=350
      AND `file_is_image`=1
      AND `file_published`=1
  76. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=350
  77. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  78. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=350
      AND `file_is_image`=0
      AND `file_published`=1
  79. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='350'
  80. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  81. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=350
  82. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=350
  83. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=117
  84. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='117'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  85. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=117
  86. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  87. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='117'
  88. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=117
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  89. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=117
  90. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='117'
  91. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=117
  92. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=117
      AND `file_is_image`=1
      AND `file_published`=1
  93. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=117
  94. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  95. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=117
      AND `file_is_image`=0
      AND `file_published`=1
  96. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='117'
  97. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  98. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=117
  99. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=117
  100. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=190
  101. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='190'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  102. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=190
  103. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  104. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='190'
  105. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=190
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  106. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=190
  107. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='190'
  108. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=190
  109. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=190
      AND `file_is_image`=1
      AND `file_published`=1
  110. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=190
  111. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  112. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=190
      AND `file_is_image`=0
      AND `file_published`=1
  113. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='190'
  114. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  115. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=190
  116. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=190
  117. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=151
  118. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='151'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  119. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=151
  120. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  121. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='151'
  122. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=151
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  123. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=151
  124. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='151'
  125. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=151
  126. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=151
      AND `file_is_image`=1
      AND `file_published`=1
  127. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=151
  128. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  129. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=151
      AND `file_is_image`=0
      AND `file_published`=1
  130. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='151'
  131. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  132. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=151
  133. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=151
  134. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=187
  135. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='187'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  136. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=187
  137. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  138. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='187'
  139. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=187
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  140. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=187
  141. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='187'
  142. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=187
  143. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=187
      AND `file_is_image`=1
      AND `file_published`=1
  144. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=187
  145. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  146. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=187
      AND `file_is_image`=0
      AND `file_published`=1
  147. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='187'
  148. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  149. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=187
  150. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=187
  151. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=116
  152. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='116'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  153. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=116
  154. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  155. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='116'
  156. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=116
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  157. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=116
  158. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='116'
  159. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=116
  160. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=116
      AND `file_is_image`=1
      AND `file_published`=1
  161. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=116
  162. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  163. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=116
      AND `file_is_image`=0
      AND `file_published`=1
  164. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='116'
  165. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  166. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=116
  167. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=116
  168. SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 76 OR mm.menuid = 0 )
      ORDER BY position, ordering
  169. 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
  170. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='7894935004324'
  171. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=641
  172. 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`='641'
  173. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=641
  174. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='641'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  175. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=641
  176. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  177. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='641'
  178. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=641
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  179. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=641
  180. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='641'
  181. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=641
  182. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=641
  183. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='19657'
  184. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1215
  185. 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'
  186. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1215
  187. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1215'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  188. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1215
  189. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  190. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1215'
  191. 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
  192. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1215
  193. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1215'
  194. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1215
  195. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1215
  196. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='22718'
  197. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1441
  198. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='1441'
  199. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1441
  200. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1441'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  201. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1441
  202. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  203. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1441'
  204. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1441
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  205. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1441
  206. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1441'
  207. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1441
  208. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1441
  209. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='21848'
  210. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1445
  211. 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`='1445'
  212. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1445
  213. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1445'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  214. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1445
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330313' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  216. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1445'
  217. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1445
      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=1445
  219. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1445'
  220. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1445
  221. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1445
  222. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='0'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  223. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='69'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  224. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='17'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  225. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='103'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  226. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='30'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  227. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='28'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  228. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='105'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  229. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='66'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  230. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='73'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  231. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='74'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  232. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='75'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  233. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='106'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  234. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='62'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  235. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='15'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  236. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='101'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  237. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='97'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  238. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='102'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  239. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='100'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  240. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='99'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  241. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='98'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  242. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='39'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  243. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='89'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  244. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='85'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  245. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='104'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  246. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='88'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  247. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='86'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  248. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='87'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  249. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='58'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  250. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='107'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  251. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='116'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  252. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='110'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  253. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='115'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  254. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='112'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  255. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='111'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  256. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='109'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  257. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='108'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  258. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='113'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  259. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='114'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  260. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='59'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  261. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='79'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  262. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='32'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  263. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='33'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  264. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='36'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  265. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='38'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  266. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='37'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  267. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='72'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  268. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='40'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  269. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='61'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  270. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='47'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  271. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='78'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  272. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='84'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  273. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='46'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  274. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='83'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  275. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='16'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  276. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='55'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  277. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='29'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  278. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='41'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  279. SELECT category_name AS cname, category_id AS cid, category_child_id AS ccid
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='25'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  280. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  281. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  282. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  283. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  284. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  285. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  286. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  287. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  288. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  289. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  290. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  291. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  292. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  293. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  294. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  295. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  296. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  297. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  298. SELECT category_name AS cname, category_id AS cid, category_child_id 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
  299. 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
  300. 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
  301. SELECT product_id, product_name, product_parent_id, product_thumb_image,product_s_desc, product_full_image
      FROM jos_vm_product
      WHERE product_sku='21908'
  302. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1374
  303. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1374
  304. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1374'
      AND (start_date<='1550330314' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  305. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1374
  306. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330314' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  307. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1374'
  308. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1374
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  309. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1374
  310. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1374'
  311. 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'
  312. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1408
  313. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1408
  314. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1408'
      AND (start_date<='1550330314' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  315. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1408
  316. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330314' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  317. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1408'
  318. 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
  319. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1408
  320. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1408'
  321. SELECT product_id, product_name, product_parent_id, product_thumb_image,product_s_desc, product_full_image
      FROM jos_vm_product
      WHERE product_sku='20531'
  322. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1380
  323. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1380
  324. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1380'
      AND (start_date<='1550330314' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  325. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1380
  326. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330314' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  327. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1380'
  328. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1380
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  329. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1380
  330. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1380'
  331. SELECT product_id, product_name, product_parent_id, product_thumb_image,product_s_desc, product_full_image
      FROM jos_vm_product
      WHERE product_sku='20329'
  332. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1449
  333. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1449
  334. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1449'
      AND (start_date<='1550330314' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  335. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1449
  336. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330314' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  337. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1449'
  338. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1449
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  339. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1449
  340. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1449'
  341. SELECT product_id, product_name, product_parent_id, product_thumb_image,product_s_desc, product_full_image
      FROM jos_vm_product
      WHERE product_sku='7894935097111'
  342. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1326
  343. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1326
  344. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1326'
      AND (start_date<='1550330314' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  345. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1326
  346. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330314' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  347. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1326'
  348. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1326
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  349. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1326
  350. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1326'
  351. SELECT product_id, product_name, product_parent_id, product_thumb_image,product_s_desc, product_full_image
      FROM jos_vm_product
      WHERE product_sku='7899653221732'
  352. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1431
  353. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1431
  354. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1431'
      AND (start_date<='1550330314' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  355. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1431
  356. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1550330314' OR start_date=0)
      AND (end_date>='1550273760' OR end_date=0)
      AND product_discount_id=discount_id
  357. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1431'
  358. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1431
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  359. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1431
  360. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1431'

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