Arms of Lugo Flag
Flag Specifications:
» Size: 150x90 cm (3'x5').
» Material: polyester. For indoor or moderate outdoor use.
» The flag has two brass grommets to hoist the flag on a flagpole.
Read about the history of the Arms of Lugo at www.GalicianFlag.com
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.021 seconds (+0.021); 4.28 MB (+3.666) - afterInitialiseApplication 0.032 seconds (+0.011); 6.26 MB (+1.985) - afterRouteApplication 0.168 seconds (+0.135); 17.66 MB (+11.403) - afterDispatchApplication 0.180 seconds (+0.012); 18.60 MB (+0.934) - beforeRenderModule mod_custom (Secure Payment)Application 0.187 seconds (+0.006); 19.07 MB (+0.476) - afterRenderModule mod_custom (Secure Payment)Application 0.187 seconds (+0.000); 19.07 MB (-0.002) - beforeRenderModule mod_menu (Terms of Service)Application 0.189 seconds (+0.003); 19.13 MB (+0.056) - afterRenderModule mod_menu (Terms of Service)Application 0.190 seconds (+0.000); 19.12 MB (-0.005) - beforeRenderModule mod_menu (Contact Us)Application 0.190 seconds (+0.000); 19.13 MB (+0.005) - afterRenderModule mod_menu (Contact Us)Application 0.190 seconds (+0.000); 19.12 MB (-0.005) - beforeRenderModule mod_custom (Like Us / Follow Us)Application 0.191 seconds (+0.001); 19.13 MB (+0.004) - afterRenderModule mod_custom (Like Us / Follow Us)Application 0.191 seconds (+0.000); 19.13 MB (-0.001) - beforeRenderModule mod_virtuemart_product (Featured Products)Application 0.268 seconds (+0.077); 20.41 MB (+1.289) - afterRenderModule mod_virtuemart_product (Featured Products)Application 0.268 seconds (+0.000); 20.41 MB (-0.008) - beforeRenderModule mod_virtuemart_search (Search)Application 0.270 seconds (+0.002); 20.42 MB (+0.016) - afterRenderModule mod_virtuemart_search (Search)Application 0.270 seconds (+0.000); 20.42 MB (-0.006) - beforeRenderModule mod_virtuemart_category (Products)Application 0.278 seconds (+0.008); 20.53 MB (+0.115) - afterRenderModule mod_virtuemart_category (Products)Application 0.279 seconds (+0.000); 20.53 MB (-0.003) - beforeRenderModule mod_virtuemart_currencies (View prices in your currency)Application 0.281 seconds (+0.003); 20.64 MB (+0.109) - afterRenderModule mod_virtuemart_currencies (View prices in your currency)Application 0.281 seconds (+0.000); 20.64 MB (-0.002) - beforeRenderModule mod_metamod (Most Popular Last Month)Application 0.286 seconds (+0.005); 21.50 MB (+0.861) - afterRenderModule mod_metamod (Most Popular Last Month)Application 0.286 seconds (+0.000); 21.49 MB (-0.006) - beforeRenderModule mod_metamod (MetaMod Welcome)Application 0.287 seconds (+0.000); 21.50 MB (+0.007) - afterRenderModule mod_metamod (MetaMod Welcome)Application 0.287 seconds (+0.000); 21.49 MB (-0.005) - beforeRenderModule mod_metamod (MetaMod)Application 0.287 seconds (+0.000); 21.50 MB (+0.007) - afterRenderModule mod_metamod (MetaMod)Application 0.287 seconds (+0.000); 21.49 MB (-0.006) - beforeRenderModule mod_metamod (MetaMod Kilt Gallaecia)Application 0.287 seconds (+0.000); 21.50 MB (+0.007) - afterRenderModule mod_metamod (MetaMod Kilt Gallaecia)Application 0.287 seconds (+0.000); 21.49 MB (-0.008) - beforeRenderModule mod_custom (Banner)Application 0.288 seconds (+0.001); 21.50 MB (+0.004) - afterRenderModule mod_custom (Banner)Application 0.288 seconds (+0.000); 21.49 MB (-0.003) - beforeRenderModule mod_custom (Languages)Application 0.289 seconds (+0.001); 21.50 MB (+0.004) - afterRenderModule mod_custom (Languages)Application 0.291 seconds (+0.002); 21.56 MB (+0.068) - afterRender21.58 MB (22,628,616 Bytes)SELECT `data`
FROM `vgali_session`
WHERE `session_id` = '9e51690fe749612cfb44bdb2b75e0e1e'DELETE
FROM `vgali_session`
WHERE `time` < '1782898477'SELECT `session_id`
FROM `vgali_session`
WHERE `session_id` = '9e51690fe749612cfb44bdb2b75e0e1e'
LIMIT 0, 1INSERT INTO `vgali_session`
(`session_id`, `client_id`, `time`)
VALUES
('9e51690fe749612cfb44bdb2b75e0e1e', 0, '1782899377')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 'galician-flags'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 "lugo-county-flag"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` = "377"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "377"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "377"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "377"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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` = 377SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 377
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "377"
and `virtuemart_category_id`= "5"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` = "5"SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =377
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_idSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =377
and `field_type` = "Z"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =377
and `field_type` = "R"
and is_cart_attribute = 0
order by orderingSELECT `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` = "116"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "116"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "116"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "116"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 116SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 116
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "116"
and `virtuemart_category_id`= "7"SELECT `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 *
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-07-01 09:49:37" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-07-01 09:49:37" )
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`= 20SELECT `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` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=20SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 116SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "907"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "6"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 6SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 6
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6"
and `virtuemart_category_id`= "5"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` = 6SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "706"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "376"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "376"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "376"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "376"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 376SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 376
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "376"
and `virtuemart_category_id`= "5"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 376SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "898"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 300SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 300
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "300"
and `virtuemart_category_id`= "43"SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `vgali_virtuemart_categories`.`virtuemart_category_id` = "43"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 49SELECT `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`=49SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 300SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "609"SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =377
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`SELECT virtuemart_product_id, product_name
FROM `vgali_virtuemart_products_en_gb`
JOIN `vgali_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =300SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 377SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "899"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "5"
ORDER BY `ordering`SELECT `category_child_id`
FROM `vgali_virtuemart_category_categories`
WHERE `category_parent_id` = 5SELECT 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` = 5
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`=3SELECT `category_name`,`virtuemart_category_id`
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=5SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "52"SELECT 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-07-01 09:49:37')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-01 09:49:37')
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` = "403"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "403"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "403"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "403"
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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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` = 403SELECT 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` = 403
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "403"
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` =403
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` =403
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` =403
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` = "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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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`= "5"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 30SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "728"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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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`= "5"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` = "146"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "146"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "146"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "146"
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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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` = 146SELECT 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` = 146
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "146"
and `virtuemart_category_id`= "22"SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `vgali_virtuemart_categories`.`virtuemart_category_id` = "22"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 29SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 22SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=22SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=29SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 146SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "684"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` =403
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` =146SELECT `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` = 403SELECT `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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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`= "5"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` =351
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` =351
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` =351
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` = "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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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`= "5"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 `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` = "286"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "286"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "286"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "286"
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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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` = 286SELECT 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` = 286
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "286"
and `virtuemart_category_id`= "5"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 286SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "600"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` = "317"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "317"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "317"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "317"
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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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` = 317SELECT 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` = 317
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "317"
and `virtuemart_category_id`= "5"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 317SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "653"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` =351
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` =317SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 351SELECT `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` = "154"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "154"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "154"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "154"
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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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` = 154SELECT 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` = 154
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "154"
and `virtuemart_category_id`= "22"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` =154
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` =154
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` =154
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` = "151"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "151"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "151"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "151"
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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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` = 151SELECT 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` = 151
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "151"
and `virtuemart_category_id`= "22"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 151SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "685"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` = "149"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "149"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "149"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "149"
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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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` = 149SELECT 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` = 149
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "149"
and `virtuemart_category_id`= "22"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 149SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "735"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` = "156"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "156"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "156"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "156"
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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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` = 156SELECT 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` = 156
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "156"
and `virtuemart_category_id`= "22"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 156SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "678"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` = "100"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "100"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "100"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "100"
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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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` = 100SELECT 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` = 100
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "100"
and `virtuemart_category_id`= "7"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 100SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "732"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` =154
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` =154
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=3
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` =154
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=9
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` =154
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=12
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` =154
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=6
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` =100SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 154SELECT `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` = "272"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "272"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "272"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "272"
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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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` = 272SELECT 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` = 272
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "272"
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` =272
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` =272
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` =272
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` =272
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` =272
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` =272SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 272SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "205"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "205"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "205"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "205"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 205SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 205
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "205"
and `virtuemart_category_id`= "27"SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `vgali_virtuemart_categories`.`virtuemart_category_id` = "27"SELECT 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` =205
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` =205
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` =205
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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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 `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 `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` = 383SELECT `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` = "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` = "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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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 `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 `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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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` = "412"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "412"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "412"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "412"
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-07-01 09:49:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-07-01 09:49:37" ) )
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` = 412SELECT 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` = 412
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "412"
and `virtuemart_category_id`= "5"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 412SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "965"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` =205
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` =205
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=8
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` =205
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` =412SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 205SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "944"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "657"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "677"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "885"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1136"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1137"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`= 8SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=8SELECT `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`= 28SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=28SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 37SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=37SELECT `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`= 50SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=50SELECT `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:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzgyODk5Mzc3O3M6NDoibGFzdCI7aToxNzgyODk5Mzc3O3M6Mzoibm93IjtpOjE3ODI4OTkzNzc7fX1zOjg6InJlZ2lzdHJ5IjtPOjk6IkpSZWdpc3RyeSI6MTp7czo3OiIAKgBkYXRhIjtPOjg6InN0ZENsYXNzIjowOnt9fXM6NDoidXNlciI7Tzo1OiJKVXNlciI6MjU6e3M6OToiACoAaXNSb290IjtiOjA7czoyOiJpZCI7aTowO3M6NDoibmFtZSI7TjtzOjg6InVzZXJuYW1lIjtOO3M6NToiZW1haWwiO047czo4OiJwYXNzd29yZCI7TjtzOjE0OiJwYXNzd29yZF9jbGVhciI7czowOiIiO3M6ODoidXNlcnR5cGUiO047czo1OiJibG9jayI7TjtzOjk6InNlbmRFbWFpbCI7aTowO3M6MTI6InJlZ2lzdGVyRGF0ZSI7TjtzOjEzOiJsYXN0dmlzaXREYXRlIjtOO3M6MTA6ImFjdGl2YXRpb24iO047czo2OiJwYXJhbXMiO047czo2OiJncm91cHMiO2E6MDp7fXM6NToiZ3Vlc3QiO2k6MTtzOjEzOiJsYXN0UmVzZXRUaW1lIjtOO3M6MTA6InJlc2V0Q291bnQiO047czoxMDoiACoAX3BhcmFtcyI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjE0OiIAKgBfYXV0aEdyb3VwcyI7YToxOntpOjA7aToxO31zOjE0OiIAKgBfYXV0aExldmVscyI7YToyOntpOjA7aToxO2k6MTtpOjE7fXM6MTU6IgAqAF9hdXRoQWN0aW9ucyI7TjtzOjEyOiIAKgBfZXJyb3JNc2ciO047czoxMDoiACoAX2Vycm9ycyI7YTowOnt9czozOiJhaWQiO2k6MDt9fXM6NDoiX192bSI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo2OiJ2bWNhcnQiO3M6NzUyOiJPOjg6InN0ZENsYXNzIjoyODp7czo4OiJwcm9kdWN0cyI7YTowOnt9czo4OiJ2ZW5kb3JJZCI7aToxO3M6MjE6Imxhc3RWaXNpdGVkQ2F0ZWdvcnlJZCI7aTowO3M6Mjg6InZpcnR1ZW1hcnRfc2hpcG1lbnRtZXRob2RfaWQiO2k6MDtzOjI3OiJ2aXJ0dWVtYXJ0X3BheW1lbnRtZXRob2RfaWQiO2k6MDtzOjI1OiJhdXRvbWF0aWNTZWxlY3RlZFNoaXBtZW50IjtiOjA7czoyNDoiYXV0b21hdGljU2VsZWN0ZWRQYXltZW50IjtiOjA7czoxMjoib3JkZXJfbnVtYmVyIjtOO3M6MTk6InZpcnR1ZW1hcnRfb3JkZXJfaWQiO2I6MDtzOjI6IkJUIjtpOjA7czoyOiJTVCI7aTowO3M6MTE6InRvc0FjY2VwdGVkIjtiOjA7czoxNjoiY3VzdG9tZXJfY29tbWVudCI7czowOiIiO3M6MTA6ImNvdXBvbkNvZGUiO3M6MDoiIjtzOjIwOiJfdHJpZXNWYWxpZGF0ZUNvdXBvbiI7YTowOnt9czoxNDoib3JkZXJfbGFuZ3VhZ2UiO3M6MDoiIjtzOjg6ImNhcnREYXRhIjtOO3M6NToibGlzdHMiO047czoxNDoicHJpY2VzQ3VycmVuY3kiO047czoxNToicGF5bWVudEN1cnJlbmN5IjtOO3M6MTA6Il9pbkNvbmZpcm0iO2I6MDtzOjExOiJfaW5DaGVja091dCI7YjowO3M6MTQ6Il9kYXRhVmFsaWRhdGVkIjtiOjA7czoxMjoiX2NvbmZpcm1Eb25lIjtiOjA7czoxMDoiU1RzYW1lQXNCVCI7YjoxO3M6MTU6ImN1c3RvbWVyX251bWJlciI7czo3OiJub25yZWdfIjtzOjY6ImxheW91dCI7czo3OiJkZWZhdWx0IjtzOjEwOiJsYXlvdXRQYXRoIjtzOjA6IiI7fSI7czoyMzoidm1sYXN0dmlzaXRlZGNhdGVnb3J5aWQiO2k6NTtzOjIzOiJ2bWxhc3R2aXNpdGVkcHJvZHVjdGlkcyI7YToxOntpOjA7aTozNzc7fX19fQ==\";'
, `time` = '1782899377'
WHERE `session_id` = '9e51690fe749612cfb44bdb2b75e0e1e'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`24 × 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`24 × SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`24 × SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`24 × SELECT *
FROM `vgali_virtuemart_product_prices`24 × SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc24 × 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`24 × SELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`24 × 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`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`)7 × 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`6 × SELECT virtuemart_product_id, product_name
FROM `vgali_virtuemart_products_en_gb` JOIN `vgali_virtuemart_products` as C using (`virtuemart_product_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 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`4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM vgali_extensions4 × SELECT id
FROM vgali_assets2 × SELECT `virtuemart_category_id`
FROM vgali_virtuemart_calc_categories2 × SELECT `virtuemart_manufacturer_id`
FROM vgali_virtuemart_calc_manufacturers2 × SELECT `virtuemart_state_id`
FROM vgali_virtuemart_calc_states2 × SELECT `virtuemart_country_id`
FROM vgali_virtuemart_calc_countries2 × SELECT `virtuemart_shoppergroup_id`
FROM vgali_virtuemart_calc_shoppergroups2 × SELECT `category_name`,`virtuemart_category_id`
FROM `vgali_virtuemart_categories_en_gb`2 × SELECT b.rules
FROM vgali_assets AS a
LEFT JOIN vgali_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt2 × SELECT *
FROM `vgali_virtuemart_shoppergroups`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 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 `value`
FROM `vgali_admintools_storage`1 × SELECT `virtuemart_currency_id`,CONCAT_WS(" ",`currency_name`,`currency_symbol`) as currency_txt
FROM `vgali_virtuemart_currencies`1 × SELECT *
FROM `vgali_virtuemart_userfields`1 × 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 count(vgali_virtuemart_products.virtuemart_product_id) AS total
FROM `vgali_virtuemart_products`, `vgali_virtuemart_product_categories`1 × SELECT `category_child_id`
FROM `vgali_virtuemart_category_categories`1 × SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`1 × SELECT a.rules
FROM vgali_assets AS a1 × SELECT `customer_number`
FROM `vgali_virtuemart_vmusers`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:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzgyODk5Mzc3O3M6NDoibGFzdCI7aToxNzgyODk5Mzc3O3M6Mzoibm93IjtpOjE3ODI4OTkzNzc7fX1zOjg6InJlZ2lzdHJ5IjtPOjk6IkpSZWdpc3RyeSI6MTp7czo3OiIAKgBkYXRhIjtPOjg6InN0ZENsYXNzIjowOnt9fXM6NDoidXNlciI7Tzo1OiJKVXNlciI6MjU6e3M6OToiACoAaXNSb290IjtiOjA7czoyOiJpZCI7aTowO3M6NDoibmFtZSI7TjtzOjg6InVzZXJuYW1lIjtOO3M6NToiZW1haWwiO047czo4OiJwYXNzd29yZCI7TjtzOjE0OiJwYXNzd29yZF9jbGVhciI7czowOiIiO3M6ODoidXNlcnR5cGUiO047czo1OiJibG9jayI7TjtzOjk6InNlbmRFbWFpbCI7aTowO3M6MTI6InJlZ2lzdGVyRGF0ZSI7TjtzOjEzOiJsYXN0dmlzaXREYXRlIjtOO3M6MTA6ImFjdGl2YXRpb24iO047czo2OiJwYXJhbXMiO047czo2OiJncm91cHMiO2E6MDp7fXM6NToiZ3Vlc3QiO2k6MTtzOjEzOiJsYXN0UmVzZXRUaW1lIjtOO3M6MTA6InJlc2V0Q291bnQiO047czoxMDoiACoAX3BhcmFtcyI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjE0OiIAKgBfYXV0aEdyb3VwcyI7YToxOntpOjA7aToxO31zOjE0OiIAKgBfYXV0aExldmVscyI7YToyOntpOjA7aToxO2k6MTtpOjE7fXM6MTU6IgAqAF9hdXRoQWN0aW9ucyI7TjtzOjEyOiIAKgBfZXJyb3JNc2ciO047czoxMDoiACoAX2Vycm9ycyI7YTowOnt9czozOiJhaWQiO2k6MDt9fXM6NDoiX192bSI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo2OiJ2bWNhcnQiO3M6NzUyOiJPOjg6InN0ZENsYXNzIjoyODp7czo4OiJwcm9kdWN0cyI7YTowOnt9czo4OiJ2ZW5kb3JJZCI7aToxO3M6MjE6Imxhc3RWaXNpdGVkQ2F0ZWdvcnlJZCI7aTowO3M6Mjg6InZpcnR1ZW1hcnRfc2hpcG1lbnRtZXRob2RfaWQiO2k6MDtzOjI3OiJ2aXJ0dWVtYXJ0X3BheW1lbnRtZXRob2RfaWQiO2k6MDtzOjI1OiJhdXRvbWF0aWNTZWxlY3RlZFNoaXBtZW50IjtiOjA7czoyNDoiYXV0b21hdGljU2VsZWN0ZWRQYXltZW50IjtiOjA7czoxMjoib3JkZXJfbnVtYmVyIjtOO3M6MTk6InZpcnR1ZW1hcnRfb3JkZXJfaWQiO2I6MDtzOjI6IkJUIjtpOjA7czoyOiJTVCI7aTowO3M6MTE6InRvc0FjY2VwdGVkIjtiOjA7czoxNjoiY3VzdG9tZXJfY29tbWVudCI7czowOiIiO3M6MTA6ImNvdXBvbkNvZGUiO3M6MDoiIjtzOjIwOiJfdHJpZXNWYWxpZGF0ZUNvdXBvbiI7YTowOnt9czoxNDoib3JkZXJfbGFuZ3VhZ2UiO3M6MDoiIjtzOjg6ImNhcnREYXRhIjtOO3M6NToibGlzdHMiO047czoxNDoicHJpY2VzQ3VycmVuY3kiO047czoxNToicGF5bWVudEN1cnJlbmN5IjtOO3M6MTA6Il9pbkNvbmZpcm0iO2I6MDtzOjExOiJfaW5DaGVja091dCI7YjowO3M6MTQ6Il9kYXRhVmFsaWRhdGVkIjtiOjA7czoxMjoiX2NvbmZpcm1Eb25lIjtiOjA7czoxMDoiU1RzYW1lQXNCVCI7YjoxO3M6MTU6ImN1c3RvbWVyX251bWJlciI7czo3OiJub25yZWdfIjtzOjY6ImxheW91dCI7czo3OiJkZWZhdWx0IjtzOjEwOiJsYXlvdXRQYXRoIjtzOjA6IiI7fSI7czoyMzoidm1sYXN0dmlzaXRlZGNhdGVnb3J5aWQiO2k6NTtzOjIzOiJ2bWxhc3R2aXNpdGVkcHJvZHVjdGlkcyI7YToxOntpOjA7aTozNzc7fX19fQ==\";' , `time` = '1782899377'1 × SHOW FULL COLUMNS
FROM `vgali_assets1 × SHOW TABLES LIKE "vgali_virtuemart_configs1 × INSERT INTO `vgali_session` (`session_id`, `client_id`, `time`)
VALUES ('9e51690fe749612cfb44bdb2b75e0e1e', 0, '1782899377'1 × DELETE
FROM `vgali_session`






