BUSCAR PRODUCTO

ENTRAR A COMPRAR






RECIBE EL BOLETIN

Estamos en Facebook

Norton Safe Web

VirtueMart
Su carro está vacío.

Elija un Producto

Ordenado por:     Mostrar #  

Resultados 221 - 240 de 4181

At the Table (Conferencia)-John Guastaferro/DESCARGA DE VIDEO

$ 170.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
John Guastaferro es un dinámico presentador, autor y creador. Sus trabajos publicados son aclamados por magos de todo el mundo.(Checa el video demo) 
Detalles del Producto...


At the Table (Conferencia)-Jon Armstrong/DESCARGA DE VIDEO

$ 170.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
Jon Armstrong es un excelente presentador con un paquete de cartas ya sea para close-up o escenario.(Vea video demo) 
Detalles del Producto...


At The Table (Conferencia)-Jonathan Friedman/DESCARGA DE VIDEO

$ 175.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
No puedes perderte esta magna conferencia, en esta edición de At The Table. (Vea video demo) 
Detalles del Producto...


At the Table (Conferencia)-Justin Miller/DESCARGA DE VIDEO

$ 175.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
Justin Miller. creador mágico extraordinario, y un artista prestidigitador de clase mundial.(Vea video demo) 
Detalles del Producto...


At The Table (Conferencia)-Losander/DESCARGA DE VIDEO

$ 175.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
Losander es un mago mundialmente renombrado que ha cautivado público por años.(Vea video demo) 
Detalles del Producto...


At The Table (Conferencia)-Marc Lavelle/DESCARGA DE VIDEO

$ 175.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
Como mago de tiempo completo, Marc Lavelle no es extraño encontrar una multitud diciendo wow!!(Vea video demo) 
Detalles del Producto...


At the Table (Conferencia)-Marcus Eddie/DESCARGA DE VIDEO

$ 170.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
Marcus Eddie te sorprenderá. Así de simple. Si la magia de close-up es lo tuyo, definitivamente tendrás que checar esta conferencia. (Vea video demo) 
Detalles del Producto...


At The Table (Conferencia)-Mark Calabrese/DESCARGA DE VIDEO

$ 175.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
Mark Calabrese con su triunfal debut en la experiencia At the Table y ahora de regreso para esta segunda entrega.(Vea video demo) 
Detalles del Producto...


At The Table (Conferencia)-Mark Calabrese/DESCARGA DE VIDEO

$ 170.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
Mark es un mago de renombre que en esta conferencia at the table te emnseñará a detalle sus mejores efectos, realmente asombrosos y que ahora podrás conocer sus secretos con este video de descarga. (Vea video demo) 
Detalles del Producto...


At the Table (Conferencia)-Michael Ammar/DESCARGA DE VIDEO

$ 170.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
La palabra"Magia" y el nombre "Michael Ammar" van de la mano. Michael es una LEYENDA VIVA de la magia.(Vea video demo) 
Detalles del Producto...


At The Table (Conferencia)-Michael Lair/DESCARGA DE VIDEO

$ 175.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
Michael nos brinda algunos de sus mas grandes secretos y mas solicitados trucos a la mesa.(Vea video demo) 
Detalles del Producto...


At the Table (Conferencia)-Mike Hankins/DESCARGA DE VIDEO

$ 175.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
Descubre que tipos de secretos Mike ha estado ocultando a el mundo en esta muy especial experiencia At The Table.(Vea video demo) 
Detalles del Producto...


At the Table (Conferencia)-Nathan Kranzo/DESCARGA DE VIDEO

$ 175.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
Magia que ha trabajado y perfeccionado por largos periodos de tiempo. Diversión,reputación y engaños. Nathan te ofrece todo!(Vea video demo) 
Detalles del Producto...


At the Table (Conferencia)-Patrick Kun/DESCARGA DE VIDEO

