Bonjour Visiteur
Au fil des voyages, au fil des rencontres.
Trame des relations, autour des tissus ;
De la spirale Hmong, aux pompons Lisu ...
A partir de 60€ d'achats, les frais de port sont offerts !!
Venez voir les nouveautés
La mode ethnique fait sa Une !!!
De plus en plus en vogue, en Asie, une mode suivie de près en Europe.
L’ethnique et, notamment et surtout, les vêtements Hmong sont à l’honneur dans le milieu de la mode. Des vêtements utilisant les tissus vintage ou copiant les motifs que l’on retrouve au fil des magazines ainsi que dans les boutiques branchées.
Le chic de l’ethnique par excellence !

Des tenues plus sobres seront magnifiées par des sacs utilisant ces tissus, véritables œuvres d’art qui feront perdurer la mémoire d’une culture.
session.client.forwarded ⇒ 216.73.216.131
session.client.browser ⇒ Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
password_clear ⇒
groups ⇒
session.token ⇒ fc07538f6fa16d965450bed2a36e8bf0
vmcart ⇒ O:8:"stdClass":21:{s:8:"products";a:0:{}s:8:"vendorId";i:1;s:21:"lastVisitedCategoryId";i:0;s:28:"virtuemart_shipmentmethod_id";i:0;s:27:"virtuemart_paymentmethod_id";i:0;s:25:"automaticSelectedShipment";b:0;s:24:"automaticSelectedPayment";b:0;s:12:"order_number";N;s:2:"BT";i:0;s:2:"ST";i:0;s:11:"tosAccepted";N;s:16:"customer_comment";s:0:"";s:10:"couponCode";s:0:"";s:8:"cartData";N;s:5:"lists";N;s:14:"pricesCurrency";N;s:15:"paymentCurrency";N;s:11:"_inCheckOut";b:0;s:14:"_dataValidated";b:0;s:12:"_confirmDone";b:0;s:10:"STsameAsBT";i:0;}
Application 0.000 seconds (+0.000); 0.19 MB (+0.193) - afterLoadApplication 0.016 seconds (+0.015); 0.83 MB (+0.633) - afterInitialiseApplication 0.083 seconds (+0.067); 1.22 MB (+0.393) - afterRouteApplication 0.097 seconds (+0.014); 1.66 MB (+0.442) - afterDispatchApplication 0.120 seconds (+0.024); 2.81 MB (+1.146) - beforeRenderModule mod_roknavmenu ()Application 0.185 seconds (+0.065); 3.28 MB (+0.468) - beforeRenderModule mod_login (Se Connecter)Application 0.187 seconds (+0.002); 3.30 MB (+0.023) - afterRenderModule mod_login (Se Connecter)Application 0.187 seconds (+0.000); 3.27 MB (-0.030) - afterRenderModule mod_roknavmenu ()Application 0.189 seconds (+0.002); 3.25 MB (-0.013) - beforeRenderModule mod_custom (Footer Mentions Legales)Application 0.190 seconds (+0.001); 3.26 MB (+0.004) - afterRenderModule mod_custom (Footer Mentions Legales)Application 0.190 seconds (+0.000); 3.26 MB (-0.001) - beforeRenderModule mod_custom (Footer Conditions Générales)Application 0.190 seconds (+0.000); 3.26 MB (+0.003) - afterRenderModule mod_custom (Footer Conditions Générales)Application 0.190 seconds (+0.000); 3.26 MB (-0.001) - beforeRenderModule mod_custom (Footer Copyright)Application 0.190 seconds (+0.000); 3.26 MB (+0.003) - afterRenderModule mod_custom (Footer Copyright)Application 0.190 seconds (+0.000); 3.26 MB (-0.000) - beforeRenderModule mod_articles_categories (Mes soeurs)Application 0.192 seconds (+0.002); 3.28 MB (+0.015) - afterRenderModule mod_articles_categories (Mes soeurs)Application 0.192 seconds (+0.000); 3.28 MB (-0.002) - beforeRenderModule mod_virtuemart_product (Les Vedettes)Application 0.277 seconds (+0.085); 3.98 MB (+0.706) - afterRenderModule mod_virtuemart_product (Les Vedettes)Application 0.277 seconds (+0.000); 3.98 MB (-0.005) - beforeRenderModule mod_virtuemart_product (Au hasard)Application 0.302 seconds (+0.024); 4.28 MB (+0.303) - afterRenderModule mod_virtuemart_product (Au hasard)Application 0.302 seconds (+0.000); 4.27 MB (-0.006) - beforeRenderModule mod_virtuemart_search (Rechercher)Application 0.305 seconds (+0.003); 4.29 MB (+0.014) - afterRenderModule mod_virtuemart_search (Rechercher)Application 0.305 seconds (+0.000); 4.28 MB (-0.003) - beforeRenderModule mod_virtuemart_cart (Panier)Application 0.475 seconds (+0.170); 5.57 MB (+1.285) - afterRenderModule mod_virtuemart_cart (Panier)Application 0.475 seconds (+0.000); 5.57 MB (-0.001) - beforeRenderModule mod_vm_prod_cat_full (Catégories)Application 0.511 seconds (+0.036); 5.85 MB (+0.278) - afterRenderModule mod_vm_prod_cat_full (Catégories)Application 0.511 seconds (+0.000); 5.85 MB (+0.000) - beforeRenderModule mod_breadcrumbs (Fil d'Arianne)Application 0.513 seconds (+0.002); 5.86 MB (+0.014) - afterRenderModule mod_breadcrumbs (Fil d'Arianne)Application 0.513 seconds (+0.000); 5.86 MB (-0.004) - beforeRenderModule mod_virtuemart_product (Nouveautés !)Application 0.544 seconds (+0.031); 6.18 MB (+0.318) - afterRenderModule mod_virtuemart_product (Nouveautés !)Application 0.544 seconds (+0.000); 6.17 MB (-0.006) - beforeRenderModule mod_custom (Bonne nouvelle !)Application 0.544 seconds (+0.000); 6.17 MB (+0.003) - afterRenderModule mod_custom (Bonne nouvelle !)Application 0.544 seconds (+0.000); 6.17 MB (-0.001) - beforeRenderModule mod_custom (Retour de voyage en asie)Application 0.545 seconds (+0.000); 6.17 MB (+0.003) - afterRenderModule mod_custom (Retour de voyage en asie)Application 0.545 seconds (+0.000); 6.17 MB (-0.001) - beforeRenderModule mod_custom (Utilisateur courant)Application 0.545 seconds (+0.000); 6.18 MB (+0.003) - afterRenderModule mod_custom (Utilisateur courant)Application 0.550 seconds (+0.005); 6.23 MB (+0.055) - afterRender6.28 MB (6,584,140 Bytes)SELECT `data`
FROM `jom25_session`
WHERE `session_id` = 'fcc2b128fd65db16ee3c1dc25ca21a5c'SELECT `session_id`
FROM `jom25_session`
WHERE `session_id` = 'fcc2b128fd65db16ee3c1dc25ca21a5c'
LIMIT 0, 1INSERT INTO `jom25_session`
(`session_id`, `client_id`, `time`)
VALUES
('fcc2b128fd65db16ee3c1dc25ca21a5c', 0, '1771244256')SELECT extension_id AS id, element AS "option", params, enabled
FROM jom25_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT b.id
FROM jom25_usergroups AS a
LEFT JOIN jom25_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1SELECT id, rules
FROM `jom25_viewlevels`SELECT folder AS type, element AS name, params
FROM jom25_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 jom25_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 jom25_menu AS m
LEFT JOIN jom25_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.lftSELECT extension_id AS id, element AS "option", params, enabled
FROM jom25_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jom25_categories as c
LEFT JOIN jom25_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jom25_categories AS cat JOIN jom25_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=17
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT alias, catid
FROM jom25_content
WHERE id = 17SHOW FULL COLUMNS
FROM `jom25_content`SELECT *
FROM jom25_jcomments_settingsSELECT id, home, template, s.params
FROM jom25_template_styles as s
LEFT JOIN jom25_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 *
FROM jom25_languages
WHERE published=1
ORDER BY ordering ASCSELECT a.rules
FROM jom25_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftSELECT b.rules
FROM jom25_assets AS a
LEFT JOIN jom25_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
SELECT MAX(contact.id) AS id
FROM jom25_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jom25_content AS a
LEFT JOIN jom25_categories AS c
on c.id = a.catid
LEFT JOIN jom25_users AS u
on u.id = a.created_by
LEFT JOIN jom25_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jom25_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jom25_categories AS cat JOIN jom25_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 17
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-16 12:17:37')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-16 12:17:37')
AND (a.state = 1 OR a.state =2)SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jom25_categories as c
LEFT JOIN jom25_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jom25_categories AS cat JOIN jom25_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=10
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT b.rules
FROM jom25_assets AS a
LEFT JOIN jom25_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.17')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT a.id,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM jom25_content AS a
LEFT JOIN jom25_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 10
AND a.state = 1
AND a.access = 1
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-02-16 12:17:37')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-02-16 12:17:37')
ORDER BY a.created DESCSELECT *
FROM `jom25_jcomments_objects`
WHERE `object_id` = '17'
AND `object_group` = 'com_content'
AND `lang` = 'fr-FR'SELECT count(*)
FROM jom25_jcomments AS c
WHERE c.object_id = 17
AND c.object_group = 'com_content'
AND c.published = 1UPDATE jom25_content
SET hits = hits + 1
WHERE id = 17SELECT id, home, template, s.params
FROM jom25_template_styles as s
LEFT JOIN jom25_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 id, home, template, s.params
FROM jom25_template_styles as s
LEFT JOIN jom25_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 id, home, template, s.params
FROM jom25_template_styles as s
LEFT JOIN jom25_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 m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jom25_modules AS m
LEFT JOIN jom25_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jom25_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-02-16 12:17:37')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-02-16 12:17:37')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 123 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingSELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, m.published, m.ordering, m.id in ( '91' ) as in_id, m.position in ( '91' ) as in_position
FROM jom25_modules AS m
WHERE m.access IN (1,1)
AND ( m.id in ( '91' ) OR m.position in ( '91' ) )
ORDER BY ( field(
case when m.position in ( '91' ) then m.position else m.id end,
'91' )), m.orderingSELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, m.published, m.ordering, m.id in ( '88' ) as in_id, m.position in ( '88' ) as in_position
FROM jom25_modules AS m
WHERE m.access IN (1,1)
AND ( m.id in ( '88' ) OR m.position in ( '88' ) )
ORDER BY ( field(
case when m.position in ( '88' ) then m.position else m.id end,
'88' )), m.orderingSELECT ts.template
FROM jom25_template_styles AS ts
INNER JOIN jom25_menu AS m
ON ts.id=m.template_style_id
WHERE m.id = 123
AND m.template_style_id != 0SELECT template
FROM jom25_template_styles
WHERE home = 1
AND client_id = 0SHOW TABLES LIKE "%virtuemart_configs%"SELECT `config`
FROM `jom25_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `jom25_virtuemart_permgroups`
ORDER BY `group_level`SELECT extension_id AS id, element AS "option", params, enabled
FROM jom25_extensions
WHERE `type` = 'component'
AND `element` = 'com_virtuemart'SELECT *
FROM `jom25_menu`
where `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language="fr_fr")SELECT extension_id AS id, element AS "option", params, enabled
FROM jom25_extensions
WHERE `type` = 'component'
AND `element` = 'com_jevents'SELECT id, title, module, position, content, showtitle, params, mm.menuid
FROM jom25_modules AS m
LEFT JOIN jom25_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-02-16 12:17:37')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-02-16 12:17:37')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 123 OR mm.menuid <= 0)
ORDER BY position, orderingSELECT alias, catid
FROM jom25_content
WHERE id = 17SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jom25_categories as c
LEFT JOIN jom25_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jom25_categories AS cat JOIN jom25_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=2
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_vmuser_shoppergroups`
WHERE `virtuemart_user_id` = "0"SELECT *
FROM `jom25_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"SELECT `virtuemart_userinfo_id`
FROM `jom25_virtuemart_userinfos`
WHERE `virtuemart_user_id` = "0"SELECT l.`virtuemart_product_id`
FROM `jom25_virtuemart_products_fr_fr` as l JOIN `jom25_virtuemart_products` AS p using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_shoppergroups`
ON p.`virtuemart_product_id` = `jom25_virtuemart_product_shoppergroups`.`virtuemart_product_id`
LEFT
OUTER JOIN `jom25_virtuemart_shoppergroups` as s
ON s.`virtuemart_shoppergroup_id` = `jom25_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
WHERE ( p.`published`="1"
AND p.`product_in_stock` - p.`product_ordered` >"0"
AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL )
AND p.`product_special`="1" )
group by p.`virtuemart_product_id`
ORDER BY RAND()ASC
LIMIT 0, 2SELECT `jom25_virtuemart_products_fr_fr`.* ,`jom25_virtuemart_products`.* ,`jom25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jom25_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `jom25_virtuemart_products_fr_fr` JOIN jom25_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_manufacturers`
on `jom25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_customfields`
on `jom25_virtuemart_product_customfields`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
WHERE jom25_virtuemart_products_fr_fr.`virtuemart_product_id` = "164"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "164"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "164"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "164"
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-02-16 12:17:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-02-16 12:17:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 164SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "164"
and `virtuemart_category_id`= "7"SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)
WHERE jom25_virtuemart_categories_fr_fr.`virtuemart_category_id` = "7"SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `jom25_virtuemart_vendors` AS v
LEFT JOIN `jom25_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency
WHERE v.`virtuemart_vendor_id`="1"SELECT *
FROM `jom25_virtuemart_currencies`
WHERE `virtuemart_currency_id`="47"SELECT `price_display`,`custom_price_display`
FROM `jom25_virtuemart_shoppergroups` AS `sg`
WHERE `sg`.`default` = "2"SELECT *
FROM `jom25_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"SELECT *
FROM jom25_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-02-16 12:17:37" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-02-16 12:17:37" )
OR `for_override` = "1" )SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 7SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 4SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=4SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=7SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 164SELECT `jom25_virtuemart_products_fr_fr`.* ,`jom25_virtuemart_products`.* ,`jom25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jom25_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `jom25_virtuemart_products_fr_fr` JOIN jom25_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_manufacturers`
on `jom25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_customfields`
on `jom25_virtuemart_product_customfields`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
WHERE jom25_virtuemart_products_fr_fr.`virtuemart_product_id` = "166"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "166"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "166"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "166"
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-02-16 12:17:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-02-16 12:17:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 166SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "166"
and `virtuemart_category_id`= "7"SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)
WHERE jom25_virtuemart_categories_fr_fr.`virtuemart_category_id` = "7"SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 166SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "389"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "390"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "391"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "392"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "393"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "394"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "395"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "402"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "403"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "404"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "405"SELECT l.`virtuemart_product_id`
FROM `jom25_virtuemart_products_fr_fr` as l JOIN `jom25_virtuemart_products` AS p using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_shoppergroups`
ON p.`virtuemart_product_id` = `jom25_virtuemart_product_shoppergroups`.`virtuemart_product_id`
LEFT
OUTER JOIN `jom25_virtuemart_shoppergroups` as s
ON s.`virtuemart_shoppergroup_id` = `jom25_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
WHERE ( p.`published`="1"
AND p.`product_in_stock` - p.`product_ordered` >"0"
AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL ) )
group by p.`virtuemart_product_id`
ORDER BY RAND() ASC
LIMIT 0, 2SELECT `jom25_virtuemart_products_fr_fr`.* ,`jom25_virtuemart_products`.* ,`jom25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jom25_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `jom25_virtuemart_products_fr_fr` JOIN jom25_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_manufacturers`
on `jom25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_customfields`
on `jom25_virtuemart_product_customfields`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
WHERE jom25_virtuemart_products_fr_fr.`virtuemart_product_id` = "106"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "106"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "106"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "106"
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-02-16 12:17:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-02-16 12:17:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 106SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "106"
and `virtuemart_category_id`= "21"SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)
WHERE jom25_virtuemart_categories_fr_fr.`virtuemart_category_id` = "21"SELECT `jom25_virtuemart_products_fr_fr`.* ,`jom25_virtuemart_products`.* ,`jom25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jom25_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `jom25_virtuemart_products_fr_fr` JOIN jom25_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_manufacturers`
on `jom25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_customfields`
on `jom25_virtuemart_product_customfields`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
WHERE jom25_virtuemart_products_fr_fr.`virtuemart_product_id` = "93"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "93"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "93"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "93"
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-02-16 12:17:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-02-16 12:17:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 93SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "93"
and `virtuemart_category_id`= "21"SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)
WHERE jom25_virtuemart_categories_fr_fr.`virtuemart_category_id` = "21"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 21SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 5SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=5SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=21SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 106SELECT `jom25_virtuemart_products_fr_fr`.* ,`jom25_virtuemart_products`.* ,`jom25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jom25_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `jom25_virtuemart_products_fr_fr` JOIN jom25_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_manufacturers`
on `jom25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_customfields`
on `jom25_virtuemart_product_customfields`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
WHERE jom25_virtuemart_products_fr_fr.`virtuemart_product_id` = "47"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "47"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "47"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "47"
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-02-16 12:17:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-02-16 12:17:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 47SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "47"
and `virtuemart_category_id`= "26"SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)
WHERE jom25_virtuemart_categories_fr_fr.`virtuemart_category_id` = "26"SELECT `jom25_virtuemart_products_fr_fr`.* ,`jom25_virtuemart_products`.* ,`jom25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jom25_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `jom25_virtuemart_products_fr_fr` JOIN jom25_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_manufacturers`
on `jom25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_customfields`
on `jom25_virtuemart_product_customfields`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
WHERE jom25_virtuemart_products_fr_fr.`virtuemart_product_id` = "45"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "45"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "45"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "45"
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-02-16 12:17:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-02-16 12:17:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 45SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "45"
and `virtuemart_category_id`= "26"SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)
WHERE jom25_virtuemart_categories_fr_fr.`virtuemart_category_id` = "26"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 26SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 6SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=6SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=26SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 47SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "198"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "199"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "68"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 0SELECT *
FROM jom25_virtuemart_calcs
WHERE
`calc_kind`="DBTaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2026-02-16 12:17:37" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-02-16 12:17:37" )SELECT *
FROM jom25_virtuemart_calcs
WHERE
`calc_kind`="TaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2026-02-16 12:17:37" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-02-16 12:17:37" )SELECT *
FROM jom25_virtuemart_calcs
WHERE
`calc_kind`="DATaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2026-02-16 12:17:37" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-02-16 12:17:37" )SELECT `category_parent_id`, `ordering`
FROM `jom25_virtuemart_category_categories`
WHERE `category_child_id` = '-1'SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 0
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "4"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "5"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "6"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "9"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "37"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "17"
ORDER BY `ordering`SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 4SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 4
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "7"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "8"
ORDER BY `ordering`SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 7
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 8SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 4SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=8SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 8
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 5SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 5
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "22"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "20"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "21"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "23"
ORDER BY `ordering`SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 22SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 5SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=22SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 22
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 20SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 5SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=20SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 20
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 21
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 23SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 5SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=23SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 23
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 6SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 6
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "24"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "25"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "26"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "27"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "28"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "30"
ORDER BY `ordering`SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 24SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 6SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=24SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 24
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 25SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 6SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=25SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 25
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 26
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 27SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 6SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=27SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 27
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 28SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 6SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=28SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 28
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 30SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 6SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=30SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 30
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 9SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=9SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 9
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "31"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "32"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "33"
ORDER BY `ordering`SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 31SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 9SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=31SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 31
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 32SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 9SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=32SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 32
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 33SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 9SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=33SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 33
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 37SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=37SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 37
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 17SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=17SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 17
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "34"
ORDER BY `ordering`SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 34SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 17SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=34SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 34
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT l.`virtuemart_product_id`
FROM `jom25_virtuemart_products_fr_fr` as l JOIN `jom25_virtuemart_products` AS p using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_shoppergroups`
ON p.`virtuemart_product_id` = `jom25_virtuemart_product_shoppergroups`.`virtuemart_product_id`
LEFT
OUTER JOIN `jom25_virtuemart_shoppergroups` as s
ON s.`virtuemart_shoppergroup_id` = `jom25_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
WHERE ( p.`published`="1"
AND p.`product_in_stock` - p.`product_ordered` >"0"
AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL ) )
group by p.`virtuemart_product_id`
ORDER BY RAND() ASC
LIMIT 0, 4SELECT `jom25_virtuemart_products_fr_fr`.* ,`jom25_virtuemart_products`.* ,`jom25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jom25_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `jom25_virtuemart_products_fr_fr` JOIN jom25_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_manufacturers`
on `jom25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_customfields`
on `jom25_virtuemart_product_customfields`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
WHERE jom25_virtuemart_products_fr_fr.`virtuemart_product_id` = "41"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "41"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "41"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "41"
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-02-16 12:17:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-02-16 12:17:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 41SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "41"
and `virtuemart_category_id`= "24"SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)
WHERE jom25_virtuemart_categories_fr_fr.`virtuemart_category_id` = "24"SELECT `jom25_virtuemart_products_fr_fr`.* ,`jom25_virtuemart_products`.* ,`jom25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jom25_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `jom25_virtuemart_products_fr_fr` JOIN jom25_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_manufacturers`
on `jom25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_customfields`
on `jom25_virtuemart_product_customfields`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
WHERE jom25_virtuemart_products_fr_fr.`virtuemart_product_id` = "34"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "34"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "34"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "34"
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-02-16 12:17:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-02-16 12:17:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 34SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "34"
and `virtuemart_category_id`= "24"SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)
WHERE jom25_virtuemart_categories_fr_fr.`virtuemart_category_id` = "24"SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 41SELECT `jom25_virtuemart_products_fr_fr`.* ,`jom25_virtuemart_products`.* ,`jom25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jom25_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `jom25_virtuemart_products_fr_fr` JOIN jom25_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_manufacturers`
on `jom25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_customfields`
on `jom25_virtuemart_product_customfields`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
WHERE jom25_virtuemart_products_fr_fr.`virtuemart_product_id` = "155"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "155"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "155"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "155"
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-02-16 12:17:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-02-16 12:17:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 155SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "155"
and `virtuemart_category_id`= "7"SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)
WHERE jom25_virtuemart_categories_fr_fr.`virtuemart_category_id` = "7"SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 155SELECT `jom25_virtuemart_products_fr_fr`.* ,`jom25_virtuemart_products`.* ,`jom25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jom25_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `jom25_virtuemart_products_fr_fr` JOIN jom25_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_manufacturers`
on `jom25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_customfields`
on `jom25_virtuemart_product_customfields`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
WHERE jom25_virtuemart_products_fr_fr.`virtuemart_product_id` = "81"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "81"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "81"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "81"
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-02-16 12:17:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-02-16 12:17:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 81SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "81"
and `virtuemart_category_id`= "27"SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)
WHERE jom25_virtuemart_categories_fr_fr.`virtuemart_category_id` = "27"SELECT `jom25_virtuemart_products_fr_fr`.* ,`jom25_virtuemart_products`.* ,`jom25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jom25_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `jom25_virtuemart_products_fr_fr` JOIN jom25_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_manufacturers`
on `jom25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_customfields`
on `jom25_virtuemart_product_customfields`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
WHERE jom25_virtuemart_products_fr_fr.`virtuemart_product_id` = "79"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "79"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "79"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "79"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-02-16 12:17:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-02-16 12:17:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 79SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "79"
and `virtuemart_category_id`= "27"SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)
WHERE jom25_virtuemart_categories_fr_fr.`virtuemart_category_id` = "27"SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 81SELECT `jom25_virtuemart_products_fr_fr`.* ,`jom25_virtuemart_products`.* ,`jom25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jom25_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `jom25_virtuemart_products_fr_fr` JOIN jom25_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_manufacturers`
on `jom25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_customfields`
on `jom25_virtuemart_product_customfields`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
WHERE jom25_virtuemart_products_fr_fr.`virtuemart_product_id` = "84"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "84"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "84"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "84"
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-02-16 12:17:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-02-16 12:17:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 84SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "84"
and `virtuemart_category_id`= "27"SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)
WHERE jom25_virtuemart_categories_fr_fr.`virtuemart_category_id` = "27"SELECT `jom25_virtuemart_products_fr_fr`.* ,`jom25_virtuemart_products`.* ,`jom25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jom25_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `jom25_virtuemart_products_fr_fr` JOIN jom25_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_manufacturers`
on `jom25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_customfields`
on `jom25_virtuemart_product_customfields`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
WHERE jom25_virtuemart_products_fr_fr.`virtuemart_product_id` = "79"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "79"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "79"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "79"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-02-16 12:17:37" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-02-16 12:17:37" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 79SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "79"
and `virtuemart_category_id`= "27"SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)
WHERE jom25_virtuemart_categories_fr_fr.`virtuemart_category_id` = "27"SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 84SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "59"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "60"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "345"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "346"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "347"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "348"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "153"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "154"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "159"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "160"SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jom25_categories as c
LEFT JOIN jom25_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jom25_categories AS cat JOIN jom25_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=14
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftUPDATE `jom25_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1771244256;s:18:\"session.timer.last\";i:1771244256;s:17:\"session.timer.now\";i:1771244256;s:24:\"session.client.forwarded\";s:14:\"216.73.216.131\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"fc07538f6fa16d965450bed2a36e8bf0\";}__vm|a:1:{s:6:\"vmcart\";s:545:\"O:8:\"stdClass\":21:{s:8:\"products\";a:0:{}s:8:\"vendorId\";i:1;s:21:\"lastVisitedCategoryId\";i:0;s:28:\"virtuemart_shipmentmethod_id\";i:0;s:27:\"virtuemart_paymentmethod_id\";i:0;s:25:\"automaticSelectedShipment\";b:0;s:24:\"automaticSelectedPayment\";b:0;s:12:\"order_number\";N;s:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";N;s:16:\"customer_comment\";s:0:\"\";s:10:\"couponCode\";s:0:\"\";s:8:\"cartData\";N;s:5:\"lists\";N;s:14:\"pricesCurrency\";N;s:15:\"paymentCurrency\";N;s:11:\"_inCheckOut\";b:0;s:14:\"_dataValidated\";b:0;s:12:\"_confirmDone\";b:0;s:10:\"STsameAsBT\";i:0;}\";}'
, `time` = '1771244257'
WHERE `session_id` = 'fcc2b128fd65db16ee3c1dc25ca21a5c'**39 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`****24 × SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`****23 × SELECT L.*
FROM `jom25_virtuemart_categories_fr_fr` as L
JOIN `jom25_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `jom25_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`****22 × SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`****22 × SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`****13 × SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`****13 × SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`****13 × SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`****13 × SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc****13 × SELECT *
FROM `jom25_virtuemart_product_prices`****13 × SELECT `jom25_virtuemart_products_fr_fr`.* ,`jom25_virtuemart_products`.* ,`jom25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jom25_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `jom25_virtuemart_products_fr_fr` JOIN jom25_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_manufacturers`
on `jom25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_customfields`
on `jom25_virtuemart_product_customfields`.`virtuemart_product_id`=`jom25_virtuemart_products_fr_fr`.`virtuemart_product_id`****13 × SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)****8 × SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`****5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM jom25_extensions****4 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jom25_categories as c
LEFT JOIN jom25_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jom25_categories AS cat JOIN jom25_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt****4 × SELECT id, home, template, s.params
FROM jom25_template_styles as s
LEFT JOIN jom25_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id****4 × SELECT *
FROM jom25_virtuemart_calcs****3 × SELECT l.`virtuemart_product_id`
FROM `jom25_virtuemart_products_fr_fr` as l JOIN `jom25_virtuemart_products` AS p using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_product_shoppergroups`
ON p.`virtuemart_product_id` = `jom25_virtuemart_product_shoppergroups`.`virtuemart_product_id`
LEFT
OUTER JOIN `jom25_virtuemart_shoppergroups` as s
ON s.`virtuemart_shoppergroup_id` = `jom25_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`****2 × SELECT *
FROM `jom25_virtuemart_shoppergroups`****2 × SELECT b.rules
FROM jom25_assets AS a
LEFT JOIN jom25_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt****2 × SELECT alias, catid
FROM jom25_content****1 × SELECT `virtuemart_userinfo_id`
FROM `jom25_virtuemart_userinfos`****1 × SELECT `category_parent_id`, `ordering`
FROM `jom25_virtuemart_category_categories`****1 × SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_vmuser_shoppergroups`****1 × SELECT *
FROM `jom25_virtuemart_currencies`****1 × SELECT `price_display`,`custom_price_display`
FROM `jom25_virtuemart_shoppergroups` AS `sg`****1 × SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `jom25_virtuemart_vendors` AS v
LEFT JOIN `jom25_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency****1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `jom25_virtuemart_permgroups`****1 × SELECT *
FROM jom25_jcomments_setting****1 × SELECT *
FROM jom25_languages****1 × SELECT a.rules
FROM jom25_assets AS a****1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id
FROM jom25_contact_details AS contact****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 jom25_menu AS m
LEFT JOIN jom25_extensions AS e
ON m.component_id = e.extension_id****1 × SELECT folder AS type, element AS name, params
FROM jom25_extensions****1 × SELECT `session_id`
FROM `jom25_session`****1 × SELECT b.id
FROM jom25_usergroups AS a
LEFT JOIN jom25_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt****1 × SELECT id, rules
FROM `jom25_viewlevels****1 × SELECT a.id,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM jom25_content AS a
LEFT JOIN jom25_categories AS cc
ON cc.id = a.catid****1 × SELECT *
FROM `jom25_jcomments_objects`****1 × SELECT template
FROM jom25_template_styles****1 × SELECT `config`
FROM `jom25_virtuemart_configs`****1 × SELECT `data`
FROM `jom25_session`****1 × SELECT *
FROM `jom25_menu`****1 × SELECT ts.template
FROM jom25_template_styles AS ts
INNER JOIN jom25_menu AS m
ON ts.id=m.template_style_id****1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, m.published, m.ordering, m.id in ( '88' ) as in_id, m.position in ( '88' ) as in_position
FROM jom25_modules AS m****1 × SELECT count(*)
FROM jom25_jcomments AS c****1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jom25_modules AS m
LEFT JOIN jom25_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jom25_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id****1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, m.published, m.ordering, m.id in ( '91' ) as in_id, m.position in ( '91' ) as in_position
FROM jom25_modules AS m****1 × SELECT id, title, module, position, content, showtitle, params, mm.menuid
FROM jom25_modules AS m
LEFT JOIN jom25_modules_menu AS mm
ON mm.moduleid = m.id****1 × UPDATE `jom25_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1771244256;s:18:\"session.timer.last\";i:1771244256;s:17:\"session.timer.now\";i:1771244256;s:24:\"session.client.forwarded\";s:14:\"216.73.216.131\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"fc07538f6fa16d965450bed2a36e8bf0\";}__vm|a:1:{s:6:\"vmcart\";s:545:\"O:8:\"stdClass\":21:{s:8:\"products\";a:0:{}s:8:\"vendorId\";i:1;s:21:\"lastVisitedCategoryId\";i:0;s:28:\"virtuemart_shipmentmethod_id\";i:0;s:27:\"virtuemart_paymentmethod_id\";i:0;s:25:\"automaticSelectedShipment\";b:0;s:24:\"automaticSelectedPayment\";b:0;s:12:\"order_number\";N;s:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";N;s:16:\"customer_comment\";s:0:\"\";s:10:\"couponCode\";s:0:\"\";s:8:\"cartData\";N;s:5:\"lists\";N;s:14:\"pricesCurrency\";N;s:15:\"paymentCurrency\";N;s:11:\"_inCheckOut\";b:0;s:14:\"_dataValidated\";b:0;s:12:\"_confirmDone\";b:0;s:10:\"STsameAsBT\";i:0;}\";}' , `time` = '1771244257'****1 × SHOW TABLES LIKE "%virtuemart_configs%****1 × UPDATE jom25_content
SET hits = hits + 1****1 × SHOW FULL COLUMNS
FROM `jom25_content****1 × INSERT INTO `jom25_session` (`session_id`, `client_id`, `time`)
VALUES ('fcc2b128fd65db16ee3c1dc25ca21a5c', 0, '1771244256'**# JROOT/administrator/components/com_virtuemart/tables/paymentmethods.php COM_VIRTUEMART_PAYMENT_JPLUGIN_ID="VIRTUEMART PAYMENT JPLUGIN ID" COM_VIRTUEMART_PAYMENT_NAME="VIRTUEMART PAYMENT NAME" # JROOT/administrator/components/com_virtuemart/tables/shoppergroups.php COM_VIRTUEMART_SHOPPER_GROUP_NAME="VIRTUEMART SHOPPER GROUP NAME" # JROOT/administrator/components/com_virtuemart/tables/category_medias.php COM_VIRTUEMART_VIRTUEMART_CATEGORY_ID="VIRTUEMART VIRTUEMART CATEGORY ID" # JROOT/administrator/components/com_virtuemart/tables/vmusers.php COM_VIRTUEMART_VIRTUEMART_USER_ID="VIRTUEMART VIRTUEMART USER ID" # JROOT/administrator/components/com_virtuemart/helpers/vmtable.php COM_VIRTUEMART__PKEY="VIRTUEMART PKEY" # **Fichier inconnu** GANTRY_INITIALIZED_FROM="INITIALIZED FROM"



