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
De minuscules points de croix révélateurs d'un travail minutieux et soigné. Dans des tons foncés allant du vieux rose au marron en passant par le bleu et quelques touches vertes. Un liseré marron en bordure, le portefeuille se ferme par une pièce. L'intérieur du portefeuille est en chanvre noir. Une partie porte cartes et grande poche fermée par un zip, une autre partie avec grande poche divisée en deux et fermée également par un zip. (Ne Convient pas pour un carnet de chèque).
Dimensions : 10,5 cm x 22 cm (Portefeuille fermé).
session.client.forwarded ⇒ 216.73.216.147
session.client.browser ⇒ Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
password_clear ⇒
groups ⇒
session.token ⇒ 886d1ab7afee4a93bd5fc59ea9b5df47
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.001 seconds (+0.001); 0.20 MB (+0.196) - afterLoadApplication 0.045 seconds (+0.043); 0.83 MB (+0.636) - afterInitialiseApplication 0.071 seconds (+0.027); 1.21 MB (+0.381) - afterRouteApplication 0.240 seconds (+0.168); 3.27 MB (+2.062) - afterDispatchApplication 0.292 seconds (+0.053); 4.42 MB (+1.150) - beforeRenderModule mod_roknavmenu ()Application 0.329 seconds (+0.037); 4.78 MB (+0.353) - beforeRenderModule mod_login (Se Connecter)Application 0.335 seconds (+0.006); 4.80 MB (+0.024) - afterRenderModule mod_login (Se Connecter)Application 0.335 seconds (+0.000); 4.77 MB (-0.030) - afterRenderModule mod_roknavmenu ()Application 0.339 seconds (+0.004); 4.77 MB (-0.002) - beforeRenderModule mod_custom (Footer Mentions Legales)Application 0.342 seconds (+0.003); 4.77 MB (+0.004) - afterRenderModule mod_custom (Footer Mentions Legales)Application 0.342 seconds (+0.000); 4.77 MB (-0.001) - beforeRenderModule mod_custom (Footer Conditions Générales)Application 0.342 seconds (+0.000); 4.77 MB (+0.003) - afterRenderModule mod_custom (Footer Conditions Générales)Application 0.343 seconds (+0.000); 4.77 MB (-0.001) - beforeRenderModule mod_custom (Footer Copyright)Application 0.343 seconds (+0.000); 4.78 MB (+0.003) - afterRenderModule mod_custom (Footer Copyright)Application 0.343 seconds (+0.000); 4.78 MB (-0.000) - beforeRenderModule mod_articles_categories (Mes soeurs)Application 0.347 seconds (+0.004); 4.82 MB (+0.043) - afterRenderModule mod_articles_categories (Mes soeurs)Application 0.347 seconds (+0.000); 4.82 MB (-0.002) - beforeRenderModule mod_virtuemart_product (Les Vedettes)Application 0.377 seconds (+0.030); 5.01 MB (+0.192) - afterRenderModule mod_virtuemart_product (Les Vedettes)Application 0.377 seconds (+0.000); 5.00 MB (-0.005) - beforeRenderModule mod_virtuemart_product (Au hasard)Application 0.398 seconds (+0.021); 5.17 MB (+0.171) - afterRenderModule mod_virtuemart_product (Au hasard)Application 0.398 seconds (+0.000); 5.17 MB (-0.006) - beforeRenderModule mod_virtuemart_search (Rechercher)Application 0.404 seconds (+0.006); 5.18 MB (+0.014) - afterRenderModule mod_virtuemart_search (Rechercher)Application 0.404 seconds (+0.000); 5.18 MB (-0.003) - beforeRenderModule mod_virtuemart_cart (Panier)Application 0.413 seconds (+0.009); 5.45 MB (+0.266) - afterRenderModule mod_virtuemart_cart (Panier)Application 0.413 seconds (+0.000); 5.44 MB (-0.001) - beforeRenderModule mod_vm_prod_cat_full (Catégories)Application 0.452 seconds (+0.039); 5.69 MB (+0.248) - afterRenderModule mod_vm_prod_cat_full (Catégories)Application 0.452 seconds (+0.000); 5.69 MB (+0.000) - beforeRenderModule mod_breadcrumbs (Fil d'Arianne)Application 0.454 seconds (+0.002); 5.71 MB (+0.015) - afterRenderModule mod_breadcrumbs (Fil d'Arianne)Application 0.454 seconds (+0.000); 5.70 MB (-0.004) - beforeRenderModule mod_virtuemart_product (Nouveautés !)Application 0.481 seconds (+0.027); 5.97 MB (+0.263) - afterRenderModule mod_virtuemart_product (Nouveautés !)Application 0.481 seconds (+0.000); 5.96 MB (-0.006) - beforeRenderModule mod_custom (Bonne nouvelle !)Application 0.481 seconds (+0.000); 5.96 MB (+0.003) - afterRenderModule mod_custom (Bonne nouvelle !)Application 0.481 seconds (+0.000); 5.96 MB (-0.001) - beforeRenderModule mod_custom (Retour de voyage en asie)Application 0.481 seconds (+0.000); 5.97 MB (+0.003) - afterRenderModule mod_custom (Retour de voyage en asie)Application 0.481 seconds (+0.000); 5.97 MB (-0.001) - beforeRenderModule mod_custom (Utilisateur courant)Application 0.482 seconds (+0.000); 5.97 MB (+0.003) - afterRenderModule mod_custom (Utilisateur courant)Application 0.487 seconds (+0.005); 6.03 MB (+0.056) - afterRender6.07 MB (6,367,948 Bytes)SELECT `data`
FROM `jom25_session`
WHERE `session_id` = '7d46f1b56ff4d44a7bcdb9dfefe0422d'DELETE
FROM `jom25_session`
WHERE `time` < '1776422561'SELECT `session_id`
FROM `jom25_session`
WHERE `session_id` = '7d46f1b56ff4d44a7bcdb9dfefe0422d'
LIMIT 0, 1INSERT INTO `jom25_session`
(`session_id`, `client_id`, `time`)
VALUES
('7d46f1b56ff4d44a7bcdb9dfefe0422d', 0, '1776426161')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.lftSHOW 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 *
FROM jom25_languages
WHERE published=1
ORDER BY ordering ASCSELECT 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 `virtuemart_category_id`
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `slug` LIKE 'portefeuille-soleil'SELECT `p`.`virtuemart_product_id`
FROM `jom25_virtuemart_products_fr_fr` AS `p`
LEFT JOIN `jom25_virtuemart_product_categories` AS `xref`
ON `p`.`virtuemart_product_id` = `xref`.`virtuemart_product_id`
WHERE `p`.`slug` LIKE "portefeuille-soleil-01"SHOW FULL COLUMNS
FROM `jom25_content`SELECT extension_id AS id, element AS "option", params, enabled
FROM jom25_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'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
WHERE s.client_id = 0
AND e.enabled = 1SELECT `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` = "60"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "60"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "60"SELECT `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 *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "60"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-04-17 11:42:42" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-04-17 11:42:42" ) )
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` = 60SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "60"
and `virtuemart_category_id`= "32"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` = "32"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-04-17 11:42:42" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-04-17 11:42:42" )
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`= 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`=9SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=32SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 60SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "102"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "103"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "104"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "105"SELECT `l`.`virtuemart_product_id`, `l`.`product_name`
FROM `jom25_virtuemart_products` as `p`
JOIN `jom25_virtuemart_products_fr_fr` as `l` using (`virtuemart_product_id`)
JOIN `jom25_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_shoppergroups` as `psgr`
on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)
WHERE `virtuemart_category_id` = 32
and `slug` < "portefeuille-soleil-01"
AND ( psgr.`virtuemart_shoppergroup_id`= "1" OR psgr.`virtuemart_shoppergroup_id` IS NULL )
AND p.`published`= 1
ORDER BY `p`.created_on DESC
LIMIT 0,1SELECT `l`.`virtuemart_product_id`, `l`.`product_name`
FROM `jom25_virtuemart_products` as `p`
JOIN `jom25_virtuemart_products_fr_fr` as `l` using (`virtuemart_product_id`)
JOIN `jom25_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_shoppergroups` as `psgr`
on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)
WHERE `virtuemart_category_id` = 32
and `slug` > "portefeuille-soleil-01"
AND ( psgr.`virtuemart_shoppergroup_id`= "1" OR psgr.`virtuemart_shoppergroup_id` IS NULL )
AND p.`published`= 1
ORDER BY `p`.created_on ASC
LIMIT 0,1SELECT `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` = "32"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "32"
ORDER BY `ordering`SELECT `category_child_id`
FROM `jom25_virtuemart_category_categories`
WHERE `category_parent_id` = 32SELECT count(jom25_virtuemart_products.virtuemart_product_id) AS total
FROM `jom25_virtuemart_products`, `jom25_virtuemart_product_categories`
WHERE `jom25_virtuemart_products`.`virtuemart_vendor_id` = "1"
AND `jom25_virtuemart_product_categories`.`virtuemart_category_id` = 32
AND `jom25_virtuemart_products`.`virtuemart_product_id` = `jom25_virtuemart_product_categories`.`virtuemart_product_id`
AND `jom25_virtuemart_products`.`published` = "1"SELECT `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 `category_name`,`virtuemart_category_id`
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=9SELECT `category_name`,`virtuemart_category_id`
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=32SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "338"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_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` = 32
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASCSELECT 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 `jom25_virtuemart_paymentmethods_fr_fr` as l JOIN `jom25_virtuemart_paymentmethods` AS v USING (`virtuemart_paymentmethod_id`)
LEFT JOIN `jom25_extensions` as j
ON j.`extension_id` = v.`payment_jplugin_id`
LEFT
OUTER JOIN `jom25_virtuemart_paymentmethod_shoppergroups` AS s
ON v.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`
WHERE v.`published` = "1"
AND j.`element` = "klarna"
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_paymentmethod_id`
ORDER BY v.`ordering`SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 61SELECT 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-04-17 11:42:42')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-04-17 11:42:42')
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 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 = 101
AND m.template_style_id != 0SELECT template
FROM jom25_template_styles
WHERE home = 1
AND client_id = 0SELECT 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-04-17 11:42:42')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-04-17 11:42:42')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY position, orderingSELECT `virtuemart_category_id`
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `slug` LIKE 'portefeuille-soleil'SELECT `p`.`virtuemart_product_id`
FROM `jom25_virtuemart_products_fr_fr` AS `p`
LEFT JOIN `jom25_virtuemart_product_categories` AS `xref`
ON `p`.`virtuemart_product_id` = `xref`.`virtuemart_product_id`
WHERE `p`.`slug` LIKE "portefeuille-soleil-01"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=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 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-04-17 11:42:42" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-04-17 11:42:42" ) )
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 `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` = "165"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "165"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "165"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "165"
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-04-17 11:42:42" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-04-17 11:42:42" ) )
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` = 165SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "165"
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` = 165SELECT `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` = "396"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "398"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "400"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "401"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` = "139"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "139"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "139"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "139"
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-04-17 11:42:42" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-04-17 11:42:42" ) )
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` = 139SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "139"
and `virtuemart_category_id`= "20"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` = "20"SELECT `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`=5SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=20SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 139SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "307"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "308"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "309"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-04-17 11:42:42" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-04-17 11:42:42" )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-04-17 11:42:42" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-04-17 11:42:42" )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-04-17 11:42:42" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-04-17 11:42:42" )SELECT `category_parent_id`, `ordering`
FROM `jom25_virtuemart_category_categories`
WHERE `category_child_id` = '32'SELECT `category_parent_id`, `ordering`
FROM `jom25_virtuemart_category_categories`
WHERE `category_child_id` = '32'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` = "9"SELECT `category_parent_id`, `ordering`
FROM `jom25_virtuemart_category_categories`
WHERE `category_child_id` = '9'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 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 `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`=21SELECT 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 `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_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 `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`=26SELECT 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 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`= 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` = "120"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "120"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "120"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "120"
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-04-17 11:42:42" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-04-17 11:42:42" ) )
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` = 120SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "120"
and `virtuemart_category_id`= "22"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` = "22"SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 120SELECT `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` = "116"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "116"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "116"SELECT *
FROM `jom25_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-04-17 11:42:42" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-04-17 11:42:42" ) )
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` = 116SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "116"
and `virtuemart_category_id`= "22"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` = "22"SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 116SELECT `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` = "156"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "156"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "156"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "156"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-04-17 11:42:42" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-04-17 11:42:42" ) )
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` = 156SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "156"
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` = 156SELECT `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` = "141"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "141"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "141"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "141"
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-04-17 11:42:42" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-04-17 11:42:42" ) )
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` = 141SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "141"
and `virtuemart_category_id`= "34"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` = "34"SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 141SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "236"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "237"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "238"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "240"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "218"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "219"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "220"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "221"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "349"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "350"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "351"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "316"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "317"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:1776426161;s:18:\"session.timer.last\";i:1776426161;s:17:\"session.timer.now\";i:1776426161;s:24:\"session.client.forwarded\";s:14:\"216.73.216.147\";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\";N;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\";N;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:\"886d1ab7afee4a93bd5fc59ea9b5df47\";}__vm|a:3:{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;}\";s:23:\"vmlastvisitedcategoryid\";i:32;s:23:\"vmlastvisitedproductids\";a:1:{i:0;i:60;}}'
, `time` = '1776426162'
WHERE `session_id` = '7d46f1b56ff4d44a7bcdb9dfefe0422d'**39 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`****32 × SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`****23 × SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_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`****10 × SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)****9 × SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`****8 × SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`****8 × SELECT *
FROM `jom25_virtuemart_product_prices`****8 × SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc****8 × SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`****8 × 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`****8 × SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`****5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM jom25_extensions****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 `category_parent_id`, `ordering`
FROM `jom25_virtuemart_category_categories`****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 `category_name`,`virtuemart_category_id`
FROM `jom25_virtuemart_categories_fr_fr`****2 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM `jom25_virtuemart_category_categories` AS `xref`****2 × SELECT `virtuemart_category_id`
FROM `jom25_virtuemart_categories_fr_fr`****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****2 × SELECT `p`.`virtuemart_product_id`
FROM `jom25_virtuemart_products_fr_fr` AS `p`
LEFT JOIN `jom25_virtuemart_product_categories` AS `xref`
ON `p`.`virtuemart_product_id` = `xref`.`virtuemart_product_id`****2 × SELECT `l`.`virtuemart_product_id`, `l`.`product_name`
FROM `jom25_virtuemart_products` as `p` JOIN `jom25_virtuemart_products_fr_fr` as `l` using (`virtuemart_product_id`) JOIN `jom25_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)
LEFT JOIN `jom25_virtuemart_product_shoppergroups` as `psgr`
on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)****2 × SELECT *
FROM `jom25_virtuemart_shoppergroups`****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 × SELECT template
FROM jom25_template_styles****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 `jom25_virtuemart_paymentmethods_fr_fr` as l JOIN `jom25_virtuemart_paymentmethods` AS v USING (`virtuemart_paymentmethod_id`)
LEFT JOIN `jom25_extensions` as j
ON j.`extension_id` = v.`payment_jplugin_id`
LEFT
OUTER JOIN `jom25_virtuemart_paymentmethod_shoppergroups` AS s
ON v.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`****1 × SELECT `category_child_id`
FROM `jom25_virtuemart_category_categories`****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 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(jom25_virtuemart_products.virtuemart_product_id) AS total
FROM `jom25_virtuemart_products`, `jom25_virtuemart_product_categories`****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 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 `config`
FROM `jom25_virtuemart_configs`****1 × SELECT folder AS type, element AS name, params
FROM jom25_extensions****1 × SELECT id, rules
FROM `jom25_viewlevels****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 `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `jom25_virtuemart_permgroups`****1 × SELECT *
FROM jom25_languages****1 × SELECT `data`
FROM `jom25_session`****1 × SELECT *
FROM `jom25_virtuemart_currencies`****1 × SELECT `virtuemart_userinfo_id`
FROM `jom25_virtuemart_userinfos`****1 × SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_vmuser_shoppergroups`****1 × SELECT *
FROM `jom25_menu`****1 × SELECT `price_display`,`custom_price_display`
FROM `jom25_virtuemart_shoppergroups` AS `sg`****1 × UPDATE `jom25_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1776426161;s:18:\"session.timer.last\";i:1776426161;s:17:\"session.timer.now\";i:1776426161;s:24:\"session.client.forwarded\";s:14:\"216.73.216.147\";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\";N;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\";N;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:\"886d1ab7afee4a93bd5fc59ea9b5df47\";}__vm|a:3:{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;}\";s:23:\"vmlastvisitedcategoryid\";i:32;s:23:\"vmlastvisitedproductids\";a:1:{i:0;i:60;}}' , `time` = '1776426162'****1 × SHOW FULL COLUMNS
FROM `jom25_content****1 × SHOW TABLES LIKE "%virtuemart_configs%****1 × INSERT INTO `jom25_session` (`session_id`, `client_id`, `time`)
VALUES ('7d46f1b56ff4d44a7bcdb9dfefe0422d', 0, '1776426161'****1 × DELETE
FROM `jom25_session`**# 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/ratings.php COM_VIRTUEMART_VIRTUEMART_RATING_ID="VIRTUEMART VIRTUEMART RATING 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"







