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
Un grand sac pour les sorties shopping.
Somptueuses broderies rouge-orangé et vertes sur fond jaune.
Le dos du sac est de couleur marron. Il se ferme par un zip.
Anses tréssées se terminant par des pompons de couleurs.
L'intérieur, en coton noir, est muni d'une petite poche zippée
Dimensions : 56 cm x 39 cm
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 ⇒ 326ec2fe8b6d076dc1c54df4cacfd806
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.057 seconds (+0.057); 0.83 MB (+0.633) - afterInitialiseApplication 0.067 seconds (+0.010); 1.21 MB (+0.379) - afterRouteApplication 0.373 seconds (+0.306); 3.27 MB (+2.062) - afterDispatchApplication 0.471 seconds (+0.098); 4.41 MB (+1.146) - beforeRenderModule mod_roknavmenu ()Application 0.553 seconds (+0.082); 4.77 MB (+0.353) - beforeRenderModule mod_login (Se Connecter)Application 0.556 seconds (+0.003); 4.79 MB (+0.024) - afterRenderModule mod_login (Se Connecter)Application 0.556 seconds (+0.000); 4.76 MB (-0.030) - afterRenderModule mod_roknavmenu ()Application 0.559 seconds (+0.002); 4.75 MB (-0.013) - beforeRenderModule mod_custom (Footer Mentions Legales)Application 0.560 seconds (+0.001); 4.75 MB (+0.004) - afterRenderModule mod_custom (Footer Mentions Legales)Application 0.560 seconds (+0.000); 4.75 MB (-0.001) - beforeRenderModule mod_custom (Footer Conditions Générales)Application 0.560 seconds (+0.000); 4.75 MB (+0.003) - afterRenderModule mod_custom (Footer Conditions Générales)Application 0.560 seconds (+0.000); 4.75 MB (-0.001) - beforeRenderModule mod_custom (Footer Copyright)Application 0.560 seconds (+0.000); 4.75 MB (+0.003) - afterRenderModule mod_custom (Footer Copyright)Application 0.560 seconds (+0.000); 4.75 MB (-0.000) - beforeRenderModule mod_articles_categories (Mes soeurs)Application 0.562 seconds (+0.002); 4.79 MB (+0.041) - afterRenderModule mod_articles_categories (Mes soeurs)Application 0.562 seconds (+0.000); 4.79 MB (-0.002) - beforeRenderModule mod_virtuemart_product (Les Vedettes)Application 0.655 seconds (+0.093); 4.99 MB (+0.193) - afterRenderModule mod_virtuemart_product (Les Vedettes)Application 0.655 seconds (+0.000); 4.98 MB (-0.005) - beforeRenderModule mod_virtuemart_product (Au hasard)Application 0.787 seconds (+0.132); 5.26 MB (+0.280) - afterRenderModule mod_virtuemart_product (Au hasard)Application 0.787 seconds (+0.000); 5.26 MB (-0.006) - beforeRenderModule mod_virtuemart_search (Rechercher)Application 0.847 seconds (+0.061); 5.27 MB (+0.014) - afterRenderModule mod_virtuemart_search (Rechercher)Application 0.847 seconds (+0.000); 5.27 MB (-0.003) - beforeRenderModule mod_virtuemart_cart (Panier)Application 0.854 seconds (+0.007); 5.53 MB (+0.266) - afterRenderModule mod_virtuemart_cart (Panier)Application 0.854 seconds (+0.000); 5.53 MB (-0.001) - beforeRenderModule mod_vm_prod_cat_full (Catégories)Application 0.970 seconds (+0.115); 5.78 MB (+0.248) - afterRenderModule mod_vm_prod_cat_full (Catégories)Application 0.970 seconds (+0.000); 5.78 MB (+0.000) - beforeRenderModule mod_breadcrumbs (Fil d'Arianne)Application 0.971 seconds (+0.002); 5.79 MB (+0.015) - afterRenderModule mod_breadcrumbs (Fil d'Arianne)Application 0.971 seconds (+0.000); 5.79 MB (-0.004) - beforeRenderModule mod_virtuemart_product (Nouveautés !)Application 1.080 seconds (+0.108); 6.09 MB (+0.299) - afterRenderModule mod_virtuemart_product (Nouveautés !)Application 1.080 seconds (+0.000); 6.08 MB (-0.006) - beforeRenderModule mod_custom (Bonne nouvelle !)Application 1.080 seconds (+0.000); 6.09 MB (+0.003) - afterRenderModule mod_custom (Bonne nouvelle !)Application 1.080 seconds (+0.000); 6.09 MB (-0.001) - beforeRenderModule mod_custom (Retour de voyage en asie)Application 1.080 seconds (+0.000); 6.09 MB (+0.003) - afterRenderModule mod_custom (Retour de voyage en asie)Application 1.080 seconds (+0.000); 6.09 MB (-0.001) - beforeRenderModule mod_custom (Utilisateur courant)Application 1.080 seconds (+0.000); 6.09 MB (+0.003) - afterRenderModule mod_custom (Utilisateur courant)Application 1.085 seconds (+0.005); 6.15 MB (+0.055) - afterRender6.19 MB (6,495,276 Bytes)SELECT `data`
FROM `jom25_session`
WHERE `session_id` = '8b19e1c4680feb9f4edef2df3cecff68'DELETE
FROM `jom25_session`
WHERE `time` < '1771240105'SELECT `session_id`
FROM `jom25_session`
WHERE `session_id` = '8b19e1c4680feb9f4edef2df3cecff68'
LIMIT 0, 1INSERT INTO `jom25_session`
(`session_id`, `client_id`, `time`)
VALUES
('8b19e1c4680feb9f4edef2df3cecff68', 0, '1771243705')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 'sacs-inspiration'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 "sac-jardin-fleuri"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` = "161"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "161"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "161"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` = "161"
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:08:25" )
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:08:25" ) )
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` = 161SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "161"
and `virtuemart_category_id`= "8"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` = "8"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:08:25" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-02-16 12:08:25" )
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`= 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`=4SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=8SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 161SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "371"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "372"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "373"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "374"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "375"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` = 8
and `slug` < "sac-jardin-fleuri"
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` = 8
and `slug` > "sac-jardin-fleuri"
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` = "8"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "8"
ORDER BY `ordering`SELECT `category_child_id`
FROM `jom25_virtuemart_category_categories`
WHERE `category_parent_id` = 8SELECT 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` = 8
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`= 8SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM `jom25_virtuemart_category_categories` AS `xref`
WHERE `xref`.`category_child_id`= 4SELECT `category_name`,`virtuemart_category_id`
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=4SELECT `category_name`,`virtuemart_category_id`
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=8SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "370"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` = 8
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 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:08:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-02-16 12:08:25')
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-02-16 12:08:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-02-16 12:08:25')
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 'sacs-inspiration'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 "sac-jardin-fleuri"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` = "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:08:25" )
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:08:25" ) )
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 `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`=7SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 166SELECT `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:08:25" )
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:08:25" ) )
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 `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 164SELECT `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 `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 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` = "168"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "168"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "168"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "168"
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:08:25" )
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:08:25" ) )
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` = 168SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "168"
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` = 168SELECT `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` = "94"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "94"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "94"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "94"
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:08:25" )
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:08:25" ) )
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` = 94SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "94"
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:08:25" )
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:08:25" ) )
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` = 94SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "412"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "415"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "413"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "414"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "416"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "169"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "170"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "171"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:08:25" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-02-16 12:08:25" )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:08:25" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-02-16 12:08:25" )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:08:25" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-02-16 12:08:25" )SELECT `category_parent_id`, `ordering`
FROM `jom25_virtuemart_category_categories`
WHERE `category_child_id` = '8'SELECT `category_parent_id`, `ordering`
FROM `jom25_virtuemart_category_categories`
WHERE `category_child_id` = '8'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` = "4"SELECT `category_parent_id`, `ordering`
FROM `jom25_virtuemart_category_categories`
WHERE `category_child_id` = '4'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 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`= 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 `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 `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` = "132"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "132"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "132"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "132"
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:08:25" )
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:08:25" ) )
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` = 132SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "132"
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 `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 132SELECT `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` = "25"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "25"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "25"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "25"
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:08:25" )
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:08:25" ) )
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` = 25SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "25"
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 `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` = "23"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "23"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "23"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "23"
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:08:25" )
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:08:25" ) )
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` = 23SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "23"
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 `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 25SELECT `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` = "128"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "128"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "128"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "128"
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:08:25" )
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:08:25" ) )
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` = 128SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "128"
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` = 128SELECT `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` = "111"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "111"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "111"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "111"
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:08:25" )
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:08:25" ) )
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` = 111SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "111"
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:08:25" )
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:08:25" ) )
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` = 111SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "286"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "287"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "288"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "34"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "270"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "271"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "272"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "273"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "208"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "209"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:1771243705;s:18:\"session.timer.last\";i:1771243705;s:17:\"session.timer.now\";i:1771243705;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\";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:\"326ec2fe8b6d076dc1c54df4cacfd806\";}__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:8;s:23:\"vmlastvisitedproductids\";a:1:{i:0;i:161;}}'
, `time` = '1771243706'
WHERE `session_id` = '8b19e1c4680feb9f4edef2df3cecff68'**39 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`****35 × 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`****23 × SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`****22 × SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`****14 × SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)****12 × SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`****12 × 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`****12 × SELECT *
FROM `jom25_virtuemart_product_prices`****12 × SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc****12 × SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`****12 × SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`****9 × SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`****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 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`****3 × SELECT `category_parent_id`, `ordering`
FROM `jom25_virtuemart_category_categories`****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 `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 *
FROM `jom25_virtuemart_shoppergroups`****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 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 `virtuemart_category_id`
FROM `jom25_virtuemart_categories_fr_fr`****1 × SELECT count(jom25_virtuemart_products.virtuemart_product_id) AS total
FROM `jom25_virtuemart_products`, `jom25_virtuemart_product_categories`****1 × SELECT template
FROM jom25_template_styles****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 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 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 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 `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:1771243705;s:18:\"session.timer.last\";i:1771243705;s:17:\"session.timer.now\";i:1771243705;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\";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:\"326ec2fe8b6d076dc1c54df4cacfd806\";}__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:8;s:23:\"vmlastvisitedproductids\";a:1:{i:0;i:161;}}' , `time` = '1771243706'****1 × SHOW FULL COLUMNS
FROM `jom25_content****1 × SHOW TABLES LIKE "%virtuemart_configs%****1 × INSERT INTO `jom25_session` (`session_id`, `client_id`, `time`)
VALUES ('8b19e1c4680feb9f4edef2df3cecff68', 0, '1771243705'****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"








