Profile Information

Memory Usage

Queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'o53oqi2odk4te9o1lv1rhnll95'
2. DELETE
     FROM jos_session
     WHERE ( time < '1283996871' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'o53oqi2odk4te9o1lv1rhnll95'
4. UPDATE `jos_session`
     SET `time`='1284002271',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1284002270;s:18:\"session.timer.last\";i:1284002270;s:17:\"session.timer.now\";i:1284002271;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:63:\"/home/abstraktron/dev/1/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:17:\"application.queue\";a:2:{i:0;a:2:{s:7:\"message\";N;s:4:\"type\";s:7:\"message\";}i:1;a:2:{s:7:\"message\";N;s:4:\"type\";s:7:\"message\";}}}userstate|a:0:{}VMCHECK|s:2:\"OK\";'
     WHERE session_id='o53oqi2odk4te9o1lv1rhnll95'
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 `id`,`link`
     FROM jos_menu 
     WHERE ((`name` LIKE '%vmchk%')
     AND (`published` > 0))
8. SELECT oldurl, newurl
     FROM jos_redirection
     WHERE oldurl = 'vmchk/view-all-products-in-shop.html'
     ORDER BY rank ASC
     LIMIT 1
9. UPDATE jos_redirection
     SET cpt=(cpt+1)
     WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.browse&vmcchk=1'
     AND `oldurl` = 'vmchk/view-all-products-in-shop.html'
10. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 147)
      ORDER BY menuid DESC
      LIMIT 0, 1
11. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
12. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
               
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
13. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
14. SELECT 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`);
15. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
16. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
17. SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) AS num_rows
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
18. SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`jos_vm_category`.`category_id`,
                                    `jos_vm_product`.`product_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`,
                                    `product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_sku` ASC
      LIMIT 0, 100
19. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=16
20. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='16'
      AND (start_date<='1284002280' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
21. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16
22. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002280' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
23. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='16'
24. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
25. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=16
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
26. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=16
      AND `file_published`=1
27. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=16
28. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=16
29. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6
30. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6'
      AND (start_date<='1284002282' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
31. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6
32. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002282' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
33. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6'
34. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
35. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=6
      AND `file_published`=1
36. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=6
37. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=6
38. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5
39. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5'
      AND (start_date<='1284002282' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
40. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5
41. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002282' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
42. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5'
43. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
44. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5
      AND `file_published`=1
45. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5
46. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5
47. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=10
48. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='10'
      AND (start_date<='1284002282' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
49. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=10
50. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002282' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
51. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='10'
52. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=10
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
53. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=10
      AND `file_published`=1
54. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=10
55. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=10
56. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=29
57. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='29'
      AND (start_date<='1284002282' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
58. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=29
59. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002282' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
60. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='29'
61. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=29
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
62. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=29
      AND `file_published`=1
63. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=29
64. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=29
65. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=38
66. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='38'
      AND (start_date<='1284002282' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
67. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=38
68. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002282' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
69. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='38'
70. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=38
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
71. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=38
      AND `file_published`=1
72. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=38
73. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=38
74. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=23
75. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='23'
      AND (start_date<='1284002282' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
76. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=23
77. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002282' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
78. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='23'
79. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=23
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
80. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=23
      AND `file_published`=1
81. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=23
82. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=23
83. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=39
84. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='39'
      AND (start_date<='1284002282' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
85. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=39
86. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002282' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
87. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='39'
88. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=39
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
89. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=39
      AND `file_published`=1
90. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=39
91. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=39
92. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=34
93. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='34'
      AND (start_date<='1284002283' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
94. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=34
95. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002283' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
96. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='34'
97. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=34
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
98. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=34
      AND `file_published`=1
99. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=34
100. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=34
101. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=7
102. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='7'
       AND (start_date<='1284002283' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
103. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=7
104. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002283' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
105. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='7'
106. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=7
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
107. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=7
       AND `file_published`=1
108. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=7
109. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=7
110. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=12
111. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='12'
       AND (start_date<='1284002283' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
112. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=12
113. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002283' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
114. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='12'
115. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=12
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
116. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=12
       AND `file_published`=1
117. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=12
118. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=12
119. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=44
120. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='44'
       AND (start_date<='1284002283' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
121. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=44
122. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002283' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
123. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='44'
124. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=44
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
125. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=44
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
126. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=44
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
127. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=44
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
128. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=44
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
129. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=44
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
130. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=44
       AND `file_published`=1
131. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=8
132. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='8'
       AND (start_date<='1284002283' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
133. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=8
134. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002283' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
135. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='8'
136. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=8
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
137. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=8
       AND `file_published`=1
138. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=8
139. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=8
140. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=40
141. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='40'
       AND (start_date<='1284002283' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
142. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=40
143. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002283' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
144. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='40'
145. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=40
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
146. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=40
       AND `file_published`=1
147. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=40
148. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=40
149. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=13
150. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='13'
       AND (start_date<='1284002284' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
151. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=13
152. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002284' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
153. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='13'
154. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=13
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
155. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=13
       AND `file_published`=1
156. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=13
157. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=13
158. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=24
159. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='24'
       AND (start_date<='1284002284' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
160. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=24
161. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002284' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
162. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='24'
163. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=24
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
164. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=24
       AND `file_published`=1
165. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=24
166. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=24
167. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=18
168. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='18'
       AND (start_date<='1284002284' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
169. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=18
170. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002284' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
171. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='18'
172. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=18
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
173. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=18
       AND `file_published`=1
174. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=18
175. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=18
176. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=15
177. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='15'
       AND (start_date<='1284002284' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
178. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=15
179. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002284' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
180. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='15'
181. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=15
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
182. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=15
       AND `file_published`=1
183. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=15
184. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=15
185. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=14
186. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='14'
       AND (start_date<='1284002284' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
187. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=14
188. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002284' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
189. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='14'
190. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=14
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
191. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=14
       AND `file_published`=1
192. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=14
193. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=14
194. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=17
195. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='17'
       AND (start_date<='1284002284' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
196. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=17
197. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002284' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
198. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='17'
199. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=17
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
200. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=17
       AND `file_published`=1
201. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=17
202. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=17
203. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=19
204. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='19'
       AND (start_date<='1284002284' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
205. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=19
206. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002284' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
207. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='19'
208. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=19
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
209. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=19
       AND `file_published`=1
210. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=19
211. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=19
212. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=21
213. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='21'
       AND (start_date<='1284002285' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
214. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=21
215. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002285' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
216. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='21'
217. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=21
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
218. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=21
       AND `file_published`=1
219. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=21
220. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=21
221. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=20
222. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='20'
       AND (start_date<='1284002285' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
223. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=20
224. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002285' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
225. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='20'
226. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=20
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
227. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=20
       AND `file_published`=1
228. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=20
229. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=20
230. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=22
231. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='22'
       AND (start_date<='1284002285' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
232. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=22
233. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002285' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
234. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='22'
235. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=22
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
236. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=22
       AND `file_published`=1
237. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=22
238. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=22
239. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=36
240. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='36'
       AND (start_date<='1284002285' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
241. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=36
242. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002285' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
243. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='36'
244. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=36
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
245. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=36
       AND `file_published`=1
246. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=36
247. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=36
248. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=42
249. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='42'
       AND (start_date<='1284002286' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
250. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=42
251. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002286' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
252. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='42'
253. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=42
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
254. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=42
       AND `file_published`=1
255. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=42
256. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=42
257. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=30
258. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='30'
       AND (start_date<='1284002286' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
259. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=30
260. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002286' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
261. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='30'
262. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=30
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
263. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=30
       AND `file_published`=1
264. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=30
265. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=30
266. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=31
267. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='31'
       AND (start_date<='1284002286' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
268. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=31
269. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002286' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
270. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='31'
271. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=31
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
272. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=31
       AND `file_published`=1
273. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=31
274. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=31
275. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=32
276. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='32'
       AND (start_date<='1284002286' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
277. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=32
278. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002286' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
279. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='32'
280. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=32
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
281. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=32
       AND `file_published`=1
282. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=32
283. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=32
284. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=4
285. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='4'
       AND (start_date<='1284002286' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
286. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=4
287. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002286' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
288. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='4'
289. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=4
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
290. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=4
       AND `file_published`=1
291. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=4
292. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=4
293. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=2
294. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='2'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
295. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=2
296. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
297. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='2'
298. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=2
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
299. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=2
       AND `file_published`=1
300. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=2
301. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=2
302. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=3
303. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='3'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
304. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=3
305. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
306. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='3'
307. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=3
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
308. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=3
       AND `file_published`=1
309. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=3
310. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=3
311. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=41
312. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='41'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
313. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=41
314. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
315. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='41'
316. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=41
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
317. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=41
       AND `file_published`=1
318. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=41
319. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=41
320. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=27
321. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='27'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
322. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=27
323. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
324. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='27'
325. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=27
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
326. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=27
       AND `file_published`=1
327. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=27
328. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=27
329. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=11
330. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='11'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
331. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=11
332. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
333. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='11'
334. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=11
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
335. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=11
       AND `file_published`=1
336. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=11
337. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=11
338. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=35
339. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='35'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
340. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=35
341. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
342. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='35'
343. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=35
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
344. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=35
       AND `file_published`=1
345. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=35
346. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=35
347. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=37
348. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='37'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
349. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=37
350. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
351. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='37'
352. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=37
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
353. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=37
       AND `file_published`=1
354. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=37
355. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=37
356. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=25
357. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='25'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
358. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=25
359. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
360. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='25'
361. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=25
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
362. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=25
       AND `file_published`=1
363. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=25
364. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=25
365. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=26
366. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='26'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
367. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=26
368. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
369. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='26'
370. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=26
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
371. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=26
       AND `file_published`=1
372. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=26
373. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=26
374. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=28
375. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='28'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
376. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=28
377. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
378. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='28'
379. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=28
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
380. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=28
       AND `file_published`=1
381. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=28
382. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=28
383. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=43
384. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='43'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
385. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=43
386. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
387. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='43'
388. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=43
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
389. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=43
       AND `file_published`=1
390. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=43
391. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=43
392. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=33
393. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='33'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
394. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='33'
395. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=33
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
396. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=33
       AND `file_published`=1
397. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=33
398. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=33
399. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=9
400. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='9'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
401. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=9
402. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1284002287' OR start_date=0)
       AND (end_date>='1283927760' OR end_date=0)
       AND product_discount_id=discount_id
403. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='9'
404. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=9
       AND shopper_group_id=5   
       ORDER BY price_quantity_start
405. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=9
       AND `file_published`=1
406. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=9
407. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=9
408. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=&lang=en&limit=5&limitstart=0&page=shop.browse'
409. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=&lang=en&limit=10&limitstart=0&page=shop.browse'
410. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=&lang=en&limit=15&limitstart=0&page=shop.browse'
411. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=&lang=en&limit=20&limitstart=0&page=shop.browse'
412. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=&lang=en&limit=25&limitstart=0&page=shop.browse'
413. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=&lang=en&limit=30&limitstart=0&page=shop.browse'
414. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=&lang=en&limit=50&limitstart=0&page=shop.browse'
415. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=&lang=en&limit=100&limitstart=0&page=shop.browse'
416. SELECT DISTINCT product_sku,product_id,product_name,product_s_desc,product_thumb_image, product_full_image, product_in_stock, product_url
       FROM jos_vm_product
       WHERE (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')
       AND vendor_id='1'
       AND jos_vm_product.product_publish='Y'
       AND jos_vm_product.product_special='Y'
       ORDER BY RAND()
       LIMIT 0, 10
417. SELECT
                                     `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                     `jos_vm_category`.`category_flypage`
                            
       FROM
                                     `jos_vm_product`
     
                            
       LEFT JOIN `jos_vm_product_category_xref`
       ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                            
       LEFT JOIN `jos_vm_category`
       ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
     
                            
       WHERE `jos_vm_product`.`product_id`='33'
