tecnostore.es

Su Carrito

[ ... ] Productos
Ir a compra

operadorsat1

VirtueMart
Su carro está vacío.
Usted está en: tecnostore.es

Productos Destacados

DSC-WX350
300,00 €
139,00 €
KD-55AF8
2 799,00 €
1 819,00 €
ILCE-7SB
2 499,00 €
1 398,99 €
KD-65AF8
3 799,00 €
2 799,00 €
DSC-HX90B
450,00 €
309,00 €
ILCA-77M2
1 199,00 €
959,00 €

Productos que pueden interesarte

XS-FB6920
70,00 €
52,03 €
VPL-DW122
599,00 €
508,20 €
CLM-V55
410,00 €
332,75 €
BNR25IPSL
7,90 €
4,72 €
BDV-E2100
300,00 €
278,30 €
ALC-F62S
8,00 €
6,66 €

Categorías

Estamos en:

comparador de precios shoppydoo

  

comparador de precios Encuentra Precios

  

Visita sonystore.es en ShopMania

10razones

Aceptamos pagos con

pagosv2trans

Utilizamos cookies para mejorar nuestro sitio web y su experiencia al usarlo. Ya se han establecido cookies utilizadas para el funcionamiento esencial del sitio. Para obtener más información sobre las cookies que utilizamos, consulte nuestra política de privacidad.

Yo acepto las cookies para este sitio.

Perfíl de la información

Application afterLoad: 0.000 seconds, 0.88 MB
Application afterInitialise: 0.025 seconds, 4.70 MB
Application afterRoute: 0.031 seconds, 5.68 MB
Application afterDispatch: 0.053 seconds, 8.80 MB
Application afterRender: 0.247 seconds, 18.70 MB

Memoria usada

19731528

