Profile Information

Application afterLoad: 0.000 seconds, 0.29 MB
Application afterInitialise: 0.006 seconds, 0.95 MB
Application afterRoute: 0.014 seconds, 2.52 MB
Application afterDispatch: 3.019 seconds, 3.20 MB
Application afterRender: 3.031 seconds, 3.41 MB

Memory Usage

3602960

449 queries logged

  1. DELETE
      FROM jos_session
      WHERE ( time < '1739786070' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = 'lp3cqbhe3qku6f4c11a81tbnk2'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'lp3cqbhe3qku6f4c11a81tbnk2','1739793270','','0','1','0' )
  4. SELECT *
      FROM jos_components
      WHERE parent = 0
  5. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  6. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  7. SELECT *
      FROM jos_redshop_configuration
  8. SELECT *
      FROM jos_redshop_catalog_request
      WHERE block = 0
  9. SELECT *
      FROM jos_redshop_sample_request
      WHERE block = 0
  10. SELECT count(id)
      FROM jos_redshop_cron
      WHERE date = '2025-02-17'
  11. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'lp3cqbhe3qku6f4c11a81tbnk2'
  12. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('lp3cqbhe3qku6f4c11a81tbnk2', '0','1739793272')
  13. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'lp3cqbhe3qku6f4c11a81tbnk2'
      AND section='manufacturers'
      AND section_id='5'
  14. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('lp3cqbhe3qku6f4c11a81tbnk2','0','manufacturers','5','1739793273')
  15. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
  16. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 222)
      ORDER BY menuid DESC
      LIMIT 0, 1
  17. SELECT mn.*, m.media_name,m.section_id
      FROM  jos_redshop_manufacturer AS mn
      LEFT JOIN jos_redshop_media AS m
      ON m.section_id=mn.manufacturer_id
      AND m.published = 1
      AND m.media_section='manufacturer'
      WHERE mn.published = 1 
      AND mn.manufacturer_id='5'
  18. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1
      AND id = '222'
  19. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=manufacturers%' 
      AND params  LIKE '%manufacturerid=5
    %'
  20. SELECT *
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = 5
  21. SELECT *
      FROM  jos_redshop_manufacturer
      WHERE published = 1
  22. SELECT DISTINCT(p.product_id),p.product_number,p.product_name,p.product_price,p.product_s_desc,p.product_thumb_image,p.product_full_image , c.category_name
      FROM jos_redshop_product AS p , jos_redshop_manufacturer AS m , jos_redshop_category AS c , jos_redshop_product_category_xref AS pc
      WHERE p.published=1
      AND p.manufacturer_id=5
      AND p.manufacturer_id=m.manufacturer_id 
      AND p.product_id = pc.product_id 
      AND p.expired = 0 
      AND p.product_parent_id = 0 
      AND pc.category_id = c.category_id 
      GROUP BY p.product_id   
      ORDER BY p.product_name ASC
  23. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'manufacturer_products'
      AND published=1
      AND template_id='14'
      LIMIT 0,1
  24. SELECT category_id AS value, category_name AS text
      FROM jos_redshop_category
      WHERE published = '1'
      ORDER BY category_name ASC
  25. SELECT DISTINCT(p.product_id),p.product_number,p.product_name,p.product_price,p.product_s_desc,p.product_thumb_image,p.product_full_image , c.category_name
      FROM jos_redshop_product AS p , jos_redshop_manufacturer AS m , jos_redshop_category AS c , jos_redshop_product_category_xref AS pc
      WHERE p.published=1
      AND p.manufacturer_id=5
      AND p.manufacturer_id=m.manufacturer_id 
      AND p.product_id = pc.product_id 
      AND p.expired = 0 
      AND p.product_parent_id = 0 
      AND pc.category_id = c.category_id 
      GROUP BY p.product_id   
      ORDER BY p.product_name ASC
      LIMIT 60, 15
  26. SELECT *
      FROM jos_menu
      WHERE id = '222'
  27. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '182'
  28. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '182'
      AND pc.category_id = c.category_id
  29. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='58'
      AND c.category_id = cx.category_parent_id
  30. 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='56'
      AND c.category_id = cx.category_parent_id
  31. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  32. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 182
  33. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 182
      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
  34. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  35. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739793273'
      AND end_date >= '1739793273' 
      ORDER BY amount DESC
      LIMIT 0,1
  36. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 182
  37. 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
  38. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 182
  39. 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
  40. 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'
  41. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 182
  42. 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
  43. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 182
  44. 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
  45. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 182
      AND ps.stockroom_id = s.stockroom_id
  46. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 182
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  47. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 182
      AND discount_enddate>='1739793273'
      AND discount_stratdate<='1739793273'
  48. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 182
  49. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 182
      AND ps.stockroom_id = s.stockroom_id
  50. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  51. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="182"
      AND media_type="images" 
      AND media_name = "1308081107_GU9234_1B.jpg"
  52. SELECT *
      FROM jos_menu
      WHERE id = '222'
  53. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '165'
  54. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '165'
      AND pc.category_id = c.category_id 
      AND c.category_id = '57'
  55. 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='57'
      AND c.category_id = cx.category_parent_id
  56. 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='56'
      AND c.category_id = cx.category_parent_id
  57. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
  58. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 165
  59. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 165
      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
  60. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  61. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739793273'
      AND end_date >= '1739793273' 
      ORDER BY amount DESC
      LIMIT 0,1
  62. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 165
  63. 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
  64. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 165
  65. 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
  66. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  67. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 165
  68. 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
  69. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 165
  70. 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
  71. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 165
      AND ps.stockroom_id = s.stockroom_id
  72. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 165
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  73. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 165
      AND discount_enddate>='1739793273'
      AND discount_stratdate<='1739793273'
  74. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 165
  75. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 165
      AND ps.stockroom_id = s.stockroom_id
  76. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  77. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="165"
      AND media_type="images" 
      AND media_name = "1308068446_GIR9300-4.jpg"
  78. SELECT *
      FROM jos_menu
      WHERE id = '222'
  79. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '168'
  80. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '168'
      AND pc.category_id = c.category_id 
      AND c.category_id = '57'
  81. 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='57'
      AND c.category_id = cx.category_parent_id
  82. 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='56'
      AND c.category_id = cx.category_parent_id
  83. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
  84. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 168
  85. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 168
      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
  86. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  87. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739793273'
      AND end_date >= '1739793273' 
      ORDER BY amount DESC
      LIMIT 0,1
  88. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 168
  89. 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
  90. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 168
  91. 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
  92. 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'
  93. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 168
  94. 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
  95. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 168
  96. 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
  97. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 168
      AND ps.stockroom_id = s.stockroom_id
  98. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 168
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  99. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 168
      AND discount_enddate>='1739793273'
      AND discount_stratdate<='1739793273'
  100. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 168
  101. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 168
      AND ps.stockroom_id = s.stockroom_id
  102. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  103. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="168"
      AND media_type="images" 
      AND media_name = "1308070454_GIR9300-5.jpg"
  104. SELECT *
      FROM jos_menu
      WHERE id = '222'
  105. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '107'
  106. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '107'
      AND pc.category_id = c.category_id 
      AND c.category_id = '57'
  107. 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='57'
      AND c.category_id = cx.category_parent_id
  108. 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='56'
      AND c.category_id = cx.category_parent_id
  109. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
  110. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 107
  111. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 107
      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
  112. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  113. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739793273'
      AND end_date >= '1739793273' 
      ORDER BY amount DESC
      LIMIT 0,1
  114. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 107
  115. 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
  116. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 107
  117. 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
  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 *
      FROM jos_redshop_product
      WHERE product_id = 107
  120. 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
  121. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 107
  122. 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
  123. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 107
      AND ps.stockroom_id = s.stockroom_id
  124. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 107
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  125. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 107
      AND discount_enddate>='1739793273'
      AND discount_stratdate<='1739793273'
  126. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 107
  127. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 107
      AND ps.stockroom_id = s.stockroom_id
  128. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  129. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="107"
      AND media_type="images" 
      AND media_name = "1307641215_GIR9310-11.jpg"
  130. SELECT *
      FROM jos_menu
      WHERE id = '222'
  131. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '132'
  132. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '132'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  133. 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='58'
      AND c.category_id = cx.category_parent_id
  134. 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='56'
      AND c.category_id = cx.category_parent_id
  135. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  136. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 132
  137. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 132
      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
  138. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  139. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739793273'
      AND end_date >= '1739793273' 
      ORDER BY amount DESC
      LIMIT 0,1
  140. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 132
  141. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  142. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 132
  143. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  144. SELECT 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'
  145. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 132
  146. 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
  147. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 132
  148. 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
  149. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 132
      AND ps.stockroom_id = s.stockroom_id
  150. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 132
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  151. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 132
      AND discount_enddate>='1739793273'
      AND discount_stratdate<='1739793273'
  152. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 132
  153. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 132
      AND ps.stockroom_id = s.stockroom_id
  154. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  155. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="132"
      AND media_type="images" 
      AND media_name = "1307729532_GIR9400-1B.jpg"
  156. SELECT *
      FROM jos_menu
      WHERE id = '222'
  157. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '127'
  158. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '127'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  159. 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='58'
      AND c.category_id = cx.category_parent_id
  160. 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='56'
      AND c.category_id = cx.category_parent_id
  161. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  162. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 127
  163. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 127
      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
  164. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  165. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739793273'
      AND end_date >= '1739793273' 
      ORDER BY amount DESC
      LIMIT 0,1
  166. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 127
  167. 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
  168. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 127
  169. 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
  170. 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'
  171. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 127
  172. 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
  173. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 127
  174. 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
  175. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 127
      AND ps.stockroom_id = s.stockroom_id
  176. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 127
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  177. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 127
      AND discount_enddate>='1739793273'
      AND discount_stratdate<='1739793273'
  178. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 127
  179. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 127
      AND ps.stockroom_id = s.stockroom_id
  180. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  181. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="127"
      AND media_type="images" 
      AND media_name = "1307726316_GIR9400-3B.jpg"
  182. SELECT *
      FROM jos_menu
      WHERE id = '222'
  183. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '141'
  184. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '141'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  185. 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='58'
      AND c.category_id = cx.category_parent_id
  186. 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='56'
      AND c.category_id = cx.category_parent_id
  187. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  188. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 141
  189. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 141
      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
  190. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  191. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739793273'
      AND end_date >= '1739793273' 
      ORDER BY amount DESC
      LIMIT 0,1
  192. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 141
  193. 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
  194. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 141
  195. 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
  196. 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'
  197. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 141
  198. 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
  199. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 141
  200. 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
  201. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 141
      AND ps.stockroom_id = s.stockroom_id
  202. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 141
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  203. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 141
      AND discount_enddate>='1739793273'
      AND discount_stratdate<='1739793273'
  204. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 141
  205. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 141
      AND ps.stockroom_id = s.stockroom_id
  206. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  207. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="141"
      AND media_type="images" 
      AND media_name = "1307735645_GIR9401-1B.jpg"
  208. SELECT *
      FROM jos_menu
      WHERE id = '222'
  209. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '144'
  210. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '144'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  211. 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='58'
      AND c.category_id = cx.category_parent_id
  212. 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='56'
      AND c.category_id = cx.category_parent_id
  213. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  214. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 144
  215. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 144
      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
  216. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  217. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739793273'
      AND end_date >= '1739793273' 
      ORDER BY amount DESC
      LIMIT 0,1
  218. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 144
  219. 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
  220. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 144
  221. 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
  222. 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'
  223. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 144
  224. 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
  225. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 144
  226. 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
  227. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 144
      AND ps.stockroom_id = s.stockroom_id
  228. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 144
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  229. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 144
      AND discount_enddate>='1739793273'
      AND discount_stratdate<='1739793273'
  230. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 144
  231. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 144
      AND ps.stockroom_id = s.stockroom_id
  232. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  233. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="144"
      AND media_type="images" 
      AND media_name = "1307736697_GIR9401-2B.jpg"
  234. SELECT *
      FROM jos_menu
      WHERE id = '222'
  235. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '173'
  236. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '173'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  237. 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='58'
      AND c.category_id = cx.category_parent_id
  238. 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='56'
      AND c.category_id = cx.category_parent_id
  239. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  240. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 173
  241. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 173
      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
  242. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  243. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739793273'
      AND end_date >= '1739793273' 
      ORDER BY amount DESC
      LIMIT 0,1
  244. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 173
  245. 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
  246. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 173
  247. 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
  248. 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'
  249. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 173
  250. 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
  251. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 173
  252. 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
  253. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 173
      AND ps.stockroom_id = s.stockroom_id
  254. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 173
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  255. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 173
      AND discount_enddate>='1739793273'
      AND discount_stratdate<='1739793273'
  256. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 173
  257. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 173
      AND ps.stockroom_id = s.stockroom_id
  258. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  259. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="173"
      AND media_type="images" 
      AND media_name = "1308076095_GIR9402-1B.jpg"
  260. SELECT *
      FROM jos_menu
      WHERE id = '222'
  261. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '93'
  262. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '93'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  263. 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='58'
      AND c.category_id = cx.category_parent_id
  264. 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='56'
      AND c.category_id = cx.category_parent_id
  265. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  266. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 93
  267. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 93
      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
  268. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  269. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739793273'
      AND end_date >= '1739793273' 
      ORDER BY amount DESC
      LIMIT 0,1
  270. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
  271. 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
  272. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
  273. 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
  274. 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'
  275. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
  276. 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
  277. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
  278. 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
  279. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 93
      AND ps.stockroom_id = s.stockroom_id
  280. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 93
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  281. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
      AND discount_enddate>='1739793273'
      AND discount_stratdate<='1739793273'
  282. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 93
  283. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 93
      AND ps.stockroom_id = s.stockroom_id
  284. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  285. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="93"
      AND media_type="images" 
      AND media_name = "1307566197_GIR9403-1B.jpg"
  286. SELECT *
      FROM jos_menu
      WHERE id = '222'
  287. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '98'
  288. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '98'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  289. 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='58'
      AND c.category_id = cx.category_parent_id
  290. 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='56'
      AND c.category_id = cx.category_parent_id
  291. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  292. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 98
  293. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 98
      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
  294. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  295. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739793273'
      AND end_date >= '1739793273' 
      ORDER BY amount DESC
      LIMIT 0,1
  296. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 98
  297. 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
  298. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 98
  299. 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
  300. 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'
  301. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 98
  302. 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
  303. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 98
  304. 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
  305. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 98
      AND ps.stockroom_id = s.stockroom_id
  306. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 98
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  307. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 98
      AND discount_enddate>='1739793273'
      AND discount_stratdate<='1739793273'
  308. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 98
  309. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 98
      AND ps.stockroom_id = s.stockroom_id
  310. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  311. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="98"
      AND media_type="images" 
      AND media_name = "1307630630_GIR9403-2B.jpg"
  312. SELECT *
      FROM jos_menu
      WHERE id = '222'
  313. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '88'
  314. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '88'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  315. 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='58'
      AND c.category_id = cx.category_parent_id
  316. 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='56'
      AND c.category_id = cx.category_parent_id
  317. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  318. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 88
  319. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 88
      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
  320. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  321. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739793273'
      AND end_date >= '1739793273' 
      ORDER BY amount DESC
      LIMIT 0,1
  322. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
  323. 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
  324. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
  325. 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
  326. 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'
  327. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
  328. 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
  329. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
  330. 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
  331. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 88
      AND ps.stockroom_id = s.stockroom_id
  332. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 88
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  333. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
      AND discount_enddate>='1739793273'
      AND discount_stratdate<='1739793273'
  334. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 88
  335. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 88
      AND ps.stockroom_id = s.stockroom_id
  336. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  337. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="88"
      AND media_type="images" 
      AND media_name = "1307555687_GIR9403-3B.jpg"
  338. SELECT *
      FROM jos_menu
      WHERE id = '222'
  339. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '90'
  340. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '90'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  341. 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='58'
      AND c.category_id = cx.category_parent_id
  342. 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='56'
      AND c.category_id = cx.category_parent_id
  343. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  344. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 90
  345. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 90
      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
  346. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  347. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739793273'
      AND end_date >= '1739793273' 
      ORDER BY amount DESC
      LIMIT 0,1
  348. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
  349. 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
  350. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
  351. 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
  352. 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'
  353. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
  354. 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
  355. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
  356. 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
  357. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 90
      AND ps.stockroom_id = s.stockroom_id
  358. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 90
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  359. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
      AND discount_enddate>='1739793273'
      AND discount_stratdate<='1739793273'
  360. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 90
  361. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 90
      AND ps.stockroom_id = s.stockroom_id
  362. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  363. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="90"
      AND media_type="images" 
      AND media_name = "1307558555_GIR9404-1B.jpg"
  364. SELECT *
      FROM jos_menu
      WHERE id = '222'
  365. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '161'
  366. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '161'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  367. 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='58'
      AND c.category_id = cx.category_parent_id
  368. 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='56'
      AND c.category_id = cx.category_parent_id
  369. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  370. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 161
  371. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 161
      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
  372. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  373. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739793273'
      AND end_date >= '1739793273' 
      ORDER BY amount DESC
      LIMIT 0,1
  374. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 161
  375. 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
  376. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 161
  377. 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
  378. 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'
  379. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 161
  380. 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
  381. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 161
  382. 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
  383. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 161
      AND ps.stockroom_id = s.stockroom_id
  384. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 161
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  385. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 161
      AND discount_enddate>='1739793273'
      AND discount_stratdate<='1739793273'
  386. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 161
  387. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 161
      AND ps.stockroom_id = s.stockroom_id
  388. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  389. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="161"
      AND media_type="images" 
      AND media_name = "1308062330_GIR9404-2B.jpg"
  390. SELECT *
      FROM jos_menu
      WHERE id = '222'
  391. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '87'
  392. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '87'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  393. 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='58'
      AND c.category_id = cx.category_parent_id
  394. 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='56'
      AND c.category_id = cx.category_parent_id
  395. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  396. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 87
  397. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 87
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  398. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  399. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739793273'
      AND end_date >= '1739793273' 
      ORDER BY amount DESC
      LIMIT 0,1
  400. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
  401. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  402. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
  403. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  404. SELECT 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'
  405. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
  406. 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
  407. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
  408. 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
  409. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 87
      AND ps.stockroom_id = s.stockroom_id
  410. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 87
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  411. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
      AND discount_enddate>='1739793273'
      AND discount_stratdate<='1739793273'
  412. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 87
  413. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 87
      AND ps.stockroom_id = s.stockroom_id
  414. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  415. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="87"
      AND media_type="images" 
      AND media_name = "1307553969_GIR9405-1B.jpg"
  416. SELECT *
      FROM jos_menu
      WHERE id = '222'
  417. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  418. SELECT *
      FROM jos_menu
      WHERE id = '222'
  419. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  420. SELECT *
      FROM jos_menu
      WHERE id = '222'
  421. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  422. SELECT *
      FROM jos_menu
      WHERE id = '222'
  423. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  424. SELECT *
      FROM jos_menu
      WHERE id = '222'
  425. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  426. SELECT *
      FROM jos_menu
      WHERE id = '222'
  427. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  428. SELECT *
      FROM jos_menu
      WHERE id = '222'
  429. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  430. SELECT *
      FROM jos_menu
      WHERE id = '222'
  431. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  432. SELECT *
      FROM jos_menu
      WHERE id = '222'
  433. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  434. SELECT *
      FROM jos_menu
      WHERE id = '222'
  435. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  436. SELECT *
      FROM jos_menu
      WHERE id = '222'
  437. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  438. SELECT *
      FROM jos_menu
      WHERE id = '222'
  439. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  440. SELECT *
      FROM jos_menu
      WHERE id = '222'
  441. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  442. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='10'
      AND published=1 
      AND field_name IN ('manufacturer_image')
  443. 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 = 222 OR mm.menuid = 0 )
      ORDER BY position, ordering
  444. SELECT *
      FROM jos_menu
      WHERE id = '71'
  445. SELECT *
      FROM jos_menu
      WHERE id = '222'
  446. SELECT category_id      
      FROM jos_redshop_product_category_xref cx
      WHERE product_id = ''
  447. 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'
  448. SELECT category_id AS value,category_name AS text
      FROM jos_redshop_category
      WHERE published = 1
  449. SELECT *
      FROM jos_menu
      WHERE id = '222'

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None