418. 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 = 147 OR mm.menuid = 0 )
       ORDER BY position, ordering
419. SELECT guest, usertype, client_id
       FROM jos_session
       WHERE client_id = 0
420. SELECT category_name, category_id, category_child_id
       FROM jos_vm_category AS a, jos_vm_category_xref AS b
       WHERE a.category_publish='Y'
       AND  b.category_parent_id='0'
       AND a.category_id=b.category_child_id
       ORDER BY category_parent_id, list_order, category_name ASC
421. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&TreeId=1&category_id=1&lang=en&page=shop.browse'
422. SELECT name, link,id
       FROM jos_menu
       WHERE published='1'
       AND link LIKE 'index.php?option=com_virtuemart%'
423. SELECT c.category_name, c.category_id, x.category_parent_id
       FROM jos_vm_category AS c
      
       LEFT JOIN jos_vm_category_xref AS x
       ON c.category_id = x.category_child_id;
424. SELECT oldurl
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&lang=en&page=shop.browse'
425. SELECT category_name, category_id, category_child_id
       FROM jos_vm_category AS a, jos_vm_category_xref AS b
       WHERE a.category_publish='Y'
       AND  b.category_parent_id='1'
       AND a.category_id=b.category_child_id
       ORDER BY category_parent_id, list_order, category_name ASC
426. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&TreeId=1&category_id=3&lang=en&page=shop.browse'
427. SELECT name, link,id
       FROM jos_menu
       WHERE published='1'
       AND link LIKE 'index.php?option=com_virtuemart%'
428. SELECT oldurl
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&lang=en&page=shop.browse'
429. SELECT category_name, category_id, category_child_id
       FROM jos_vm_category AS a, jos_vm_category_xref AS b
       WHERE a.category_publish='Y'
       AND  b.category_parent_id='3'
       AND a.category_id=b.category_child_id
       ORDER BY category_parent_id, list_order, category_name ASC
430. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&TreeId=2&category_id=5&lang=en&page=shop.browse'
431. SELECT name, link,id
       FROM jos_menu
       WHERE published='1'
       AND link LIKE 'index.php?option=com_virtuemart%'
432. SELECT oldurl
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&lang=en&page=shop.browse'
433. SELECT category_name, category_id, category_child_id
       FROM jos_vm_category AS a, jos_vm_category_xref AS b
       WHERE a.category_publish='Y'
       AND  b.category_parent_id='5'
       AND a.category_id=b.category_child_id
       ORDER BY category_parent_id, list_order, category_name ASC
434. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&TreeId=3&category_id=4&lang=en&page=shop.browse'
435. SELECT name, link,id
       FROM jos_menu
       WHERE published='1'
       AND link LIKE 'index.php?option=com_virtuemart%'
436. SELECT oldurl
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=4&lang=en&page=shop.browse'
437. SELECT category_name, category_id, category_child_id
       FROM jos_vm_category AS a, jos_vm_category_xref AS b
       WHERE a.category_publish='Y'
       AND  b.category_parent_id='4'
       AND a.category_id=b.category_child_id
       ORDER BY category_parent_id, list_order, category_name ASC
438. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&TreeId=4&category_id=6&lang=en&page=shop.browse'
439. SELECT name, link,id
       FROM jos_menu
       WHERE published='1'
       AND link LIKE 'index.php?option=com_virtuemart%'
440. SELECT oldurl
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&lang=en&page=shop.browse'
441. SELECT category_name, category_id, category_child_id
       FROM jos_vm_category AS a, jos_vm_category_xref AS b
       WHERE a.category_publish='Y'
       AND  b.category_parent_id='6'
       AND a.category_id=b.category_child_id
       ORDER BY category_parent_id, list_order, category_name ASC
442. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&TreeId=5&category_id=7&lang=en&page=shop.browse'
443. SELECT name, link,id
       FROM jos_menu
       WHERE published='1'
       AND link LIKE 'index.php?option=com_virtuemart%'
