Texture Style 2 Wallpapers

Product Details

  • Type: Sidewall
  • Collection: Texture Style 2
  • Features: paste the wall
  • Roll Dimensions (D/Roll): 33ft x 21in (10m x 53cm)

Wallcoverings are packaged and sold in double rolls only

  • paste the wall
  • dry strippable
  • extra washable
  • good lightfastness

Profile Information

Application afterLoad: 0.000 seconds, 0.29 MB
Application afterInitialise: 0.005 seconds, 0.96 MB
Application afterRoute: 0.012 seconds, 2.52 MB
Application afterDispatch: 10.663 seconds, 4.89 MB
Application afterRender: 10.674 seconds, 5.19 MB

Memory Usage

5469040

3703 queries logged

  1. DELETE
      FROM jos_session
      WHERE ( time < '1739780399' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = 'qclq74op3vih6lh5c7dufq4516'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'qclq74op3vih6lh5c7dufq4516','1739787599','','0','1','0' )
  4. SELECT *
      FROM jos_components
      WHERE parent = 0
  5. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  6. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  7. SELECT *
      FROM jos_redshop_configuration
  8. SELECT *
      FROM jos_redshop_catalog_request
      WHERE block = 0
  9. SELECT *
      FROM jos_redshop_sample_request
      WHERE block = 0
  10. SELECT count(id)
      FROM jos_redshop_cron
      WHERE date = '2025-02-17'
  11. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'qclq74op3vih6lh5c7dufq4516'
  12. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('qclq74op3vih6lh5c7dufq4516', '0','1739787603')
  13. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'qclq74op3vih6lh5c7dufq4516'
      AND section='category'
      AND section_id=''
  14. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('qclq74op3vih6lh5c7dufq4516','0','category','','1739787609')
  15. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
  16. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 324)
      ORDER BY menuid DESC
      LIMIT 0, 1
  17. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_category AS c
      LEFT JOIN jos_redshop_product_category_xref AS pc
      ON pc.category_id=c.category_id
      WHERE p.product_id = pc.product_id
      AND pc.category_id=262
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY c.ordering ASC
  18. SELECT *
      FROM jos_redshop_category
      WHERE category_id = 262
  19. SELECT *
      FROM jos_redshop_category AS c, jos_redshop_template AS t
      WHERE t.template_id = c.category_template
      AND t.template_section='category'
      AND c.category_id=262
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
  20. SELECT *
      FROM  jos_redshop_category AS c , jos_redshop_category_xref AS cat_ref
      WHERE cat_ref.category_child_id=c.category_id
      AND category_parent_id=262
      AND published = 1
      ORDER BY c.category_name ASC
  21. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '262'
  22. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=262%')
      ORDER BY 'ordering'
  23. SELECT *
      FROM jos_menu
      WHERE id = '324'
  24. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  25. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  26. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_category AS c
      LEFT JOIN jos_redshop_product_category_xref AS pc
      ON pc.category_id=c.category_id
      WHERE p.product_id = pc.product_id
      AND pc.category_id=262
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY p.product_name ASC
      LIMIT 0, 200
  27. SELECT *
      FROM jos_redshop_category AS c, jos_redshop_template AS t
      WHERE t.template_id = c.category_template
      AND t.template_section='category'
      AND c.category_id=262
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
  28. SELECT *
      FROM  jos_redshop_category AS c , jos_redshop_category_xref AS cat_ref
      WHERE cat_ref.category_child_id=c.category_id
      AND category_parent_id=262
      AND published = 1
      ORDER BY c.category_name ASC
  29. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '262'
  30. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=262%')
      ORDER BY 'ordering'
  31. SELECT *
      FROM jos_menu
      WHERE id = '324'
  32. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  33. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  34. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=18826
      AND p.published = 1
      ORDER BY a.ordering ASC
  35. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=18826
      AND t.published = 1
      LIMIT 0,1
  36. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  37. SELECT *
      FROM jos_menu
      WHERE id = '324'
  38. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '18826'
  39. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '18826'
      AND pc.category_id = c.category_id 
      AND c.category_id = '282'
  40. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id=''
      AND c.category_id = cx.category_parent_id
  41. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = ''
  42. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  43. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='18826'
      AND section='1'
  44. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18826
  45. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18826
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  46. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  47. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  48. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18826
  49. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  50. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18826
  51. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  52. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  53. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18826
  54. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  55. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18826
  56. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  57. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18826
      AND ps.stockroom_id = s.stockroom_id
  58. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18826
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  59. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18826
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  60. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 18826
  61. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18826
      AND ps.stockroom_id = s.stockroom_id
  62. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  63. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="18826"
      AND media_type="images" 
      AND media_name = "1738265515_34011.jpg"
  64. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  65. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18826
      AND ps.stockroom_id = s.stockroom_id
  66. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  67. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18826
  68. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18826
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  69. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  70. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  71. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18826
  72. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  73. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18826
  74. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  75. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18826
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  76. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18826
      AND ps.stockroom_id = s.stockroom_id
  77. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  78. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18826
  79. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18826
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  80. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  81. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  82. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18826
  83. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  84. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18826
  85. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  86. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18826
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  87. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16096
      AND p.published = 1
      ORDER BY a.ordering ASC
  88. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16096
      AND t.published = 1
      LIMIT 0,1
  89. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  90. SELECT *
      FROM jos_menu
      WHERE id = '324'
  91. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16096'
  92. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16096'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  93. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  94. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  95. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  96. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16096'
      AND section='1'
  97. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16096
  98. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16096
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  99. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  100. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  101. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16096
  102. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  103. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16096
  104. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  105. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  106. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16096
  107. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  108. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16096
  109. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  110. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16096
      AND ps.stockroom_id = s.stockroom_id
  111. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16096
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  112. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16096
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  113. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16096
  114. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16096
      AND ps.stockroom_id = s.stockroom_id
  115. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  116. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16096"
      AND media_type="images" 
      AND media_name = "texturestyle2/bg21536.jpg"
  117. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  118. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16096
      AND ps.stockroom_id = s.stockroom_id
  119. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  120. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16096
  121. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16096
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  122. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  123. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  124. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16096
  125. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  126. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16096
  127. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  128. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16096
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  129. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16096
      AND ps.stockroom_id = s.stockroom_id
  130. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  131. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16096
  132. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16096
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  133. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  134. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  135. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16096
  136. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  137. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16096
  138. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  139. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16096
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  140. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16097
      AND p.published = 1
      ORDER BY a.ordering ASC
  141. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16097
      AND t.published = 1
      LIMIT 0,1
  142. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  143. SELECT *
      FROM jos_menu
      WHERE id = '324'
  144. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16097'
  145. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16097'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  146. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  147. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  148. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  149. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16097'
      AND section='1'
  150. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16097
  151. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16097
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  152. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  153. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  154. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16097
  155. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  156. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16097
  157. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  158. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  159. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16097
  160. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  161. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16097
  162. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  163. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16097
      AND ps.stockroom_id = s.stockroom_id
  164. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16097
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  165. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16097
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  166. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16097
  167. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16097
      AND ps.stockroom_id = s.stockroom_id
  168. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  169. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16097"
      AND media_type="images" 
      AND media_name = "texturestyle2/ch28255.jpg"
  170. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  171. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16097
      AND ps.stockroom_id = s.stockroom_id
  172. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  173. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16097
  174. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16097
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  175. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  176. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  177. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16097
  178. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  179. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16097
  180. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  181. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16097
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  182. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16097
      AND ps.stockroom_id = s.stockroom_id
  183. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  184. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16097
  185. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16097
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  186. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  187. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  188. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16097
  189. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  190. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16097
  191. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  192. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16097
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  193. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16098
      AND p.published = 1
      ORDER BY a.ordering ASC
  194. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16098
      AND t.published = 1
      LIMIT 0,1
  195. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  196. SELECT *
      FROM jos_menu
      WHERE id = '324'
  197. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16098'
  198. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16098'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  199. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  200. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  201. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  202. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16098'
      AND section='1'
  203. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16098
  204. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16098
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  205. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  206. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  207. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16098
  208. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  209. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16098
  210. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  211. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  212. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16098
  213. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  214. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16098
  215. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  216. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16098
      AND ps.stockroom_id = s.stockroom_id
  217. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16098
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  218. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16098
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  219. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16098
  220. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16098
      AND ps.stockroom_id = s.stockroom_id
  221. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  222. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16098"
      AND media_type="images" 
      AND media_name = "texturestyle2/ch28319.jpg"
  223. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  224. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16098
      AND ps.stockroom_id = s.stockroom_id
  225. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  226. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16098
  227. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16098
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  228. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  229. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  230. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16098
  231. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  232. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16098
  233. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  234. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16098
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  235. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16098
      AND ps.stockroom_id = s.stockroom_id
  236. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  237. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16098
  238. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16098
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  239. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  240. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  241. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16098
  242. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  243. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16098
  244. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  245. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16098
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  246. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16099
      AND p.published = 1
      ORDER BY a.ordering ASC
  247. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16099
      AND t.published = 1
      LIMIT 0,1
  248. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  249. SELECT *
      FROM jos_menu
      WHERE id = '324'
  250. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16099'
  251. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16099'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  252. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  253. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  254. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  255. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16099'
      AND section='1'
  256. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16099
  257. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16099
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  258. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  259. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  260. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16099
  261. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  262. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16099
  263. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  264. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  265. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16099
  266. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  267. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16099
  268. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  269. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16099
      AND ps.stockroom_id = s.stockroom_id
  270. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16099
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  271. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16099
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  272. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16099
  273. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16099
      AND ps.stockroom_id = s.stockroom_id
  274. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  275. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16099"
      AND media_type="images" 
      AND media_name = "texturestyle2/ft23498.jpg"
  276. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  277. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16099
      AND ps.stockroom_id = s.stockroom_id
  278. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  279. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16099
  280. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16099
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  281. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  282. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  283. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16099
  284. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  285. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16099
  286. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  287. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16099
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  288. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16099
      AND ps.stockroom_id = s.stockroom_id
  289. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  290. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16099
  291. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16099
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  292. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  293. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  294. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16099
  295. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  296. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16099
  297. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  298. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16099
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  299. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16100
      AND p.published = 1
      ORDER BY a.ordering ASC
  300. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16100
      AND t.published = 1
      LIMIT 0,1
  301. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  302. SELECT *
      FROM jos_menu
      WHERE id = '324'
  303. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16100'
  304. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16100'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  305. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  306. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  307. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  308. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16100'
      AND section='1'
  309. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16100
  310. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16100
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  311. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  312. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  313. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16100
  314. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  315. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16100
  316. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  317. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  318. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16100
  319. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  320. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16100
  321. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  322. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16100
      AND ps.stockroom_id = s.stockroom_id
  323. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16100
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  324. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16100
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  325. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16100
  326. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16100
      AND ps.stockroom_id = s.stockroom_id
  327. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  328. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16100"
      AND media_type="images" 
      AND media_name = "texturestyle2/hb25879.jpg"
  329. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  330. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16100
      AND ps.stockroom_id = s.stockroom_id
  331. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  332. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16100
  333. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16100
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  334. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  335. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  336. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16100
  337. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  338. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16100
  339. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  340. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16100
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  341. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16100
      AND ps.stockroom_id = s.stockroom_id
  342. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  343. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16100
  344. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16100
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  345. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  346. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  347. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16100
  348. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  349. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16100
  350. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  351. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16100
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  352. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16101
      AND p.published = 1
      ORDER BY a.ordering ASC
  353. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16101
      AND t.published = 1
      LIMIT 0,1
  354. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  355. SELECT *
      FROM jos_menu
      WHERE id = '324'
  356. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16101'
  357. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16101'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  358. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  359. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  360. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  361. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16101'
      AND section='1'
  362. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16101
  363. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16101
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  364. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  365. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  366. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16101
  367. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  368. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16101
  369. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  370. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  371. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16101
  372. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  373. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16101
  374. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  375. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16101
      AND ps.stockroom_id = s.stockroom_id
  376. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16101
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  377. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16101
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  378. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16101
  379. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16101
      AND ps.stockroom_id = s.stockroom_id
  380. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  381. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16101"
      AND media_type="images" 
      AND media_name = "texturestyle2/kb10915.jpg"
  382. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  383. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16101
      AND ps.stockroom_id = s.stockroom_id
  384. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  385. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16101
  386. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16101
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  387. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  388. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  389. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16101
  390. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  391. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16101
  392. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  393. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16101
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  394. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16101
      AND ps.stockroom_id = s.stockroom_id
  395. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  396. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16101
  397. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16101
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  398. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  399. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  400. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16101
  401. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  402. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16101
  403. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  404. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16101
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  405. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16102
      AND p.published = 1
      ORDER BY a.ordering ASC
  406. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16102
      AND t.published = 1
      LIMIT 0,1
  407. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  408. SELECT *
      FROM jos_menu
      WHERE id = '324'
  409. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16102'
  410. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16102'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  411. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  412. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  413. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  414. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16102'
      AND section='1'
  415. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16102
  416. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16102
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  417. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  418. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  419. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16102
  420. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  421. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16102
  422. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  423. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  424. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16102
  425. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  426. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16102
  427. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  428. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16102
      AND ps.stockroom_id = s.stockroom_id
  429. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16102
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  430. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16102
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  431. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16102
  432. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16102
      AND ps.stockroom_id = s.stockroom_id
  433. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  434. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16102"
      AND media_type="images" 
      AND media_name = "texturestyle2/kb20225.jpg"
  435. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  436. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16102
      AND ps.stockroom_id = s.stockroom_id
  437. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  438. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16102
  439. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16102
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  440. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  441. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  442. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16102
  443. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  444. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16102
  445. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  446. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16102
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  447. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16102
      AND ps.stockroom_id = s.stockroom_id
  448. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  449. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16102
  450. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16102
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  451. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  452. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  453. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16102
  454. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  455. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16102
  456. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  457. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16102
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  458. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16103
      AND p.published = 1
      ORDER BY a.ordering ASC
  459. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16103
      AND t.published = 1
      LIMIT 0,1
  460. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  461. SELECT *
      FROM jos_menu
      WHERE id = '324'
  462. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16103'
  463. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16103'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  464. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  465. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  466. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  467. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16103'
      AND section='1'
  468. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16103
  469. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16103
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  470. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  471. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  472. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16103
  473. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  474. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16103
  475. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  476. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  477. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16103
  478. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  479. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16103
  480. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  481. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16103
      AND ps.stockroom_id = s.stockroom_id
  482. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16103
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  483. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16103
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  484. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16103
  485. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16103
      AND ps.stockroom_id = s.stockroom_id
  486. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  487. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16103"
      AND media_type="images" 
      AND media_name = "texturestyle2/ll29502.jpg"
  488. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  489. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16103
      AND ps.stockroom_id = s.stockroom_id
  490. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  491. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16103
  492. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16103
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  493. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  494. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  495. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16103
  496. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  497. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16103
  498. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  499. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16103
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  500. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16103
      AND ps.stockroom_id = s.stockroom_id
  501. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  502. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16103
  503. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16103
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  504. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  505. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  506. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16103
  507. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  508. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16103
  509. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  510. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16103
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  511. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16104
      AND p.published = 1
      ORDER BY a.ordering ASC
  512. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16104
      AND t.published = 1
      LIMIT 0,1
  513. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  514. SELECT *
      FROM jos_menu
      WHERE id = '324'
  515. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16104'
  516. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16104'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  517. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  518. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  519. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  520. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16104'
      AND section='1'
  521. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16104
  522. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16104
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  523. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  524. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  525. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16104
  526. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  527. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16104
  528. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  529. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  530. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16104
  531. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  532. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16104
  533. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  534. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16104
      AND ps.stockroom_id = s.stockroom_id
  535. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16104
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  536. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16104
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  537. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16104
  538. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16104
      AND ps.stockroom_id = s.stockroom_id
  539. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  540. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16104"
      AND media_type="images" 
      AND media_name = "texturestyle2/te29306.jpg"
  541. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  542. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16104
      AND ps.stockroom_id = s.stockroom_id
  543. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  544. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16104
  545. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16104
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  546. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  547. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  548. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16104
  549. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  550. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16104
  551. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  552. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16104
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  553. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16104
      AND ps.stockroom_id = s.stockroom_id
  554. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  555. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16104
  556. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16104
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  557. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  558. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  559. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16104
  560. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  561. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16104
  562. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  563. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16104
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  564. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16105
      AND p.published = 1
      ORDER BY a.ordering ASC
  565. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16105
      AND t.published = 1
      LIMIT 0,1
  566. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  567. SELECT *
      FROM jos_menu
      WHERE id = '324'
  568. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16105'
  569. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16105'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  570. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  571. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  572. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  573. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16105'
      AND section='1'
  574. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16105
  575. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16105
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  576. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  577. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  578. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16105
  579. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  580. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16105
  581. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  582. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  583. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16105
  584. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  585. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16105
  586. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  587. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16105
      AND ps.stockroom_id = s.stockroom_id
  588. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16105
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  589. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16105
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  590. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16105
  591. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16105
      AND ps.stockroom_id = s.stockroom_id
  592. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  593. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16105"
      AND media_type="images" 
      AND media_name = "texturestyle2/te29309.jpg"
  594. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  595. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16105
      AND ps.stockroom_id = s.stockroom_id
  596. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  597. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16105
  598. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16105
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  599. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  600. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  601. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16105
  602. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  603. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16105
  604. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  605. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16105
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  606. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16105
      AND ps.stockroom_id = s.stockroom_id
  607. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  608. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16105
  609. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16105
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  610. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  611. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  612. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16105
  613. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  614. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16105
  615. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  616. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16105
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  617. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16106
      AND p.published = 1
      ORDER BY a.ordering ASC
  618. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16106
      AND t.published = 1
      LIMIT 0,1
  619. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  620. SELECT *
      FROM jos_menu
      WHERE id = '324'
  621. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16106'
  622. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16106'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  623. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  624. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  625. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  626. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16106'
      AND section='1'
  627. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16106
  628. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16106
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  629. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  630. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  631. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16106
  632. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  633. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16106
  634. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  635. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  636. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16106
  637. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  638. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16106
  639. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  640. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16106
      AND ps.stockroom_id = s.stockroom_id
  641. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16106
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  642. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16106
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  643. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16106
  644. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16106
      AND ps.stockroom_id = s.stockroom_id
  645. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  646. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16106"
      AND media_type="images" 
      AND media_name = "texturestyle2/te29312.jpg"
  647. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  648. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16106
      AND ps.stockroom_id = s.stockroom_id
  649. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  650. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16106
  651. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16106
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  652. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  653. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  654. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16106
  655. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  656. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16106
  657. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  658. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16106
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  659. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16106
      AND ps.stockroom_id = s.stockroom_id
  660. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  661. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16106
  662. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16106
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  663. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  664. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  665. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16106
  666. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  667. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16106
  668. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  669. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16106
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  670. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16107
      AND p.published = 1
      ORDER BY a.ordering ASC
  671. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16107
      AND t.published = 1
      LIMIT 0,1
  672. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  673. SELECT *
      FROM jos_menu
      WHERE id = '324'
  674. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16107'
  675. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16107'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  676. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  677. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  678. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  679. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16107'
      AND section='1'
  680. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16107
  681. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16107
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  682. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  683. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  684. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16107
  685. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  686. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16107
  687. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  688. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  689. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16107
  690. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  691. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16107
  692. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  693. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16107
      AND ps.stockroom_id = s.stockroom_id
  694. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16107
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  695. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16107
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  696. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16107
  697. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16107
      AND ps.stockroom_id = s.stockroom_id
  698. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  699. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16107"
      AND media_type="images" 
      AND media_name = "texturestyle2/te29313.jpg"
  700. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  701. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16107
      AND ps.stockroom_id = s.stockroom_id
  702. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  703. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16107
  704. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16107
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  705. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  706. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  707. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16107
  708. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  709. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16107
  710. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  711. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16107
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  712. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16107
      AND ps.stockroom_id = s.stockroom_id
  713. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  714. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16107
  715. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16107
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  716. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  717. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  718. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16107
  719. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  720. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16107
  721. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  722. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16107
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  723. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16108
      AND p.published = 1
      ORDER BY a.ordering ASC
  724. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16108
      AND t.published = 1
      LIMIT 0,1
  725. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  726. SELECT *
      FROM jos_menu
      WHERE id = '324'
  727. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16108'
  728. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16108'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  729. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  730. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  731. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  732. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16108'
      AND section='1'
  733. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16108
  734. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16108
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  735. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  736. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  737. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16108
  738. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  739. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16108
  740. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  741. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  742. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16108
  743. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  744. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16108
  745. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  746. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16108
      AND ps.stockroom_id = s.stockroom_id
  747. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16108
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  748. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16108
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  749. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16108
  750. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16108
      AND ps.stockroom_id = s.stockroom_id
  751. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  752. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16108"
      AND media_type="images" 
      AND media_name = "texturestyle2/te29317.jpg"
  753. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  754. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16108
      AND ps.stockroom_id = s.stockroom_id
  755. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  756. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16108
  757. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16108
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  758. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  759. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  760. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16108
  761. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  762. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16108
  763. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  764. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16108
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  765. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16108
      AND ps.stockroom_id = s.stockroom_id
  766. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  767. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16108
  768. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16108
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  769. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  770. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  771. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16108
  772. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  773. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16108
  774. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  775. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16108
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  776. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16109
      AND p.published = 1
      ORDER BY a.ordering ASC
  777. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16109
      AND t.published = 1
      LIMIT 0,1
  778. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  779. SELECT *
      FROM jos_menu
      WHERE id = '324'
  780. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16109'
  781. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16109'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  782. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  783. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  784. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  785. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16109'
      AND section='1'
  786. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16109
  787. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16109
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  788. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  789. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  790. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16109
  791. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  792. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16109
  793. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  794. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  795. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16109
  796. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  797. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16109
  798. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  799. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16109
      AND ps.stockroom_id = s.stockroom_id
  800. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16109
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  801. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16109
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  802. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16109
  803. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16109
      AND ps.stockroom_id = s.stockroom_id
  804. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  805. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16109"
      AND media_type="images" 
      AND media_name = "texturestyle2/te29327.jpg"
  806. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  807. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16109
      AND ps.stockroom_id = s.stockroom_id
  808. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  809. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16109
  810. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16109
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  811. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  812. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  813. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16109
  814. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  815. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16109
  816. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  817. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16109
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  818. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16109
      AND ps.stockroom_id = s.stockroom_id
  819. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  820. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16109
  821. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16109
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  822. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  823. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  824. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16109
  825. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  826. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16109
  827. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  828. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16109
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  829. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16110
      AND p.published = 1
      ORDER BY a.ordering ASC
  830. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16110
      AND t.published = 1
      LIMIT 0,1
  831. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  832. SELECT *
      FROM jos_menu
      WHERE id = '324'
  833. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16110'
  834. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16110'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  835. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  836. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  837. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  838. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16110'
      AND section='1'
  839. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16110
  840. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16110
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  841. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  842. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  843. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16110
  844. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  845. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16110
  846. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  847. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  848. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16110
  849. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  850. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16110
  851. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  852. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16110
      AND ps.stockroom_id = s.stockroom_id
  853. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16110
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  854. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16110
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  855. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16110
  856. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16110
      AND ps.stockroom_id = s.stockroom_id
  857. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  858. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16110"
      AND media_type="images" 
      AND media_name = "texturestyle2/te29333.jpg"
  859. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  860. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16110
      AND ps.stockroom_id = s.stockroom_id
  861. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  862. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16110
  863. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16110
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  864. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  865. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  866. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16110
  867. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  868. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16110
  869. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  870. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16110
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  871. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16110
      AND ps.stockroom_id = s.stockroom_id
  872. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  873. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16110
  874. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16110
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  875. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  876. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  877. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16110
  878. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  879. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16110
  880. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  881. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16110
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  882. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16111
      AND p.published = 1
      ORDER BY a.ordering ASC
  883. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16111
      AND t.published = 1
      LIMIT 0,1
  884. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  885. SELECT *
      FROM jos_menu
      WHERE id = '324'
  886. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16111'
  887. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16111'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  888. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  889. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  890. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  891. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16111'
      AND section='1'
  892. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16111
  893. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16111
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  894. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  895. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  896. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16111
  897. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  898. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16111
  899. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  900. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  901. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16111
  902. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  903. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16111
  904. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  905. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16111
      AND ps.stockroom_id = s.stockroom_id
  906. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16111
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  907. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16111
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  908. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16111
  909. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16111
      AND ps.stockroom_id = s.stockroom_id
  910. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  911. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16111"
      AND media_type="images" 
      AND media_name = "texturestyle2/te29340.jpg"
  912. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  913. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16111
      AND ps.stockroom_id = s.stockroom_id
  914. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  915. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16111
  916. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16111
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  917. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  918. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  919. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16111
  920. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  921. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16111
  922. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  923. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16111
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  924. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16111
      AND ps.stockroom_id = s.stockroom_id
  925. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  926. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16111
  927. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16111
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  928. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  929. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  930. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16111
  931. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  932. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16111
  933. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  934. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16111
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  935. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16112
      AND p.published = 1
      ORDER BY a.ordering ASC
  936. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16112
      AND t.published = 1
      LIMIT 0,1
  937. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  938. SELECT *
      FROM jos_menu
      WHERE id = '324'
  939. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16112'
  940. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16112'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  941. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  942. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  943. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  944. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16112'
      AND section='1'
  945. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16112
  946. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16112
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  947. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  948. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  949. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16112
  950. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  951. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16112
  952. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  953. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  954. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16112
  955. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  956. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16112
  957. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  958. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16112
      AND ps.stockroom_id = s.stockroom_id
  959. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16112
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  960. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16112
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  961. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16112
  962. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16112
      AND ps.stockroom_id = s.stockroom_id
  963. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  964. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16112"
      AND media_type="images" 
      AND media_name = "texturestyle2/te29344.jpg"
  965. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  966. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16112
      AND ps.stockroom_id = s.stockroom_id
  967. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  968. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16112
  969. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16112
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  970. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  971. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  972. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16112
  973. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  974. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16112
  975. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  976. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16112
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  977. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16112
      AND ps.stockroom_id = s.stockroom_id
  978. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  979. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16112
  980. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16112
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  981. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  982. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  983. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16112
  984. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  985. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16112
  986. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  987. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16112
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  988. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16113
      AND p.published = 1
      ORDER BY a.ordering ASC
  989. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16113
      AND t.published = 1
      LIMIT 0,1
  990. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  991. SELECT *
      FROM jos_menu
      WHERE id = '324'
  992. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16113'
  993. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16113'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  994. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  995. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  996. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  997. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16113'
      AND section='1'
  998. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16113
  999. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16113
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1000. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1001. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1002. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16113
  1003. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1004. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16113
  1005. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1006. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1007. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16113
  1008. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1009. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16113
  1010. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1011. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16113
      AND ps.stockroom_id = s.stockroom_id
  1012. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16113
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  1013. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16113
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1014. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16113
  1015. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16113
      AND ps.stockroom_id = s.stockroom_id
  1016. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  1017. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16113"
      AND media_type="images" 
      AND media_name = "texturestyle2/te29362.jpg"
  1018. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  1019. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16113
      AND ps.stockroom_id = s.stockroom_id
  1020. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1021. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16113
  1022. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16113
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1023. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1024. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1025. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16113
  1026. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1027. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16113
  1028. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1029. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16113
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1030. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16113
      AND ps.stockroom_id = s.stockroom_id
  1031. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1032. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16113
  1033. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16113
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1034. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1035. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1036. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16113
  1037. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1038. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16113
  1039. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1040. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16113
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1041. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16114
      AND p.published = 1
      ORDER BY a.ordering ASC
  1042. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16114
      AND t.published = 1
      LIMIT 0,1
  1043. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  1044. SELECT *
      FROM jos_menu
      WHERE id = '324'
  1045. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16114'
  1046. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16114'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  1047. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  1048. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  1049. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  1050. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16114'
      AND section='1'
  1051. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16114
  1052. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16114
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1053. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1054. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1055. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16114
  1056. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1057. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16114
  1058. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1059. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1060. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16114
  1061. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1062. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16114
  1063. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1064. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16114
      AND ps.stockroom_id = s.stockroom_id
  1065. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16114
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  1066. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16114
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1067. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16114
  1068. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16114
      AND ps.stockroom_id = s.stockroom_id
  1069. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  1070. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16114"
      AND media_type="images" 
      AND media_name = "texturestyle2/te29369.jpg"
  1071. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  1072. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16114
      AND ps.stockroom_id = s.stockroom_id
  1073. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1074. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16114
  1075. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16114
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1076. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1077. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1078. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16114
  1079. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1080. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16114
  1081. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1082. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16114
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1083. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16114
      AND ps.stockroom_id = s.stockroom_id
  1084. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1085. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16114
  1086. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16114
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1087. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1088. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1089. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16114
  1090. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1091. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16114
  1092. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1093. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16114
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1094. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16115
      AND p.published = 1
      ORDER BY a.ordering ASC
  1095. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16115
      AND t.published = 1
      LIMIT 0,1
  1096. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  1097. SELECT *
      FROM jos_menu
      WHERE id = '324'
  1098. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16115'
  1099. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16115'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  1100. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  1101. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  1102. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  1103. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16115'
      AND section='1'
  1104. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16115
  1105. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16115
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1106. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1107. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1108. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16115
  1109. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1110. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16115
  1111. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1112. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1113. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16115
  1114. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1115. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16115
  1116. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1117. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16115
      AND ps.stockroom_id = s.stockroom_id
  1118. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16115
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  1119. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16115
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1120. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16115
  1121. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16115
      AND ps.stockroom_id = s.stockroom_id
  1122. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  1123. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16115"
      AND media_type="images" 
      AND media_name = "texturestyle2/te29371.jpg"
  1124. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  1125. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16115
      AND ps.stockroom_id = s.stockroom_id
  1126. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1127. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16115
  1128. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16115
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1129. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1130. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1131. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16115
  1132. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1133. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16115
  1134. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1135. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16115
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1136. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16115
      AND ps.stockroom_id = s.stockroom_id
  1137. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1138. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16115
  1139. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16115
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1140. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1141. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1142. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16115
  1143. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1144. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16115
  1145. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1146. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16115
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1147. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16116
      AND p.published = 1
      ORDER BY a.ordering ASC
  1148. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16116
      AND t.published = 1
      LIMIT 0,1
  1149. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  1150. SELECT *
      FROM jos_menu
      WHERE id = '324'
  1151. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16116'
  1152. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16116'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  1153. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  1154. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  1155. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  1156. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16116'
      AND section='1'
  1157. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16116
  1158. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16116
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1159. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1160. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1161. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16116
  1162. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1163. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16116
  1164. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1165. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1166. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16116
  1167. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1168. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16116
  1169. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1170. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16116
      AND ps.stockroom_id = s.stockroom_id
  1171. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16116
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  1172. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16116
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1173. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16116
  1174. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16116
      AND ps.stockroom_id = s.stockroom_id
  1175. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  1176. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16116"
      AND media_type="images" 
      AND media_name = "texturestyle2/tx13223.jpg"
  1177. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  1178. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16116
      AND ps.stockroom_id = s.stockroom_id
  1179. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1180. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16116
  1181. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16116
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1182. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1183. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1184. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16116
  1185. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1186. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16116
  1187. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1188. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16116
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1189. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16116
      AND ps.stockroom_id = s.stockroom_id
  1190. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1191. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16116
  1192. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16116
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1193. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1194. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1195. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16116
  1196. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1197. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16116
  1198. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1199. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16116
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1200. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16117
      AND p.published = 1
      ORDER BY a.ordering ASC
  1201. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16117
      AND t.published = 1
      LIMIT 0,1
  1202. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  1203. SELECT *
      FROM jos_menu
      WHERE id = '324'
  1204. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16117'
  1205. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16117'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  1206. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  1207. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  1208. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  1209. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16117'
      AND section='1'
  1210. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16117
  1211. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16117
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1212. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1213. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1214. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16117
  1215. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1216. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16117
  1217. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1218. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1219. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16117
  1220. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1221. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16117
  1222. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1223. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16117
      AND ps.stockroom_id = s.stockroom_id
  1224. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16117
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  1225. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16117
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1226. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16117
  1227. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16117
      AND ps.stockroom_id = s.stockroom_id
  1228. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  1229. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16117"
      AND media_type="images" 
      AND media_name = "texturestyle2/tx34802.jpg"
  1230. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  1231. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16117
      AND ps.stockroom_id = s.stockroom_id
  1232. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1233. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16117
  1234. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16117
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1235. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1236. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1237. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16117
  1238. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1239. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16117
  1240. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1241. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16117
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1242. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16117
      AND ps.stockroom_id = s.stockroom_id
  1243. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1244. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16117
  1245. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16117
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1246. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1247. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1248. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16117
  1249. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1250. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16117
  1251. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1252. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16117
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1253. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16118
      AND p.published = 1
      ORDER BY a.ordering ASC
  1254. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16118
      AND t.published = 1
      LIMIT 0,1
  1255. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  1256. SELECT *
      FROM jos_menu
      WHERE id = '324'
  1257. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16118'
  1258. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16118'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  1259. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  1260. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  1261. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  1262. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16118'
      AND section='1'
  1263. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16118
  1264. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16118
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1265. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1266. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1267. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16118
  1268. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1269. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16118
  1270. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1271. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1272. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16118
  1273. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1274. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16118
  1275. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1276. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16118
      AND ps.stockroom_id = s.stockroom_id
  1277. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16118
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  1278. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16118
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1279. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16118
  1280. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16118
      AND ps.stockroom_id = s.stockroom_id
  1281. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  1282. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16118"
      AND media_type="images" 
      AND media_name = "texturestyle2/tx34803.jpg"
  1283. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  1284. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16118
      AND ps.stockroom_id = s.stockroom_id
  1285. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1286. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16118
  1287. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16118
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1288. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1289. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1290. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16118
  1291. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1292. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16118
  1293. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1294. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16118
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1295. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16118
      AND ps.stockroom_id = s.stockroom_id
  1296. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  1297. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16118
  1298. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16118
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  1299. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1300. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787609'
      AND end_date >= '1739787609' 
      ORDER BY amount DESC
      LIMIT 0,1
  1301. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16118
  1302. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  1303. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16118
  1304. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  1305. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16118
      AND discount_enddate>='1739787609'
      AND discount_stratdate<='1739787609'
  1306. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=16119
      AND p.published = 1
      ORDER BY a.ordering ASC
  1307. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=16119
      AND t.published = 1
      LIMIT 0,1
  1308. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  1309. SELECT *
      FROM jos_menu
      WHERE id = '324'
  1310. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16119'
  1311. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16119'
      AND pc.category_id = c.category_id 
      AND c.category_id = '262'
  1312. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='262'
      AND c.category_id = cx.category_parent_id
  1313. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '262'
  1314. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  1315. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='16119'
      AND section='1'
  1316. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16119
  1317. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16119
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <=