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
      • Sous vêtements Manches Longues
      • Pyjamas
      • Sous Vêtements Manches Courtes
      • Boxers - Caleçons
      • Sous Vêtements sans manches
  • NAISSANCE
      • chaussons bébé
      • bonnet bébé
      • trio bébé
      • moufles bébé
  • ACCESSOIRES
      • SAC
      • Cagoule
      • masque anti projection
      • Echarpes
  • Galerie Photos
  • Contact
  • Connexion
  • qui sommes nous
    • Notre histoire
    • Notre matière
    • Notre travail

Accessoire en soie

  1. Cagoule

    Cagoule

    En Savoir Plus
  2. Echarpes

    Echarpes

    En Savoir Plus
  3. masque anti projection

    masque anti projection

    En Savoir Plus
  4. SAC

    SAC

    En Savoir Plus
Categories
  1. ACCESSOIRES
  2. duo bébé moufles et bonnet
  3. FEMME
  4. HOMME
  5. Naissance
Tags
  • Caleçon long soie
  • culotte en soie
  • Cagoule en soie
  • Tee-shirt en jersey
  • Encolure ronde
  • chemise jersey
  • jersey
  • pull jersey soie
PRODUITS EN VEDETTE
/
TOP VENTES
/
NOUVEAUX PRODUITS
  • VENUS SANS MANCHES VENUS SANS MANCHES
    79,00 €
    VENUS SANS MANCHES
  • Caraco CAPUCINE
    89,00 €
    Caraco CAPUCINE
  • Caleçon COLZA
    59,00 €
    Caleçon COLZA
  • Nuisette AUDACE
    145,00 €
    Nuisette AUDACE
  • 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
  • NYMPHIA SANS MANCHES NYMPHIA SANS MANCHES
    78,00 €
    NYMPHIA SANS MANCHES
  • 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.228) - afterLoad
Application 0.027 seconds (+0.027); 7.27 MB (+6.043) - afterInitialise
Application 0.032 seconds (+0.005); 8.36 MB (+1.085) - afterRoute
Application 0.082 seconds (+0.049); 18.18 MB (+9.827) - beforeRenderModule mod_virtuemart_category (Categories )
Application 0.086 seconds (+0.004); 18.61 MB (+0.429) - afterRenderModule mod_virtuemart_category (Categories )
Application 0.086 seconds (+0.000); 18.61 MB (-0.005) - beforeRenderModule mod_wfttags (Recherche par mot clé)
Application 0.088 seconds (+0.002); 18.69 MB (+0.080) - afterRenderModule mod_wfttags (Recherche par mot clé)
Application 0.092 seconds (+0.004); 18.81 MB (+0.119) - afterDispatch
Application 0.093 seconds (+0.001); 18.94 MB (+0.136) - beforeRenderModule mod_custom (Social Icons (Custom HTML))
Application 0.094 seconds (+0.001); 18.95 MB (+0.007) - afterRenderModule mod_custom (Social Icons (Custom HTML))
Application 0.094 seconds (+0.000); 18.95 MB (+0.002) - beforeRenderModule mod_acymailing (AcyMailing Module)
Application 0.102 seconds (+0.008); 20.26 MB (+1.310) - afterRenderModule mod_acymailing (AcyMailing Module)
Application 0.102 seconds (+0.000); 20.22 MB (-0.042) - beforeRenderModule mod_custom (Contact)
Application 0.103 seconds (+0.001); 20.26 MB (+0.041) - afterRenderModule mod_custom (Contact)
Application 0.103 seconds (+0.000); 20.26 MB (-0.001) - beforeRenderModule mod_menu (MON COMPTE)
Application 0.107 seconds (+0.003); 20.38 MB (+0.121) - afterRenderModule mod_menu (MON COMPTE)
Application 0.107 seconds (+0.000); 20.38 MB (-0.006) - beforeRenderModule mod_menu (INFORMATIONS)
Application 0.109 seconds (+0.003); 20.49 MB (+0.111) - afterRenderModule mod_menu (INFORMATIONS)
Application 0.109 seconds (+0.000); 20.48 MB (-0.008) - beforeRenderModule mod_custom (Copyrights Block (Custom html))
Application 0.110 seconds (+0.000); 20.48 MB (+0.005) - afterRenderModule mod_custom (Copyrights Block (Custom html))
Application 0.110 seconds (+0.000); 20.48 MB (-0.001) - beforeRenderModule mod_wft_products_slider (WFT Products Slider)
Application 0.223 seconds (+0.113); 25.27 MB (+4.788) - afterRenderModule mod_wft_products_slider (WFT Products Slider)
Application 0.223 seconds (+0.000); 25.26 MB (-0.010) - beforeRenderModule mod_menu (Top Menu (FR) )
Application 0.260 seconds (+0.037); 29.49 MB (+4.231) - afterRenderModule mod_menu (Top Menu (FR) )
Application 0.260 seconds (+0.000); 29.49 MB (-0.004) - beforeRenderModule mod_search (Search)
Application 0.263 seconds (+0.003); 29.51 MB (+0.028) - afterRenderModule mod_search (Search)
Application 0.263 seconds (+0.000); 29.51 MB (-0.007) - beforeRenderModule mod_menu (Services (FR))
Application 0.265 seconds (+0.001); 29.52 MB (+0.017) - afterRenderModule mod_menu (Services (FR))
Application 0.265 seconds (+0.000); 29.52 MB (-0.008) - beforeRenderModule mod_virtuemart_cart (VM - PANIER)
Application 0.411 seconds (+0.146); 40.13 MB (+10.613) - afterRenderModule mod_virtuemart_cart (VM - PANIER)
Application 0.411 seconds (+0.000); 40.13 MB (-0.003) - beforeRenderModule mod_languages (Language Switcher)
Application 0.416 seconds (+0.005); 40.24 MB (+0.111) - afterRenderModule mod_languages (Language Switcher)
Application 0.421 seconds (+0.005); 40.37 MB (+0.133) - afterRender

