Product details:
» Large sticker, size 12.3 x 10.9 cm (4.84'' x 4.29'').
» Made in quality vinyl, durable and water resistant.
» Read more about the history of the Holy Grail as the Coat of Arms of Galicia at www.galicianflag.com/holy_grail_kingdom_galicia.htm
Instructions:
1 Clean the surface where the decal will be installed.
2 Slowly removed the paper backing making sure that your decal remains stuck to the clear transfer tape. If part of your decal lifts up with the backing, press the paper backing back down against it until it stays stuck to the transfer tape.
3 Once your decal is peeled away from the backing, line up & position your decal against the surface to which it will be applied.
4 Use a credit card or something similar to smooth down your decal, making sure that it is completely stuck to the surface.
5 Carefully & Slowly, remove the transfer tape from your decal, making sure that your decal is stuck to the surface. If you see part of the decal does not release from the transfer tape, press it back down to the surface and repeat the process.
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.611) - afterLoadApplication 0.026 seconds (+0.026); 4.28 MB (+3.665) - afterInitialiseApplication 0.039 seconds (+0.013); 6.26 MB (+1.985) - afterRouteApplication 0.180 seconds (+0.141); 17.67 MB (+11.412) - afterDispatchApplication 0.192 seconds (+0.012); 18.61 MB (+0.933) - beforeRenderModule mod_custom (Secure Payment)Application 0.199 seconds (+0.006); 19.08 MB (+0.475) - afterRenderModule mod_custom (Secure Payment)Application 0.199 seconds (+0.000); 19.08 MB (-0.002) - beforeRenderModule mod_menu (Terms of Service)Application 0.201 seconds (+0.002); 19.14 MB (+0.057) - afterRenderModule mod_menu (Terms of Service)Application 0.201 seconds (+0.000); 19.13 MB (-0.005) - beforeRenderModule mod_menu (Contact Us)Application 0.202 seconds (+0.000); 19.14 MB (+0.005) - afterRenderModule mod_menu (Contact Us)Application 0.202 seconds (+0.000); 19.13 MB (-0.005) - beforeRenderModule mod_custom (Like Us / Follow Us)Application 0.202 seconds (+0.001); 19.13 MB (+0.004) - afterRenderModule mod_custom (Like Us / Follow Us)Application 0.202 seconds (+0.000); 19.13 MB (-0.001) - beforeRenderModule mod_virtuemart_product (Featured Products)Application 0.278 seconds (+0.076); 20.43 MB (+1.295) - afterRenderModule mod_virtuemart_product (Featured Products)Application 0.278 seconds (+0.000); 20.42 MB (-0.008) - beforeRenderModule mod_virtuemart_search (Search)Application 0.281 seconds (+0.002); 20.44 MB (+0.015) - afterRenderModule mod_virtuemart_search (Search)Application 0.281 seconds (+0.000); 20.43 MB (-0.006) - beforeRenderModule mod_virtuemart_category (Products)Application 0.289 seconds (+0.008); 20.54 MB (+0.107) - afterRenderModule mod_virtuemart_category (Products)Application 0.289 seconds (+0.000); 20.53 MB (-0.003) - beforeRenderModule mod_virtuemart_currencies (View prices in your currency)Application 0.291 seconds (+0.003); 20.64 MB (+0.109) - afterRenderModule mod_virtuemart_currencies (View prices in your currency)Application 0.291 seconds (+0.000); 20.64 MB (-0.002) - beforeRenderModule mod_metamod (Most Popular Last Month)Application 0.296 seconds (+0.005); 21.50 MB (+0.861) - afterRenderModule mod_metamod (Most Popular Last Month)Application 0.296 seconds (+0.000); 21.50 MB (-0.005) - beforeRenderModule mod_metamod (MetaMod Welcome)Application 0.297 seconds (+0.000); 21.50 MB (+0.007) - afterRenderModule mod_metamod (MetaMod Welcome)Application 0.297 seconds (+0.000); 21.50 MB (-0.005) - beforeRenderModule mod_metamod (MetaMod)Application 0.297 seconds (+0.000); 21.51 MB (+0.007) - afterRenderModule mod_metamod (MetaMod)Application 0.297 seconds (+0.000); 21.50 MB (-0.006) - beforeRenderModule mod_metamod (MetaMod Kilt Gallaecia)Application 0.297 seconds (+0.000); 21.51 MB (+0.007) - afterRenderModule mod_metamod (MetaMod Kilt Gallaecia)Application 0.297 seconds (+0.000); 21.50 MB (-0.008) - beforeRenderModule mod_custom (Banner)Application 0.298 seconds (+0.001); 21.50 MB (+0.004) - afterRenderModule mod_custom (Banner)Application 0.298 seconds (+0.000); 21.50 MB (-0.003) - beforeRenderModule mod_custom (Languages)Application 0.299 seconds (+0.001); 21.50 MB (+0.004) - afterRenderModule mod_custom (Languages)Application 0.301 seconds (+0.003); 21.57 MB (+0.069) - afterRender21.59 MB (22,638,256 Bytes)SELECT `data`
FROM `vgali_session`
WHERE `session_id` = '9d003dc8e9d9528e3a3e4405e1d56ed7'DELETE
FROM `vgali_session`
WHERE `time` < '1779032843'SELECT `session_id`
FROM `vgali_session`
WHERE `session_id` = '9d003dc8e9d9528e3a3e4405e1d56ed7'
LIMIT 0, 1INSERT INTO `vgali_session`
(`session_id`, `client_id`, `time`)
VALUES
('9d003dc8e9d9528e3a3e4405e1d56ed7', 0, '1779033743')SELECT 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 id, rules
FROM `vgali_viewlevels`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 'stickers'SELECT `p`.`virtuemart_product_id`
FROM `vgali_virtuemart_products_en_gb` AS `p`
LEFT JOIN `vgali_virtuemart_product_categories` AS `xref`
ON `p`.`virtuemart_product_id` = `xref`.`virtuemart_product_id`
WHERE `p`.`slug` LIKE "galician-coat-of-arms-sticker"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 `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 `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` = "440"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "440"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "440"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "440"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 440SELECT 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` = 440
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "440"
and `virtuemart_category_id`= "19"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` = "19"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` =440
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` =440
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` =440
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` = "204"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "204"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "204"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "204"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 204SELECT 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` = 204
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "204"
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-05-17 16:02:23" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-05-17 16:02:23" )
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`= 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` = 204SELECT `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` = "972"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` = "416"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "416"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "416"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "416"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 416SELECT 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` = 416
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "416"
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` = 416SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "969"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` = "125"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "125"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "125"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "125"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 125SELECT 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` = 125
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "125"
and `virtuemart_category_id`= "28"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` = "28"SELECT `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 `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 125SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "702"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` = "420"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "420"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "420"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "420"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 420SELECT 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` = 420
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "420"
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` = 420SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "989"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` =440
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` =420SELECT `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 `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 440SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1033"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "19"
ORDER BY `ordering`SELECT `category_child_id`
FROM `vgali_virtuemart_category_categories`
WHERE `category_parent_id` = 19SELECT 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` = 19
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`=19SELECT 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 id
FROM vgali_assets
WHERE parent_id = 0SELECT id
FROM vgali_assets
WHERE parent_id = 0SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id
FROM `vgali_virtuemart_shipmentmethods_en_gb` as l JOIN `vgali_virtuemart_shipmentmethods` AS v USING (`virtuemart_shipmentmethod_id`)
LEFT JOIN `vgali_extensions` as j
ON j.`extension_id` = v.`shipment_jplugin_id`
LEFT
OUTER JOIN `vgali_virtuemart_shipmentmethod_shoppergroups` AS s
ON v.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`
WHERE v.`published` = "1"
AND j.`element` = "weight_countries"
AND (v.`virtuemart_vendor_id` = "1" OR v.`virtuemart_vendor_id` = "0")
AND ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )
GROUP BY v.`virtuemart_shipmentmethod_id`
ORDER BY v.`ordering`SELECT `customer_number`
FROM `vgali_virtuemart_vmusers`
WHERE `virtuemart_user_id`='0'SHOW FULL COLUMNS
FROM `vgali_virtuemart_userfields`SELECT *
FROM `vgali_virtuemart_userfields`
WHERE 1 = 1
AND `account`=1
AND published = 1
ORDER BY orderingSELECT 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-05-17 16:02:23')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-05-17 16:02:23')
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` = "453"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "453"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "453"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "453"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 453SELECT 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` = 453
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "453"
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` =453
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` =453
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` =453
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` = "383"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "383"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "383"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "383"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 383SELECT 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` = 383
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "383"
and `virtuemart_category_id`= "14"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 383SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "905"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` = "389"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "389"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "389"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "389"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 389SELECT 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` = 389
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "389"
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`= 22SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=22SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 389SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "920"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` = "158"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "158"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "158"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "158"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 158SELECT 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` = 158
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "158"
and `virtuemart_category_id`= "22"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 158SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "664"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` = "351"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "351"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "351"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "351"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 351SELECT 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` = 351
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "351"
and `virtuemart_category_id`= "3"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 351SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "657"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` =453
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` =351SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 453SELECT `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` = "276"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "276"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "276"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "276"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 276SELECT 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` = 276
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "276"
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 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` =276
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` =276
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` =276
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` =276
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` =276
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=16
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` =276SELECT `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` = 276SELECT `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` = "30"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "30"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "30"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "30"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 30SELECT 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` = 30
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "30"
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` =30
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` =30
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` =30
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` = "336"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "336"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "336"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "336"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 336SELECT 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` = 336
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "336"
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`= 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` = 336SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "603"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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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 `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 `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` = "138"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "138"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "138"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "138"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 138SELECT 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` = 138
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "138"
and `virtuemart_category_id`= "3"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 138SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "654"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` = "44"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "44"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "44"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "44"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 44SELECT 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` = 44
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "44"
and `virtuemart_category_id`= "3"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 44SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "590"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` =30
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` =44SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 30SELECT `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` = "482"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "482"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "482"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "482"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 482SELECT 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` = 482
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "482"
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` =482
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` =482
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` =482
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` = "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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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 `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`= 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` = 469SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1091"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` = "468"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "468"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "468"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "468"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 468SELECT 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` = 468
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "468"
and `virtuemart_category_id`= "19"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 468SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1090"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` = "391"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "391"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "391"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "391"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 391SELECT 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` = 391
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "391"
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` = 391SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "922"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` = "429"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "429"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "429"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "429"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 429SELECT 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` = 429
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "429"
and `virtuemart_category_id`= "7"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 429SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1015"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` =482
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` =429SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 482SELECT `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` = "433"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "433"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "433"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "433"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 433SELECT 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` = 433
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "433"
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` =433
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` =433
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` =433
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` = "63"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "63"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "63"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "63"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 63SELECT 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` = 63
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "63"
and `virtuemart_category_id`= "7"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 63SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "908"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` = "121"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "121"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "121"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "121"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 121SELECT 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` = 121
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "121"
and `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 `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` = 121SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "681"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` = "225"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "225"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "225"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "225"
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-05-17 16:02:23" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-17 16:02:23" ) )
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` = 225SELECT 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` = 225
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "225"
and `virtuemart_category_id`= "7"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` =433
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` =433
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` =225SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 433SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1055"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "771"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "728"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1126"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1021"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1022"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1023"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 0SELECT `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`= 37SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=37SELECT `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 `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 `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 `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 `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 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:2392:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzc5MDMzNzQzO3M6NDoibGFzdCI7aToxNzc5MDMzNzQzO3M6Mzoibm93IjtpOjE3NzkwMzM3NDM7fX1zOjg6InJlZ2lzdHJ5IjtPOjk6IkpSZWdpc3RyeSI6MTp7czo3OiIAKgBkYXRhIjtPOjg6InN0ZENsYXNzIjowOnt9fXM6NDoidXNlciI7Tzo1OiJKVXNlciI6MjU6e3M6OToiACoAaXNSb290IjtiOjA7czoyOiJpZCI7aTowO3M6NDoibmFtZSI7TjtzOjg6InVzZXJuYW1lIjtOO3M6NToiZW1haWwiO047czo4OiJwYXNzd29yZCI7TjtzOjE0OiJwYXNzd29yZF9jbGVhciI7czowOiIiO3M6ODoidXNlcnR5cGUiO047czo1OiJibG9jayI7TjtzOjk6InNlbmRFbWFpbCI7aTowO3M6MTI6InJlZ2lzdGVyRGF0ZSI7TjtzOjEzOiJsYXN0dmlzaXREYXRlIjtOO3M6MTA6ImFjdGl2YXRpb24iO047czo2OiJwYXJhbXMiO047czo2OiJncm91cHMiO2E6MDp7fXM6NToiZ3Vlc3QiO2k6MTtzOjEzOiJsYXN0UmVzZXRUaW1lIjtOO3M6MTA6InJlc2V0Q291bnQiO047czoxMDoiACoAX3BhcmFtcyI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjE0OiIAKgBfYXV0aEdyb3VwcyI7YToxOntpOjA7aToxO31zOjE0OiIAKgBfYXV0aExldmVscyI7YToyOntpOjA7aToxO2k6MTtpOjE7fXM6MTU6IgAqAF9hdXRoQWN0aW9ucyI7TjtzOjEyOiIAKgBfZXJyb3JNc2ciO047czoxMDoiACoAX2Vycm9ycyI7YTowOnt9czozOiJhaWQiO2k6MDt9fXM6NDoiX192bSI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo2OiJ2bWNhcnQiO3M6NzUyOiJPOjg6InN0ZENsYXNzIjoyODp7czo4OiJwcm9kdWN0cyI7YTowOnt9czo4OiJ2ZW5kb3JJZCI7aToxO3M6MjE6Imxhc3RWaXNpdGVkQ2F0ZWdvcnlJZCI7aTowO3M6Mjg6InZpcnR1ZW1hcnRfc2hpcG1lbnRtZXRob2RfaWQiO2k6MDtzOjI3OiJ2aXJ0dWVtYXJ0X3BheW1lbnRtZXRob2RfaWQiO2k6MDtzOjI1OiJhdXRvbWF0aWNTZWxlY3RlZFNoaXBtZW50IjtiOjA7czoyNDoiYXV0b21hdGljU2VsZWN0ZWRQYXltZW50IjtiOjA7czoxMjoib3JkZXJfbnVtYmVyIjtOO3M6MTk6InZpcnR1ZW1hcnRfb3JkZXJfaWQiO2I6MDtzOjI6IkJUIjtpOjA7czoyOiJTVCI7aTowO3M6MTE6InRvc0FjY2VwdGVkIjtiOjA7czoxNjoiY3VzdG9tZXJfY29tbWVudCI7czowOiIiO3M6MTA6ImNvdXBvbkNvZGUiO3M6MDoiIjtzOjIwOiJfdHJpZXNWYWxpZGF0ZUNvdXBvbiI7YTowOnt9czoxNDoib3JkZXJfbGFuZ3VhZ2UiO3M6MDoiIjtzOjg6ImNhcnREYXRhIjtOO3M6NToibGlzdHMiO047czoxNDoicHJpY2VzQ3VycmVuY3kiO047czoxNToicGF5bWVudEN1cnJlbmN5IjtOO3M6MTA6Il9pbkNvbmZpcm0iO2I6MDtzOjExOiJfaW5DaGVja091dCI7YjowO3M6MTQ6Il9kYXRhVmFsaWRhdGVkIjtiOjA7czoxMjoiX2NvbmZpcm1Eb25lIjtiOjA7czoxMDoiU1RzYW1lQXNCVCI7YjoxO3M6MTU6ImN1c3RvbWVyX251bWJlciI7czo3OiJub25yZWdfIjtzOjY6ImxheW91dCI7czo3OiJkZWZhdWx0IjtzOjEwOiJsYXlvdXRQYXRoIjtzOjA6IiI7fSI7czoyMzoidm1sYXN0dmlzaXRlZGNhdGVnb3J5aWQiO2k6MTk7czoyMzoidm1sYXN0dmlzaXRlZHByb2R1Y3RpZHMiO2E6MTp7aTowO2k6NDQwO319fX0=\";'
, `time` = '1779033743'
WHERE `session_id` = '9d003dc8e9d9528e3a3e4405e1d56ed7'27 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`26 × SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`26 × SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`25 × SELECT *
FROM `vgali_virtuemart_product_prices`25 × 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`25 × SELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`25 × SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`25 × SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`25 × 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`25 × SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc24 × SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`12 × 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`9 × SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)6 × 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`6 × 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`6 × SELECT id
FROM vgali_assets6 × SELECT virtuemart_product_id, product_name
FROM `vgali_virtuemart_products_en_gb` JOIN `vgali_virtuemart_products` as C using (`virtuemart_product_id`)4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM vgali_extensions2 × SELECT `virtuemart_category_id`
FROM vgali_virtuemart_calc_categories2 × SELECT `virtuemart_state_id`
FROM vgali_virtuemart_calc_states2 × SELECT `virtuemart_manufacturer_id`
FROM vgali_virtuemart_calc_manufacturers2 × 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 `virtuemart_country_id`
FROM vgali_virtuemart_calc_countries2 × SELECT `virtuemart_shoppergroup_id`
FROM vgali_virtuemart_calc_shoppergroups2 × SELECT *
FROM `vgali_virtuemart_shoppergroups`2 × SELECT b.rules
FROM vgali_assets AS a
LEFT JOIN vgali_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`1 × SELECT `category_name`,`virtuemart_category_id`
FROM `vgali_virtuemart_categories_en_gb`1 × 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 CONCAT(`vendor_accepted_currencies`, ",",`vendor_currency`) AS all_currencies, `vendor_currency`
FROM `vgali_virtuemart_vendors`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.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 *
FROM `vgali_virtuemart_userfields`1 × SELECT count(vgali_virtuemart_products.virtuemart_product_id) AS total
FROM `vgali_virtuemart_products`, `vgali_virtuemart_product_categories`1 × SELECT a.rules
FROM vgali_assets AS a1 × SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id
FROM `vgali_virtuemart_shipmentmethods_en_gb` as l JOIN `vgali_virtuemart_shipmentmethods` AS v USING (`virtuemart_shipmentmethod_id`)
LEFT JOIN `vgali_extensions` as j
ON j.`extension_id` = v.`shipment_jplugin_id`
LEFT
OUTER JOIN `vgali_virtuemart_shipmentmethod_shoppergroups` AS s
ON v.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`1 × SELECT `customer_number`
FROM `vgali_virtuemart_vmusers`1 × SELECT `category_child_id`
FROM `vgali_virtuemart_category_categories`1 × SELECT `price_display`,`custom_price_display`
FROM `vgali_virtuemart_shoppergroups` AS `sg`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 `config`
FROM `vgali_virtuemart_configs`1 × SELECT *
FROM `vgali_menu`1 × SELECT folder AS type, element AS name, params
FROM vgali_extensions1 × SELECT id, rules
FROM `vgali_viewlevels1 × SELECT `session_id`
FROM `vgali_session`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 `virtuemart_category_id`
FROM `vgali_virtuemart_categories_en_gb`1 × SELECT `p`.`virtuemart_product_id`
FROM `vgali_virtuemart_products_en_gb` AS `p`
LEFT JOIN `vgali_virtuemart_product_categories` AS `xref`
ON `p`.`virtuemart_product_id` = `xref`.`virtuemart_product_id`1 × 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 *
FROM `vgali_virtuemart_currencies`1 × SELECT `data`
FROM `vgali_session`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`)1 × SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_vmuser_shoppergroups`1 × SELECT *
FROM vgali_languages1 × 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 *
FROM vgali_virtuemart_calcs1 × SHOW FULL COLUMNS
FROM `vgali_virtuemart_userfields1 × UPDATE `vgali_session`
SET `data` = 'joomla|s:2392:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzc5MDMzNzQzO3M6NDoibGFzdCI7aToxNzc5MDMzNzQzO3M6Mzoibm93IjtpOjE3NzkwMzM3NDM7fX1zOjg6InJlZ2lzdHJ5IjtPOjk6IkpSZWdpc3RyeSI6MTp7czo3OiIAKgBkYXRhIjtPOjg6InN0ZENsYXNzIjowOnt9fXM6NDoidXNlciI7Tzo1OiJKVXNlciI6MjU6e3M6OToiACoAaXNSb290IjtiOjA7czoyOiJpZCI7aTowO3M6NDoibmFtZSI7TjtzOjg6InVzZXJuYW1lIjtOO3M6NToiZW1haWwiO047czo4OiJwYXNzd29yZCI7TjtzOjE0OiJwYXNzd29yZF9jbGVhciI7czowOiIiO3M6ODoidXNlcnR5cGUiO047czo1OiJibG9jayI7TjtzOjk6InNlbmRFbWFpbCI7aTowO3M6MTI6InJlZ2lzdGVyRGF0ZSI7TjtzOjEzOiJsYXN0dmlzaXREYXRlIjtOO3M6MTA6ImFjdGl2YXRpb24iO047czo2OiJwYXJhbXMiO047czo2OiJncm91cHMiO2E6MDp7fXM6NToiZ3Vlc3QiO2k6MTtzOjEzOiJsYXN0UmVzZXRUaW1lIjtOO3M6MTA6InJlc2V0Q291bnQiO047czoxMDoiACoAX3BhcmFtcyI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjE0OiIAKgBfYXV0aEdyb3VwcyI7YToxOntpOjA7aToxO31zOjE0OiIAKgBfYXV0aExldmVscyI7YToyOntpOjA7aToxO2k6MTtpOjE7fXM6MTU6IgAqAF9hdXRoQWN0aW9ucyI7TjtzOjEyOiIAKgBfZXJyb3JNc2ciO047czoxMDoiACoAX2Vycm9ycyI7YTowOnt9czozOiJhaWQiO2k6MDt9fXM6NDoiX192bSI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo2OiJ2bWNhcnQiO3M6NzUyOiJPOjg6InN0ZENsYXNzIjoyODp7czo4OiJwcm9kdWN0cyI7YTowOnt9czo4OiJ2ZW5kb3JJZCI7aToxO3M6MjE6Imxhc3RWaXNpdGVkQ2F0ZWdvcnlJZCI7aTowO3M6Mjg6InZpcnR1ZW1hcnRfc2hpcG1lbnRtZXRob2RfaWQiO2k6MDtzOjI3OiJ2aXJ0dWVtYXJ0X3BheW1lbnRtZXRob2RfaWQiO2k6MDtzOjI1OiJhdXRvbWF0aWNTZWxlY3RlZFNoaXBtZW50IjtiOjA7czoyNDoiYXV0b21hdGljU2VsZWN0ZWRQYXltZW50IjtiOjA7czoxMjoib3JkZXJfbnVtYmVyIjtOO3M6MTk6InZpcnR1ZW1hcnRfb3JkZXJfaWQiO2I6MDtzOjI6IkJUIjtpOjA7czoyOiJTVCI7aTowO3M6MTE6InRvc0FjY2VwdGVkIjtiOjA7czoxNjoiY3VzdG9tZXJfY29tbWVudCI7czowOiIiO3M6MTA6ImNvdXBvbkNvZGUiO3M6MDoiIjtzOjIwOiJfdHJpZXNWYWxpZGF0ZUNvdXBvbiI7YTowOnt9czoxNDoib3JkZXJfbGFuZ3VhZ2UiO3M6MDoiIjtzOjg6ImNhcnREYXRhIjtOO3M6NToibGlzdHMiO047czoxNDoicHJpY2VzQ3VycmVuY3kiO047czoxNToicGF5bWVudEN1cnJlbmN5IjtOO3M6MTA6Il9pbkNvbmZpcm0iO2I6MDtzOjExOiJfaW5DaGVja091dCI7YjowO3M6MTQ6Il9kYXRhVmFsaWRhdGVkIjtiOjA7czoxMjoiX2NvbmZpcm1Eb25lIjtiOjA7czoxMDoiU1RzYW1lQXNCVCI7YjoxO3M6MTU6ImN1c3RvbWVyX251bWJlciI7czo3OiJub25yZWdfIjtzOjY6ImxheW91dCI7czo3OiJkZWZhdWx0IjtzOjEwOiJsYXlvdXRQYXRoIjtzOjA6IiI7fSI7czoyMzoidm1sYXN0dmlzaXRlZGNhdGVnb3J5aWQiO2k6MTk7czoyMzoidm1sYXN0dmlzaXRlZHByb2R1Y3RpZHMiO2E6MTp7aTowO2k6NDQwO319fX0=\";' , `time` = '1779033743'1 × SHOW FULL COLUMNS
FROM `vgali_assets1 × SHOW TABLES LIKE "vgali_virtuemart_configs1 × INSERT INTO `vgali_session` (`session_id`, `client_id`, `time`)
VALUES ('9d003dc8e9d9528e3a3e4405e1d56ed7', 0, '1779033743'1 × DELETE
FROM `vgali_session`






