Skip to Store Area:

https://www.myorlandosentinel.com/components/com_gk2_photoslide/images/thumbm/171477Slide_Orl_Sen_2014_04_17.jpg https://www.myorlandosentinel.com/components/com_gk2_photoslide/images/thumbm/12054401.jpg https://www.myorlandosentinel.com/components/com_gk2_photoslide/images/thumbm/91081802.jpg

ORLANDO SENTINEL DEALS ARE LISTED BELOW:

 

Thursday - Sunday Delivery
$24.29
Add to Cart
4-Day Home Delivery for as low as $1.81 a week!
13 Weeks, 26 Weeks, & 52 Weeks Available!

Order up to 4 subscription per address!

Learn More
7-Days A Week Delivery
$38.88
Add to Cart
7-Day Home Delivery for as low as $2.90 a week!
Save up to 70% OFF the Newsstand Price.
Subscribe Now and Lock this LOW Rate in Today! Learn More


Thursday & Sunday Delivery
$15.49
Add to Cart
Home Delivery full of coupons.
Pick up 4 subscriptions today!

Learn More
 

Profile Information

Application afterLoad: 0.000 seconds, 0.73 MB
Application afterInitialise: 0.013 seconds, 2.15 MB
Application afterRoute: 0.015 seconds, 2.40 MB
Application afterDispatch: 0.029 seconds, 3.68 MB
Application afterRender: 0.045 seconds, 5.53 MB

Memory Usage

5952680

303 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = '1v1mjctq6t07rna38fvfsq1694'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1398294497' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '1v1mjctq6t07rna38fvfsq1694'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '1v1mjctq6t07rna38fvfsq1694','1398299897','','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 = 1)
      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 = 5
      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-24 00:38:17' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-04-24 00:38:17' )   )    OR  ( a.state = -1 )  )
  13. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='5'
  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 = 1 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  15. SELECT
                            *
                   
      FROM
                            jos_gk2_photoslide_groups
                   
      WHERE
                            `id` = 1
                   
      LIMIT 1;
  16. SELECT
                            `c`.`sectionid` AS `sid`,
                            `i`.`file` AS `file`,
                            `i`.`title` AS `title`,
                            `i`.`text` AS `text`,
                            `i`.`linktype` AS `linktype`,
                            `i`.`linkvalue` AS `linkvalue`,
                            `i`.`article` AS `article`,
                            `i`.`wordcount` AS `wordcount`,
                            `c`.`title` AS `ctitle`,
                            `c`.`introtext` AS `introtext`,
                            `c`.`catid` AS `cid`
                   
      FROM
                            jos_gk2_photoslide_slides AS `i`
                   
      LEFT JOIN
                            jos_content AS `c`
                           
      ON
                            `i`.`article` = `c`.`id`
                   
      WHERE
                            `i`.`group_id` = 1
                           
      AND
                            `i`.`published` = 1
                           
      AND
                            `i`.`access` <= 0
                   
      ORDER BY
                            `i`.`order`,
                            `i`.`access` ASC;
  17. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  18. 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'
  19. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  20. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  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 3
      AND 12

      GROUP BY g1.name

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

303 legacy queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = '1v1mjctq6t07rna38fvfsq1694'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1398294497' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '1v1mjctq6t07rna38fvfsq1694'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '1v1mjctq6t07rna38fvfsq1694','1398299897','','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 = 1)
      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 = 5
      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-24 00:38:17' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-04-24 00:38:17' )   )    OR  ( a.state = -1 )  )
  13. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='5'
  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 = 1 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  15. SELECT
                            *
                   
      FROM
                            jos_gk2_photoslide_groups
                   
      WHERE
                            `id` = 1
                   
      LIMIT 1;
  16. SELECT
                            `c`.`sectionid` AS `sid`,
                            `i`.`file` AS `file`,
                            `i`.`title` AS `title`,
                            `i`.`text` AS `text`,
                            `i`.`linktype` AS `linktype`,
                            `i`.`linkvalue` AS `linkvalue`,
                            `i`.`article` AS `article`,
                            `i`.`wordcount` AS `wordcount`,
                            `c`.`title` AS `ctitle`,
                            `c`.`introtext` AS `introtext`,
                            `c`.`catid` AS `cid`
                   
      FROM
                            jos_gk2_photoslide_slides AS `i`
                   
      LEFT JOIN
                            jos_content AS `c`
                           
      ON
                            `i`.`article` = `c`.`id`
                   
      WHERE
                            `i`.`group_id` = 1
                           
      AND
                            `i`.`published` = 1
                           
      AND
                            `i`.`access` <= 0
                   
      ORDER BY
                            `i`.`order`,
                            `i`.`access` ASC;
  17. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  18. 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'
  19. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  20. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  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 3
      AND 12

      GROUP BY g1.name

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