Skip to Store Area:

About My Orlando Sentinel

MyOrlandoSentinel.com is a secure online destination where you can get the very best prices and discounts on home delivery subscriptions to the Orlando Sentinel and Sun Sentinel. If you would like to start a subscription to the Orlando Sentinel or just research the latest home delivery rates, please visit MyOrlandoSentinel.com

We are a local promotions and marketing company contracted with the Orlando Sentinel and Sun Sentinel to help build circulation and home delivery through website marketing, retail kiosk sales, coupon classes and local events. That means we have direct contact with the Sentinel so that we can offer you prompt, reliable home delivery service at great prices. Our subscription order checkout is quick, easy, secure and your newspaper delivery will begin in less than a week of your order being placed. Your order information is kept safe, and we value your privacy. We would love a chance to earn your business.

We are always eager to hear from our customers. Please let us know how we can help you. If you have any suggestions that might better your experience with MyOrlandoSentinel.com please send an email to us at: This e-mail address is being protected from spambots. You need JavaScript enabled to view it . We look forward to hearing from you.

 

Profile Information

Application afterLoad: 0.000 seconds, 0.74 MB
Application afterInitialise: 0.015 seconds, 2.16 MB
Application afterRoute: 0.017 seconds, 2.41 MB
Application afterDispatch: 0.027 seconds, 3.47 MB
Application afterRender: 0.043 seconds, 5.40 MB

Memory Usage

5808560

