BUSCAR PRODUCTO

ENTRAR A COMPRAR






RECIBE EL BOLETIN

Estamos en Facebook

Norton Safe Web

VirtueMart
Su carro está vacío.

Correo electrónico
Trucos De Magia arrow Psychic Color Sticks


Psychic Color Sticks
Ver imagen grande


Psychic Color Sticks

( Fabricante Certificado )
$ 200.00






Opiniones de los usuarios:

No hay opiniones para este producto.
Por favor, registrese para escribir una opinión.




DISTRIBUIDOR DE

first
  
last
 
 
start
stop

Contador de Visitas

mod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_counter
mod_vvisit_counterDesde Febrero 200764242067

Hay: 443 visitantes, 40 bots online
Mozilla 5.0, 
Hoy: Jun 01, 2024
 
  Diseñado por Calaf Alberto ©  
     
     

Perfíl de la información

Application afterLoad: 0.004 seconds, 0.24 MB
Application afterInitialise: 0.134 seconds, 2.52 MB
Application afterRoute: 0.177 seconds, 3.01 MB
Application afterDispatch: 0.549 seconds, 6.73 MB
Application afterRender: 1.504 seconds, 8.33 MB

Memoria usada

8787536

257 queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'ega955ugtrgbsf7a6tskddesj2'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1717245854' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'ega955ugtrgbsf7a6tskddesj2'
  4. UPDATE `jos_session`
      SET `time`='1717249454',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1717249433;s:18:\"session.timer.last\";i:1717249433;s:17:\"session.timer.now\";i:1717249449;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:89:\"D:\\inetpub\\wwwroot\\lacasadelamagia.net\\www\\tienda\\libraries\\joomla\\html\\parameter\\element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"35286456edabc3e66eaa1e5d8eebac70\";}auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:3:{s:3:\"idx\";i:2;i:0;a:2:{s:10:\"product_id\";i:5778;s:11:\"category_id\";i:103;}i:1;a:2:{s:10:\"product_id\";i:518;s:11:\"category_id\";i:1;}}ps_vendor_id|i:1;minimum_pov|s:6:\"200.00\";vendor_currency|s:3:\"MXN\";userstate|a:1:{s:10:\"product_id\";i:518;}last_page|s:20:\"shop.product_details\";product_sess|a:35:{i:5779;a:4:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249433;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5780;a:4:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249433;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5778;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249433;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:16171;a:4:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249433;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5045;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:221;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:16945;a:4:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2593;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:18131;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:18130;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:18128;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:18127;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:18126;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:18125;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:18124;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:18123;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:18122;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:18121;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:14537;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:14003;a:4:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:18090;a:4:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:15992;a:4:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249434;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:417;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249449;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:14313;a:1:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";}i:16684;a:1:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";}i:518;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249449;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:17943;a:4:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249449;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1717;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249449;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:15757;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249449;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:16868;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249449;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:17930;a:4:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249449;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:16226;a:4:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249450;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:16427;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249450;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:18010;a:4:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249450;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3501;a:4:{s:7:\"flypage\";s:15:\"flypage_new.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717249450;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}}taxrate|a:1:{i:1;i:0;}last_browse_parameters|a:7:{s:11:\"category_id\";N;s:15:\"manufacturer_id\";N;s:7:\"keyword\";b:0;s:8:\"keyword1\";N;s:8:\"keyword2\";N;s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}vmUseGreyBox|s:1:\"0\";vmCartDirection|s:1:\"0\";vmMiniCart|b:0;__XIJC|a:1:{s:6:\"curUrl\";s:352:\"aHR0cHM6Ly9sYWNhc2FkZWxhbWFnaWEubmV0L3RpZW5kYS9pbmRleC5waHA/SXRlbWlkPTkmY2F0ZWdvcnlfaWQ9MSZmbHlwYWdlPWZseXBhZ2VfbmV3LnRwbCZvcHRpb249Y29tX3ZpcnR1ZW1hcnQmcGFnZT1zaG9wLnByb2R1Y3RfZGV0YWlscyZwcm9kdWN0X2lkPTUxOCZJdGVtaWQ9OSZjYXRlZ29yeV9pZD0xJmZseXBhZ2U9Zmx5cGFnZV9uZXcudHBsJm9wdGlvbj1jb21fdmlydHVlbWFydCZwYWdlPXNob3AucHJvZHVjdF9kZXRhaWxzJnByb2R1Y3RfaWQ9NTE4\";}'
      WHERE session_id='ega955ugtrgbsf7a6tskddesj2'
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT MAX(TIME)  
      FROM jos_vvcounter_logs
  8. SELECT *
      FROM jos_xijc_config
      WHERE name = 'config'
  9. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 32)
      ORDER BY menuid DESC
      LIMIT 0, 1
  10. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  11. 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'
  12. 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`);
  13. SELECT module_id, module_name
      FROM jos_vm_module
      ORDER BY module_name
  14. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  15. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  16. SELECT *
      FROM `jos_vm_product`
      WHERE `product_id`=2443
      AND `product_publish`='Y'
  17. SELECT product_sku, related_products
      FROM jos_vm_product,jos_vm_product_relations
      WHERE jos_vm_product_relations.product_id='2443'
      AND product_publish='Y'
      AND FIND_IN_SET(jos_vm_product.product_id, REPLACE(related_products, '|', ',' ))
      LIMIT 0, 4
  18. SELECT CONCAT( 'search=', `search`, '
    replace='
    , `replace`, '
    area='
    , `area`, '
    '
    , `params` )
      FROM jos_rereplacer
      WHERE published = 1
      AND area = 'articles' OR params LIKE '%use_xml=1%'
      ORDER BY ordering, id
  19. 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='1'
      AND jos_vm_category.category_id='1'
  20. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  21. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  22. 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`.`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`.`product_name` ASC
      LIMIT 0, 2000
  23. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='1'
  24. SELECT manufacturer_id
      FROM jos_vm_product_mf_xref
      WHERE product_id='2443'
  25. SELECT mf_name,jos_vm_manufacturer.manufacturer_id
      FROM jos_vm_product_mf_xref,jos_vm_manufacturer
      WHERE product_id='2443'
      AND jos_vm_manufacturer.manufacturer_id=jos_vm_product_mf_xref.manufacturer_id
  26. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2443
  27. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2443'
      AND (start_date<='1717249454' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  28. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2443
  29. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717249454' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  30. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2443'
  31. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  32. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2443
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  33. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2443'
  34. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2443
      AND `file_is_image`=1
      AND `file_published`=1
  35. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2443
  36. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  37. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2443
      AND `file_is_image`=0
      AND `file_published`=1
  38. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2443'
  39. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  40. SELECT attribute_value
      FROM jos_vm_product_attribute
      WHERE `product_id` = '0'
      AND attribute_name='download'
  41. SELECT DISTINCT file_id, file_mimetype, file_title, file_name
      FROM `jos_vm_product_files`
      WHERE file_product_id = '0'
      AND file_published = '1'
      AND file_is_image = '0'
  42. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2443'
  43. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2443
  44. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2443'
  45. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2443
  46. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2443'
  47. SELECT COUNT(*) AS num_rows
      FROM jos_vm_product_reviews
                                                   
      WHERE product_id='2443'
      AND published='Y'
  48. SELECT comment, TIME, userid, user_rating
      FROM jos_vm_product_reviews
                                           
      WHERE product_id='2443'
      AND published='Y'
      ORDER BY `time` DESC  
      LIMIT 0, 5
  49. SELECT jos_vm_vendor.vendor_name
      FROM jos_vm_product, jos_vm_vendor
      WHERE jos_vm_product.product_id='2443'
      AND jos_vm_vendor.vendor_id=jos_vm_product.vendor_id
  50. SELECT *
      FROM jos_vm_product_product_type_xref
      WHERE product_id='2443'
  51. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM jos_vm_product AS p,jos_vm_category AS c,jos_vm_product_category_xref AS cx
      WHERE p.product_id = '518'
      AND c.category_id = '1'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  52. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=518
  53. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM jos_vm_product AS p,jos_vm_category AS c,jos_vm_product_category_xref AS cx
      WHERE p.product_id = '5778'
      AND c.category_id = '103'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  54. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5778
  55. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2443
  56. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2443
  57. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2443
  58. SELECT product_id, attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='2443'
  59. SELECT product_id, attribute
      FROM jos_vm_product
      WHERE product_id='2443'
  60. SELECT product_id, custom_attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='2443'
  61. SELECT product_id, custom_attribute
      FROM jos_vm_product
      WHERE product_id='2443'
  62. SELECT product_id,product_name
      FROM jos_vm_product
      WHERE product_parent_id='2443'
      AND product_publish='Y'
  63. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2443
  64. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2443
  65. SELECT `payment_method_id`
      FROM `jos_vm_payment_method`
      WHERE `payment_class`='ps_paypal_api'
      AND `payment_enabled`='Y'
  66. 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 = 32 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  67. SELECT p.product_sku
      FROM jos_vm_product AS p
    JOIN jos_vm_product_category_xref AS pc
      ON p.product_id=pc.product_id
    JOIN jos_vm_category AS c
      ON pc.category_id=c.category_id
     
      WHERE p.product_publish = 'Y'
      AND c.category_publish = 'Y'
      AND product_parent_id=0
     
      ORDER BY RAND()
      LIMIT 5
  68. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='18808'
  69. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=14537
  70. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14537
  71. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14537
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  72. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='14537'
  73. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14537
  74. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14537
  75. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='T19004'
  76. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=16192
  77. 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`='16192'
  78. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=16192
  79. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='16192'
      AND (start_date<='1717249455' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  80. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16192
  81. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717249455' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  82. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='16192'
  83. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=16192
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  84. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='16192'
  85. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=16192
  86. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=16192
  87. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='PGSILK9_WHTONBLKPOLKA'
  88. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=15811
  89. 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`='15811'
  90. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=15811
  91. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='15811'
      AND (start_date<='1717249455' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  92. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=15811
  93. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717249455' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  94. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='15811'
  95. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=15811
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  96. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='15811'
  97. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=15811
  98. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=15811
  99. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='MESIKAWAX'
  100. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2159
  101. 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`='2159'
  102. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2159
  103. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2159'
      AND (start_date<='1717249455' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  104. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2159
  105. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717249455' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  106. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2159'
  107. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2159
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  108. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2159'
  109. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2159
  110. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2159
  111. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='dvmagicmadesimp_act1_sp'
  112. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=13922
  113. 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`='13922'
  114. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=13922
  115. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='13922'
      AND (start_date<='1717249455' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  116. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=13922
  117. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717249455' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  118. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='13922'
  119. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=13922
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  120. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='13922'
  121. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=13922
  122. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=13922
  123. SELECT *
     
      FROM jos_banner
     
      WHERE showBanner=1
     
      AND cid IN ( 1 )
     
      AND catid = 17
     
      ORDER BY RAND()
  124. SELECT DISTINCT product_sku
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE product_parent_id=''
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_publish='Y'
      ORDER BY jos_vm_product.product_id DESC
      LIMIT 0, 10
  125. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ZZROPE'
  126. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18131
  127. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18131
  128. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18131
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  129. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18131'
  130. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18131
  131. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18131
  132. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='GUILLOD'
  133. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18130
  134. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18130
  135. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18130
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  136. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18130'
  137. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18130
  138. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18130
  139. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='MUNEVNEW2'
  140. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18128
  141. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18128
  142. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  143. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18128'
  144. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18128
  145. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18128
  146. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='MUNEVNEW1'
  147. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18127
  148. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18127
  149. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18127
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  150. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18127'
  151. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18127
  152. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18127
  153. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='NUEVOGUERO'
  154. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18126
  155. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18126
  156. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18126
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  157. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18126'
  158. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18126
  159. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18126
  160. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='APPEARINGCANEMETAL_GREEN'
  161. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18125
  162. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18125
  163. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18125
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  164. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18125'
  165. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18125
  166. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18125
  167. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DBOMBAG'
  168. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18124
  169. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18124
  170. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  171. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18124'
  172. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18124
  173. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18124
  174. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='MARIORENE2'
  175. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18123
  176. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18123
  177. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18123
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  178. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18123'
  179. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18123
  180. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18123
  181. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ARCOI3'
  182. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18122
  183. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18122
  184. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18122
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  185. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18122'
  186. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18122
  187. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18122
  188. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ARCOI2'
  189. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18121
  190. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18121
  191. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18121
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  192. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18121'
  193. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18121
  194. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18121
  195. SELECT TIME, visits, guests, members, bots  
      FROM jos_vvcounter_logs  
      WHERE '1=1'  
      AND TIME > 1717221600
  196. SELECT session_id, TIME, guest, DATA  
      FROM jos_session  
      WHERE '1=1'  
      AND TIME >= 1717248748
  197. SELECT session_id, TIME, guest, DATA  
      FROM jos_session  
      WHERE TIME > 1717248555
  198. SELECT DISTINCT product_sku
      FROM jos_vm_product
      WHERE product_parent_id=''
      AND vendor_id='1'
      AND jos_vm_product.product_publish='Y'
      ORDER BY product_name DESC
  199. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='21783'
  200. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=17615
  201. 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`='17615'
  202. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=17615
  203. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='17615'
      AND (start_date<='1717249455' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  204. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=17615
  205. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717249455' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  206. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='17615'
  207. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=17615
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  208. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='17615'
  209. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=17615
  210. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=17615
  211. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='dvdess_invisible_sp'
  212. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=13909
  213. 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`='13909'
  214. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=13909
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='13909'
      AND (start_date<='1717249455' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  216. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=13909
  217. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717249455' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  218. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='13909'
  219. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=13909
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  220. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='13909'
  221. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=13909
  222. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=13909
  223. 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, 2
  224. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='dvvibebob'
  225. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=13935
  226. 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`='13935'
  227. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=13935
  228. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='13935'
      AND (start_date<='1717249455' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  229. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=13935
  230. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717249455' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  231. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='13935'
  232. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=13935
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  233. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='13935'
  234. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=13935
  235. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=13935
  236. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='dvreight'
  237. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=17210
  238. 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`='17210'
  239. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=17210
  240. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='17210'
      AND (start_date<='1717249455' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  241. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=17210
  242. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717249455' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  243. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='17210'
  244. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=17210
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  245. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='17210'
  246. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=17210
  247. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=17210
  248. 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
  249. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  250. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'
  251. SELECT p.product_id, p.product_sales AS sales, p.product_parent_id, p.product_name, c.category_id, c.category_flypage
      FROM jos_vm_product p, jos_vm_product_category_xref pc, jos_vm_category c
      WHERE p.product_publish='Y'
      AND pc.product_id = p.product_id
      AND pc.category_id = c.category_id
      AND p.product_sales > 0
      GROUP BY p.product_id
      ORDER BY sales DESC, p.product_name  
      LIMIT 0, 10
  252. SELECT *
      FROM jos_acymailing_config
  253. SELECT *
      FROM jos_acymailing_list
      WHERE TYPE = 'list'
      ORDER BY ordering ASC
  254. SELECT *
      FROM `jos_acymailing_fields` AS a
      WHERE a.`published` = 1
      ORDER BY a.`ordering` ASC
  255. SELECT CONCAT( 'search=', `search`, '
    replace='
    , `replace`, '
    area='
    , `area`, '
    '
    , `params` )
      FROM jos_rereplacer
      WHERE published = 1
      AND area = 'component' OR params LIKE '%use_xml=1%'
      ORDER BY ordering, id
  256. SELECT CONCAT( 'search=', `search`, '
    replace='
    , `replace`, '
    area='
    , `area`, '
    '
    , `params` )
      FROM jos_rereplacer
      WHERE published = 1
      AND area = 'body' OR params LIKE '%use_xml=1%'
      ORDER BY ordering, id
  257. SELECT CONCAT( 'search=', `search`, '
    replace='
    , `replace`, '
    area='
    , `area`, '
    '
    , `params` )
      FROM jos_rereplacer
      WHERE published = 1
      AND area = 'everywhere' OR params LIKE '%use_xml=1%'
      ORDER BY ordering, id

0 legado de las queries identificadas

    Archivos de idioma cargados

    Sin traducir las cadenas de diagnóstico

    Ninguno

    Sin traducir las cadenas de diseñador

    Ninguno