DELETE
FROM jos_session
WHERE ( time < '1739781077' )
SELECT *
FROM jos_session
WHERE session_id = 'pajjq863u66n4p0pdjtisf54r3'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'pajjq863u66n4p0pdjtisf54r3','1739788277','','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 = 'pajjq863u66n4p0pdjtisf54r3'
INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
VALUES ('pajjq863u66n4p0pdjtisf54r3', '0','1739788279')
SELECT *
FROM jos_redshop_pageviewer
WHERE session_id = 'pajjq863u66n4p0pdjtisf54r3'
AND section='manufacturers'
AND section_id='5'
INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
VALUES ('pajjq863u66n4p0pdjtisf54r3','0','manufacturers','5','1739788281')
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 = 222)
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='5'
SELECT *
FROM jos_menu
WHERE link LIKE '%com_redshop%'
AND published=1
AND id = '222'
SELECT *
FROM jos_menu
WHERE link LIKE '%com_redshop%'
AND published=1
AND link LIKE '%view=manufacturers%'
AND params LIKE '%manufacturerid=5
%'
SELECT *
FROM jos_redshop_manufacturer
WHERE manufacturer_id = 5
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=5
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_name ASC
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=5
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_name ASC
LIMIT 0, 15
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '62'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '62'
AND pc.category_id = c.category_id
AND c.category_id = '54'
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='54'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '54'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 62
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 62
AND p.shopper_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 <= '1739788281'
AND end_date >= '1739788281'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 62
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 62
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 62
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 62
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 62
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 62
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 62
AND discount_enddate>='1739788281'
AND discount_stratdate<='1739788281'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 62
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 62
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 ="62"
AND media_type="images"
AND media_name = "1306504415_HAV40729.jpg"
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '63'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '63'
AND pc.category_id = c.category_id
AND c.category_id = '54'
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='54'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '54'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 63
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 63
AND p.shopper_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 <= '1739788281'
AND end_date >= '1739788281'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 63
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 63
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 63
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 63
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 63
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 63
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 63
AND discount_enddate>='1739788281'
AND discount_stratdate<='1739788281'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 63
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 63
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 ="63"
AND media_type="images"
AND media_name = "1306512161_HAV40785.jpg"
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '64'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '64'
AND pc.category_id = c.category_id
AND c.category_id = '54'
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='54'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '54'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 64
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 64
AND p.shopper_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 <= '1739788281'
AND end_date >= '1739788281'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 64
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 64
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 64
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 64
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 64
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 64
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 64
AND discount_enddate>='1739788281'
AND discount_stratdate<='1739788281'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 64
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 64
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 ="64"
AND media_type="images"
AND media_name = "1307107064_HAV40797.jpg"
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '65'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '65'
AND pc.category_id = c.category_id
AND c.category_id = '54'
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='54'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '54'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 65
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 65
AND p.shopper_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 <= '1739788281'
AND end_date >= '1739788281'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 65
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 65
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 65
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 65
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 65
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 65
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 65
AND discount_enddate>='1739788281'
AND discount_stratdate<='1739788281'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 65
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 65
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 ="65"
AND media_type="images"
AND media_name = "1307034582_HAV40803.jpg"
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '66'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '66'
AND pc.category_id = c.category_id
AND c.category_id = '54'
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='54'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '54'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 66
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 66
AND p.shopper_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 <= '1739788281'
AND end_date >= '1739788281'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 66
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 66
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 66
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 66
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 66
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 66
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 66
AND discount_enddate>='1739788281'
AND discount_stratdate<='1739788281'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 66
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 66
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 ="66"
AND media_type="images"
AND media_name = "1307035942_HAV40816.jpg"
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '67'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '67'
AND pc.category_id = c.category_id
AND c.category_id = '54'
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='54'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '54'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 67
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 67
AND p.shopper_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 <= '1739788281'
AND end_date >= '1739788281'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 67
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 67
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 67
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 67
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 67
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 67
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 67
AND discount_enddate>='1739788281'
AND discount_stratdate<='1739788281'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 67
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 67
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 ="67"
AND media_type="images"
AND media_name = "1307037209_HAV40826.jpg"
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '68'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '68'
AND pc.category_id = c.category_id
AND c.category_id = '54'
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='54'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '54'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 68
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 68
AND p.shopper_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 <= '1739788282'
AND end_date >= '1739788282'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 68
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 68
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 68
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 68
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 68
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 68
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 68
AND discount_enddate>='1739788282'
AND discount_stratdate<='1739788282'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 68
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 68
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 ="68"
AND media_type="images"
AND media_name = "1307037873_HAV40834.jpg"
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '69'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '69'
AND pc.category_id = c.category_id
AND c.category_id = '54'
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='54'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '54'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 69
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 69
AND p.shopper_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 <= '1739788282'
AND end_date >= '1739788282'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 69
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 69
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 69
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 69
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 69
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 69
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 69
AND discount_enddate>='1739788282'
AND discount_stratdate<='1739788282'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 69
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 69
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 ="69"
AND media_type="images"
AND media_name = "1307040489_HAV40846.jpg"
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '70'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '70'
AND pc.category_id = c.category_id
AND c.category_id = '54'
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='54'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '54'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 70
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 70
AND p.shopper_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 <= '1739788282'
AND end_date >= '1739788282'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 70
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 70
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 70
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 70
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 70
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 70
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 70
AND discount_enddate>='1739788282'
AND discount_stratdate<='1739788282'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 70
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 70
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 ="70"
AND media_type="images"
AND media_name = "1307041924_HAV40856.jpg"
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '71'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '71'
AND pc.category_id = c.category_id
AND c.category_id = '54'
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='54'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '54'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 71
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 71
AND p.shopper_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 <= '1739788282'
AND end_date >= '1739788282'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 71
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 71
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 71
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 71
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 71
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 71
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 71
AND discount_enddate>='1739788282'
AND discount_stratdate<='1739788282'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 71
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 71
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 ="71"
AND media_type="images"
AND media_name = "1307042897_HAV40863.jpg"
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '72'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '72'
AND pc.category_id = c.category_id
AND c.category_id = '54'
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='54'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '54'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 72
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 72
AND p.shopper_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 <= '1739788282'
AND end_date >= '1739788282'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 72
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 72
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 72
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 72
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 72
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 72
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 72
AND discount_enddate>='1739788282'
AND discount_stratdate<='1739788282'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 72
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 72
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 ="72"
AND media_type="images"
AND media_name = "1307044016_HAV40874.jpg"
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '73'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '73'
AND pc.category_id = c.category_id
AND c.category_id = '55'
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='55'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '55'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 73
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 73
AND p.shopper_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 <= '1739788282'
AND end_date >= '1739788282'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 73
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 73
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 73
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 73
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 73
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 73
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 73
AND discount_enddate>='1739788282'
AND discount_stratdate<='1739788282'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 73
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 73
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 ="73"
AND media_type="images"
AND media_name = "1307111373_HMY57503.jpg"
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '74'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '74'
AND pc.category_id = c.category_id
AND c.category_id = '55'
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='55'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '55'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 74
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 74
AND p.shopper_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 <= '1739788282'
AND end_date >= '1739788282'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 74
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 74
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
FROM jos_redshop_users_info AS u
LEFT JOIN jos_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 = 74
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 74
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 74
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 74
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 74
AND discount_enddate>='1739788282'
AND discount_stratdate<='1739788282'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 74
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 74
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 ="74"
AND media_type="images"
AND media_name = "1307114222_HMY57511.jpg"
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '75'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '75'
AND pc.category_id = c.category_id
AND c.category_id = '55'
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='55'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '55'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 75
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 75
AND p.shopper_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 <= '1739788282'
AND end_date >= '1739788282'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 75
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 75
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 75
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 75
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 75
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 75
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 75
AND discount_enddate>='1739788282'
AND discount_stratdate<='1739788282'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 75
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 75
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 ="75"
AND media_type="images"
AND media_name = "1307115096_HMY57533.jpg"
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '76'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '76'
AND pc.category_id = c.category_id
AND c.category_id = '55'
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='55'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '55'
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 76
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 76
AND p.shopper_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 <= '1739788282'
AND end_date >= '1739788282'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 76
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 76
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 76
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 76
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 76
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 76
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 76
AND discount_enddate>='1739788282'
AND discount_stratdate<='1739788282'
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 76
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 76
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 ="76"
AND media_type="images"
AND media_name = "1307115913_HMY57542.jpg"
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,manufacturer_name
FROM jos_redshop_manufacturer
WHERE manufacturer_id = '5'
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,manufacturer_name
FROM jos_redshop_manufacturer
WHERE manufacturer_id = '5'
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,manufacturer_name
FROM jos_redshop_manufacturer
WHERE manufacturer_id = '5'
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,manufacturer_name
FROM jos_redshop_manufacturer
WHERE manufacturer_id = '5'
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,manufacturer_name
FROM jos_redshop_manufacturer
WHERE manufacturer_id = '5'
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,manufacturer_name
FROM jos_redshop_manufacturer
WHERE manufacturer_id = '5'
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,manufacturer_name
FROM jos_redshop_manufacturer
WHERE manufacturer_id = '5'
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,manufacturer_name
FROM jos_redshop_manufacturer
WHERE manufacturer_id = '5'
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,manufacturer_name
FROM jos_redshop_manufacturer
WHERE manufacturer_id = '5'
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,manufacturer_name
FROM jos_redshop_manufacturer
WHERE manufacturer_id = '5'
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT sef_url,manufacturer_name
FROM jos_redshop_manufacturer
WHERE manufacturer_id = '5'
SELECT *
FROM jos_redshop_fields
WHERE field_section='10'
AND published=1
AND field_name IN ('manufacturer_image')
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 222 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT *
FROM jos_menu
WHERE id = '71'
SELECT *
FROM jos_menu
WHERE id = '222'
SELECT category_id
FROM jos_redshop_product_category_xref cx
WHERE product_id = ''
SELECT id
FROM jos_menu
WHERE `link` LIKE '%com_redshop%'
AND `link` LIKE '%view=category%'
AND (`link` LIKE '%id=216%' OR `params` LIKE '%categoryid=216%')
ORDER BY 'ordering'
SELECT category_id AS value,category_name AS text
FROM jos_redshop_category
WHERE published = 1
SELECT *
FROM jos_menu
WHERE id = '222'