Small, typical wooden plate as used in traditional taverns and country fairs.
Medium size, typical wooden plate as used in traditional taverns and country fairs.
Large, typical wooden plate as used in traditional taverns and country fairs.
Typical wooden plates used in traditional taverns and country fairs. This basic set for two people includes 2xSmall and 2xMedium wooden plates.
Red kilt towel for children; perfect for the beach, the bath...
Impress your friends with the fun Kilt Towel! Just put the towel around your waist and you'll have a kilt on the beach!
Typical wooden plates used in traditional taverns and country fairs. This basic set for four people includes 4xSmall and 4xMedium wooden plates.
Re-create an iconic Galician landmark with this Santiago de Compostela Cathedral 3D Jigsaw Puzzle. Measuring an impressive 37 x 26 x 23 cm when complete (14.5'' x 10.2'' x 9''), this is the perfect puzzle to display for all to admire.
All orders taken using Secure Server based in the U.S. Please read our Terms and Conditions and Privacy Policy for details.
![]()
Application 0.000 seconds (+0.000); 0.61 MB (+0.612) - afterLoadApplication 0.021 seconds (+0.020); 4.16 MB (+3.545) - afterInitialiseApplication 0.032 seconds (+0.012); 6.12 MB (+1.965) - afterRouteApplication 0.157 seconds (+0.124); 12.88 MB (+6.755) - afterDispatchApplication 0.168 seconds (+0.011); 13.83 MB (+0.956) - beforeRenderModule mod_custom (Secure Payment)Application 0.173 seconds (+0.005); 14.31 MB (+0.475) - afterRenderModule mod_custom (Secure Payment)Application 0.173 seconds (+0.000); 14.31 MB (-0.002) - beforeRenderModule mod_menu (Terms of Service)Application 0.175 seconds (+0.002); 14.36 MB (+0.056) - afterRenderModule mod_menu (Terms of Service)Application 0.175 seconds (+0.000); 14.36 MB (-0.005) - beforeRenderModule mod_menu (Contact Us)Application 0.175 seconds (+0.000); 14.36 MB (+0.005) - afterRenderModule mod_menu (Contact Us)Application 0.175 seconds (+0.000); 14.36 MB (-0.005) - beforeRenderModule mod_custom (Like Us / Follow Us)Application 0.175 seconds (+0.001); 14.36 MB (+0.004) - afterRenderModule mod_custom (Like Us / Follow Us)Application 0.175 seconds (+0.000); 14.36 MB (-0.001) - beforeRenderModule mod_virtuemart_product (Featured Products)Application 0.229 seconds (+0.054); 15.73 MB (+1.374) - afterRenderModule mod_virtuemart_product (Featured Products)Application 0.229 seconds (+0.000); 15.73 MB (-0.008) - beforeRenderModule mod_virtuemart_search (Search)Application 0.231 seconds (+0.002); 15.74 MB (+0.015) - afterRenderModule mod_virtuemart_search (Search)Application 0.231 seconds (+0.000); 15.74 MB (-0.006) - beforeRenderModule mod_virtuemart_category (Products)Application 0.252 seconds (+0.021); 15.84 MB (+0.106) - afterRenderModule mod_virtuemart_category (Products)Application 0.252 seconds (+0.000); 15.84 MB (-0.003) - beforeRenderModule mod_virtuemart_currencies (View prices in your currency)Application 0.254 seconds (+0.002); 15.95 MB (+0.113) - afterRenderModule mod_virtuemart_currencies (View prices in your currency)Application 0.254 seconds (+0.000); 15.95 MB (-0.002) - beforeRenderModule mod_metamod (Most Popular Last Month)Application 0.259 seconds (+0.005); 16.81 MB (+0.862) - afterRenderModule mod_metamod (Most Popular Last Month)Application 0.259 seconds (+0.000); 16.81 MB (-0.005) - beforeRenderModule mod_metamod (MetaMod Welcome)Application 0.259 seconds (+0.000); 16.81 MB (+0.007) - afterRenderModule mod_metamod (MetaMod Welcome)Application 0.259 seconds (+0.000); 16.81 MB (-0.005) - beforeRenderModule mod_metamod (MetaMod)Application 0.259 seconds (+0.000); 16.81 MB (+0.007) - afterRenderModule mod_metamod (MetaMod)Application 0.259 seconds (+0.000); 16.81 MB (-0.006) - beforeRenderModule mod_metamod (MetaMod Kilt Gallaecia)Application 0.259 seconds (+0.000); 16.82 MB (+0.007) - afterRenderModule mod_metamod (MetaMod Kilt Gallaecia)Application 0.260 seconds (+0.000); 16.81 MB (-0.008) - beforeRenderModule mod_custom (Banner)Application 0.260 seconds (+0.001); 16.81 MB (+0.004) - afterRenderModule mod_custom (Banner)Application 0.260 seconds (+0.000); 16.81 MB (-0.003) - beforeRenderModule mod_custom (Languages)Application 0.261 seconds (+0.001); 16.81 MB (+0.004) - afterRenderModule mod_custom (Languages)Application 0.264 seconds (+0.003); 16.90 MB (+0.088) - afterRender16.92 MB (17,743,312 Bytes)SELECT `data`
FROM `vgali_session`
WHERE `session_id` = 'd2c3a32779480def5cbf0767ecbcb14a'SELECT folder AS type, element AS name, params
FROM vgali_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY orderingSELECT extension_id AS id, element AS "option", params, enabled
FROM vgali_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 vgali_menu AS m
LEFT JOIN vgali_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.lftSHOW TABLES LIKE "vgali_virtuemart_configs"SELECT `config`
FROM `vgali_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";SELECT extension_id AS id, element AS "option", params, enabled
FROM vgali_extensions
WHERE `type` = 'component'
AND `element` = 'com_virtuemart'SELECT *
FROM `vgali_menu`
where `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language = "en-GB" )SELECT `virtuemart_category_id`
FROM `vgali_virtuemart_categories_en_gb`
WHERE `slug` LIKE 'home-items'SELECT *
FROM vgali_languages
WHERE published=1
ORDER BY ordering ASCSELECT id, home, template, s.params
FROM vgali_template_styles as s
LEFT JOIN vgali_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 = 1SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 47SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=47SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `vgali_virtuemart_categories`.`virtuemart_category_id` = "47"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "47"
ORDER BY `ordering`SELECT `category_child_id`
FROM `vgali_virtuemart_category_categories`
WHERE `category_parent_id` = 47SELECT extension_id AS id, element AS "option", params, enabled
FROM vgali_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT b.id
FROM vgali_usergroups AS a
LEFT JOIN vgali_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1SELECT a.rules
FROM vgali_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftSHOW FULL COLUMNS
FROM `vgali_assets`SELECT id
FROM vgali_assets
WHERE parent_id = 0SELECT b.rules
FROM vgali_assets AS a
LEFT JOIN vgali_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT b.rules
FROM vgali_assets AS a
LEFT JOIN vgali_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_virtuemart')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT 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 `vgali_virtuemart_categories_en_gb` l
JOIN `vgali_virtuemart_categories` AS c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` AS cx
ON l.`virtuemart_category_id` = cx.`category_child_id`
WHERE c.`published` = 1
AND cx.`category_parent_id` = 47
AND (c.`virtuemart_vendor_id` = "1" OR c.`shared` = "1")
ORDER BY c.ordering ASC
LIMIT 0, 50SELECT FOUND_ROWS()SELECT count(vgali_virtuemart_products.virtuemart_product_id) AS total
FROM `vgali_virtuemart_products`, `vgali_virtuemart_product_categories`
WHERE `vgali_virtuemart_products`.`virtuemart_vendor_id` = "1"
AND `vgali_virtuemart_product_categories`.`virtuemart_category_id` = 47
AND `vgali_virtuemart_products`.`virtuemart_product_id` = `vgali_virtuemart_product_categories`.`virtuemart_product_id`
AND `vgali_virtuemart_products`.`published` = "1"SELECT `category_name`,`virtuemart_category_id`
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=47SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_vmuser_shoppergroups`
WHERE `virtuemart_user_id` = "0"SELECT *
FROM `vgali_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` , IF(pp.override, pp.product_override_price, pp.product_price) as product_price
FROM `vgali_virtuemart_products` as p
INNER JOIN `vgali_virtuemart_products_en_gb` as l using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( p.`published`="1"
AND `pc`.`virtuemart_category_id` = 47
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) )
group by p.`virtuemart_product_id`
ORDER BY `product_price` ASC
LIMIT 0, 200SELECT FOUND_ROWS()SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "71"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "71"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "71"SELECT *
FROM `vgali_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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 `vgali_virtuemart_manufacturers`.* ,`vgali_virtuemart_manufacturers_en_gb`.*
FROM `vgali_virtuemart_manufacturers`
INNER JOIN `vgali_virtuemart_manufacturers_en_gb` using (`virtuemart_manufacturer_id`)
WHERE `vgali_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "1"SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 71SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 71
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "71"
and `virtuemart_category_id`= "47"SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =71
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_idSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =71
and `field_type` = "Z"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =71
and `field_type` = "R"
and is_cart_attribute = 0
order by orderingSELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `vgali_virtuemart_vendors` AS v
LEFT JOIN `vgali_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency
WHERE v.`virtuemart_vendor_id`="1"SELECT *
FROM `vgali_virtuemart_currencies`
WHERE `virtuemart_currency_id`="47"SELECT `price_display`,`custom_price_display`
FROM `vgali_virtuemart_shoppergroups` AS `sg`
WHERE `sg`.`default` = "2"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "190"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "190"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "190"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "190"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 190SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 190
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "190"
and `virtuemart_category_id`= "14"SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `vgali_virtuemart_categories`.`virtuemart_category_id` = "14"SELECT *
FROM `vgali_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"SELECT *
FROM vgali_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 <= "2026-06-09 15:39:44" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-06-09 15:39:44" )
OR `for_override` = "1" )SELECT `virtuemart_category_id`
FROM vgali_virtuemart_calc_categories
WHERE `virtuemart_calc_id`="1"SELECT `virtuemart_shoppergroup_id`
FROM vgali_virtuemart_calc_shoppergroups
WHERE `virtuemart_calc_id`="1"SELECT `virtuemart_country_id`
FROM vgali_virtuemart_calc_countries
WHERE `virtuemart_calc_id`="1"SELECT `virtuemart_state_id`
FROM vgali_virtuemart_calc_states
WHERE `virtuemart_calc_id`="1"SELECT `virtuemart_manufacturer_id`
FROM vgali_virtuemart_calc_manufacturers
WHERE `virtuemart_calc_id`="1"SELECT `virtuemart_category_id`
FROM vgali_virtuemart_calc_categories
WHERE `virtuemart_calc_id`="2"SELECT `virtuemart_shoppergroup_id`
FROM vgali_virtuemart_calc_shoppergroups
WHERE `virtuemart_calc_id`="2"SELECT `virtuemart_country_id`
FROM vgali_virtuemart_calc_countries
WHERE `virtuemart_calc_id`="2"SELECT `virtuemart_state_id`
FROM vgali_virtuemart_calc_states
WHERE `virtuemart_calc_id`="2"SELECT `virtuemart_manufacturer_id`
FROM vgali_virtuemart_calc_manufacturers
WHERE `virtuemart_calc_id`="2"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 32SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=32SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 190SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 14SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=14SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "595"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "78"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "78"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "78"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "78"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 78SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 78
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "78"
and `virtuemart_category_id`= "47"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 21SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=21SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 78SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "601"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "376"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "376"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "376"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "376"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 376SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 376
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "376"
and `virtuemart_category_id`= "3"SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `vgali_virtuemart_categories`.`virtuemart_category_id` = "3"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 5SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 3SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=3SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=5SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 376SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "898"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "79"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "79"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "79"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "79"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 79SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 79
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "79"
and `virtuemart_category_id`= "47"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 79SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "624"SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =71
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`SELECT virtuemart_product_id, product_name
FROM `vgali_virtuemart_products_en_gb`
JOIN `vgali_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =79SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 71SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "72"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "72"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "72"SELECT *
FROM `vgali_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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 72SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 72
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "72"
and `virtuemart_category_id`= "47"SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =72
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_idSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =72
and `field_type` = "Z"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =72
and `field_type` = "R"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =72
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`SELECT virtuemart_product_id, product_name
FROM `vgali_virtuemart_products_en_gb`
JOIN `vgali_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =376SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 72SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "73"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "73"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "73"SELECT *
FROM `vgali_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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 73SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 73
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "73"
and `virtuemart_category_id`= "47"SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =73
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_idSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =73
and `field_type` = "Z"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =73
and `field_type` = "R"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =73
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`SELECT virtuemart_product_id, product_name
FROM `vgali_virtuemart_products_en_gb`
JOIN `vgali_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =190SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 73SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "490"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "490"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "490"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "490"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 490SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 490
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "490"
and `virtuemart_category_id`= "47"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 8SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=8SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 490SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "132"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "132"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "132"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "132"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 132SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 132
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "132"
and `virtuemart_category_id`= "47"SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =132
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_idSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =132
and `field_type` = "Z"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =132
and `field_type` = "R"
and is_cart_attribute = 0
order by orderingSELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "3"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "3"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "3"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "3"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 3SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 3
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "3"
and `virtuemart_category_id`= "14"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 27SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=27SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 3SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "588"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "205"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "205"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "205"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "205"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 205SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 205
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "205"
and `virtuemart_category_id`= "27"SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `vgali_virtuemart_categories`.`virtuemart_category_id` = "27"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 205SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1136"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "248"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "248"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "248"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "248"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 248SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 248
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "248"
and `virtuemart_category_id`= "22"SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `vgali_virtuemart_categories`.`virtuemart_category_id` = "22"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 29SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 22SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=22SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=29SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 248SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "583"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "178"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "178"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "178"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "178"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 178SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 178
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "178"
and `virtuemart_category_id`= "14"SELECT id
FROM vgali_assets
WHERE parent_id = 0SELECT id
FROM vgali_assets
WHERE parent_id = 0SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =132
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`SELECT virtuemart_product_id, product_name
FROM `vgali_virtuemart_products_en_gb`
JOIN `vgali_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =178SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 132SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "128"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "128"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "128"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "128"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 128SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 128
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "128"
and `virtuemart_category_id`= "47"SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =128
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_idSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =128
and `field_type` = "Z"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =128
and `field_type` = "R"
and is_cart_attribute = 0
order by orderingSELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "112"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "112"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "112"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "112"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 112SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 112
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "112"
and `virtuemart_category_id`= "47"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 112SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "599"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "129"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "129"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "129"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "129"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 129SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 129
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "129"
and `virtuemart_category_id`= "47"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 129SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "587"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "127"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "127"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "127"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "127"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 127SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 127
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "127"
and `virtuemart_category_id`= "47"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 127SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "860"SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =128
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`SELECT virtuemart_product_id, product_name
FROM `vgali_virtuemart_products_en_gb`
JOIN `vgali_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =3SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 128SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "374"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "374"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "374"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "374"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 374SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 374
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "374"
and `virtuemart_category_id`= "47"SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =374
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_idSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =374
and `field_type` = "Z"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =374
and `field_type` = "R"
and is_cart_attribute = 0
order by orderingSELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "366"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "366"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "366"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "366"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 366SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 366
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "366"
and `virtuemart_category_id`= "8"SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `vgali_virtuemart_categories`.`virtuemart_category_id` = "8"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 43SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=43SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=50SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 366SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "883"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "380"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "380"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "380"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "380"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 380SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 380
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "380"
and `virtuemart_category_id`= "7"SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `vgali_virtuemart_categories`.`virtuemart_category_id` = "7"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 7SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=7SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 380SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "902"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "365"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "365"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "365"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "365"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 365SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 365
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "365"
and `virtuemart_category_id`= "8"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 51SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=51SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 365SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "882"SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =374
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`SELECT virtuemart_product_id, product_name
FROM `vgali_virtuemart_products_en_gb`
JOIN `vgali_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =365SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 48SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=48SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 374SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "627"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "631"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "629"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1135"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "581"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "859"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1056"SELECT id
FROM vgali_assets
WHERE parent_id = 0SELECT L.*
FROM `vgali_virtuemart_categories_en_gb` as L
JOIN `vgali_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 47
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY c.ordering ASCSELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "21"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "48"
ORDER BY `ordering`SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "57"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "58"SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM vgali_modules AS m
LEFT JOIN vgali_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN vgali_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 <= '2026-06-09 15:39:44')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-09 15:39:44')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingSELECT extension_id AS id, element AS "option", params, enabled
FROM vgali_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'SELECT id
FROM vgali_assets
WHERE parent_id = 0SELECT p.`virtuemart_product_id` , IF(pp.override, pp.product_override_price, pp.product_price) as product_price
FROM `vgali_virtuemart_products` as p
INNER JOIN `vgali_virtuemart_products_en_gb` as l using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( p.`published`="1"
AND `pc`.`virtuemart_category_id` > 0
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) )
group by p.`virtuemart_product_id`
ORDER BY RAND() ASC
LIMIT 0, 5SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "419"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "419"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "419"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "419"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 419SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 419
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "419"
and `virtuemart_category_id`= "14"SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =419
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_idSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =419
and `field_type` = "Z"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =419
and `field_type` = "R"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =419
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`,
field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =419
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=8
ORDER BY field.`ordering`SELECT virtuemart_product_id, product_name
FROM `vgali_virtuemart_products_en_gb`
JOIN `vgali_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =419SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 419SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "469"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "469"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "469"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "469"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 469SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 469
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "469"
and `virtuemart_category_id`= "8"SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =469
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_idSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =469
and `field_type` = "Z"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =469
and `field_type` = "R"
and is_cart_attribute = 0
order by orderingSELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "367"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "367"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "367"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "367"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 367SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 367
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "367"
and `virtuemart_category_id`= "8"SELECT id
FROM vgali_assets
WHERE parent_id = 0SELECT id
FROM vgali_assets
WHERE parent_id = 0SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "210"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "210"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "210"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "210"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 210SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 210
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "210"
and `virtuemart_category_id`= "7"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 20SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=20SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 210SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "761"SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =469
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`SELECT virtuemart_product_id, product_name
FROM `vgali_virtuemart_products_en_gb`
JOIN `vgali_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =380SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 469SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "410"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "410"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "410"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "410"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 410SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 410
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "410"
and `virtuemart_category_id`= "22"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 410SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "472"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "472"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "472"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "472"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 472SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 472
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "472"
and `virtuemart_category_id`= "7"SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =472
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_idSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =472
and `field_type` = "Z"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =472
and `field_type` = "R"
and is_cart_attribute = 0
order by orderingSELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "60"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "60"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "60"SELECT *
FROM `vgali_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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 60SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 60
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "60"
and `virtuemart_category_id`= "7"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 60SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "756"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "321"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "321"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "321"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "321"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 321SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 321
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "321"
and `virtuemart_category_id`= "7"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 321SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "733"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "278"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "278"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "278"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "278"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 278SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 278
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "278"
and `virtuemart_category_id`= "7"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 278SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "781"SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =472
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`,
field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =472
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=7
ORDER BY field.`ordering`SELECT virtuemart_product_id, product_name
FROM `vgali_virtuemart_products_en_gb`
JOIN `vgali_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =278SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 472SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "377"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "377"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "377"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "377"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 377SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 377
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "377"
and `virtuemart_category_id`= "3"SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =377
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_idSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =377
and `field_type` = "Z"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =377
and `field_type` = "R"
and is_cart_attribute = 0
order by orderingSELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "116"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "116"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "116"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "116"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 116SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 116
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "116"
and `virtuemart_category_id`= "7"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 116SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "907"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "6"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 6SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 6
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6"
and `virtuemart_category_id`= "3"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 6SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "706"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "300"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "300"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "300"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "300"
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` <= "2026-06-09 15:39:44" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 15:39:44" ) )
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 pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 300SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 300
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "300"
and `virtuemart_category_id`= "43"SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `vgali_virtuemart_categories`.`virtuemart_category_id` = "43"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 49SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=49SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 300SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "609"SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =377
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`SELECT virtuemart_product_id, product_name
FROM `vgali_virtuemart_products_en_gb`
JOIN `vgali_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =300SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 377SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "984"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "985"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1091"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "955"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1100"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1101"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1102"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "899"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 0SELECT L.*
FROM `vgali_virtuemart_categories_en_gb` as L
JOIN `vgali_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 0
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY c.ordering ASCSELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "27"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "22"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "7"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "8"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "3"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "19"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "28"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "37"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "32"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "47"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "43"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "14"
ORDER BY `ordering`SELECT L.*
FROM `vgali_virtuemart_categories_en_gb` as L
JOIN `vgali_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 27
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY c.ordering ASCSELECT L.*
FROM `vgali_virtuemart_categories_en_gb` as L
JOIN `vgali_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 22
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY c.ordering ASCSELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "29"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "30"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "31"
ORDER BY `ordering`SELECT L.*
FROM `vgali_virtuemart_categories_en_gb` as L
JOIN `vgali_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 7
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY c.ordering ASCSELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "20"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "38"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "24"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "52"
ORDER BY `ordering`SELECT L.*
FROM `vgali_virtuemart_categories_en_gb` as L
JOIN `vgali_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 8
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY c.ordering ASCSELECT L.*
FROM `vgali_virtuemart_categories_en_gb` as L
JOIN `vgali_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 3
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY c.ordering ASCSELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "5"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "16"
ORDER BY `ordering`SELECT L.*
FROM `vgali_virtuemart_categories_en_gb` as L
JOIN `vgali_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 19
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY c.ordering ASCSELECT L.*
FROM `vgali_virtuemart_categories_en_gb` as L
JOIN `vgali_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 28
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY c.ordering ASCSELECT L.*
FROM `vgali_virtuemart_categories_en_gb` as L
JOIN `vgali_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 37
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY c.ordering ASCSELECT L.*
FROM `vgali_virtuemart_categories_en_gb` as L
JOIN `vgali_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 32
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY c.ordering ASCSELECT L.*
FROM `vgali_virtuemart_categories_en_gb` as L
JOIN `vgali_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 43
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY c.ordering ASCSELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "49"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "50"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "51"
ORDER BY `ordering`SELECT L.*
FROM `vgali_virtuemart_categories_en_gb` as L
JOIN `vgali_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 14
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY c.ordering ASCSELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 30SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=30SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 31SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=31SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 38SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=38SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 24SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=24SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 52SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=52SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 16SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=16SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 19SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=19SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 28SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=28SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 37SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=37SELECT CONCAT(`vendor_accepted_currencies`, ",",`vendor_currency`) AS all_currencies, `vendor_currency`
FROM `vgali_virtuemart_vendors`
WHERE `virtuemart_vendor_id`=1SELECT `virtuemart_currency_id`,CONCAT_WS(" ",`currency_name`,`currency_symbol`) as currency_txt
FROM `vgali_virtuemart_currencies`
WHERE `virtuemart_currency_id` IN (52,47,144,47)
and (`virtuemart_vendor_id` = "1" OR `shared`="1")
AND published = "1"
ORDER BY `ordering`,`currency_name`SELECT `value`
FROM `vgali_admintools_storage`
WHERE `key` = 'cparams'UPDATE `vgali_session`
SET `data` = 'joomla|s:2892:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjQ6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjI7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzgxMDE5NTgzO3M6NDoibGFzdCI7aToxNzgxMDE5NTgzO3M6Mzoibm93IjtpOjE3ODEwMTk1ODQ7fXM6NjoiY2xpZW50IjtPOjg6InN0ZENsYXNzIjoxOntzOjk6ImZvcndhcmRlZCI7czoxMjoiMTAuMS4xMjUuMTM4Ijt9fXM6ODoicmVnaXN0cnkiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjE6e3M6MTQ6ImNvbV92aXJ0dWVtYXJ0IjtPOjg6InN0ZENsYXNzIjozOntzOjg6ImNhdGVnb3J5IjtPOjg6InN0ZENsYXNzIjoyOntzOjU6ImxpbWl0IjtzOjM6ImludCI7czoxMDoibGltaXRzdGFydCI7aTowO31zOjExOiJjYXRlZ29yeWM0NyI7Tzo4OiJzdGRDbGFzcyI6MTp7czo1OiJsaW1pdCI7czozOiJpbnQiO31zOjEzOiJjYXRlZ29yeWM0N20wIjtPOjg6InN0ZENsYXNzIjoxOntzOjEwOiJsaW1pdHN0YXJ0IjtpOjA7fX19fXM6NDoidXNlciI7Tzo1OiJKVXNlciI6MjU6e3M6OToiACoAaXNSb290IjtiOjA7czoyOiJpZCI7aTowO3M6NDoibmFtZSI7TjtzOjg6InVzZXJuYW1lIjtOO3M6NToiZW1haWwiO047czo4OiJwYXNzd29yZCI7TjtzOjE0OiJwYXNzd29yZF9jbGVhciI7czowOiIiO3M6ODoidXNlcnR5cGUiO047czo1OiJibG9jayI7TjtzOjk6InNlbmRFbWFpbCI7aTowO3M6MTI6InJlZ2lzdGVyRGF0ZSI7TjtzOjEzOiJsYXN0dmlzaXREYXRlIjtOO3M6MTA6ImFjdGl2YXRpb24iO047czo2OiJwYXJhbXMiO047czo2OiJncm91cHMiO2E6MDp7fXM6NToiZ3Vlc3QiO2k6MTtzOjEzOiJsYXN0UmVzZXRUaW1lIjtOO3M6MTA6InJlc2V0Q291bnQiO047czoxMDoiACoAX3BhcmFtcyI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjE0OiIAKgBfYXV0aEdyb3VwcyI7YToxOntpOjA7aToxO31zOjE0OiIAKgBfYXV0aExldmVscyI7YToyOntpOjA7aToxO2k6MTtpOjE7fXM6MTU6IgAqAF9hdXRoQWN0aW9ucyI7TjtzOjEyOiIAKgBfZXJyb3JNc2ciO047czoxMDoiACoAX2Vycm9ycyI7YTowOnt9czozOiJhaWQiO2k6MDt9czoxMToiYXBwbGljYXRpb24iO086ODoic3RkQ2xhc3MiOjE6e3M6NToicXVldWUiO047fX1zOjQ6Il9fdm0iO086ODoic3RkQ2xhc3MiOjQ6e3M6Njoidm1jYXJ0IjtzOjc1MjoiTzo4OiJzdGRDbGFzcyI6Mjg6e3M6ODoicHJvZHVjdHMiO2E6MDp7fXM6ODoidmVuZG9ySWQiO2k6MTtzOjIxOiJsYXN0VmlzaXRlZENhdGVnb3J5SWQiO2k6MDtzOjI4OiJ2aXJ0dWVtYXJ0X3NoaXBtZW50bWV0aG9kX2lkIjtpOjA7czoyNzoidmlydHVlbWFydF9wYXltZW50bWV0aG9kX2lkIjtpOjA7czoyNToiYXV0b21hdGljU2VsZWN0ZWRTaGlwbWVudCI7YjowO3M6MjQ6ImF1dG9tYXRpY1NlbGVjdGVkUGF5bWVudCI7YjowO3M6MTI6Im9yZGVyX251bWJlciI7TjtzOjE5OiJ2aXJ0dWVtYXJ0X29yZGVyX2lkIjtiOjA7czoyOiJCVCI7aTowO3M6MjoiU1QiO2k6MDtzOjExOiJ0b3NBY2NlcHRlZCI7YjowO3M6MTY6ImN1c3RvbWVyX2NvbW1lbnQiO3M6MDoiIjtzOjEwOiJjb3Vwb25Db2RlIjtzOjA6IiI7czoyMDoiX3RyaWVzVmFsaWRhdGVDb3Vwb24iO2E6MDp7fXM6MTQ6Im9yZGVyX2xhbmd1YWdlIjtzOjA6IiI7czo4OiJjYXJ0RGF0YSI7TjtzOjU6Imxpc3RzIjtOO3M6MTQ6InByaWNlc0N1cnJlbmN5IjtOO3M6MTU6InBheW1lbnRDdXJyZW5jeSI7TjtzOjEwOiJfaW5Db25maXJtIjtiOjA7czoxMToiX2luQ2hlY2tPdXQiO2I6MDtzOjE0OiJfZGF0YVZhbGlkYXRlZCI7YjowO3M6MTI6Il9jb25maXJtRG9uZSI7YjowO3M6MTA6IlNUc2FtZUFzQlQiO2I6MTtzOjE1OiJjdXN0b21lcl9udW1iZXIiO3M6Nzoibm9ucmVnXyI7czo2OiJsYXlvdXQiO3M6NzoiZGVmYXVsdCI7czoxMDoibGF5b3V0UGF0aCI7czowOiIiO30iO3M6MjM6InZtbGFzdHZpc2l0ZWRjYXRlZ29yeWlkIjtpOjQ3O3M6MTk6InZtbGFzdHZpc2l0ZWRtYW51aWQiO2k6LTE7czoxNToidm1sYXN0dmlzSXRlbWlkIjtpOjEwMTt9fX0=\";'
, `time` = '1781019584'
WHERE `session_id` = 'd2c3a32779480def5cbf0767ecbcb14a'37 × SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`34 × SELECT *
FROM `vgali_virtuemart_product_prices`34 × SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`34 × SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc34 × SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`34 × SELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`34 × SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`34 × SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`32 × SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`27 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`27 × SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`26 × SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`20 × SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`13 × SELECT L.*
FROM `vgali_virtuemart_categories_en_gb` as L JOIN `vgali_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`10 × SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`10 × SELECT virtuemart_product_id, product_name
FROM `vgali_virtuemart_products_en_gb` JOIN `vgali_virtuemart_products` as C using (`virtuemart_product_id`)10 × SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`8 × SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)7 × SELECT id
FROM vgali_assets4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM vgali_extensions2 × SELECT b.rules
FROM vgali_assets AS a
LEFT JOIN vgali_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt2 × SELECT `virtuemart_manufacturer_id`
FROM vgali_virtuemart_calc_manufacturers2 × SELECT `virtuemart_country_id`
FROM vgali_virtuemart_calc_countries2 × SELECT `virtuemart_state_id`
FROM vgali_virtuemart_calc_states2 × SELECT *
FROM `vgali_virtuemart_shoppergroups`2 × SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`2 × SELECT FOUND_ROWS(2 × SELECT `virtuemart_category_id`
FROM vgali_virtuemart_calc_categories2 × SELECT `virtuemart_shoppergroup_id`
FROM vgali_virtuemart_calc_shoppergroups1 × SELECT CONCAT(`vendor_accepted_currencies`, ",",`vendor_currency`) AS all_currencies, `vendor_currency`
FROM `vgali_virtuemart_vendors`1 × SELECT *
FROM vgali_virtuemart_calcs1 × SELECT folder AS type, element AS name, params
FROM vgali_extensions1 × SELECT p.`virtuemart_product_id` , IF(pp.override, pp.product_override_price, pp.product_price) as product_price
FROM `vgali_virtuemart_products` as p
INNER JOIN `vgali_virtuemart_products_en_gb` as l using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM vgali_modules AS m
LEFT JOIN vgali_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN vgali_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `price_display`,`custom_price_display`
FROM `vgali_virtuemart_shoppergroups` AS `sg`1 × SELECT `virtuemart_currency_id`,CONCAT_WS(" ",`currency_name`,`currency_symbol`) as currency_txt
FROM `vgali_virtuemart_currencies`1 × SELECT `value`
FROM `vgali_admintools_storage`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 vgali_menu AS m
LEFT JOIN vgali_extensions AS e
ON m.component_id = e.extension_id1 × SELECT count(vgali_virtuemart_products.virtuemart_product_id) AS total
FROM `vgali_virtuemart_products`, `vgali_virtuemart_product_categories`1 × SELECT `category_name`,`virtuemart_category_id`
FROM `vgali_virtuemart_categories_en_gb`1 × SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_vmuser_shoppergroups`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 `vgali_virtuemart_categories_en_gb` l JOIN `vgali_virtuemart_categories` AS c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` AS cx
ON l.`virtuemart_category_id` = cx.`category_child_id`1 × SELECT a.rules
FROM vgali_assets AS a1 × SELECT `category_child_id`
FROM `vgali_virtuemart_category_categories`1 × SELECT b.id
FROM vgali_usergroups AS a
LEFT JOIN vgali_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` , IF(pp.override, pp.product_override_price, pp.product_price) as product_price
FROM `vgali_virtuemart_products` as p
INNER JOIN `vgali_virtuemart_products_en_gb` as l using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`1 × SELECT *
FROM vgali_languages1 × SELECT `config`
FROM `vgali_virtuemart_configs`1 × SELECT id, home, template, s.params
FROM vgali_template_styles as s
LEFT JOIN vgali_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `vgali_virtuemart_vendors` AS v
LEFT JOIN `vgali_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency1 × SELECT `vgali_virtuemart_manufacturers`.* ,`vgali_virtuemart_manufacturers_en_gb`.*
FROM `vgali_virtuemart_manufacturers`
INNER JOIN `vgali_virtuemart_manufacturers_en_gb` using (`virtuemart_manufacturer_id`)1 × SELECT *
FROM `vgali_menu`1 × SELECT `virtuemart_category_id`
FROM `vgali_virtuemart_categories_en_gb`1 × SELECT `data`
FROM `vgali_session`1 × SELECT *
FROM `vgali_virtuemart_currencies`1 × UPDATE `vgali_session`
SET `data` = 'joomla|s:2892:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjQ6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjI7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzgxMDE5NTgzO3M6NDoibGFzdCI7aToxNzgxMDE5NTgzO3M6Mzoibm93IjtpOjE3ODEwMTk1ODQ7fXM6NjoiY2xpZW50IjtPOjg6InN0ZENsYXNzIjoxOntzOjk6ImZvcndhcmRlZCI7czoxMjoiMTAuMS4xMjUuMTM4Ijt9fXM6ODoicmVnaXN0cnkiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjE6e3M6MTQ6ImNvbV92aXJ0dWVtYXJ0IjtPOjg6InN0ZENsYXNzIjozOntzOjg6ImNhdGVnb3J5IjtPOjg6InN0ZENsYXNzIjoyOntzOjU6ImxpbWl0IjtzOjM6ImludCI7czoxMDoibGltaXRzdGFydCI7aTowO31zOjExOiJjYXRlZ29yeWM0NyI7Tzo4OiJzdGRDbGFzcyI6MTp7czo1OiJsaW1pdCI7czozOiJpbnQiO31zOjEzOiJjYXRlZ29yeWM0N20wIjtPOjg6InN0ZENsYXNzIjoxOntzOjEwOiJsaW1pdHN0YXJ0IjtpOjA7fX19fXM6NDoidXNlciI7Tzo1OiJKVXNlciI6MjU6e3M6OToiACoAaXNSb290IjtiOjA7czoyOiJpZCI7aTowO3M6NDoibmFtZSI7TjtzOjg6InVzZXJuYW1lIjtOO3M6NToiZW1haWwiO047czo4OiJwYXNzd29yZCI7TjtzOjE0OiJwYXNzd29yZF9jbGVhciI7czowOiIiO3M6ODoidXNlcnR5cGUiO047czo1OiJibG9jayI7TjtzOjk6InNlbmRFbWFpbCI7aTowO3M6MTI6InJlZ2lzdGVyRGF0ZSI7TjtzOjEzOiJsYXN0dmlzaXREYXRlIjtOO3M6MTA6ImFjdGl2YXRpb24iO047czo2OiJwYXJhbXMiO047czo2OiJncm91cHMiO2E6MDp7fXM6NToiZ3Vlc3QiO2k6MTtzOjEzOiJsYXN0UmVzZXRUaW1lIjtOO3M6MTA6InJlc2V0Q291bnQiO047czoxMDoiACoAX3BhcmFtcyI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjE0OiIAKgBfYXV0aEdyb3VwcyI7YToxOntpOjA7aToxO31zOjE0OiIAKgBfYXV0aExldmVscyI7YToyOntpOjA7aToxO2k6MTtpOjE7fXM6MTU6IgAqAF9hdXRoQWN0aW9ucyI7TjtzOjEyOiIAKgBfZXJyb3JNc2ciO047czoxMDoiACoAX2Vycm9ycyI7YTowOnt9czozOiJhaWQiO2k6MDt9czoxMToiYXBwbGljYXRpb24iO086ODoic3RkQ2xhc3MiOjE6e3M6NToicXVldWUiO047fX1zOjQ6Il9fdm0iO086ODoic3RkQ2xhc3MiOjQ6e3M6Njoidm1jYXJ0IjtzOjc1MjoiTzo4OiJzdGRDbGFzcyI6Mjg6e3M6ODoicHJvZHVjdHMiO2E6MDp7fXM6ODoidmVuZG9ySWQiO2k6MTtzOjIxOiJsYXN0VmlzaXRlZENhdGVnb3J5SWQiO2k6MDtzOjI4OiJ2aXJ0dWVtYXJ0X3NoaXBtZW50bWV0aG9kX2lkIjtpOjA7czoyNzoidmlydHVlbWFydF9wYXltZW50bWV0aG9kX2lkIjtpOjA7czoyNToiYXV0b21hdGljU2VsZWN0ZWRTaGlwbWVudCI7YjowO3M6MjQ6ImF1dG9tYXRpY1NlbGVjdGVkUGF5bWVudCI7YjowO3M6MTI6Im9yZGVyX251bWJlciI7TjtzOjE5OiJ2aXJ0dWVtYXJ0X29yZGVyX2lkIjtiOjA7czoyOiJCVCI7aTowO3M6MjoiU1QiO2k6MDtzOjExOiJ0b3NBY2NlcHRlZCI7YjowO3M6MTY6ImN1c3RvbWVyX2NvbW1lbnQiO3M6MDoiIjtzOjEwOiJjb3Vwb25Db2RlIjtzOjA6IiI7czoyMDoiX3RyaWVzVmFsaWRhdGVDb3Vwb24iO2E6MDp7fXM6MTQ6Im9yZGVyX2xhbmd1YWdlIjtzOjA6IiI7czo4OiJjYXJ0RGF0YSI7TjtzOjU6Imxpc3RzIjtOO3M6MTQ6InByaWNlc0N1cnJlbmN5IjtOO3M6MTU6InBheW1lbnRDdXJyZW5jeSI7TjtzOjEwOiJfaW5Db25maXJtIjtiOjA7czoxMToiX2luQ2hlY2tPdXQiO2I6MDtzOjE0OiJfZGF0YVZhbGlkYXRlZCI7YjowO3M6MTI6Il9jb25maXJtRG9uZSI7YjowO3M6MTA6IlNUc2FtZUFzQlQiO2I6MTtzOjE1OiJjdXN0b21lcl9udW1iZXIiO3M6Nzoibm9ucmVnXyI7czo2OiJsYXlvdXQiO3M6NzoiZGVmYXVsdCI7czoxMDoibGF5b3V0UGF0aCI7czowOiIiO30iO3M6MjM6InZtbGFzdHZpc2l0ZWRjYXRlZ29yeWlkIjtpOjQ3O3M6MTk6InZtbGFzdHZpc2l0ZWRtYW51aWQiO2k6LTE7czoxNToidm1sYXN0dmlzSXRlbWlkIjtpOjEwMTt9fX0=\";' , `time` = '1781019584'1 × SHOW FULL COLUMNS
FROM `vgali_assets1 × SHOW TABLES LIKE "vgali_virtuemart_configs






