DELETE
FROM jos_session
WHERE ( time < '1739783314' )
SELECT *
FROM jos_session
WHERE session_id = 'hf4f3or3gi04irbh43o9jalao7'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'hf4f3or3gi04irbh43o9jalao7','1739790514','','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 = 'hf4f3or3gi04irbh43o9jalao7'
INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
VALUES ('hf4f3or3gi04irbh43o9jalao7', '0','1739790515')
SELECT *
FROM jos_redshop_pageviewer
WHERE session_id = 'hf4f3or3gi04irbh43o9jalao7'
AND section='category'
AND section_id=''
INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
VALUES ('hf4f3or3gi04irbh43o9jalao7','0','category','','1739790516')
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 = 224)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_redshop_product AS p, jos_redshop_category AS c
LEFT JOIN jos_redshop_product_category_xref AS pc
ON pc.category_id=c.category_id
WHERE p.product_id = pc.product_id
AND pc.category_id=164
AND p.published = 1
AND p.expired = 0
AND p.product_parent_id = 0
ORDER BY c.ordering ASC
SELECT *
FROM jos_redshop_category
WHERE category_id = 164
SELECT *
FROM jos_redshop_category AS c, jos_redshop_template AS t
WHERE t.template_id = c.category_template
AND t.template_section='category'
AND c.category_id=164
AND t.published = 1
ORDER BY c.ordering ASC
LIMIT 0,1
SELECT *
FROM jos_redshop_category AS c , jos_redshop_category_xref AS cat_ref
WHERE cat_ref.category_child_id=c.category_id
AND category_parent_id=164
AND published = 1
ORDER BY c.category_name ASC
SELECT *
FROM jos_redshop_category
WHERE category_id = '164'
SELECT id
FROM jos_menu
WHERE `link` LIKE '%com_redshop%'
AND `link` LIKE '%view=category%'
AND (`params` LIKE '%categoryid=164%')
ORDER BY 'ordering'
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT *
FROM jos_redshop_product AS p, jos_redshop_category AS c
LEFT JOIN jos_redshop_product_category_xref AS pc
ON pc.category_id=c.category_id
WHERE p.product_id = pc.product_id
AND pc.category_id=164
AND p.published = 1
AND p.expired = 0
AND p.product_parent_id = 0
ORDER BY p.product_name ASC
LIMIT 0, 200
SELECT *
FROM jos_redshop_category AS c, jos_redshop_template AS t
WHERE t.template_id = c.category_template
AND t.template_section='category'
AND c.category_id=164
AND t.published = 1
ORDER BY c.ordering ASC
LIMIT 0,1
SELECT *
FROM jos_redshop_category AS c , jos_redshop_category_xref AS cat_ref
WHERE cat_ref.category_child_id=c.category_id
AND category_parent_id=164
AND published = 1
ORDER BY c.category_name ASC
SELECT *
FROM jos_redshop_category
WHERE category_id = '164'
SELECT id
FROM jos_menu
WHERE `link` LIKE '%com_redshop%'
AND `link` LIKE '%view=category%'
AND (`params` LIKE '%categoryid=164%')
ORDER BY 'ordering'
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7820
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7820
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7820'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7820'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7820'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7820
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7820
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7820
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7820
SELECT tr.*
FROM jos_redshop_tax_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 = 7820
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7820
SELECT tr.*
FROM jos_redshop_tax_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 = 7820
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7820
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7820
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7820
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7820
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 ="7820"
AND media_type="images"
AND media_name = "1515527985_FTN_H_2702.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7820
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7820
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7820
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7820
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7820
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7820
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7820
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7820
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7820
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7820
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7820
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7820
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7821
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7821
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7821'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7821'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7821'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7821
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7821
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7821
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7821
SELECT tr.*
FROM jos_redshop_tax_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 = 7821
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7821
SELECT tr.*
FROM jos_redshop_tax_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 = 7821
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7821
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7821
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7821
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7821
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 ="7821"
AND media_type="images"
AND media_name = "1515528095_FTN_H_2703.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7821
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7821
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7821
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7821
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7821
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7821
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7821
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7821
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7821
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7821
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7821
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7821
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7822
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7822
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7822'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7822'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7822'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7822
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7822
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7822
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7822
SELECT tr.*
FROM jos_redshop_tax_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 = 7822
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7822
SELECT tr.*
FROM jos_redshop_tax_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 = 7822
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7822
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7822
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7822
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7822
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 ="7822"
AND media_type="images"
AND media_name = "1515528155_FTN_H_2704.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7822
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7822
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7822
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7822
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7822
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7822
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7822
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7822
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7822
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7822
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7822
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7822
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7823
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7823
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7823'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7823'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7823'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7823
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7823
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7823
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7823
SELECT tr.*
FROM jos_redshop_tax_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 = 7823
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7823
SELECT tr.*
FROM jos_redshop_tax_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 = 7823
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7823
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7823
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7823
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7823
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 ="7823"
AND media_type="images"
AND media_name = "1515528217_FTN_H_2706.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7823
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7823
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7823
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7823
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7823
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7823
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7823
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7823
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7823
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7823
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7823
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7823
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7824
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7824
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7824'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7824'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7824'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7824
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7824
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7824
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7824
SELECT tr.*
FROM jos_redshop_tax_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 = 7824
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7824
SELECT tr.*
FROM jos_redshop_tax_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 = 7824
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7824
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7824
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7824
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7824
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 ="7824"
AND media_type="images"
AND media_name = "1515528286_FTN_H_2709.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7824
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7824
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7824
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7824
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7824
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7824
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7824
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7824
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7824
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7824
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7824
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7824
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7825
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7825
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7825'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7825'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7825'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7825
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7825
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7825
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7825
SELECT tr.*
FROM jos_redshop_tax_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 = 7825
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7825
SELECT tr.*
FROM jos_redshop_tax_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 = 7825
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7825
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7825
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7825
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7825
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 ="7825"
AND media_type="images"
AND media_name = "1515528358_FTN_H_2711.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7825
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7825
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7825
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7825
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7825
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7825
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7825
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7825
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7825
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7825
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7825
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7825
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7826
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7826
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7826'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7826'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7826'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7826
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7826
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790516'
AND end_date >= '1739790516'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7826
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7826
SELECT tr.*
FROM jos_redshop_tax_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 = 7826
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7826
SELECT tr.*
FROM jos_redshop_tax_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 = 7826
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7826
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7826
AND discount_enddate>='1739790516'
AND discount_stratdate<='1739790516'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7826
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7826
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 ="7826"
AND media_type="images"
AND media_name = "1515529696_FTN_H_2712.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7826
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7826
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7826
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7826
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7826
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7826
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7826
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7826
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7826
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7826
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7826
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7826
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7827
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7827
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7827'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7827'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7827'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7827
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7827
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7827
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7827
SELECT tr.*
FROM jos_redshop_tax_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 = 7827
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7827
SELECT tr.*
FROM jos_redshop_tax_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 = 7827
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7827
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7827
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7827
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7827
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 ="7827"
AND media_type="images"
AND media_name = "1515529803_FTN_H_2714.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7827
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7827
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7827
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7827
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7827
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7827
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7827
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7827
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7827
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7827
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7827
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7827
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7828
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7828
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7828'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7828'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7828'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7828
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7828
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7828
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7828
SELECT tr.*
FROM jos_redshop_tax_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 = 7828
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7828
SELECT tr.*
FROM jos_redshop_tax_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 = 7828
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7828
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7828
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7828
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7828
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 ="7828"
AND media_type="images"
AND media_name = "1515530165_FTN_H_2715.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7828
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7828
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7828
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7828
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7828
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7828
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7828
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7828
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7828
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7828
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7828
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7828
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7829
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7829
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7829'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7829'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7829'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7829
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7829
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7829
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7829
SELECT tr.*
FROM jos_redshop_tax_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 = 7829
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7829
SELECT tr.*
FROM jos_redshop_tax_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 = 7829
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7829
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7829
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7829
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7829
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 ="7829"
AND media_type="images"
AND media_name = "1515530237_FTN_H_2717.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7829
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7829
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7829
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7829
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7829
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7829
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7829
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7829
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7829
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7829
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7829
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7829
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7830
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7830
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7830'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7830'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7830'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7830
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7830
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7830
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7830
SELECT tr.*
FROM jos_redshop_tax_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 = 7830
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7830
SELECT tr.*
FROM jos_redshop_tax_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 = 7830
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7830
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7830
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7830
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7830
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 ="7830"
AND media_type="images"
AND media_name = "1515530315_FTN_H_2719.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7830
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7830
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7830
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7830
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7830
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7830
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7830
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7830
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7830
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7830
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7830
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7830
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7831
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7831
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7831'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7831'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7831'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7831
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7831
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7831
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7831
SELECT tr.*
FROM jos_redshop_tax_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 = 7831
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7831
SELECT tr.*
FROM jos_redshop_tax_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 = 7831
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7831
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7831
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7831
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7831
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 ="7831"
AND media_type="images"
AND media_name = "1515530433_FTN_H_2722.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7831
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7831
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7831
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7831
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7831
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7831
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7831
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7831
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7831
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7831
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7831
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7831
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7832
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7832
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7832'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7832'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7832'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7832
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7832
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7832
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7832
SELECT tr.*
FROM jos_redshop_tax_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 = 7832
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7832
SELECT tr.*
FROM jos_redshop_tax_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 = 7832
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7832
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7832
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7832
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7832
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 ="7832"
AND media_type="images"
AND media_name = "1515530573_FTN_H_2724.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7832
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7832
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7832
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7832
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7832
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7832
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7832
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7832
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7832
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7832
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7832
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7832
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7833
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7833
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7833'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7833'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7833'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7833
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7833
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7833
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7833
SELECT tr.*
FROM jos_redshop_tax_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 = 7833
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7833
SELECT tr.*
FROM jos_redshop_tax_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 = 7833
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7833
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7833
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7833
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7833
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 ="7833"
AND media_type="images"
AND media_name = "1515530893_FTN_H_2725.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7833
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7833
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7833
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7833
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7833
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7833
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7833
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7833
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7833
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7833
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7833
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7833
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7834
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7834
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7834'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7834'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7834'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7834
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7834
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7834
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7834
SELECT tr.*
FROM jos_redshop_tax_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 = 7834
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7834
SELECT tr.*
FROM jos_redshop_tax_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 = 7834
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7834
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7834
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7834
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7834
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 ="7834"
AND media_type="images"
AND media_name = "1515532656_FTN_H_2727.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7834
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7834
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7834
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7834
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7834
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7834
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7834
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7834
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7834
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7834
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7834
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7834
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7835
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7835
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7835'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7835'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7835'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7835
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7835
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7835
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7835
SELECT tr.*
FROM jos_redshop_tax_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 = 7835
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7835
SELECT tr.*
FROM jos_redshop_tax_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 = 7835
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7835
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7835
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7835
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7835
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 ="7835"
AND media_type="images"
AND media_name = "1515532762_FTN_H_2728.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7835
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7835
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7835
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7835
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7835
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7835
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7835
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7835
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7835
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7835
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7835
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7835
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7836
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7836
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7836'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7836'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7836'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7836
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7836
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7836
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7836
SELECT tr.*
FROM jos_redshop_tax_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 = 7836
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7836
SELECT tr.*
FROM jos_redshop_tax_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 = 7836
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7836
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7836
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7836
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7836
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 ="7836"
AND media_type="images"
AND media_name = "1515533171_FTN_H_2738.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7836
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7836
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7836
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7836
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7836
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7836
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7836
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7836
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7836
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7836
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7836
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7836
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7837
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7837
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7837'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7837'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7837'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7837
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7837
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7837
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7837
SELECT tr.*
FROM jos_redshop_tax_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 = 7837
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7837
SELECT tr.*
FROM jos_redshop_tax_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 = 7837
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7837
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7837
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7837
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7837
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 ="7837"
AND media_type="images"
AND media_name = "1515533253_FTN_H_2742.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7837
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7837
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7837
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7837
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7837
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7837
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7837
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7837
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7837
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7837
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7837
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7837
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7838
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7838
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7838'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7838'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7838'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7838
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7838
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7838
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7838
SELECT tr.*
FROM jos_redshop_tax_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 = 7838
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7838
SELECT tr.*
FROM jos_redshop_tax_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 = 7838
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7838
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7838
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7838
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7838
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 ="7838"
AND media_type="images"
AND media_name = "1515533313_FTN_H_2743.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7838
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7838
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7838
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7838
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7838
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7838
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7838
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7838
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7838
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7838
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7838
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7838
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7839
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7839
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7839'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7839'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7839'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7839
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7839
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7839
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7839
SELECT tr.*
FROM jos_redshop_tax_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 = 7839
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7839
SELECT tr.*
FROM jos_redshop_tax_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 = 7839
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7839
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7839
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7839
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7839
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 ="7839"
AND media_type="images"
AND media_name = "1515533539_FTN_H_2748.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7839
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7839
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7839
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7839
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7839
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7839
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7839
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7839
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7839
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7839
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7839
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7839
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7840
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7840
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7840'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7840'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7840'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7840
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7840
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7840
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7840
SELECT tr.*
FROM jos_redshop_tax_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 = 7840
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7840
SELECT tr.*
FROM jos_redshop_tax_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 = 7840
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7840
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7840
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7840
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7840
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 ="7840"
AND media_type="images"
AND media_name = "1515533640_FTN_H_2749.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7840
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7840
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7840
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7840
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7840
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7840
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7840
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7840
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7840
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7840
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7840
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7840
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7841
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7841
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7841'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7841'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7841'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7841
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7841
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7841
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7841
SELECT tr.*
FROM jos_redshop_tax_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 = 7841
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7841
SELECT tr.*
FROM jos_redshop_tax_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 = 7841
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7841
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7841
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 7841
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7841
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 ="7841"
AND media_type="images"
AND media_name = "1515533715_FTN_H_2750.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7841
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7841
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7841
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7841
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7841
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7841
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 7841
AND ps.stockroom_id = s.stockroom_id
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 p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7841
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7841
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7841
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7841
SELECT tr.*
FROM jos_redshop_tax_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 *
FROM jos_redshop_product
WHERE product_id = 7841
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT count(a.attribute_id)
FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=7797
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=7797
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_menu
WHERE id = '224'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '7797'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '7797'
AND pc.category_id = c.category_id
AND c.category_id = '164'
SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
WHERE cx.category_child_id='164'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '164'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='7797'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 7797
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7797
AND p.shopper_group_id = '0'
AND ( p.price_quantity_start <= '1'
AND p.price_quantity_end >= '1' )
ORDER BY price_quantity_start ASC
LIMIT 0,1
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 <= '1739790517'
AND end_date >= '1739790517'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 7797
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7797
SELECT tr.*
FROM jos_redshop_tax_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 = 7797
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 7797
SELECT tr.*
FROM jos_redshop_tax_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 = 7797
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 7797
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 7797
AND discount_enddate>='1739790517'
AND discount_stratdate<='1739790517'
SELECT *
FROM jos_redshop_