444. SELECT oldurl
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&lang=en&page=shop.browse'
445. SELECT category_name, category_id, category_child_id
       FROM jos_vm_category AS a, jos_vm_category_xref AS b
       WHERE a.category_publish='Y'
       AND  b.category_parent_id='7'
       AND a.category_id=b.category_child_id
       ORDER BY category_parent_id, list_order, category_name ASC
446. SELECT category_id, category_description, category_name,category_child_id AS cid, category_parent_id AS pid,list_order, category_publish
                                                    
       FROM jos_vm_category, jos_vm_category_xref
       WHERE jos_vm_category.category_publish='Y'
       AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
       ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
447. SELECT group_id,group_name,group_level
       FROM `jos_vm_auth_group`
       ORDER BY group_level
448. SELECT published
       FROM jos_modules
       WHERE module='mod_virtuemart_cart'
449. SELECT user_info_id
       FROM `jos_vm_user_info`
       WHERE user_id='0'
       AND address_type='BT'
450. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_user&lang=en&view=reset'
451. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_user&lang=en&view=remind'
452. SELECT currency_id, currency_code, currency_name
       FROM `jos_vm_currency`
       WHERE FIND_IN_SET(`currency_code`, 'AUD,GBP,COP,KMF,JPY,NZD,USD,')
       ORDER BY `currency_name`
453. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&lang=en&page=shop.browse'
454. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&lang=en&page=shop.browse'
455. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&lang=en&page=shop.browse'
456. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=4&lang=en&page=shop.browse'
457. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&lang=en&page=shop.browse'
458. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&lang=en&page=shop.browse'
459. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category=&lang=en&page=shop.browse'
460. SELECT name, link,id
       FROM jos_menu
       WHERE published='1'
       AND link LIKE 'index.php?option=com_virtuemart%'
461. SELECT oldurl
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.browse'
462. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.search'
463. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.downloads'
464. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.cart'
465. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.registration'
466. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=16'
467. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=16'
468. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=6'
469. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=6'
470. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=5'
471. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=5'
472. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=10'
473. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=10'
474. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=29'
475. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=29'
476. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=38'
477. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=38'
478. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=23'
479. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=23'
480. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=39'
481. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=39'
482. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=34'
483. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=34'
484. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=7'
485. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=7'
486. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=12'
487. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=12'
488. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=44'
489. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.ask&product_id=44&subject=Call for Pricing: DMSO 1000ml'
490. SELECT name, link,id
       FROM jos_menu
       WHERE published='1'
       AND link LIKE 'index.php?option=com_virtuemart%'
491. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=44'
492. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=44'
493. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=8'
494. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=8'
495. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=40'
496. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=40'
497. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=13'
498. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=13'
499. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=24'
500. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=24'
501. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=18'
502. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=18'
503. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=15'
504. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=15'
505. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=14'
506. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=14'
507. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=17'
508. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=17'
509. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=19'
510. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=19'
511. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=21'
512. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=21'
513. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=20'
514. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=20'
515. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=22'
516. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=22'
517. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=36'
518. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=36'
519. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=42'
520. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=42'
521. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=30'
522. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=30'
523. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=31'
524. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=31'
525. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=32'
526. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=32'
527. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=4'
528. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=4'
529. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=2'
530. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=2'
531. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=3'
532. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=3'
533. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=41'
534. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=41'
535. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=27'
536. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=27'
537. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=11'
538. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=11'
539. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=35'
540. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=35'
541. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=37'
542. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=37'
543. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=25'
544. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=25'
545. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=26'
546. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=26'
547. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=28'
548. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=28'
549. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=43'
550. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=43'
551. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=33'
552. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=33'
553. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&flypage=garden_flypage.tpl&lang=en&page=shop.product_details&product_id=33'
554. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=9'
555. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=9'
556. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=33'
557. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=33'
558. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_content&Itemid=44&id=25&lang=en&view=article'
559. SELECT oldurl, dateadd
       FROM jos_redirection
       WHERE newurl = 'index.php?option=com_content&Itemid=52&id=65&lang=en&view=article'