301 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'gv6fvnr43t034cdu1cevtlqpc7'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1398290629' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'gv6fvnr43t034cdu1cevtlqpc7'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'gv6fvnr43t034cdu1cevtlqpc7','1398296029','','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 template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 2)
      ORDER BY menuid DESC
      LIMIT 0, 1
  12. SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access  
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = cc.SECTION
      AND s.scope = "content"
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE a.id = 1
      AND (  ( a.created_by = 0 )    OR  ( a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-04-23 23:33:49' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-04-23 23:33:49' )   )    OR  ( a.state = -1 )  )
  13. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='1'
  14. 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 = 2 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  15. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  16. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                   
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  17. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  18. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  19. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

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

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

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

      FROM jos_core_acl_aro_groups AS g1

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

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft
  22. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  23. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  24. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  25. SELECT `show_price_including_tax`
      FROM jos_vm_shopper_group
      WHERE `shopper_group_id` = '5'
  26. SELECT `show_price_including_tax`
      FROM jos_vm_shopper_group
      WHERE `shopper_group_id` = '5'
  27. 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
  28. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4321'
      GROUP BY order_id
  29. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4321'
      GROUP BY order_id
  30. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4330'
      GROUP BY order_id
  31. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4330'
      GROUP BY order_id
  32. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4354'
      GROUP BY order_id
  33. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4354'
      GROUP BY order_id
  34. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4396'
      GROUP BY order_id
  35. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4396'
      GROUP BY order_id
  36. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4423'
      GROUP BY order_id
  37. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4423'
      GROUP BY order_id
  38. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4436'
      GROUP BY order_id
  39. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4436'
      GROUP BY order_id
  40. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4446'
      GROUP BY order_id
  41. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4446'
      GROUP BY order_id
  42. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4500'
      GROUP BY order_id
  43. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4500'
      GROUP BY order_id
  44. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4519'
      GROUP BY order_id
  45. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4519'
      GROUP BY order_id
  46. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4561'
      GROUP BY order_id
  47. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4561'
      GROUP BY order_id
  48. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4585'
      GROUP BY order_id
  49. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4585'
      GROUP BY order_id
  50. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4590'
      GROUP BY order_id
  51. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4590'
      GROUP BY order_id
  52. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4677'
      GROUP BY order_id
  53. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4677'
      GROUP BY order_id
  54. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4691'
      GROUP BY order_id
  55. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4691'
      GROUP BY order_id
  56. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4711'
      GROUP BY order_id
  57. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4711'
      GROUP BY order_id
  58. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4713'
      GROUP BY order_id
  59. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4713'
      GROUP BY order_id
  60. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4721'
      GROUP BY order_id
  61. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4721'
      GROUP BY order_id
  62. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4722'
      GROUP BY order_id
  63. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4722'
      GROUP BY order_id
  64. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4743'
      GROUP BY order_id
  65. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4743'
      GROUP BY order_id
  66. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4814'
      GROUP BY order_id
  67. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4814'
      GROUP BY order_id
  68. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4909'
      GROUP BY order_id
  69. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4909'
      GROUP BY order_id
  70. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4932'
      GROUP BY order_id
  71. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4932'
      GROUP BY order_id
  72. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4933'
      GROUP BY order_id
  73. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4933'
      GROUP BY order_id
  74. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4944'
      GROUP BY order_id
  75. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4944'
      GROUP BY order_id
  76. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4947'
      GROUP BY order_id
  77. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4947'
      GROUP BY order_id
  78. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5016'
      GROUP BY order_id
  79. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5016'
      GROUP BY order_id
  80. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5052'
      GROUP BY order_id
  81. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5052'
      GROUP BY order_id
  82. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5106'
      GROUP BY order_id
  83. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5106'
      GROUP BY order_id
  84. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5170'
      GROUP BY order_id
  85. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5170'
      GROUP BY order_id
  86. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5293'
      GROUP BY order_id
  87. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5293'
      GROUP BY order_id
  88. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5294'
      GROUP BY order_id
  89. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5294'
      GROUP BY order_id
  90. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5309'
      GROUP BY order_id
  91. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5309'
      GROUP BY order_id
  92. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5321'
      GROUP BY order_id
  93. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5321'
      GROUP BY order_id
  94. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5334'
      GROUP BY order_id
  95. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5334'
      GROUP BY order_id
  96. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5335'
      GROUP BY order_id
  97. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5335'
      GROUP BY order_id
  98. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5339'
      GROUP BY order_id
  99. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5339'
      GROUP BY order_id
  100. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5341'
      GROUP BY order_id
  101. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5341'
      GROUP BY order_id
  102. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5346'
      GROUP BY order_id
  103. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5346'
      GROUP BY order_id
  104. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5350'
      GROUP BY order_id
  105. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5350'
      GROUP BY order_id
  106. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5366'
      GROUP BY order_id
  107. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5366'
      GROUP BY order_id
  108. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5421'
      GROUP BY order_id
  109. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5421'
      GROUP BY order_id
  110. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5453'
      GROUP BY order_id
  111. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5453'
      GROUP BY order_id
  112. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5471'
      GROUP BY order_id
  113. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5471'
      GROUP BY order_id
  114. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5472'
      GROUP BY order_id
  115. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5472'
      GROUP BY order_id
  116. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5474'
      GROUP BY order_id
  117. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5474'
      GROUP BY order_id
  118. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5484'
      GROUP BY order_id
  119. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5484'
      GROUP BY order_id
  120. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5526'
      GROUP BY order_id
  121. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5526'
      GROUP BY order_id
  122. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5550'
      GROUP BY order_id
  123. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5550'
      GROUP BY order_id
  124. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5551'
      GROUP BY order_id
  125. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5551'
      GROUP BY order_id
  126. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5580'
      GROUP BY order_id
  127. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5580'
      GROUP BY order_id
  128. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5582'
      GROUP BY order_id
  129. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5582'
      GROUP BY order_id
  130. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5588'
      GROUP BY order_id
  131. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5588'
      GROUP BY order_id
  132. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5630'
      GROUP BY order_id
  133. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5630'
      GROUP BY order_id
  134. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5635'
      GROUP BY order_id
  135. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5635'
      GROUP BY order_id
  136. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5665'
      GROUP BY order_id
  137. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5665'
      GROUP BY order_id
  138. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5670'
      GROUP BY order_id
  139. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5670'
      GROUP BY order_id
  140. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5671'
      GROUP BY order_id
  141. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5671'
      GROUP BY order_id
  142. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5681'
      GROUP BY order_id
  143. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5681'
      GROUP BY order_id
  144. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5716'
      GROUP BY order_id
  145. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5716'
      GROUP BY order_id
  146. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5732'
      GROUP BY order_id
  147. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5732'
      GROUP BY order_id
  148. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5818'
      GROUP BY order_id
  149. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5818'
      GROUP BY order_id
  150. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5880'
      GROUP BY order_id
  151. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5880'
      GROUP BY order_id
  152. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5886'
      GROUP BY order_id
  153. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5886'
      GROUP BY order_id
  154. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5972'
      GROUP BY order_id
  155. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5972'
      GROUP BY order_id
  156. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5994'
      GROUP BY order_id
  157. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5994'
      GROUP BY order_id
  158. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5995'
      GROUP BY order_id
  159. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5995'
      GROUP BY order_id
  160. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5996'
      GROUP BY order_id
  161. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5996'
      GROUP BY order_id
  162. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6035'
      GROUP BY order_id
  163. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6035'
      GROUP BY order_id
  164. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6090'
      GROUP BY order_id
  165. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6090'
      GROUP BY order_id
  166. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6113'
      GROUP BY order_id
  167. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6113'
      GROUP BY order_id
  168. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6117'
      GROUP BY order_id
  169. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6117'
      GROUP BY order_id
  170. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6189'
      GROUP BY order_id
  171. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6189'
      GROUP BY order_id
  172. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6192'
      GROUP BY order_id
  173. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6192'
      GROUP BY order_id
  174. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6265'
      GROUP BY order_id
  175. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6265'
      GROUP BY order_id
  176. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6328'
      GROUP BY order_id
  177. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6328'
      GROUP BY order_id
  178. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6384'
      GROUP BY order_id
  179. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6384'
      GROUP BY order_id
  180. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6389'
      GROUP BY order_id
  181. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6389'
      GROUP BY order_id
  182. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6541'
      GROUP BY order_id
  183. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6541'
      GROUP BY order_id
  184. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6542'
      GROUP BY order_id
  185. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6542'
      GROUP BY order_id
  186. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6550'
      GROUP BY order_id
  187. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6550'
      GROUP BY order_id
  188. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6580'
      GROUP BY order_id
  189. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6580'
      GROUP BY order_id
  190. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6591'
      GROUP BY order_id
  191. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6591'
      GROUP BY order_id
  192. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6711'
      GROUP BY order_id
  193. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6711'
      GROUP BY order_id
  194. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6719'
      GROUP BY order_id
  195. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6719'
      GROUP BY order_id
  196. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6843'
      GROUP BY order_id
  197. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6843'
      GROUP BY order_id
  198. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6865'
      GROUP BY order_id
  199. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6865'
      GROUP BY order_id
  200. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7191'
      GROUP BY order_id
  201. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7191'
      GROUP BY order_id
  202. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7203'
      GROUP BY order_id
  203. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7203'
      GROUP BY order_id
  204. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7265'
      GROUP BY order_id
  205. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7265'
      GROUP BY order_id
  206. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7271'
      GROUP BY order_id
  207. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7271'
      GROUP BY order_id
  208. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7361'
      GROUP BY order_id
  209. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7361'
      GROUP BY order_id
  210. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7435'
      GROUP BY order_id
  211. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7435'
      GROUP BY order_id
  212. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7443'
      GROUP BY order_id
  213. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7443'
      GROUP BY order_id
  214. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7601'
      GROUP BY order_id
  215. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7601'
      GROUP BY order_id
  216. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7617'
      GROUP BY order_id
  217. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7617'
      GROUP BY order_id
  218. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7772'
      GROUP BY order_id
  219. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7772'
      GROUP BY order_id
  220. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7829'
      GROUP BY order_id
  221. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7829'
      GROUP BY order_id
  222. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7924'
      GROUP BY order_id
  223. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7924'
      GROUP BY order_id
  224. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8008'
      GROUP BY order_id
  225. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8008'
      GROUP BY order_id
  226. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8010'
      GROUP BY order_id
  227. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8010'
      GROUP BY order_id
  228. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8025'
      GROUP BY order_id
  229. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8025'
      GROUP BY order_id
  230. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8028'
      GROUP BY order_id
  231. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8028'
      GROUP BY order_id
  232. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8031'
      GROUP BY order_id
  233. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8031'
      GROUP BY order_id
  234. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8043'
      GROUP BY order_id
  235. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8043'
      GROUP BY order_id
  236. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8056'
      GROUP BY order_id
  237. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8056'
      GROUP BY order_id
  238. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8059'
      GROUP BY order_id
  239. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8059'
      GROUP BY order_id
  240. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8202'
      GROUP BY order_id
  241. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8202'
      GROUP BY order_id
  242. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8243'
      GROUP BY order_id
  243. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8243'
      GROUP BY order_id
  244. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8248'
      GROUP BY order_id
  245. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8248'
      GROUP BY order_id
  246. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8368'
      GROUP BY order_id
  247. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8368'
      GROUP BY order_id
  248. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8385'
      GROUP BY order_id
  249. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8385'
      GROUP BY order_id
  250. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8401'
      GROUP BY order_id
  251. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8401'
      GROUP BY order_id
  252. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9066'
      GROUP BY order_id
  253. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9066'
      GROUP BY order_id
  254. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9120'
      GROUP BY order_id
  255. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9120'
      GROUP BY order_id
  256. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9120'
      GROUP BY order_id
  257. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9120'
      GROUP BY order_id
  258. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9160'
      GROUP BY order_id
  259. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9160'
      GROUP BY order_id
  260. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9377'
      GROUP BY order_id
  261. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9377'
      GROUP BY order_id
  262. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9411'
      GROUP BY order_id
  263. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9411'
      GROUP BY order_id
  264. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9428'
      GROUP BY order_id
  265. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9428'
      GROUP BY order_id
  266. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9465'
      GROUP BY order_id
  267. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9465'
      GROUP BY order_id
  268. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9516'
      GROUP BY order_id
  269. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9516'
      GROUP BY order_id
  270. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9528'
      GROUP BY order_id
  271. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9528'
      GROUP BY order_id
  272. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9610'
      GROUP BY order_id
  273. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9610'
      GROUP BY order_id
  274. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9633'
      GROUP BY order_id
  275. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9633'
      GROUP BY order_id
  276. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9832'
      GROUP BY order_id
  277. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9832'
      GROUP BY order_id
  278. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9846'
      GROUP BY order_id
  279. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9846'
      GROUP BY order_id
  280. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9936'
      GROUP BY order_id
  281. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9936'
      GROUP BY order_id
  282. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10029'
      GROUP BY order_id
  283. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10029'
      GROUP BY order_id
  284. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10122'
      GROUP BY order_id
  285. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10122'
      GROUP BY order_id
  286. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10159'
      GROUP BY order_id
  287. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10159'
      GROUP BY order_id
  288. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10256'
      GROUP BY order_id
  289. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10256'
      GROUP BY order_id
  290. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10314'
      GROUP BY order_id
  291. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10314'
      GROUP BY order_id
  292. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10578'
      GROUP BY order_id
  293. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10578'
      GROUP BY order_id
  294. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10610'
      GROUP BY order_id
  295. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10610'
      GROUP BY order_id
  296. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10712'
      GROUP BY order_id
  297. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10712'
      GROUP BY order_id
  298. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10729'
      GROUP BY order_id
  299. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10729'
      GROUP BY order_id
  300. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10741'
      GROUP BY order_id
  301. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10741'
      GROUP BY order_id

