Profile Information

Application afterLoad: 0.000 seconds, 0.30 MB
Application afterInitialise: 0.005 seconds, 0.97 MB
Application afterRoute: 0.009 seconds, 2.53 MB
Application afterDispatch: 1.949 seconds, 3.50 MB
Application afterRender: 1.957 seconds, 3.70 MB

Memory Usage

3909904

891 queries logged

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

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None