DELETE
FROM jos_session
WHERE ( time < '1739780089' )
SELECT *
FROM jos_session
WHERE session_id = '8lkflbcvpgtiaffedlqkdsrge4'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '8lkflbcvpgtiaffedlqkdsrge4','1739787289','','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 = '8lkflbcvpgtiaffedlqkdsrge4'
INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
VALUES ('8lkflbcvpgtiaffedlqkdsrge4', '0','1739787290')
SELECT *
FROM jos_redshop_pageviewer
WHERE session_id = '8lkflbcvpgtiaffedlqkdsrge4'
AND section='category'
AND section_id=''
INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
VALUES ('8lkflbcvpgtiaffedlqkdsrge4','0','category','','1739787291')
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 = 323)
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=261
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 = 261
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=261
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=261
AND published = 1
ORDER BY c.category_name ASC
SELECT *
FROM jos_redshop_category
WHERE category_id = '261'
SELECT id
FROM jos_menu
WHERE `link` LIKE '%com_redshop%'
AND `link` LIKE '%view=category%'
AND (`params` LIKE '%categoryid=261%')
ORDER BY 'ordering'
SELECT *
FROM jos_menu
WHERE id = '323'
SELECT sef_url,category_name
FROM jos_redshop_category
WHERE category_id = '261'
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='261'
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=261
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=261
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=261
AND published = 1
ORDER BY c.category_name ASC
SELECT *
FROM jos_redshop_category
WHERE category_id = '261'
SELECT id
FROM jos_menu
WHERE `link` LIKE '%com_redshop%'
AND `link` LIKE '%view=category%'
AND (`params` LIKE '%categoryid=261%')
ORDER BY 'ordering'
SELECT *
FROM jos_menu
WHERE id = '323'
SELECT sef_url,category_name
FROM jos_redshop_category
WHERE category_id = '261'
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='261'
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=16039
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=16039
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16039'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16039'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16039'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16039
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16039
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16039
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16039
SELECT tr.*
FROM jos_redshop_tax_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 = 16039
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16039
SELECT tr.*
FROM jos_redshop_tax_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 = 16039
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16039
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16039
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16039
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16039
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 ="16039"
AND media_type="images"
AND media_name = "texturepalette2/35208.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 = 16039
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 = 16039
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16039
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16039
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16039
SELECT tr.*
FROM jos_redshop_tax_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 = 16039
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16039
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 = 16039
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16039
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16039
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16039
SELECT tr.*
FROM jos_redshop_tax_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 = 16039
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16040
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=16040
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16040'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16040'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16040'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16040
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16040
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16040
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16040
SELECT tr.*
FROM jos_redshop_tax_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 = 16040
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16040
SELECT tr.*
FROM jos_redshop_tax_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 = 16040
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16040
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16040
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16040
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16040
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 ="16040"
AND media_type="images"
AND media_name = "texturepalette2/35217.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 = 16040
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 = 16040
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16040
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16040
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16040
SELECT tr.*
FROM jos_redshop_tax_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 = 16040
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16040
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 = 16040
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16040
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16040
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16040
SELECT tr.*
FROM jos_redshop_tax_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 = 16040
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16041
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=16041
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16041'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16041'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16041'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16041
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16041
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16041
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16041
SELECT tr.*
FROM jos_redshop_tax_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 = 16041
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16041
SELECT tr.*
FROM jos_redshop_tax_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 = 16041
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16041
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16041
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16041
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16041
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 ="16041"
AND media_type="images"
AND media_name = "texturepalette2/35220.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 = 16041
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 = 16041
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16041
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16041
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16041
SELECT tr.*
FROM jos_redshop_tax_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 = 16041
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16041
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 = 16041
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16041
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16041
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16041
SELECT tr.*
FROM jos_redshop_tax_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 = 16041
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16042
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=16042
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16042'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16042'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16042'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16042
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16042
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16042
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16042
SELECT tr.*
FROM jos_redshop_tax_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 = 16042
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16042
SELECT tr.*
FROM jos_redshop_tax_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 = 16042
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16042
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16042
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16042
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16042
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 ="16042"
AND media_type="images"
AND media_name = "texturepalette2/35226.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 = 16042
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 = 16042
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16042
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16042
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16042
SELECT tr.*
FROM jos_redshop_tax_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 = 16042
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16042
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 = 16042
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16042
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16042
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16042
SELECT tr.*
FROM jos_redshop_tax_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 = 16042
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16043
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=16043
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16043'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16043'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16043'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16043
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16043
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16043
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16043
SELECT tr.*
FROM jos_redshop_tax_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 = 16043
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16043
SELECT tr.*
FROM jos_redshop_tax_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 = 16043
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16043
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16043
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16043
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16043
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 ="16043"
AND media_type="images"
AND media_name = "texturepalette2/35230.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 = 16043
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 = 16043
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16043
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16043
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16043
SELECT tr.*
FROM jos_redshop_tax_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 = 16043
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16043
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 = 16043
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16043
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16043
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16043
SELECT tr.*
FROM jos_redshop_tax_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 = 16043
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16044
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=16044
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16044'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16044'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16044'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16044
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16044
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16044
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16044
SELECT tr.*
FROM jos_redshop_tax_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 = 16044
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16044
SELECT tr.*
FROM jos_redshop_tax_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 = 16044
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16044
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16044
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16044
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16044
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 ="16044"
AND media_type="images"
AND media_name = "texturepalette2/35231.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 = 16044
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 = 16044
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16044
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16044
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16044
SELECT tr.*
FROM jos_redshop_tax_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 = 16044
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16044
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 = 16044
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16044
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16044
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16044
SELECT tr.*
FROM jos_redshop_tax_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 = 16044
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16045
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=16045
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16045'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16045'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16045'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16045
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16045
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16045
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16045
SELECT tr.*
FROM jos_redshop_tax_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 = 16045
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16045
SELECT tr.*
FROM jos_redshop_tax_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 = 16045
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16045
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16045
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16045
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16045
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 ="16045"
AND media_type="images"
AND media_name = "texturepalette2/35233.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 = 16045
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 = 16045
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16045
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16045
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16045
SELECT tr.*
FROM jos_redshop_tax_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 = 16045
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16045
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 = 16045
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16045
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16045
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16045
SELECT tr.*
FROM jos_redshop_tax_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 = 16045
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16046
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=16046
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16046'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16046'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16046'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16046
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16046
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16046
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16046
SELECT tr.*
FROM jos_redshop_tax_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 = 16046
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16046
SELECT tr.*
FROM jos_redshop_tax_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 = 16046
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16046
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16046
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16046
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16046
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 ="16046"
AND media_type="images"
AND media_name = "texturepalette2/35234.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 = 16046
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 = 16046
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16046
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16046
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16046
SELECT tr.*
FROM jos_redshop_tax_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 = 16046
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16046
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 = 16046
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16046
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16046
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16046
SELECT tr.*
FROM jos_redshop_tax_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 = 16046
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16047
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=16047
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16047'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16047'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16047'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16047
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16047
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16047
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16047
SELECT tr.*
FROM jos_redshop_tax_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 = 16047
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16047
SELECT tr.*
FROM jos_redshop_tax_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 = 16047
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16047
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16047
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16047
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16047
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 ="16047"
AND media_type="images"
AND media_name = "texturepalette2/35235.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 = 16047
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 = 16047
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16047
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16047
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16047
SELECT tr.*
FROM jos_redshop_tax_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 = 16047
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16047
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 = 16047
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16047
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16047
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16047
SELECT tr.*
FROM jos_redshop_tax_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 = 16047
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16048
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=16048
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16048'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16048'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16048'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16048
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16048
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16048
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16048
SELECT tr.*
FROM jos_redshop_tax_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 = 16048
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16048
SELECT tr.*
FROM jos_redshop_tax_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 = 16048
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16048
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16048
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16048
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16048
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 ="16048"
AND media_type="images"
AND media_name = "texturepalette2/35236.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 = 16048
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 = 16048
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16048
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16048
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16048
SELECT tr.*
FROM jos_redshop_tax_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 = 16048
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16048
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 = 16048
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16048
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16048
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16048
SELECT tr.*
FROM jos_redshop_tax_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 = 16048
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16049
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=16049
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16049'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16049'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16049'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16049
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16049
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16049
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16049
SELECT tr.*
FROM jos_redshop_tax_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 = 16049
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16049
SELECT tr.*
FROM jos_redshop_tax_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 = 16049
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16049
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16049
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16049
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16049
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 ="16049"
AND media_type="images"
AND media_name = "texturepalette2/35240.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 = 16049
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 = 16049
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16049
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16049
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16049
SELECT tr.*
FROM jos_redshop_tax_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 = 16049
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16049
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 = 16049
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16049
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16049
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16049
SELECT tr.*
FROM jos_redshop_tax_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 = 16049
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16050
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=16050
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16050'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16050'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16050'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16050
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16050
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16050
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16050
SELECT tr.*
FROM jos_redshop_tax_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 = 16050
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16050
SELECT tr.*
FROM jos_redshop_tax_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 = 16050
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16050
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16050
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16050
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16050
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 ="16050"
AND media_type="images"
AND media_name = "texturepalette2/35245.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 = 16050
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 = 16050
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16050
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16050
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16050
SELECT tr.*
FROM jos_redshop_tax_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 = 16050
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16050
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 = 16050
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16050
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16050
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16050
SELECT tr.*
FROM jos_redshop_tax_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 = 16050
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16051
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=16051
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16051'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16051'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16051'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16051
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16051
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16051
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16051
SELECT tr.*
FROM jos_redshop_tax_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 = 16051
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16051
SELECT tr.*
FROM jos_redshop_tax_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 = 16051
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16051
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16051
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16051
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16051
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 ="16051"
AND media_type="images"
AND media_name = "texturepalette2/35252.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 = 16051
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 = 16051
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16051
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16051
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16051
SELECT tr.*
FROM jos_redshop_tax_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 = 16051
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16051
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 = 16051
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16051
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16051
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16051
SELECT tr.*
FROM jos_redshop_tax_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 = 16051
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16052
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=16052
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16052'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16052'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16052'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16052
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16052
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16052
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16052
SELECT tr.*
FROM jos_redshop_tax_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 = 16052
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16052
SELECT tr.*
FROM jos_redshop_tax_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 = 16052
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16052
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16052
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16052
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16052
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 ="16052"
AND media_type="images"
AND media_name = "texturepalette2/35259.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 = 16052
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 = 16052
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16052
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16052
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16052
SELECT tr.*
FROM jos_redshop_tax_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 = 16052
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16052
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 = 16052
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16052
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16052
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16052
SELECT tr.*
FROM jos_redshop_tax_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 = 16052
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16053
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=16053
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16053'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16053'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16053'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16053
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16053
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16053
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16053
SELECT tr.*
FROM jos_redshop_tax_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 = 16053
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16053
SELECT tr.*
FROM jos_redshop_tax_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 = 16053
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16053
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16053
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16053
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16053
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 ="16053"
AND media_type="images"
AND media_name = "texturepalette2/35262.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 = 16053
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 = 16053
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16053
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16053
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16053
SELECT tr.*
FROM jos_redshop_tax_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 = 16053
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16053
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 = 16053
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16053
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16053
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16053
SELECT tr.*
FROM jos_redshop_tax_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 = 16053
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16054
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=16054
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16054'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16054'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16054'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16054
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16054
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16054
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16054
SELECT tr.*
FROM jos_redshop_tax_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 = 16054
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16054
SELECT tr.*
FROM jos_redshop_tax_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 = 16054
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16054
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16054
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16054
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16054
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 ="16054"
AND media_type="images"
AND media_name = "texturepalette2/35265.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 = 16054
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 = 16054
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16054
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16054
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16054
SELECT tr.*
FROM jos_redshop_tax_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 = 16054
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16054
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 = 16054
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16054
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16054
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16054
SELECT tr.*
FROM jos_redshop_tax_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 = 16054
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16055
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=16055
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16055'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16055'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16055'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16055
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16055
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16055
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16055
SELECT tr.*
FROM jos_redshop_tax_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 = 16055
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16055
SELECT tr.*
FROM jos_redshop_tax_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 = 16055
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16055
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16055
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16055
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16055
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 ="16055"
AND media_type="images"
AND media_name = "texturepalette2/35267.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 = 16055
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 = 16055
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16055
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16055
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16055
SELECT tr.*
FROM jos_redshop_tax_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 = 16055
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16055
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 = 16055
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16055
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16055
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16055
SELECT tr.*
FROM jos_redshop_tax_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 = 16055
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16056
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=16056
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16056'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16056'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16056'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16056
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16056
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16056
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16056
SELECT tr.*
FROM jos_redshop_tax_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 = 16056
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16056
SELECT tr.*
FROM jos_redshop_tax_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 = 16056
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16056
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16056
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16056
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16056
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 ="16056"
AND media_type="images"
AND media_name = "texturepalette2/35268.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 = 16056
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 = 16056
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16056
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16056
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16056
SELECT tr.*
FROM jos_redshop_tax_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 = 16056
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16056
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 = 16056
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16056
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 <= '1739787291'
AND end_date >= '1739787291'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16056
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16056
SELECT tr.*
FROM jos_redshop_tax_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 = 16056
AND discount_enddate>='1739787291'
AND discount_stratdate<='1739787291'
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=16057
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=16057
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16057'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16057'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16057'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16057
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16057
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16057
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16057
SELECT tr.*
FROM jos_redshop_tax_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 = 16057
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16057
SELECT tr.*
FROM jos_redshop_tax_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 = 16057
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16057
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16057
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16057
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16057
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 ="16057"
AND media_type="images"
AND media_name = "texturepalette2/35300.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 = 16057
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 = 16057
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16057
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16057
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16057
SELECT tr.*
FROM jos_redshop_tax_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 = 16057
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16057
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 = 16057
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16057
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16057
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16057
SELECT tr.*
FROM jos_redshop_tax_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 = 16057
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
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=16058
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=16058
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16058'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16058'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16058'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16058
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16058
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16058
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16058
SELECT tr.*
FROM jos_redshop_tax_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 = 16058
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16058
SELECT tr.*
FROM jos_redshop_tax_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 = 16058
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16058
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16058
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16058
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16058
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 ="16058"
AND media_type="images"
AND media_name = "texturepalette2/35301.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 = 16058
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 = 16058
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16058
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16058
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16058
SELECT tr.*
FROM jos_redshop_tax_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 = 16058
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16058
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 = 16058
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16058
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16058
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16058
SELECT tr.*
FROM jos_redshop_tax_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 = 16058
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
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=16059
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=16059
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16059'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16059'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16059'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16059
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16059
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16059
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16059
SELECT tr.*
FROM jos_redshop_tax_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 = 16059
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16059
SELECT tr.*
FROM jos_redshop_tax_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 = 16059
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16059
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16059
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16059
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16059
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 ="16059"
AND media_type="images"
AND media_name = "texturepalette2/35303.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 = 16059
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 = 16059
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16059
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16059
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16059
SELECT tr.*
FROM jos_redshop_tax_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 = 16059
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16059
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 = 16059
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16059
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16059
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16059
SELECT tr.*
FROM jos_redshop_tax_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 = 16059
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
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=16060
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=16060
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16060'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16060'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16060'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16060
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16060
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16060
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16060
SELECT tr.*
FROM jos_redshop_tax_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 = 16060
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16060
SELECT tr.*
FROM jos_redshop_tax_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 = 16060
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16060
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16060
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16060
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16060
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 ="16060"
AND media_type="images"
AND media_name = "texturepalette2/35304.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 = 16060
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 = 16060
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16060
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16060
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16060
SELECT tr.*
FROM jos_redshop_tax_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 = 16060
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16060
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 = 16060
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16060
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16060
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16060
SELECT tr.*
FROM jos_redshop_tax_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 = 16060
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
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=16061
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=16061
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16061'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16061'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16061'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16061
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16061
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16061
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16061
SELECT tr.*
FROM jos_redshop_tax_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 = 16061
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16061
SELECT tr.*
FROM jos_redshop_tax_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 = 16061
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16061
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16061
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16061
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16061
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 ="16061"
AND media_type="images"
AND media_name = "texturepalette2/35305.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 = 16061
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 = 16061
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16061
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16061
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16061
SELECT tr.*
FROM jos_redshop_tax_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 = 16061
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16061
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 = 16061
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16061
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16061
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16061
SELECT tr.*
FROM jos_redshop_tax_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 = 16061
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
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=16062
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=16062
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16062'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16062'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16062'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16062
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16062
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16062
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16062
SELECT tr.*
FROM jos_redshop_tax_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 = 16062
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16062
SELECT tr.*
FROM jos_redshop_tax_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 = 16062
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16062
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16062
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16062
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16062
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 ="16062"
AND media_type="images"
AND media_name = "texturepalette2/35306.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 = 16062
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 = 16062
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16062
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16062
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16062
SELECT tr.*
FROM jos_redshop_tax_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 = 16062
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16062
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 = 16062
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16062
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16062
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16062
SELECT tr.*
FROM jos_redshop_tax_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 = 16062
AND discount_enddate>='1739787292'
AND discount_stratdate<='1739787292'
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=16063
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=16063
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 = '323'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16063'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16063'
AND pc.category_id = c.category_id
AND c.category_id = '261'
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='261'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '261'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
SELECT *
FROM jos_redshop_fields_data
WHERE fieldid='1'
AND itemid='16063'
AND section='1'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16063
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16063
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 <= '1739787292'
AND end_date >= '1739787292'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16063
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16063
SELECT tr.*
FROM jos_redshop_tax_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 = 16063
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT 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 = 16063
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
&nb