286 queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'og8jr6mdgjsih415bt3r9tl0v2'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1586036074' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'og8jr6mdgjsih415bt3r9tl0v2'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'og8jr6mdgjsih415bt3r9tl0v2','1586037874','','0','1','0' )
  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 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
  8. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 1)
      ORDER BY menuid DESC
      LIMIT 0, 1
  9. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      WHERE 1
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-04-04 22:04:34' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-04-04 22:04:34' )
      ORDER BY  f.ordering
      LIMIT 0, 4
  10. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      WHERE 1
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-04-04 22:04:34' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-04-04 22:04:34' )
      ORDER BY  f.ordering
  11. SELECT *
      FROM jos_kunena_configuration
      WHERE id=1
  12. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 1 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  13. SELECT a.*,  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-04-04 22:04:34' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-04-04 22:04:34' )
      AND s.id > 0
      AND s.published = 1
      AND cc.published = 1
      ORDER BY a.created DESC
      LIMIT 0, 5
  14. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      LEFT JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE ( a.state = 1
      AND s.id > 0 )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-04-04 22:04:34' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-04-04 22:04:34' )
      AND s.published = 1
      AND cc.published = 1
      ORDER BY a.hits DESC
      LIMIT 0, 5
  15. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  16. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                   
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  17. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  18. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  19. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

      ORDER BY g1.lft
  20. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  21. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft
  22. 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`);
  23. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='0'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  24. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  25. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='2'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  26. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='17'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  27. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='41'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  28. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='42'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  29. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='43'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  30. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='44'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  31. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='39'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  32. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='97'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  33. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='3'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  34. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='57'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  35. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='62'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  36. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='63'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  37. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='103'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  38. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='55'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  39. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='60'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  40. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='61'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  41. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='52'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  42. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='54'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  43. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='56'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  44. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='53'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  45. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='109'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  46. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='58'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  47. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='59'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  48. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='64'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  49. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='65'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  50. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='11'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  51. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='46'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  52. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='40'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  53. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='12'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  54. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='76'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  55. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='100'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  56. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='71'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  57. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='69'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  58. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='101'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  59. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='102'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  60. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='72'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  61. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='74'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  62. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='75'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  63. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='73'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  64. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='8'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  65. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='49'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  66. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='48'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  67. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='47'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  68. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='9'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  69. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='51'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  70. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='50'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  71. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='106'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  72. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='107'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  73. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='108'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  74. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='15'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  75. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='77'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  76. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='82'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  77. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='79'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  78. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='81'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  79. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='104'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  80. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='80'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  81. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='78'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  82. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='10'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  83. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='84'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  84. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='83'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  85. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='91'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  86. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='14'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  87. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='98'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  88. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='85'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  89. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='86'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  90. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='88'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  91. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='90'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  92. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='89'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  93. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='87'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  94. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='99'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  95. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='92'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  96. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='95'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  97. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='94'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  98. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='96'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  99. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='93'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  100. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='16'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  101. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='105'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  102. 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
  103. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  104. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 2
  105. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (2)
  106. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 3
  107. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  108. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 11
  109. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (11)
  110. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 12
  111. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (12)
  112. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 8
  113. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (8)
  114. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 9
  115. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (9)
  116. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 106
  117. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (106)
  118. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 15
  119. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (15)
  120. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 10
  121. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (10)
  122. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 91
  123. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (91)
  124. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 14
  125. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (14)
  126. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 92
  127. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (92)
  128. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 16
  129. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (16)
  130. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 105
  131. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (105)
  132. SELECT

                            *

                   
      FROM

                            jos_gk3_photoslide_groups

                   
      WHERE

                            `id` = 1

                   
      LIMIT 1;
  133. SELECT

                            `c`.`sectionid` AS `sid`,

                            `c`.`catid` AS `cid`,

                            `c`.`title` AS `ctitle`,

                            `c`.`introtext` AS `introtext`,

                            `i`.`name` AS `name`,

                            `i`.`filename` AS `filename`,

                            `i`.`article` AS `article`,

                            `i`.`title` AS `title`,

                            `i`.`link_type` AS `link_type`,

                            `i`.`link` AS `link`,

                            `i`.`content` AS `content`

                   
      FROM

                            jos_gk3_photoslide_slides AS `i`

                   
      LEFT JOIN

                            jos_content AS `c`

                           
      ON

                            `i`.`article` = `c`.`id`

                   
      WHERE

                            `i`.`group_id` = 1

                           
      AND

                            `i`.`published` = 1

                           
      AND

                            `i`.`access` <= 0

                   
      ORDER BY

                            `i`.`order`,

                            `i`.`access` ASC;
  134. SELECT p.product_id AS pid, c.category_id AS cid
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS c
      ON p.product_id = c.product_id
      WHERE p.product_sku = 'SVF15N1S2ES.ES2'
      LIMIT 1;
  135. SELECT p.product_id AS pid, c.category_id AS cid
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS c
      ON p.product_id = c.product_id
      WHERE p.product_sku = 'KD65X9005ABAE'
      LIMIT 1;
  136. 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, 6
  137. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DSCWX350B.CE3'
  138. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2323
  139. 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`='2323'
  140. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 60
  141. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3,55,60)
  142. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 2323
  143. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2323
  144. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2323'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  145. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2323'
  146. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  147. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2323
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  148. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2323
  149. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2323'
  150. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='KD55AF8BAEP'
  151. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3454
  152. 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`='3454'
  153. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 43
  154. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (2,17,43)
  155. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 3454
  156. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3454
  157. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3454'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  158. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3454'
  159. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3454
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  160. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3454
  161. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3454'
  162. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ILCE7SB.CEC'
  163. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2611
  164. 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`='2611'
  165. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 62
  166. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3,57,62)
  167. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 2611
  168. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2611
  169. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2611'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  170. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2611'
  171. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2611
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  172. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2611
  173. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2611'
  174. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='KD65AF8BAEP'
  175. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3453
  176. 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`='3453'
  177. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 43
  178. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (2,17,43)
  179. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 3453
  180. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3453
  181. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3453'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  182. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3453'
  183. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3453
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  184. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3453
  185. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3453'
  186. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DSCHX90B.CE3'
  187. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2876
  188. 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`='2876'
  189. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 60
  190. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3,55,60)
  191. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 2876
  192. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2876
  193. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2876'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  194. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2876'
  195. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2876
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  196. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2876
  197. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2876'
  198. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ILCA77M2.CEC'
  199. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2509
  200. 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`='2509'
  201. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 62
  202. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3,57,62)
  203. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 2509
  204. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2509
  205. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2509'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  206. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2509'
  207. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2509
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  208. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2509
  209. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2509'
  210. 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
  211. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='XSFB6920E.EUR'
  212. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3082
  213. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='3082'
  214. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 82
  215. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (15,77,82)
  216. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 3082
  217. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3082
  218. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3082'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  219. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3082'
  220. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3082
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  221. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3082
  222. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3082'
  223. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='VPLDW122'
  224. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3001
  225. 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`='3001'
  226. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 49
  227. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (8,49)
  228. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 3001
  229. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3001
  230. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3001'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  231. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3001'
  232. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3001
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  233. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3001
  234. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3001'
  235. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='CLMV55.CE'
  236. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2055
  237. 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`='2055'
  238. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 56
  239. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3,52,56)
  240. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 2055
  241. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2055
  242. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2055'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  243. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2055'
  244. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2055
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  245. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2055
  246. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2055'
  247. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='BNR25IPSL'
  248. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=760
  249. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='760'
  250. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 98
  251. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (14,98)
  252. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 760
  253. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=760
  254. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='760'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  255. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='760'
  256. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=760
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  257. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=760
  258. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='760'
  259. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='BDVE2100.CEL'
  260. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1899
  261. 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`='1899'
  262. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 39
  263. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (2,39)
  264. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 1899
  265. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1899
  266. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1899'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  267. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1899'
  268. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1899
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  269. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1899
  270. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1899'
  271. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ALCF62S.SYH'
  272. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1447
  273. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='1447'
  274. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 63
  275. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3,57,63)
  276. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 1447
  277. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1447
  278. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1447'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  279. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1447'
  280. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1447
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  281. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1447
  282. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1447'
  283. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 39
  284. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (2,39)
  285. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 39
  286. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (2,39)

