DELETE
FROM jos_session
WHERE ( time < '1739780659' )
SELECT *
FROM jos_session
WHERE session_id = 'ueaqf2jurhum6t9ea04a1tqoi1'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'ueaqf2jurhum6t9ea04a1tqoi1','1739787859','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
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
SELECT *
FROM jos_redshop_configuration
SELECT *
FROM jos_redshop_catalog_request
WHERE block = 0
SELECT *
FROM jos_redshop_sample_request
WHERE block = 0
SELECT count(id)
FROM jos_redshop_cron
WHERE date = '2025-02-17'
SELECT *
FROM jos_redshop_siteviewer
WHERE session_id = 'ueaqf2jurhum6t9ea04a1tqoi1'
INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
VALUES ('ueaqf2jurhum6t9ea04a1tqoi1', '0','1739787860')
SELECT *
FROM jos_redshop_pageviewer
WHERE session_id = 'ueaqf2jurhum6t9ea04a1tqoi1'
AND section='manufacturers'
AND section_id='23'
INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
VALUES ('ueaqf2jurhum6t9ea04a1tqoi1','0','manufacturers','23','1739787861')
SELECT sg.*
FROM `jos_redshop_shopper_group` AS sg
WHERE sg.`shopper_group_id` = 0
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 258)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT mn.*, m.media_name,m.section_id
FROM jos_redshop_manufacturer AS mn
LEFT JOIN jos_redshop_media AS m
ON m.section_id=mn.manufacturer_id
AND m.published = 1
AND m.media_section='manufacturer'
WHERE mn.published = 1
AND mn.manufacturer_id='23'
SELECT *
FROM jos_menu
WHERE link LIKE '%com_redshop%'
AND published=1
AND id = '258'
SELECT *
FROM jos_menu
WHERE link LIKE '%com_redshop%'
AND published=1
AND link LIKE '%view=manufacturers%'
AND params LIKE '%manufacturerid=23
%'
SELECT *
FROM jos_redshop_manufacturer
WHERE manufacturer_id = 23
SELECT *
FROM jos_redshop_manufacturer
WHERE published = 1
SELECT DISTINCT(p.product_id),p.product_number,p.product_name,p.product_price,p.product_s_desc,p.product_thumb_image,p.product_full_image , c.category_name
FROM jos_redshop_product AS p , jos_redshop_manufacturer AS m , jos_redshop_category AS c , jos_redshop_product_category_xref AS pc
WHERE p.published=1
AND p.manufacturer_id=23
AND p.manufacturer_id=m.manufacturer_id
AND p.product_id = pc.product_id
AND p.expired = 0
AND p.product_parent_id = 0
AND pc.category_id = c.category_id
GROUP BY p.product_id
ORDER BY p.product_id DESC
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'manufacturer_products'
AND published=1
AND template_id='14'
LIMIT 0,1
SELECT category_id AS value, category_name AS text
FROM jos_redshop_category
WHERE published = '1'
ORDER BY category_name ASC
SELECT DISTINCT(p.product_id),p.product_number,p.product_name,p.product_price,p.product_s_desc,p.product_thumb_image,p.product_full_image , c.category_name
FROM jos_redshop_product AS p , jos_redshop_manufacturer AS m , jos_redshop_category AS c , jos_redshop_product_category_xref AS pc
WHERE p.published=1
AND p.manufacturer_id=23
AND p.manufacturer_id=m.manufacturer_id
AND p.product_id = pc.product_id
AND p.expired = 0
AND p.product_parent_id = 0
AND pc.category_id = c.category_id
GROUP BY p.product_id
ORDER BY p.product_id DESC
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16653'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16653'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16653
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16653
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16653
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16653
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16653
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16653
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16653
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16653
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16653
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16653
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16653
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16653"
AND media_type="images"
AND media_name = "energy/91985.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16652'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16652'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16652
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16652
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16652
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16652
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16652
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16652
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16652
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16652
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16652
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16652
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16652
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16652"
AND media_type="images"
AND media_name = "energy/91984.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16651'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16651'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16651
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16651
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16651
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16651
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16651
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16651
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16651
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16651
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16651
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16651
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16651
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16651"
AND media_type="images"
AND media_name = "energy/91983.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16650'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16650'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16650
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16650
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16650
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16650
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16650
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16650
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16650
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16650
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16650
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16650
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16650
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16650"
AND media_type="images"
AND media_name = "energy/91982.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16649'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16649'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16649
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16649
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16649
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16649
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16649
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16649
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16649
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16649
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16649
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16649
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16649
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16649"
AND media_type="images"
AND media_name = "energy/91981.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16648'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16648'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16648
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16648
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16648
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16648
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16648
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16648
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16648
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16648
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16648
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16648
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16648
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16648"
AND media_type="images"
AND media_name = "energy/91980.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16647'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16647'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16647
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16647
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16647
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16647
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16647
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16647
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16647
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16647
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16647
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16647
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16647
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16647"
AND media_type="images"
AND media_name = "energy/91979.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16646'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16646'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16646
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16646
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16646
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16646
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16646
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16646
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16646
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16646
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16646
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16646
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16646
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16646"
AND media_type="images"
AND media_name = "energy/91978.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16645'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16645'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16645
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16645
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16645
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16645
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16645
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16645
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16645
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16645
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16645
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16645
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16645
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16645"
AND media_type="images"
AND media_name = "energy/91977.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16644'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16644'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16644
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16644
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16644
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16644
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16644
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16644
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16644
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16644
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16644
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16644
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16644
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16644"
AND media_type="images"
AND media_name = "energy/91976.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16643'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16643'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16643
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16643
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16643
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16643
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16643
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16643
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16643
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16643
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16643
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16643
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16643
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16643"
AND media_type="images"
AND media_name = "energy/91975.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16642'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16642'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16642
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16642
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16642
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16642
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16642
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16642
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16642
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16642
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16642
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16642
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16642
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16642"
AND media_type="images"
AND media_name = "energy/91974.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16641'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16641'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16641
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16641
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16641
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16641
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16641
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16641
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16641
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16641
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16641
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16641
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16641
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16641"
AND media_type="images"
AND media_name = "energy/91973.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16640'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16640'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16640
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16640
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16640
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16640
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16640
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16640
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16640
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16640
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16640
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16640
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16640
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16640"
AND media_type="images"
AND media_name = "energy/91972.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16639'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16639'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16639
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16639
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16639
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16639
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16639
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16639
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16639
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16639
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16639
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16639
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16639
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16639"
AND media_type="images"
AND media_name = "energy/91971.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16638'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16638'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16638
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16638
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16638
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16638
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16638
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16638
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16638
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16638
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16638
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16638
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16638
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16638"
AND media_type="images"
AND media_name = "energy/91970.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16637'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16637'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16637
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16637
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16637
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16637
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16637
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16637
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16637
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16637
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16637
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16637
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16637
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16637"
AND media_type="images"
AND media_name = "energy/91969.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16636'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16636'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16636
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16636
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16636
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16636
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16636
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16636
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16636
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16636
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16636
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16636
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16636
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16636"
AND media_type="images"
AND media_name = "energy/91968.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16635'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16635'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16635
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16635
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16635
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16635
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16635
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16635
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16635
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16635
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16635
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16635
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16635
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16635"
AND media_type="images"
AND media_name = "energy/91967.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16634'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16634'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16634
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16634
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16634
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16634
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16634
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16634
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16634
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16634
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16634
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16634
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16634
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16634"
AND media_type="images"
AND media_name = "energy/91966.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16633'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16633'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16633
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16633
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16633
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16633
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16633
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16633
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16633
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16633
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16633
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16633
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16633
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16633"
AND media_type="images"
AND media_name = "energy/91965.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16632'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16632'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16632
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16632
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16632
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16632
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16632
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16632
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16632
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16632
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16632
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16632
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16632
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16632"
AND media_type="images"
AND media_name = "energy/91964.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16631'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16631'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16631
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16631
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16631
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16631
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16631
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16631
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16631
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16631
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16631
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16631
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16631
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16631"
AND media_type="images"
AND media_name = "energy/91963.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16630'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16630'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16630
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16630
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16630
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16630
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16630
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16630
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16630
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16630
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16630
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16630
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16630
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16630"
AND media_type="images"
AND media_name = "energy/91962.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16629'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16629'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16629
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16629
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16629
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16629
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16629
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16629
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16629
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16629
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16629
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16629
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16629
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16629"
AND media_type="images"
AND media_name = "energy/91961.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16628'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16628'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16628
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16628
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16628
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16628
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16628
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16628
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16628
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16628
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16628
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16628
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16628
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16628"
AND media_type="images"
AND media_name = "energy/91960.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16627'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16627'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16627
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16627
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16627
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16627
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16627
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16627
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16627
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16627
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16627
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16627
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16627
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16627"
AND media_type="images"
AND media_name = "energy/91959.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16626'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16626'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16626
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16626
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16626
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16626
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16626
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16626
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16626
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16626
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16626
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16626
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16626
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16626"
AND media_type="images"
AND media_name = "energy/91958.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16625'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16625'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16625
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16625
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16625
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16625
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16625
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16625
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16625
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16625
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16625
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16625
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16625
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16625"
AND media_type="images"
AND media_name = "energy/91957.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16624'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16624'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16624
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16624
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16624
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16624
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16624
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16624
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16624
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16624
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16624
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16624
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16624
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16624"
AND media_type="images"
AND media_name = "energy/91956.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16623'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16623'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16623
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16623
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16623
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16623
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16623
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16623
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16623
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16623
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16623
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16623
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16623
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16623"
AND media_type="images"
AND media_name = "energy/91955.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16622'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16622'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16622
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16622
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16622
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16622
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16622
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16622
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16622
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16622
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16622
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16622
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16622
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16622"
AND media_type="images"
AND media_name = "energy/91954.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16621'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16621'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16621
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16621
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16621
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16621
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16621
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16621
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16621
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16621
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16621
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16621
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16621
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16621"
AND media_type="images"
AND media_name = "energy/91953.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16620'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16620'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16620
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16620
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16620
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16620
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16620
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16620
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16620
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16620
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16620
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16620
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16620
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16620"
AND media_type="images"
AND media_name = "energy/91952.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16619'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16619'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16619
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16619
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16619
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16619
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16619
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16619
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16619
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16619
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16619
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16619
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16619
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16619"
AND media_type="images"
AND media_name = "energy/91951.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16618'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16618'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16618
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16618
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16618
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16618
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16618
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16618
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16618
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16618
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16618
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16618
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16618
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16618"
AND media_type="images"
AND media_name = "energy/91950.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16617'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16617'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16617
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16617
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
SELECT *
FROM jos_redshop_discount_product_shoppers AS ps
WHERE ps.shopper_group_id ='0'
SELECT *
FROM jos_redshop_discount_product
WHERE amount <= 0
AND discount_product_id IN (0)
AND published =1
AND start_date <= '1739787861'
AND end_date >= '1739787861'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16617
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16617
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
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'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16617
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16617
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16617
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16617
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16617
AND discount_enddate>='1739787861'
AND discount_stratdate<='1739787861'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16617
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16617
AND ps.stockroom_id = s.stockroom_id
SELECT *
FROM jos_modules
WHERE `module` LIKE 'mod_redmagicmagnifyplus'
AND published = 1
SELECT *
FROM jos_redshop_media
WHERE media_section = "product"
AND section_id ="16617"
AND media_type="images"
AND media_name = "energy/91949.jpg"
SELECT *
FROM jos_menu
WHERE id = '258'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16616'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16616'
AND pc.category_id = c.category_id
AND c.category_id = '270'
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='270'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '270'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16616
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16616
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
SELECT *