TEL: 06.01.35.01.10 E-MAIL: contact@soieries-des-cevennes.com
Français
Votre Panier: 0 Article(s) - 0,00 €
Article(s) récemment ajouté(s)
Total TTC : 0,00 €
PANIER
Services (FR)
  • MON COMPTE
  • Mes Favoris
  • PANIER
  • HISTORIQUE DE MES COMMANDES
 
Selectionnez une catégorie...
 
  • Accueil Accueil
  • FEMME
      • Chemise de nuit - Pyjama
      • Slips - Culottes - Boxers
      • Sous vêtements Manches Longues
      • Sous vêtements Manches Courtes
      • Sous vêtements Sans Manches
      • Lingerie sexy en soie
  • HOMME
      • Pyjamas
      • Boxers - Caleçons
      • Sous vêtements Manches Longues
      • Sous Vêtements Manches Courtes
      • Sous Vêtements sans manches
  • NAISSANCE
      • trio bébé
      • chaussons bébé
      • bonnet bébé
      • moufles bébé
  • ACCESSOIRES
      • masque anti projection
      • SAC
      • Cagoule
      • Echarpes
  • Galerie Photos
  • Contact
  • Connexion
  • qui sommes nous
    • Notre histoire
    • Notre matière
    • Notre travail
  • LES SOIERIES DES CÉVENNES: Atelier de création au service de la soie

PRODUITS EN VEDETTE
/
TOP VENTES
/
NOUVEAUX PRODUITS
  • ROBE SETINA
    349,00 €
    ROBE SETINA
  • caraco IMMORTELLE
    89,00 €
    caraco IMMORTELLE
  • Nuisette AUDACE
    145,00 €
    Nuisette AUDACE
  • Caraco AZALEE
    95,00 €
    Caraco AZALEE
  • Caleçon COLZA
    59,00 €
    Caleçon COLZA
  • Culotte  CARDAMOME
    46,00 €
    Culotte CARDAMOME
  • VENUS MANCHES LONGUES VENUS MANCHES LONGUES
    91,00 €
    VENUS MANCHES LONGUES
  • ALISÉE MANCHES LONGUES
    92,00 €
    ALISÉE MANCHES LONGUES
  • Pimprenelle Pimprenelle
    79,00 €
    Pimprenelle
  • Muscade Manches Longues Muscade Manches Longues
    106,00 €
    Muscade Manches Longues
  • Muscade Sans manches Muscade Sans manches
    94,00 €
    Muscade Sans manches
  • MUSCADE MANCHES COURTES MUSCADE MANCHES COURTES
    100,00 €
    MUSCADE MANCHES COURTES
  • masque  soie anti projection masque  soie anti projection
    10,00 €
    masque soie anti projection
  • trio naissance
    59,00 €
    trio naissance
  • alizé manches courtes alizé manches courtes
    85,00 €
    alizé manches courtes
  • nymphia manches courtes nymphia manches courtes
    85,00 €
    nymphia manches courtes

INFORMATIONS

  • A Propos
  • Livraison et Retour
  • Politique de Confidentialité
  • Conditions Générales de vente
  • Conditions d'entretien
  • Correspondance des Tailles

 

© 2014 SOIERIES DES CEVENNES.
Tous droits réservés.

MON COMPTE

  • MON COMPTE
  • Historique des commandes
  • PANIER
  • MES FAVORIS

CONTACTEZ-NOUS

  • Filature de Grefeuilhe 30170 MONOBLET
  • Téléphone: 06.01.35.01.10 (Sylvie)
  • Email: Cette adresse e-mail est protégée contre les robots spammeurs. Vous devez activer le JavaScript pour la visualiser.
  • Web: www.soieries-des-cevennes
 

NEWSLETTER

Souscrivez à notre Newsletter et recevez des informations concernant nos services, les promotions de notre boutique en ligne et de notre atelier de vêtements de soie situé à Monoblet dans le Gard.

Console de débogage Joomla!

Session

__default

session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)

user

password_clear ⇒
groups ⇒

__vm

