SELECT *
FROM jos_session
WHERE session_id = 'pvf0m5jqie703t71at4e806pp4'
DELETE
FROM jos_session
WHERE ( time < '1739391565' )
SELECT *
FROM jos_session
WHERE session_id = 'pvf0m5jqie703t71at4e806pp4'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'pvf0m5jqie703t71at4e806pp4','1739398765','','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-12'
SELECT *
FROM jos_redshop_siteviewer
WHERE session_id = 'pvf0m5jqie703t71at4e806pp4'
INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
VALUES ('pvf0m5jqie703t71at4e806pp4', '0','1739398766')
SELECT *
FROM jos_redshop_pageviewer
WHERE session_id = 'pvf0m5jqie703t71at4e806pp4'
AND section='product'
AND section_id='16437'
INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
VALUES ('pvf0m5jqie703t71at4e806pp4','0','product','16437','1739398768')
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 = 330)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT id
FROM `jos_components`
WHERE `link` LIKE '%com_reddesign%'
SELECT p.*, c.category_id, c.category_name, m.manufacturer_name ,s.supplier_name
FROM (jos_redshop_category AS c ,jos_redshop_product AS p , jos_redshop_product_category_xref AS pcr )
LEFT JOIN jos_redshop_manufacturer AS m
ON m.manufacturer_id = p.manufacturer_id
LEFT JOIN jos_redshop_supplier AS s
ON s.supplier_id = p.supplier_id
WHERE p.product_id=16437
AND pcr.product_id=16437
AND pcr.category_id=c.category_id
AND p.published = 1
SELECT min_del_time AS deltime, s.max_del_time, s.delivery_time
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16437
AND ps.stockroom_id = s.stockroom_id
AND ps.quantity >0
ORDER BY min_del_time ASC
LIMIT 0,1
SELECT *
FROM jos_redshop_product AS p, jos_redshop_template AS t
WHERE t.template_id = p.product_template
AND t.template_section='product'
AND p.product_id=16437
AND t.published = 1
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16437
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16437
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 <= '1739398768'
AND end_date >= '1739398768'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_menu
WHERE id = '330'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16437'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16437'
AND pc.category_id = c.category_id
AND c.category_id = '268'
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='268'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '268'
SELECT *
FROM jos_redshop_fields
WHERE field_section='1'
AND published=1
AND field_name IN ('product_desc','product_thumb_image','more_images','product_s_desc','manufacturer_link','related_product:Related Products')
SELECT *
FROM jos_redshop_manufacturer
WHERE manufacturer_id = 23
SELECT *
FROM jos_menu
WHERE id = '330'
SELECT sef_url,manufacturer_name
FROM jos_redshop_manufacturer
WHERE manufacturer_id = '23'
SELECT product_id AS value,product_name AS text
FROM `jos_redshop_product`
WHERE `product_parent_id` =16437
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16437
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16437
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16437
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 <= '1739398768'
AND end_date >= '1739398768'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16437
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16437
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 16437
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16437
SELECT tr.*
FROM jos_redshop_tax_rate 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 = 16437
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16437
AND p.shopper_group_id = '0'
ORDER BY price_quantity_start ASC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16437
AND discount_enddate>='1739398768'
AND discount_stratdate<='1739398768'
SELECT *
FROM jos_redshop_media AS m
LEFT JOIN jos_redshop_product AS p
ON p.product_id = m.section_id
WHERE m.media_section = 'product'
AND media_type='images'
AND m.section_id=16437
AND m.published = 1
SELECT *
FROM jos_redshop_wrapper
WHERE published = 1
AND (FIND_IN_SET(16437,product_id) OR wrapper_use_to_all = 1 )
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'wrapper_template'
AND published=1
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'attribute_template'
AND published=1
SELECT a.attribute_id AS value,a.attribute_name AS text,a.*
FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
WHERE a.product_id = p.product_id
AND p.product_id=16437
AND p.published = 1
ORDER BY a.ordering ASC
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'accessory_template'
AND published=1
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'review'
AND published=1
LIMIT 0,1
SELECT ui.firstname,ui.lastname,pr.*
FROM jos_redshop_product_rating AS pr, jos_users AS u, jos_redshop_users_info AS ui
WHERE pr.product_id=16437
AND pr.published = 1
AND pr.userid=u.id
AND ui.user_id=u.id
AND ui.address_type LIKE 'BT'
ORDER BY pr.favoured DESC
SELECT pr.*
FROM jos_redshop_product_rating AS pr
WHERE pr.product_id=16437
AND pr.published = 1
SELECT sum(user_rating) AS rating
FROM jos_redshop_product_rating AS pr
WHERE pr.product_id=16437
AND pr.published = 1
SELECT *
FROM jos_redshop_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT *
FROM jos_redshop_product AS p
WHERE p.product_id = 16437
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16437
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 ="16437"
AND media_type="images"
AND media_name = "air/95015.jpg"
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'add_to_cart'
AND published=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16437
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16437
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16437
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 <= '1739398768'
AND end_date >= '1739398768'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16437
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16437
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16437
AND discount_enddate>='1739398768'
AND discount_stratdate<='1739398768'
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_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
SELECT sum(quantity) AS quantity
FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s
WHERE ps.product_id = 16437
AND ps.stockroom_id = s.stockroom_id
SELECT p.*
FROM jos_redshop_product AS p
WHERE p.product_id = 16437
SELECT p.price_id,p.product_price,p.product_currency
FROM jos_redshop_product_price AS p
WHERE p.product_id = 16437
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 <= '1739398768'
AND end_date >= '1739398768'
ORDER BY amount DESC
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16437
SELECT sg.*
FROM jos_redshop_shopper_group AS sg
LEFT JOIN jos_redshop_users_info AS ui
ON ui.shopper_group_id = sg.shopper_group_id
WHERE ui.user_id = '0'
LIMIT 0,1
SELECT *
FROM jos_redshop_product
WHERE product_id = 16437
SELECT tr.*
FROM jos_redshop_tax_rate AS tr
WHERE tr.tax_group_id = 1
AND tr.tax_country="CAN"
AND tr.tax_state = "ON"
ORDER BY `tax_rate` DESC
SELECT *
FROM jos_redshop_product
WHERE product_id = 16437
AND discount_enddate>='1739398768'
AND discount_stratdate<='1739398768'
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_fields
WHERE field_section='12'
AND field_name=''
AND published=1
AND field_show_in_front=1
UPDATE jos_redshop_product
SET `visited` = visited + 1
WHERE `product_id` = '16437'
SELECT p.product_name,pcx.category_id
FROM jos_redshop_product AS p,jos_redshop_product_category_xref AS pcx
WHERE p.product_id = 16437
AND p.product_id = pcx.product_id
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=''
AND c.category_id = cx.category_parent_id
SELECT pcx.product_id,p.product_name
FROM jos_redshop_product AS p,jos_redshop_product_category_xref AS pcx
WHERE pcx.category_id=268
AND pcx.product_id=p.product_id
ORDER BY pcx.product_id
SELECT *
FROM jos_menu
WHERE id = '330'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16438'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16438'
AND pc.category_id = c.category_id
AND c.category_id = '268'
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='268'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '268'
SELECT *
FROM jos_menu
WHERE id = '330'
SELECT sef_url,product_name,cat_in_sefurl
FROM jos_redshop_product
WHERE product_id = '16436'
SELECT c.category_id
FROM jos_redshop_category c,jos_redshop_product_category_xref pc
WHERE pc.product_id = '16436'
AND pc.category_id = c.category_id
AND c.category_id = '268'
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='268'
AND c.category_id = cx.category_parent_id
SELECT category_name
FROM jos_redshop_category
WHERE category_id = '268'
SELECT *
FROM jos_redshop_textlibrary
WHERE published=1
SELECT *
FROM jos_menu
WHERE link LIKE '%com_redshop%'
AND published=1
AND id = '330'
SELECT category_id
FROM jos_redshop_product_category_xref
WHERE product_id=16437
SELECT *
FROM jos_menu
WHERE link LIKE '%com_redshop%'
AND published=1
AND link LIKE '%view=category%'
AND params NOT LIKE '%categoryid%'
SELECT *
FROM jos_menu
WHERE link LIKE '%com_redshop%'
AND published=1
AND link LIKE '%view=category%'
AND params LIKE '%categoryid=268
%'
SELECT category_parent_id
FROM jos_redshop_category_xref
WHERE category_child_id=268
SELECT *
FROM jos_menu
WHERE link LIKE '%com_redshop%'
AND published=1
AND link LIKE '%view=product%'
AND params LIKE '%productid=16437
%'
SELECT *
FROM jos_redshop_product
WHERE product_id = 16437
SELECT *
FROM jos_redshop_template
WHERE template_section LIKE 'related_product'
AND published=1
SELECT *
FROM jos_redshop_product AS p ,jos_redshop_product_related AS r
WHERE r.related_id = p.product_id
AND r.product_id=16437
AND p.published = 1
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 = 330 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 = '330'