Il tuo Carrello è vuoto.
Visualizza Carrello

Newsletters

Subscribe Here



Informazioni Profilo

Application afterLoad: 0.012 seconds, 0.29 MB
Application afterInitialise: 0.112 seconds, 1.57 MB
Application afterRoute: 0.191 seconds, 2.18 MB
Application afterDispatch: 0.253 seconds, 2.63 MB
Application afterRender: 0.652 seconds, 4.81 MB

Utilizzo Memoria

5082560

423 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'vs5gronigklv0r59f70s2cpsr0'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1493087600' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'vs5gronigklv0r59f70s2cpsr0'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'vs5gronigklv0r59f70s2cpsr0','1493094800','','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 newurl
      FROM jos_sh404sef_aliases
      WHERE alias = ''
  8. 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
  9. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  10. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 1)
      ORDER BY menuid DESC
      LIMIT 0, 1
  11. 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
      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
      WHERE 1
      AND a.access <= 0
      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 <= '2017-04-25 04:33:20' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-04-25 04:33:20' )
      ORDER BY  f.ordering
      LIMIT 0, 9
  12. 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
      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
      WHERE 1
      AND a.access <= 0
      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 <= '2017-04-25 04:33:20' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-04-25 04:33:20' )
      ORDER BY  f.ordering
  13. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=1&format=feed&lang=it&type=rss&view=frontpage'
  14. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=1&format=feed&lang=it&type=atom&view=frontpage'
  15. SELECT newurl
      FROM jos_sh404sef_aliases
      WHERE alias = ''
  16. SELECT newurl
      FROM jos_sh404sef_aliases
      WHERE alias = ''
  17. 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
  18. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=6&id=8&lang=it&view=article'
  19. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=26&id=21&lang=it&view=article'
  20. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=7&id=5&lang=it&view=article'
  21. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=8&id=4&lang=it&view=article'
  22. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=9&id=3&lang=it&view=article'
  23. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=10&id=9&lang=it&view=article'
  24. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=11&id=6&lang=it&view=article'
  25. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=12&id=7&lang=it&view=article'
  26. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_xmap&Itemid=15&lang=it&sitemap=1'
  27. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  28. 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'
  29. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  30. 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`);
  31. SELECT DISTINCT product_sku
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE product_parent_id=''
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_publish='Y'
      ORDER BY jos_vm_product.product_id DESC
      LIMIT 9
  32. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='AR3-W638'
  33. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='6118'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  34. 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`='6118'
  35. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  36. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  37. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=170&flypage=flypage.tpl&lang=it&page=shop.product_details&product_id=6118'
  38. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  39. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 6118
  40. SELECT c.category_name, c.category_id, x.category_parent_id
      FROM jos_vm_category AS c
     
      LEFT JOIN jos_vm_category_xref AS x
      ON c.category_id = x.category_child_id;
  41. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '6118'
  42. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=170&flypage=flypage.tpl&lang=it&limitstart=0&page=shop.product_details&product_id=6118'
  43. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6118
  44. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6118'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  45. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6118
  46. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  47. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6118'
  48. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  49. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6118
      AND shopper_group_id=8  
      ORDER BY price_quantity_start
  50. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6118
  51. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='AR3-JM4010-CYAN'
  52. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='6117'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  53. 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`='6117'
  54. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=172&flypage=flypage.tpl&lang=it&page=shop.product_details&product_id=6117'
  55. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  56. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 6117
  57. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '6117'
  58. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=172&flypage=flypage.tpl&lang=it&limitstart=0&page=shop.product_details&product_id=6117'
  59. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6117
  60. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6117'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  61. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6117
  62. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  63. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6117'
  64. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6117
      AND shopper_group_id=8  
      ORDER BY price_quantity_start
  65. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6117
  66. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='AR3-JM4010-PINK'
  67. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='6116'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  68. 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`='6116'
  69. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=172&flypage=flypage.tpl&lang=it&page=shop.product_details&product_id=6116'
  70. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  71. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 6116
  72. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '6116'
  73. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=172&flypage=flypage.tpl&lang=it&limitstart=0&page=shop.product_details&product_id=6116'
  74. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6116
  75. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6116'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  76. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6116
  77. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  78. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6116'
  79. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6116
      AND shopper_group_id=8  
      ORDER BY price_quantity_start
  80. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6116
  81. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='AR3-JM4022-RED'
  82. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='6115'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  83. 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`='6115'
  84. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=172&flypage=flypage.tpl&lang=it&page=shop.product_details&product_id=6115'
  85. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  86. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 6115
  87. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '6115'
  88. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=172&flypage=flypage.tpl&lang=it&limitstart=0&page=shop.product_details&product_id=6115'
  89. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6115
  90. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6115'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  91. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6115
  92. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  93. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6115'
  94. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6115
      AND shopper_group_id=8  
      ORDER BY price_quantity_start
  95. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6115
  96. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='AR3-JM4022-SILVER'
  97. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='6114'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  98. 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`='6114'
  99. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=172&flypage=flypage.tpl&lang=it&page=shop.product_details&product_id=6114'
  100. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  101. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 6114
  102. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '6114'
  103. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=172&flypage=flypage.tpl&lang=it&limitstart=0&page=shop.product_details&product_id=6114'
  104. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6114
  105. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6114'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  106. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6114
  107. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  108. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6114'
  109. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6114
      AND shopper_group_id=8  
      ORDER BY price_quantity_start
  110. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6114
  111. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='AR3-JM4022-BLACK'
  112. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='6113'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  113. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='6113'
  114. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=172&flypage=flypage.tpl&lang=it&page=shop.product_details&product_id=6113'
  115. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  116. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 6113
  117. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '6113'
  118. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=172&flypage=flypage.tpl&lang=it&limitstart=0&page=shop.product_details&product_id=6113'
  119. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6113
  120. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6113'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  121. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6113
  122. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  123. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6113'
  124. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6113
      AND shopper_group_id=8  
      ORDER BY price_quantity_start
  125. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6113
  126. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='AR3-JM280'
  127. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='6112'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  128. 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`='6112'
  129. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=171&flypage=flypage.tpl&lang=it&page=shop.product_details&product_id=6112'
  130. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  131. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 6112
  132. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '6112'
  133. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=171&flypage=flypage.tpl&lang=it&limitstart=0&page=shop.product_details&product_id=6112'
  134. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6112
  135. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6112'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  136. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6112
  137. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  138. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6112'
  139. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6112
      AND shopper_group_id=8  
      ORDER BY price_quantity_start
  140. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6112
  141. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='AR3-JM121'
  142. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='6111'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  143. 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`='6111'
  144. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=171&flypage=flypage.tpl&lang=it&page=shop.product_details&product_id=6111'
  145. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  146. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 6111
  147. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '6111'
  148. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=171&flypage=flypage.tpl&lang=it&limitstart=0&page=shop.product_details&product_id=6111'
  149. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6111
  150. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6111'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  151. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6111
  152. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  153. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6111'
  154. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6111
      AND shopper_group_id=8  
      ORDER BY price_quantity_start
  155. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6111
  156. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='AR3-W087'
  157. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='6110'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  158. 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`='6110'
  159. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=170&flypage=flypage.tpl&lang=it&page=shop.product_details&product_id=6110'
  160. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  161. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 6110
  162. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '6110'
  163. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=170&flypage=flypage.tpl&lang=it&limitstart=0&page=shop.product_details&product_id=6110'
  164. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6110
  165. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6110'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6110
  167. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1493094801' OR start_date=0)
      AND (end_date>='1493076960' OR end_date=0)
      AND product_discount_id=discount_id
  168. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6110'
  169. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6110
      AND shopper_group_id=8  
      ORDER BY price_quantity_start
  170. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6110
  171. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&lang=it&page=shop.cart'
  172. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  173. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&lang=it&limitstart=0&page=shop.cart'
  174. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=0
      AND a.category_publish='Y'
  175. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=0
      AND a.category_publish='Y'
      ORDER BY a.category_name
  176. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=71&lang=it&page=shop.browse'
  177. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  178. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=71&lang=it&limitstart=0&page=shop.browse'
  179. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=71
      AND a.category_publish='Y'
  180. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=71
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  181. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=71
      AND a.category_publish='Y'
  182. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=71
      AND a.category_publish='Y'
      ORDER BY a.category_name
  183. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=158
      AND a.category_publish='Y'
  184. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=40&lang=it&page=shop.browse'
  185. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  186. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=40&lang=it&limitstart=0&page=shop.browse'
  187. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=40
      AND a.category_publish='Y'
  188. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=40
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  189. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=40
      AND a.category_publish='Y'
  190. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=40
      AND a.category_publish='Y'
      ORDER BY a.category_name
  191. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=58
      AND a.category_publish='Y'
  192. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=58
      AND a.category_publish='Y'
      ORDER BY a.category_name
  193. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=60
      AND a.category_publish='Y'
  194. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=166
      AND a.category_publish='Y'
  195. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=100
      AND a.category_publish='Y'
  196. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=100
      AND a.category_publish='Y'
      ORDER BY a.category_name
  197. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=101
      AND a.category_publish='Y'
  198. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=102
      AND a.category_publish='Y'
  199. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=103
      AND a.category_publish='Y'
  200. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=104
      AND a.category_publish='Y'
  201. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=105
      AND a.category_publish='Y'
  202. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=106
      AND a.category_publish='Y'
  203. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=107
      AND a.category_publish='Y'
  204. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=108
      AND a.category_publish='Y'
  205. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=109
      AND a.category_publish='Y'
  206. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=110
      AND a.category_publish='Y'
  207. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=111
      AND a.category_publish='Y'
  208. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=112
      AND a.category_publish='Y'
  209. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=162
      AND a.category_publish='Y'
  210. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=113
      AND a.category_publish='Y'
  211. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=115
      AND a.category_publish='Y'
  212. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=116
      AND a.category_publish='Y'
  213. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=117
      AND a.category_publish='Y'
  214. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=118
      AND a.category_publish='Y'
  215. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=119
      AND a.category_publish='Y'
  216. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=120
      AND a.category_publish='Y'
  217. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=114
      AND a.category_publish='Y'
  218. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=121
      AND a.category_publish='Y'
  219. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=122
      AND a.category_publish='Y'
  220. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=123
      AND a.category_publish='Y'
  221. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=124
      AND a.category_publish='Y'
  222. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=135
      AND a.category_publish='Y'
  223. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=125
      AND a.category_publish='Y'
  224. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=126
      AND a.category_publish='Y'
  225. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=127
      AND a.category_publish='Y'
  226. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=128
      AND a.category_publish='Y'
  227. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=129
      AND a.category_publish='Y'
  228. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=130
      AND a.category_publish='Y'
  229. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=131
      AND a.category_publish='Y'
  230. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=132
      AND a.category_publish='Y'
  231. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=133
      AND a.category_publish='Y'
  232. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=134
      AND a.category_publish='Y'
  233. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=136
      AND a.category_publish='Y'
  234. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=143
      AND a.category_publish='Y'
  235. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=137
      AND a.category_publish='Y'
  236. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=138
      AND a.category_publish='Y'
  237. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=139
      AND a.category_publish='Y'
  238. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=140
      AND a.category_publish='Y'
  239. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=141
      AND a.category_publish='Y'
  240. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=142
      AND a.category_publish='Y'
  241. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=144
      AND a.category_publish='Y'
  242. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=145
      AND a.category_publish='Y'
  243. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=146
      AND a.category_publish='Y'
  244. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=59
      AND a.category_publish='Y'
  245. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=26
      AND a.category_publish='Y'
  246. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=26
      AND a.category_publish='Y'
      ORDER BY a.category_name
  247. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=165
      AND a.category_publish='Y'
  248. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=167
      AND a.category_publish='Y'
  249. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=57
      AND a.category_publish='Y'
  250. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=27
      AND a.category_publish='Y'
  251. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=27
      AND a.category_publish='Y'
      ORDER BY a.category_name
  252. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=29
      AND a.category_publish='Y'
  253. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=28
      AND a.category_publish='Y'
  254. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=70
      AND a.category_publish='Y'
  255. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=49
      AND a.category_publish='Y'
  256. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=20
      AND a.category_publish='Y'
  257. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=20
      AND a.category_publish='Y'
      ORDER BY a.category_name
  258. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=21
      AND a.category_publish='Y'
  259. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=22
      AND a.category_publish='Y'
  260. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=83
      AND a.category_publish='Y'
  261. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=164
      AND a.category_publish='Y'
  262. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=64
      AND a.category_publish='Y'
  263. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=42
      AND a.category_publish='Y'
  264. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
  265. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=23
      AND a.category_publish='Y'
  266. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=163
      AND a.category_publish='Y'
  267. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=33
      AND a.category_publish='Y'
  268. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=33
      AND a.category_publish='Y'
      ORDER BY a.category_name
  269. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=35
      AND a.category_publish='Y'
  270. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=37
      AND a.category_publish='Y'
  271. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=34
      AND a.category_publish='Y'
  272. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=81
      AND a.category_publish='Y'
  273. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=82
      AND a.category_publish='Y'
  274. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=99&lang=it&page=shop.browse'
  275. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  276. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=99&lang=it&limitstart=0&page=shop.browse'
  277. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=99
      AND a.category_publish='Y'
  278. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=99
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  279. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=99
      AND a.category_publish='Y'
  280. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=147&lang=it&page=shop.browse'
  281. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  282. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=147&lang=it&limitstart=0&page=shop.browse'
  283. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=147
      AND a.category_publish='Y'
  284. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=147
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  285. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=147
      AND a.category_publish='Y'
  286. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=67&lang=it&page=shop.browse'
  287. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  288. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=67&lang=it&limitstart=0&page=shop.browse'
  289. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=67
      AND a.category_publish='Y'
  290. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=67
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  291. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=67
      AND a.category_publish='Y'
  292. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=168&lang=it&page=shop.browse'
  293. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  294. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=168&lang=it&limitstart=0&page=shop.browse'
  295. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=168
      AND a.category_publish='Y'
  296. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=168
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  297. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=168
      AND a.category_publish='Y'
  298. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=98&lang=it&page=shop.browse'
  299. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  300. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=98&lang=it&limitstart=0&page=shop.browse'
  301. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=98
      AND a.category_publish='Y'
  302. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=98
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  303. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=98
      AND a.category_publish='Y'
  304. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=95&lang=it&page=shop.browse'
  305. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  306. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=95&lang=it&limitstart=0&page=shop.browse'
  307. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=95
      AND a.category_publish='Y'
  308. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=95
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  309. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=95
      AND a.category_publish='Y'
  310. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=84&lang=it&page=shop.browse'
  311. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  312. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=84&lang=it&limitstart=0&page=shop.browse'
  313. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=84
      AND a.category_publish='Y'
  314. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=84
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  315. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=84
      AND a.category_publish='Y'
  316. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=160&lang=it&page=shop.browse'
  317. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  318. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=160&lang=it&limitstart=0&page=shop.browse'
  319. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=160
      AND a.category_publish='Y'
  320. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=160
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  321. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=160
      AND a.category_publish='Y'
  322. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=56&lang=it&page=shop.browse'
  323. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  324. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=56&lang=it&limitstart=0&page=shop.browse'
  325. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=56
      AND a.category_publish='Y'
  326. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=56
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  327. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=56
      AND a.category_publish='Y'
  328. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=169&lang=it&page=shop.browse'
  329. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  330. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=169&lang=it&limitstart=0&page=shop.browse'
  331. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=169
      AND a.category_publish='Y'
  332. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=169
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  333. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=169
      AND a.category_publish='Y'
  334. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=151&lang=it&page=shop.browse'
  335. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  336. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=151&lang=it&limitstart=0&page=shop.browse'
  337. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=151
      AND a.category_publish='Y'
  338. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=151
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  339. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=151
      AND a.category_publish='Y'
  340. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=151
      AND a.category_publish='Y'
      ORDER BY a.category_name
  341. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=154
      AND a.category_publish='Y'
  342. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=157
      AND a.category_publish='Y'
  343. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=155
      AND a.category_publish='Y'
  344. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=152
      AND a.category_publish='Y'
  345. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=156
      AND a.category_publish='Y'
  346. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=54&lang=it&page=shop.browse'
  347. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  348. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=54&lang=it&limitstart=0&page=shop.browse'
  349. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=54
      AND a.category_publish='Y'
  350. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=54
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  351. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=54
      AND a.category_publish='Y'
  352. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=39&lang=it&page=shop.browse'
  353. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  354. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=39&lang=it&limitstart=0&page=shop.browse'
  355. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=39
      AND a.category_publish='Y'
  356. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=39
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  357. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=39
      AND a.category_publish='Y'
  358. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=39
      AND a.category_publish='Y'
      ORDER BY a.category_name
  359. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=48
      AND a.category_publish='Y'
  360. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=86
      AND a.category_publish='Y'
  361. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=63
      AND a.category_publish='Y'
  362. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=62
      AND a.category_publish='Y'
  363. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=88
      AND a.category_publish='Y'
  364. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=148&lang=it&page=shop.browse'
  365. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  366. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=148&lang=it&limitstart=0&page=shop.browse'
  367. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=148
      AND a.category_publish='Y'
  368. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=148
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  369. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=148
      AND a.category_publish='Y'
  370. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=149&lang=it&page=shop.browse'
  371. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  372. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=149&lang=it&limitstart=0&page=shop.browse'
  373. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=149
      AND a.category_publish='Y'
  374. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=149
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  375. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=149
      AND a.category_publish='Y'
  376. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=159&lang=it&page=shop.browse'
  377. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  378. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=159&lang=it&limitstart=0&page=shop.browse'
  379. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=159
      AND a.category_publish='Y'
  380. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=159
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  381. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=159
      AND a.category_publish='Y'
  382. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=161&lang=it&page=shop.browse'
  383. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  384. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=161&lang=it&limitstart=0&page=shop.browse'
  385. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=161
      AND a.category_publish='Y'
  386. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=161
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  387. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=161
      AND a.category_publish='Y'
  388. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=41&lang=it&page=shop.browse'
  389. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  390. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&category_id=41&lang=it&limitstart=0&page=shop.browse'
  391. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=41
      AND a.category_publish='Y'
  392. SELECT COUNT(*)
      FROM jos_vm_product_category_xref AS f, jos_vm_category AS a, jos_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=41
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  393. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=41
      AND a.category_publish='Y'
  394. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=41
      AND a.category_publish='Y'
      ORDER BY a.category_name
  395. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=172
      AND a.category_publish='Y'
  396. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=171
      AND a.category_publish='Y'
  397. SELECT COUNT(*)
      FROM jos_vm_category AS a, jos_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=170
      AND a.category_publish='Y'
  398. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_user&lang=it&view=reset'
  399. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_user&lang=it&view=remind'
  400. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&lang=it&page=shop.registration'
  401. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  402. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&lang=it&limitstart=0&page=shop.registration'
  403. SELECT *
      FROM `jos_jnews_xonfig`
  404. SELECT *
      FROM `jos_jnews_lists`
      WHERE `published` = 1
  405. SELECT *, RAND() AS ordering
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND cid = 1
      AND catid = 1
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
  406. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 6
  407. INSERT INTO jos_bannertrack ( track_type, banner_id, track_date )
      VALUES ( 1, 6, '2017-04-25' )
  408. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_banners&bid=6&lang=it&task=click'
  409. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&lang=it'
  410. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  411. SELECT name, link,id
      FROM jos_menu
      WHERE id = 2
      AND published='1'
  412. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=2&lang=it&limitstart=0'
  413. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=3&id=11&lang=it&view=article'
  414. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=4&id=10&lang=it&view=article'
  415. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_contact&Itemid=5&id=1&lang=it&view=contact'
  416. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=16&id=1&lang=it&view=article'
  417. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=22&id=14&lang=it&view=article'
  418. SELECT `category_name` AS `name` , `category_id` AS `id` , `category_parent_id` , `category_child_id` , `list_order`
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category.category_publish='Y'
      AND (jos_vm_category_xref.category_parent_id='' OR jos_vm_category_xref.category_parent_id='0')
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      ORDER BY jos_vm_category.category_name,jos_vm_category.list_order ASC
  419. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&lang=it&page=shop.cart'
  420. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  421. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&lang=it&limitstart=0&page=shop.cart'
  422. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=22&lang=it&page=shop.parameter_search_form&product_type_id=1'
  423. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'

4 legacy queries logged

  1. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  2. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

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

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

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

      FROM jos_core_acl_aro_groups AS g1

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

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft

File Lingua caricati

Stringhe Diagnostica non tradotte

Nessuno

Stringhe Designer non tradotte

Nessuno