DELETE
FROM jos_session
WHERE ( time < '1739781030' )
SELECT *
FROM jos_session
WHERE session_id = 'kp1irs3m293so37itc2cp7ip44'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'kp1irs3m293so37itc2cp7ip44','1739788230','','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 = 'kp1irs3m293so37itc2cp7ip44'
INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
VALUES ('kp1irs3m293so37itc2cp7ip44', '0','1739788231')
SELECT *
FROM jos_redshop_pageviewer
WHERE session_id = 'kp1irs3m293so37itc2cp7ip44'
AND section='manufacturers'
AND section_id='11'
INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
VALUES ('kp1irs3m293so37itc2cp7ip44','0','manufacturers','11','1739788233')
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 = 143)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT mn.*, m.media_name,m.section_id
FROM jos_redshop_manufacturer AS mn
LEFT JOIN jos_redshop_media AS m
ON m.section_id=mn.manufacturer_id
AND m.published = 1
AND m.media_section='manufacturer'
WHERE mn.published = 1
AND mn.manufacturer_id='11'
SELECT *
FROM jos_menu
WHERE link LIKE '%com_redshop%'
AND published=1
AND id = '143'
SELECT *
FROM jos_menu
WHERE link LIKE '%com_redshop%'
AND published=1
AND link LIKE '%view=manufacturers%'
AND params LIKE '%manufacturerid=11
%'
SELECT *
FROM jos_redshop_manufacturer
WHERE manufacturer_id = 11
SELECT *
FROM jos_redshop_manufacturer
WHERE published = 1
SELECT DISTINCT(p.product_id),p.product_number,p.product_name,p.product_price,p.product_s_desc,p.product_thumb_image,p.product_full_image , c.category_name
FROM jos_redshop_product AS p , jos_redshop_manufacturer AS m , jos_redshop_category AS c , jos_redshop_product_category_xref AS pc
WHERE p.published=1
AND p.manufacturer_id=11
AND p.manufacturer_id=m.manufacturer_id
AND p.product_id = pc.product_id
AND p.expired = 0
AND p.product_parent_id = 0
AND pc.category_id = c.category_id
GROUP BY p.product_id
ORDER BY p.product_id DESC
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'manufacturer_products'
AND published=1
AND template_id='14'
LIMIT 0,1
SELECT category_id AS value, category_name AS text
FROM jos_redshop_category
WHERE published = '1'
ORDER BY category_name ASC
SELECT DISTINCT(p.product_id),p.product_number,p.product_name,p.product_price,p.product_s_desc,p.product_thumb_image,p.product_full_image , c.category_name
FROM jos_redshop_product AS p , jos_redshop_manufacturer AS m , jos_redshop_category AS c , jos_redshop_product_category_xref AS pc
WHERE p.published=1
AND p.manufacturer_id=11
AND p.manufacturer_id=m.manufacturer_id
AND p.product_id = pc.product_id
AND p.expired = 0
AND p.product_parent_id = 0
AND pc.category_id = c.category_id
GROUP BY p.product_id
ORDER BY p.product_id DESC
SELECT *
FROM jos_menu
WHERE id = '143'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '18303'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '18303'
AND pc.category_id = c.category_id
AND c.category_id = '276'
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='276'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '276'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 18303
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18303
AND p.shopper_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 <= '1739788233'
AND end_date >= '1739788233'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18303
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18303
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18303
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18303
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18303
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18303
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 18303
AND discount_enddate>='1739788233'
AND discount_stratdate<='1739788233'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 18303
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 18303
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 ="18303"
AND media_type="images"
AND media_name = "fashionforwalls4/2557N-72_scan_fashionforwalls4.jpg"
SELECT *
FROM jos_menu
WHERE id = '143'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '18302'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '18302'
AND pc.category_id = c.category_id
AND c.category_id = '276'
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='276'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '276'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 18302
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18302
AND p.shopper_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 <= '1739788233'
AND end_date >= '1739788233'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18302
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18302
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18302
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18302
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18302
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18302
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 18302
AND discount_enddate>='1739788233'
AND discount_stratdate<='1739788233'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 18302
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 18302
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 ="18302"
AND media_type="images"
AND media_name = "fashionforwalls4/2557N-71_scan_fashionforwalls4.jpg"
SELECT *
FROM jos_menu
WHERE id = '143'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '18301'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '18301'
AND pc.category_id = c.category_id
AND c.category_id = '276'
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='276'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '276'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 18301
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18301
AND p.shopper_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 <= '1739788233'
AND end_date >= '1739788233'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18301
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18301
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18301
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18301
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18301
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18301
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 18301
AND discount_enddate>='1739788233'
AND discount_stratdate<='1739788233'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 18301
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 18301
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 ="18301"
AND media_type="images"
AND media_name = "fashionforwalls4/2556N-72_scan_fashionforwalls4.jpg"
SELECT *
FROM jos_menu
WHERE id = '143'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '18300'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '18300'
AND pc.category_id = c.category_id
AND c.category_id = '276'
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='276'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '276'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 18300
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18300
AND p.shopper_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 <= '1739788233'
AND end_date >= '1739788233'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18300
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18300
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18300
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18300
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18300
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18300
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 18300
AND discount_enddate>='1739788233'
AND discount_stratdate<='1739788233'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 18300
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 18300
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 ="18300"
AND media_type="images"
AND media_name = "fashionforwalls4/2556N-71_scan_fashionforwalls4.jpg"
SELECT *
FROM jos_menu
WHERE id = '143'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '18299'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '18299'
AND pc.category_id = c.category_id
AND c.category_id = '276'
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='276'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '276'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 18299
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18299
AND p.shopper_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 <= '1739788233'
AND end_date >= '1739788233'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18299
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18299
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18299
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18299
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18299
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18299
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 18299
AND discount_enddate>='1739788233'
AND discount_stratdate<='1739788233'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 18299
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 18299
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 ="18299"
AND media_type="images"
AND media_name = "fashionforwalls4/2555N-72_scan_fashionforwalls4.jpg"
SELECT *
FROM jos_menu
WHERE id = '143'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '18298'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '18298'
AND pc.category_id = c.category_id
AND c.category_id = '276'
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='276'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '276'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 18298
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18298
AND p.shopper_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 <= '1739788233'
AND end_date >= '1739788233'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18298
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18298
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18298
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18298
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18298
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18298
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 18298
AND discount_enddate>='1739788233'
AND discount_stratdate<='1739788233'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 18298
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 18298
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 ="18298"
AND media_type="images"
AND media_name = "fashionforwalls4/2555N-71_scan_fashionforwalls4.jpg"
SELECT *
FROM jos_menu
WHERE id = '143'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '18297'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '18297'
AND pc.category_id = c.category_id
AND c.category_id = '276'
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='276'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '276'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 18297
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18297
AND p.shopper_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 <= '1739788233'
AND end_date >= '1739788233'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18297
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18297
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18297
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18297
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18297
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18297
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 18297
AND discount_enddate>='1739788233'
AND discount_stratdate<='1739788233'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 18297
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 18297
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 ="18297"
AND media_type="images"
AND media_name = "fashionforwalls4/2554N-72_scan_fashionforwalls4.jpg"
SELECT *
FROM jos_menu
WHERE id = '143'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '18296'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '18296'
AND pc.category_id = c.category_id
AND c.category_id = '276'
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='276'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '276'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 18296
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18296
AND p.shopper_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 <= '1739788233'
AND end_date >= '1739788233'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18296
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18296
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18296
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18296
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18296
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18296
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 18296
AND discount_enddate>='1739788233'
AND discount_stratdate<='1739788233'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 18296
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 18296
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 ="18296"
AND media_type="images"
AND media_name = "fashionforwalls4/2554N-71_scan_fashionforwalls4.jpg"
SELECT *
FROM jos_menu
WHERE id = '143'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '18295'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '18295'
AND pc.category_id = c.category_id
AND c.category_id = '276'
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='276'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '276'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 18295
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18295
AND p.shopper_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 <= '1739788233'
AND end_date >= '1739788233'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18295
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18295
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18295
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18295
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18295
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18295
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 18295
AND discount_enddate>='1739788233'
AND discount_stratdate<='1739788233'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 18295
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 18295
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 ="18295"
AND media_type="images"
AND media_name = "fashionforwalls4/2553N-72_scan_fashionforwalls4.jpg"
SELECT *
FROM jos_menu
WHERE id = '143'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '18294'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '18294'
AND pc.category_id = c.category_id
AND c.category_id = '276'
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='276'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '276'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 18294
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18294
AND p.shopper_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 <= '1739788233'
AND end_date >= '1739788233'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18294
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18294
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18294
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18294
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18294
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18294
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 18294
AND discount_enddate>='1739788233'
AND discount_stratdate<='1739788233'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 18294
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 18294
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 ="18294"
AND media_type="images"
AND media_name = "fashionforwalls4/2553N-71_scan_fashionforwalls4.jpg"
SELECT *
FROM jos_menu
WHERE id = '143'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '18293'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '18293'
AND pc.category_id = c.category_id
AND c.category_id = '276'
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='276'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '276'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 18293
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18293
AND p.shopper_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 <= '1739788233'
AND end_date >= '1739788233'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18293
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18293
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18293
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18293
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18293
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18293
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 18293
AND discount_enddate>='1739788233'
AND discount_stratdate<='1739788233'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 18293
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 18293
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 ="18293"
AND media_type="images"
AND media_name = "fashionforwalls4/2552N-82_scan_fashionforwalls4.jpg"
SELECT *
FROM jos_menu
WHERE id = '143'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '18292'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '18292'
AND pc.category_id = c.category_id
AND c.category_id = '276'
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='276'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '276'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 18292
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18292
AND p.shopper_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 <= '1739788233'
AND end_date >= '1739788233'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18292
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18292
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18292
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18292
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18292
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18292
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 18292
AND discount_enddate>='1739788233'
AND discount_stratdate<='1739788233'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 18292
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 18292
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 ="18292"
AND media_type="images"
AND media_name = "fashionforwalls4/2552N-81_scan_fashionforwalls4.jpg"
SELECT *
FROM jos_menu
WHERE id = '143'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '18291'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '18291'
AND pc.category_id = c.category_id
AND c.category_id = '276'
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='276'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '276'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 18291
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18291
AND p.shopper_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 <= '1739788233'
AND end_date >= '1739788233'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18291
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18291
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18291
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18291
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18291
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18291
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 18291
AND discount_enddate>='1739788233'
AND discount_stratdate<='1739788233'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 18291
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 18291
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 ="18291"
AND media_type="images"
AND media_name = "fashionforwalls4/2551N-82_scan_fashionforwalls4.jpg"
SELECT *
FROM jos_menu
WHERE id = '143'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '18290'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '18290'
AND pc.category_id = c.category_id
AND c.category_id = '276'
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='276'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '276'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 18290
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18290
AND p.shopper_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 <= '1739788233'
AND end_date >= '1739788233'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18290
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18290
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18290
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18290
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18290
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18290
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 18290
AND discount_enddate>='1739788233'
AND discount_stratdate<='1739788233'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 18290
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 18290
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 ="18290"
AND media_type="images"
AND media_name = "fashionforwalls4/2551N-81_scan_fashionforwalls4.jpg"
SELECT *
FROM jos_menu
WHERE id = '143'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '18289'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '18289'
AND pc.category_id = c.category_id
AND c.category_id = '276'
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='276'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '276'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 18289
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18289
AND p.shopper_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 <= '1739788233'
AND end_date >= '1739788233'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18289
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18289
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18289
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18289
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18289
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18289
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 18289
AND discount_enddate>='1739788233'
AND discount_stratdate<='1739788233'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 18289
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 18289
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 ="18289"
AND media_type="images"
AND media_name = "fashionforwalls4/2550N-82_scan_fashionforwalls4.jpg"
SELECT *
FROM jos_menu
WHERE id = '143'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '18288'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '18288'
AND pc.category_id = c.category_id
AND c.category_id = '276'
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='276'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '276'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 18288
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 18288
AND p.shopper_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 <= '1739788233'
AND end_date >= '1739788233'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18288
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 18288
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 18288
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