$ 170.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
Patrick Kun es uno de los mas talentosos closopistas que habrás visto. (Checa el video demo) 
Detalles del Producto...


At the Table (Conferencia)-Paul Draper/DESCARGA DE VIDEO

$ 175.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
En esta experiencia AT THE TABLE, Paul presentará y explicará ambas piezas de magia y mentalismo.(Vea video demo) 
Detalles del Producto...


At the Table (Conferencia)-Peter Turner/DESCARGA DE VIDEO

$ 175.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
El hombre, el mito, la leyenda misma, Peter Turner se une a nosotros para una inolvidable experiencia At the Table!(Vea video demo) 
Detalles del Producto...


At the Table (Conferencia)-Rick Merrill/DESCARGA DE VIDEO

$ 170.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
Unete a Rick y compartirá contigolo que lo ha hecho un campeón al compartirte algunas de las rutinas mas viuales d ela magia que lo han hecho exitoso.(Checa el video en inglés) 
Detalles del Producto...


At The Table (Conferencia)-Robbie Moreland/DESCARGA DE VIDEO

$ 175.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
Considerado uno de mejores magos delmundo, nos comparte ahora los secretos de estos formidables efectos. (Vea video demo) 
Detalles del Producto...


At The Table (Conferencia)-Scott Wells/DESCARGA DE VIDEO

$ 175.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
Scott Wells! Aquí los trucos que aprenderás de este formidable mago! (Vea video demo) 
Detalles del Producto...


At the Table (Conferencia)-Shin Lim/DESCARGA DE VIDEO

$ 170.00
Media de puntuacion de los usuarios:
0 stars  Votos totales: 0
Cuando veas su magia en vivo te frotarás los ojos de incredulidad!(Vea video demo) 
Detalles del Producto...





Mostrar #  
Resultados 221 - 240 de 4181

Productos destacados

Art Of Magic Por:Wayne Houchin

$ 700.00
$ 350.00
Ahorra: $ 350.00
Art Of Magic Por:Wayne Houchin

Conoce y aprende la magia mas sorprendente de Wayne Houchin!

Urban Station Assembly Por:Creative Artists

$ 110.00
Urban Station Assembly Por:Creative Artists

Una asamblea instantánea con un giro! los reyes desaparecen, aparecen, dónde estarán ahora? Dónde terminarán? Mira el video y te sorprenderás.


Bicycle-Negro

$ 115.00
Bicycle-Negro

Un nuevo color para tu acto con cartas! Bicycle DORSO clásico negro.

Cross (DVD & Gimmicks) "Bonus Pack" Por:Tjiu

$ 800.00
$ 400.00
Ahorra: $ 400.00
Cross (DVD & Gimmicks)

Un muy visual e impactante efecto de una de las mentes mas grandes de Indonesia, Agus Tjiu.(Vea video demo)


Baraja Para Forzar Rojo (4 De Diamantes)

$ 165.00
Baraja Para Forzar Rojo (4 De Diamantes)

Baraja Para Forzar-Dorso Rojo-52 cartas con el valor mencionado. Calidad Bicycle.

Títere Dinito-Verde

$ 50.00
Títere Dinito-Verde

Hermoso títere para que diviertas a tus peques o ellos se diviertan. Fabricado con elegante peluche peinado muy suavecito. Solo mete la manita y a disfrutar con tu personaje. Foto real del producto.


Panditas y Bamboos

$ 150.00
Panditas y Bamboos

El efecto clásico de la cartomagia del agua y aceite pero en una nueva versión. (Vea video demo)

Placebo Por: Mark Calabrese/DESCARGA DE VIDEO

$ 210.00
Placebo Por: Mark Calabrese/DESCARGA DE VIDEO

Placebo es un milagro raro en cartomagia que permite al espectador hacer todo el trabajo!(Vea video demo)


Sharpie Por:Lars La Ville/La Ville Magic/DESCARGA DE VIDEO

