Skip to Store Area:

Print

Thursday & Sunday Home Delivery feed

Below you will have the option to receive home delivery for 13, 26, or 52 weeks by choosing one of our options below. To choose you must click on the image or link of the length of weeks you request. You will then be directed to the next page of our checkout where you will determine how many subscriptions you would like to receive to your address. (Maximum Of 4 Per Address).


PLEASE CHOOSE AN OPTION BELOW:



Order by:

  • «« Start
  • « Prev
  • 1
  • Next »
  • End »»
Results 1 - 3 of 3

Profile Information

Application afterLoad: 0.000 seconds, 0.74 MB
Application afterInitialise: 0.014 seconds, 2.17 MB
Application afterRoute: 0.015 seconds, 2.41 MB
Application afterDispatch: 0.042 seconds, 4.95 MB
Application afterRender: 0.053 seconds, 5.38 MB

Memory Usage

5793736

361 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'mi7pkkjtmpa01qi901vgepvn65'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1398270975' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'mi7pkkjtmpa01qi901vgepvn65'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'mi7pkkjtmpa01qi901vgepvn65','1398276375','','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 *
      FROM jos_vm_affiliate_settings
      WHERE `setting` = '1'
  8. SELECT o.`order_id` AS order_id, o.`cdate` AS DATE, o.`order_subtotal` AS order_subtotal, aop.`affiliate_id` AS affiliate_id
      FROM jos_vm_affiliate_orders_pretrack aop, jos_vm_orders o
      WHERE o.`order_id` = aop.`estimated_order_id`
      AND o.`ip_address` = aop.`customer_ip`
  9. DELETE
      FROM jos_vm_affiliate_orders_pretrack
  10. 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
  11. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  12. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                   
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  13. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  14. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  15. 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
  16. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  17. 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
  18. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  19. SELECT module_id, module_name
      FROM jos_vm_module
      ORDER BY module_name
  20. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  21. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  22. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  23. SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) AS num_rows
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=5
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
  24. SELECT category_id, category_name
      FROM jos_vm_category
      WHERE category_id='5'
  25. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='5'
  26. SELECT category_id, category_thumb_image, category_child_id,category_name
      FROM jos_vm_category,jos_vm_category_xref
      WHERE jos_vm_category_xref.category_parent_id='5'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      AND jos_vm_category.vendor_id='1'
      AND jos_vm_category.category_publish='Y'
      ORDER BY jos_vm_category.list_order, jos_vm_category.category_name ASC
  27. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='5'
      AND jos_vm_category.category_id='5'
  28. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  29. SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=5
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 0, 20
  30. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 0)
      ORDER BY menuid DESC
      LIMIT 0, 1
  31. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=13
  32. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='13'
      AND (start_date<='1398276375' OR start_date=0)
      AND (end_date>='1398209760' OR end_date=0)
      AND product_discount_id=discount_id
  33. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=13
  34. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1398276375' OR start_date=0)
      AND (end_date>='1398209760' OR end_date=0)
      AND product_discount_id=discount_id
  35. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='13'
  36. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  37. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=13
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  38. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=13
  39. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  40. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='13'
  41. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=13
  42. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=13
      AND `file_is_image`=1
      AND `file_published`=1
  43. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=13
  44. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  45. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=13
      AND `file_is_image`=0
      AND `file_published`=1
  46. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='13'
  47. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  48. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=13
  49. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=13
  50. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14
  51. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='14'
      AND (start_date<='1398276375' OR start_date=0)
      AND (end_date>='1398209760' OR end_date=0)
      AND product_discount_id=discount_id
  52. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14
  53. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1398276375' OR start_date=0)
      AND (end_date>='1398209760' OR end_date=0)
      AND product_discount_id=discount_id
  54. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='14'
  55. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  56. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=14
  57. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='14'
  58. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=14
  59. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14
      AND `file_is_image`=1
      AND `file_published`=1
  60. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14
  61. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  62. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14
      AND `file_is_image`=0
      AND `file_published`=1
  63. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='14'
  64. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  65. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14
  66. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14
  67. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=15
  68. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='15'
      AND (start_date<='1398276375' OR start_date=0)
      AND (end_date>='1398209760' OR end_date=0)
      AND product_discount_id=discount_id
  69. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=15
  70. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1398276375' OR start_date=0)
      AND (end_date>='1398209760' OR end_date=0)
      AND product_discount_id=discount_id
  71. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='15'
  72. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=15
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  73. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=15
  74. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='15'
  75. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=15
  76. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=15
      AND `file_is_image`=1
      AND `file_published`=1
  77. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=15
  78. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  79. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=15
      AND `file_is_image`=0
      AND `file_published`=1
  80. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='15'
  81. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  82. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=15
  83. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=15
  84. 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 = 0 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  85. SELECT `show_price_including_tax`
      FROM jos_vm_shopper_group
      WHERE `shopper_group_id` = '5'
  86. SELECT `show_price_including_tax`
      FROM jos_vm_shopper_group
      WHERE `shopper_group_id` = '5'
  87. SELECT ao.`order_id` AS order_id, o.`order_subtotal` - o.`coupon_discount`  + o.`order_tax` AS order_subtotal, ao.`affiliate_id` AS affiliate_id, ao.`order_status` AS aff_order_status, o.`order_status` AS order_status
      FROM jos_vm_affiliate_orders ao
      LEFT JOIN jos_vm_orders o
      ON ao.`order_id` = o.`order_id`
      WHERE ao.`paid` = 0
      AND ao.`order_status` != o.`order_status` OR ao.`paid` = 0
      AND o.`order_status` IS NULL
  88. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4321'
      GROUP BY order_id
  89. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4321'
      GROUP BY order_id
  90. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4330'
      GROUP BY order_id
  91. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4330'
      GROUP BY order_id
  92. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4354'
      GROUP BY order_id
  93. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4354'
      GROUP BY order_id
  94. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4396'
      GROUP BY order_id
  95. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4396'
      GROUP BY order_id
  96. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4423'
      GROUP BY order_id
  97. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4423'
      GROUP BY order_id
  98. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4436'
      GROUP BY order_id
  99. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4436'
      GROUP BY order_id
  100. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4446'
      GROUP BY order_id
  101. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4446'
      GROUP BY order_id
  102. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4500'
      GROUP BY order_id
  103. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4500'
      GROUP BY order_id
  104. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4519'
      GROUP BY order_id
  105. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4519'
      GROUP BY order_id
  106. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4561'
      GROUP BY order_id
  107. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4561'
      GROUP BY order_id
  108. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4585'
      GROUP BY order_id
  109. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4585'
      GROUP BY order_id
  110. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4590'
      GROUP BY order_id
  111. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4590'
      GROUP BY order_id
  112. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4677'
      GROUP BY order_id
  113. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4677'
      GROUP BY order_id
  114. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4691'
      GROUP BY order_id
  115. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4691'
      GROUP BY order_id
  116. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4711'
      GROUP BY order_id
  117. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4711'
      GROUP BY order_id
  118. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4713'
      GROUP BY order_id
  119. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4713'
      GROUP BY order_id
  120. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4721'
      GROUP BY order_id
  121. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4721'
      GROUP BY order_id
  122. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4722'
      GROUP BY order_id
  123. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4722'
      GROUP BY order_id
  124. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4743'
      GROUP BY order_id
  125. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4743'
      GROUP BY order_id
  126. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4814'
      GROUP BY order_id
  127. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4814'
      GROUP BY order_id
  128. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4909'
      GROUP BY order_id
  129. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4909'
      GROUP BY order_id
  130. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4932'
      GROUP BY order_id
  131. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4932'
      GROUP BY order_id
  132. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4933'
      GROUP BY order_id
  133. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4933'
      GROUP BY order_id
  134. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4944'
      GROUP BY order_id
  135. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4944'
      GROUP BY order_id
  136. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4947'
      GROUP BY order_id
  137. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4947'
      GROUP BY order_id
  138. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5016'
      GROUP BY order_id
  139. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5016'
      GROUP BY order_id
  140. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5052'
      GROUP BY order_id
  141. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5052'
      GROUP BY order_id
  142. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5106'
      GROUP BY order_id
  143. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5106'
      GROUP BY order_id
  144. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5170'
      GROUP BY order_id
  145. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5170'
      GROUP BY order_id
  146. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5293'
      GROUP BY order_id
  147. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5293'
      GROUP BY order_id
  148. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5294'
      GROUP BY order_id
  149. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5294'
      GROUP BY order_id
  150. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5309'
      GROUP BY order_id
  151. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5309'
      GROUP BY order_id
  152. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5321'
      GROUP BY order_id
  153. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5321'
      GROUP BY order_id
  154. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5334'
      GROUP BY order_id
  155. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5334'
      GROUP BY order_id
  156. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5335'
      GROUP BY order_id
  157. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5335'
      GROUP BY order_id
  158. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5339'
      GROUP BY order_id
  159. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5339'
      GROUP BY order_id
  160. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5341'
      GROUP BY order_id
  161. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5341'
      GROUP BY order_id
  162. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5346'
      GROUP BY order_id
  163. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5346'
      GROUP BY order_id
  164. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5350'
      GROUP BY order_id
  165. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5350'
      GROUP BY order_id
  166. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5366'
      GROUP BY order_id
  167. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5366'
      GROUP BY order_id
  168. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5421'
      GROUP BY order_id
  169. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5421'
      GROUP BY order_id
  170. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5453'
      GROUP BY order_id
  171. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5453'
      GROUP BY order_id
  172. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5471'
      GROUP BY order_id
  173. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5471'
      GROUP BY order_id
  174. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5472'
      GROUP BY order_id
  175. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5472'
      GROUP BY order_id
  176. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5474'
      GROUP BY order_id
  177. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5474'
      GROUP BY order_id
  178. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5484'
      GROUP BY order_id
  179. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5484'
      GROUP BY order_id
  180. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5526'
      GROUP BY order_id
  181. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5526'
      GROUP BY order_id
  182. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5550'
      GROUP BY order_id
  183. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5550'
      GROUP BY order_id
  184. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5551'
      GROUP BY order_id
  185. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5551'
      GROUP BY order_id
  186. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5580'
      GROUP BY order_id
  187. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5580'
      GROUP BY order_id
  188. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5582'
      GROUP BY order_id
  189. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5582'
      GROUP BY order_id
  190. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5588'
      GROUP BY order_id
  191. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5588'
      GROUP BY order_id
  192. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5630'
      GROUP BY order_id
  193. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5630'
      GROUP BY order_id
  194. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5635'
      GROUP BY order_id
  195. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5635'
      GROUP BY order_id
  196. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5665'
      GROUP BY order_id
  197. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5665'
      GROUP BY order_id
  198. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5670'
      GROUP BY order_id
  199. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5670'
      GROUP BY order_id
  200. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5671'
      GROUP BY order_id
  201. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5671'
      GROUP BY order_id
  202. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5681'
      GROUP BY order_id
  203. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5681'
      GROUP BY order_id
  204. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5716'
      GROUP BY order_id
  205. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5716'
      GROUP BY order_id
  206. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5732'
      GROUP BY order_id
  207. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5732'
      GROUP BY order_id
  208. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5818'
      GROUP BY order_id
  209. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5818'
      GROUP BY order_id
  210. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5880'
      GROUP BY order_id
  211. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5880'
      GROUP BY order_id
  212. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5886'
      GROUP BY order_id
  213. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5886'
      GROUP BY order_id
  214. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5972'
      GROUP BY order_id
  215. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5972'
      GROUP BY order_id
  216. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5994'
      GROUP BY order_id
  217. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5994'
      GROUP BY order_id
  218. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5995'
      GROUP BY order_id
  219. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5995'
      GROUP BY order_id
  220. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5996'
      GROUP BY order_id
  221. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5996'
      GROUP BY order_id
  222. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6035'
      GROUP BY order_id
  223. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6035'
      GROUP BY order_id
  224. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6090'
      GROUP BY order_id
  225. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6090'
      GROUP BY order_id
  226. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6113'
      GROUP BY order_id
  227. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6113'
      GROUP BY order_id
  228. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6117'
      GROUP BY order_id
  229. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6117'
      GROUP BY order_id
  230. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6189'
      GROUP BY order_id
  231. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6189'
      GROUP BY order_id
  232. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6192'
      GROUP BY order_id
  233. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6192'
      GROUP BY order_id
  234. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6265'
      GROUP BY order_id
  235. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6265'
      GROUP BY order_id
  236. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6328'
      GROUP BY order_id
  237. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6328'
      GROUP BY order_id
  238. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6384'
      GROUP BY order_id
  239. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6384'
      GROUP BY order_id
  240. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6389'
      GROUP BY order_id
  241. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6389'
      GROUP BY order_id
  242. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6541'
      GROUP BY order_id
  243. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6541'
      GROUP BY order_id
  244. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6542'
      GROUP BY order_id
  245. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6542'
      GROUP BY order_id
  246. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6550'
      GROUP BY order_id
  247. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6550'
      GROUP BY order_id
  248. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6580'
      GROUP BY order_id
  249. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6580'
      GROUP BY order_id
  250. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6591'
      GROUP BY order_id
  251. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6591'
      GROUP BY order_id
  252. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6711'
      GROUP BY order_id
  253. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6711'
      GROUP BY order_id
  254. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6719'
      GROUP BY order_id
  255. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6719'
      GROUP BY order_id
  256. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6843'
      GROUP BY order_id
  257. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6843'
      GROUP BY order_id
  258. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6865'
      GROUP BY order_id
  259. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6865'
      GROUP BY order_id
  260. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7191'
      GROUP BY order_id
  261. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7191'
      GROUP BY order_id
  262. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7203'
      GROUP BY order_id
  263. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7203'
      GROUP BY order_id
  264. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7265'
      GROUP BY order_id
  265. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7265'
      GROUP BY order_id
  266. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7271'
      GROUP BY order_id
  267. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7271'
      GROUP BY order_id
  268. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7361'
      GROUP BY order_id
  269. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7361'
      GROUP BY order_id
  270. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7435'
      GROUP BY order_id
  271. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7435'
      GROUP BY order_id
  272. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7443'
      GROUP BY order_id
  273. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7443'
      GROUP BY order_id
  274. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7601'
      GROUP BY order_id
  275. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7601'
      GROUP BY order_id
  276. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7617'
      GROUP BY order_id
  277. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7617'
      GROUP BY order_id
  278. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7772'
      GROUP BY order_id
  279. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7772'
      GROUP BY order_id
  280. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7829'
      GROUP BY order_id
  281. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7829'
      GROUP BY order_id
  282. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7924'
      GROUP BY order_id
  283. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7924'
      GROUP BY order_id
  284. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8008'
      GROUP BY order_id
  285. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8008'
      GROUP BY order_id
  286. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8010'
      GROUP BY order_id
  287. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8010'
      GROUP BY order_id
  288. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8025'
      GROUP BY order_id
  289. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8025'
      GROUP BY order_id
  290. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8028'
      GROUP BY order_id
  291. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8028'
      GROUP BY order_id
  292. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8031'
      GROUP BY order_id
  293. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8031'
      GROUP BY order_id
  294. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8043'
      GROUP BY order_id
  295. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8043'
      GROUP BY order_id
  296. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8056'
      GROUP BY order_id
  297. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8056'
      GROUP BY order_id
  298. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8059'
      GROUP BY order_id
  299. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8059'
      GROUP BY order_id
  300. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8202'
      GROUP BY order_id
  301. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8202'
      GROUP BY order_id
  302. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8243'
      GROUP BY order_id
  303. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8243'
      GROUP BY order_id
  304. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8248'
      GROUP BY order_id
  305. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8248'
      GROUP BY order_id
  306. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8368'
      GROUP BY order_id
  307. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8368'
      GROUP BY order_id
  308. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8385'
      GROUP BY order_id
  309. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8385'
      GROUP BY order_id
  310. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8401'
      GROUP BY order_id
  311. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8401'
      GROUP BY order_id
  312. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9066'
      GROUP BY order_id
  313. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9066'
      GROUP BY order_id
  314. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9120'
      GROUP BY order_id
  315. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9120'
      GROUP BY order_id
  316. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9120'
      GROUP BY order_id
  317. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9120'
      GROUP BY order_id
  318. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9160'
      GROUP BY order_id
  319. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9160'
      GROUP BY order_id
  320. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9377'
      GROUP BY order_id
  321. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9377'
      GROUP BY order_id
  322. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9411'
      GROUP BY order_id
  323. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9411'
      GROUP BY order_id
  324. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9428'
      GROUP BY order_id
  325. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9428'
      GROUP BY order_id
  326. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9465'
      GROUP BY order_id
  327. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9465'
      GROUP BY order_id
  328. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9516'
      GROUP BY order_id
  329. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9516'
      GROUP BY order_id
  330. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9528'
      GROUP BY order_id
  331. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9528'
      GROUP BY order_id
  332. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9610'
      GROUP BY order_id
  333. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9610'
      GROUP BY order_id
  334. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9633'
      GROUP BY order_id
  335. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9633'
      GROUP BY order_id
  336. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9832'
      GROUP BY order_id
  337. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9832'
      GROUP BY order_id
  338. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9846'
      GROUP BY order_id
  339. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9846'
      GROUP BY order_id
  340. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9936'
      GROUP BY order_id
  341. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9936'
      GROUP BY order_id
  342. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10029'
      GROUP BY order_id
  343. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10029'
      GROUP BY order_id
  344. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10122'
      GROUP BY order_id
  345. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10122'
      GROUP BY order_id
  346. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10159'
      GROUP BY order_id
  347. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10159'
      GROUP BY order_id
  348. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10256'
      GROUP BY order_id
  349. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10256'
      GROUP BY order_id
  350. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10314'
      GROUP BY order_id
  351. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10314'
      GROUP BY order_id
  352. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10578'
      GROUP BY order_id
  353. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10578'
      GROUP BY order_id
  354. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10610'
      GROUP BY order_id
  355. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10610'
      GROUP BY order_id
  356. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10712'
      GROUP BY order_id
  357. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10712'
      GROUP BY order_id
  358. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10729'
      GROUP BY order_id
  359. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10729'
      GROUP BY order_id
  360. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10741'
      GROUP BY order_id
  361. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10741'
      GROUP BY order_id

