Collection AG Design PHOTO MURALS – the best way to quickly and professionally please children, teenagers and adults and change boring home, office and industrial interior.

The variety of motifs is perfectly suitable for decorating massive wall fragments and whole walls for different types of kids residential, educational, medical and sport environment.

The motifs for this collection have been worked up by the leading design team of AG Design Group with the involvement of specialists of Walt Disney Company, Sanrio, Little Mole and experts – customers of different age groups.

AG Design Murals

 

Profile Information

Application afterLoad: 0.000 seconds, 0.29 MB
Application afterInitialise: 0.006 seconds, 0.95 MB
Application afterRoute: 0.012 seconds, 2.51 MB
Application afterDispatch: 4.915 seconds, 6.44 MB
Application afterRender: 4.939 seconds, 6.84 MB

Memory Usage

7200472

6247 queries logged

  1. DELETE
      FROM jos_session
      WHERE ( time < '1739783314' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = 'hf4f3or3gi04irbh43o9jalao7'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'hf4f3or3gi04irbh43o9jalao7','1739790514','','0','1','0' )
  4. SELECT *
      FROM jos_components
      WHERE parent = 0
  5. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  6. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  7. SELECT *
      FROM jos_redshop_configuration
  8. SELECT *
      FROM jos_redshop_catalog_request
      WHERE block = 0
  9. SELECT *
      FROM jos_redshop_sample_request
      WHERE block = 0
  10. SELECT count(id)
      FROM jos_redshop_cron
      WHERE date = '2025-02-17'
  11. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'hf4f3or3gi04irbh43o9jalao7'
  12. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('hf4f3or3gi04irbh43o9jalao7', '0','1739790515')
  13. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'hf4f3or3gi04irbh43o9jalao7'
      AND section='category'
      AND section_id=''
  14. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('hf4f3or3gi04irbh43o9jalao7','0','category','','1739790516')
  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 = 224)
      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=164
      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
      WHERE category_id = 164
  19. 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=164
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
  20. 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=164
      AND published = 1
      ORDER BY c.category_name ASC
  21. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '164'
  22. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=164%')
      ORDER BY 'ordering'
  23. SELECT *
      FROM jos_menu
      WHERE id = '224'
  24. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  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='164'
      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=164
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY p.product_name ASC
      LIMIT 0, 200
  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=164
      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=164
      AND published = 1
      ORDER BY c.category_name ASC
  29. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '164'
  30. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=164%')
      ORDER BY 'ordering'
  31. SELECT *
      FROM jos_menu
      WHERE id = '224'
  32. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  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='164'
      AND c.category_id = cx.category_parent_id
  34. 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=7820
      AND p.published = 1
      ORDER BY a.ordering ASC
  35. 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=7820
      AND t.published = 1
      LIMIT 0,1
  36. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  37. SELECT *
      FROM jos_menu
      WHERE id = '224'
  38. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7820'
  39. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7820'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  40. 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='164'
      AND c.category_id = cx.category_parent_id
  41. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  42. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  43. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7820'
      AND section='1'
  44. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7820
  45. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7820
      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
  46. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  47. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  48. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7820
  49. 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
  50. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7820
  51. 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
  52. 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'
  53. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7820
  54. 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
  55. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7820
  56. 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
  57. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7820
      AND ps.stockroom_id = s.stockroom_id
  58. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7820
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  59. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7820
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  60. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7820
  61. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7820
      AND ps.stockroom_id = s.stockroom_id
  62. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  63. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7820"
      AND media_type="images" 
      AND media_name = "1515527985_FTN_H_2702.jpg"
  64. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  65. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7820
      AND ps.stockroom_id = s.stockroom_id
  66. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  67. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7820
  68. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7820
      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
  69. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  70. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  71. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7820
  72. 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
  73. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7820
  74. 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
  75. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7820
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  76. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7820
      AND ps.stockroom_id = s.stockroom_id
  77. 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'
  78. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7820
  79. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7820
      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
  80. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  81. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  82. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7820
  83. 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
  84. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7820
  85. 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
  86. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7820
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  87. 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=7821
      AND p.published = 1
      ORDER BY a.ordering ASC
  88. 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=7821
      AND t.published = 1
      LIMIT 0,1
  89. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  90. SELECT *
      FROM jos_menu
      WHERE id = '224'
  91. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7821'
  92. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7821'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  93. 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='164'
      AND c.category_id = cx.category_parent_id
  94. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  95. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  96. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7821'
      AND section='1'
  97. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7821
  98. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7821
      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
  99. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  100. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  101. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7821
  102. 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
  103. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7821
  104. 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
  105. 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'
  106. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7821
  107. 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
  108. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7821
  109. 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
  110. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7821
      AND ps.stockroom_id = s.stockroom_id
  111. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7821
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  112. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7821
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  113. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7821
  114. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7821
      AND ps.stockroom_id = s.stockroom_id
  115. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  116. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7821"
      AND media_type="images" 
      AND media_name = "1515528095_FTN_H_2703.jpg"
  117. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  118. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7821
      AND ps.stockroom_id = s.stockroom_id
  119. 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'
  120. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7821
  121. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7821
      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
  122. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  123. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  124. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7821
  125. 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
  126. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7821
  127. 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
  128. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7821
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  129. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7821
      AND ps.stockroom_id = s.stockroom_id
  130. 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'
  131. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7821
  132. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7821
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  133. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  134. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  135. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7821
  136. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  137. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7821
  138. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  139. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7821
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  140. 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=7822
      AND p.published = 1
      ORDER BY a.ordering ASC
  141. 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=7822
      AND t.published = 1
      LIMIT 0,1
  142. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  143. SELECT *
      FROM jos_menu
      WHERE id = '224'
  144. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7822'
  145. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7822'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  146. 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='164'
      AND c.category_id = cx.category_parent_id
  147. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  148. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  149. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7822'
      AND section='1'
  150. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7822
  151. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7822
      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
  152. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  153. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  154. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7822
  155. 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
  156. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7822
  157. 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
  158. 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'
  159. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7822
  160. 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
  161. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7822
  162. 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
  163. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7822
      AND ps.stockroom_id = s.stockroom_id
  164. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7822
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  165. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7822
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  166. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7822
  167. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7822
      AND ps.stockroom_id = s.stockroom_id
  168. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  169. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7822"
      AND media_type="images" 
      AND media_name = "1515528155_FTN_H_2704.jpg"
  170. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  171. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7822
      AND ps.stockroom_id = s.stockroom_id
  172. 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'
  173. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7822
  174. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7822
      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
  175. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  176. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  177. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7822
  178. 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
  179. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7822
  180. 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
  181. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7822
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  182. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7822
      AND ps.stockroom_id = s.stockroom_id
  183. 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'
  184. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7822
  185. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7822
      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
  186. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  187. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  188. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7822
  189. 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
  190. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7822
  191. 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
  192. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7822
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  193. 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=7823
      AND p.published = 1
      ORDER BY a.ordering ASC
  194. 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=7823
      AND t.published = 1
      LIMIT 0,1
  195. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  196. SELECT *
      FROM jos_menu
      WHERE id = '224'
  197. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7823'
  198. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7823'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  199. 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='164'
      AND c.category_id = cx.category_parent_id
  200. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  201. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  202. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7823'
      AND section='1'
  203. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7823
  204. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7823
      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
  205. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  206. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  207. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7823
  208. 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
  209. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7823
  210. 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
  211. 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'
  212. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7823
  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 = 7823
  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 sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7823
      AND ps.stockroom_id = s.stockroom_id
  217. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7823
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  218. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7823
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  219. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7823
  220. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7823
      AND ps.stockroom_id = s.stockroom_id
  221. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  222. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7823"
      AND media_type="images" 
      AND media_name = "1515528217_FTN_H_2706.jpg"
  223. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  224. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7823
      AND ps.stockroom_id = s.stockroom_id
  225. 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'
  226. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7823
  227. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7823
      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
  228. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  229. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  230. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7823
  231. 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
  232. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7823
  233. 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
  234. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7823
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  235. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7823
      AND ps.stockroom_id = s.stockroom_id
  236. 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'
  237. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7823
  238. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7823
      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
  239. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  240. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  241. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7823
  242. 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
  243. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7823
  244. 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
  245. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7823
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  246. 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=7824
      AND p.published = 1
      ORDER BY a.ordering ASC
  247. 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=7824
      AND t.published = 1
      LIMIT 0,1
  248. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  249. SELECT *
      FROM jos_menu
      WHERE id = '224'
  250. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7824'
  251. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7824'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  252. 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='164'
      AND c.category_id = cx.category_parent_id
  253. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  254. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  255. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7824'
      AND section='1'
  256. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7824
  257. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7824
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  258. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  259. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  260. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7824
  261. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  262. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7824
  263. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  264. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  265. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7824
  266. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  267. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7824
  268. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  269. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7824
      AND ps.stockroom_id = s.stockroom_id
  270. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7824
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  271. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7824
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  272. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7824
  273. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7824
      AND ps.stockroom_id = s.stockroom_id
  274. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  275. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7824"
      AND media_type="images" 
      AND media_name = "1515528286_FTN_H_2709.jpg"
  276. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  277. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7824
      AND ps.stockroom_id = s.stockroom_id
  278. 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'
  279. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7824
  280. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7824
      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
  281. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  282. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  283. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7824
  284. 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
  285. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7824
  286. 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
  287. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7824
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  288. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7824
      AND ps.stockroom_id = s.stockroom_id
  289. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  290. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7824
  291. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7824
      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
  292. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  293. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  294. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7824
  295. 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
  296. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7824
  297. 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
  298. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7824
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  299. 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=7825
      AND p.published = 1
      ORDER BY a.ordering ASC
  300. 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=7825
      AND t.published = 1
      LIMIT 0,1
  301. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  302. SELECT *
      FROM jos_menu
      WHERE id = '224'
  303. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7825'
  304. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7825'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  305. 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='164'
      AND c.category_id = cx.category_parent_id
  306. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  307. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  308. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7825'
      AND section='1'
  309. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7825
  310. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7825
      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
  311. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  312. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  313. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7825
  314. 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
  315. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7825
  316. 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
  317. 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'
  318. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7825
  319. 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
  320. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7825
  321. 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
  322. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7825
      AND ps.stockroom_id = s.stockroom_id
  323. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7825
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  324. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7825
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  325. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7825
  326. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7825
      AND ps.stockroom_id = s.stockroom_id
  327. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  328. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7825"
      AND media_type="images" 
      AND media_name = "1515528358_FTN_H_2711.jpg"
  329. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  330. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7825
      AND ps.stockroom_id = s.stockroom_id
  331. 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'
  332. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7825
  333. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7825
      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
  334. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  335. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  336. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7825
  337. 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
  338. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7825
  339. 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
  340. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7825
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  341. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7825
      AND ps.stockroom_id = s.stockroom_id
  342. 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'
  343. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7825
  344. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7825
      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
  345. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  346. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  347. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7825
  348. 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
  349. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7825
  350. 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
  351. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7825
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  352. 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=7826
      AND p.published = 1
      ORDER BY a.ordering ASC
  353. 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=7826
      AND t.published = 1
      LIMIT 0,1
  354. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  355. SELECT *
      FROM jos_menu
      WHERE id = '224'
  356. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7826'
  357. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7826'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  358. 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='164'
      AND c.category_id = cx.category_parent_id
  359. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  360. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  361. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7826'
      AND section='1'
  362. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7826
  363. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7826
      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
  364. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  365. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790516'
      AND end_date >= '1739790516' 
      ORDER BY amount DESC
      LIMIT 0,1
  366. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7826
  367. 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
  368. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7826
  369. 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
  370. 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'
  371. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7826
  372. 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
  373. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7826
  374. 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
  375. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7826
      AND ps.stockroom_id = s.stockroom_id
  376. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7826
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  377. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7826
      AND discount_enddate>='1739790516'
      AND discount_stratdate<='1739790516'
  378. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7826
  379. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7826
      AND ps.stockroom_id = s.stockroom_id
  380. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  381. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7826"
      AND media_type="images" 
      AND media_name = "1515529696_FTN_H_2712.jpg"
  382. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  383. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7826
      AND ps.stockroom_id = s.stockroom_id
  384. 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'
  385. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7826
  386. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7826
      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
  387. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  388. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  389. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7826
  390. 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
  391. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7826
  392. 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
  393. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7826
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  394. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7826
      AND ps.stockroom_id = s.stockroom_id
  395. 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'
  396. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7826
  397. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7826
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  398. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  399. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  400. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7826
  401. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  402. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7826
  403. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  404. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7826
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  405. 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=7827
      AND p.published = 1
      ORDER BY a.ordering ASC
  406. 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=7827
      AND t.published = 1
      LIMIT 0,1
  407. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  408. SELECT *
      FROM jos_menu
      WHERE id = '224'
  409. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7827'
  410. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7827'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  411. 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='164'
      AND c.category_id = cx.category_parent_id
  412. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  413. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  414. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7827'
      AND section='1'
  415. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7827
  416. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7827
      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
  417. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  418. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  419. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7827
  420. 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
  421. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7827
  422. 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
  423. 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'
  424. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7827
  425. 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
  426. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7827
  427. 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
  428. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7827
      AND ps.stockroom_id = s.stockroom_id
  429. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7827
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  430. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7827
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  431. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7827
  432. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7827
      AND ps.stockroom_id = s.stockroom_id
  433. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  434. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7827"
      AND media_type="images" 
      AND media_name = "1515529803_FTN_H_2714.jpg"
  435. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  436. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7827
      AND ps.stockroom_id = s.stockroom_id
  437. 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'
  438. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7827
  439. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7827
      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
  440. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  441. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  442. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7827
  443. 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
  444. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7827
  445. 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
  446. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7827
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  447. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7827
      AND ps.stockroom_id = s.stockroom_id
  448. 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'
  449. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7827
  450. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7827
      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
  451. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  452. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  453. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7827
  454. 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
  455. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7827
  456. 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
  457. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7827
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  458. 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=7828
      AND p.published = 1
      ORDER BY a.ordering ASC
  459. 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=7828
      AND t.published = 1
      LIMIT 0,1
  460. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  461. SELECT *
      FROM jos_menu
      WHERE id = '224'
  462. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7828'
  463. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7828'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  464. 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='164'
      AND c.category_id = cx.category_parent_id
  465. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  466. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  467. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7828'
      AND section='1'
  468. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7828
  469. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7828
      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
  470. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  471. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  472. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7828
  473. 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
  474. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7828
  475. 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
  476. 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'
  477. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7828
  478. 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
  479. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7828
  480. 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
  481. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7828
      AND ps.stockroom_id = s.stockroom_id
  482. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7828
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  483. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7828
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  484. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7828
  485. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7828
      AND ps.stockroom_id = s.stockroom_id
  486. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  487. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7828"
      AND media_type="images" 
      AND media_name = "1515530165_FTN_H_2715.jpg"
  488. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  489. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7828
      AND ps.stockroom_id = s.stockroom_id
  490. 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'
  491. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7828
  492. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7828
      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
  493. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  494. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  495. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7828
  496. 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
  497. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7828
  498. 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
  499. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7828
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  500. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7828
      AND ps.stockroom_id = s.stockroom_id
  501. 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'
  502. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7828
  503. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7828
      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
  504. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  505. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  506. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7828
  507. 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
  508. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7828
  509. 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
  510. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7828
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  511. 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=7829
      AND p.published = 1
      ORDER BY a.ordering ASC
  512. 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=7829
      AND t.published = 1
      LIMIT 0,1
  513. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  514. SELECT *
      FROM jos_menu
      WHERE id = '224'
  515. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7829'
  516. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7829'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  517. 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='164'
      AND c.category_id = cx.category_parent_id
  518. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  519. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  520. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7829'
      AND section='1'
  521. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7829
  522. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7829
      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
  523. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  524. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  525. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7829
  526. 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
  527. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7829
  528. 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
  529. 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'
  530. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7829
  531. 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
  532. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7829
  533. 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
  534. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7829
      AND ps.stockroom_id = s.stockroom_id
  535. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7829
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  536. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7829
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  537. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7829
  538. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7829
      AND ps.stockroom_id = s.stockroom_id
  539. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  540. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7829"
      AND media_type="images" 
      AND media_name = "1515530237_FTN_H_2717.jpg"
  541. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  542. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7829
      AND ps.stockroom_id = s.stockroom_id
  543. 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'
  544. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7829
  545. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7829
      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
  546. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  547. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  548. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7829
  549. 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
  550. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7829
  551. 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
  552. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7829
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  553. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7829
      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 = 7829
  556. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7829
      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 <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  559. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7829
  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 = 7829
  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 = 7829
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  564. 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=7830
      AND p.published = 1
      ORDER BY a.ordering ASC
  565. 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=7830
      AND t.published = 1
      LIMIT 0,1
  566. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  567. SELECT *
      FROM jos_menu
      WHERE id = '224'
  568. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7830'
  569. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7830'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  570. 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='164'
      AND c.category_id = cx.category_parent_id
  571. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  572. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  573. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7830'
      AND section='1'
  574. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7830
  575. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7830
      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
  576. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  577. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  578. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7830
  579. 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
  580. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7830
  581. 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
  582. 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'
  583. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7830
  584. 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
  585. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7830
  586. 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
  587. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7830
      AND ps.stockroom_id = s.stockroom_id
  588. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7830
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  589. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7830
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  590. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7830
  591. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7830
      AND ps.stockroom_id = s.stockroom_id
  592. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  593. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7830"
      AND media_type="images" 
      AND media_name = "1515530315_FTN_H_2719.jpg"
  594. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  595. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7830
      AND ps.stockroom_id = s.stockroom_id
  596. 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'
  597. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7830
  598. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7830
      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
  599. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  600. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  601. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7830
  602. 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
  603. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7830
  604. 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
  605. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7830
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  606. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7830
      AND ps.stockroom_id = s.stockroom_id
  607. 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'
  608. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7830
  609. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7830
      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
  610. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  611. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  612. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7830
  613. 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
  614. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7830
  615. 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
  616. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7830
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  617. 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=7831
      AND p.published = 1
      ORDER BY a.ordering ASC
  618. 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=7831
      AND t.published = 1
      LIMIT 0,1
  619. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  620. SELECT *
      FROM jos_menu
      WHERE id = '224'
  621. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7831'
  622. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7831'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  623. 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='164'
      AND c.category_id = cx.category_parent_id
  624. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  625. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  626. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7831'
      AND section='1'
  627. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7831
  628. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7831
      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
  629. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  630. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  631. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7831
  632. 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
  633. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7831
  634. 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
  635. 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'
  636. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7831
  637. 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
  638. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7831
  639. 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
  640. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7831
      AND ps.stockroom_id = s.stockroom_id
  641. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7831
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  642. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7831
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  643. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7831
  644. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7831
      AND ps.stockroom_id = s.stockroom_id
  645. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  646. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7831"
      AND media_type="images" 
      AND media_name = "1515530433_FTN_H_2722.jpg"
  647. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  648. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7831
      AND ps.stockroom_id = s.stockroom_id
  649. 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'
  650. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7831
  651. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7831
      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
  652. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  653. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  654. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7831
  655. 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
  656. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7831
  657. 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
  658. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7831
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  659. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7831
      AND ps.stockroom_id = s.stockroom_id
  660. 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'
  661. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7831
  662. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7831
      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
  663. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  664. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  665. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7831
  666. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  667. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7831
  668. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  669. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7831
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  670. 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=7832
      AND p.published = 1
      ORDER BY a.ordering ASC
  671. 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=7832
      AND t.published = 1
      LIMIT 0,1
  672. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  673. SELECT *
      FROM jos_menu
      WHERE id = '224'
  674. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7832'
  675. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7832'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  676. 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='164'
      AND c.category_id = cx.category_parent_id
  677. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  678. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  679. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7832'
      AND section='1'
  680. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7832
  681. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7832
      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
  682. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  683. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  684. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7832
  685. 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
  686. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7832
  687. 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
  688. 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'
  689. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7832
  690. 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
  691. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7832
  692. 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
  693. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7832
      AND ps.stockroom_id = s.stockroom_id
  694. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7832
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  695. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7832
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  696. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7832
  697. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7832
      AND ps.stockroom_id = s.stockroom_id
  698. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  699. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7832"
      AND media_type="images" 
      AND media_name = "1515530573_FTN_H_2724.jpg"
  700. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  701. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7832
      AND ps.stockroom_id = s.stockroom_id
  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 p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7832
  704. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7832
      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
  705. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  706. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  707. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7832
  708. 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
  709. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7832
  710. 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
  711. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7832
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  712. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7832
      AND ps.stockroom_id = s.stockroom_id
  713. 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'
  714. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7832
  715. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7832
      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
  716. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  717. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  718. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7832
  719. 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
  720. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7832
  721. 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
  722. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7832
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  723. 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=7833
      AND p.published = 1
      ORDER BY a.ordering ASC
  724. 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=7833
      AND t.published = 1
      LIMIT 0,1
  725. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  726. SELECT *
      FROM jos_menu
      WHERE id = '224'
  727. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7833'
  728. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7833'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  729. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='164'
      AND c.category_id = cx.category_parent_id
  730. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  731. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  732. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7833'
      AND section='1'
  733. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7833
  734. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7833
      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
  735. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  736. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  737. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7833
  738. 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
  739. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7833
  740. 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
  741. 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'
  742. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7833
  743. 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
  744. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7833
  745. 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
  746. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7833
      AND ps.stockroom_id = s.stockroom_id
  747. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7833
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  748. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7833
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  749. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7833
  750. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7833
      AND ps.stockroom_id = s.stockroom_id
  751. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  752. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7833"
      AND media_type="images" 
      AND media_name = "1515530893_FTN_H_2725.jpg"
  753. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  754. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7833
      AND ps.stockroom_id = s.stockroom_id
  755. 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'
  756. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7833
  757. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7833
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  758. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  759. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  760. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7833
  761. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  762. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7833
  763. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  764. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7833
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  765. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7833
      AND ps.stockroom_id = s.stockroom_id
  766. 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'
  767. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7833
  768. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7833
      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
  769. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  770. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  771. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7833
  772. 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
  773. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7833
  774. 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
  775. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7833
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  776. 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=7834
      AND p.published = 1
      ORDER BY a.ordering ASC
  777. 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=7834
      AND t.published = 1
      LIMIT 0,1
  778. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  779. SELECT *
      FROM jos_menu
      WHERE id = '224'
  780. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7834'
  781. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7834'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  782. 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='164'
      AND c.category_id = cx.category_parent_id
  783. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  784. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  785. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7834'
      AND section='1'
  786. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7834
  787. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7834
      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
  788. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  789. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  790. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7834
  791. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  792. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7834
  793. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  794. SELECT 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'
  795. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7834
  796. 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
  797. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7834
  798. 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
  799. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7834
      AND ps.stockroom_id = s.stockroom_id
  800. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7834
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  801. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7834
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  802. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7834
  803. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7834
      AND ps.stockroom_id = s.stockroom_id
  804. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  805. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7834"
      AND media_type="images" 
      AND media_name = "1515532656_FTN_H_2727.jpg"
  806. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  807. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7834
      AND ps.stockroom_id = s.stockroom_id
  808. 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'
  809. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7834
  810. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7834
      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
  811. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  812. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  813. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7834
  814. 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
  815. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7834
  816. 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
  817. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7834
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  818. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7834
      AND ps.stockroom_id = s.stockroom_id
  819. 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'
  820. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7834
  821. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7834
      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
  822. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  823. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  824. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7834
  825. 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
  826. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7834
  827. 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
  828. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7834
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  829. 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=7835
      AND p.published = 1
      ORDER BY a.ordering ASC
  830. 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=7835
      AND t.published = 1
      LIMIT 0,1
  831. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  832. SELECT *
      FROM jos_menu
      WHERE id = '224'
  833. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7835'
  834. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7835'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  835. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='164'
      AND c.category_id = cx.category_parent_id
  836. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  837. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  838. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7835'
      AND section='1'
  839. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7835
  840. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7835
      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
  841. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  842. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  843. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7835
  844. 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
  845. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7835
  846. 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
  847. 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'
  848. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7835
  849. 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
  850. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7835
  851. 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
  852. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7835
      AND ps.stockroom_id = s.stockroom_id
  853. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7835
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  854. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7835
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  855. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7835
  856. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7835
      AND ps.stockroom_id = s.stockroom_id
  857. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  858. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7835"
      AND media_type="images" 
      AND media_name = "1515532762_FTN_H_2728.jpg"
  859. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  860. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7835
      AND ps.stockroom_id = s.stockroom_id
  861. 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'
  862. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7835
  863. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7835
      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
  864. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  865. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  866. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7835
  867. 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
  868. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7835
  869. 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
  870. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7835
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  871. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7835
      AND ps.stockroom_id = s.stockroom_id
  872. 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'
  873. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7835
  874. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7835
      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
  875. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  876. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  877. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7835
  878. 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
  879. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7835
  880. 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
  881. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7835
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  882. 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=7836
      AND p.published = 1
      ORDER BY a.ordering ASC
  883. 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=7836
      AND t.published = 1
      LIMIT 0,1
  884. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  885. SELECT *
      FROM jos_menu
      WHERE id = '224'
  886. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7836'
  887. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7836'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  888. 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='164'
      AND c.category_id = cx.category_parent_id
  889. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  890. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  891. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7836'
      AND section='1'
  892. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7836
  893. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7836
      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
  894. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  895. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  896. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7836
  897. 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
  898. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7836
  899. 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
  900. 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'
  901. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7836
  902. 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
  903. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7836
  904. 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
  905. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7836
      AND ps.stockroom_id = s.stockroom_id
  906. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7836
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  907. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7836
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  908. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7836
  909. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7836
      AND ps.stockroom_id = s.stockroom_id
  910. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  911. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7836"
      AND media_type="images" 
      AND media_name = "1515533171_FTN_H_2738.jpg"
  912. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  913. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7836
      AND ps.stockroom_id = s.stockroom_id
  914. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  915. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7836
  916. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7836
      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
  917. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  918. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  919. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7836
  920. 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
  921. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7836
  922. 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
  923. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7836
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  924. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7836
      AND ps.stockroom_id = s.stockroom_id
  925. 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'
  926. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7836
  927. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7836
      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
  928. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  929. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  930. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7836
  931. 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
  932. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7836
  933. 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
  934. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7836
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  935. 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=7837
      AND p.published = 1
      ORDER BY a.ordering ASC
  936. 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=7837
      AND t.published = 1
      LIMIT 0,1
  937. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  938. SELECT *
      FROM jos_menu
      WHERE id = '224'
  939. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7837'
  940. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7837'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  941. 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='164'
      AND c.category_id = cx.category_parent_id
  942. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  943. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  944. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7837'
      AND section='1'
  945. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7837
  946. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7837
      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
  947. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  948. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  949. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7837
  950. 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
  951. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7837
  952. 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
  953. 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'
  954. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7837
  955. 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
  956. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7837
  957. 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
  958. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7837
      AND ps.stockroom_id = s.stockroom_id
  959. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7837
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  960. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7837
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  961. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7837
  962. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7837
      AND ps.stockroom_id = s.stockroom_id
  963. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  964. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7837"
      AND media_type="images" 
      AND media_name = "1515533253_FTN_H_2742.jpg"
  965. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  966. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7837
      AND ps.stockroom_id = s.stockroom_id
  967. 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'
  968. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7837
  969. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7837
      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
  970. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  971. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  972. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7837
  973. 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
  974. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7837
  975. 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
  976. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7837
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  977. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7837
      AND ps.stockroom_id = s.stockroom_id
  978. 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'
  979. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7837
  980. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7837
      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
  981. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  982. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  983. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7837
  984. 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
  985. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7837
  986. 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
  987. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7837
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  988. 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=7838
      AND p.published = 1
      ORDER BY a.ordering ASC
  989. 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=7838
      AND t.published = 1
      LIMIT 0,1
  990. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  991. SELECT *
      FROM jos_menu
      WHERE id = '224'
  992. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7838'
  993. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7838'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  994. 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='164'
      AND c.category_id = cx.category_parent_id
  995. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  996. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  997. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7838'
      AND section='1'
  998. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7838
  999. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7838
      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
  1000. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1001. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  1002. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7838
  1003. 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
  1004. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7838
  1005. 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
  1006. 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'
  1007. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7838
  1008. 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
  1009. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7838
  1010. 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
  1011. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7838
      AND ps.stockroom_id = s.stockroom_id
  1012. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7838
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  1013. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7838
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  1014. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7838
  1015. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7838
      AND ps.stockroom_id = s.stockroom_id
  1016. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  1017. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7838"
      AND media_type="images" 
      AND media_name = "1515533313_FTN_H_2743.jpg"
  1018. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  1019. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7838
      AND ps.stockroom_id = s.stockroom_id
  1020. 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'
  1021. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7838
  1022. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7838
      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
  1023. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1024. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  1025. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7838
  1026. 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
  1027. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7838
  1028. 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
  1029. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7838
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  1030. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7838
      AND ps.stockroom_id = s.stockroom_id
  1031. 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'
  1032. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7838
  1033. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7838
      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
  1034. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1035. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  1036. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7838
  1037. 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
  1038. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7838
  1039. 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
  1040. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7838
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  1041. 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=7839
      AND p.published = 1
      ORDER BY a.ordering ASC
  1042. 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=7839
      AND t.published = 1
      LIMIT 0,1
  1043. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  1044. SELECT *
      FROM jos_menu
      WHERE id = '224'
  1045. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7839'
  1046. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7839'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  1047. 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='164'
      AND c.category_id = cx.category_parent_id
  1048. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  1049. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  1050. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7839'
      AND section='1'
  1051. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7839
  1052. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7839
      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
  1053. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1054. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  1055. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7839
  1056. 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
  1057. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7839
  1058. 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
  1059. 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'
  1060. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7839
  1061. 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
  1062. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7839
  1063. 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
  1064. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7839
      AND ps.stockroom_id = s.stockroom_id
  1065. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7839
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  1066. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7839
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  1067. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7839
  1068. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7839
      AND ps.stockroom_id = s.stockroom_id
  1069. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  1070. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7839"
      AND media_type="images" 
      AND media_name = "1515533539_FTN_H_2748.jpg"
  1071. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  1072. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7839
      AND ps.stockroom_id = s.stockroom_id
  1073. 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'
  1074. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7839
  1075. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7839
      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
  1076. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1077. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  1078. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7839
  1079. 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
  1080. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7839
  1081. 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
  1082. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7839
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  1083. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7839
      AND ps.stockroom_id = s.stockroom_id
  1084. 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'
  1085. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7839
  1086. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7839
      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
  1087. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1088. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  1089. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7839
  1090. 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
  1091. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7839
  1092. 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
  1093. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7839
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  1094. 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=7840
      AND p.published = 1
      ORDER BY a.ordering ASC
  1095. 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=7840
      AND t.published = 1
      LIMIT 0,1
  1096. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  1097. SELECT *
      FROM jos_menu
      WHERE id = '224'
  1098. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7840'
  1099. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7840'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  1100. 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='164'
      AND c.category_id = cx.category_parent_id
  1101. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  1102. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  1103. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7840'
      AND section='1'
  1104. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7840
  1105. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7840
      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
  1106. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1107. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  1108. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7840
  1109. 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
  1110. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7840
  1111. 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
  1112. 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'
  1113. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7840
  1114. 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
  1115. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7840
  1116. 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
  1117. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7840
      AND ps.stockroom_id = s.stockroom_id
  1118. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7840
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  1119. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7840
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  1120. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7840
  1121. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7840
      AND ps.stockroom_id = s.stockroom_id
  1122. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  1123. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7840"
      AND media_type="images" 
      AND media_name = "1515533640_FTN_H_2749.jpg"
  1124. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  1125. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7840
      AND ps.stockroom_id = s.stockroom_id
  1126. 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'
  1127. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7840
  1128. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7840
      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
  1129. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1130. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  1131. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7840
  1132. 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
  1133. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7840
  1134. 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
  1135. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7840
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  1136. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7840
      AND ps.stockroom_id = s.stockroom_id
  1137. 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'
  1138. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7840
  1139. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7840
      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
  1140. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1141. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  1142. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7840
  1143. 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
  1144. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7840
  1145. 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
  1146. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7840
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  1147. 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=7841
      AND p.published = 1
      ORDER BY a.ordering ASC
  1148. 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=7841
      AND t.published = 1
      LIMIT 0,1
  1149. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  1150. SELECT *
      FROM jos_menu
      WHERE id = '224'
  1151. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7841'
  1152. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7841'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  1153. 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='164'
      AND c.category_id = cx.category_parent_id
  1154. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  1155. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  1156. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7841'
      AND section='1'
  1157. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7841
  1158. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7841
      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
  1159. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1160. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  1161. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7841
  1162. 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
  1163. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7841
  1164. 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
  1165. 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'
  1166. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7841
  1167. 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
  1168. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7841
  1169. 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
  1170. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7841
      AND ps.stockroom_id = s.stockroom_id
  1171. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7841
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  1172. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7841
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  1173. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 7841
  1174. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7841
      AND ps.stockroom_id = s.stockroom_id
  1175. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  1176. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="7841"
      AND media_type="images" 
      AND media_name = "1515533715_FTN_H_2750.jpg"
  1177. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  1178. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7841
      AND ps.stockroom_id = s.stockroom_id
  1179. 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'
  1180. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7841
  1181. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7841
      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
  1182. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1183. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  1184. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7841
  1185. 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
  1186. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7841
  1187. 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
  1188. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7841
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  1189. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7841
      AND ps.stockroom_id = s.stockroom_id
  1190. 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'
  1191. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7841
  1192. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7841
      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
  1193. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1194. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  1195. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7841
  1196. 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
  1197. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7841
  1198. 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
  1199. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7841
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  1200. 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=7797
      AND p.published = 1
      ORDER BY a.ordering ASC
  1201. 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=7797
      AND t.published = 1
      LIMIT 0,1
  1202. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  1203. SELECT *
      FROM jos_menu
      WHERE id = '224'
  1204. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '7797'
  1205. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '7797'
      AND pc.category_id = c.category_id 
      AND c.category_id = '164'
  1206. 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='164'
      AND c.category_id = cx.category_parent_id
  1207. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
  1208. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  1209. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='7797'
      AND section='1'
  1210. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 7797
  1211. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7797
      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
  1212. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  1213. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739790517'
      AND end_date >= '1739790517' 
      ORDER BY amount DESC
      LIMIT 0,1
  1214. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7797
  1215. 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
  1216. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7797
  1217. 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
  1218. 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'
  1219. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7797
  1220. 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
  1221. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7797
  1222. 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
  1223. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 7797
      AND ps.stockroom_id = s.stockroom_id
  1224. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 7797
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  1225. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 7797
      AND discount_enddate>='1739790517'
      AND discount_stratdate<='1739790517'
  1226. SELECT
      FROM jos_redshop_