$ 260.00
Sharpie Por:Lars La Ville/La Ville Magic/DESCARGA DE VIDEO

En este video, se enseñan varios efectos novedosos usando la ortografía y un Sharpie.(Vea video demo)

Megasandwich De Pollo De Spumlátex

$ 450.00
Megasandwich De Pollo De Spumlátex

Gigantesco sandwich de esponja el pan y el relleno de spumlátex con cómicos ingredientes. Medida: 41 X 33 cms.Chilla el pollo al apretar el sandwich.



Productos vistos recientemente

Productos Sugeridos

$ 40.00


$ 335.00


Productos al Azar

$ 20.00


$ 13.00


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 200764240672

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

Perfíl de la información

Application afterLoad: 0.000 seconds, 0.24 MB
Application afterInitialise: 0.073 seconds, 2.51 MB
Application afterRoute: 0.088 seconds, 2.99 MB
Application afterDispatch: 0.864 seconds, 6.73 MB
Application afterRender: 4.307 seconds, 24.25 MB

Memoria usada

25481392

636 queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'd908kc9itkjlbpcttgoraap8c0'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1717243142' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'd908kc9itkjlbpcttgoraap8c0'
  4. UPDATE `jos_session`
      SET `time`='1717246742',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1717246736;s:18:\"session.timer.last\";i:1717246736;s:17:\"session.timer.now\";i:1717246736;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:\"8ca38027d083fe49e92f5b2a9bb81d9d\";}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:2:{s:3:\"idx\";i:1;i:0;a:2:{s:10:\"product_id\";i:15494;s:11:\"category_id\";i:100;}}ps_vendor_id|i:1;minimum_pov|s:6:\"200.00\";vendor_currency|s:3:\"MXN\";userstate|a:1:{s:10:\"product_id\";i:15494;}last_page|s:20:\"shop.product_details\";product_sess|a:23:{i:14429;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:1717246736;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:14721;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:1717246736;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:15252;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:1717246736;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:15494;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1717246736;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:793;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:1717246736;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:15153;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:1717246736;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3731;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:1717246736;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:17927;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:1717246736;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:17052;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:1717246736;}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:1717246736;}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:1717246736;}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:1717246736;}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:1717246736;}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:1717246736;}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:1717246736;}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:1717246736;}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:1717246736;}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:1717246736;}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:1717246736;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:16512;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:1717246739;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2579;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:1717246739;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:119;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:1717246739;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:16632;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:1717246739;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";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\";}taxrate|a:1:{i:1;i:0;}vmUseGreyBox|s:1:\"0\";vmCartDirection|s:1:\"0\";vmMiniCart|b:0;__XIJC|a:1:{s:6:\"curUrl\";s:216:\"aHR0cHM6Ly9sYWNhc2FkZWxhbWFnaWEubmV0L3RpZW5kYS9pbmRleC5waHA/SXRlbWlkPTMmY2F0ZWdvcnlfaWQ9MTAwJmZseXBhZ2U9Zmx5cGFnZV9pbWFnZXMudHBsJm9wdGlvbj1jb21fdmlydHVlbWFydCZwYWdlPXNob3AucHJvZHVjdF9kZXRhaWxzJnByb2R1Y3RfaWQ9MTU0OTQ=\";}'
      WHERE session_id='d908kc9itkjlbpcttgoraap8c0'
  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 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
  10. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 100002)
      ORDER BY menuid DESC
      LIMIT 0, 1
  11. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  12. 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'
  13. 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`);
  14. SELECT module_id, module_name
      FROM jos_vm_module
      ORDER BY module_name
  15. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  16. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  17. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  18. 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`.`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'
  19. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  20. 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 220, 20
  21. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14228
  22. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='14228'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  23. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14228
  24. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  25. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='14228'
  26. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  27. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14228
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  28. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='14228'
  29. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14228
      AND `file_is_image`=1
      AND `file_published`=1
  30. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14228
  31. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  32. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14228
      AND `file_is_image`=0
      AND `file_published`=1
  33. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='14228'
  34. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  35. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='14228'
  36. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14228
  37. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14228
  38. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14225
  39. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='14225'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  40. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14225
  41. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  42. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='14225'
  43. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14225
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  44. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='14225'
  45. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14225
      AND `file_is_image`=1
      AND `file_published`=1
  46. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14225
  47. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  48. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14225
      AND `file_is_image`=0
      AND `file_published`=1
  49. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='14225'
  50. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  51. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='14225'
  52. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14225
  53. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14225
  54. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=16359
  55. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='16359'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  56. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16359
  57. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  58. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='16359'
  59. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=16359
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  60. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='16359'
  61. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=16359
      AND `file_is_image`=1
      AND `file_published`=1
  62. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16359
  63. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  64. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=16359
      AND `file_is_image`=0
      AND `file_published`=1
  65. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='16359'
  66. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  67. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='16359'
  68. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=16359
  69. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=16359
  70. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14082
  71. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='14082'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  72. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14082
  73. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  74. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='14082'
  75. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14082
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  76. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='14082'
  77. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14082
      AND `file_is_image`=1
      AND `file_published`=1
  78. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14082
  79. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  80. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14082
      AND `file_is_image`=0
      AND `file_published`=1
  81. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='14082'
  82. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  83. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='14082'
  84. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14082
  85. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14082
  86. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=16536
  87. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='16536'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  88. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16536
  89. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  90. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='16536'
  91. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=16536
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  92. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='16536'
  93. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=16536
      AND `file_is_image`=1
      AND `file_published`=1
  94. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16536
  95. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  96. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=16536
      AND `file_is_image`=0
      AND `file_published`=1
  97. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='16536'
  98. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  99. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='16536'
  100. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=16536
  101. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=16536
  102. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=16358
  103. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='16358'
      AND (start_date<='1717246742' 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=16358
  105. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246742' 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='16358'
  107. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=16358
      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='16358'
  109. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=16358
      AND `file_is_image`=1
      AND `file_published`=1
  110. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16358
  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`=16358
      AND `file_is_image`=0
      AND `file_published`=1
  113. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='16358'
  114. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  115. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='16358'
  116. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=16358
  117. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=16358
  118. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14226
  119. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='14226'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  120. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14226
  121. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  122. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='14226'
  123. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14226
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  124. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='14226'
  125. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14226
      AND `file_is_image`=1
      AND `file_published`=1
  126. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14226
  127. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  128. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14226
      AND `file_is_image`=0
      AND `file_published`=1
  129. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='14226'
  130. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  131. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='14226'
  132. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14226
  133. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14226
  134. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=15399
  135. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='15399'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  136. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=15399
  137. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  138. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='15399'
  139. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=15399
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  140. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='15399'
  141. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=15399
      AND `file_is_image`=1
      AND `file_published`=1
  142. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=15399
  143. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  144. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=15399
      AND `file_is_image`=0
      AND `file_published`=1
  145. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='15399'
  146. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  147. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='15399'
  148. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=15399
  149. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=15399
  150. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=15398
  151. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='15398'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  152. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=15398
  153. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  154. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='15398'
  155. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=15398
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  156. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='15398'
  157. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=15398
      AND `file_is_image`=1
      AND `file_published`=1
  158. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=15398
  159. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  160. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=15398
      AND `file_is_image`=0
      AND `file_published`=1
  161. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='15398'
  162. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  163. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='15398'
  164. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=15398
  165. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=15398
  166. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14218
  167. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='14218'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  168. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14218
  169. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246742' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  170. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='14218'
  171. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14218
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  172. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='14218'
  173. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14218
      AND `file_is_image`=1
      AND `file_published`=1
  174. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14218
  175. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  176. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14218
      AND `file_is_image`=0
      AND `file_published`=1
  177. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='14218'
  178. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  179. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='14218'
  180. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14218
  181. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14218
  182. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=16538
  183. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='16538'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  184. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16538
  185. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  186. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='16538'
  187. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=16538
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  188. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='16538'
  189. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=16538
      AND `file_is_image`=1
      AND `file_published`=1
  190. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16538
  191. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  192. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=16538
      AND `file_is_image`=0
      AND `file_published`=1
  193. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='16538'
  194. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  195. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='16538'
  196. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=16538
  197. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=16538
  198. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14095
  199. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='14095'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  200. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14095
  201. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  202. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='14095'
  203. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14095
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  204. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='14095'
  205. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14095
      AND `file_is_image`=1
      AND `file_published`=1
  206. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14095
  207. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  208. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14095
      AND `file_is_image`=0
      AND `file_published`=1
  209. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='14095'
  210. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  211. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='14095'
  212. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14095
  213. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14095
  214. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14084
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='14084'
      AND (start_date<='1717246743' 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=14084
  217. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' 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='14084'
  219. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14084
      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='14084'
  221. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14084
      AND `file_is_image`=1
      AND `file_published`=1
  222. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14084
  223. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  224. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14084
      AND `file_is_image`=0
      AND `file_published`=1
  225. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='14084'
  226. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  227. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='14084'
  228. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14084
  229. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14084
  230. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14227
  231. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='14227'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  232. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14227
  233. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  234. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='14227'
  235. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14227
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  236. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='14227'
  237. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14227
      AND `file_is_image`=1
      AND `file_published`=1
  238. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14227
  239. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  240. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14227
      AND `file_is_image`=0
      AND `file_published`=1
  241. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='14227'
  242. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  243. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='14227'
  244. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14227
  245. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14227
  246. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14083
  247. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='14083'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  248. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14083
  249. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  250. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='14083'
  251. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14083
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  252. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='14083'
  253. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14083
      AND `file_is_image`=1
      AND `file_published`=1
  254. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14083
  255. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  256. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14083
      AND `file_is_image`=0
      AND `file_published`=1
  257. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='14083'
  258. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  259. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='14083'
  260. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14083
  261. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14083
  262. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14210
  263. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='14210'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  264. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14210
  265. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  266. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='14210'
  267. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14210
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  268. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='14210'
  269. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14210
      AND `file_is_image`=1
      AND `file_published`=1
  270. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14210
  271. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  272. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14210
      AND `file_is_image`=0
      AND `file_published`=1
  273. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='14210'
  274. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  275. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='14210'
  276. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14210
  277. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14210
  278. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14230
  279. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='14230'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  280. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14230
  281. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  282. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='14230'
  283. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14230
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  284. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='14230'
  285. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14230
      AND `file_is_image`=1
      AND `file_published`=1
  286. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14230
  287. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  288. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14230
      AND `file_is_image`=0
      AND `file_published`=1
  289. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='14230'
  290. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  291. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='14230'
  292. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14230
  293. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14230
  294. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=16604
  295. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='16604'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  296. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16604
  297. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  298. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='16604'
  299. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=16604
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  300. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='16604'
  301. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=16604
      AND `file_is_image`=1
      AND `file_published`=1
  302. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16604
  303. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  304. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=16604
      AND `file_is_image`=0
      AND `file_published`=1
  305. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='16604'
  306. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  307. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='16604'
  308. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=16604
  309. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=16604
  310. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=16605
  311. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='16605'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  312. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16605
  313. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  314. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='16605'
  315. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=16605
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  316. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='16605'
  317. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=16605
      AND `file_is_image`=1
      AND `file_published`=1
  318. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16605
  319. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  320. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=16605
      AND `file_is_image`=0
      AND `file_published`=1
  321. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='16605'
  322. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  323. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='16605'
  324. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=16605
  325. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=16605
  326. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14169
  327. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='14169'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  328. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14169
  329. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  330. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='14169'
  331. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14169
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  332. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='14169'
  333. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14169
      AND `file_is_image`=1
      AND `file_published`=1
  334. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14169
  335. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  336. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14169
      AND `file_is_image`=0
      AND `file_published`=1
  337. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='14169'
  338. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  339. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='14169'
  340. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14169
  341. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14169
  342. 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 = '15494'
      AND c.category_id = '100'
      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
  343. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=15494
  344. SELECT DISTINCT product_sku,product_id,product_name,product_s_desc,product_thumb_image, product_full_image, product_in_stock, product_url
      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, 10
  345. 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`='4666'
  346. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4666
  347. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4666'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  348. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4666'
  349. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4666
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  350. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4666'
  351. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4666
  352. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4666
  353. 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`='16535'
  354. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=16535
  355. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='16535'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  356. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16535
  357. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  358. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='16535'
  359. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=16535
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  360. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='16535'
  361. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=16535
  362. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=16535
  363. 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`='5617'
  364. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5617
  365. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5617'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  366. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5617
  367. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  368. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5617'
  369. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5617
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  370. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5617'
  371. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5617
  372. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5617
  373. 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`='14252'
  374. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14252
  375. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='14252'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  376. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='14252'
  377. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14252
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  378. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='14252'
  379. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14252
  380. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14252
  381. 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`='17119'
  382. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=17119
  383. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='17119'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  384. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=17119
  385. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  386. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='17119'
  387. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=17119
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  388. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='17119'
  389. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=17119
  390. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=17119
  391. 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`='17376'
  392. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=17376
  393. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='17376'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  394. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=17376
  395. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  396. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='17376'
  397. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=17376
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  398. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='17376'
  399. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=17376
  400. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=17376
  401. 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`='17782'
  402. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=17782
  403. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='17782'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  404. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=17782
  405. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  406. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='17782'
  407. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=17782
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  408. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='17782'
  409. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=17782
  410. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=17782
  411. 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`='15400'
  412. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=15400
  413. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='15400'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  414. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=15400
  415. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  416. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='15400'
  417. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=15400
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  418. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='15400'
  419. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=15400
  420. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=15400
  421. 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`='16942'
  422. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=16942
  423. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='16942'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  424. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16942
  425. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  426. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='16942'
  427. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=16942
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  428. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='16942'
  429. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=16942
  430. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=16942
  431. 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`='4311'
  432. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4311
  433. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4311'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  434. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4311
  435. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  436. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4311'
  437. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4311
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  438. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4311'
  439. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4311
  440. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4311
  441. 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 = 100002 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  442. 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
  443. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='dvaultchame'
  444. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=16970
  445. 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`='16970'
  446. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=16970
  447. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='16970'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  448. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16970
  449. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  450. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='16970'
  451. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=16970
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  452. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='16970'
  453. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=16970
  454. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=16970
  455. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DL00030'
  456. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3609
  457. 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`='3609'
  458. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3609
  459. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3609'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  460. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3609
  461. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  462. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3609'
  463. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3609
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  464. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3609'
  465. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3609
  466. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3609
  467. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='transitcm'
  468. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5230
  469. 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`='5230'
  470. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5230
  471. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5230'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  472. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5230'
  473. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5230
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  474. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5230'
  475. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5230
  476. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5230
  477. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='NM5'
  478. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=17767
  479. 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`='17767'
  480. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=17767
  481. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='17767'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  482. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=17767
  483. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  484. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='17767'
  485. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=17767
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  486. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='17767'
  487. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=17767
  488. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=17767
  489. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='china7'
  490. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1936
  491. 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`='1936'
  492. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1936
  493. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1936'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  494. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1936
  495. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246743' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  496. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1936'
  497. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1936
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  498. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1936'
  499. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1936
  500. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1936
  501. SELECT *
     
      FROM jos_banner
     
      WHERE showBanner=1
     
      AND cid IN ( 1 )
     
      AND catid = 17
     
      ORDER BY RAND()
  502. 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
  503. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ZZROPE'
  504. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18131
  505. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18131
  506. 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
  507. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18131'
  508. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18131
  509. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18131
  510. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='GUILLOD'
  511. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18130
  512. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18130
  513. 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
  514. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18130'
  515. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18130
  516. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18130
  517. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='MUNEVNEW2'
  518. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18128
  519. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18128
  520. 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
  521. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18128'
  522. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18128
  523. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18128
  524. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='MUNEVNEW1'
  525. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18127
  526. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18127
  527. 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
  528. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18127'
  529. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18127
  530. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18127
  531. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='NUEVOGUERO'
  532. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18126
  533. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18126
  534. 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
  535. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18126'
  536. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18126
  537. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18126
  538. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='APPEARINGCANEMETAL_GREEN'
  539. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18125
  540. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18125
  541. 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
  542. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18125'
  543. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18125
  544. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18125
  545. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DBOMBAG'
  546. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18124
  547. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18124
  548. 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
  549. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18124'
  550. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18124
  551. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18124
  552. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='MARIORENE2'
  553. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18123
  554. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18123
  555. 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
  556. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18123'
  557. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18123
  558. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18123
  559. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ARCOI3'
  560. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18122
  561. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18122
  562. 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
  563. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18122'
  564. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18122
  565. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18122
  566. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ARCOI2'
  567. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18121
  568. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18121
  569. 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
  570. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18121'
  571. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18121
  572. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18121
  573. SELECT TIME, visits, guests, members, bots  
      FROM jos_vvcounter_logs  
      WHERE '1=1'  
      AND TIME > 1717221600
  574. SELECT session_id, TIME, guest, DATA  
      FROM jos_session  
      WHERE '1=1'  
      AND TIME >= 1717246360
  575. SELECT TIME, visits, guests, members, bots  
      FROM jos_vvcounter_logs  
      WHERE '1=1'  
      AND TIME <= 1717221600
  576. SELECT session_id, TIME, guest, DATA  
      FROM jos_session  
      WHERE TIME > 1717245846
  577. 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
  578. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ratonfeliz'
  579. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3846
  580. 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`='3846'
  581. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3846
  582. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3846'
      AND (start_date<='1717246746' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  583. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3846
  584. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246746' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  585. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3846'
  586. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3846
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  587. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3846'
  588. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3846
  589. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3846
  590. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='lapizl2'
  591. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5442
  592. 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`='5442'
  593. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5442
  594. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5442'
      AND (start_date<='1717246746' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  595. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5442
  596. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246746' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  597. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5442'
  598. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5442
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  599. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5442'
  600. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5442
  601. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5442
  602. 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
  603. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DESTAPAXXX'
  604. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18032
  605. 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`='18032'
  606. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18032
  607. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='18032'
      AND (start_date<='1717246746' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  608. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=18032
  609. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246746' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  610. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='18032'
  611. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18032
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  612. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18032'
  613. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18032
  614. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18032
  615. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='MENTALPHO_BLU'
  616. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=4492
  617. 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`='4492'
  618. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4492
  619. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4492'
      AND (start_date<='1717246746' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  620. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4492
  621. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246746' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
  622. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4492'
  623. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4492
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  624. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4492'
  625. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4492
  626. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4492
  627. 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
  628. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  629. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'
  630. 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
  631. SELECT *
      FROM jos_acymailing_config
  632. SELECT *
      FROM jos_acymailing_list
      WHERE TYPE = 'list'
      ORDER BY ordering ASC
  633. SELECT *
      FROM `jos_acymailing_fields` AS a
      WHERE a.`published` = 1
      ORDER BY a.`ordering` ASC
  634. 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
  635. 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
  636. 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