City Glam Collection

Product Details

  • Type: Sidewall
  • Collection: City Glam
  • Features: paste the wall
  • Roll Dimensions (D/Roll): 33’ 0” x 21” (10m x 53 cm)

Wallcoverings are packaged and sold in double rolls only

The City Glam collection is a successful collaboration of tradition and contemporary trends. Redesigned classic ornament, clear geometry, which has none of a single extra line, skillful play on the interaction of glossy and matte surfaces, composed sparkle - the collection fully reveals the theme of sluggish luxury, while meeting the requirements of modern trends in interior design. It is interesting to note that in City Glam collection has no bright colors contrasting with each other, the entire collection is formed on the attributes: warm anthracite, strict graphite, silver on white, delicate cocoa with milk that does not go out of fashion, smoky pearl colors play shades, blink on related paints – enable to create a bunch of new, unique interior solutions. City Glam consists of two main motives, the background, combining them, as well as three additional companions that combine perfectly with each other and enable to integrate motives into the interiors of various styles.

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

City Glam

 

Order By :

Profile Information

Application afterLoad: 0.000 seconds, 0.29 MB
Application afterInitialise: 0.005 seconds, 0.96 MB
Application afterRoute: 0.010 seconds, 2.52 MB
Application afterDispatch: 6.942 seconds, 8.92 MB
Application afterRender: 6.953 seconds, 9.51 MB

Memory Usage

10008400

14635 queries logged

  1. DELETE
      FROM jos_session
      WHERE ( time < '1739780659' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = 'ueaqf2jurhum6t9ea04a1tqoi1'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'ueaqf2jurhum6t9ea04a1tqoi1','1739787859','','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 = 'ueaqf2jurhum6t9ea04a1tqoi1'
  12. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('ueaqf2jurhum6t9ea04a1tqoi1', '0','1739787860')
  13. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'ueaqf2jurhum6t9ea04a1tqoi1'
      AND section='manufacturers'
      AND section_id='23'
  14. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('ueaqf2jurhum6t9ea04a1tqoi1','0','manufacturers','23','1739787861')
  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 = 258)
      ORDER BY menuid DESC
      LIMIT 0, 1
  17. SELECT mn.*, m.media_name,m.section_id
      FROM  jos_redshop_manufacturer AS mn
      LEFT JOIN jos_redshop_media AS m
      ON m.section_id=mn.manufacturer_id
      AND m.published = 1
      AND m.media_section='manufacturer'
      WHERE mn.published = 1 
      AND mn.manufacturer_id='23'
  18. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1
      AND id = '258'
  19. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=manufacturers%' 
      AND params  LIKE '%manufacturerid=23
    %'
  20. SELECT *
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = 23
  21. SELECT *
      FROM  jos_redshop_manufacturer
      WHERE published = 1
  22. SELECT DISTINCT(p.product_id),p.product_number,p.product_name,p.product_price,p.product_s_desc,p.product_thumb_image,p.product_full_image , c.category_name
      FROM jos_redshop_product AS p , jos_redshop_manufacturer AS m , jos_redshop_category AS c , jos_redshop_product_category_xref AS pc
      WHERE p.published=1
      AND p.manufacturer_id=23
      AND p.manufacturer_id=m.manufacturer_id 
      AND p.product_id = pc.product_id 
      AND p.expired = 0 
      AND p.product_parent_id = 0 
      AND pc.category_id = c.category_id 
      GROUP BY p.product_id   
      ORDER BY p.product_id DESC
  23. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'manufacturer_products'
      AND published=1
      AND template_id='14'
      LIMIT 0,1
  24. SELECT category_id AS value, category_name AS text
      FROM jos_redshop_category
      WHERE published = '1'
      ORDER BY category_name ASC
  25. SELECT DISTINCT(p.product_id),p.product_number,p.product_name,p.product_price,p.product_s_desc,p.product_thumb_image,p.product_full_image , c.category_name
      FROM jos_redshop_product AS p , jos_redshop_manufacturer AS m , jos_redshop_category AS c , jos_redshop_product_category_xref AS pc
      WHERE p.published=1
      AND p.manufacturer_id=23
      AND p.manufacturer_id=m.manufacturer_id 
      AND p.product_id = pc.product_id 
      AND p.expired = 0 
      AND p.product_parent_id = 0 
      AND pc.category_id = c.category_id 
      GROUP BY p.product_id   
      ORDER BY p.product_id DESC
  26. SELECT *
      FROM jos_menu
      WHERE id = '258'
  27. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16653'
  28. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16653'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  29. 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='270'
      AND c.category_id = cx.category_parent_id
  30. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  31. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16653
  32. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16653
      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
  33. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  34. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  35. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16653
  36. 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
  37. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16653
  38. 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
  39. 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'
  40. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16653
  41. 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
  42. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16653
  43. 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
  44. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16653
      AND ps.stockroom_id = s.stockroom_id
  45. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16653
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  46. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16653
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  47. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16653
  48. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16653
      AND ps.stockroom_id = s.stockroom_id
  49. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  50. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16653"
      AND media_type="images" 
      AND media_name = "energy/91985.jpg"
  51. SELECT *
      FROM jos_menu
      WHERE id = '258'
  52. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16652'
  53. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16652'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  54. 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='270'
      AND c.category_id = cx.category_parent_id
  55. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  56. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16652
  57. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16652
      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
  58. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  59. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  60. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16652
  61. 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
  62. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16652
  63. 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
  64. 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'
  65. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16652
  66. 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
  67. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16652
  68. 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
  69. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16652
      AND ps.stockroom_id = s.stockroom_id
  70. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16652
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  71. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16652
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  72. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16652
  73. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16652
      AND ps.stockroom_id = s.stockroom_id
  74. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  75. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16652"
      AND media_type="images" 
      AND media_name = "energy/91984.jpg"
  76. SELECT *
      FROM jos_menu
      WHERE id = '258'
  77. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16651'
  78. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16651'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  79. 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='270'
      AND c.category_id = cx.category_parent_id
  80. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  81. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16651
  82. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16651
      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
  83. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  84. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  85. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16651
  86. 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
  87. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16651
  88. 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
  89. 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'
  90. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16651
  91. 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
  92. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16651
  93. 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
  94. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16651
      AND ps.stockroom_id = s.stockroom_id
  95. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16651
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  96. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16651
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  97. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16651
  98. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16651
      AND ps.stockroom_id = s.stockroom_id
  99. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  100. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16651"
      AND media_type="images" 
      AND media_name = "energy/91983.jpg"
  101. SELECT *
      FROM jos_menu
      WHERE id = '258'
  102. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16650'
  103. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16650'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  104. 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='270'
      AND c.category_id = cx.category_parent_id
  105. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  106. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16650
  107. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16650
      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
  108. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  109. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  110. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16650
  111. 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
  112. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16650
  113. 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
  114. 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'
  115. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16650
  116. 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
  117. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16650
  118. 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
  119. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16650
      AND ps.stockroom_id = s.stockroom_id
  120. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16650
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  121. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16650
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  122. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16650
  123. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16650
      AND ps.stockroom_id = s.stockroom_id
  124. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  125. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16650"
      AND media_type="images" 
      AND media_name = "energy/91982.jpg"
  126. SELECT *
      FROM jos_menu
      WHERE id = '258'
  127. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16649'
  128. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16649'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  129. 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='270'
      AND c.category_id = cx.category_parent_id
  130. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  131. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16649
  132. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16649
      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 <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  135. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16649
  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 = 16649
  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 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'
  140. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16649
  141. 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
  142. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16649
  143. 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
  144. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16649
      AND ps.stockroom_id = s.stockroom_id
  145. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16649
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  146. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16649
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  147. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16649
  148. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16649
      AND ps.stockroom_id = s.stockroom_id
  149. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  150. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16649"
      AND media_type="images" 
      AND media_name = "energy/91981.jpg"
  151. SELECT *
      FROM jos_menu
      WHERE id = '258'
  152. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16648'
  153. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16648'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  154. 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='270'
      AND c.category_id = cx.category_parent_id
  155. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  156. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16648
  157. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16648
      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
  158. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  159. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  160. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16648
  161. 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
  162. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16648
  163. 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
  164. 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'
  165. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16648
  166. 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
  167. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16648
  168. 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
  169. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16648
      AND ps.stockroom_id = s.stockroom_id
  170. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16648
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  171. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16648
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  172. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16648
  173. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16648
      AND ps.stockroom_id = s.stockroom_id
  174. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  175. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16648"
      AND media_type="images" 
      AND media_name = "energy/91980.jpg"
  176. SELECT *
      FROM jos_menu
      WHERE id = '258'
  177. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16647'
  178. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16647'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  179. 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='270'
      AND c.category_id = cx.category_parent_id
  180. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  181. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16647
  182. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16647
      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
  183. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  184. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  185. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16647
  186. 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
  187. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16647
  188. 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
  189. 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'
  190. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16647
  191. 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
  192. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16647
  193. 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
  194. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16647
      AND ps.stockroom_id = s.stockroom_id
  195. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16647
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  196. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16647
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  197. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16647
  198. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16647
      AND ps.stockroom_id = s.stockroom_id
  199. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  200. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16647"
      AND media_type="images" 
      AND media_name = "energy/91979.jpg"
  201. SELECT *
      FROM jos_menu
      WHERE id = '258'
  202. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16646'
  203. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16646'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  204. 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='270'
      AND c.category_id = cx.category_parent_id
  205. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  206. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16646
  207. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16646
      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
  208. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  209. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  210. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16646
  211. 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
  212. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16646
  213. 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
  214. 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'
  215. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16646
  216. 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
  217. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16646
  218. 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
  219. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16646
      AND ps.stockroom_id = s.stockroom_id
  220. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16646
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  221. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16646
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  222. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16646
  223. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16646
      AND ps.stockroom_id = s.stockroom_id
  224. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  225. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16646"
      AND media_type="images" 
      AND media_name = "energy/91978.jpg"
  226. SELECT *
      FROM jos_menu
      WHERE id = '258'
  227. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16645'
  228. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16645'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  229. 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='270'
      AND c.category_id = cx.category_parent_id
  230. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  231. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16645
  232. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16645
      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
  233. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  234. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  235. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16645
  236. 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
  237. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16645
  238. 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
  239. 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'
  240. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16645
  241. 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
  242. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16645
  243. 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
  244. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16645
      AND ps.stockroom_id = s.stockroom_id
  245. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16645
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  246. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16645
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  247. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16645
  248. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16645
      AND ps.stockroom_id = s.stockroom_id
  249. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  250. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16645"
      AND media_type="images" 
      AND media_name = "energy/91977.jpg"
  251. SELECT *
      FROM jos_menu
      WHERE id = '258'
  252. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16644'
  253. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16644'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  254. 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='270'
      AND c.category_id = cx.category_parent_id
  255. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  256. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16644
  257. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16644
      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 <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  260. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16644
  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 = 16644
  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 = 16644
  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 = 16644
  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 = 16644
      AND ps.stockroom_id = s.stockroom_id
  270. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16644
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  271. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16644
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  272. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16644
  273. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16644
      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 ="16644"
      AND media_type="images" 
      AND media_name = "energy/91976.jpg"
  276. SELECT *
      FROM jos_menu
      WHERE id = '258'
  277. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16643'
  278. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16643'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  279. 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='270'
      AND c.category_id = cx.category_parent_id
  280. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  281. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16643
  282. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16643
      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
  283. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  284. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  285. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16643
  286. 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
  287. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16643
  288. 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
  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 *
      FROM jos_redshop_product
      WHERE product_id = 16643
  291. 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
  292. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16643
  293. 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
  294. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16643
      AND ps.stockroom_id = s.stockroom_id
  295. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16643
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  296. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16643
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  297. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16643
  298. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16643
      AND ps.stockroom_id = s.stockroom_id
  299. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  300. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16643"
      AND media_type="images" 
      AND media_name = "energy/91975.jpg"
  301. SELECT *
      FROM jos_menu
      WHERE id = '258'
  302. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16642'
  303. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16642'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  304. 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='270'
      AND c.category_id = cx.category_parent_id
  305. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  306. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16642
  307. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16642
      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
  308. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  309. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  310. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16642
  311. 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
  312. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16642
  313. 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
  314. 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'
  315. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16642
  316. 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
  317. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16642
  318. 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
  319. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16642
      AND ps.stockroom_id = s.stockroom_id
  320. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16642
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  321. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16642
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  322. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16642
  323. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16642
      AND ps.stockroom_id = s.stockroom_id
  324. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  325. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16642"
      AND media_type="images" 
      AND media_name = "energy/91974.jpg"
  326. SELECT *
      FROM jos_menu
      WHERE id = '258'
  327. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16641'
  328. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16641'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  329. 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='270'
      AND c.category_id = cx.category_parent_id
  330. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  331. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16641
  332. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16641
      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
  333. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  334. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  335. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16641
  336. 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
  337. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16641
  338. 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
  339. 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'
  340. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16641
  341. 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
  342. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16641
  343. 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
  344. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16641
      AND ps.stockroom_id = s.stockroom_id
  345. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16641
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  346. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16641
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  347. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16641
  348. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16641
      AND ps.stockroom_id = s.stockroom_id
  349. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  350. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16641"
      AND media_type="images" 
      AND media_name = "energy/91973.jpg"
  351. SELECT *
      FROM jos_menu
      WHERE id = '258'
  352. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16640'
  353. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16640'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  354. 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='270'
      AND c.category_id = cx.category_parent_id
  355. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  356. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16640
  357. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16640
      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
  358. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  359. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  360. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16640
  361. 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
  362. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16640
  363. 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
  364. 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'
  365. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16640
  366. 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
  367. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16640
  368. 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
  369. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16640
      AND ps.stockroom_id = s.stockroom_id
  370. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16640
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  371. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16640
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  372. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16640
  373. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16640
      AND ps.stockroom_id = s.stockroom_id
  374. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  375. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16640"
      AND media_type="images" 
      AND media_name = "energy/91972.jpg"
  376. SELECT *
      FROM jos_menu
      WHERE id = '258'
  377. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16639'
  378. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16639'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  379. 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='270'
      AND c.category_id = cx.category_parent_id
  380. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  381. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16639
  382. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16639
      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
  383. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  384. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  385. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16639
  386. 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
  387. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16639
  388. 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
  389. 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'
  390. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16639
  391. 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
  392. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16639
  393. 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
  394. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16639
      AND ps.stockroom_id = s.stockroom_id
  395. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16639
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  396. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16639
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  397. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16639
  398. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16639
      AND ps.stockroom_id = s.stockroom_id
  399. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  400. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16639"
      AND media_type="images" 
      AND media_name = "energy/91971.jpg"
  401. SELECT *
      FROM jos_menu
      WHERE id = '258'
  402. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16638'
  403. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16638'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  404. 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='270'
      AND c.category_id = cx.category_parent_id
  405. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  406. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16638
  407. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16638
      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
  408. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  409. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  410. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16638
  411. 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
  412. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16638
  413. 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
  414. 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'
  415. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16638
  416. 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
  417. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16638
  418. 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
  419. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16638
      AND ps.stockroom_id = s.stockroom_id
  420. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16638
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  421. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16638
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  422. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16638
  423. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16638
      AND ps.stockroom_id = s.stockroom_id
  424. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  425. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16638"
      AND media_type="images" 
      AND media_name = "energy/91970.jpg"
  426. SELECT *
      FROM jos_menu
      WHERE id = '258'
  427. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16637'
  428. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16637'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  429. 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='270'
      AND c.category_id = cx.category_parent_id
  430. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  431. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16637
  432. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16637
      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
  433. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  434. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  435. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16637
  436. 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
  437. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16637
  438. 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
  439. 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'
  440. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16637
  441. 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
  442. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16637
  443. 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
  444. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16637
      AND ps.stockroom_id = s.stockroom_id
  445. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16637
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  446. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16637
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  447. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16637
  448. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16637
      AND ps.stockroom_id = s.stockroom_id
  449. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  450. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16637"
      AND media_type="images" 
      AND media_name = "energy/91969.jpg"
  451. SELECT *
      FROM jos_menu
      WHERE id = '258'
  452. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16636'
  453. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16636'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  454. 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='270'
      AND c.category_id = cx.category_parent_id
  455. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  456. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16636
  457. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16636
      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
  458. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  459. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  460. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16636
  461. 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
  462. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16636
  463. 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
  464. 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'
  465. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16636
  466. 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
  467. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16636
  468. 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
  469. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16636
      AND ps.stockroom_id = s.stockroom_id
  470. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16636
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  471. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16636
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  472. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16636
  473. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16636
      AND ps.stockroom_id = s.stockroom_id
  474. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  475. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16636"
      AND media_type="images" 
      AND media_name = "energy/91968.jpg"
  476. SELECT *
      FROM jos_menu
      WHERE id = '258'
  477. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16635'
  478. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16635'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  479. 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='270'
      AND c.category_id = cx.category_parent_id
  480. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  481. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16635
  482. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16635
      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
  483. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  484. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  485. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16635
  486. 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
  487. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16635
  488. 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
  489. 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'
  490. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16635
  491. 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
  492. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16635
  493. 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
  494. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16635
      AND ps.stockroom_id = s.stockroom_id
  495. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16635
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  496. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16635
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  497. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16635
  498. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16635
      AND ps.stockroom_id = s.stockroom_id
  499. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  500. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16635"
      AND media_type="images" 
      AND media_name = "energy/91967.jpg"
  501. SELECT *
      FROM jos_menu
      WHERE id = '258'
  502. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16634'
  503. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16634'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  504. 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='270'
      AND c.category_id = cx.category_parent_id
  505. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  506. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16634
  507. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16634
      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
  508. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  509. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  510. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16634
  511. 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
  512. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16634
  513. 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
  514. 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'
  515. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16634
  516. 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
  517. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16634
  518. 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
  519. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16634
      AND ps.stockroom_id = s.stockroom_id
  520. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16634
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  521. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16634
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  522. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16634
  523. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16634
      AND ps.stockroom_id = s.stockroom_id
  524. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  525. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16634"
      AND media_type="images" 
      AND media_name = "energy/91966.jpg"
  526. SELECT *
      FROM jos_menu
      WHERE id = '258'
  527. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16633'
  528. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16633'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  529. 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='270'
      AND c.category_id = cx.category_parent_id
  530. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  531. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16633
  532. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16633
      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
  533. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  534. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  535. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16633
  536. 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
  537. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16633
  538. 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
  539. 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'
  540. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16633
  541. 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
  542. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16633
  543. 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
  544. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16633
      AND ps.stockroom_id = s.stockroom_id
  545. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16633
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  546. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16633
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  547. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16633
  548. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16633
      AND ps.stockroom_id = s.stockroom_id
  549. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  550. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16633"
      AND media_type="images" 
      AND media_name = "energy/91965.jpg"
  551. SELECT *
      FROM jos_menu
      WHERE id = '258'
  552. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16632'
  553. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16632'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  554. 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='270'
      AND c.category_id = cx.category_parent_id
  555. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  556. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16632
  557. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16632
      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
  558. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  559. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  560. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16632
  561. 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
  562. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16632
  563. 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
  564. 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'
  565. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16632
  566. 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
  567. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16632
  568. 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
  569. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16632
      AND ps.stockroom_id = s.stockroom_id
  570. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16632
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  571. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16632
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  572. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16632
  573. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16632
      AND ps.stockroom_id = s.stockroom_id
  574. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  575. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16632"
      AND media_type="images" 
      AND media_name = "energy/91964.jpg"
  576. SELECT *
      FROM jos_menu
      WHERE id = '258'
  577. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16631'
  578. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16631'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  579. 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='270'
      AND c.category_id = cx.category_parent_id
  580. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  581. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16631
  582. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16631
      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
  583. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  584. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  585. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16631
  586. 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
  587. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16631
  588. 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
  589. 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'
  590. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16631
  591. 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
  592. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16631
  593. 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
  594. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16631
      AND ps.stockroom_id = s.stockroom_id
  595. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16631
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  596. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16631
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  597. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16631
  598. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16631
      AND ps.stockroom_id = s.stockroom_id
  599. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  600. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16631"
      AND media_type="images" 
      AND media_name = "energy/91963.jpg"
  601. SELECT *
      FROM jos_menu
      WHERE id = '258'
  602. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16630'
  603. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16630'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  604. 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='270'
      AND c.category_id = cx.category_parent_id
  605. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  606. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16630
  607. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16630
      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
  608. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  609. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  610. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16630
  611. 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
  612. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16630
  613. 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
  614. 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'
  615. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16630
  616. 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
  617. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16630
  618. 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
  619. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16630
      AND ps.stockroom_id = s.stockroom_id
  620. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16630
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  621. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16630
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  622. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16630
  623. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16630
      AND ps.stockroom_id = s.stockroom_id
  624. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  625. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16630"
      AND media_type="images" 
      AND media_name = "energy/91962.jpg"
  626. SELECT *
      FROM jos_menu
      WHERE id = '258'
  627. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16629'
  628. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16629'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  629. 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='270'
      AND c.category_id = cx.category_parent_id
  630. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  631. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16629
  632. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16629
      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
  633. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  634. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  635. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16629
  636. 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
  637. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16629
  638. 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
  639. 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'
  640. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16629
  641. 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
  642. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16629
  643. 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
  644. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16629
      AND ps.stockroom_id = s.stockroom_id
  645. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16629
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  646. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16629
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  647. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16629
  648. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16629
      AND ps.stockroom_id = s.stockroom_id
  649. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  650. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16629"
      AND media_type="images" 
      AND media_name = "energy/91961.jpg"
  651. SELECT *
      FROM jos_menu
      WHERE id = '258'
  652. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16628'
  653. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16628'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  654. 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='270'
      AND c.category_id = cx.category_parent_id
  655. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  656. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16628
  657. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16628
      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
  658. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  659. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  660. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16628
  661. 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
  662. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16628
  663. 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
  664. 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'
  665. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16628
  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 = 16628
  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 sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16628
      AND ps.stockroom_id = s.stockroom_id
  670. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16628
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  671. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16628
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  672. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16628
  673. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16628
      AND ps.stockroom_id = s.stockroom_id
  674. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  675. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16628"
      AND media_type="images" 
      AND media_name = "energy/91960.jpg"
  676. SELECT *
      FROM jos_menu
      WHERE id = '258'
  677. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16627'
  678. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16627'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  679. 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='270'
      AND c.category_id = cx.category_parent_id
  680. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  681. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16627
  682. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16627
      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
  683. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  684. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  685. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16627
  686. 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
  687. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16627
  688. 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
  689. 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'
  690. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16627
  691. 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
  692. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16627
  693. 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
  694. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16627
      AND ps.stockroom_id = s.stockroom_id
  695. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16627
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  696. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16627
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  697. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16627
  698. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16627
      AND ps.stockroom_id = s.stockroom_id
  699. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  700. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16627"
      AND media_type="images" 
      AND media_name = "energy/91959.jpg"
  701. SELECT *
      FROM jos_menu
      WHERE id = '258'
  702. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16626'
  703. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16626'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  704. 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='270'
      AND c.category_id = cx.category_parent_id
  705. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  706. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16626
  707. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16626
      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
  708. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  709. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  710. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16626
  711. 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
  712. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16626
  713. 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
  714. 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'
  715. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16626
  716. 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
  717. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16626
  718. 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
  719. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16626
      AND ps.stockroom_id = s.stockroom_id
  720. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16626
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  721. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16626
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  722. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16626
  723. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16626
      AND ps.stockroom_id = s.stockroom_id
  724. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  725. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16626"
      AND media_type="images" 
      AND media_name = "energy/91958.jpg"
  726. SELECT *
      FROM jos_menu
      WHERE id = '258'
  727. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16625'
  728. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16625'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  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='270'
      AND c.category_id = cx.category_parent_id
  730. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  731. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16625
  732. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16625
      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
  733. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  734. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  735. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16625
  736. 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
  737. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16625
  738. 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
  739. 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'
  740. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16625
  741. 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
  742. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16625
  743. 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
  744. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16625
      AND ps.stockroom_id = s.stockroom_id
  745. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16625
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  746. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16625
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  747. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16625
  748. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16625
      AND ps.stockroom_id = s.stockroom_id
  749. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  750. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16625"
      AND media_type="images" 
      AND media_name = "energy/91957.jpg"
  751. SELECT *
      FROM jos_menu
      WHERE id = '258'
  752. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16624'
  753. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16624'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  754. 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='270'
      AND c.category_id = cx.category_parent_id
  755. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  756. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16624
  757. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16624
      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 <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  760. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16624
  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 = 16624
  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 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'
  765. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16624
  766. 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
  767. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16624
  768. 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
  769. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16624
      AND ps.stockroom_id = s.stockroom_id
  770. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16624
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  771. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16624
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  772. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16624
  773. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16624
      AND ps.stockroom_id = s.stockroom_id
  774. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  775. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16624"
      AND media_type="images" 
      AND media_name = "energy/91956.jpg"
  776. SELECT *
      FROM jos_menu
      WHERE id = '258'
  777. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16623'
  778. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16623'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  779. 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='270'
      AND c.category_id = cx.category_parent_id
  780. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  781. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16623
  782. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16623
      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
  783. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  784. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  785. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16623
  786. 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
  787. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16623
  788. 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
  789. 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'
  790. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16623
  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 = 16623
  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 sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16623
      AND ps.stockroom_id = s.stockroom_id
  795. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16623
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  796. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16623
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  797. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16623
  798. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16623
      AND ps.stockroom_id = s.stockroom_id
  799. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  800. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16623"
      AND media_type="images" 
      AND media_name = "energy/91955.jpg"
  801. SELECT *
      FROM jos_menu
      WHERE id = '258'
  802. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16622'
  803. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16622'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  804. 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='270'
      AND c.category_id = cx.category_parent_id
  805. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  806. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16622
  807. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16622
      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
  808. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  809. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  810. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16622
  811. 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
  812. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16622
  813. 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
  814. 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'
  815. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16622
  816. 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
  817. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16622
  818. 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
  819. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16622
      AND ps.stockroom_id = s.stockroom_id
  820. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16622
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  821. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16622
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  822. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16622
  823. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16622
      AND ps.stockroom_id = s.stockroom_id
  824. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  825. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16622"
      AND media_type="images" 
      AND media_name = "energy/91954.jpg"
  826. SELECT *
      FROM jos_menu
      WHERE id = '258'
  827. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16621'
  828. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16621'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  829. 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='270'
      AND c.category_id = cx.category_parent_id
  830. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  831. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16621
  832. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16621
      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
  833. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  834. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  835. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16621
  836. 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
  837. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16621
  838. 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
  839. 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'
  840. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16621
  841. 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
  842. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16621
  843. 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
  844. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16621
      AND ps.stockroom_id = s.stockroom_id
  845. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16621
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  846. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16621
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  847. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16621
  848. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16621
      AND ps.stockroom_id = s.stockroom_id
  849. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  850. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16621"
      AND media_type="images" 
      AND media_name = "energy/91953.jpg"
  851. SELECT *
      FROM jos_menu
      WHERE id = '258'
  852. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16620'
  853. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16620'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  854. 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='270'
      AND c.category_id = cx.category_parent_id
  855. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  856. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16620
  857. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16620
      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
  858. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  859. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  860. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16620
  861. 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
  862. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16620
  863. 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
  864. 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'
  865. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16620
  866. 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
  867. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16620
  868. 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
  869. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16620
      AND ps.stockroom_id = s.stockroom_id
  870. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16620
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  871. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16620
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  872. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16620
  873. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16620
      AND ps.stockroom_id = s.stockroom_id
  874. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  875. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16620"
      AND media_type="images" 
      AND media_name = "energy/91952.jpg"
  876. SELECT *
      FROM jos_menu
      WHERE id = '258'
  877. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16619'
  878. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16619'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  879. 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='270'
      AND c.category_id = cx.category_parent_id
  880. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  881. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16619
  882. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16619
      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
  883. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  884. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  885. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16619
  886. 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
  887. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16619
  888. 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
  889. 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'
  890. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16619
  891. 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
  892. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16619
  893. 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
  894. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16619
      AND ps.stockroom_id = s.stockroom_id
  895. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16619
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  896. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16619
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  897. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16619
  898. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16619
      AND ps.stockroom_id = s.stockroom_id
  899. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  900. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16619"
      AND media_type="images" 
      AND media_name = "energy/91951.jpg"
  901. SELECT *
      FROM jos_menu
      WHERE id = '258'
  902. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16618'
  903. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16618'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  904. 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='270'
      AND c.category_id = cx.category_parent_id
  905. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  906. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16618
  907. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16618
      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
  908. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  909. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  910. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16618
  911. 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
  912. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16618
  913. 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
  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 *
      FROM jos_redshop_product
      WHERE product_id = 16618
  916. 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
  917. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16618
  918. 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
  919. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16618
      AND ps.stockroom_id = s.stockroom_id
  920. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16618
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  921. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16618
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  922. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16618
  923. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16618
      AND ps.stockroom_id = s.stockroom_id
  924. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  925. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16618"
      AND media_type="images" 
      AND media_name = "energy/91950.jpg"
  926. SELECT *
      FROM jos_menu
      WHERE id = '258'
  927. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16617'
  928. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16617'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  929. 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='270'
      AND c.category_id = cx.category_parent_id
  930. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  931. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16617
  932. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16617
      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
  933. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  934. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787861'
      AND end_date >= '1739787861' 
      ORDER BY amount DESC
      LIMIT 0,1
  935. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16617
  936. 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
  937. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16617
  938. 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
  939. 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'
  940. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16617
  941. 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
  942. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16617
  943. 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
  944. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16617
      AND ps.stockroom_id = s.stockroom_id
  945. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16617
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  946. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 16617
      AND discount_enddate>='1739787861'
      AND discount_stratdate<='1739787861'
  947. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 16617
  948. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 16617
      AND ps.stockroom_id = s.stockroom_id
  949. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  950. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="16617"
      AND media_type="images" 
      AND media_name = "energy/91949.jpg"
  951. SELECT *
      FROM jos_menu
      WHERE id = '258'
  952. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '16616'
  953. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '16616'
      AND pc.category_id = c.category_id 
      AND c.category_id = '270'
  954. 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='270'
      AND c.category_id = cx.category_parent_id
  955. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '270'
  956. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 16616
  957. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 16616
      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
  958. SELECT *