301 legacy queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'gv6fvnr43t034cdu1cevtlqpc7'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1398290629' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'gv6fvnr43t034cdu1cevtlqpc7'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'gv6fvnr43t034cdu1cevtlqpc7','1398296029','','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 template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 2)
      ORDER BY menuid DESC
      LIMIT 0, 1
  12. SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access  
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = cc.SECTION
      AND s.scope = "content"
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE a.id = 1
      AND (  ( a.created_by = 0 )    OR  ( a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-04-23 23:33:49' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-04-23 23:33:49' )   )    OR  ( a.state = -1 )  )
  13. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='1'
  14. 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 = 2 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  15. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  16. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                   
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  17. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  18. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  19. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

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

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

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

      FROM jos_core_acl_aro_groups AS g1

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

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft
  22. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  23. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  24. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  25. SELECT `show_price_including_tax`
      FROM jos_vm_shopper_group
      WHERE `shopper_group_id` = '5'
  26. SELECT `show_price_including_tax`
      FROM jos_vm_shopper_group
      WHERE `shopper_group_id` = '5'
  27. 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
  28. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4321'
      GROUP BY order_id
  29. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4321'
      GROUP BY order_id
  30. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4330'
      GROUP BY order_id
  31. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4330'
      GROUP BY order_id
  32. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4354'
      GROUP BY order_id
  33. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4354'
      GROUP BY order_id
  34. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4396'
      GROUP BY order_id
  35. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4396'
      GROUP BY order_id
  36. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4423'
      GROUP BY order_id
  37. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4423'
      GROUP BY order_id
  38. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4436'
      GROUP BY order_id
  39. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4436'
      GROUP BY order_id
  40. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4446'
      GROUP BY order_id
  41. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4446'
      GROUP BY order_id
  42. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4500'
      GROUP BY order_id
  43. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4500'
      GROUP BY order_id
  44. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4519'
      GROUP BY order_id
  45. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4519'
      GROUP BY order_id
  46. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4561'
      GROUP BY order_id
  47. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4561'
      GROUP BY order_id
  48. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4585'
      GROUP BY order_id
  49. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4585'
      GROUP BY order_id
  50. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4590'
      GROUP BY order_id
  51. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4590'
      GROUP BY order_id
  52. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4677'
      GROUP BY order_id
  53. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4677'
      GROUP BY order_id
  54. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4691'
      GROUP BY order_id
  55. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4691'
      GROUP BY order_id
  56. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4711'
      GROUP BY order_id
  57. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4711'
      GROUP BY order_id
  58. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4713'
      GROUP BY order_id
  59. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4713'
      GROUP BY order_id
  60. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4721'
      GROUP BY order_id
  61. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4721'
      GROUP BY order_id
  62. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4722'
      GROUP BY order_id
  63. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4722'
      GROUP BY order_id
  64. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4743'
      GROUP BY order_id
  65. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4743'
      GROUP BY order_id
  66. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4814'
      GROUP BY order_id
  67. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4814'
      GROUP BY order_id
  68. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4909'
      GROUP BY order_id
  69. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4909'
      GROUP BY order_id
  70. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4932'
      GROUP BY order_id
  71. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4932'
      GROUP BY order_id
  72. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4933'
      GROUP BY order_id
  73. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4933'
      GROUP BY order_id
  74. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4944'
      GROUP BY order_id
  75. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4944'
      GROUP BY order_id
  76. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4947'
      GROUP BY order_id
  77. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='4947'
      GROUP BY order_id
  78. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5016'
      GROUP BY order_id
  79. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5016'
      GROUP BY order_id
  80. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5052'
      GROUP BY order_id
  81. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5052'
      GROUP BY order_id
  82. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5106'
      GROUP BY order_id
  83. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5106'
      GROUP BY order_id
  84. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5170'
      GROUP BY order_id
  85. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5170'
      GROUP BY order_id
  86. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5293'
      GROUP BY order_id
  87. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5293'
      GROUP BY order_id
  88. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5294'
      GROUP BY order_id
  89. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5294'
      GROUP BY order_id
  90. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5309'
      GROUP BY order_id
  91. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5309'
      GROUP BY order_id
  92. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5321'
      GROUP BY order_id
  93. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5321'
      GROUP BY order_id
  94. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5334'
      GROUP BY order_id
  95. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5334'
      GROUP BY order_id
  96. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5335'
      GROUP BY order_id
  97. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5335'
      GROUP BY order_id
  98. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5339'
      GROUP BY order_id
  99. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5339'
      GROUP BY order_id
  100. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5341'
      GROUP BY order_id
  101. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5341'
      GROUP BY order_id
  102. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5346'
      GROUP BY order_id
  103. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5346'
      GROUP BY order_id
  104. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5350'
      GROUP BY order_id
  105. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5350'
      GROUP BY order_id
  106. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5366'
      GROUP BY order_id
  107. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5366'
      GROUP BY order_id
  108. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5421'
      GROUP BY order_id
  109. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5421'
      GROUP BY order_id
  110. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5453'
      GROUP BY order_id
  111. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5453'
      GROUP BY order_id
  112. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5471'
      GROUP BY order_id
  113. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5471'
      GROUP BY order_id
  114. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5472'
      GROUP BY order_id
  115. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5472'
      GROUP BY order_id
  116. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5474'
      GROUP BY order_id
  117. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5474'
      GROUP BY order_id
  118. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5484'
      GROUP BY order_id
  119. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5484'
      GROUP BY order_id
  120. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5526'
      GROUP BY order_id
  121. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5526'
      GROUP BY order_id
  122. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5550'
      GROUP BY order_id
  123. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5550'
      GROUP BY order_id
  124. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5551'
      GROUP BY order_id
  125. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5551'
      GROUP BY order_id
  126. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5580'
      GROUP BY order_id
  127. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5580'
      GROUP BY order_id
  128. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5582'
      GROUP BY order_id
  129. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5582'
      GROUP BY order_id
  130. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5588'
      GROUP BY order_id
  131. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5588'
      GROUP BY order_id
  132. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5630'
      GROUP BY order_id
  133. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5630'
      GROUP BY order_id
  134. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5635'
      GROUP BY order_id
  135. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5635'
      GROUP BY order_id
  136. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5665'
      GROUP BY order_id
  137. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5665'
      GROUP BY order_id
  138. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5670'
      GROUP BY order_id
  139. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5670'
      GROUP BY order_id
  140. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5671'
      GROUP BY order_id
  141. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5671'
      GROUP BY order_id
  142. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5681'
      GROUP BY order_id
  143. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5681'
      GROUP BY order_id
  144. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5716'
      GROUP BY order_id
  145. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5716'
      GROUP BY order_id
  146. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5732'
      GROUP BY order_id
  147. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5732'
      GROUP BY order_id
  148. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5818'
      GROUP BY order_id
  149. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5818'
      GROUP BY order_id
  150. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5880'
      GROUP BY order_id
  151. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5880'
      GROUP BY order_id
  152. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5886'
      GROUP BY order_id
  153. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5886'
      GROUP BY order_id
  154. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5972'
      GROUP BY order_id
  155. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5972'
      GROUP BY order_id
  156. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5994'
      GROUP BY order_id
  157. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5994'
      GROUP BY order_id
  158. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5995'
      GROUP BY order_id
  159. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5995'
      GROUP BY order_id
  160. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5996'
      GROUP BY order_id
  161. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='5996'
      GROUP BY order_id
  162. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6035'
      GROUP BY order_id
  163. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6035'
      GROUP BY order_id
  164. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6090'
      GROUP BY order_id
  165. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6090'
      GROUP BY order_id
  166. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6113'
      GROUP BY order_id
  167. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6113'
      GROUP BY order_id
  168. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6117'
      GROUP BY order_id
  169. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6117'
      GROUP BY order_id
  170. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6189'
      GROUP BY order_id
  171. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6189'
      GROUP BY order_id
  172. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6192'
      GROUP BY order_id
  173. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6192'
      GROUP BY order_id
  174. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6265'
      GROUP BY order_id
  175. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6265'
      GROUP BY order_id
  176. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6328'
      GROUP BY order_id
  177. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6328'
      GROUP BY order_id
  178. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6384'
      GROUP BY order_id
  179. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6384'
      GROUP BY order_id
  180. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6389'
      GROUP BY order_id
  181. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6389'
      GROUP BY order_id
  182. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6541'
      GROUP BY order_id
  183. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6541'
      GROUP BY order_id
  184. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6542'
      GROUP BY order_id
  185. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6542'
      GROUP BY order_id
  186. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6550'
      GROUP BY order_id
  187. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6550'
      GROUP BY order_id
  188. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6580'
      GROUP BY order_id
  189. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6580'
      GROUP BY order_id
  190. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6591'
      GROUP BY order_id
  191. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6591'
      GROUP BY order_id
  192. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6711'
      GROUP BY order_id
  193. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6711'
      GROUP BY order_id
  194. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6719'
      GROUP BY order_id
  195. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6719'
      GROUP BY order_id
  196. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6843'
      GROUP BY order_id
  197. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6843'
      GROUP BY order_id
  198. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6865'
      GROUP BY order_id
  199. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='6865'
      GROUP BY order_id
  200. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7191'
      GROUP BY order_id
  201. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7191'
      GROUP BY order_id
  202. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7203'
      GROUP BY order_id
  203. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7203'
      GROUP BY order_id
  204. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7265'
      GROUP BY order_id
  205. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7265'
      GROUP BY order_id
  206. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7271'
      GROUP BY order_id
  207. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7271'
      GROUP BY order_id
  208. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7361'
      GROUP BY order_id
  209. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7361'
      GROUP BY order_id
  210. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7435'
      GROUP BY order_id
  211. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7435'
      GROUP BY order_id
  212. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7443'
      GROUP BY order_id
  213. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7443'
      GROUP BY order_id
  214. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7601'
      GROUP BY order_id
  215. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7601'
      GROUP BY order_id
  216. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7617'
      GROUP BY order_id
  217. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7617'
      GROUP BY order_id
  218. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7772'
      GROUP BY order_id
  219. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7772'
      GROUP BY order_id
  220. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7829'
      GROUP BY order_id
  221. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7829'
      GROUP BY order_id
  222. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7924'
      GROUP BY order_id
  223. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='7924'
      GROUP BY order_id
  224. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8008'
      GROUP BY order_id
  225. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8008'
      GROUP BY order_id
  226. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8010'
      GROUP BY order_id
  227. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8010'
      GROUP BY order_id
  228. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8025'
      GROUP BY order_id
  229. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8025'
      GROUP BY order_id
  230. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8028'
      GROUP BY order_id
  231. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8028'
      GROUP BY order_id
  232. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8031'
      GROUP BY order_id
  233. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8031'
      GROUP BY order_id
  234. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8043'
      GROUP BY order_id
  235. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8043'
      GROUP BY order_id
  236. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8056'
      GROUP BY order_id
  237. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8056'
      GROUP BY order_id
  238. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8059'
      GROUP BY order_id
  239. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8059'
      GROUP BY order_id
  240. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8202'
      GROUP BY order_id
  241. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8202'
      GROUP BY order_id
  242. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8243'
      GROUP BY order_id
  243. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8243'
      GROUP BY order_id
  244. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8248'
      GROUP BY order_id
  245. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8248'
      GROUP BY order_id
  246. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8368'
      GROUP BY order_id
  247. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8368'
      GROUP BY order_id
  248. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8385'
      GROUP BY order_id
  249. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8385'
      GROUP BY order_id
  250. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8401'
      GROUP BY order_id
  251. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='8401'
      GROUP BY order_id
  252. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9066'
      GROUP BY order_id
  253. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9066'
      GROUP BY order_id
  254. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9120'
      GROUP BY order_id
  255. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9120'
      GROUP BY order_id
  256. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9120'
      GROUP BY order_id
  257. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9120'
      GROUP BY order_id
  258. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9160'
      GROUP BY order_id
  259. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9160'
      GROUP BY order_id
  260. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9377'
      GROUP BY order_id
  261. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9377'
      GROUP BY order_id
  262. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9411'
      GROUP BY order_id
  263. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9411'
      GROUP BY order_id
  264. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9428'
      GROUP BY order_id
  265. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9428'
      GROUP BY order_id
  266. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9465'
      GROUP BY order_id
  267. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9465'
      GROUP BY order_id
  268. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9516'
      GROUP BY order_id
  269. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9516'
      GROUP BY order_id
  270. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9528'
      GROUP BY order_id
  271. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9528'
      GROUP BY order_id
  272. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9610'
      GROUP BY order_id
  273. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9610'
      GROUP BY order_id
  274. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9633'
      GROUP BY order_id
  275. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9633'
      GROUP BY order_id
  276. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9832'
      GROUP BY order_id
  277. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9832'
      GROUP BY order_id
  278. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9846'
      GROUP BY order_id
  279. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9846'
      GROUP BY order_id
  280. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9936'
      GROUP BY order_id
  281. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='9936'
      GROUP BY order_id
  282. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10029'
      GROUP BY order_id
  283. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10029'
      GROUP BY order_id
  284. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10122'
      GROUP BY order_id
  285. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10122'
      GROUP BY order_id
  286. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10159'
      GROUP BY order_id
  287. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10159'
      GROUP BY order_id
  288. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10256'
      GROUP BY order_id
  289. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10256'
      GROUP BY order_id
  290. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10314'
      GROUP BY order_id
  291. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10314'
      GROUP BY order_id
  292. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10578'
      GROUP BY order_id
  293. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10578'
      GROUP BY order_id
  294. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10610'
      GROUP BY order_id
  295. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10610'
      GROUP BY order_id
  296. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10712'
      GROUP BY order_id
  297. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10712'
      GROUP BY order_id
  298. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10729'
      GROUP BY order_id
  299. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10729'
      GROUP BY order_id
  300. SELECT SUM(product_quantity)
      FROM jos_vm_order_item
      WHERE order_id='10741'
      GROUP BY order_id
  301. 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