286 legado de las queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'og8jr6mdgjsih415bt3r9tl0v2'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1586036074' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'og8jr6mdgjsih415bt3r9tl0v2'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'og8jr6mdgjsih415bt3r9tl0v2','1586037874','','0','1','0' )
  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 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
  8. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 1)
      ORDER BY menuid DESC
      LIMIT 0, 1
  9. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      WHERE 1
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-04-04 22:04:34' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-04-04 22:04:34' )
      ORDER BY  f.ordering
      LIMIT 0, 4
  10. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      WHERE 1
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-04-04 22:04:34' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-04-04 22:04:34' )
      ORDER BY  f.ordering
  11. SELECT *
      FROM jos_kunena_configuration
      WHERE id=1
  12. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 1 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  13. SELECT a.*,  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-04-04 22:04:34' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-04-04 22:04:34' )
      AND s.id > 0
      AND s.published = 1
      AND cc.published = 1
      ORDER BY a.created DESC
      LIMIT 0, 5
  14. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      LEFT JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE ( a.state = 1
      AND s.id > 0 )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-04-04 22:04:34' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-04-04 22:04:34' )
      AND s.published = 1
      AND cc.published = 1
      ORDER BY a.hits DESC
      LIMIT 0, 5
  15. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  16. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                   
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  17. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  18. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  19. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

      ORDER BY g1.lft
  20. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  21. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft
  22. 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`);
  23. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='0'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  24. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  25. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='2'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  26. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='17'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  27. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='41'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  28. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='42'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  29. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='43'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  30. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='44'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  31. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='39'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  32. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='97'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  33. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='3'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  34. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='57'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  35. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='62'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  36. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='63'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  37. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='103'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  38. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='55'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  39. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='60'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  40. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='61'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  41. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='52'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  42. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='54'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  43. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='56'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  44. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='53'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  45. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='109'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  46. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='58'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  47. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='59'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  48. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='64'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  49. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='65'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  50. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='11'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  51. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='46'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  52. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='40'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  53. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='12'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  54. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='76'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  55. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='100'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  56. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='71'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  57. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='69'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  58. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='101'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  59. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='102'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  60. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='72'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  61. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='74'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  62. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='75'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  63. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='73'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  64. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='8'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  65. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='49'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  66. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='48'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  67. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='47'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  68. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='9'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  69. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='51'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  70. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='50'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  71. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='106'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  72. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='107'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  73. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='108'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  74. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='15'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  75. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='77'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  76. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='82'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  77. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='79'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  78. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='81'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  79. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='104'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  80. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='80'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  81. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='78'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  82. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='10'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  83. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='84'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  84. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='83'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  85. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='91'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  86. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='14'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  87. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='98'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  88. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='85'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  89. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='86'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  90. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='88'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  91. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='90'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  92. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='89'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  93. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='87'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  94. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='99'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  95. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='92'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  96. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='95'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  97. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='94'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  98. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='96'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  99. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='93'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  100. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='16'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  101. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='105'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  102. 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
  103. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  104. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 2
  105. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (2)
  106. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 3
  107. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3)
  108. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 11
  109. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (11)
  110. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 12
  111. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (12)
  112. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 8
  113. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (8)
  114. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 9
  115. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (9)
  116. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 106
  117. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (106)
  118. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 15
  119. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (15)
  120. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 10
  121. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (10)
  122. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 91
  123. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (91)
  124. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 14
  125. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (14)
  126. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 92
  127. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (92)
  128. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 16
  129. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (16)
  130. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 105
  131. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (105)
  132. SELECT

                            *

                   
      FROM

                            jos_gk3_photoslide_groups

                   
      WHERE

                            `id` = 1

                   
      LIMIT 1;
  133. SELECT

                            `c`.`sectionid` AS `sid`,

                            `c`.`catid` AS `cid`,

                            `c`.`title` AS `ctitle`,

                            `c`.`introtext` AS `introtext`,

                            `i`.`name` AS `name`,

                            `i`.`filename` AS `filename`,

                            `i`.`article` AS `article`,

                            `i`.`title` AS `title`,

                            `i`.`link_type` AS `link_type`,

                            `i`.`link` AS `link`,

                            `i`.`content` AS `content`

                   
      FROM

                            jos_gk3_photoslide_slides AS `i`

                   
      LEFT JOIN

                            jos_content AS `c`

                           
      ON

                            `i`.`article` = `c`.`id`

                   
      WHERE

                            `i`.`group_id` = 1

                           
      AND

                            `i`.`published` = 1

                           
      AND

                            `i`.`access` <= 0

                   
      ORDER BY

                            `i`.`order`,

                            `i`.`access` ASC;
  134. SELECT p.product_id AS pid, c.category_id AS cid
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS c
      ON p.product_id = c.product_id
      WHERE p.product_sku = 'SVF15N1S2ES.ES2'
      LIMIT 1;
  135. SELECT p.product_id AS pid, c.category_id AS cid
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS c
      ON p.product_id = c.product_id
      WHERE p.product_sku = 'KD65X9005ABAE'
      LIMIT 1;
  136. 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, 6
  137. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DSCWX350B.CE3'
  138. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2323
  139. 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`='2323'
  140. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 60
  141. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3,55,60)
  142. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 2323
  143. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2323
  144. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2323'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  145. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2323'
  146. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  147. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2323
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  148. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2323
  149. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2323'
  150. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='KD55AF8BAEP'
  151. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3454
  152. 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`='3454'
  153. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 43
  154. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (2,17,43)
  155. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 3454
  156. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3454
  157. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3454'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  158. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3454'
  159. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3454
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  160. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3454
  161. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3454'
  162. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ILCE7SB.CEC'
  163. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2611
  164. 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`='2611'
  165. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 62
  166. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3,57,62)
  167. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 2611
  168. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2611
  169. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2611'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  170. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2611'
  171. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2611
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  172. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2611
  173. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2611'
  174. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='KD65AF8BAEP'
  175. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3453
  176. 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`='3453'
  177. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 43
  178. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (2,17,43)
  179. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 3453
  180. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3453
  181. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3453'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  182. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3453'
  183. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3453
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  184. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3453
  185. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3453'
  186. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DSCHX90B.CE3'
  187. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2876
  188. 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`='2876'
  189. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 60
  190. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3,55,60)
  191. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 2876
  192. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2876
  193. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2876'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  194. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2876'
  195. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2876
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  196. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2876
  197. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2876'
  198. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ILCA77M2.CEC'
  199. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2509
  200. 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`='2509'
  201. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 62
  202. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3,57,62)
  203. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 2509
  204. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2509
  205. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2509'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  206. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2509'
  207. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2509
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  208. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2509
  209. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2509'
  210. 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
  211. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='XSFB6920E.EUR'
  212. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3082
  213. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='3082'
  214. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 82
  215. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (15,77,82)
  216. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 3082
  217. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3082
  218. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3082'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  219. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3082'
  220. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3082
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  221. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3082
  222. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3082'
  223. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='VPLDW122'
  224. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3001
  225. 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`='3001'
  226. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 49
  227. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (8,49)
  228. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 3001
  229. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3001
  230. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3001'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  231. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3001'
  232. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3001
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  233. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3001
  234. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3001'
  235. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='CLMV55.CE'
  236. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2055
  237. 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`='2055'
  238. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 56
  239. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3,52,56)
  240. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 2055
  241. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2055
  242. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2055'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  243. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2055'
  244. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2055
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  245. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2055
  246. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2055'
  247. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='BNR25IPSL'
  248. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=760
  249. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='760'
  250. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 98
  251. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (14,98)
  252. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 760
  253. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=760
  254. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='760'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  255. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='760'
  256. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=760
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  257. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=760
  258. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='760'
  259. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='BDVE2100.CEL'
  260. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1899
  261. 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`='1899'
  262. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 39
  263. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (2,39)
  264. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 1899
  265. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1899
  266. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1899'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  267. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1899'
  268. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1899
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  269. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1899
  270. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1899'
  271. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ALCF62S.SYH'
  272. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1447
  273. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='1447'
  274. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 63
  275. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (3,57,63)
  276. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 1447
  277. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1447
  278. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1447'
      AND (start_date<='1586037874' OR start_date=0)
      AND (end_date>='1585956960' OR end_date=0)
      AND product_discount_id=discount_id
  279. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1447'
  280. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1447
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  281. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1447
  282. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1447'
  283. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 39
  284. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (2,39)
  285. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 39
  286. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (2,39)

Archivos de idioma cargados

Sin traducir las cadenas de diagnóstico

Ninguno

Sin traducir las cadenas de diseñador

Ninguno