Product details:
» Celtic Design initial pendant in Sterling Silver, size: 14 x 9 mm (0.55 x 0.35 in).
» It comes with a choice of an iron chain (adjustable size 46-53 cm / 18-21 inch) or a black cotton cord.
» Displaying your identity to others has never looked more elegant!
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.024 seconds (+0.024); 4.28 MB (+3.666) - afterInitialiseApplication 0.037 seconds (+0.013); 6.26 MB (+1.985) - afterRouteApplication 0.169 seconds (+0.132); 17.71 MB (+11.447) - afterDispatchApplication 0.184 seconds (+0.014); 18.64 MB (+0.934) - beforeRenderModule mod_custom (Secure Payment)Application 0.191 seconds (+0.007); 19.12 MB (+0.476) - afterRenderModule mod_custom (Secure Payment)Application 0.191 seconds (+0.000); 19.12 MB (-0.002) - beforeRenderModule mod_menu (Terms of Service)Application 0.193 seconds (+0.002); 19.17 MB (+0.057) - afterRenderModule mod_menu (Terms of Service)Application 0.193 seconds (+0.000); 19.17 MB (-0.005) - beforeRenderModule mod_menu (Contact Us)Application 0.193 seconds (+0.000); 19.17 MB (+0.005) - afterRenderModule mod_menu (Contact Us)Application 0.193 seconds (+0.000); 19.17 MB (-0.005) - beforeRenderModule mod_custom (Like Us / Follow Us)Application 0.194 seconds (+0.001); 19.17 MB (+0.004) - afterRenderModule mod_custom (Like Us / Follow Us)Application 0.194 seconds (+0.000); 19.17 MB (-0.001) - beforeRenderModule mod_virtuemart_product (Featured Products)Application 0.274 seconds (+0.080); 20.24 MB (+1.071) - afterRenderModule mod_virtuemart_product (Featured Products)Application 0.274 seconds (+0.000); 20.23 MB (-0.008) - beforeRenderModule mod_virtuemart_search (Search)Application 0.277 seconds (+0.003); 20.25 MB (+0.016) - afterRenderModule mod_virtuemart_search (Search)Application 0.277 seconds (+0.000); 20.24 MB (-0.006) - beforeRenderModule mod_virtuemart_category (Products)Application 0.285 seconds (+0.008); 20.34 MB (+0.100) - afterRenderModule mod_virtuemart_category (Products)Application 0.285 seconds (+0.000); 20.34 MB (-0.003) - beforeRenderModule mod_virtuemart_currencies (View prices in your currency)Application 0.288 seconds (+0.003); 20.45 MB (+0.110) - afterRenderModule mod_virtuemart_currencies (View prices in your currency)Application 0.288 seconds (+0.000); 20.45 MB (-0.002) - beforeRenderModule mod_metamod (Most Popular Last Month)Application 0.293 seconds (+0.005); 21.31 MB (+0.862) - afterRenderModule mod_metamod (Most Popular Last Month)Application 0.293 seconds (+0.000); 21.30 MB (-0.006) - beforeRenderModule mod_metamod (MetaMod Welcome)Application 0.293 seconds (+0.000); 21.31 MB (+0.007) - afterRenderModule mod_metamod (MetaMod Welcome)Application 0.293 seconds (+0.000); 21.30 MB (-0.005) - beforeRenderModule mod_metamod (MetaMod)Application 0.294 seconds (+0.000); 21.31 MB (+0.007) - afterRenderModule mod_metamod (MetaMod)Application 0.294 seconds (+0.000); 21.30 MB (-0.006) - beforeRenderModule mod_metamod (MetaMod Kilt Gallaecia)Application 0.294 seconds (+0.000); 21.31 MB (+0.007) - afterRenderModule mod_metamod (MetaMod Kilt Gallaecia)Application 0.294 seconds (+0.000); 21.30 MB (-0.008) - beforeRenderModule mod_custom (Banner)Application 0.295 seconds (+0.001); 21.31 MB (+0.004) - afterRenderModule mod_custom (Banner)Application 0.295 seconds (+0.000); 21.30 MB (-0.003) - beforeRenderModule mod_custom (Languages)Application 0.296 seconds (+0.001); 21.31 MB (+0.004) - afterRenderModule mod_custom (Languages)Application 0.298 seconds (+0.003); 21.38 MB (+0.068) - afterRender21.39 MB (22,432,144 Bytes)SELECT `data`
FROM `vgali_session`
WHERE `session_id` = '7318bf1560f61d8035d43099766b3402'DELETE
FROM `vgali_session`
WHERE `time` < '1779321009'SELECT `session_id`
FROM `vgali_session`
WHERE `session_id` = '7318bf1560f61d8035d43099766b3402'
LIMIT 0, 1INSERT INTO `vgali_session`
(`session_id`, `client_id`, `time`)
VALUES
('7318bf1560f61d8035d43099766b3402', 0, '1779321909')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 'jewellery'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 "letter-f-silver-celtic-initial-pendant"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` = "265"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "265"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "265"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "265"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
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` = 265SELECT 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` = 265
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "265"
and `virtuemart_category_id`= "7"SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `vgali_virtuemart_categories`.`virtuemart_category_id` = "7"SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =265
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` =265
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` =265
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` =265
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 `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 *
FROM `vgali_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"SELECT *
FROM vgali_virtuemart_calcs
WHERE
`calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2026-05-21 00:05:09" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-05-21 00:05:09" )
OR `for_override` = "1" )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` =265
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` =265SELECT `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`= 7SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=7SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 265SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "782"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "7"
ORDER BY `ordering`SELECT `category_child_id`
FROM `vgali_virtuemart_category_categories`
WHERE `category_parent_id` = 7SELECT a.rules
FROM vgali_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftSHOW FULL COLUMNS
FROM `vgali_assets`SELECT id
FROM vgali_assets
WHERE parent_id = 0SELECT b.rules
FROM vgali_assets AS a
LEFT JOIN vgali_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT b.rules
FROM vgali_assets AS a
LEFT JOIN vgali_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_virtuemart')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
FROM `vgali_virtuemart_categories_en_gb` l
JOIN `vgali_virtuemart_categories` AS c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` AS cx
ON l.`virtuemart_category_id` = cx.`category_child_id`
WHERE c.`published` = 1
AND cx.`category_parent_id` = 7
AND (c.`virtuemart_vendor_id` = "1" OR c.`shared` = "1")
ORDER BY c.ordering ASC
LIMIT 0, 50SELECT FOUND_ROWS()SELECT count(vgali_virtuemart_products.virtuemart_product_id) AS total
FROM `vgali_virtuemart_products`, `vgali_virtuemart_product_categories`
WHERE `vgali_virtuemart_products`.`virtuemart_vendor_id` = "1"
AND `vgali_virtuemart_product_categories`.`virtuemart_category_id` = 7
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`=7SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "45"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "47"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "48"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "889"SELECT id
FROM vgali_assets
WHERE parent_id = 0SELECT 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 `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 20SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=20SELECT `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 m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM vgali_modules AS m
LEFT JOIN vgali_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN vgali_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-05-21 00:05:09')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-05-21 00:05:09')
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` = "465"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "465"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "465"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "465"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
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` = 465SELECT 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` = 465
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "465"
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` =465
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` =465
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` =465
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` = "399"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "399"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "399"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "399"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
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` = 399SELECT 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` = 399
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "399"
and `virtuemart_category_id`= "7"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 399SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "934"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "391"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "391"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "391"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "391"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 391SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 391
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "391"
and `virtuemart_category_id`= "7"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 391SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "922"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "463"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "463"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "463"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "463"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
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` = 463SELECT 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` = 463
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "463"
and `virtuemart_category_id`= "7"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 463SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1080"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` = "367"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "367"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "367"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "367"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 367SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 367
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "367"
and `virtuemart_category_id`= "8"SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `vgali_virtuemart_categories`.`virtuemart_category_id` = "8"SELECT id
FROM vgali_assets
WHERE parent_id = 0SELECT id
FROM vgali_assets
WHERE parent_id = 0SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =465
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` =367SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 465SELECT `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` = "245"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "245"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "245"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "245"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
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` = 245SELECT 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` = 245
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "245"
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 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` =245
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` =245
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` =245
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` = "228"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "228"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "228"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "228"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
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` = 228SELECT 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` = 228
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "228"
and `virtuemart_category_id`= "7"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 228SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1098"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` = "432"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "432"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "432"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "432"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
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` = 432SELECT 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` = 432
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "432"
and `virtuemart_category_id`= "7"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 22SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=22SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 432SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1019"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` = "390"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "390"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "390"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "390"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
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` = 390SELECT 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` = 390
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "390"
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` = 390SELECT `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` = "921"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` =245
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` =390SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 245SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "63"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "63"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "63"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "63"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 63SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 63
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "63"
and `virtuemart_category_id`= "7"SELECT 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` =63
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` =63
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` =63
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-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 44SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 44
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "44"
and `virtuemart_category_id`= "3"SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `vgali_virtuemart_categories`.`virtuemart_category_id` = "3"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 5SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 3SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=3SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=5SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 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` = "126"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "126"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "126"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "126"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
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` = 126SELECT 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` = 126
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "126"
and `virtuemart_category_id`= "28"SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `vgali_virtuemart_categories`.`virtuemart_category_id` = "28"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 28SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=28SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 126SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "703"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` = "55"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "55"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "55"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "55"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
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` = 55SELECT 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` = 55
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "55"
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 `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` = 55SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "694"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-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 116SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 116
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "116"
and `virtuemart_category_id`= "7"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 116SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "907"SELECT 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` =63
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` =63
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` =116SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 63SELECT `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` = "424"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "424"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "424"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "424"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
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` = 424SELECT 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` = 424
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "424"
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` =424
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` =424
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` =424
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` =424
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` =424
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=3
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` =424SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 29SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=29SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 424SELECT `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` = "413"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "413"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "413"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "413"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
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` = 413SELECT 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` = 413
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "413"
and `virtuemart_category_id`= "3"SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =413
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` =413
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` =413
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` = "8"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "8"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "8"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "8"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
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` = 8SELECT 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` = 8
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "8"
and `virtuemart_category_id`= "3"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 8SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "705"SELECT `vgali_virtuemart_products`.* ,`vgali_virtuemart_products_en_gb`.* ,`vgali_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`vgali_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `vgali_virtuemart_products`
INNER JOIN `vgali_virtuemart_products_en_gb` using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_manufacturers`
on `vgali_virtuemart_product_manufacturers`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_customfields`
on `vgali_virtuemart_product_customfields`.`virtuemart_product_id`=`vgali_virtuemart_products`.`virtuemart_product_id`
WHERE `vgali_virtuemart_products`.`virtuemart_product_id` = "138"SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "138"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "138"SELECT *
FROM `vgali_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "138"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-05-21 00:05:09" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-05-21 00:05:09" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 138SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc
LEFT JOIN `vgali_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 138
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "138"
and `virtuemart_category_id`= "3"SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 138SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "654"SELECT 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` =413
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` =138SELECT `slug`
FROM `vgali_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 413SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1083"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1084"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1053"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "908"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "1002"SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`
WHERE `vgali_virtuemart_medias`.`virtuemart_media_id` = "966"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`= 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`= 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`= 43SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=43SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM vgali_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 49SELECT `slug` as name
FROM `vgali_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=49SELECT `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:2560:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzc5MzIxOTA5O3M6NDoibGFzdCI7aToxNzc5MzIxOTA5O3M6Mzoibm93IjtpOjE3NzkzMjE5MDk7fX1zOjg6InJlZ2lzdHJ5IjtPOjk6IkpSZWdpc3RyeSI6MTp7czo3OiIAKgBkYXRhIjtPOjg6InN0ZENsYXNzIjoxOntzOjE0OiJjb21fdmlydHVlbWFydCI7Tzo4OiJzdGRDbGFzcyI6MTp7czoxNDoicHJvZHVjdGRldGFpbHMiO086ODoic3RkQ2xhc3MiOjI6e3M6NToibGltaXQiO3M6MzoiaW50IjtzOjEwOiJsaW1pdHN0YXJ0IjtpOjA7fX19fXM6NDoidXNlciI7Tzo1OiJKVXNlciI6MjU6e3M6OToiACoAaXNSb290IjtiOjA7czoyOiJpZCI7aTowO3M6NDoibmFtZSI7TjtzOjg6InVzZXJuYW1lIjtOO3M6NToiZW1haWwiO047czo4OiJwYXNzd29yZCI7TjtzOjE0OiJwYXNzd29yZF9jbGVhciI7czowOiIiO3M6ODoidXNlcnR5cGUiO047czo1OiJibG9jayI7TjtzOjk6InNlbmRFbWFpbCI7aTowO3M6MTI6InJlZ2lzdGVyRGF0ZSI7TjtzOjEzOiJsYXN0dmlzaXREYXRlIjtOO3M6MTA6ImFjdGl2YXRpb24iO047czo2OiJwYXJhbXMiO047czo2OiJncm91cHMiO2E6MDp7fXM6NToiZ3Vlc3QiO2k6MTtzOjEzOiJsYXN0UmVzZXRUaW1lIjtOO3M6MTA6InJlc2V0Q291bnQiO047czoxMDoiACoAX3BhcmFtcyI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjE0OiIAKgBfYXV0aEdyb3VwcyI7YToxOntpOjA7aToxO31zOjE0OiIAKgBfYXV0aExldmVscyI7YToyOntpOjA7aToxO2k6MTtpOjE7fXM6MTU6IgAqAF9hdXRoQWN0aW9ucyI7TjtzOjEyOiIAKgBfZXJyb3JNc2ciO047czoxMDoiACoAX2Vycm9ycyI7YTowOnt9czozOiJhaWQiO2k6MDt9fXM6NDoiX192bSI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo2OiJ2bWNhcnQiO3M6NzUyOiJPOjg6InN0ZENsYXNzIjoyODp7czo4OiJwcm9kdWN0cyI7YTowOnt9czo4OiJ2ZW5kb3JJZCI7aToxO3M6MjE6Imxhc3RWaXNpdGVkQ2F0ZWdvcnlJZCI7aTowO3M6Mjg6InZpcnR1ZW1hcnRfc2hpcG1lbnRtZXRob2RfaWQiO2k6MDtzOjI3OiJ2aXJ0dWVtYXJ0X3BheW1lbnRtZXRob2RfaWQiO2k6MDtzOjI1OiJhdXRvbWF0aWNTZWxlY3RlZFNoaXBtZW50IjtiOjA7czoyNDoiYXV0b21hdGljU2VsZWN0ZWRQYXltZW50IjtiOjA7czoxMjoib3JkZXJfbnVtYmVyIjtOO3M6MTk6InZpcnR1ZW1hcnRfb3JkZXJfaWQiO2I6MDtzOjI6IkJUIjtpOjA7czoyOiJTVCI7aTowO3M6MTE6InRvc0FjY2VwdGVkIjtiOjA7czoxNjoiY3VzdG9tZXJfY29tbWVudCI7czowOiIiO3M6MTA6ImNvdXBvbkNvZGUiO3M6MDoiIjtzOjIwOiJfdHJpZXNWYWxpZGF0ZUNvdXBvbiI7YTowOnt9czoxNDoib3JkZXJfbGFuZ3VhZ2UiO3M6MDoiIjtzOjg6ImNhcnREYXRhIjtOO3M6NToibGlzdHMiO047czoxNDoicHJpY2VzQ3VycmVuY3kiO047czoxNToicGF5bWVudEN1cnJlbmN5IjtOO3M6MTA6Il9pbkNvbmZpcm0iO2I6MDtzOjExOiJfaW5DaGVja091dCI7YjowO3M6MTQ6Il9kYXRhVmFsaWRhdGVkIjtiOjA7czoxMjoiX2NvbmZpcm1Eb25lIjtiOjA7czoxMDoiU1RzYW1lQXNCVCI7YjoxO3M6MTU6ImN1c3RvbWVyX251bWJlciI7czo3OiJub25yZWdfIjtzOjY6ImxheW91dCI7czo3OiJkZWZhdWx0IjtzOjEwOiJsYXlvdXRQYXRoIjtzOjA6IiI7fSI7czoyMzoidm1sYXN0dmlzaXRlZGNhdGVnb3J5aWQiO2k6NztzOjIzOiJ2bWxhc3R2aXNpdGVkcHJvZHVjdGlkcyI7YToxOntpOjA7aToyNjU7fX19fQ==\";'
, `time` = '1779321909'
WHERE `session_id` = '7318bf1560f61d8035d43099766b3402'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`23 × SELECT `vgali_virtuemart_medias`.*
FROM `vgali_virtuemart_medias`19 × SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_product_shoppergroups`19 × SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_product_medias`19 × SELECT *
FROM `vgali_virtuemart_product_prices`19 × 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`19 × SELECT `ordering`,`id`
FROM `vgali_virtuemart_product_categories`19 × 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`19 × SELECT pc.`virtuemart_category_id`
FROM `vgali_virtuemart_product_categories` as pc18 × 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 id
FROM vgali_assets7 × SELECT `vgali_virtuemart_categories`.* ,`vgali_virtuemart_categories_en_gb`.*
FROM `vgali_virtuemart_categories`
INNER JOIN `vgali_virtuemart_categories_en_gb` using (`virtuemart_category_id`)6 × SELECT C.`virtuemart_custom_id` , `custom_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 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_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_extensions3 × SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `vgali_virtuemart_customs` AS C
LEFT JOIN `vgali_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`2 × SELECT `virtuemart_shoppergroup_id`
FROM vgali_virtuemart_calc_shoppergroups2 × SELECT *
FROM `vgali_virtuemart_shoppergroups`2 × SELECT `virtuemart_country_id`
FROM vgali_virtuemart_calc_countries2 × SELECT `virtuemart_category_id`
FROM vgali_virtuemart_calc_categories2 × SELECT `virtuemart_state_id`
FROM vgali_virtuemart_calc_states2 × SELECT b.rules
FROM vgali_assets AS a
LEFT JOIN vgali_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt2 × SELECT `virtuemart_manufacturer_id`
FROM vgali_virtuemart_calc_manufacturers1 × SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
FROM `vgali_virtuemart_categories_en_gb` l JOIN `vgali_virtuemart_categories` AS c using (`virtuemart_category_id`)
LEFT JOIN `vgali_virtuemart_category_categories` AS cx
ON l.`virtuemart_category_id` = cx.`category_child_id`1 × SELECT count(vgali_virtuemart_products.virtuemart_product_id) AS total
FROM `vgali_virtuemart_products`, `vgali_virtuemart_product_categories`1 × SELECT `value`
FROM `vgali_admintools_storage`1 × SELECT `virtuemart_media_id`
FROM `vgali_virtuemart_category_medias`1 × SELECT a.rules
FROM vgali_assets AS a1 × SELECT `virtuemart_currency_id`,CONCAT_WS(" ",`currency_name`,`currency_symbol`) as currency_txt
FROM `vgali_virtuemart_currencies`1 × SELECT CONCAT(`vendor_accepted_currencies`, ",",`vendor_currency`) AS all_currencies, `vendor_currency`
FROM `vgali_virtuemart_vendors`1 × SELECT p.`virtuemart_product_id` , IF(pp.override, pp.product_override_price, pp.product_price) as product_price
FROM `vgali_virtuemart_products` as p
INNER JOIN `vgali_virtuemart_products_en_gb` as l using (`virtuemart_product_id`)
LEFT JOIN `vgali_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `vgali_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`1 × SELECT 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 `customer_number`
FROM `vgali_virtuemart_vmusers`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 *
FROM `vgali_virtuemart_userfields`1 × SELECT FOUND_ROWS(1 × SELECT `category_name`,`virtuemart_category_id`
FROM `vgali_virtuemart_categories_en_gb`1 × SELECT `category_child_id`
FROM `vgali_virtuemart_category_categories`1 × SELECT `price_display`,`custom_price_display`
FROM `vgali_virtuemart_shoppergroups` AS `sg`1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM vgali_menu AS m
LEFT JOIN vgali_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `config`
FROM `vgali_virtuemart_configs`1 × SELECT *
FROM `vgali_menu`1 × SELECT folder AS type, element AS name, params
FROM vgali_extensions1 × SELECT id, rules
FROM `vgali_viewlevels1 × SELECT `session_id`
FROM `vgali_session`1 × SELECT b.id
FROM vgali_usergroups AS a
LEFT JOIN vgali_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `virtuemart_category_id`
FROM `vgali_virtuemart_categories_en_gb`1 × SELECT `p`.`virtuemart_product_id`
FROM `vgali_virtuemart_products_en_gb` AS `p`
LEFT JOIN `vgali_virtuemart_product_categories` AS `xref`
ON `p`.`virtuemart_product_id` = `xref`.`virtuemart_product_id`1 × SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `vgali_virtuemart_vendors` AS v
LEFT JOIN `vgali_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency1 × SELECT *
FROM `vgali_virtuemart_currencies`1 × SELECT `data`
FROM `vgali_session`1 × SELECT `vgali_virtuemart_manufacturers`.* ,`vgali_virtuemart_manufacturers_en_gb`.*
FROM `vgali_virtuemart_manufacturers`
INNER JOIN `vgali_virtuemart_manufacturers_en_gb` using (`virtuemart_manufacturer_id`)1 × SELECT `virtuemart_shoppergroup_id`
FROM `vgali_virtuemart_vmuser_shoppergroups`1 × SELECT *
FROM vgali_languages1 × SELECT id, home, template, s.params
FROM vgali_template_styles as s
LEFT JOIN vgali_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM vgali_virtuemart_calcs1 × SHOW FULL COLUMNS
FROM `vgali_virtuemart_userfields1 × UPDATE `vgali_session`
SET `data` = 'joomla|s:2560:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzc5MzIxOTA5O3M6NDoibGFzdCI7aToxNzc5MzIxOTA5O3M6Mzoibm93IjtpOjE3NzkzMjE5MDk7fX1zOjg6InJlZ2lzdHJ5IjtPOjk6IkpSZWdpc3RyeSI6MTp7czo3OiIAKgBkYXRhIjtPOjg6InN0ZENsYXNzIjoxOntzOjE0OiJjb21fdmlydHVlbWFydCI7Tzo4OiJzdGRDbGFzcyI6MTp7czoxNDoicHJvZHVjdGRldGFpbHMiO086ODoic3RkQ2xhc3MiOjI6e3M6NToibGltaXQiO3M6MzoiaW50IjtzOjEwOiJsaW1pdHN0YXJ0IjtpOjA7fX19fXM6NDoidXNlciI7Tzo1OiJKVXNlciI6MjU6e3M6OToiACoAaXNSb290IjtiOjA7czoyOiJpZCI7aTowO3M6NDoibmFtZSI7TjtzOjg6InVzZXJuYW1lIjtOO3M6NToiZW1haWwiO047czo4OiJwYXNzd29yZCI7TjtzOjE0OiJwYXNzd29yZF9jbGVhciI7czowOiIiO3M6ODoidXNlcnR5cGUiO047czo1OiJibG9jayI7TjtzOjk6InNlbmRFbWFpbCI7aTowO3M6MTI6InJlZ2lzdGVyRGF0ZSI7TjtzOjEzOiJsYXN0dmlzaXREYXRlIjtOO3M6MTA6ImFjdGl2YXRpb24iO047czo2OiJwYXJhbXMiO047czo2OiJncm91cHMiO2E6MDp7fXM6NToiZ3Vlc3QiO2k6MTtzOjEzOiJsYXN0UmVzZXRUaW1lIjtOO3M6MTA6InJlc2V0Q291bnQiO047czoxMDoiACoAX3BhcmFtcyI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjE0OiIAKgBfYXV0aEdyb3VwcyI7YToxOntpOjA7aToxO31zOjE0OiIAKgBfYXV0aExldmVscyI7YToyOntpOjA7aToxO2k6MTtpOjE7fXM6MTU6IgAqAF9hdXRoQWN0aW9ucyI7TjtzOjEyOiIAKgBfZXJyb3JNc2ciO047czoxMDoiACoAX2Vycm9ycyI7YTowOnt9czozOiJhaWQiO2k6MDt9fXM6NDoiX192bSI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo2OiJ2bWNhcnQiO3M6NzUyOiJPOjg6InN0ZENsYXNzIjoyODp7czo4OiJwcm9kdWN0cyI7YTowOnt9czo4OiJ2ZW5kb3JJZCI7aToxO3M6MjE6Imxhc3RWaXNpdGVkQ2F0ZWdvcnlJZCI7aTowO3M6Mjg6InZpcnR1ZW1hcnRfc2hpcG1lbnRtZXRob2RfaWQiO2k6MDtzOjI3OiJ2aXJ0dWVtYXJ0X3BheW1lbnRtZXRob2RfaWQiO2k6MDtzOjI1OiJhdXRvbWF0aWNTZWxlY3RlZFNoaXBtZW50IjtiOjA7czoyNDoiYXV0b21hdGljU2VsZWN0ZWRQYXltZW50IjtiOjA7czoxMjoib3JkZXJfbnVtYmVyIjtOO3M6MTk6InZpcnR1ZW1hcnRfb3JkZXJfaWQiO2I6MDtzOjI6IkJUIjtpOjA7czoyOiJTVCI7aTowO3M6MTE6InRvc0FjY2VwdGVkIjtiOjA7czoxNjoiY3VzdG9tZXJfY29tbWVudCI7czowOiIiO3M6MTA6ImNvdXBvbkNvZGUiO3M6MDoiIjtzOjIwOiJfdHJpZXNWYWxpZGF0ZUNvdXBvbiI7YTowOnt9czoxNDoib3JkZXJfbGFuZ3VhZ2UiO3M6MDoiIjtzOjg6ImNhcnREYXRhIjtOO3M6NToibGlzdHMiO047czoxNDoicHJpY2VzQ3VycmVuY3kiO047czoxNToicGF5bWVudEN1cnJlbmN5IjtOO3M6MTA6Il9pbkNvbmZpcm0iO2I6MDtzOjExOiJfaW5DaGVja091dCI7YjowO3M6MTQ6Il9kYXRhVmFsaWRhdGVkIjtiOjA7czoxMjoiX2NvbmZpcm1Eb25lIjtiOjA7czoxMDoiU1RzYW1lQXNCVCI7YjoxO3M6MTU6ImN1c3RvbWVyX251bWJlciI7czo3OiJub25yZWdfIjtzOjY6ImxheW91dCI7czo3OiJkZWZhdWx0IjtzOjEwOiJsYXlvdXRQYXRoIjtzOjA6IiI7fSI7czoyMzoidm1sYXN0dmlzaXRlZGNhdGVnb3J5aWQiO2k6NztzOjIzOiJ2bWxhc3R2aXNpdGVkcHJvZHVjdGlkcyI7YToxOntpOjA7aToyNjU7fX19fQ==\";' , `time` = '1779321909'1 × SHOW FULL COLUMNS
FROM `vgali_assets1 × SHOW TABLES LIKE "vgali_virtuemart_configs1 × INSERT INTO `vgali_session` (`session_id`, `client_id`, `time`)
VALUES ('7318bf1560f61d8035d43099766b3402', 0, '1779321909'1 × DELETE
FROM `vgali_session`






