Joomla! Debug Console
session.client.browser ⇒ Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
password_clear ⇒
groups ⇒
vmcart ⇒ O:8:"stdClass":21:{s:8:"products";a:0:{}s:8:"vendorId";i:1;s:21:"lastVisitedCategoryId";i:0;s:28:"virtuemart_shipmentmethod_id";i:0;s:27:"virtuemart_paymentmethod_id";i:0;s:25:"automaticSelectedShipment";b:0;s:24:"automaticSelectedPayment";b:0;s:12:"order_number";N;s:2:"BT";i:0;s:2:"ST";i:0;s:11:"tosAccepted";N;s:16:"customer_comment";s:0:"";s:10:"couponCode";s:0:"";s:8:"cartData";N;s:5:"lists";N;s:14:"pricesCurrency";N;s:15:"paymentCurrency";N;s:11:"_inCheckOut";b:0;s:14:"_dataValidated";b:0;s:12:"_confirmDone";b:0;s:10:"STsameAsBT";i:0;}
4.9 MB (5,135,960 Bytes)
311 Queries Logged
SELECT `data`
FROM `josnj_session`
WHERE `session_id` = '14a80d405d8de27d1c1aad77319ab7dd'
DELETE
FROM `josnj_session`
WHERE `time` < '1754428853'
SELECT folder AS type, element AS name, params
FROM josnj_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM josnj_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM josnj_menu AS m
LEFT JOIN josnj_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SHOW TABLES LIKE "%virtuemart_configs%"
SELECT `config`
FROM `josnj_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `josnj_virtuemart_permgroups`
ORDER BY `group_level`
SELECT *
FROM josnj_languages
WHERE published=1
ORDER BY ordering ASC
SELECT extension_id AS id, element AS "option", params, enabled
FROM josnj_extensions
WHERE `type` = 'component'
AND `element` = 'com_virtuemart'
SELECT *
FROM `josnj_menu`
where `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language="en_gb")
SELECT id, home, template, s.params
FROM josnj_template_styles as s
LEFT JOIN josnj_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT manifest_cache
FROM josnj_extensions
WHERE element LIKE 'jsn_epic_free'
SELECT COUNT(*)
FROM josnj_extensions
WHERE type = 'component'
AND element = 'com_sh404sef'
SELECT extension_id AS id, element AS "option", params, enabled
FROM josnj_extensions
WHERE `type` = 'component'
AND `element` = 'com_menus'
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "0"
ORDER BY `ordering`
SELECT `category_child_id`
FROM `josnj_virtuemart_category_categories`
WHERE `category_parent_id` = 0
SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
FROM `josnj_virtuemart_categories_en_gb` l
JOIN `josnj_virtuemart_categories` AS c using (`virtuemart_category_id`)
LEFT JOIN `josnj_virtuemart_category_categories` AS cx
ON l.`virtuemart_category_id` = cx.`category_child_id`
WHERE c.`published` = 1
AND cx.`category_parent_id` = 0
AND (c.`virtuemart_vendor_id` = "1" OR c.`shared` = "1")
ORDER BY category_name ASC
LIMIT 0, 20
SELECT FOUND_ROWS()
SELECT L.*
FROM `josnj_virtuemart_categories_en_gb` as L
JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `josnj_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 0
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "13"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "4"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "1"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "5"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "6"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "7"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "8"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "9"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "10"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "11"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "12"
ORDER BY `ordering`
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "83"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "82"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "81"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "80"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "79"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "78"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "77"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "76"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "75"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "74"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 0
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_vmuser_shoppergroups`
WHERE `virtuemart_user_id` = "0"
SELECT *
FROM `josnj_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
SELECT `virtuemart_userinfo_id`
FROM `josnj_virtuemart_userinfos`
WHERE `virtuemart_user_id` = "0"
SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id`
FROM `josnj_virtuemart_products_en_gb` as l JOIN `josnj_virtuemart_products` AS p using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_categories_en_gb` as c
ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
LEFT JOIN `josnj_virtuemart_product_shoppergroups`
ON p.`virtuemart_product_id` = `josnj_virtuemart_product_shoppergroups`.`virtuemart_product_id`
LEFT
OUTER JOIN `josnj_virtuemart_shoppergroups` as s
ON s.`virtuemart_shoppergroup_id` = `josnj_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
WHERE ( p.`published`="1"
AND `pc`.`virtuemart_category_id` > 0
AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL ) )
group by p.`virtuemart_product_id`
ORDER BY `category_name` DESC
LIMIT 0, 20
SELECT FOUND_ROWS()
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "72"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "72"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "72"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "72"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "11"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 72
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "72"
and `virtuemart_category_id`= "12"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "12"
SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `josnj_virtuemart_vendors` AS v
LEFT JOIN `josnj_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency
WHERE v.`virtuemart_vendor_id`="1"
SELECT *
FROM `josnj_virtuemart_currencies`
WHERE `virtuemart_currency_id`="65"
SELECT `price_display`,`custom_price_display`
FROM `josnj_virtuemart_shoppergroups` AS `sg`
WHERE `sg`.`default` = "2"
SELECT *
FROM `josnj_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
SELECT *
FROM josnj_virtuemart_calcs
WHERE
`calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-08-05 21:35:53" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-08-05 21:35:53" )
OR `for_override` = "1" )
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 12
SELECT `slug` as name
FROM `josnj_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=12
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 72
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "73"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "73"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "73"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "73"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "11"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 73
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "73"
and `virtuemart_category_id`= "12"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "12"
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 73
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "69"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "69"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "69"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "69"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "11"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 69
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "69"
and `virtuemart_category_id`= "12"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "12"
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 69
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "70"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "70"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "70"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "70"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "11"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 70
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "70"
and `virtuemart_category_id`= "12"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "12"
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 70
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "71"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "71"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "71"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "71"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "11"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 71
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "71"
and `virtuemart_category_id`= "12"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "12"
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 71
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "65"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "65"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "65"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "65"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "10"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 65
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "65"
and `virtuemart_category_id`= "11"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "11"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 11
SELECT `slug` as name
FROM `josnj_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=11
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 65
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "66"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "66"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "66"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "66"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "10"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 66
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "66"
and `virtuemart_category_id`= "11"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "11"
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 66
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "67"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "67"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "67"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "67"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "10"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 67
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "67"
and `virtuemart_category_id`= "11"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "11"
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 67
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "68"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "68"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "68"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "68"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "10"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 68
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "68"
and `virtuemart_category_id`= "11"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "11"
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 68
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "63"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "63"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "63"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "63"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "10"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 63
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "63"
and `virtuemart_category_id`= "11"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "11"
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 63
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "64"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "64"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "64"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "64"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "10"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 64
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "64"
and `virtuemart_category_id`= "11"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "11"
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 64
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "59"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "59"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "59"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "59"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "9"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 59
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "59"
and `virtuemart_category_id`= "10"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "10"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 10
SELECT `slug` as name
FROM `josnj_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=10
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 59
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "60"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "60"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "60"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "60"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "9"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 60
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "60"
and `virtuemart_category_id`= "10"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "10"
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 60
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "61"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "61"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "61"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "61"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "9"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 61
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "61"
and `virtuemart_category_id`= "10"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "10"
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 61
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "62"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "62"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "62"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "62"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "9"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 62
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "62"
and `virtuemart_category_id`= "10"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "10"
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 62
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "56"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "56"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "56"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "56"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "7"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 56
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "56"
and `virtuemart_category_id`= "9"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "9"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 9
SELECT `slug` as name
FROM `josnj_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=9
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 56
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "57"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "57"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "57"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "57"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "7"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 57
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "57"
and `virtuemart_category_id`= "9"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "9"
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 57
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "58"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "58"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "58"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "58"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "7"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 58
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "58"
and `virtuemart_category_id`= "9"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "9"
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 58
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "52"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "52"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "52"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "52"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "6"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 52
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "52"
and `virtuemart_category_id`= "8"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "8"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 8
SELECT `slug` as name
FROM `josnj_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=8
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 52
SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "53"
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "53"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "53"
SELECT *
FROM `josnj_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "53"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:53" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "6"
SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 53
SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "53"
and `virtuemart_category_id`= "8"
SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "8"
SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 53
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "72"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "73"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "69"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "70"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "71"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "65"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "66"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "67"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "68"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "63"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "64"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "59"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "60"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "61"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "62"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "56"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "57"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "58"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "52"
SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "53"
SELECT DISTINCT l.`mf_name`,l.`virtuemart_manufacturer_id`
FROM `josnj_virtuemart_manufacturers_en_gb` as l JOIN `josnj_virtuemart_product_manufacturers` AS pm using (`virtuemart_manufacturer_id`)
LEFT JOIN `josnj_virtuemart_products` as p
ON p.`virtuemart_product_id` = pm.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_categories` as c
ON c.`virtuemart_product_id` = pm.`virtuemart_product_id`
WHERE p.`published` =1
ORDER BY l.`mf_name`
SELECT `slug`
FROM `josnj_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=12
SELECT `slug`
FROM `josnj_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=2
SELECT `slug`
FROM `josnj_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=1
SELECT `slug`
FROM `josnj_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=3
SELECT `slug`
FROM `josnj_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=4
SELECT `slug`
FROM `josnj_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=5
SELECT `slug`
FROM `josnj_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=6
SELECT `slug`
FROM `josnj_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=7
SELECT `slug`
FROM `josnj_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=9
SELECT `slug`
FROM `josnj_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=10
SELECT `slug`
FROM `josnj_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=11
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 13
SELECT `slug` as name
FROM `josnj_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=13
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 4
SELECT `slug` as name
FROM `josnj_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=4
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 1
SELECT `slug` as name
FROM `josnj_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=1
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 5
SELECT `slug` as name
FROM `josnj_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=5
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 6
SELECT `slug` as name
FROM `josnj_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=6
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 7
SELECT `slug` as name
FROM `josnj_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=7
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM josnj_modules AS m
LEFT JOIN josnj_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN josnj_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-08-05 21:35:53')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-08-05 21:35:53')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT m.id
FROM josnj_modules AS m
INNER JOIN josnj_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.client_id = 0
AND m.published = 1
AND m.module LIKE 'mod_k2_%'
AND (mm.menuid < 0
AND mm.menuid = 0)
AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
left", "promo", "promo-right", "content-top", "content-top-below", "
left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")
SELECT m.id
FROM josnj_modules AS m
INNER JOIN josnj_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.client_id = 0
AND m.published = 1
AND m.module LIKE 'mod_k2_%'
AND (mm.menuid = 0 OR mm.menuid = 0 OR (mm.menuid < 0
AND mm.menuid != 0))
AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
left", "promo", "promo-right", "content-top", "content-top-below", "
left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")
GROUP BY m.id
SELECT extension_id AS id, element AS "option", params, enabled
FROM josnj_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT L.*
FROM `josnj_virtuemart_categories_en_gb` as L
JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `josnj_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 13
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `josnj_virtuemart_categories_en_gb` as L
JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `josnj_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 4
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `josnj_virtuemart_categories_en_gb` as L
JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `josnj_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 1
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "2"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "3"
ORDER BY `ordering`
SELECT L.*
FROM `josnj_virtuemart_categories_en_gb` as L
JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `josnj_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 5
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `josnj_virtuemart_categories_en_gb` as L
JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `josnj_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 6
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `josnj_virtuemart_categories_en_gb` as L
JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `josnj_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 7
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `josnj_virtuemart_categories_en_gb` as L
JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `josnj_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 8
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `josnj_virtuemart_categories_en_gb` as L
JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `josnj_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 9
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `josnj_virtuemart_categories_en_gb` as L
JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `josnj_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 10
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `josnj_virtuemart_categories_en_gb` as L
JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `josnj_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 11
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `josnj_virtuemart_categories_en_gb` as L
JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `josnj_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 12
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM `josnj_virtuemart_category_categories` AS `xref`
WHERE `xref`.`category_child_id`= 0
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 2
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 1
SELECT `slug` as name
FROM `josnj_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=2
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 3
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 1
SELECT `slug` as name
FROM `josnj_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=3
UPDATE `josnj_session`
SET `data` = '7yjw-Lp_pC5uc27nwovfQARLMAW2sJl80-UBmk7LwBucIsvt_PTPh-k5saZLnPDzO66qxwjj2nKG_wkMI1j6dKO1SwliXkivyIcYKSfUKMbTVnJBcMuPczT-iZK0ddw-KPR-QZF3s3BDi9aQHLCe4EmTcEO-GspwYo1N6WAu3NifTLxn8wcZtc1ldfPxrA4sTRQS49Zt0HkKy5b7doWnefIyvl5BtbgmFO3v1wD5swoLBcsAI8p1V5knAVs4GiGZWsfbL32fiD8s5MjnrMOQjrg0GNECCebl-bVwajpCbFjbpM_Z9ksdpx5ICUayE6Qk3ntK-kkKwRgJvTWrAskxRQTJwxYupG-FOkoql_Nt3CS3jku3FmTM2KQS53nMq-IBNRGCzc8DPfMJ1556otz0ZiwNSa1mps5WjJb33d51_Qkt6hBKQBkt3KyWOFPW_OT2q9PegaAjSv-Cvub0kNrKajt1ejJWUiQl8feTYGBO8GiNx2LCU88qoibGJlVZCreBqLaBz5NKTmKkDiNmfhW8_m447C4tkyFKhgyZGZv8s4hvrPi1WD_agXyh6N730DGwQsuGB50mmF8ED7ABgYFd3NG_y-F5eL-hJ76h02vUdjcmC3alklKutygiXEJI1zH5klaqE9lnePGuJ_LosSOEV1U2RUA4BakpnuxivHriExrR-LrIHC7QRRGhPsqlnvUicPyenhwPhA4Qla_tS6m1BINGxhuhWEIpv5QpHf1Y6fypEfpMpvoeQ9AJ9L-xCQKoOsIdFpfFtbYf5N81nPtchNAmhBcnQvKUDb48sV2FblJSIAc-cf7OJHpwsVi4h9O-NZJs9fb8UwIOtpWCEuh_rVfK2xE1MUq_nWBXYSW8rDIS-qbCZJqq9-c3AvG8nLA00mLcBbbc4WkRjfNU616uID7omaMibDIVgM0CdbLFBlEo2RWuw0DW7DB7GfdlhPMbNpS8rZbBVwqkDj38Hf15VkPO15ILiETcdSaqMXb6UZTLkSCOHbfgwvLLh6MTc7DyMCAowMqCixOlWIgtVo8wQZE_0kfw-MuvK2t6w2eprDflWcnRVIE5XiNGujYW7UKlDZFWBFsu8zmSkyH5jOGtp67e9O1duohR6mT9WNrQ8tr9zsP7mINq4yihKG-c0NP8pPiwW3AraZXAKH5_Tdk1phTBNoYIB7cxGFFV9hELhsCy-q4Vmo1veFTv7H-IxLP8GPT5HPf9vdR7EiAYKH8iA748tX5Acs1J3Nmi4Imzcsw987tD7256F4pCs0SvrPf4dkKnsPbf-8MMavVjZBKANyEzD_bjjQ-9H28jHKbB2KVe5RxzRMRlTr9l3FJZpPYirZQW41524Ohz93r-tt6XSpyNMQAPCD10QUWMAqC1Azs5huQ1l-fUjokHcjpj0L9LfJL5tUJmOld03QrJzn3dSETOT2eodhCwlqNc9ZszSAelHSMktw1JCGgqyfxqavHRoRbVIOqxu-A9q9VlpHRi5_-hb62uVBnjPusaCq9Q79HCXRJRGxHMao1D_6Jc-MzavJiobU9Y6Cg5pgVJcXHq1vDapYVZFdVSRNrmZ2fso5fszIzuATh_Ye-WYZKBgGqJZFcVoxEfxCp2PuzFXZovMgoV0iAAdqp96OCcFoRY_SNed12BwQst0qm0OVO2tpTrzGVo4hRmC1_KxkO__VajiM9NO5pNvx2ApNwCeaH_i3NDzNsA1Afl8QOwpgxJna-xuCKswGXIhphRvOtuJrOOVTrvpYKXYuTIgpHiU49FkL-Z5dox8erqp4_8Eb_FHds5k5u954mDx01fXD_sQ5objbNZDlNt96iOVwswpq9N7L9-rjxFrKiIWJS-8k_I_G97Xzrj1LOUVWl5fOzCxQ9GIEjAan7213ABi6QybeA34fLrYd6tYh-FDaGfc07089QYns1Xf6YgEq0uYXlnpwXetIgQR8mNyW68vihdvl46_Pb9E5zo-qmSP5ZMU9EFWiNN7sXcIeh0Iy57-TOankYAhTB34Kvs2-tmqaPCjdgd6TYY8blyBVfs0BBGj9bAel9Y7aPkFakIahm8-YTrQ0lTi2CKLylYctxvduIfDU8e3bsvJv-D_0UYRegL_wAzxhjV6mM05xUIde7tGOqp7_WL23Od1dNILvSYz_KLTbRGLtLjst4X64KEgnKycx3Z-xAxQxJ68yA-7dfhv_jCGM_t-6WVY_4eCtb2wHB0KagPBGRDobll8JwkuEvX4D1I8fxQeaf9wFf9ULuW-VCu7b3M0zBUJB-r8k1K2GsOnDi3aKP5HRQX7sWwCvB0iTSpbql_FIrIt-TUdeMbw8TRLh2YRcCJyGhKQnm0O5oBOThzqQGD6PFNjv6xKHPIODBd9ToT3_Sy2ZMuy-ohIw6w_Ku33w..'
, `time` = '1754429753'
WHERE `session_id` = '14a80d405d8de27d1c1aad77319ab7dd'
44 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
30 × SELECT `josnj_virtuemart_medias`.*
FROM `josnj_virtuemart_medias`
20 × SELECT pc.`virtuemart_category_id`
FROM `josnj_virtuemart_product_categories` as pc
20 × SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
20 × SELECT `ordering`,`id`
FROM `josnj_virtuemart_product_categories`
20 × SELECT `slug`
FROM `josnj_virtuemart_products_en_gb`
20 × SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
20 × SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_manufacturers`
on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_customfields`
on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
20 × SELECT *
FROM `josnj_virtuemart_product_prices`
20 × SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_product_medias`
20 × SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_product_shoppergroups`
16 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM josnj_virtuemart_category_categories AS `xref`
14 × SELECT `virtuemart_media_id`
FROM `josnj_virtuemart_category_medias`
13 × SELECT `slug` as name
FROM `josnj_virtuemart_categories_en_gb`
12 × SELECT L.*
FROM `josnj_virtuemart_categories_en_gb` as L
JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `josnj_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
11 × SELECT `slug`
FROM `josnj_virtuemart_manufacturers_en_gb`
4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM josnj_extensions
2 × SELECT FOUND_ROWS(
2 × SELECT *
FROM `josnj_virtuemart_shoppergroups`
2 × SELECT m.id
FROM josnj_modules AS m
INNER JOIN josnj_modules_menu AS mm
ON mm.moduleid = m.id
1 × SELECT *
FROM `josnj_virtuemart_currencies`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM josnj_modules AS m
LEFT JOIN josnj_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN josnj_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM `josnj_virtuemart_category_categories` AS `xref`
1 × SELECT DISTINCT l.`mf_name`,l.`virtuemart_manufacturer_id`
FROM `josnj_virtuemart_manufacturers_en_gb` as l JOIN `josnj_virtuemart_product_manufacturers` AS pm using (`virtuemart_manufacturer_id`)
LEFT JOIN `josnj_virtuemart_products` as p
ON p.`virtuemart_product_id` = pm.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_product_categories` as c
ON c.`virtuemart_product_id` = pm.`virtuemart_product_id`
1 × SELECT *
FROM josnj_virtuemart_calcs
1 × SELECT `price_display`,`custom_price_display`
FROM `josnj_virtuemart_shoppergroups` AS `sg`
1 × SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `josnj_virtuemart_vendors` AS v
LEFT JOIN `josnj_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency
1 × SELECT `virtuemart_userinfo_id`
FROM `josnj_virtuemart_userinfos`
1 × SELECT *
FROM josnj_languages
1 × SELECT *
FROM `josnj_menu`
1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `josnj_virtuemart_permgroups`
1 × SELECT `config`
FROM `josnj_virtuemart_configs`
1 × SELECT folder AS type, element AS name, params
FROM josnj_extensions
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM josnj_menu AS m
LEFT JOIN josnj_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT id, home, template, s.params
FROM josnj_template_styles as s
LEFT JOIN josnj_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT manifest_cache
FROM josnj_extensions
1 × SELECT `virtuemart_shoppergroup_id`
FROM `josnj_virtuemart_vmuser_shoppergroups`
1 × SELECT `data`
FROM `josnj_session`
1 × SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
FROM `josnj_virtuemart_categories_en_gb` l
JOIN `josnj_virtuemart_categories` AS c using (`virtuemart_category_id`)
LEFT JOIN `josnj_virtuemart_category_categories` AS cx
ON l.`virtuemart_category_id` = cx.`category_child_id`
1 × SELECT `category_child_id`
FROM `josnj_virtuemart_category_categories`
1 × SELECT COUNT(*)
FROM josnj_extensions
1 × SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id`
FROM `josnj_virtuemart_products_en_gb` as l JOIN `josnj_virtuemart_products` AS p using (`virtuemart_product_id`)
LEFT JOIN `josnj_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `josnj_virtuemart_categories_en_gb` as c
ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
LEFT JOIN `josnj_virtuemart_product_shoppergroups`
ON p.`virtuemart_product_id` = `josnj_virtuemart_product_shoppergroups`.`virtuemart_product_id`
LEFT
OUTER JOIN `josnj_virtuemart_shoppergroups` as s
ON s.`virtuemart_shoppergroup_id` = `josnj_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
OTHER Tables:
1 × UPDATE `josnj_session`
SET `data` = '7yjw-Lp_pC5uc27nwovfQARLMAW2sJl80-UBmk7LwBucIsvt_PTPh-k5saZLnPDzO66qxwjj2nKG_wkMI1j6dKO1SwliXkivyIcYKSfUKMbTVnJBcMuPczT-iZK0ddw-KPR-QZF3s3BDi9aQHLCe4EmTcEO-GspwYo1N6WAu3NifTLxn8wcZtc1ldfPxrA4sTRQS49Zt0HkKy5b7doWnefIyvl5BtbgmFO3v1wD5swoLBcsAI8p1V5knAVs4GiGZWsfbL32fiD8s5MjnrMOQjrg0GNECCebl-bVwajpCbFjbpM_Z9ksdpx5ICUayE6Qk3ntK-kkKwRgJvTWrAskxRQTJwxYupG-FOkoql_Nt3CS3jku3FmTM2KQS53nMq-IBNRGCzc8DPfMJ1556otz0ZiwNSa1mps5WjJb33d51_Qkt6hBKQBkt3KyWOFPW_OT2q9PegaAjSv-Cvub0kNrKajt1ejJWUiQl8feTYGBO8GiNx2LCU88qoibGJlVZCreBqLaBz5NKTmKkDiNmfhW8_m447C4tkyFKhgyZGZv8s4hvrPi1WD_agXyh6N730DGwQsuGB50mmF8ED7ABgYFd3NG_y-F5eL-hJ76h02vUdjcmC3alklKutygiXEJI1zH5klaqE9lnePGuJ_LosSOEV1U2RUA4BakpnuxivHriExrR-LrIHC7QRRGhPsqlnvUicPyenhwPhA4Qla_tS6m1BINGxhuhWEIpv5QpHf1Y6fypEfpMpvoeQ9AJ9L-xCQKoOsIdFpfFtbYf5N81nPtchNAmhBcnQvKUDb48sV2FblJSIAc-cf7OJHpwsVi4h9O-NZJs9fb8UwIOtpWCEuh_rVfK2xE1MUq_nWBXYSW8rDIS-qbCZJqq9-c3AvG8nLA00mLcBbbc4WkRjfNU616uID7omaMibDIVgM0CdbLFBlEo2RWuw0DW7DB7GfdlhPMbNpS8rZbBVwqkDj38Hf15VkPO15ILiETcdSaqMXb6UZTLkSCOHbfgwvLLh6MTc7DyMCAowMqCixOlWIgtVo8wQZE_0kfw-MuvK2t6w2eprDflWcnRVIE5XiNGujYW7UKlDZFWBFsu8zmSkyH5jOGtp67e9O1duohR6mT9WNrQ8tr9zsP7mINq4yihKG-c0NP8pPiwW3AraZXAKH5_Tdk1phTBNoYIB7cxGFFV9hELhsCy-q4Vmo1veFTv7H-IxLP8GPT5HPf9vdR7EiAYKH8iA748tX5Acs1J3Nmi4Imzcsw987tD7256F4pCs0SvrPf4dkKnsPbf-8MMavVjZBKANyEzD_bjjQ-9H28jHKbB2KVe5RxzRMRlTr9l3FJZpPYirZQW41524Ohz93r-tt6XSpyNMQAPCD10QUWMAqC1Azs5huQ1l-fUjokHcjpj0L9LfJL5tUJmOld03QrJzn3dSETOT2eodhCwlqNc9ZszSAelHSMktw1JCGgqyfxqavHRoRbVIOqxu-A9q9VlpHRi5_-hb62uVBnjPusaCq9Q79HCXRJRGxHMao1D_6Jc-MzavJiobU9Y6Cg5pgVJcXHq1vDapYVZFdVSRNrmZ2fso5fszIzuATh_Ye-WYZKBgGqJZFcVoxEfxCp2PuzFXZovMgoV0iAAdqp96OCcFoRY_SNed12BwQst0qm0OVO2tpTrzGVo4hRmC1_KxkO__VajiM9NO5pNvx2ApNwCeaH_i3NDzNsA1Afl8QOwpgxJna-xuCKswGXIhphRvOtuJrOOVTrvpYKXYuTIgpHiU49FkL-Z5dox8erqp4_8Eb_FHds5k5u954mDx01fXD_sQ5objbNZDlNt96iOVwswpq9N7L9-rjxFrKiIWJS-8k_I_G97Xzrj1LOUVWl5fOzCxQ9GIEjAan7213ABi6QybeA34fLrYd6tYh-FDaGfc07089QYns1Xf6YgEq0uYXlnpwXetIgQR8mNyW68vihdvl46_Pb9E5zo-qmSP5ZMU9EFWiNN7sXcIeh0Iy57-TOankYAhTB34Kvs2-tmqaPCjdgd6TYY8blyBVfs0BBGj9bAel9Y7aPkFakIahm8-YTrQ0lTi2CKLylYctxvduIfDU8e3bsvJv-D_0UYRegL_wAzxhjV6mM05xUIde7tGOqp7_WL23Od1dNILvSYz_KLTbRGLtLjst4X64KEgnKycx3Z-xAxQxJ68yA-7dfhv_jCGM_t-6WVY_4eCtb2wHB0KagPBGRDobll8JwkuEvX4D1I8fxQeaf9wFf9ULuW-VCu7b3M0zBUJB-r8k1K2GsOnDi3aKP5HRQX7sWwCvB0iTSpbql_FIrIt-TUdeMbw8TRLh2YRcCJyGhKQnm0O5oBOThzqQGD6PFNjv6xKHPIODBd9ToT3_Sy2ZMuy-ohIw6w_Ku33w..' , `time` = '1754429753'
1 × SHOW TABLES LIKE "%virtuemart_configs%
1 × DELETE
FROM `josnj_session`