vmcart ⇒ O:8:"stdClass":24:{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:20:"_triesValidateCoupon";a:0:{}s:14:"order_language";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";b:1;s:15:"customer_number";s:7:"nonreg_";}

Profil d'information

Application 0.000 seconds (+0.000); 1.23 MB (+1.227) - afterLoad
Application 0.028 seconds (+0.028); 7.27 MB (+6.043) - afterInitialise
Application 0.033 seconds (+0.005); 8.35 MB (+1.082) - afterRoute
Application 0.048 seconds (+0.015); 11.16 MB (+2.808) - afterDispatch
Application 0.051 seconds (+0.003); 11.53 MB (+0.370) - beforeRenderModule mod_custom (Social Icons (Custom HTML))
Application 0.052 seconds (+0.001); 11.60 MB (+0.070) - afterRenderModule mod_custom (Social Icons (Custom HTML))
Application 0.052 seconds (+0.000); 11.60 MB (+0.003) - beforeRenderModule mod_acymailing (AcyMailing Module)
Application 0.060 seconds (+0.008); 12.90 MB (+1.300) - afterRenderModule mod_acymailing (AcyMailing Module)
Application 0.060 seconds (+0.000); 12.86 MB (-0.041) - beforeRenderModule mod_custom (Contact)
Application 0.073 seconds (+0.013); 13.96 MB (+1.094) - afterRenderModule mod_custom (Contact)
Application 0.073 seconds (+0.000); 13.95 MB (-0.001) - beforeRenderModule mod_menu (MON COMPTE)
Application 0.085 seconds (+0.012); 16.17 MB (+2.214) - afterRenderModule mod_menu (MON COMPTE)
Application 0.085 seconds (+0.000); 16.16 MB (-0.006) - beforeRenderModule mod_menu (INFORMATIONS)
Application 0.087 seconds (+0.002); 16.25 MB (+0.090) - afterRenderModule mod_menu (INFORMATIONS)
Application 0.087 seconds (+0.000); 16.24 MB (-0.008) - beforeRenderModule mod_custom (Copyrights Block (Custom html))
Application 0.087 seconds (+0.000); 16.25 MB (+0.005) - afterRenderModule mod_custom (Copyrights Block (Custom html))
Application 0.087 seconds (+0.000); 16.25 MB (-0.001) - beforeRenderModule mod_wft_products_slider (WFT Products Slider)
Application 0.225 seconds (+0.138); 25.18 MB (+8.937) - afterRenderModule mod_wft_products_slider (WFT Products Slider)
Application 0.225 seconds (+0.000); 25.18 MB (-0.009) - beforeRenderModule mod_wft_responsiveslides (WFT Responsive Slides Module)
Application 0.226 seconds (+0.000); 25.19 MB (+0.016) - afterRenderModule mod_wft_responsiveslides (WFT Responsive Slides Module)
Application 0.226 seconds (+0.000); 25.18 MB (-0.013) - beforeRenderModule mod_custom (Services Links Block (Custom html))
Application 0.226 seconds (+0.000); 25.18 MB (+0.005) - afterRenderModule mod_custom (Services Links Block (Custom html))
Application 0.226 seconds (+0.000); 25.18 MB (-0.002) - beforeRenderModule mod_menu (Top Menu (FR) )
Application 0.265 seconds (+0.039); 29.65 MB (+4.471) - afterRenderModule mod_menu (Top Menu (FR) )
Application 0.265 seconds (+0.000); 29.65 MB (-0.004) - beforeRenderModule mod_search (Search)
Application 0.269 seconds (+0.004); 29.68 MB (+0.028) - afterRenderModule mod_search (Search)
Application 0.269 seconds (+0.000); 29.67 MB (-0.007) - beforeRenderModule mod_menu (Services (FR))
Application 0.271 seconds (+0.001); 29.68 MB (+0.017) - afterRenderModule mod_menu (Services (FR))
Application 0.271 seconds (+0.000); 29.68 MB (-0.008) - beforeRenderModule mod_virtuemart_cart (VM - PANIER)
Application 0.424 seconds (+0.153); 40.30 MB (+10.625) - afterRenderModule mod_virtuemart_cart (VM - PANIER)
Application 0.424 seconds (+0.000); 40.30 MB (-0.003) - beforeRenderModule mod_languages (Language Switcher)
Application 0.429 seconds (+0.005); 40.41 MB (+0.113) - afterRenderModule mod_languages (Language Switcher)
Application 0.435 seconds (+0.005); 40.54 MB (+0.130) - afterRender

Occupation de la mémoire

40.57 MB (42,535,496 Bytes)

Requêtes de base de données

456 requêtes exécutées

  1. SELECT `data`
      FROM `d1pvd_session`
      WHERE `session_id` = 'ec5021847bc360e56f69adb5108f5a15'
  2. DELETE
      FROM `d1pvd_session`
      WHERE `time` < '1615131243'
  3. SELECT `session_id`
      FROM `d1pvd_session`
      WHERE `session_id` = 'ec5021847bc360e56f69adb5108f5a15'
      LIMIT 0, 1
  4. INSERT INTO `d1pvd_session` (`session_id`, `client_id`, `time`)
      VALUES ('ec5021847bc360e56f69adb5108f5a15', 0, '1615138443')
  5. SELECT extension_id AS id, element AS "option", params, enabled
      FROM d1pvd_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  6. SELECT b.id
      FROM d1pvd_usergroups AS a
      LEFT JOIN d1pvd_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 1
  7. SELECT id, rules
      FROM `d1pvd_viewlevels`
  8. SELECT folder AS type, element AS name, params
      FROM d1pvd_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  9. SELECT *
      FROM d1pvd_languages
      WHERE published=1
      ORDER BY ordering ASC
  10. SELECT extension_id AS id, element AS "option", params, enabled
      FROM d1pvd_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  11. SELECT language,id
      FROM `d1pvd_menu`
      WHERE home = 1
      AND published = 1
      AND client_id = 0
  12. 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 d1pvd_menu AS m
      LEFT JOIN d1pvd_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.lft
  13. SELECT extension_id AS id, element AS "option", params, enabled
      FROM d1pvd_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  14. SELECT id, home, template, s.params
      FROM d1pvd_template_styles as s
      LEFT JOIN d1pvd_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 = 1
  15. SELECT a.rules
      FROM d1pvd_assets AS a
      WHERE (a.id = 1)
      GROUP BY a.id, a.rules, a.lft
  16. SELECT b.rules
      FROM d1pvd_assets AS a
      LEFT JOIN d1pvd_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE (a.name = 'com_content')
      GROUP BY b.id, b.rules, b.lft
      ORDER BY b.lft
  17. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
      CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
      FROM d1pvd_contact_details AS contact
      WHERE contact.published = 1
      AND contact.user_id = a.created_by
      AND (contact.language in ('fr-FR','*') OR contact.language IS NULL)) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM d1pvd_content AS a
      LEFT JOIN d1pvd_categories AS c
      ON c.id = a.catid
      LEFT JOIN d1pvd_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN d1pvd_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN d1pvd_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN d1pvd_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM d1pvd_categories AS cat JOIN d1pvd_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
      INNER JOIN d1pvd_content_frontpage AS fp
      ON fp.content_id = a.id
      WHERE a.access IN (1,1)
      AND c.access IN (1,1)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-07 17:34:03')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-07 17:34:03')
      AND a.language in ('fr-FR','*')
      ORDER BY c.lft,
      CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created DESC
      LIMIT 0, 9
  18. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
      CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
      FROM d1pvd_contact_details AS contact
      WHERE contact.published = 1
      AND contact.user_id = a.created_by
      AND (contact.language in ('fr-FR','*') OR contact.language IS NULL)) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM d1pvd_content AS a
      LEFT JOIN d1pvd_categories AS c
      ON c.id = a.catid
      LEFT JOIN d1pvd_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN d1pvd_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN d1pvd_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN d1pvd_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM d1pvd_categories AS cat JOIN d1pvd_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
      INNER JOIN d1pvd_content_frontpage AS fp
      ON fp.content_id = a.id
      WHERE a.access IN (1,1)
      AND c.access IN (1,1)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-07 17:34:03')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-07 17:34:03')
      AND a.language in ('fr-FR','*')
      ORDER BY c.lft,
      CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created DESC
  19. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM d1pvd_modules AS m
      LEFT JOIN d1pvd_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN d1pvd_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 <= '2021-03-07 17:34:03')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-03-07 17:34:03')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 171 OR mm.menuid <= 0)
      AND m.language IN ('fr-FR','*')
      ORDER BY m.position, m.ordering
  20. SELECT *
      FROM d1pvd_acymailing_config
  21. SELECT *
      FROM d1pvd_acymailing_list
      WHERE type = 'list'
      ORDER BY ordering ASC
  22. SHOW TABLES LIKE "d1pvd_virtuemart_configs"
  23. SELECT `config`
      FROM `d1pvd_virtuemart_configs`
      WHERE `virtuemart_config_id` = "1";
  24. SHOW FULL COLUMNS
      FROM `d1pvd_assets`
  25. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  26. SELECT b.rules
      FROM d1pvd_assets AS a
      LEFT JOIN d1pvd_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE (a.id = 1)
      GROUP BY b.id, b.rules, b.lft
      ORDER BY b.lft
  27. SELECT extension_id AS id, element AS "option", params, enabled
      FROM d1pvd_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_virtuemart'
  28. SELECT *
      FROM `d1pvd_menu`
      where `link` like "index.php?option=com_virtuemart%"
      and client_id=0
      and published=1
      and (language="*" or language = "fr-FR" )
  29. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  30. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_vmuser_shoppergroups`
      WHERE `virtuemart_user_id` = "0"
  31. SELECT *
      FROM `d1pvd_virtuemart_shoppergroups`
      WHERE `default` = "2"
      AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
      AND `published`="1"
  32. SELECT p.`virtuemart_product_id`
      FROM `d1pvd_virtuemart_products` as p
      LEFT JOIN `d1pvd_virtuemart_product_shoppergroups` as ps
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
      WHERE ( p.`published`="1"
      AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
      AND p.`product_special`="1" )
      group by p.`virtuemart_product_id`
      ORDER BY RAND() ASC
      LIMIT 0, 4
  33. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      WHERE d1pvd_virtuemart_products_fr_fr.`virtuemart_product_id` = "64"
  34. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "64"
      ORDER BY `ordering`
  35. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "64"
  36. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "64"
      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` <= "2021-03-07 17:34:03" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-07 17:34:03" ) )
      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) )
  37. SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
      WHERE d1pvd_virtuemart_manufacturers_fr_fr.`virtuemart_manufacturer_id` = "3"
  38. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 64
  39. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 64
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  40. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =64
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  41. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =64
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  42. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =64
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  43. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =64
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 1
      group by virtuemart_custom_id
      ORDER BY field.`ordering`
  44. SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
      FROM `d1pvd_virtuemart_vendors` AS v
      LEFT JOIN `d1pvd_virtuemart_currencies` AS c
      ON virtuemart_currency_id = vendor_currency
      WHERE v.`virtuemart_vendor_id`="1"
  45. SELECT *
      FROM `d1pvd_virtuemart_currencies`
      WHERE `virtuemart_currency_id`="47"
  46. SELECT `price_display`,`custom_price_display`
      FROM `d1pvd_virtuemart_shoppergroups` AS `sg`
      WHERE `sg`.`default` = "2"
  47. SELECT *
      FROM `d1pvd_virtuemart_shoppergroups`
      WHERE `default` = "2"
      AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
      AND `published`="1"
  48. SELECT *
      FROM d1pvd_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 <= "2021-03-07 17:34:03" )
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-03-07 17:34:03" ) OR `for_override` = "1" )
  49. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =64
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  50. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =64
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  51. SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
      WHERE `product_parent_id` =64
  52. SELECT `product_parent_id`
      FROM `d1pvd_virtuemart_products`
      WHERE `virtuemart_product_id` = 64
  53. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 64
  54. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      WHERE d1pvd_virtuemart_products_fr_fr.`virtuemart_product_id` = "43"
  55. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "43"
      ORDER BY `ordering`
  56. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "43"
  57. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "43"
      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` <= "2021-03-07 17:34:03" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-07 17:34:03" ) )
      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) )
  58. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 43
  59. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 43
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  60. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "43"
      and `virtuemart_category_id`= "12"
  61. SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
      WHERE d1pvd_virtuemart_categories_fr_fr.`virtuemart_category_id` = "12"
  62. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =43
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  63. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =43
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  64. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =43
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  65. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =43
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 1
      group by virtuemart_custom_id
      ORDER BY field.`ordering`
  66. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =43
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  67. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =43
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  68. SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
      WHERE `product_parent_id` =43
  69. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 12
  70. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 7
  71. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 12
  72. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=12
  73. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 43
  74. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      WHERE d1pvd_virtuemart_products_fr_fr.`virtuemart_product_id` = "71"
  75. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "71"
      ORDER BY `ordering`
  76. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "71"
  77. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "71"
      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` <= "2021-03-07 17:34:03" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-07 17:34:03" ) )
      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) )
  78. SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
      WHERE d1pvd_virtuemart_manufacturers_fr_fr.`virtuemart_manufacturer_id` = "3"
  79. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 71
  80. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 71
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  81. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "71"
      and `virtuemart_category_id`= "12"
  82. SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
      WHERE d1pvd_virtuemart_categories_fr_fr.`virtuemart_category_id` = "12"
  83. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =71
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  84. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =71
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  85. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =71
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  86. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =71
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 1
      group by virtuemart_custom_id
      ORDER BY field.`ordering`
  87. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =71
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  88. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =71
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  89. SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
      WHERE `product_parent_id` =71
  90. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 71
  91. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      WHERE d1pvd_virtuemart_products_fr_fr.`virtuemart_product_id` = "41"
  92. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "41"
      ORDER BY `ordering`
  93. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "41"
  94. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "41"
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2021-03-07 17:34:03" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-07 17:34:03" ) )
      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) )
  95. SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
      WHERE d1pvd_virtuemart_manufacturers_fr_fr.`virtuemart_manufacturer_id` = "3"
  96. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 41
  97. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 41
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  98. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "41"
      and `virtuemart_category_id`= "12"
  99. SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
      WHERE d1pvd_virtuemart_categories_fr_fr.`virtuemart_category_id` = "12"
  100. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =41
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  101. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =41
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  102. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =41
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  103. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =41
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 1
      group by virtuemart_custom_id
      ORDER BY field.`ordering`
  104. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =41
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  105. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =41
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  106. SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
      WHERE `product_parent_id` =41
  107. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 41
  108. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "103"
  109. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "66"
  110. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "110"
  111. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "64"
  112. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  113. SELECT p.`virtuemart_product_id`
      FROM `d1pvd_virtuemart_products` as p
      LEFT JOIN `d1pvd_virtuemart_product_shoppergroups` as ps
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_prices` as pp
      ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
      WHERE ( p.`published`="1"
      AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
      AND pp.`product_price`>"0.0" )
      group by p.`virtuemart_product_id`
      ORDER BY p.`product_sales` DESC
      LIMIT 0, 4
  114. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      WHERE d1pvd_virtuemart_products_fr_fr.`virtuemart_product_id` = "56"
  115. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "56"
      ORDER BY `ordering`
  116. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "56"
  117. SELECT *
      FROM `d1pvd_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` <= "2021-03-07 17:34:03" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-07 17:34:03" ) )
      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) )
  118. SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
      WHERE d1pvd_virtuemart_manufacturers_fr_fr.`virtuemart_manufacturer_id` = "3"
  119. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 56
  120. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 56
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  121. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "56"
      and `virtuemart_category_id`= "40"
  122. SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
      WHERE d1pvd_virtuemart_categories_fr_fr.`virtuemart_category_id` = "40"
  123. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =56
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  124. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =56
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  125. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =56
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  126. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =56
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 1
      group by virtuemart_custom_id
      ORDER BY field.`ordering`
  127. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =56
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  128. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =56
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  129. SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
      WHERE `product_parent_id` =56
  130. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 40
  131. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 8
  132. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 40
  133. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=40
  134. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 56
  135. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      WHERE d1pvd_virtuemart_products_fr_fr.`virtuemart_product_id` = "40"
  136. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "40"
      ORDER BY `ordering`
  137. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "40"
  138. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "40"
      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` <= "2021-03-07 17:34:03" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-07 17:34:03" ) )
      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) )
  139. SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
      WHERE d1pvd_virtuemart_manufacturers_fr_fr.`virtuemart_manufacturer_id` = "3"
  140. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 40
  141. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 40
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  142. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "40"
      and `virtuemart_category_id`= "35"
  143. SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
      WHERE d1pvd_virtuemart_categories_fr_fr.`virtuemart_category_id` = "35"
  144. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =40
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  145. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =40
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  146. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =40
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  147. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =40
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 1
      group by virtuemart_custom_id
      ORDER BY field.`ordering`
  148. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =40
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  149. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =40
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  150. SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
      WHERE `product_parent_id` =40
  151. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 35
  152. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 7
  153. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 35
  154. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=35
  155. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 40
  156. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      WHERE d1pvd_virtuemart_products_fr_fr.`virtuemart_product_id` = "27"
  157. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "27"
      ORDER BY `ordering`
  158. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "27"
  159. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "27"
      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` <= "2021-03-07 17:34:03" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-07 17:34:03" ) )
      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) )
  160. SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
      WHERE d1pvd_virtuemart_manufacturers_fr_fr.`virtuemart_manufacturer_id` = "3"
  161. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 27
  162. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 27
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  163. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "27"
      and `virtuemart_category_id`= "31"
  164. SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
      WHERE d1pvd_virtuemart_categories_fr_fr.`virtuemart_category_id` = "31"
  165. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =27
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  166. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =27
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  167. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =27
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  168. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =27
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 1
      group by virtuemart_custom_id
      ORDER BY field.`ordering`
  169. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =27
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  170. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =27
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  171. SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
      WHERE `product_parent_id` =27
  172. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 31
  173. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 7
  174. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 31
  175. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=31
  176. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 27
  177. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      WHERE d1pvd_virtuemart_products_fr_fr.`virtuemart_product_id` = "36"
  178. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "36"
      ORDER BY `ordering`
  179. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "36"
  180. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "36"
      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` <= "2021-03-07 17:34:03" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-07 17:34:03" ) )
      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) )
  181. SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
      WHERE d1pvd_virtuemart_manufacturers_fr_fr.`virtuemart_manufacturer_id` = "3"
  182. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 36
  183. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 36
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  184. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "36"
      and `virtuemart_category_id`= "31"
  185. SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
      WHERE d1pvd_virtuemart_categories_fr_fr.`virtuemart_category_id` = "31"
  186. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =36
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  187. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =36
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  188. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =36
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  189. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =36
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 1
      group by virtuemart_custom_id
      ORDER BY field.`ordering`
  190. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =36
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  191. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =36
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  192. SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
      WHERE `product_parent_id` =36
  193. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 36
  194. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "94"
  195. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "160"
  196. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "28"
  197. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "168"
  198. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "55"
  199. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  200. SELECT p.`virtuemart_product_id`
      FROM `d1pvd_virtuemart_products` as p
      LEFT JOIN `d1pvd_virtuemart_product_shoppergroups` as ps
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
      WHERE ( p.`published`="1"
      AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) )
      group by p.`virtuemart_product_id`
      ORDER BY p.`created_on` DESC
      LIMIT 0, 8
  201. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      WHERE d1pvd_virtuemart_products_fr_fr.`virtuemart_product_id` = "104"
  202. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "104"
      ORDER BY `ordering`
  203. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "104"
  204. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "104"
      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` <= "2021-03-07 17:34:03" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-07 17:34:03" ) )
      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) )
  205. SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
      WHERE d1pvd_virtuemart_manufacturers_fr_fr.`virtuemart_manufacturer_id` = "3"
  206. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 104
  207. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 104
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  208. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "104"
      and `virtuemart_category_id`= "33"
  209. SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
      WHERE d1pvd_virtuemart_categories_fr_fr.`virtuemart_category_id` = "33"
  210. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =104
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  211. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =104
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  212. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =104
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  213. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =104
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 1
      group by virtuemart_custom_id
      ORDER BY field.`ordering`
  214. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =104
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  215. SELECT `virtuemart_category_id`
      FROM d1pvd_virtuemart_calc_categories
      WHERE `virtuemart_calc_id`="5"
  216. SELECT `virtuemart_shoppergroup_id`
      FROM d1pvd_virtuemart_calc_shoppergroups
      WHERE `virtuemart_calc_id`="5"
  217. SELECT `virtuemart_country_id`
      FROM d1pvd_virtuemart_calc_countries
      WHERE `virtuemart_calc_id`="5"
  218. SELECT `virtuemart_state_id`
      FROM d1pvd_virtuemart_calc_states
      WHERE `virtuemart_calc_id`="5"
  219. SELECT `virtuemart_manufacturer_id`
      FROM d1pvd_virtuemart_calc_manufacturers
      WHERE `virtuemart_calc_id`="5"
  220. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =104
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  221. SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
      WHERE `product_parent_id` =104
  222. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 33
  223. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 7
  224. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 33
  225. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=33
  226. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 104
  227. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      WHERE d1pvd_virtuemart_products_fr_fr.`virtuemart_product_id` = "103"
  228. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "103"
      ORDER BY `ordering`
  229. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "103"
  230. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "103"
      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` <= "2021-03-07 17:34:03" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-07 17:34:03" ) )
      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) )
  231. SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
      WHERE d1pvd_virtuemart_manufacturers_fr_fr.`virtuemart_manufacturer_id` = "3"
  232. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 103
  233. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 103
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  234. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "103"
      and `virtuemart_category_id`= "31"
  235. SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
      WHERE d1pvd_virtuemart_categories_fr_fr.`virtuemart_category_id` = "31"
  236. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =103
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  237. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =103
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  238. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =103
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  239. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =103
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 1
      group by virtuemart_custom_id
      ORDER BY field.`ordering`
  240. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =103
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  241. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =103
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  242. SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
      WHERE `product_parent_id` =103
  243. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 103
  244. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      WHERE d1pvd_virtuemart_products_fr_fr.`virtuemart_product_id` = "102"
  245. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "102"
      ORDER BY `ordering`
  246. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "102"
  247. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "102"
      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` <= "2021-03-07 17:34:03" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-07 17:34:03" ) )
      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) )
  248. SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
      WHERE d1pvd_virtuemart_manufacturers_fr_fr.`virtuemart_manufacturer_id` = "3"
  249. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 102
  250. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 102
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  251. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "102"
      and `virtuemart_category_id`= "33"
  252. SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
      WHERE d1pvd_virtuemart_categories_fr_fr.`virtuemart_category_id` = "33"
  253. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =102
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  254. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =102
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  255. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =102
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  256. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =102
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 1
      group by virtuemart_custom_id
      ORDER BY field.`ordering`
  257. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =102
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  258. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =102
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  259. SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
      WHERE `product_parent_id` =102
  260. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 102
  261. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      WHERE d1pvd_virtuemart_products_fr_fr.`virtuemart_product_id` = "101"
  262. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "101"
      ORDER BY `ordering`
  263. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "101"
  264. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "101"
      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` <= "2021-03-07 17:34:03" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-07 17:34:03" ) )
      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) )
  265. SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
      WHERE d1pvd_virtuemart_manufacturers_fr_fr.`virtuemart_manufacturer_id` = "3"
  266. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 101
  267. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 101
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  268. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "101"
      and `virtuemart_category_id`= "32"
  269. SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
      WHERE d1pvd_virtuemart_categories_fr_fr.`virtuemart_category_id` = "32"
  270. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =101
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  271. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =101
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  272. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =101
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  273. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =101
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 1
      group by virtuemart_custom_id
      ORDER BY field.`ordering`
  274. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =101
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  275. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =101
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  276. SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
      WHERE `product_parent_id` =101
  277. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 32
  278. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 7
  279. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 32
  280. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=32
  281. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 101
  282. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      WHERE d1pvd_virtuemart_products_fr_fr.`virtuemart_product_id` = "100"
  283. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "100"
      ORDER BY `ordering`
  284. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "100"
  285. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "100"
      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` <= "2021-03-07 17:34:03" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-07 17:34:03" ) )
      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) )
  286. SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
      WHERE d1pvd_virtuemart_manufacturers_fr_fr.`virtuemart_manufacturer_id` = "3"
  287. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 100
  288. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 100
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  289. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "100"
      and `virtuemart_category_id`= "52"
  290. SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
      WHERE d1pvd_virtuemart_categories_fr_fr.`virtuemart_category_id` = "52"
  291. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =100
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  292. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =100
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  293. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =100
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  294. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =100
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 1
      group by virtuemart_custom_id
      ORDER BY field.`ordering`
  295. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =100
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  296. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =100
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  297. SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
      WHERE `product_parent_id` =100
  298. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 52
  299. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 9
  300. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 52
  301. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=52
  302. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 100
  303. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      WHERE d1pvd_virtuemart_products_fr_fr.`virtuemart_product_id` = "99"
  304. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "99"
      ORDER BY `ordering`
  305. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "99"
  306. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "99"
      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` <= "2021-03-07 17:34:03" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-07 17:34:03" ) )
      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) )
  307. SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
      WHERE d1pvd_virtuemart_manufacturers_fr_fr.`virtuemart_manufacturer_id` = "3"
  308. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 99
  309. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 99
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  310. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "99"
      and `virtuemart_category_id`= "50"
  311. SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
      WHERE d1pvd_virtuemart_categories_fr_fr.`virtuemart_category_id` = "50"
  312. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =99
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  313. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =99
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  314. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =99
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  315. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =99
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 1
      group by virtuemart_custom_id
      ORDER BY field.`ordering`
  316. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =99
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  317. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =99
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  318. SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
      WHERE `product_parent_id` =99
  319. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 50
  320. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 22
  321. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 50
  322. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=50
  323. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 99
  324. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      WHERE d1pvd_virtuemart_products_fr_fr.`virtuemart_product_id` = "98"
  325. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "98"
      ORDER BY `ordering`
  326. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "98"
  327. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "98"
      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` <= "2021-03-07 17:34:03" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-07 17:34:03" ) )
      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) )
  328. SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
      WHERE d1pvd_virtuemart_manufacturers_fr_fr.`virtuemart_manufacturer_id` = "3"
  329. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 98
  330. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 98
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  331. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "98"
      and `virtuemart_category_id`= "32"
  332. SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
      WHERE d1pvd_virtuemart_categories_fr_fr.`virtuemart_category_id` = "32"
  333. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =98
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  334. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =98
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  335. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =98
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  336. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =98
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 1
      group by virtuemart_custom_id
      ORDER BY field.`ordering`
  337. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =98
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  338. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =98
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  339. SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
      WHERE `product_parent_id` =98
  340. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 98
  341. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      WHERE d1pvd_virtuemart_products_fr_fr.`virtuemart_product_id` = "97"
  342. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "97"
      ORDER BY `ordering`
  343. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "97"
  344. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "97"
      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` <= "2021-03-07 17:34:03" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-07 17:34:03" ) )
      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) )
  345. SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
      WHERE d1pvd_virtuemart_manufacturers_fr_fr.`virtuemart_manufacturer_id` = "3"
  346. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 97
  347. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 97
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  348. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "97"
      and `virtuemart_category_id`= "32"
  349. SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
      WHERE d1pvd_virtuemart_categories_fr_fr.`virtuemart_category_id` = "32"
  350. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =97
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  351. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =97
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  352. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =97
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  353. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =97
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 1
      group by virtuemart_custom_id
      ORDER BY field.`ordering`
  354. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =97
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  355. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
      Where `virtuemart_product_id` =97
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  356. SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
      WHERE `product_parent_id` =97
  357. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 97
  358. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "210"
  359. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "211"
  360. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "205"
  361. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "208"
  362. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "204"
  363. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "206"
  364. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "203"
  365. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "209"
  366. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "191"
  367. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "193"
  368. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "189"
  369. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "187"
  370. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "188"
  371. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "185"
  372. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "186"
  373. SELECT `product_parent_id`
      FROM `d1pvd_virtuemart_products`
      WHERE `virtuemart_product_id` = 64
  374. SELECT extension_id AS id, element AS "option", params, enabled
      FROM d1pvd_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_contact'
  375. SHOW FULL COLUMNS
      FROM `d1pvd_easyblog_configs`
  376. SELECT *
      FROM d1pvd_easyblog_configs
      WHERE `name` = 'config'
  377. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  378. SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
      FROM `d1pvd_virtuemart_categories_fr_fr` l JOIN `d1pvd_virtuemart_categories` AS c using (`virtuemart_category_id`)
      LEFT JOIN `d1pvd_virtuemart_category_categories` AS cx
      ON l.`virtuemart_category_id` = cx.`category_child_id`
      WHERE c.`published` = 1
      AND cx.`category_parent_id` = 7
      AND (c.`virtuemart_vendor_id` = "1" OR c.`shared` = "1")
      ORDER BY ordering ASC
      LIMIT 0, 20
  379. SELECT FOUND_ROWS()
  380. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 36
  381. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 35
  382. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 31
  383. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 32
  384. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 33
  385. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 12
  386. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 36
  387. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 7
  388. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 36
  389. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=36
  390. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  391. SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
      FROM `d1pvd_virtuemart_categories_fr_fr` l JOIN `d1pvd_virtuemart_categories` AS c using (`virtuemart_category_id`)
      LEFT JOIN `d1pvd_virtuemart_category_categories` AS cx
      ON l.`virtuemart_category_id` = cx.`category_child_id`
      WHERE c.`published` = 1
      AND cx.`category_parent_id` = 8
      AND (c.`virtuemart_vendor_id` = "1" OR c.`shared` = "1")
      ORDER BY ordering ASC
      LIMIT 0, 20
  392. SELECT FOUND_ROWS()
  393. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 41
  394. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 40
  395. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 39
  396. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 38
  397. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 13
  398. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 41
  399. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 8
  400. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 41
  401. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=41
  402. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 39
  403. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 8
  404. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 39
  405. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=39
  406. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 38
  407. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 8
  408. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 38
  409. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=38
  410. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 13
  411. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 8
  412. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 13
  413. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=13
  414. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  415. SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
      FROM `d1pvd_virtuemart_categories_fr_fr` l JOIN `d1pvd_virtuemart_categories` AS c using (`virtuemart_category_id`)
      LEFT JOIN `d1pvd_virtuemart_category_categories` AS cx
      ON l.`virtuemart_category_id` = cx.`category_child_id`
      WHERE c.`published` = 1
      AND cx.`category_parent_id` = 22
      AND (c.`virtuemart_vendor_id` = "1" OR c.`shared` = "1")
      ORDER BY ordering ASC
      LIMIT 0, 20
  416. SELECT FOUND_ROWS()
  417. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 50
  418. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 49
  419. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 44
  420. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 43
  421. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 49
  422. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 22
  423. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 49
  424. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=49
  425. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 44
  426. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 22
  427. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 44
  428. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=44
  429. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 43
  430. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 22
  431. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 43
  432. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=43
  433. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  434. SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
      FROM `d1pvd_virtuemart_categories_fr_fr` l JOIN `d1pvd_virtuemart_categories` AS c using (`virtuemart_category_id`)
      LEFT JOIN `d1pvd_virtuemart_category_categories` AS cx
      ON l.`virtuemart_category_id` = cx.`category_child_id`
      WHERE c.`published` = 1
      AND cx.`category_parent_id` = 9
      AND (c.`virtuemart_vendor_id` = "1" OR c.`shared` = "1")
      ORDER BY ordering ASC
      LIMIT 0, 20
  435. SELECT FOUND_ROWS()
  436. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 52
  437. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 37
  438. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 16
  439. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 15
  440. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 37
  441. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 9
  442. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 37
  443. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=37
  444. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 16
  445. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 9
  446. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 16
  447. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=16
  448. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 15
  449. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 9
  450. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 15
  451. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=15
  452. SELECT *
      FROM d1pvd_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 <= "2021-03-07 17:34:03" )
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-03-07 17:34:03" )
  453. SELECT *
      FROM d1pvd_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 <= "2021-03-07 17:34:03" )
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-03-07 17:34:03" )
  454. SELECT *
      FROM d1pvd_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 <= "2021-03-07 17:34:03" )
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-03-07 17:34:03" )
  455. SELECT m2.language, m2.id
      FROM d1pvd_menu as m
      INNER JOIN d1pvd_associations as a
      ON a.id=m.id
      AND a.context='com_menus.item'
      INNER JOIN d1pvd_associations as a2
      ON a.key=a2.key
      INNER JOIN d1pvd_menu as m2
      ON a2.id=m2.id
      WHERE m.id=171
  456. UPDATE `d1pvd_session`
      SET `data` = 'LkJnToS1qUPBCd1pR_8a3wbpYBWjPY5BT47HhYZIkCTDm_iZ_9C0BX7TD0EDpc9XuJOuOiisCpAFVcBrhUakWo3v3waszXt_2N92_A29FcAThWzaIhlya4yVASg_viE0W0I1tBTFfYtjhkb__oLKronnR7rfFOGp6cKrTc8tH_C8h-mpPcXwuOsKrA7i0kiiZ2AfajA6X6ofRKVuLLnINtLRQXqNesnKOXoGR0-cjeAnTPudBk__X4j0OkFuJPdZoPeQsOeh6iTu07mNJx7vuwXuIM3sJhEciqFxkH4gjTX6a8Bzvd3iOIc5_LvZhbMNcJFIFwvdu4B8Xh0ClH_wNE9_gWm-oCqWKyUxieUf_JgEBLiyLY9dRJmtG0NcPcys8DM8zoV4CW43U9fhcQ5MrEF5vKwT1-ly_fbtSfLyy540J5n1_8Tbdm3igpwj4QhN0a_J-K2LVB-fPwovA_uKBZhtlTOOVNNA9-JK_qEe304t8R8kqAZ-3C1EMaINlizuQrzdfvE527ERzacDFQOOw612v7KtUoSMhpYcQpPd5Y0fjUe0Dn9HjzeD1dB2x1lcPKoiPGyadt3UwtlIQCBF197dXwlwmgEVsjm7ir6JSHABA0NcJcqwsel-9Y_50b-O_43JfQBUgaqXW_NA8iIz61WvEJYII-3XsuDRqw5cDXTNfXUm-FwEHKh17ehhd4xm0yXLhCNxd3kap4b2RaVMMUnCN5w_kgNGb9H4Vnud51L9Pz2OdAWMnSDtN3xMwtXtxj4n5QvPHbX56ZC87gTpQqTwCUF8aWi08ss6R28fQR53aJm2F3wSteQxcptm_VG0sxTv2DIKUr7g4GFa_zPtbhEqs6P9hwd3i9mAxeGrpEoWJx_bWzAYM5aoef0pgpj2QS03XhqcB_CLyf7WtMpY42-LABQ6frAiiK1_T39sff3B1mBmRwj2yTvTU96GRNCyQG9dqIjQlnMX5hGFtNcBDKZwlZPdLIcSxXyZxiEXFmrXgKBPNrOZc4u9TPZbFOSdQU_DOoIRwEE5cGA1KGxYFBO8PJn8HIHXjq43WxirPBS8Qszu7wy_jWN5hsw4RSQgZ9xUUN9n5WH2g21mxFVKf0eoHH3Pf1yxLLRHlzQXyUxcdkjuRlEWL1Tm5YLHEQlaWZzIDOcOkicEFJnIGOz2pF5x8rDGclPzz1j8wMy5cVVklkHSGCR-SfdsuDHCY09An7oswKIleFYufmzvHDCRRzhg8lNcLG1rYJiLLVO3YDdnUygajXaFHcawxQLtcuhUvw3SYGH1QBmAlmcSEES9F_o7Cq8l_M0a0M3kQtfflduiC4JfAJupFt4PAyFWFDNLhDmfxxBItiHqsUHM0eMaL5BNg-lDNr38y6LNXsNullqj-7V4xV0-J9J5ioiaAFIBLDTS5TCwz2DRRNBL5sreHSfD3713NA6mHUoJ8xO9eISyaAWzdETcVcXELu6UwaVhHBvb5mNNsytKBAG2fvK2dcAPJPE5jTsn_gVJzTDaDPM6a5lopI1WMSIuz8P14o9URqkApRYmRk2QkG5iicX0zQHQPw_K5BYAI_vvkmbf7xGRXrFKdOkR0hjF_9rqZUQiEZ8Ie70Oho9p_APtFZ1sKFVDf22s5xg4iWUpMlEx1fJL9ZFEvzVYDMi_ANJ9OjrqyT_xVacqUiWp1qqPNlgsKgWZwoxOuIsvp9G_FnSFYhr6G371qbC66wfMlujkgXYC8Rdm5bYnAYUDMpx2XXqG8ycxvxh1dL68OTThwZm9c3s57a2V8VPdxtrL-LmU8EYyZIa-mbctui3BFGQKFMyWqO4WvheSPs6crhQkPkOaN2jp60tTgntfIdSOqnxm_AvYo2BrUr5czGKpo2Z7UMuGRDGflXBhPe1cYqBN10AQ5sD2KF6juXpRu80J8juJpGZ3EYWkyAQQH7f5cGjxldAYsgcijN3ZCtjxnIAnxK9yQ5zcX0dJq_9apris-vL5QBxWaTjP4ZmMCULfKyNAdZWVgrrtfIpQ-wfl09c1WPSjG14kAllEU5DbBd80WuGtLKrnPFLzUh3xlXoWuKu_zhcjqEjH9GcC0m-HCdImtlUdK58vmtbS0TV-zN_g_fd80Vb-yclrqlfTgt4qRY6YXNztSg..' , `time` = '1615138444'
      WHERE `session_id` = 'ec5021847bc360e56f69adb5108f5a15'