Occupation de la mémoire

40.4 MB (42,360,816 Bytes)

Requêtes de base de données

459 requêtes exécutées

  1. SELECT `data`
      FROM `d1pvd_session`
      WHERE `session_id` = '1dd60980ecf8855d1d09b7245b4ff796'
  2. DELETE
      FROM `d1pvd_session`
      WHERE `time` < '1611756731'
  3. SELECT `session_id`
      FROM `d1pvd_session`
      WHERE `session_id` = '1dd60980ecf8855d1d09b7245b4ff796'
      LIMIT 0, 1
  4. INSERT INTO `d1pvd_session` (`session_id`, `client_id`, `time`)
      VALUES ('1dd60980ecf8855d1d09b7245b4ff796', 0, '1611763931')
  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_virtuemart'
  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. SHOW TABLES LIKE "d1pvd_virtuemart_configs"
  16. SELECT `config`
      FROM `d1pvd_virtuemart_configs`
      WHERE `virtuemart_config_id` = "1";
  17. SELECT a.rules
      FROM d1pvd_assets AS a
      WHERE (a.id = 1)
      GROUP BY a.id, a.rules, a.lft
  18. SHOW FULL COLUMNS
      FROM `d1pvd_assets`
  19. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  20. 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
  21. 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" )
  22. 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` = "9"
  23. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_category_medias`
      WHERE `virtuemart_category_id` = "9"
      ORDER BY `ordering`
  24. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 9
  25. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  26. 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 category_name ASC
      LIMIT 0, 20
  27. SELECT FOUND_ROWS()
  28. SELECT count(d1pvd_virtuemart_products.virtuemart_product_id) AS total
      FROM `d1pvd_virtuemart_products`, `d1pvd_virtuemart_product_categories`
      WHERE `d1pvd_virtuemart_products`.`virtuemart_vendor_id` = "1"
      AND `d1pvd_virtuemart_product_categories`.`virtuemart_category_id` = 9
      AND `d1pvd_virtuemart_products`.`virtuemart_product_id` = `d1pvd_virtuemart_product_categories`.`virtuemart_product_id`
      AND `d1pvd_virtuemart_products`.`published` = "1"
  29. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_vmuser_shoppergroups`
      WHERE `virtuemart_user_id` = "0"
  30. SELECT *
      FROM `d1pvd_virtuemart_shoppergroups`
      WHERE `default` = "2"
      AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
      AND `published`="1"
  31. SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id`
      FROM `d1pvd_virtuemart_products` as p
      LEFT JOIN `d1pvd_virtuemart_products_fr_fr` as l using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_shoppergroups` as ps
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_categories` as pc
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
      WHERE ( p.`published`="1"
      AND `pc`.`virtuemart_category_id` = 9
      AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) )
      group by p.`virtuemart_product_id`
      ORDER BY product_name ASC
      LIMIT 0, 3
  32. SELECT FOUND_ROWS()
  33. SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id`
      FROM `d1pvd_virtuemart_products` as p
      LEFT JOIN `d1pvd_virtuemart_products_fr_fr` as l using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_shoppergroups` as ps
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_categories` as pc
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
      WHERE ( p.`published`="1"
      AND `pc`.`virtuemart_category_id` = 9
      AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) )
      group by p.`virtuemart_product_id`
      ORDER BY product_name ASC
      LIMIT 0, 3
  34. SELECT DISTINCT l.`mf_name`,l.`virtuemart_manufacturer_id`
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` as l JOIN `d1pvd_virtuemart_product_manufacturers` AS pm using (`virtuemart_manufacturer_id`)
      LEFT JOIN `d1pvd_virtuemart_products` as p
      ON p.`virtuemart_product_id` = pm.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_categories` as c
      ON c.`virtuemart_product_id` = pm.`virtuemart_product_id`
      WHERE p.`published` =1
      AND c.`virtuemart_category_id` =9
      ORDER BY l.`mf_name`
  35. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  36. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "96"
  37. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "95"
  38. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "201"
  39. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "202"
  40. 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-01-27 16:12:11')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-27 16:12:11')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 197 OR mm.menuid <= 0)
      AND m.language IN ('fr-FR','*')
      ORDER BY m.position, m.ordering
  41. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM `d1pvd_virtuemart_category_categories` AS `xref`
      WHERE `xref`.`category_child_id`= 9
  42. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 51
  43. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 51
  44. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=51
  45. SELECT tag_id, tag_name
      FROM d1pvd_wfttags
  46. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 16
  47. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 9
  48. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 16
  49. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=16
  50. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 15
  51. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 9
  52. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 15
  53. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=15
  54. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 52
  55. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 9
  56. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 52
  57. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=52
  58. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 37
  59. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 9
  60. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 37
  61. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=37
  62. SELECT *
      FROM d1pvd_acymailing_config
  63. SELECT *
      FROM d1pvd_acymailing_list
      WHERE type = 'list'
      ORDER BY ordering ASC
  64. SELECT extension_id AS id, element AS "option", params, enabled
      FROM d1pvd_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  65. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  66. 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
  67. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_ratings`.`rating` ,`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_ratings`
      on `d1pvd_virtuemart_ratings`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`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` = "28"
  68. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "28"
      ORDER BY `ordering`
  69. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "28"
  70. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "28"
      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-01-27 16:12:11" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 16:12:11" ) )
      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) )
  71. 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"
  72. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 28
  73. 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` = 28
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  74. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "28"
      and `virtuemart_category_id`= "33"
  75. 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"
  76. 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` =28
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  77. 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` =28
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  78. 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` =28
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  79. 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` =28
      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`
  80. 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"
  81. SELECT *
      FROM `d1pvd_virtuemart_currencies`
      WHERE `virtuemart_currency_id`="47"
  82. SELECT `price_display`,`custom_price_display`
      FROM `d1pvd_virtuemart_shoppergroups` AS `sg`
      WHERE `sg`.`default` = "2"
  83. SELECT *
      FROM `d1pvd_virtuemart_shoppergroups`
      WHERE `default` = "2"
      AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
      AND `published`="1"
  84. 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-01-27 16:12:11" )
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-01-27 16:12:11" ) OR `for_override` = "1" )
  85. 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` =28
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  86. 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` =28
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  87. 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` =28
  88. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 33
  89. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 7
  90. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 33
  91. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=33
  92. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 28
  93. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_ratings`.`rating` ,`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_ratings`
      on `d1pvd_virtuemart_ratings`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`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` = "42"
  94. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "42"
      ORDER BY `ordering`
  95. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "42"
  96. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "42"
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2021-01-27 16:12:11" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 16:12:11" ) )
      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) )
  97. 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"
  98. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 42
  99. 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` = 42
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  100. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "42"
      and `virtuemart_category_id`= "12"
  101. 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"
  102. 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` =42
      and `field_type` != "G"
      and `field_type` != "R"
      and `field_type` != "Z"
      and is_cart_attribute = 0
      order by field.`ordering`,virtuemart_custom_id
  103. 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` =42
      and `field_type` = "Z"
      and is_cart_attribute = 0
      order by ordering
  104. 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` =42
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  105. 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` =42
      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`
  106. 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` =42
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  107. 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` =42
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  108. 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` =42
  109. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 12
  110. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 7
  111. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 12
  112. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=12
  113. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 42
  114. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_ratings`.`rating` ,`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_ratings`
      on `d1pvd_virtuemart_ratings`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`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-01-27 16:12:11" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 16:12:11" ) )
      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_ratings`.`rating` ,`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_ratings`
      on `d1pvd_virtuemart_ratings`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`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"
  136. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "71"
      ORDER BY `ordering`
  137. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "71"
  138. 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-01-27 16:12:11" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 16:12:11" ) )
      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` = 71
  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` = 71
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  142. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "71"
      and `virtuemart_category_id`= "12"
  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` = "12"
  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` =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
  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` =71
      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` =71
      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` =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`
  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` =71
      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` =71
      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` =71
  151. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 71
  152. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "69"
  153. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "169"
  154. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "65"
  155. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "94"
  156. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "110"
  157. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  158. 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
  159. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_ratings`.`rating` ,`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_ratings`
      on `d1pvd_virtuemart_ratings`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`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"
  160. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "40"
      ORDER BY `ordering`
  161. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "40"
  162. 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-01-27 16:12:11" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 16:12:11" ) )
      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) )
  163. 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"
  164. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 40
  165. 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
  166. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "40"
      and `virtuemart_category_id`= "35"
  167. 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"
  168. 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
  169. 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
  170. 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
  171. 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`
  172. 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`
  173. 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`
  174. 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
  175. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 35
  176. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 7
  177. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 35
  178. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=35
  179. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 40
  180. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_ratings`.`rating` ,`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_ratings`
      on `d1pvd_virtuemart_ratings`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`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"
  181. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "27"
      ORDER BY `ordering`
  182. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "27"
  183. 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-01-27 16:12:11" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 16:12:11" ) )
      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) )
  184. 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"
  185. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 27
  186. 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
  187. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "27"
      and `virtuemart_category_id`= "31"
  188. 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"
  189. 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
  190. 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
  191. 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
  192. 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`
  193. 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`
  194. 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`
  195. 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
  196. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 31
  197. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 7
  198. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 31
  199. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=31
  200. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 27
  201. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_ratings`.`rating` ,`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_ratings`
      on `d1pvd_virtuemart_ratings`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`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` = "24"
  202. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "24"
      ORDER BY `ordering`
  203. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "24"
  204. SELECT *
      FROM `d1pvd_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "24"
      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-01-27 16:12:11" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 16:12:11" ) )
      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` = 24
  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` = 24
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  208. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "24"
      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` =24
      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` =24
      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` =24
      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` =24
      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` =24
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  215. 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` =24
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  216. 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` =24
  217. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 24
  218. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "160"
  219. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "28"
  220. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "168"
  221. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "166"
  222. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "25"
  223. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  224. 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
  225. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_ratings`.`rating` ,`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_ratings`
      on `d1pvd_virtuemart_ratings`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`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"
  226. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "104"
      ORDER BY `ordering`
  227. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "104"
  228. 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-01-27 16:12:11" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 16:12:11" ) )
      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) )
  229. 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"
  230. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 104
  231. 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
  232. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "104"
      and `virtuemart_category_id`= "33"
  233. 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"
  234. 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
  235. 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
  236. 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
  237. 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`
  238. 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`
  239. SELECT `virtuemart_category_id`
      FROM d1pvd_virtuemart_calc_categories
      WHERE `virtuemart_calc_id`="5"
  240. SELECT `virtuemart_shoppergroup_id`
      FROM d1pvd_virtuemart_calc_shoppergroups
      WHERE `virtuemart_calc_id`="5"
  241. SELECT `virtuemart_country_id`
      FROM d1pvd_virtuemart_calc_countries
      WHERE `virtuemart_calc_id`="5"
  242. SELECT `virtuemart_state_id`
      FROM d1pvd_virtuemart_calc_states
      WHERE `virtuemart_calc_id`="5"
  243. SELECT `virtuemart_manufacturer_id`
      FROM d1pvd_virtuemart_calc_manufacturers
      WHERE `virtuemart_calc_id`="5"
  244. 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`
  245. 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
  246. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 104
  247. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_ratings`.`rating` ,`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_ratings`
      on `d1pvd_virtuemart_ratings`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`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"
  248. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "103"
      ORDER BY `ordering`
  249. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "103"
  250. 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-01-27 16:12:11" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 16:12:11" ) )
      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) )
  251. 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"
  252. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 103
  253. 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
  254. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "103"
      and `virtuemart_category_id`= "31"
  255. 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"
  256. 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
  257. 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
  258. 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
  259. 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`
  260. 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`
  261. 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`
  262. 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
  263. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 103
  264. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_ratings`.`rating` ,`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_ratings`
      on `d1pvd_virtuemart_ratings`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`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"
  265. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "102"
      ORDER BY `ordering`
  266. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "102"
  267. 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-01-27 16:12:11" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 16:12:11" ) )
      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) )
  268. 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"
  269. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 102
  270. 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
  271. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "102"
      and `virtuemart_category_id`= "33"
  272. 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"
  273. 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
  274. 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
  275. 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
  276. 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`
  277. 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`
  278. 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`
  279. 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
  280. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 102
  281. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_ratings`.`rating` ,`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_ratings`
      on `d1pvd_virtuemart_ratings`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`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"
  282. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "101"
      ORDER BY `ordering`
  283. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "101"
  284. 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-01-27 16:12:11" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 16:12:11" ) )
      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) )
  285. 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"
  286. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 101
  287. 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
  288. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "101"
      and `virtuemart_category_id`= "32"
  289. 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"
  290. 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
  291. 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
  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` =101
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  293. 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`
  294. 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`
  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` =101
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  296. 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
  297. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 32
  298. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 7
  299. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 32
  300. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=32
  301. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 101
  302. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_ratings`.`rating` ,`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_ratings`
      on `d1pvd_virtuemart_ratings`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`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"
  303. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "100"
      ORDER BY `ordering`
  304. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "100"
  305. 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-01-27 16:12:11" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 16:12:11" ) )
      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) )
  306. 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"
  307. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 100
  308. 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
  309. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "100"
      and `virtuemart_category_id`= "52"
  310. 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"
  311. 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
  312. 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
  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` =100
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  314. 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`
  315. 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`
  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` =100
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=22
      ORDER BY field.`ordering`
  317. 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
  318. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 100
  319. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_ratings`.`rating` ,`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_ratings`
      on `d1pvd_virtuemart_ratings`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`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"
  320. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "99"
      ORDER BY `ordering`
  321. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "99"
  322. 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-01-27 16:12:11" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 16:12:11" ) )
      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) )
  323. 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"
  324. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 99
  325. 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
  326. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "99"
      and `virtuemart_category_id`= "50"
  327. 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"
  328. 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
  329. 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
  330. 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
  331. 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`
  332. 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`
  333. 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`
  334. 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
  335. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 50
  336. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 22
  337. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 50
  338. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=50
  339. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 99
  340. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_ratings`.`rating` ,`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_ratings`
      on `d1pvd_virtuemart_ratings`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`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"
  341. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "98"
      ORDER BY `ordering`
  342. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "98"
  343. 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-01-27 16:12:11" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 16:12:11" ) )
      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) )
  344. 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"
  345. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 98
  346. 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
  347. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "98"
      and `virtuemart_category_id`= "32"
  348. 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"
  349. 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
  350. 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
  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` =98
      and `field_type` = "R"
      and is_cart_attribute = 0
      order by ordering
  352. 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`
  353. 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`
  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` =98
      and is_cart_attribute = 1
      and C.`virtuemart_custom_id`=21
      ORDER BY field.`ordering`
  355. 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
  356. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 98
  357. SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_ratings`.`rating` ,`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_ratings`
      on `d1pvd_virtuemart_ratings`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`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"
  358. SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "97"
      ORDER BY `ordering`
  359. SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "97"
  360. 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-01-27 16:12:11" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 16:12:11" ) )
      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) )
  361. 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"
  362. SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 97
  363. 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
  364. SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "97"
      and `virtuemart_category_id`= "32"
  365. 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"
  366. 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
  367. 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
  368. 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
  369. 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`
  370. 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`
  371. 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`
  372. 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
  373. SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
      WHERE `virtuemart_product_id` = 97
  374. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "210"
  375. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "211"
  376. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "205"
  377. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "208"
  378. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "204"
  379. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "206"
  380. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "203"
  381. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "209"
  382. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "191"
  383. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "193"
  384. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "189"
  385. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "187"
  386. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "188"
  387. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "185"
  388. SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
      WHERE d1pvd_virtuemart_medias.`virtuemart_media_id` = "186"
  389. SELECT extension_id AS id, element AS "option", params, enabled
      FROM d1pvd_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_contact'
  390. SHOW FULL COLUMNS
      FROM `d1pvd_easyblog_configs`
  391. SELECT *
      FROM d1pvd_easyblog_configs
      WHERE `name` = 'config'
  392. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  393. 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
  394. SELECT FOUND_ROWS()
  395. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 36
  396. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 35
  397. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 31
  398. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 32
  399. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 33
  400. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 12
  401. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 36
  402. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 7
  403. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 36
  404. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=36
  405. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  406. 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
  407. SELECT FOUND_ROWS()
  408. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 39
  409. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 41
  410. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 38
  411. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 40
  412. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 13
  413. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 39
  414. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 8
  415. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 39
  416. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=39
  417. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 41
  418. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 8
  419. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 41
  420. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=41
  421. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 38
  422. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 8
  423. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 38
  424. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=38
  425. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 13
  426. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 8
  427. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 13
  428. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=13
  429. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  430. 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
  431. SELECT FOUND_ROWS()
  432. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 49
  433. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 44
  434. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 50
  435. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 43
  436. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 49
  437. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 22
  438. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 49
  439. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=49
  440. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 44
  441. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 22
  442. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 44
  443. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=44
  444. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 43
  445. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 22
  446. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
      WHERE `xref`.`category_child_id`= 43
  447. SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
      WHERE `virtuemart_category_id`=43
  448. SELECT id
      FROM d1pvd_assets
      WHERE parent_id = 0
  449. 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
  450. SELECT FOUND_ROWS()
  451. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 37
  452. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 16
  453. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 52
  454. SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
      WHERE `category_parent_id` = 15
  455. 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-01-27 16:12:11" )
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-01-27 16:12:11" )
  456. 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-01-27 16:12:11" )
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-01-27 16:12:11" )
  457. 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-01-27 16:12:11" )
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-01-27 16:12:11" )
  458. 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=197
  459. UPDATE `d1pvd_session`
      SET `data` = 'NwqMBAZtsp0B4iA0VrFzO8NQwgxVa9BsDLiqu-Gx0Ok5e7xJ_ic9BsaMr5kL67gseFDoBFfLuBRBSz6mFINIsr-C115TF3WqAhiakDQFF7InTa1GRA3Jt_EdeSB6OppumhNuqeUY2YbOfI2XS68OCS1D4Uc1r6QfaygW9QXrJQmcMxTTCuJ7eA5-a7fEnNPoNCM7fc2HHXVlQnvxoS2qfTD1h-nOXdtCWtF21mQqEcjjy-Ql-X5uFUjkoKNembQ_OndgHyROMQOtAr3Be3VlxRMQ_hI7VCfnkgrdKZmuQuBvqYGdEF2P_JXo9-i8yJ_RIVOoSX5yimYqqbCGSUKCOsJ6L32w6n0cUPPD6ohOOSeF4Tz1XgkK6gDZnQuDhjtMV1aULDDNMbpaQfMIGisv3DjbuauNOEWFh10y9ayktGnkJgf_Xq2sMmioaij-nhLGixLfRQKVh49R0cFrtAd_FOUWibA3z_YMuy0w-2HqK2vakzT8L4sOfF-rQBs5dd7esVQkZpjiUPf14wLQkgKK524oniyEFchy_XFqukIB991_RT6kElboGYPWjQHH0_2ttS5tZ2n4pJNPPUKOtSm94quOFiPkirPV75MINlhcNrfkJXSgj1bsEcD0pyP2MQ2nqLRbL2_S9ox4UErnSoo_YuFX7A--VNFAx9fCF75n62vGs6fcb0lPFzBgMV0vj8D8aw5oQcFfeJgM-0Xy7C0Q9l5COYK_cm8H80eHAZr0BXc-PEJTCFXZJY158J4gOXK8GbECPMZPhanOInl4NlHPBEqaOa2URnLdj79S87kWEiXYqJs1OmOa4us8P9pDlJSOSfA0gHbolV4EFtUAh0Ao88cYGDJAhS759NKLQ0QiS3K2yUS6keuQfkzce7F-FKVDZbGl2lecvxT-x06dZWlMk54K9ss_Rud1FoHKMBDpxUHd0pcCnaHVtBJrxS4hyEPI-dCPMecnHOgrNk48QECRi3_hI5XvXqVgXiHI_VoiQQe5-3D8cPHzWJZXp049ky7hFo-l64w6lXhnI9dq5xvbYsQtYXvxquF7iermri5rcVoccPv1ZbLlI352Qq7KJT8CckhHNJEvca1jhuv2GxDeccOS5L8CVT6CrQOE2GZNedWdq0GAAc8b5C4Bys6HnC72UEurTEw2OYgA0tnnjTJh-6jgk_sG3qRKYS9EmobTzRGkJI1tdDD6nm1DuqHv0WnpQ8kM6HSw7kkAP8te5Zg3AS_jTjK31sf4mcPPAdeKvJaBla6DTaPeZCEtmSLkqZSXJKeERb6aqA_7FVHaFLge4Mg3CZ26Or3Oil884qD39xa_S0Cy6k8OrRsCWmZeBSinV9SPRlEkHYtBvNPn-YPSshPndkp7dDCyT0S3C7N84lt38PH9RvgPiD6htCvpmRUvi3YvwzIwkxx-4qcYTZYDvUMtn6OK04wrnQyWPjC-0WViVNPLbeKgRN0xMFDPAnyou_Tp7hJF9Vg8REJDWuJsSSfHoNoqnqP9NKG14QoevUkhhZHcuHRCzhEzrMKSy-ByPj1f_i9Lf-QR9lpEhSX3W8P6XLZAeNL0jY3OYFPb1OCGnmxH9PHcpKHy30MbD55LBYLvrfs13kSyuh-EJ7G-tZ1ggVbb_y4zpAfXPGIj1yrDCYmYJlyBau9ZxHbOe_IpgOaNQowFyY2MvkSsSd6SPKb61IqEWmNNFhtMQqEtUJriugsMppwWC0ndTDDw0p2p6HQrB8WEbari8InzM2VE7SoaJrKosBrXX8XVc5sC9hvvsAUkvq0gGwmqPDz6Q7ObpjLMTQrrjvT8K82wyaFA4lgmS167P_MmK6BSi2Fopbt14GDpiVzT1LAgOyJTFKJTP47rHu8hN8J4mKpQQ8WIEyjogi0x9oLPkjhZoiCsnftniLLuuDZZYhchradwKSFUPu3hsGm5LmImQPOzN3y7sR3QmBhaEHvEJpx0IDV9EtQuLJJ67DuXBK8Bg9gyBCO5vS2m5tA0pn9B2gC-CktW1Xq6qCZo-bAUV7kAYj7HVPEriklS2O4nJYnhDt_zXMpjrFkXH6mWhuKzJ5j-Hx51CYcGjand9AsRLRsyJn7FqZc2l08azgprY-LPefkaVwDkkxTZdqxa0FVXgBAYY_as0wC68K1d-gKK93VbsQWciatRAOP1esyJJwpItV_D11SlwTP_iVy0fdyX5NyH_lkGekctQ1Ud2-LsF5CLkUh0yHg.' , `time` = '1611763931'
      WHERE `session_id` = '1dd60980ecf8855d1d09b7245b4ff796'

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

