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
Le classique.
De magnifiques tissus pour ce porte monnaie classique. D'une taille très pratique, vous ne saurez plus vous en passer.
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 ⇒ 8e055065095804098aec50843e498062
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.20 MB (+0.197) - afterLoadApplication 0.052 seconds (+0.052); 0.85 MB (+0.649) - afterInitialiseApplication 0.065 seconds (+0.013); 1.23 MB (+0.387) - afterRouteApplication 0.179 seconds (+0.114); 2.38 MB (+1.150) - afterDispatchApplication 0.267 seconds (+0.087); 3.53 MB (+1.149) - beforeRenderModule mod_roknavmenu ()Application 0.277 seconds (+0.010); 3.89 MB (+0.362) - beforeRenderModule mod_login (Se Connecter)Application 0.279 seconds (+0.002); 3.92 MB (+0.027) - afterRenderModule mod_login (Se Connecter)Application 0.280 seconds (+0.000); 3.89 MB (-0.030) - afterRenderModule mod_roknavmenu ()Application 0.345 seconds (+0.065); 3.89 MB (-0.002) - beforeRenderModule mod_custom (Footer Mentions Legales)Application 0.346 seconds (+0.001); 3.89 MB (+0.004) - afterRenderModule mod_custom (Footer Mentions Legales)Application 0.346 seconds (+0.000); 3.89 MB (-0.001) - beforeRenderModule mod_custom (Footer Conditions Générales)Application 0.346 seconds (+0.000); 3.89 MB (+0.003) - afterRenderModule mod_custom (Footer Conditions Générales)Application 0.346 seconds (+0.000); 3.89 MB (-0.001) - beforeRenderModule mod_custom (Footer Copyright)Application 0.346 seconds (+0.000); 3.90 MB (+0.003) - afterRenderModule mod_custom (Footer Copyright)Application 0.346 seconds (+0.000); 3.90 MB (-0.000) - beforeRenderModule mod_articles_categories (Mes soeurs)Application 0.348 seconds (+0.002); 3.94 MB (+0.043) - afterRenderModule mod_articles_categories (Mes soeurs)Application 0.348 seconds (+0.000); 3.94 MB (-0.002) - beforeRenderModule mod_virtuemart_product (Les Vedettes)Application 0.365 seconds (+0.017); 4.12 MB (+0.179) - afterRenderModule mod_virtuemart_product (Les Vedettes)Application 0.365 seconds (+0.000); 4.11 MB (-0.005) - beforeRenderModule mod_virtuemart_product (Au hasard)Application 0.389 seconds (+0.024); 4.43 MB (+0.322) - afterRenderModule mod_virtuemart_product (Au hasard)Application 0.389 seconds (+0.000); 4.43 MB (-0.006) - beforeRenderModule mod_virtuemart_search (Rechercher)Application 0.392 seconds (+0.003); 4.44 MB (+0.014) - afterRenderModule mod_virtuemart_search (Rechercher)Application 0.392 seconds (+0.000); 4.44 MB (-0.003) - beforeRenderModule mod_virtuemart_cart (Panier)Application 0.502 seconds (+0.110); 5.72 MB (+1.278) - afterRenderModule mod_virtuemart_cart (Panier)Application 0.502 seconds (+0.000); 5.72 MB (-0.001) - beforeRenderModule mod_vm_prod_cat_full (Catégories)Application 0.563 seconds (+0.061); 5.96 MB (+0.246) - afterRenderModule mod_vm_prod_cat_full (Catégories)Application 0.563 seconds (+0.000); 5.96 MB (+0.000) - beforeRenderModule mod_breadcrumbs (Fil d'Arianne)Application 0.565 seconds (+0.002); 5.98 MB (+0.014) - afterRenderModule mod_breadcrumbs (Fil d'Arianne)Application 0.565 seconds (+0.000); 5.97 MB (-0.003) - beforeRenderModule mod_virtuemart_product (Nouveautés !)Application 0.593 seconds (+0.028); 6.22 MB (+0.248) - afterRenderModule mod_virtuemart_product (Nouveautés !)Application 0.593 seconds (+0.000); 6.21 MB (-0.006) - beforeRenderModule mod_custom (Bonne nouvelle !)Application 0.593 seconds (+0.000); 6.22 MB (+0.003) - afterRenderModule mod_custom (Bonne nouvelle !)Application 0.593 seconds (+0.000); 6.22 MB (-0.001) - beforeRenderModule mod_custom (Retour de voyage en asie)Application 0.593 seconds (+0.000); 6.22 MB (+0.003) - afterRenderModule mod_custom (Retour de voyage en asie)Application 0.593 seconds (+0.000); 6.22 MB (-0.001) - beforeRenderModule mod_custom (Utilisateur courant)Application 0.593 seconds (+0.000); 6.22 MB (+0.003) - afterRenderModule mod_custom (Utilisateur courant)Application 0.598 seconds (+0.004); 6.28 MB (+0.057) - afterRender6.33 MB (6,634,080 Bytes)SELECT `data`
FROM `jom25_session`
WHERE `session_id` = 'a69fe0f54c086d0099c9673882b308bf'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 'porte-monnaie-ethnic-classic2013-05-28-14-06-10'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_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` = "30"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "30"
ORDER BY `ordering`SELECT `category_child_id`
FROM `jom25_virtuemart_category_categories`
WHERE `category_parent_id` = 30SELECT 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` = 30
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`= 30SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM `jom25_virtuemart_category_categories` AS `xref`
WHERE `xref`.`category_child_id`= 6SELECT `category_name`,`virtuemart_category_id`
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=6SELECT `category_name`,`virtuemart_category_id`
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=30SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "108"SELECT `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 `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 `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 SQL_CALC_FOUND_ROWS 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_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_categories_fr_fr` as c
ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_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 `pc`.`virtuemart_category_id` = 30
AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL ) )
group by p.`virtuemart_product_id`
ORDER BY product_s_desc ASC
LIMIT 0, 10SELECT FOUND_ROWS()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` = "55"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "55"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "55"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "55"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-12-11 13:14:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-11 13:14:20" ) )
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` = 55SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "55"
and `virtuemart_category_id`= "30"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` = "30"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` = "53"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "53"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "53"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "53"
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` <= "2025-12-11 13:14:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-11 13:14:20" ) )
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` = 53SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "53"
and `virtuemart_category_id`= "30"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` = "30"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 <= "2025-12-11 13:14:20" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-12-11 13:14:20" )
OR `for_override` = "1" )SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 55SELECT `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` = "54"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "54"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "54"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "54"
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` <= "2025-12-11 13:14:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-11 13:14:20" ) )
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` = 54SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "54"
and `virtuemart_category_id`= "30"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` = "30"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` = "53"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "53"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "53"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "53"
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` <= "2025-12-11 13:14:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-11 13:14:20" ) )
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` = 53SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "53"
and `virtuemart_category_id`= "30"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` = "30"SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 54SELECT `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` = "56"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "56"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "56"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "56"
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` <= "2025-12-11 13:14:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-11 13:14:20" ) )
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` = 56SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "56"
and `virtuemart_category_id`= "30"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` = "30"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` = "53"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "53"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "53"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "53"
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` <= "2025-12-11 13:14:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-11 13:14:20" ) )
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` = 53SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "53"
and `virtuemart_category_id`= "30"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` = "30"SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 56SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "77"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "78"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "75"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 <= '2025-12-11 13:14:20')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-11 13:14:20')
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 <= '2025-12-11 13:14:20')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-11 13:14:20')
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 'porte-monnaie-ethnic-classic2013-05-28-14-06-10'SELECT extension_id AS id, element AS "option", params, enabled
FROM jom25_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'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` <= "2025-12-11 13:14:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-11 13:14:20" ) )
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`=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` <= "2025-12-11 13:14:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-11 13:14:20" ) )
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` = "108"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "108"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "108"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "108"
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` <= "2025-12-11 13:14:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-11 13:14:20" ) )
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` = 108SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "108"
and `virtuemart_category_id`= "25"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` = "25"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` = "42"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "42"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "42"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "42"
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` <= "2025-12-11 13:14:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-11 13:14:20" ) )
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` = 42SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "42"
and `virtuemart_category_id`= "25"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` = "25"SELECT `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 `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 108SELECT `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` = "70"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "70"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "70"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "70"
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` <= "2025-12-11 13:14:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-11 13:14:20" ) )
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` = 70SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "70"
and `virtuemart_category_id`= "33"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` = "33"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` = "66"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "66"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "66"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "66"
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` <= "2025-12-11 13:14:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-11 13:14:20" ) )
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` = 66SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "66"
and `virtuemart_category_id`= "33"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` = "33"SELECT `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`=9SELECT `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_id`=33SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 70SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "202"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "203"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "125"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "126"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "127"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "128"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 <= "2025-12-11 13:14:20" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-12-11 13:14:20" )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 <= "2025-12-11 13:14:20" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-12-11 13:14:20" )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 <= "2025-12-11 13:14:20" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-12-11 13:14:20" )SELECT `category_parent_id`, `ordering`
FROM `jom25_virtuemart_category_categories`
WHERE `category_child_id` = '30'SELECT `category_parent_id`, `ordering`
FROM `jom25_virtuemart_category_categories`
WHERE `category_child_id` = '30'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` = "6"SELECT `category_parent_id`, `ordering`
FROM `jom25_virtuemart_category_categories`
WHERE `category_child_id` = '6'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 `slug` as name
FROM `jom25_virtuemart_categories_fr_fr`
WHERE `virtuemart_category_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 `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 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 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`= 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 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` = "142"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "142"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "142"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "142"
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` <= "2025-12-11 13:14:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-11 13:14:20" ) )
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` = 142SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "142"
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` = 142SELECT `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` = "32"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "32"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "32"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "32"
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` <= "2025-12-11 13:14:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-11 13:14:20" ) )
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` = 32SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "32"
and `virtuemart_category_id`= "23"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` = "23"SELECT `slug`
FROM `jom25_virtuemart_products_fr_fr`
WHERE `virtuemart_product_id` = 32SELECT `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` = "138"SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "138"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "138"SELECT *
FROM `jom25_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "138"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-12-11 13:14:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-11 13:14:20" ) )
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` = 138SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "138"
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` = 138SELECT `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` <= "2025-12-11 13:14:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-11 13:14:20" ) )
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_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "318"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "319"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "32"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "33"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "304"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "305"SELECT `jom25_virtuemart_medias`.*
FROM `jom25_virtuemart_medias`
WHERE jom25_virtuemart_medias.`virtuemart_media_id` = "306"SELECT `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 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:2;s:19:\"session.timer.start\";i:1765458859;s:18:\"session.timer.last\";i:1765458859;s:17:\"session.timer.now\";i:1765458860;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\":1:{s:14:\"com_virtuemart\";O:8:\"stdClass\":2:{s:10:\"categoryc7\";O:8:\"stdClass\":1:{s:5:\"
limit\";s:3:\"int\";}s:11:\"categoryc30\";O:8:\"stdClass\":1:{s:5:\"
limit\";s:3:\"int\";}}}}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:\"8e055065095804098aec50843e498062\";}__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:30;s:19:\"vmlastvisitedmanuid\";i:0;}'
, `time` = '1765458861'
WHERE `session_id` = 'a69fe0f54c086d0099c9673882b308bf'**39 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jom25_virtuemart_category_categories AS `xref`****33 × 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`****18 × SELECT `jom25_virtuemart_categories_fr_fr`.* ,`jom25_virtuemart_categories`.*
FROM `jom25_virtuemart_categories_fr_fr` JOIN jom25_virtuemart_categories using (`virtuemart_category_id`)****16 × 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`****16 × SELECT `virtuemart_media_id`
FROM `jom25_virtuemart_product_medias`****16 × SELECT *
FROM `jom25_virtuemart_product_prices`****16 × SELECT `ordering`,`id`
FROM `jom25_virtuemart_product_categories`****16 × SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_product_shoppergroups`****16 × SELECT pc.`virtuemart_category_id`
FROM `jom25_virtuemart_product_categories` as pc****11 × 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 `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 *
FROM `jom25_virtuemart_shoppergroups`****2 × SELECT `category_name`,`virtuemart_category_id`
FROM `jom25_virtuemart_categories_fr_fr`****2 × SELECT `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 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****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 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 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 *
FROM `jom25_virtuemart_currencies`****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 `price_display`,`custom_price_display`
FROM `jom25_virtuemart_shoppergroups` AS `sg`****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 `virtuemart_userinfo_id`
FROM `jom25_virtuemart_userinfos`****1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `jom25_virtuemart_permgroups`****1 × SELECT *
FROM jom25_languages****1 × SELECT `config`
FROM `jom25_virtuemart_configs`****1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jom25_menu AS m
LEFT JOIN jom25_extensions AS e
ON m.component_id = e.extension_id****1 × SELECT folder AS type, element AS name, params
FROM jom25_extensions****1 × SELECT *
FROM `jom25_menu`****1 × SELECT `category_child_id`
FROM `jom25_virtuemart_category_categories`****1 × SELECT SQL_CALC_FOUND_ROWS 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_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `jom25_virtuemart_categories_fr_fr` as c
ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_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`****1 × SELECT FOUND_ROWS(****1 × SELECT `data`
FROM `jom25_session`****1 × SELECT `virtuemart_shoppergroup_id`
FROM `jom25_virtuemart_vmuser_shoppergroups`****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 × UPDATE `jom25_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1765458859;s:18:\"session.timer.last\";i:1765458859;s:17:\"session.timer.now\";i:1765458860;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\":1:{s:14:\"com_virtuemart\";O:8:\"stdClass\":2:{s:10:\"categoryc7\";O:8:\"stdClass\":1:{s:5:\"
limit\";s:3:\"int\";}s:11:\"categoryc30\";O:8:\"stdClass\":1:{s:5:\"
limit\";s:3:\"int\";}}}}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:\"8e055065095804098aec50843e498062\";}__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:30;s:19:\"vmlastvisitedmanuid\";i:0;}' , `time` = '1765458861'****1 × SHOW FULL COLUMNS
FROM `jom25_content****1 × SHOW TABLES LIKE "%virtuemart_configs%**# 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"