62 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :
  1. 57 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
  2. 32 × SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  3. 32 × SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  4. 24 × SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
  5. 19 × SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
  6. 19 × SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
  7. 16 × SELECT *
      FROM `d1pvd_virtuemart_product_prices`
  8. 16 × SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
  9. 16 × SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
  10. 16 × SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      LEFT JOIN `d1pvd_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  11. 16 × SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  12. 16 × SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
  13. 16 × SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
  14. 16 × SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`d1pvd_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN d1pvd_virtuemart_products using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_manufacturers`
      on `d1pvd_virtuemart_product_manufacturers`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_customfields`
      on `d1pvd_virtuemart_product_customfields`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`virtuemart_product_id`
  15. 16 × SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
      FROM `d1pvd_virtuemart_customs` AS C
      LEFT JOIN `d1pvd_virtuemart_product_customfields` AS field
      ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  16. 16 × SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
  17. 15 × SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  18. 15 × SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
  19. 15 × SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
  20. 8 × SELECT id
      FROM d1pvd_assets
  21. 5 × SELECT extension_id AS id, element AS "option", params, enabled
      FROM d1pvd_extensions
  22. 4 × SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
      FROM `d1pvd_virtuemart_categories_fr_fr` l JOIN `d1pvd_virtuemart_categories` AS c using (`virtuemart_category_id`)
      LEFT JOIN `d1pvd_virtuemart_category_categories` AS cx
      ON l.`virtuemart_category_id` = cx.`category_child_id`
  23. 4 × SELECT FOUND_ROWS(
  24. 4 × SELECT *
      FROM d1pvd_virtuemart_calcs
  25. 2 × SELECT `product_parent_id`
      FROM `d1pvd_virtuemart_products`
  26. 2 × SELECT *
      FROM `d1pvd_virtuemart_shoppergroups`
  27. 2 × SELECT b.rules
      FROM d1pvd_assets AS a
      LEFT JOIN d1pvd_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  28. 2 × SELECT p.`virtuemart_product_id`
      FROM `d1pvd_virtuemart_products` as p
      LEFT JOIN `d1pvd_virtuemart_product_shoppergroups` as ps
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
  29. 2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
      CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
      FROM d1pvd_contact_details AS contact
  30. 1 × SELECT `virtuemart_shoppergroup_id`
      FROM d1pvd_virtuemart_calc_shoppergroups
  31. 1 × SELECT `virtuemart_category_id`
      FROM d1pvd_virtuemart_calc_categories
  32. 1 × SELECT p.`virtuemart_product_id`
      FROM `d1pvd_virtuemart_products` as p
      LEFT JOIN `d1pvd_virtuemart_product_shoppergroups` as ps
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_prices` as pp
      ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
  33. 1 × SELECT b.id
      FROM d1pvd_usergroups AS a
      LEFT JOIN d1pvd_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  34. 1 × SELECT `virtuemart_country_id`
      FROM d1pvd_virtuemart_calc_countries
  35. 1 × SELECT `virtuemart_manufacturer_id`
      FROM d1pvd_virtuemart_calc_manufacturers
  36. 1 × SELECT `session_id`
      FROM `d1pvd_session`
  37. 1 × SELECT m2.language, m2.id
      FROM d1pvd_menu as m
      INNER JOIN d1pvd_associations as a
      ON a.id=m.id
      AND a.context='com_menus.item'
      INNER JOIN d1pvd_associations as a2
      ON a.key=a2.key
      INNER JOIN d1pvd_menu as m2
      ON a2.id=m2.id
  38. 1 × SELECT *
      FROM `d1pvd_menu`
  39. 1 × SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_vmuser_shoppergroups`
  40. 1 × SELECT id, rules
      FROM `d1pvd_viewlevels
  41. 1 × SELECT *
      FROM d1pvd_easyblog_configs
  42. 1 × SELECT `virtuemart_state_id`
      FROM d1pvd_virtuemart_calc_states
  43. 1 × SELECT folder AS type, element AS name, params
      FROM d1pvd_extensions
  44. 1 × SELECT id, home, template, s.params
      FROM d1pvd_template_styles as s
      LEFT JOIN d1pvd_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  45. 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 d1pvd_menu AS m
      LEFT JOIN d1pvd_extensions AS e
      ON m.component_id = e.extension_id
  46. 1 × SELECT a.rules
      FROM d1pvd_assets AS a
  47. 1 × SELECT `data`
      FROM `d1pvd_session`
  48. 1 × SELECT *
      FROM d1pvd_acymailing_confi
  49. 1 × SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
      FROM `d1pvd_virtuemart_vendors` AS v
      LEFT JOIN `d1pvd_virtuemart_currencies` AS c
      ON virtuemart_currency_id = vendor_currency
  50. 1 × SELECT *
      FROM `d1pvd_virtuemart_currencies`
  51. 1 × SELECT *
      FROM d1pvd_languages
  52. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM d1pvd_modules AS m
      LEFT JOIN d1pvd_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN d1pvd_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  53. 1 × SELECT language,id
      FROM `d1pvd_menu`
  54. 1 × SELECT `config`
      FROM `d1pvd_virtuemart_configs`
  55. 1 × SELECT `price_display`,`custom_price_display`
      FROM `d1pvd_virtuemart_shoppergroups` AS `sg`
  56. 1 × SELECT *
      FROM d1pvd_acymailing_list
Autres tables :
  1. 1 × SHOW FULL COLUMNS
      FROM `d1pvd_easyblog_configs
  2. 1 × UPDATE `d1pvd_session`
      SET `data` = 'LkJnToS1qUPBCd1pR_8a3wbpYBWjPY5BT47HhYZIkCTDm_iZ_9C0BX7TD0EDpc9XuJOuOiisCpAFVcBrhUakWo3v3waszXt_2N92_A29FcAThWzaIhlya4yVASg_viE0W0I1tBTFfYtjhkb__oLKronnR7rfFOGp6cKrTc8tH_C8h-mpPcXwuOsKrA7i0kiiZ2AfajA6X6ofRKVuLLnINtLRQXqNesnKOXoGR0-cjeAnTPudBk__X4j0OkFuJPdZoPeQsOeh6iTu07mNJx7vuwXuIM3sJhEciqFxkH4gjTX6a8Bzvd3iOIc5_LvZhbMNcJFIFwvdu4B8Xh0ClH_wNE9_gWm-oCqWKyUxieUf_JgEBLiyLY9dRJmtG0NcPcys8DM8zoV4CW43U9fhcQ5MrEF5vKwT1-ly_fbtSfLyy540J5n1_8Tbdm3igpwj4QhN0a_J-K2LVB-fPwovA_uKBZhtlTOOVNNA9-JK_qEe304t8R8kqAZ-3C1EMaINlizuQrzdfvE527ERzacDFQOOw612v7KtUoSMhpYcQpPd5Y0fjUe0Dn9HjzeD1dB2x1lcPKoiPGyadt3UwtlIQCBF197dXwlwmgEVsjm7ir6JSHABA0NcJcqwsel-9Y_50b-O_43JfQBUgaqXW_NA8iIz61WvEJYII-3XsuDRqw5cDXTNfXUm-FwEHKh17ehhd4xm0yXLhCNxd3kap4b2RaVMMUnCN5w_kgNGb9H4Vnud51L9Pz2OdAWMnSDtN3xMwtXtxj4n5QvPHbX56ZC87gTpQqTwCUF8aWi08ss6R28fQR53aJm2F3wSteQxcptm_VG0sxTv2DIKUr7g4GFa_zPtbhEqs6P9hwd3i9mAxeGrpEoWJx_bWzAYM5aoef0pgpj2QS03XhqcB_CLyf7WtMpY42-LABQ6frAiiK1_T39sff3B1mBmRwj2yTvTU96GRNCyQG9dqIjQlnMX5hGFtNcBDKZwlZPdLIcSxXyZxiEXFmrXgKBPNrOZc4u9TPZbFOSdQU_DOoIRwEE5cGA1KGxYFBO8PJn8HIHXjq43WxirPBS8Qszu7wy_jWN5hsw4RSQgZ9xUUN9n5WH2g21mxFVKf0eoHH3Pf1yxLLRHlzQXyUxcdkjuRlEWL1Tm5YLHEQlaWZzIDOcOkicEFJnIGOz2pF5x8rDGclPzz1j8wMy5cVVklkHSGCR-SfdsuDHCY09An7oswKIleFYufmzvHDCRRzhg8lNcLG1rYJiLLVO3YDdnUygajXaFHcawxQLtcuhUvw3SYGH1QBmAlmcSEES9F_o7Cq8l_M0a0M3kQtfflduiC4JfAJupFt4PAyFWFDNLhDmfxxBItiHqsUHM0eMaL5BNg-lDNr38y6LNXsNullqj-7V4xV0-J9J5ioiaAFIBLDTS5TCwz2DRRNBL5sreHSfD3713NA6mHUoJ8xO9eISyaAWzdETcVcXELu6UwaVhHBvb5mNNsytKBAG2fvK2dcAPJPE5jTsn_gVJzTDaDPM6a5lopI1WMSIuz8P14o9URqkApRYmRk2QkG5iicX0zQHQPw_K5BYAI_vvkmbf7xGRXrFKdOkR0hjF_9rqZUQiEZ8Ie70Oho9p_APtFZ1sKFVDf22s5xg4iWUpMlEx1fJL9ZFEvzVYDMi_ANJ9OjrqyT_xVacqUiWp1qqPNlgsKgWZwoxOuIsvp9G_FnSFYhr6G371qbC66wfMlujkgXYC8Rdm5bYnAYUDMpx2XXqG8ycxvxh1dL68OTThwZm9c3s57a2V8VPdxtrL-LmU8EYyZIa-mbctui3BFGQKFMyWqO4WvheSPs6crhQkPkOaN2jp60tTgntfIdSOqnxm_AvYo2BrUr5czGKpo2Z7UMuGRDGflXBhPe1cYqBN10AQ5sD2KF6juXpRu80J8juJpGZ3EYWkyAQQH7f5cGjxldAYsgcijN3ZCtjxnIAnxK9yQ5zcX0dJq_9apris-vL5QBxWaTjP4ZmMCULfKyNAdZWVgrrtfIpQ-wfl09c1WPSjG14kAllEU5DbBd80WuGtLKrnPFLzUh3xlXoWuKu_zhcjqEjH9GcC0m-HCdImtlUdK58vmtbS0TV-zN_g_fd80Vb-yclrqlfTgt4qRY6YXNztSg..' , `time` = '1615138444'
  3. 1 × SHOW FULL COLUMNS
      FROM `d1pvd_assets
  4. 1 × SHOW TABLES LIKE "d1pvd_virtuemart_configs
  5. 1 × INSERT INTO `d1pvd_session` (`session_id`, `client_id`, `time`)
      VALUES ('ec5021847bc360e56f69adb5108f5a15', 0, '1615138443'
  6. 1 × DELETE
      FROM `d1pvd_session`