Tables sélectionnées :
  1. 59 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM d1pvd_virtuemart_category_categories AS `xref`
  2. 30 × 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. 30 × 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. 29 × SELECT `d1pvd_virtuemart_medias`.*
      FROM `d1pvd_virtuemart_medias`
  5. 20 × SELECT `category_child_id`
      FROM `d1pvd_virtuemart_category_categories`
  6. 20 × SELECT `slug` as name
      FROM `d1pvd_virtuemart_categories_fr_fr`
  7. 16 × SELECT `d1pvd_virtuemart_categories_fr_fr`.* ,`d1pvd_virtuemart_categories`.*
      FROM `d1pvd_virtuemart_categories_fr_fr` JOIN d1pvd_virtuemart_categories using (`virtuemart_category_id`)
  8. 15 × SELECT `ordering`,`id`
      FROM `d1pvd_virtuemart_product_categories`
  9. 15 × SELECT `d1pvd_virtuemart_manufacturers_fr_fr`.* ,`d1pvd_virtuemart_manufacturers`.*
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` JOIN d1pvd_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  10. 15 × SELECT `slug`
      FROM `d1pvd_virtuemart_products_fr_fr`
  11. 15 × SELECT virtuemart_product_id, product_name
      FROM `d1pvd_virtuemart_products_fr_fr` JOIN `d1pvd_virtuemart_products` as C using (`virtuemart_product_id`)
  12. 15 × SELECT pc.`virtuemart_category_id`
      FROM `d1pvd_virtuemart_product_categories` as pc
  13. 15 × 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`
  14. 15 × 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`
  15. 15 × 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`
  16. 15 × SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_product_shoppergroups`
  17. 15 × SELECT *
      FROM `d1pvd_virtuemart_product_prices`
  18. 15 × SELECT `d1pvd_virtuemart_products_fr_fr`.* ,`d1pvd_virtuemart_products`.* ,`d1pvd_virtuemart_ratings`.`rating` ,`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_ratings`
      on `d1pvd_virtuemart_ratings`.`virtuemart_product_id`=`d1pvd_virtuemart_products_fr_fr`.`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`
  19. 15 × SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_product_medias`
  20. 10 × SELECT id
      FROM d1pvd_assets
  21. 6 × SELECT FOUND_ROWS(
  22. 5 × SELECT extension_id AS id, element AS "option", params, enabled
      FROM d1pvd_extensions
  23. 5 × 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`
  24. 4 × SELECT *
      FROM d1pvd_virtuemart_calcs
  25. 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`
  26. 2 × SELECT *
      FROM `d1pvd_virtuemart_shoppergroups`
  27. 2 × SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id`
      FROM `d1pvd_virtuemart_products` as p
      LEFT JOIN `d1pvd_virtuemart_products_fr_fr` as l using (`virtuemart_product_id`)
      LEFT JOIN `d1pvd_virtuemart_product_shoppergroups` as ps
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_categories` as pc
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
  28. 1 × SELECT `virtuemart_state_id`
      FROM d1pvd_virtuemart_calc_states
  29. 1 × SELECT `virtuemart_country_id`
      FROM d1pvd_virtuemart_calc_countries
  30. 1 × SELECT `virtuemart_manufacturer_id`
      FROM d1pvd_virtuemart_calc_manufacturers
  31. 1 × SELECT `virtuemart_shoppergroup_id`
      FROM d1pvd_virtuemart_calc_shoppergroups
  32. 1 × SELECT *
      FROM d1pvd_easyblog_configs
  33. 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
  34. 1 × SELECT `virtuemart_category_id`
      FROM d1pvd_virtuemart_calc_categories
  35. 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
  36. 1 × SELECT `price_display`,`custom_price_display`
      FROM `d1pvd_virtuemart_shoppergroups` AS `sg`
  37. 1 × SELECT `session_id`
      FROM `d1pvd_session`
  38. 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`
  39. 1 × SELECT *
      FROM `d1pvd_virtuemart_currencies`
  40. 1 × SELECT *
      FROM d1pvd_acymailing_list
  41. 1 × SELECT b.rules
      FROM d1pvd_assets AS a
      LEFT JOIN d1pvd_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  42. 1 × SELECT *
      FROM `d1pvd_menu`
  43. 1 × SELECT `virtuemart_media_id`
      FROM `d1pvd_virtuemart_category_medias`
  44. 1 × SELECT folder AS type, element AS name, params
      FROM d1pvd_extensions
  45. 1 × SELECT a.rules
      FROM d1pvd_assets AS a
  46. 1 × SELECT `config`
      FROM `d1pvd_virtuemart_configs`
  47. 1 × SELECT language,id
      FROM `d1pvd_menu`
  48. 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
  49. 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
  50. 1 × SELECT count(d1pvd_virtuemart_products.virtuemart_product_id) AS total
      FROM `d1pvd_virtuemart_products`, `d1pvd_virtuemart_product_categories`
  51. 1 × SELECT `virtuemart_shoppergroup_id`
      FROM `d1pvd_virtuemart_vmuser_shoppergroups`
  52. 1 × SELECT `data`
      FROM `d1pvd_session`
  53. 1 × SELECT tag_id, tag_name
      FROM d1pvd_wfttag
  54. 1 × SELECT *
      FROM d1pvd_acymailing_confi
  55. 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
  56. 1 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
      FROM `d1pvd_virtuemart_category_categories` AS `xref`
  57. 1 × SELECT DISTINCT l.`mf_name`,l.`virtuemart_manufacturer_id`
      FROM `d1pvd_virtuemart_manufacturers_fr_fr` as l JOIN `d1pvd_virtuemart_product_manufacturers` AS pm using (`virtuemart_manufacturer_id`)
      LEFT JOIN `d1pvd_virtuemart_products` as p
      ON p.`virtuemart_product_id` = pm.`virtuemart_product_id`
      LEFT JOIN `d1pvd_virtuemart_product_categories` as c
      ON c.`virtuemart_product_id` = pm.`virtuemart_product_id`
  58. 1 × SELECT id, rules
      FROM `d1pvd_viewlevels
  59. 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
  60. 1 × SELECT *
      FROM d1pvd_languages
Autres tables :
  1. 1 × SHOW FULL COLUMNS
      FROM `d1pvd_easyblog_configs
  2. 1 × UPDATE `d1pvd_session`
      SET `data` = 'NwqMBAZtsp0B4iA0VrFzO8NQwgxVa9BsDLiqu-Gx0Ok5e7xJ_ic9BsaMr5kL67gseFDoBFfLuBRBSz6mFINIsr-C115TF3WqAhiakDQFF7InTa1GRA3Jt_EdeSB6OppumhNuqeUY2YbOfI2XS68OCS1D4Uc1r6QfaygW9QXrJQmcMxTTCuJ7eA5-a7fEnNPoNCM7fc2HHXVlQnvxoS2qfTD1h-nOXdtCWtF21mQqEcjjy-Ql-X5uFUjkoKNembQ_OndgHyROMQOtAr3Be3VlxRMQ_hI7VCfnkgrdKZmuQuBvqYGdEF2P_JXo9-i8yJ_RIVOoSX5yimYqqbCGSUKCOsJ6L32w6n0cUPPD6ohOOSeF4Tz1XgkK6gDZnQuDhjtMV1aULDDNMbpaQfMIGisv3DjbuauNOEWFh10y9ayktGnkJgf_Xq2sMmioaij-nhLGixLfRQKVh49R0cFrtAd_FOUWibA3z_YMuy0w-2HqK2vakzT8L4sOfF-rQBs5dd7esVQkZpjiUPf14wLQkgKK524oniyEFchy_XFqukIB991_RT6kElboGYPWjQHH0_2ttS5tZ2n4pJNPPUKOtSm94quOFiPkirPV75MINlhcNrfkJXSgj1bsEcD0pyP2MQ2nqLRbL2_S9ox4UErnSoo_YuFX7A--VNFAx9fCF75n62vGs6fcb0lPFzBgMV0vj8D8aw5oQcFfeJgM-0Xy7C0Q9l5COYK_cm8H80eHAZr0BXc-PEJTCFXZJY158J4gOXK8GbECPMZPhanOInl4NlHPBEqaOa2URnLdj79S87kWEiXYqJs1OmOa4us8P9pDlJSOSfA0gHbolV4EFtUAh0Ao88cYGDJAhS759NKLQ0QiS3K2yUS6keuQfkzce7F-FKVDZbGl2lecvxT-x06dZWlMk54K9ss_Rud1FoHKMBDpxUHd0pcCnaHVtBJrxS4hyEPI-dCPMecnHOgrNk48QECRi3_hI5XvXqVgXiHI_VoiQQe5-3D8cPHzWJZXp049ky7hFo-l64w6lXhnI9dq5xvbYsQtYXvxquF7iermri5rcVoccPv1ZbLlI352Qq7KJT8CckhHNJEvca1jhuv2GxDeccOS5L8CVT6CrQOE2GZNedWdq0GAAc8b5C4Bys6HnC72UEurTEw2OYgA0tnnjTJh-6jgk_sG3qRKYS9EmobTzRGkJI1tdDD6nm1DuqHv0WnpQ8kM6HSw7kkAP8te5Zg3AS_jTjK31sf4mcPPAdeKvJaBla6DTaPeZCEtmSLkqZSXJKeERb6aqA_7FVHaFLge4Mg3CZ26Or3Oil884qD39xa_S0Cy6k8OrRsCWmZeBSinV9SPRlEkHYtBvNPn-YPSshPndkp7dDCyT0S3C7N84lt38PH9RvgPiD6htCvpmRUvi3YvwzIwkxx-4qcYTZYDvUMtn6OK04wrnQyWPjC-0WViVNPLbeKgRN0xMFDPAnyou_Tp7hJF9Vg8REJDWuJsSSfHoNoqnqP9NKG14QoevUkhhZHcuHRCzhEzrMKSy-ByPj1f_i9Lf-QR9lpEhSX3W8P6XLZAeNL0jY3OYFPb1OCGnmxH9PHcpKHy30MbD55LBYLvrfs13kSyuh-EJ7G-tZ1ggVbb_y4zpAfXPGIj1yrDCYmYJlyBau9ZxHbOe_IpgOaNQowFyY2MvkSsSd6SPKb61IqEWmNNFhtMQqEtUJriugsMppwWC0ndTDDw0p2p6HQrB8WEbari8InzM2VE7SoaJrKosBrXX8XVc5sC9hvvsAUkvq0gGwmqPDz6Q7ObpjLMTQrrjvT8K82wyaFA4lgmS167P_MmK6BSi2Fopbt14GDpiVzT1LAgOyJTFKJTP47rHu8hN8J4mKpQQ8WIEyjogi0x9oLPkjhZoiCsnftniLLuuDZZYhchradwKSFUPu3hsGm5LmImQPOzN3y7sR3QmBhaEHvEJpx0IDV9EtQuLJJ67DuXBK8Bg9gyBCO5vS2m5tA0pn9B2gC-CktW1Xq6qCZo-bAUV7kAYj7HVPEriklS2O4nJYnhDt_zXMpjrFkXH6mWhuKzJ5j-Hx51CYcGjand9AsRLRsyJn7FqZc2l08azgprY-LPefkaVwDkkxTZdqxa0FVXgBAYY_as0wC68K1d-gKK93VbsQWciatRAOP1esyJJwpItV_D11SlwTP_iVy0fdyX5NyH_lkGekctQ1Ud2-LsF5CLkUh0yHg.' , `time` = '1611763931'
  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 ('1dd60980ecf8855d1d09b7245b4ff796', 0, '1611763931'
  6. 1 × DELETE
      FROM `d1pvd_session`