Roberto Cavalli 6

Exclusive materials have been used to create a sophisticated design using a new kind of know-how, which transforms into timeless elegance for creative authentic environments.

Profile Information

Application afterLoad: 0.000 seconds, 0.30 MB
Application afterInitialise: 0.005 seconds, 0.97 MB
Application afterRoute: 0.009 seconds, 2.53 MB
Application afterDispatch: 4.018 seconds, 3.47 MB
Application afterRender: 4.027 seconds, 3.73 MB

Memory Usage

3944192

866 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = '7sprd7bakl5s5mja8qhu6de0s4'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1743450793' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '7sprd7bakl5s5mja8qhu6de0s4'
  4. UPDATE `jos_session`
      SET `time`='1743457993',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1743457989;s:18:\"session.timer.last\";i:1743457989;s:17:\"session.timer.now\";i:1743457989;s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:65:\"/home/ontwall/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}'
      WHERE session_id='7sprd7bakl5s5mja8qhu6de0s4'
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT 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
  8. SELECT *
      FROM jos_redshop_configuration
  9. SELECT *
      FROM jos_redshop_catalog_request
      WHERE block = 0
  10. SELECT *
      FROM jos_redshop_sample_request
      WHERE block = 0
  11. SELECT count(id)
      FROM jos_redshop_cron
      WHERE date = '2025-03-31'
  12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = '7sprd7bakl5s5mja8qhu6de0s4'
  13. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = '7sprd7bakl5s5mja8qhu6de0s4'
      AND section='category'
      AND section_id='184'
  14. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
  15. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 245)
      ORDER BY menuid DESC
      LIMIT 0, 1
  16. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_category AS c
      LEFT JOIN jos_redshop_product_category_xref AS pc
      ON pc.category_id=c.category_id
      WHERE p.product_id = pc.product_id
      AND pc.category_id=184
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY c.ordering ASC
  17. SELECT *
      FROM jos_redshop_category
      WHERE category_id = 184
  18. SELECT *
      FROM jos_redshop_category AS c, jos_redshop_template AS t
      WHERE t.template_id = c.category_template
      AND t.template_section='category'
      AND c.category_id=184
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
  19. SELECT *
      FROM  jos_redshop_category AS c , jos_redshop_category_xref AS cat_ref
      WHERE cat_ref.category_child_id=c.category_id
      AND category_parent_id=184
      AND published = 1
      ORDER BY c.category_name ASC
  20. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '184'
  21. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=184%')
      ORDER BY 'ordering'
  22. SELECT *
      FROM jos_menu
      WHERE id = '245'
  23. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  24. 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='184'
      AND c.category_id = cx.category_parent_id
  25. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_category AS c
      LEFT JOIN jos_redshop_product_category_xref AS pc
      ON pc.category_id=c.category_id
      WHERE p.product_id = pc.product_id
      AND pc.category_id=184
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY p.product_name ASC
      LIMIT 15, 15
  26. SELECT *
      FROM jos_redshop_category AS c, jos_redshop_template AS t
      WHERE t.template_id = c.category_template
      AND t.template_section='category'
      AND c.category_id=184
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
  27. SELECT *
      FROM  jos_redshop_category AS c , jos_redshop_category_xref AS cat_ref
      WHERE cat_ref.category_child_id=c.category_id
      AND category_parent_id=184
      AND published = 1
      ORDER BY c.category_name ASC
  28. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '184'
  29. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=184%')
      ORDER BY 'ordering'
  30. SELECT *
      FROM jos_menu
      WHERE id = '245'
  31. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  32. 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='184'
      AND c.category_id = cx.category_parent_id
  33. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=9234
      AND p.published = 1
      ORDER BY a.ordering ASC
  34. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=9234
      AND t.published = 1
      LIMIT 0,1
  35. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  36. SELECT *
      FROM jos_menu
      WHERE id = '245'
  37. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9234'
  38. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9234'
      AND pc.category_id = c.category_id 
      AND c.category_id = '184'
  39. 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='184'
      AND c.category_id = cx.category_parent_id
  40. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  41. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  42. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='9234'
      AND section='1'
  43. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9234
  44. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9234
      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
  45. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  46. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  47. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9234
  48. 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
  49. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9234
  50. 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
  51. 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'
  52. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9234
  53. 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
  54. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9234
  55. 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
  56. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9234
      AND ps.stockroom_id = s.stockroom_id
  57. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9234
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  58. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9234
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  59. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9234
  60. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9234
      AND ps.stockroom_id = s.stockroom_id
  61. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  62. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9234"
      AND media_type="images" 
      AND media_name = "1567175793_RC17026.jpg"
  63. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  64. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9234
      AND ps.stockroom_id = s.stockroom_id
  65. 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'
  66. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9234
  67. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9234
      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
  68. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  69. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  70. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9234
  71. 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
  72. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9234
  73. 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
  74. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9234
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  75. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9234
      AND ps.stockroom_id = s.stockroom_id
  76. 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'
  77. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9234
  78. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9234
      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
  79. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  80. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  81. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9234
  82. 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
  83. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9234
  84. 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
  85. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9234
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  86. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=9235
      AND p.published = 1
      ORDER BY a.ordering ASC
  87. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=9235
      AND t.published = 1
      LIMIT 0,1
  88. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  89. SELECT *
      FROM jos_menu
      WHERE id = '245'
  90. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9235'
  91. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9235'
      AND pc.category_id = c.category_id 
      AND c.category_id = '184'
  92. 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='184'
      AND c.category_id = cx.category_parent_id
  93. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  94. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  95. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='9235'
      AND section='1'
  96. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9235
  97. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9235
      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
  98. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  99. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  100. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9235
  101. 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
  102. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9235
  103. 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
  104. 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'
  105. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9235
  106. 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
  107. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9235
  108. 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
  109. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9235
      AND ps.stockroom_id = s.stockroom_id
  110. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9235
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  111. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9235
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  112. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9235
  113. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9235
      AND ps.stockroom_id = s.stockroom_id
  114. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  115. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9235"
      AND media_type="images" 
      AND media_name = "1567175846_RC17027.jpg"
  116. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  117. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9235
      AND ps.stockroom_id = s.stockroom_id
  118. 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'
  119. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9235
  120. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9235
      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
  121. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  122. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  123. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9235
  124. 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
  125. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9235
  126. 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
  127. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9235
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  128. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9235
      AND ps.stockroom_id = s.stockroom_id
  129. 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'
  130. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9235
  131. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9235
      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
  132. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  133. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  134. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9235
  135. 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
  136. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9235
  137. 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
  138. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9235
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  139. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=9236
      AND p.published = 1
      ORDER BY a.ordering ASC
  140. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=9236
      AND t.published = 1
      LIMIT 0,1
  141. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  142. SELECT *
      FROM jos_menu
      WHERE id = '245'
  143. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9236'
  144. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9236'
      AND pc.category_id = c.category_id 
      AND c.category_id = '184'
  145. 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='184'
      AND c.category_id = cx.category_parent_id
  146. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  147. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  148. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='9236'
      AND section='1'
  149. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9236
  150. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9236
      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
  151. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  152. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  153. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9236
  154. 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
  155. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9236
  156. 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
  157. 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'
  158. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9236
  159. 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
  160. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9236
  161. 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
  162. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9236
      AND ps.stockroom_id = s.stockroom_id
  163. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9236
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  164. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9236
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  165. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9236
  166. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9236
      AND ps.stockroom_id = s.stockroom_id
  167. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  168. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9236"
      AND media_type="images" 
      AND media_name = "1567175890_RC17029.jpg"
  169. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  170. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9236
      AND ps.stockroom_id = s.stockroom_id
  171. 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'
  172. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9236
  173. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9236
      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
  174. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  175. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  176. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9236
  177. 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
  178. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9236
  179. 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
  180. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9236
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  181. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9236
      AND ps.stockroom_id = s.stockroom_id
  182. 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'
  183. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9236
  184. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9236
      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
  185. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  186. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  187. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9236
  188. 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
  189. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9236
  190. 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
  191. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9236
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  192. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=9237
      AND p.published = 1
      ORDER BY a.ordering ASC
  193. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=9237
      AND t.published = 1
      LIMIT 0,1
  194. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  195. SELECT *
      FROM jos_menu
      WHERE id = '245'
  196. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9237'
  197. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9237'
      AND pc.category_id = c.category_id 
      AND c.category_id = '184'
  198. 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='184'
      AND c.category_id = cx.category_parent_id
  199. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  200. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  201. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='9237'
      AND section='1'
  202. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9237
  203. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9237
      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
  204. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  205. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  206. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9237
  207. 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
  208. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9237
  209. 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
  210. 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'
  211. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9237
  212. 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
  213. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9237
  214. 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
  215. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9237
      AND ps.stockroom_id = s.stockroom_id
  216. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9237
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  217. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9237
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  218. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9237
  219. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9237
      AND ps.stockroom_id = s.stockroom_id
  220. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  221. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9237"
      AND media_type="images" 
      AND media_name = "1567175945_RC17031.jpg"
  222. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  223. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9237
      AND ps.stockroom_id = s.stockroom_id
  224. 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'
  225. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9237
  226. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9237
      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
  227. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  228. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  229. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9237
  230. 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
  231. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9237
  232. 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
  233. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9237
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  234. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9237
      AND ps.stockroom_id = s.stockroom_id
  235. 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'
  236. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9237
  237. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9237
      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
  238. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  239. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  240. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9237
  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 = 9237
  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 *
      FROM jos_redshop_product
      WHERE product_id = 9237
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  245. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=9238
      AND p.published = 1
      ORDER BY a.ordering ASC
  246. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=9238
      AND t.published = 1
      LIMIT 0,1
  247. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  248. SELECT *
      FROM jos_menu
      WHERE id = '245'
  249. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9238'
  250. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9238'
      AND pc.category_id = c.category_id 
      AND c.category_id = '184'
  251. 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='184'
      AND c.category_id = cx.category_parent_id
  252. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  253. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  254. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='9238'
      AND section='1'
  255. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9238
  256. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9238
      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
  257. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  258. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  259. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9238
  260. 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
  261. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9238
  262. 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
  263. 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'
  264. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9238
  265. 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
  266. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9238
  267. 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
  268. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9238
      AND ps.stockroom_id = s.stockroom_id
  269. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9238
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  270. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9238
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  271. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9238
  272. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9238
      AND ps.stockroom_id = s.stockroom_id
  273. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  274. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9238"
      AND media_type="images" 
      AND media_name = "1567175979_RC17034.jpg"
  275. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  276. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9238
      AND ps.stockroom_id = s.stockroom_id
  277. 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'
  278. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9238
  279. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9238
      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
  280. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  281. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  282. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9238
  283. 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
  284. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9238
  285. 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
  286. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9238
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  287. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9238
      AND ps.stockroom_id = s.stockroom_id
  288. 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'
  289. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9238
  290. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9238
      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
  291. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  292. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  293. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9238
  294. 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
  295. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9238
  296. 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
  297. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9238
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  298. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=9239
      AND p.published = 1
      ORDER BY a.ordering ASC
  299. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=9239
      AND t.published = 1
      LIMIT 0,1
  300. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  301. SELECT *
      FROM jos_menu
      WHERE id = '245'
  302. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9239'
  303. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9239'
      AND pc.category_id = c.category_id 
      AND c.category_id = '184'
  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='184'
      AND c.category_id = cx.category_parent_id
  305. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  306. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  307. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='9239'
      AND section='1'
  308. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9239
  309. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9239
      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
  310. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  311. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  312. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9239
  313. 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
  314. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9239
  315. 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
  316. 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'
  317. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9239
  318. 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
  319. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9239
  320. 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
  321. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9239
      AND ps.stockroom_id = s.stockroom_id
  322. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9239
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  323. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9239
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  324. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9239
  325. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9239
      AND ps.stockroom_id = s.stockroom_id
  326. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  327. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9239"
      AND media_type="images" 
      AND media_name = "1567176014_RC17035.jpg"
  328. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  329. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9239
      AND ps.stockroom_id = s.stockroom_id
  330. 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'
  331. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9239
  332. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9239
      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 <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  335. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9239
  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 = 9239
  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 *
      FROM jos_redshop_product
      WHERE product_id = 9239
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  340. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9239
      AND ps.stockroom_id = s.stockroom_id
  341. 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'
  342. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9239
  343. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9239
      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
  344. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  345. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  346. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9239
  347. 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
  348. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9239
  349. 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
  350. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9239
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  351. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=9240
      AND p.published = 1
      ORDER BY a.ordering ASC
  352. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=9240
      AND t.published = 1
      LIMIT 0,1
  353. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  354. SELECT *
      FROM jos_menu
      WHERE id = '245'
  355. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9240'
  356. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9240'
      AND pc.category_id = c.category_id 
      AND c.category_id = '184'
  357. 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='184'
      AND c.category_id = cx.category_parent_id
  358. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  359. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  360. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='9240'
      AND section='1'
  361. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9240
  362. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9240
      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
  363. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  364. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  365. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9240
  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 = 9240
  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 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'
  370. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9240
  371. 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
  372. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9240
  373. 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
  374. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9240
      AND ps.stockroom_id = s.stockroom_id
  375. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9240
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  376. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9240
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  377. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9240
  378. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9240
      AND ps.stockroom_id = s.stockroom_id
  379. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  380. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9240"
      AND media_type="images" 
      AND media_name = "1567176056_RC17036.jpg"
  381. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  382. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9240
      AND ps.stockroom_id = s.stockroom_id
  383. 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'
  384. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9240
  385. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9240
      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
  386. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  387. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  388. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9240
  389. 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
  390. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9240
  391. 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
  392. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9240
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  393. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9240
      AND ps.stockroom_id = s.stockroom_id
  394. 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'
  395. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9240
  396. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9240
      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
  397. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  398. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  399. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9240
  400. 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
  401. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9240
  402. 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
  403. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9240
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  404. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=9241
      AND p.published = 1
      ORDER BY a.ordering ASC
  405. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=9241
      AND t.published = 1
      LIMIT 0,1
  406. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  407. SELECT *
      FROM jos_menu
      WHERE id = '245'
  408. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9241'
  409. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9241'
      AND pc.category_id = c.category_id 
      AND c.category_id = '184'
  410. 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='184'
      AND c.category_id = cx.category_parent_id
  411. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  412. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  413. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='9241'
      AND section='1'
  414. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9241
  415. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9241
      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
  416. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  417. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  418. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9241
  419. 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
  420. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9241
  421. 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
  422. 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'
  423. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9241
  424. 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
  425. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9241
  426. 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
  427. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9241
      AND ps.stockroom_id = s.stockroom_id
  428. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9241
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  429. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9241
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  430. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9241
  431. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9241
      AND ps.stockroom_id = s.stockroom_id
  432. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  433. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9241"
      AND media_type="images" 
      AND media_name = "1567176091_RC17037.jpg"
  434. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  435. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9241
      AND ps.stockroom_id = s.stockroom_id
  436. 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'
  437. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9241
  438. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9241
      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
  439. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  440. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  441. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9241
  442. 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
  443. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9241
  444. 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
  445. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9241
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  446. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9241
      AND ps.stockroom_id = s.stockroom_id
  447. 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'
  448. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9241
  449. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9241
      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
  450. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  451. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  452. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9241
  453. 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
  454. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9241
  455. 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
  456. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9241
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  457. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=9242
      AND p.published = 1
      ORDER BY a.ordering ASC
  458. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=9242
      AND t.published = 1
      LIMIT 0,1
  459. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  460. SELECT *
      FROM jos_menu
      WHERE id = '245'
  461. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9242'
  462. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9242'
      AND pc.category_id = c.category_id 
      AND c.category_id = '184'
  463. 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='184'
      AND c.category_id = cx.category_parent_id
  464. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  465. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  466. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='9242'
      AND section='1'
  467. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9242
  468. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9242
      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
  469. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  470. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  471. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9242
  472. 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
  473. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9242
  474. 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
  475. 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'
  476. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9242
  477. 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
  478. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9242
  479. 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
  480. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9242
      AND ps.stockroom_id = s.stockroom_id
  481. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9242
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  482. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9242
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  483. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9242
  484. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9242
      AND ps.stockroom_id = s.stockroom_id
  485. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  486. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9242"
      AND media_type="images" 
      AND media_name = "1567176123_RC17038.jpg"
  487. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  488. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9242
      AND ps.stockroom_id = s.stockroom_id
  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 p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9242
  491. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9242
      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
  492. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  493. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  494. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9242
  495. 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
  496. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9242
  497. 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
  498. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9242
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  499. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9242
      AND ps.stockroom_id = s.stockroom_id
  500. 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'
  501. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9242
  502. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9242
      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
  503. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  504. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  505. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9242
  506. 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
  507. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9242
  508. 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
  509. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9242
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  510. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=9243
      AND p.published = 1
      ORDER BY a.ordering ASC
  511. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=9243
      AND t.published = 1
      LIMIT 0,1
  512. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  513. SELECT *
      FROM jos_menu
      WHERE id = '245'
  514. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9243'
  515. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9243'
      AND pc.category_id = c.category_id 
      AND c.category_id = '184'
  516. 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='184'
      AND c.category_id = cx.category_parent_id
  517. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  518. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  519. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='9243'
      AND section='1'
  520. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9243
  521. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9243
      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
  522. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  523. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  524. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9243
  525. 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
  526. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9243
  527. 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
  528. 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'
  529. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9243
  530. 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
  531. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9243
  532. 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
  533. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9243
      AND ps.stockroom_id = s.stockroom_id
  534. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9243
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  535. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9243
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  536. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9243
  537. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9243
      AND ps.stockroom_id = s.stockroom_id
  538. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  539. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9243"
      AND media_type="images" 
      AND media_name = "1567176156_RC17039.jpg"
  540. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  541. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9243
      AND ps.stockroom_id = s.stockroom_id
  542. 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'
  543. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9243
  544. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9243
      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
  545. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  546. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  547. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9243
  548. 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
  549. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9243
  550. 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
  551. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9243
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  552. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9243
      AND ps.stockroom_id = s.stockroom_id
  553. 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'
  554. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9243
  555. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9243
      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
  556. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  557. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  558. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9243
  559. 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
  560. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9243
  561. 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
  562. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9243
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  563. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=9244
      AND p.published = 1
      ORDER BY a.ordering ASC
  564. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=9244
      AND t.published = 1
      LIMIT 0,1
  565. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  566. SELECT *
      FROM jos_menu
      WHERE id = '245'
  567. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9244'
  568. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9244'
      AND pc.category_id = c.category_id 
      AND c.category_id = '184'
  569. 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='184'
      AND c.category_id = cx.category_parent_id
  570. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  571. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  572. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='9244'
      AND section='1'
  573. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9244
  574. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9244
      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
  575. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  576. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  577. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9244
  578. 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
  579. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9244
  580. 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
  581. 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'
  582. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9244
  583. 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
  584. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9244
  585. 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
  586. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9244
      AND ps.stockroom_id = s.stockroom_id
  587. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9244
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  588. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9244
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  589. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9244
  590. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9244
      AND ps.stockroom_id = s.stockroom_id
  591. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  592. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9244"
      AND media_type="images" 
      AND media_name = "1567176209_RC17041.jpg"
  593. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  594. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9244
      AND ps.stockroom_id = s.stockroom_id
  595. 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'
  596. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9244
  597. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9244
      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
  598. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  599. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  600. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9244
  601. 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
  602. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9244
  603. 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
  604. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9244
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  605. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9244
      AND ps.stockroom_id = s.stockroom_id
  606. 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'
  607. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9244
  608. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9244
      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
  609. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  610. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  611. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9244
  612. 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
  613. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9244
  614. 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
  615. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9244
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  616. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=9245
      AND p.published = 1
      ORDER BY a.ordering ASC
  617. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=9245
      AND t.published = 1
      LIMIT 0,1
  618. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  619. SELECT *
      FROM jos_menu
      WHERE id = '245'
  620. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9245'
  621. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9245'
      AND pc.category_id = c.category_id 
      AND c.category_id = '184'
  622. 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='184'
      AND c.category_id = cx.category_parent_id
  623. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  624. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  625. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='9245'
      AND section='1'
  626. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9245
  627. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9245
      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
  628. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  629. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  630. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9245
  631. 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
  632. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9245
  633. 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
  634. 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'
  635. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9245
  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 = 9245
  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 sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9245
      AND ps.stockroom_id = s.stockroom_id
  640. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9245
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  641. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9245
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  642. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9245
  643. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9245
      AND ps.stockroom_id = s.stockroom_id
  644. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  645. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9245"
      AND media_type="images" 
      AND media_name = "1567176822_RC17043.jpg"
  646. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  647. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9245
      AND ps.stockroom_id = s.stockroom_id
  648. 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'
  649. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9245
  650. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9245
      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
  651. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  652. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  653. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9245
  654. 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
  655. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9245
  656. 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
  657. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9245
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  658. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9245
      AND ps.stockroom_id = s.stockroom_id
  659. 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'
  660. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9245
  661. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9245
      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
  662. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  663. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  664. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9245
  665. 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
  666. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9245
  667. 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
  668. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9245
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  669. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=9246
      AND p.published = 1
      ORDER BY a.ordering ASC
  670. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=9246
      AND t.published = 1
      LIMIT 0,1
  671. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  672. SELECT *
      FROM jos_menu
      WHERE id = '245'
  673. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9246'
  674. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9246'
      AND pc.category_id = c.category_id 
      AND c.category_id = '184'
  675. 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='184'
      AND c.category_id = cx.category_parent_id
  676. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  677. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  678. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='9246'
      AND section='1'
  679. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9246
  680. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9246
      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
  681. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  682. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  683. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9246
  684. 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
  685. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9246
  686. 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
  687. 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'
  688. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9246
  689. 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
  690. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9246
  691. 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
  692. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9246
      AND ps.stockroom_id = s.stockroom_id
  693. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9246
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  694. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9246
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  695. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9246
  696. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9246
      AND ps.stockroom_id = s.stockroom_id
  697. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  698. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9246"
      AND media_type="images" 
      AND media_name = "1567177238_RC17046.jpg"
  699. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  700. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9246
      AND ps.stockroom_id = s.stockroom_id
  701. 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'
  702. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9246
  703. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9246
      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
  704. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  705. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  706. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9246
  707. 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
  708. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9246
  709. 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
  710. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9246
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  711. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9246
      AND ps.stockroom_id = s.stockroom_id
  712. 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'
  713. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9246
  714. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9246
      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
  715. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  716. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  717. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9246
  718. 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
  719. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9246
  720. 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
  721. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9246
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  722. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=9247
      AND p.published = 1
      ORDER BY a.ordering ASC
  723. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=9247
      AND t.published = 1
      LIMIT 0,1
  724. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  725. SELECT *
      FROM jos_menu
      WHERE id = '245'
  726. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9247'
  727. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9247'
      AND pc.category_id = c.category_id 
      AND c.category_id = '184'
  728. 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='184'
      AND c.category_id = cx.category_parent_id
  729. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  730. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  731. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='9247'
      AND section='1'
  732. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9247
  733. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9247
      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
  734. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  735. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  736. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9247
  737. 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
  738. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9247
  739. 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
  740. 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'
  741. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9247
  742. 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
  743. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9247
  744. 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
  745. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9247
      AND ps.stockroom_id = s.stockroom_id
  746. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9247
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  747. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9247
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  748. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9247
  749. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9247
      AND ps.stockroom_id = s.stockroom_id
  750. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  751. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9247"
      AND media_type="images" 
      AND media_name = "1567177266_RC17047.jpg"
  752. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  753. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9247
      AND ps.stockroom_id = s.stockroom_id
  754. 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'
  755. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9247
  756. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9247
      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
  757. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  758. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  759. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9247
  760. 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
  761. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9247
  762. 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
  763. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9247
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  764. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9247
      AND ps.stockroom_id = s.stockroom_id
  765. 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'
  766. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9247
  767. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9247
      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
  768. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  769. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  770. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9247
  771. 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
  772. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9247
  773. 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
  774. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9247
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  775. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=9248
      AND p.published = 1
      ORDER BY a.ordering ASC
  776. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=9248
      AND t.published = 1
      LIMIT 0,1
  777. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  778. SELECT *
      FROM jos_menu
      WHERE id = '245'
  779. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9248'
  780. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9248'
      AND pc.category_id = c.category_id 
      AND c.category_id = '184'
  781. 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='184'
      AND c.category_id = cx.category_parent_id
  782. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  783. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  784. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='9248'
      AND section='1'
  785. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9248
  786. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9248
      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
  787. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  788. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  789. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9248
  790. 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
  791. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9248
  792. 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
  793. 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'
  794. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9248
  795. 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
  796. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9248
  797. 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
  798. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9248
      AND ps.stockroom_id = s.stockroom_id
  799. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9248
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  800. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9248
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  801. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9248
  802. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9248
      AND ps.stockroom_id = s.stockroom_id
  803. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  804. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9248"
      AND media_type="images" 
      AND media_name = "1567177294_RC17049.jpg"
  805. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  806. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9248
      AND ps.stockroom_id = s.stockroom_id
  807. 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'
  808. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9248
  809. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9248
      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
  810. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  811. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  812. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9248
  813. 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
  814. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9248
  815. 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
  816. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9248
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  817. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9248
      AND ps.stockroom_id = s.stockroom_id
  818. 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'
  819. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9248
  820. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9248
      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
  821. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  822. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743457997'
      AND end_date >= '1743457997' 
      ORDER BY amount DESC
      LIMIT 0,1
  823. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9248
  824. 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
  825. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9248
  826. 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
  827. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9248
      AND discount_enddate>='1743457997'
      AND discount_stratdate<='1743457997'
  828. SELECT *
      FROM jos_redshop_category
      WHERE category_id = 184
  829. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1
      AND id = '245'
  830. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=category%' 
      AND params NOT LIKE '%categoryid%'
  831. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=category%' 
      AND params  LIKE '%categoryid=184
    %'
  832. SELECT category_parent_id
      FROM jos_redshop_category_xref
      WHERE category_child_id=184
  833. SELECT *
      FROM jos_menu
      WHERE id = '245'
  834. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  835. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='184'
      AND c.category_id = cx.category_parent_id
  836. SELECT *
      FROM jos_menu
      WHERE id = '245'
  837. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  838. 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='184'
      AND c.category_id = cx.category_parent_id
  839. SELECT *
      FROM jos_menu
      WHERE id = '245'
  840. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  841. 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='184'
      AND c.category_id = cx.category_parent_id
  842. SELECT *
      FROM jos_menu
      WHERE id = '245'
  843. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  844. 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='184'
      AND c.category_id = cx.category_parent_id
  845. SELECT *
      FROM jos_menu
      WHERE id = '245'
  846. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  847. 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='184'
      AND c.category_id = cx.category_parent_id
  848. SELECT *
      FROM jos_menu
      WHERE id = '245'
  849. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  850. 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='184'
      AND c.category_id = cx.category_parent_id
  851. SELECT *
      FROM jos_menu
      WHERE id = '245'
  852. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  853. 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='184'
      AND c.category_id = cx.category_parent_id
  854. SELECT *
      FROM jos_menu
      WHERE id = '245'
  855. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  856. 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='184'
      AND c.category_id = cx.category_parent_id
  857. SELECT *
      FROM jos_menu
      WHERE id = '245'
  858. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '184'
  859. 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='184'
      AND c.category_id = cx.category_parent_id
  860. SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 245 OR mm.menuid = 0 )
      ORDER BY position, ordering
  861. SELECT *
      FROM jos_menu
      WHERE id = '71'
  862. SELECT *
      FROM jos_menu
      WHERE id = '222'
  863. SELECT category_id      
      FROM jos_redshop_product_category_xref cx
      WHERE product_id = ''
  864. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`link` LIKE '%id=216%'  OR `params` LIKE '%categoryid=216%')
      ORDER BY 'ordering'
  865. SELECT category_id AS value,category_name AS text
      FROM jos_redshop_category
      WHERE published = 1
  866. SELECT *
      FROM jos_menu
      WHERE id = '245'

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None