Profile Information

Application afterLoad: 0.000 seconds, 0.30 MB
Application afterInitialise: 0.005 seconds, 0.96 MB
Application afterRoute: 0.016 seconds, 2.52 MB
Application afterDispatch: 4.214 seconds, 3.20 MB
Application afterRender: 4.226 seconds, 3.40 MB

Memory Usage

3597352

430 queries logged

  1. DELETE
      FROM jos_session
      WHERE ( time < '1739781077' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = 'pajjq863u66n4p0pdjtisf54r3'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'pajjq863u66n4p0pdjtisf54r3','1739788277','','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 = 'pajjq863u66n4p0pdjtisf54r3'
  12. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('pajjq863u66n4p0pdjtisf54r3', '0','1739788279')
  13. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'pajjq863u66n4p0pdjtisf54r3'
      AND section='manufacturers'
      AND section_id='5'
  14. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('pajjq863u66n4p0pdjtisf54r3','0','manufacturers','5','1739788281')
  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 0, 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 = '62'
  28. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '62'
      AND pc.category_id = c.category_id 
      AND c.category_id = '54'
  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='54'
      AND c.category_id = cx.category_parent_id
  30. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '54'
  31. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 62
  32. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 62
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  33. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  34. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739788281'
      AND end_date >= '1739788281' 
      ORDER BY amount DESC
      LIMIT 0,1
  35. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 62
  36. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  37. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 62
  38. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  39. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  40. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 62
  41. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  42. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 62
  43. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  44. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 62
      AND ps.stockroom_id = s.stockroom_id
  45. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 62
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  46. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 62
      AND discount_enddate>='1739788281'
      AND discount_stratdate<='1739788281'
  47. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 62
  48. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 62
      AND ps.stockroom_id = s.stockroom_id
  49. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  50. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="62"
      AND media_type="images" 
      AND media_name = "1306504415_HAV40729.jpg"
  51. SELECT *
      FROM jos_menu
      WHERE id = '222'
  52. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '63'
  53. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '63'
      AND pc.category_id = c.category_id 
      AND c.category_id = '54'
  54. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='54'
      AND c.category_id = cx.category_parent_id
  55. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '54'
  56. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 63
  57. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 63
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  58. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  59. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739788281'
      AND end_date >= '1739788281' 
      ORDER BY amount DESC
      LIMIT 0,1
  60. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 63
  61. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  62. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 63
  63. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  64. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  65. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 63
  66. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  67. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 63
  68. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  69. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 63
      AND ps.stockroom_id = s.stockroom_id
  70. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 63
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  71. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 63
      AND discount_enddate>='1739788281'
      AND discount_stratdate<='1739788281'
  72. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 63
  73. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 63
      AND ps.stockroom_id = s.stockroom_id
  74. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  75. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="63"
      AND media_type="images" 
      AND media_name = "1306512161_HAV40785.jpg"
  76. SELECT *
      FROM jos_menu
      WHERE id = '222'
  77. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '64'
  78. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '64'
      AND pc.category_id = c.category_id 
      AND c.category_id = '54'
  79. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='54'
      AND c.category_id = cx.category_parent_id
  80. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '54'
  81. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 64
  82. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 64
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  83. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  84. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739788281'
      AND end_date >= '1739788281' 
      ORDER BY amount DESC
      LIMIT 0,1
  85. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 64
  86. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  87. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 64
  88. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  89. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  90. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 64
  91. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  92. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 64
  93. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  94. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 64
      AND ps.stockroom_id = s.stockroom_id
  95. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 64
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  96. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 64
      AND discount_enddate>='1739788281'
      AND discount_stratdate<='1739788281'
  97. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 64
  98. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 64
      AND ps.stockroom_id = s.stockroom_id
  99. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  100. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="64"
      AND media_type="images" 
      AND media_name = "1307107064_HAV40797.jpg"
  101. SELECT *
      FROM jos_menu
      WHERE id = '222'
  102. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '65'
  103. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '65'
      AND pc.category_id = c.category_id 
      AND c.category_id = '54'
  104. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='54'
      AND c.category_id = cx.category_parent_id
  105. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '54'
  106. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 65
  107. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 65
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  108. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  109. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739788281'
      AND end_date >= '1739788281' 
      ORDER BY amount DESC
      LIMIT 0,1
  110. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 65
  111. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  112. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 65
  113. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  114. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  115. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 65
  116. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  117. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 65
  118. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  119. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 65
      AND ps.stockroom_id = s.stockroom_id
  120. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 65
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  121. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 65
      AND discount_enddate>='1739788281'
      AND discount_stratdate<='1739788281'
  122. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 65
  123. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 65
      AND ps.stockroom_id = s.stockroom_id
  124. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  125. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="65"
      AND media_type="images" 
      AND media_name = "1307034582_HAV40803.jpg"
  126. SELECT *
      FROM jos_menu
      WHERE id = '222'
  127. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '66'
  128. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '66'
      AND pc.category_id = c.category_id 
      AND c.category_id = '54'
  129. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='54'
      AND c.category_id = cx.category_parent_id
  130. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '54'
  131. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 66
  132. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 66
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  133. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  134. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739788281'
      AND end_date >= '1739788281' 
      ORDER BY amount DESC
      LIMIT 0,1
  135. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 66
  136. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  137. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 66
  138. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  139. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  140. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 66
  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 = 66
  143. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  144. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 66
      AND ps.stockroom_id = s.stockroom_id
  145. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 66
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  146. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 66
      AND discount_enddate>='1739788281'
      AND discount_stratdate<='1739788281'
  147. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 66
  148. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 66
      AND ps.stockroom_id = s.stockroom_id
  149. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  150. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="66"
      AND media_type="images" 
      AND media_name = "1307035942_HAV40816.jpg"
  151. SELECT *
      FROM jos_menu
      WHERE id = '222'
  152. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '67'
  153. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '67'
      AND pc.category_id = c.category_id 
      AND c.category_id = '54'
  154. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='54'
      AND c.category_id = cx.category_parent_id
  155. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '54'
  156. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 67
  157. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 67
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  158. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  159. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739788281'
      AND end_date >= '1739788281' 
      ORDER BY amount DESC
      LIMIT 0,1
  160. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 67
  161. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  162. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 67
  163. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  164. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  165. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 67
  166. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  167. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 67
  168. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  169. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 67
      AND ps.stockroom_id = s.stockroom_id
  170. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 67
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  171. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 67
      AND discount_enddate>='1739788281'
      AND discount_stratdate<='1739788281'
  172. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 67
  173. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 67
      AND ps.stockroom_id = s.stockroom_id
  174. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  175. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="67"
      AND media_type="images" 
      AND media_name = "1307037209_HAV40826.jpg"
  176. SELECT *
      FROM jos_menu
      WHERE id = '222'
  177. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '68'
  178. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '68'
      AND pc.category_id = c.category_id 
      AND c.category_id = '54'
  179. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='54'
      AND c.category_id = cx.category_parent_id
  180. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '54'
  181. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 68
  182. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 68
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  183. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  184. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739788282'
      AND end_date >= '1739788282' 
      ORDER BY amount DESC
      LIMIT 0,1
  185. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 68
  186. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  187. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 68
  188. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  189. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  190. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 68
  191. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  192. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 68
  193. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  194. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 68
      AND ps.stockroom_id = s.stockroom_id
  195. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 68
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  196. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 68
      AND discount_enddate>='1739788282'
      AND discount_stratdate<='1739788282'
  197. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 68
  198. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 68
      AND ps.stockroom_id = s.stockroom_id
  199. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  200. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="68"
      AND media_type="images" 
      AND media_name = "1307037873_HAV40834.jpg"
  201. SELECT *
      FROM jos_menu
      WHERE id = '222'
  202. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '69'
  203. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '69'
      AND pc.category_id = c.category_id 
      AND c.category_id = '54'
  204. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='54'
      AND c.category_id = cx.category_parent_id
  205. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '54'
  206. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 69
  207. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 69
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  208. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  209. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739788282'
      AND end_date >= '1739788282' 
      ORDER BY amount DESC
      LIMIT 0,1
  210. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 69
  211. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  212. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 69
  213. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  214. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  215. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 69
  216. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  217. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 69
  218. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  219. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 69
      AND ps.stockroom_id = s.stockroom_id
  220. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 69
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  221. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 69
      AND discount_enddate>='1739788282'
      AND discount_stratdate<='1739788282'
  222. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 69
  223. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 69
      AND ps.stockroom_id = s.stockroom_id
  224. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  225. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="69"
      AND media_type="images" 
      AND media_name = "1307040489_HAV40846.jpg"
  226. SELECT *
      FROM jos_menu
      WHERE id = '222'
  227. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '70'
  228. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '70'
      AND pc.category_id = c.category_id 
      AND c.category_id = '54'
  229. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='54'
      AND c.category_id = cx.category_parent_id
  230. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '54'
  231. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 70
  232. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 70
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  233. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  234. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739788282'
      AND end_date >= '1739788282' 
      ORDER BY amount DESC
      LIMIT 0,1
  235. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 70
  236. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  237. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 70
  238. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  239. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  240. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 70
  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 = 70
  243. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  244. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 70
      AND ps.stockroom_id = s.stockroom_id
  245. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 70
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  246. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 70
      AND discount_enddate>='1739788282'
      AND discount_stratdate<='1739788282'
  247. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 70
  248. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 70
      AND ps.stockroom_id = s.stockroom_id
  249. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  250. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="70"
      AND media_type="images" 
      AND media_name = "1307041924_HAV40856.jpg"
  251. SELECT *
      FROM jos_menu
      WHERE id = '222'
  252. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '71'
  253. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '71'
      AND pc.category_id = c.category_id 
      AND c.category_id = '54'
  254. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='54'
      AND c.category_id = cx.category_parent_id
  255. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '54'
  256. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 71
  257. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 71
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  258. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  259. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739788282'
      AND end_date >= '1739788282' 
      ORDER BY amount DESC
      LIMIT 0,1
  260. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 71
  261. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  262. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 71
  263. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  264. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  265. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 71
  266. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  267. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 71
  268. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  269. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 71
      AND ps.stockroom_id = s.stockroom_id
  270. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 71
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  271. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 71
      AND discount_enddate>='1739788282'
      AND discount_stratdate<='1739788282'
  272. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 71
  273. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 71
      AND ps.stockroom_id = s.stockroom_id
  274. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  275. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="71"
      AND media_type="images" 
      AND media_name = "1307042897_HAV40863.jpg"
  276. SELECT *
      FROM jos_menu
      WHERE id = '222'
  277. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '72'
  278. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '72'
      AND pc.category_id = c.category_id 
      AND c.category_id = '54'
  279. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='54'
      AND c.category_id = cx.category_parent_id
  280. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '54'
  281. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 72
  282. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 72
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  283. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  284. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739788282'
      AND end_date >= '1739788282' 
      ORDER BY amount DESC
      LIMIT 0,1
  285. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 72
  286. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  287. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 72
  288. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  289. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  290. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 72
  291. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  292. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 72
  293. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  294. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 72
      AND ps.stockroom_id = s.stockroom_id
  295. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 72
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  296. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 72
      AND discount_enddate>='1739788282'
      AND discount_stratdate<='1739788282'
  297. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 72
  298. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 72
      AND ps.stockroom_id = s.stockroom_id
  299. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  300. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="72"
      AND media_type="images" 
      AND media_name = "1307044016_HAV40874.jpg"
  301. SELECT *
      FROM jos_menu
      WHERE id = '222'
  302. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '73'
  303. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '73'
      AND pc.category_id = c.category_id 
      AND c.category_id = '55'
  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='55'
      AND c.category_id = cx.category_parent_id
  305. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '55'
  306. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 73
  307. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 73
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  308. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  309. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739788282'
      AND end_date >= '1739788282' 
      ORDER BY amount DESC
      LIMIT 0,1
  310. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 73
  311. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  312. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 73
  313. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  314. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  315. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 73
  316. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  317. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 73
  318. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  319. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 73
      AND ps.stockroom_id = s.stockroom_id
  320. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 73
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  321. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 73
      AND discount_enddate>='1739788282'
      AND discount_stratdate<='1739788282'
  322. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 73
  323. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 73
      AND ps.stockroom_id = s.stockroom_id
  324. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  325. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="73"
      AND media_type="images" 
      AND media_name = "1307111373_HMY57503.jpg"
  326. SELECT *
      FROM jos_menu
      WHERE id = '222'
  327. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '74'
  328. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '74'
      AND pc.category_id = c.category_id 
      AND c.category_id = '55'
  329. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='55'
      AND c.category_id = cx.category_parent_id
  330. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '55'
  331. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 74
  332. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 74
      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 <= '1739788282'
      AND end_date >= '1739788282' 
      ORDER BY amount DESC
      LIMIT 0,1
  335. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 74
  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 = 74
  338. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  339. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  340. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 74
  341. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  342. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 74
  343. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  344. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 74
      AND ps.stockroom_id = s.stockroom_id
  345. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 74
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  346. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 74
      AND discount_enddate>='1739788282'
      AND discount_stratdate<='1739788282'
  347. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 74
  348. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 74
      AND ps.stockroom_id = s.stockroom_id
  349. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  350. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="74"
      AND media_type="images" 
      AND media_name = "1307114222_HMY57511.jpg"
  351. SELECT *
      FROM jos_menu
      WHERE id = '222'
  352. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '75'
  353. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '75'
      AND pc.category_id = c.category_id 
      AND c.category_id = '55'
  354. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='55'
      AND c.category_id = cx.category_parent_id
  355. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '55'
  356. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 75
  357. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 75
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  358. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  359. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739788282'
      AND end_date >= '1739788282' 
      ORDER BY amount DESC
      LIMIT 0,1
  360. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 75
  361. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  362. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 75
  363. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  364. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  365. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 75
  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 = 75
  368. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  369. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 75
      AND ps.stockroom_id = s.stockroom_id
  370. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 75
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  371. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 75
      AND discount_enddate>='1739788282'
      AND discount_stratdate<='1739788282'
  372. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 75
  373. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 75
      AND ps.stockroom_id = s.stockroom_id
  374. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  375. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="75"
      AND media_type="images" 
      AND media_name = "1307115096_HMY57533.jpg"
  376. SELECT *
      FROM jos_menu
      WHERE id = '222'
  377. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '76'
  378. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '76'
      AND pc.category_id = c.category_id 
      AND c.category_id = '55'
  379. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='55'
      AND c.category_id = cx.category_parent_id
  380. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '55'
  381. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 76
  382. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 76
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  383. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  384. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739788282'
      AND end_date >= '1739788282' 
      ORDER BY amount DESC
      LIMIT 0,1
  385. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 76
  386. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  387. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 76
  388. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  389. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  390. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 76
  391. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  392. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 76
  393. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  394. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 76
      AND ps.stockroom_id = s.stockroom_id
  395. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 76
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  396. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 76
      AND discount_enddate>='1739788282'
      AND discount_stratdate<='1739788282'
  397. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 76
  398. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 76
      AND ps.stockroom_id = s.stockroom_id
  399. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  400. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="76"
      AND media_type="images" 
      AND media_name = "1307115913_HMY57542.jpg"
  401. SELECT *
      FROM jos_menu
      WHERE id = '222'
  402. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  403. SELECT *
      FROM jos_menu
      WHERE id = '222'
  404. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  405. SELECT *
      FROM jos_menu
      WHERE id = '222'
  406. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  407. SELECT *
      FROM jos_menu
      WHERE id = '222'
  408. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  409. SELECT *
      FROM jos_menu
      WHERE id = '222'
  410. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  411. SELECT *
      FROM jos_menu
      WHERE id = '222'
  412. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  413. SELECT *
      FROM jos_menu
      WHERE id = '222'
  414. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  415. SELECT *
      FROM jos_menu
      WHERE id = '222'
  416. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  417. SELECT *
      FROM jos_menu
      WHERE id = '222'
  418. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  419. SELECT *
      FROM jos_menu
      WHERE id = '222'
  420. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  421. SELECT *
      FROM jos_menu
      WHERE id = '222'
  422. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  423. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='10'
      AND published=1 
      AND field_name IN ('manufacturer_image')
  424. 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
  425. SELECT *
      FROM jos_menu
      WHERE id = '71'
  426. SELECT *
      FROM jos_menu
      WHERE id = '222'
  427. SELECT category_id      
      FROM jos_redshop_product_category_xref cx
      WHERE product_id = ''
  428. 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'
  429. SELECT category_id AS value,category_name AS text
      FROM jos_redshop_category
      WHERE published = 1
  430. SELECT *
      FROM jos_menu
      WHERE id = '222'

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None