361 legacy queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'mi7pkkjtmpa01qi901vgepvn65'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1398270975' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'mi7pkkjtmpa01qi901vgepvn65'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'mi7pkkjtmpa01qi901vgepvn65','1398276375','','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 *
      FROM jos_vm_affiliate_settings
      WHERE `setting` = '1'
  8. SELECT o.`order_id` AS order_id, o.`cdate` AS DATE, o.`order_subtotal` AS order_subtotal, aop.`affiliate_id` AS affiliate_id
      FROM jos_vm_affiliate_orders_pretrack aop, jos_vm_orders o
      WHERE o.`order_id` = aop.`estimated_order_id`
      AND o.`ip_address` = aop.`customer_ip`
  9. DELETE
      FROM jos_vm_affiliate_orders_pretrack
  10. 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
  11. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  12. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                   
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  13. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  14. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  15. 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
  16. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  17. 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
  18. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  19. SELECT module_id, module_name
      FROM jos_vm_module
      ORDER BY module_name
  20. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  21. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  22. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  23. SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) AS num_rows
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=5
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
  24. SELECT category_id, category_name
      FROM jos_vm_category
      WHERE category_id='5'
  25. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='5'
  26. SELECT category_id, category_thumb_image, category_child_id,category_name
      FROM jos_vm_category,jos_vm_category_xref
      WHERE jos_vm_category_xref.category_parent_id='5'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      AND jos_vm_category.vendor_id='1'
      AND jos_vm_category.category_publish='Y'
      ORDER BY jos_vm_category.list_order, jos_vm_category.category_name ASC
  27. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='5'
      AND jos_vm_category.category_id='5'
  28. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  29. SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=5
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 0, 20
  30. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 0)
      ORDER BY menuid DESC
      LIMIT 0, 1
  31. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=13
  32. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='13'
      AND (start_date<='1398276375' OR start_date=0)
      AND (end_date>='1398209760' OR end_date=0)
      AND product_discount_id=discount_id
  33. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=13
  34. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1398276375' OR start_date=0)
      AND (end_date>='1398209760' OR end_date=0)
      AND product_discount_id=discount_id
  35. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='13'
  36. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  37. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=13
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  38. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=13
  39. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  40. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='13'
  41. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=13
  42. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=13
      AND `file_is_image`=1
      AND `file_published`=1
  43. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=13
  44. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  45. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=13
      AND `file_is_image`=0
      AND `file_published`=1
  46. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='13'
  47. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  48. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=13
  49. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=13
  50. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14
  51. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='14'
      AND (start_date<='1398276375' OR start_date=0)
      AND (end_date>='1398209760' OR end_date=0)
      AND product_discount_id=discount_id
  52. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14
  53. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1398276375' OR start_date=0)
      AND (end_date>='1398209760' OR end_date=0)
      AND product_discount_id=discount_id
  54. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='14'
  55. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  56. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=14
  57. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='14'
  58. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=14
  59. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14
      AND `file_is_image`=1
      AND `file_published`=1
  60. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14
  61. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  62. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14
      AND `file_is_image`=0
      AND `file_published`=1
  63. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='14'
  64. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  65. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14
  66. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14
  67. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=15
  68. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='15'
      AND (start_date<='1398276375' OR start_date=0)
      AND (end_date>='1398209760' OR end_date=0)
      AND product_discount_id=discount_id
  69. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=15
  70. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1398276375' OR start_date=0)
      AND (end_date>='1398209760' OR end_date=0)
      AND product_discount_id=discount_id
  71. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='15'
  72. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=15
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  73. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=15
  74. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='15'
  75. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=15
  76. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=15
      AND `file_is_image`=1
      AND `file_published`=1
  77. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=15
  78. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  79. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=15
      AND `file_is_image`=0
      AND `file_published`=1
  80. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='15'
  81. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  82. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=15
  83. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=15
  84. 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 = 0 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  85. SELECT `show_price_including_tax`
      FROM jos_vm_shopper_group
      WHERE `shopper_group_id` = '5'
  86. SELECT `show_price_including_tax`
      FROM jos_vm_shopper_group
      WHERE `shopper_group_id` = '5'
  87. SELECT ao.`order_id` AS order_id, o.`order_subtotal` - o.`coupon_discount`  + o.`order_tax` AS order_subtotal, ao.`affiliate_id` AS affiliate_id, ao.`order_status` AS aff_order_status, o.`order_status` AS order_status
      FROM jos_vm_affiliate_orders ao
      LEFT JOIN jos_vm_orders o
      ON ao.`order_id` = o.`order_id`
      WHERE ao.`paid` = 0
      AND ao.`order_status` != o.`order_status` OR ao.`paid` = 0
      AND o.`order_status` IS NULL
  88. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4321'
      GROUP BY order_id
  89. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4321'
      GROUP BY order_id
  90. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4330'
      GROUP BY order_id
  91. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4330'
      GROUP BY order_id
  92. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4354'
      GROUP BY order_id
  93. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4354'
      GROUP BY order_id
  94. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4396'
      GROUP BY order_id
  95. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4396'
      GROUP BY order_id
  96. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4423'
      GROUP BY order_id
  97. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4423'
      GROUP BY order_id
  98. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4436'
      GROUP BY order_id
  99. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4436'
      GROUP BY order_id
  100. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4446'
      GROUP BY order_id
  101. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4446'
      GROUP BY order_id
  102. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4500'
      GROUP BY order_id
  103. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4500'
      GROUP BY order_id
  104. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4519'
      GROUP BY order_id
  105. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4519'
      GROUP BY order_id
  106. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4561'
      GROUP BY order_id
  107. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4561'
      GROUP BY order_id
  108. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4585'
      GROUP BY order_id
  109. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4585'
      GROUP BY order_id
  110. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4590'
      GROUP BY order_id
  111. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4590'
      GROUP BY order_id
  112. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4677'
      GROUP BY order_id
  113. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4677'
      GROUP BY order_id
  114. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4691'
      GROUP BY order_id
  115. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4691'
      GROUP BY order_id
  116. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4711'
      GROUP BY order_id
  117. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4711'
      GROUP BY order_id
  118. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4713'
      GROUP BY order_id
  119. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4713'
      GROUP BY order_id
  120. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4721'
      GROUP BY order_id
  121. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4721'
      GROUP BY order_id
  122. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4722'
      GROUP BY order_id
  123. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4722'
      GROUP BY order_id
  124. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4743'
      GROUP BY order_id
  125. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4743'
      GROUP BY order_id
  126. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4814'
      GROUP BY order_id
  127. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4814'
      GROUP BY order_id
  128. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4909'
      GROUP BY order_id
  129. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4909'
      GROUP BY order_id
  130. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4932'
      GROUP BY order_id
  131. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4932'
      GROUP BY order_id
  132. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4933'
      GROUP BY order_id
  133. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4933'
      GROUP BY order_id
  134. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4944'
      GROUP BY order_id
  135. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4944'
      GROUP BY order_id
  136. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4947'
      GROUP BY order_id
  137. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4947'
      GROUP BY order_id
  138. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5016'
      GROUP BY order_id
  139. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5016'
      GROUP BY order_id
  140. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5052'
      GROUP BY order_id
  141. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5052'
      GROUP BY order_id
  142. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5106'
      GROUP BY order_id
  143. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5106'
      GROUP BY order_id
  144. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5170'
      GROUP BY order_id
  145. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5170'
      GROUP BY order_id
  146. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5293'
      GROUP BY order_id
  147. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5293'
      GROUP BY order_id
  148. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5294'
      GROUP BY order_id
  149. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5294'
      GROUP BY order_id
  150. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5309'
      GROUP BY order_id
  151. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5309'
      GROUP BY order_id
  152. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5321'
      GROUP BY order_id
  153. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5321'
      GROUP BY order_id
  154. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5334'
      GROUP BY order_id
  155. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5334'
      GROUP BY order_id
  156. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5335'
      GROUP BY order_id
  157. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5335'
      GROUP BY order_id
  158. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5339'
      GROUP BY order_id
  159. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5339'
      GROUP BY order_id
  160. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5341'
      GROUP BY order_id
  161. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5341'
      GROUP BY order_id
  162. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5346'
      GROUP BY order_id
  163. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5346'
      GROUP BY order_id
  164. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5350'
      GROUP BY order_id
  165. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5350'
      GROUP BY order_id
  166. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5366'
      GROUP BY order_id
  167. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5366'
      GROUP BY order_id
  168. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5421'
      GROUP BY order_id
  169. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5421'
      GROUP BY order_id
  170. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5453'
      GROUP BY order_id
  171. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5453'
      GROUP BY order_id
  172. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5471'
      GROUP BY order_id
  173. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5471'
      GROUP BY order_id
  174. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5472'
      GROUP BY order_id
  175. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5472'
      GROUP BY order_id
  176. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5474'
      GROUP BY order_id
  177. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5474'
      GROUP BY order_id
  178. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5484'
      GROUP BY order_id
  179. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5484'
      GROUP BY order_id
  180. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5526'
      GROUP BY order_id
  181. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5526'
      GROUP BY order_id
  182. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5550'
      GROUP BY order_id
  183. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5550'
      GROUP BY order_id
  184. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5551'
      GROUP BY order_id
  185. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5551'
      GROUP BY order_id
  186. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5580'
      GROUP BY order_id
  187. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5580'
      GROUP BY order_id
  188. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5582'
      GROUP BY order_id
  189. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5582'
      GROUP BY order_id
  190. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5588'
      GROUP BY order_id
  191. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5588'
      GROUP BY order_id
  192. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5630'
      GROUP BY order_id
  193. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5630'
      GROUP BY order_id
  194. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5635'
      GROUP BY order_id
  195. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5635'
      GROUP BY order_id
  196. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5665'
      GROUP BY order_id
  197. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5665'
      GROUP BY order_id
  198. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5670'
      GROUP BY order_id
  199. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5670'
      GROUP BY order_id
  200. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5671'
      GROUP BY order_id
  201. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5671'
      GROUP BY order_id
  202. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5681'
      GROUP BY order_id
  203. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5681'
      GROUP BY order_id
  204. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5716'
      GROUP BY order_id
  205. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5716'
      GROUP BY order_id
  206. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5732'
      GROUP BY order_id
  207. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5732'
      GROUP BY order_id
  208. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5818'
      GROUP BY order_id
  209. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5818'
      GROUP BY order_id
  210. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5880'
      GROUP BY order_id
  211. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5880'
      GROUP BY order_id
  212. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5886'
      GROUP BY order_id
  213. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5886'
      GROUP BY order_id
  214. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5972'
      GROUP BY order_id
  215. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5972'
      GROUP BY order_id
  216. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5994'
      GROUP BY order_id
  217. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5994'
      GROUP BY order_id
  218. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5995'
      GROUP BY order_id
  219. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5995'
      GROUP BY order_id
  220. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5996'
      GROUP BY order_id
  221. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5996'
      GROUP BY order_id
  222. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6035'
      GROUP BY order_id
  223. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6035'
      GROUP BY order_id
  224. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6090'
      GROUP BY order_id
  225. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6090'
      GROUP BY order_id
  226. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6113'
      GROUP BY order_id
  227. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6113'
      GROUP BY order_id
  228. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6117'
      GROUP BY order_id
  229. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6117'
      GROUP BY order_id
  230. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6189'
      GROUP BY order_id
  231. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6189'
      GROUP BY order_id
  232. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6192'
      GROUP BY order_id
  233. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6192'
      GROUP BY order_id
  234. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6265'
      GROUP BY order_id
  235. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6265'
      GROUP BY order_id
  236. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6328'
      GROUP BY order_id
  237. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6328'
      GROUP BY order_id
  238. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6384'
      GROUP BY order_id
  239. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6384'
      GROUP BY order_id
  240. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6389'
      GROUP BY order_id
  241. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6389'
      GROUP BY order_id
  242. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6541'
      GROUP BY order_id
  243. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6541'
      GROUP BY order_id
  244. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6542'
      GROUP BY order_id
  245. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6542'
      GROUP BY order_id
  246. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6550'
      GROUP BY order_id
  247. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6550'
      GROUP BY order_id
  248. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6580'
      GROUP BY order_id
  249. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6580'
      GROUP BY order_id
  250. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6591'
      GROUP BY order_id
  251. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6591'
      GROUP BY order_id
  252. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6711'
      GROUP BY order_id
  253. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6711'
      GROUP BY order_id
  254. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6719'
      GROUP BY order_id
  255. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6719'
      GROUP BY order_id
  256. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6843'
      GROUP BY order_id
  257. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6843'
      GROUP BY order_id
  258. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6865'
      GROUP BY order_id
  259. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6865'
      GROUP BY order_id
  260. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7191'
      GROUP BY order_id
  261. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7191'
      GROUP BY order_id
  262. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7203'
      GROUP BY order_id
  263. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7203'
      GROUP BY order_id
  264. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7265'
      GROUP BY order_id
  265. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7265'
      GROUP BY order_id
  266. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7271'
      GROUP BY order_id
  267. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7271'
      GROUP BY order_id
  268. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7361'
      GROUP BY order_id
  269. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7361'
      GROUP BY order_id
  270. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7435'
      GROUP BY order_id
  271. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7435'
      GROUP BY order_id
  272. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7443'
      GROUP BY order_id
  273. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7443'
      GROUP BY order_id
  274. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7601'
      GROUP BY order_id
  275. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7601'
      GROUP BY order_id
  276. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7617'
      GROUP BY order_id
  277. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7617'
      GROUP BY order_id
  278. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7772'
      GROUP BY order_id
  279. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7772'
      GROUP BY order_id
  280. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7829'
      GROUP BY order_id
  281. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7829'
      GROUP BY order_id
  282. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7924'
      GROUP BY order_id
  283. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7924'
      GROUP BY order_id
  284. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8008'
      GROUP BY order_id
  285. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8008'
      GROUP BY order_id
  286. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8010'
      GROUP BY order_id
  287. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8010'
      GROUP BY order_id
  288. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8025'
      GROUP BY order_id
  289. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8025'
      GROUP BY order_id
  290. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8028'
      GROUP BY order_id
  291. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8028'
      GROUP BY order_id
  292. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8031'
      GROUP BY order_id
  293. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8031'
      GROUP BY order_id
  294. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8043'
      GROUP BY order_id
  295. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8043'
      GROUP BY order_id
  296. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8056'
      GROUP BY order_id
  297. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8056'
      GROUP BY order_id
  298. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8059'
      GROUP BY order_id
  299. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8059'
      GROUP BY order_id
  300. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8202'
      GROUP BY order_id
  301. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8202'
      GROUP BY order_id
  302. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8243'
      GROUP BY order_id
  303. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8243'
      GROUP BY order_id
  304. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8248'
      GROUP BY order_id
  305. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8248'
      GROUP BY order_id
  306. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8368'
      GROUP BY order_id
  307. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8368'
      GROUP BY order_id
  308. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8385'
      GROUP BY order_id
  309. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8385'
      GROUP BY order_id
  310. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8401'
      GROUP BY order_id
  311. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8401'
      GROUP BY order_id
  312. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9066'
      GROUP BY order_id
  313. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9066'
      GROUP BY order_id
  314. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9120'
      GROUP BY order_id
  315. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9120'
      GROUP BY order_id
  316. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9120'
      GROUP BY order_id
  317. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9120'
      GROUP BY order_id
  318. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9160'
      GROUP BY order_id
  319. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9160'
      GROUP BY order_id
  320. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9377'
      GROUP BY order_id
  321. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9377'
      GROUP BY order_id
  322. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9411'
      GROUP BY order_id
  323. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9411'
      GROUP BY order_id
  324. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9428'
      GROUP BY order_id
  325. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9428'
      GROUP BY order_id
  326. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9465'
      GROUP BY order_id
  327. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9465'
      GROUP BY order_id
  328. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9516'
      GROUP BY order_id
  329. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9516'
      GROUP BY order_id
  330. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9528'
      GROUP BY order_id
  331. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9528'
      GROUP BY order_id
  332. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9610'
      GROUP BY order_id
  333. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9610'
      GROUP BY order_id
  334. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9633'
      GROUP BY order_id
  335. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9633'
      GROUP BY order_id
  336. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9832'
      GROUP BY order_id
  337. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9832'
      GROUP BY order_id
  338. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9846'
      GROUP BY order_id
  339. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9846'
      GROUP BY order_id
  340. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9936'
      GROUP BY order_id
  341. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9936'
      GROUP BY order_id
  342. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10029'
      GROUP BY order_id
  343. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10029'
      GROUP BY order_id
  344. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10122'
      GROUP BY order_id
  345. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10122'
      GROUP BY order_id
  346. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10159'
      GROUP BY order_id
  347. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10159'
      GROUP BY order_id
  348. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10256'
      GROUP BY order_id
  349. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10256'
      GROUP BY order_id
  350. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10314'
      GROUP BY order_id
  351. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10314'
      GROUP BY order_id
  352. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10578'
      GROUP BY order_id
  353. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10578'
      GROUP BY order_id
  354. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10610'
      GROUP BY order_id
  355. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10610'
      GROUP BY order_id
  356. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10712'
      GROUP BY order_id
  357. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10712'
      GROUP BY order_id
  358. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10729'
      GROUP BY order_id
  359. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10729'
      GROUP BY order_id
  360. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10741'
      GROUP BY order_id
  361. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10741'
      GROUP BY order_id

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None