Boutique Essénienne - Sagesse pratique au quotidien


Votre Panier

Votre panier est vide.

Accueil Accessoires Pierres magiques
PDFImprimer

Pierres magiques feed




Trié par:

Améthystes

Note moyenne des clients:
0 stars  Total des votes: 0
25.00 €
Pierre mystique, placée à l’entrée votre salon, dans votre chambre ou dans un lieu à protéger, elle absorbera toutes les influences négatives amenées par les personnes étrangères. 
Détails du produit...

La pierre verte de l'Archange Raphaël (Actinolite)

Note moyenne des clients:
0 stars  Total des votes: 0
10.00 €
Petite Taille - A la particularité de garder la mémoire de tout ce qui est divin. Aucune force sombre ne peut la pénétrer. Elle vous apportera toutes les forces bénéfiques... 
Détails du produit...

Les cristaux

Note moyenne des clients:
0 stars  Total des votes: 0
15.00 €
Fortement activés et consacrés dans des cérémonies par l’Archange de la Terre, Ouriel, ces cristaux vous apporteront un champ vibratoire intense. 
Détails du produit...

5 pierres harmonisées pour la protection de la maison

Note moyenne des clients:
0 stars  Total des votes: 0
39.00 €
Bouclier subtil contre les énergies vengeresses de tous les êtres des mondes subtils agressés par l’inconscience et l’irrespect de l’humanité entière. Mokis, angélite, améthyste et calcite. 
Détails du produit...

Les tourmalines

Note moyenne des clients:
0 stars  Total des votes: 0
25.00 €
Protection contre toutes les énergies sombres et négatives. Les tourmalines noires placent l’espace qui les entoure dans un champ d’invisibilité pour toutes les forcés négatives du monde extérieur. 
Détails du produit...


Produits vus récemment

  • «« Début
  • « Préc
  • 1
  • Suivant »
  • Fin »»
Résultats 1 - 5 de 5

Newsletter gratuite


Recevez des conseils pratiques,
des offres spéciales
et des cadeaux gratuits !

Je m'enregistre






Paiement sécurisé

credit-mutuel

Qui est en ligne

Nous avons 50 invités et 1 membre en ligne

Annonces


Informations

Application afterLoad: 0.000 seconds, 0.24 MB
Application afterInitialise: 0.074 seconds, 4.58 MB
Application afterRoute: 0.113 seconds, 6.42 MB
Application afterDispatch: 0.430 seconds, 12.50 MB
Application afterRender: 0.847 seconds, 13.97 MB

Utilisation de la mémoire

14696668

347 requêtes achevées

  1. DELETE
      FROM jos_session
      WHERE ( time < '1283478210' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = '6a5cc5b96916e67cb90c3186d8e46dae'
  3. UPDATE `jos_session`
      SET `time`='1283480010',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0'
      WHERE session_id='6a5cc5b96916e67cb90c3186d8e46dae'
  4. SELECT *
      FROM jos_components
      WHERE parent = 0
  5. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  6. SELECT name,player_id,ripper_id,postreplace
      FROM jos_avr_tags
  7. SELECT name,player_id,ripper_id,postreplace
      FROM jos_avr_tags
  8. SELECT count(*)
      FROM jos_menu_types
      WHERE `menutype`='magazin'
  9. SELECT `id`,`title`,`published`
      FROM  jos_sections
      WHERE `published`<>-2
  10. SELECT name,id,published,parent,link,home
      FROM `jos_menu`
      WHERE `menutype`='magazin'
      AND `published`<>-2
  11. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='13'
      AND `published`<>-2
  12. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='14'
      AND `published`<>-2
  13. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='15'
      AND `published`<>-2
  14. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='17'
      AND `published`<>-2
  15. SELECT *
      FROM jos_migration_backlinks
      WHERE url LIKE 'Accessoires/Pierres-magiques%' OR sefurl LIKE 'Accessoires/Pierres-magiques%'
  16. SELECT `id`,`link`
      FROM jos_menu 
      WHERE ((`name` LIKE '%Accessoires%')
      AND (`published` > 0))
  17. SELECT oldurl, newurl
      FROM jos_redirection
      WHERE oldurl = 'Accessoires/Pierres-magiques'
      ORDER BY rank ASC
      LIMIT 1
  18. UPDATE jos_redirection
      SET cpt=(cpt+1)
      WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=1&category_id=7&lang=fr&page=shop.browse'
      AND `oldurl` = 'Accessoires/Pierres-magiques'
  19. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  20. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 0)
      ORDER BY menuid DESC
      LIMIT 0, 1
  21. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  22. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
               
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  23. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  24. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  25. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  26. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  27. SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) AS num_rows
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE (`jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id` OR `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_parent_id`)
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=7
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
  28. SELECT category_id, category_name
      FROM jos_vm_category
      WHERE category_id='7'
  29. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='7'
  30. SELECT category_id, category_thumb_image, category_child_id,category_name
      FROM jos_vm_category,jos_vm_category_xref
      WHERE jos_vm_category_xref.category_parent_id='7'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      AND jos_vm_category.vendor_id='1'
      AND jos_vm_category.category_publish='Y'
      ORDER BY jos_vm_category.list_order, jos_vm_category.category_name ASC
  31. SELECT category_id, category_name,category_parent_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='7'
      AND jos_vm_category.category_id='7'
  32. SELECT category_id, category_name,category_parent_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='30'
      AND jos_vm_category.category_id='30'
  33. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=30%'
      AND published=1
  34. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  35. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  36. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=30&lang=fr&page=shop.browse'
  37. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=7%'
      AND published=1
  38. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  39. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=7&lang=fr&page=shop.browse'
  40. SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`jos_vm_category`.`category_id`,
                                    `jos_vm_product`.`product_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`,
                                    `product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE (`jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id` OR `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_parent_id`)
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=7
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`cdate` DESC
      LIMIT 0, 100
  41. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1211%'
      AND published=1
  42. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=7%'
      AND published=1
  43. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  44. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  45. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=7&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=1211'
  46. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1211
  47. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1211'
      AND (start_date<='1283480010' OR start_date=0)
      AND (end_date>='1283470560' OR end_date=0)
      AND product_discount_id=discount_id
  48. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1211
  49. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1283480010' OR start_date=0)
      AND (end_date>='1283470560' OR end_date=0)
      AND product_discount_id=discount_id
  50. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1211'
  51. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  52. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1211
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  53. SELECT country
      FROM jos_vm_user_info
      WHERE user_info_id=''
  54. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1211
  55. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1211
  56. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1211
      AND `file_is_image`=1
      AND `file_published`=1
  57. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1211
  58. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  59. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1211
      AND `file_is_image`=0
      AND `file_published`=1
  60. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1211'
  61. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  62. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='1211'
  63. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1211
  64. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1211
  65. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=970%'
      AND published=1
  66. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=7%'
      AND published=1
  67. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  68. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  69. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=7&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=970'
  70. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=970
  71. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='970'
      AND (start_date<='1283480010' OR start_date=0)
      AND (end_date>='1283470560' OR end_date=0)
      AND product_discount_id=discount_id
  72. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=970
  73. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1283480010' OR start_date=0)
      AND (end_date>='1283470560' OR end_date=0)
      AND product_discount_id=discount_id
  74. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='970'
  75. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=970
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  76. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=970
  77. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=970
  78. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=970
      AND `file_is_image`=1
      AND `file_published`=1
  79. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=970
  80. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  81. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=970
      AND `file_is_image`=0
      AND `file_published`=1
  82. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='970'
  83. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  84. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='970'
  85. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=970
  86. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=971%'
      AND published=1
  87. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=7%'
      AND published=1
  88. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  89. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  90. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=7&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=971'
  91. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=971
  92. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='971'
      AND (start_date<='1283480010' OR start_date=0)
      AND (end_date>='1283470560' OR end_date=0)
      AND product_discount_id=discount_id
  93. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=971
  94. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1283480010' OR start_date=0)
      AND (end_date>='1283470560' OR end_date=0)
      AND product_discount_id=discount_id
  95. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='971'
  96. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=971
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  97. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=971
  98. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=971
  99. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=971
      AND `file_is_image`=1
      AND `file_published`=1
  100. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=971
  101. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  102. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=971
      AND `file_is_image`=0
      AND `file_published`=1
  103. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='971'
  104. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  105. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='971'
  106. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=971
  107. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=971
  108. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=969%'
      AND published=1
  109. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=7%'
      AND published=1
  110. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  111. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  112. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=7&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=969'
  113. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=969
  114. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='969'
      AND (start_date<='1283480010' OR start_date=0)
      AND (end_date>='1283470560' OR end_date=0)
      AND product_discount_id=discount_id
  115. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=969
  116. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1283480010' OR start_date=0)
      AND (end_date>='1283470560' OR end_date=0)
      AND product_discount_id=discount_id
  117. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='969'
  118. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=969
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  119. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=969
  120. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=969
  121. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=969
      AND `file_is_image`=1
      AND `file_published`=1
  122. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=969
  123. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  124. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=969
      AND `file_is_image`=0
      AND `file_published`=1
  125. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='969'
  126. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  127. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='969'
  128. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=969
  129. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=969
  130. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=972%'
      AND published=1
  131. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=7%'
      AND published=1
  132. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  133. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  134. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=7&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=972'
  135. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=972
  136. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='972'
      AND (start_date<='1283480010' OR start_date=0)
      AND (end_date>='1283470560' OR end_date=0)
      AND product_discount_id=discount_id
  137. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=972
  138. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1283480010' OR start_date=0)
      AND (end_date>='1283470560' OR end_date=0)
      AND product_discount_id=discount_id
  139. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='972'
  140. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=972
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  141. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=972
  142. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=972
  143. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=972
      AND `file_is_image`=1
      AND `file_published`=1
  144. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=972
  145. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  146. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=972
      AND `file_is_image`=0
      AND `file_published`=1
  147. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='972'
  148. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  149. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='972'
  150. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=972
  151. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=972
  152. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM jos_vm_product AS p,jos_vm_category AS c,jos_vm_product_category_xref AS cx
      WHERE p.product_id = '303826'
      AND c.category_id = '9'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  153. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=303826
  154. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=303826%'
      AND published=1
  155. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=9%'
      AND published=1
  156. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  157. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  158. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=9&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=303826'
  159. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=9%'
      AND published=1
  160. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  161. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=9&lang=fr&page=shop.browse'
  162. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM jos_vm_product AS p,jos_vm_category AS c,jos_vm_product_category_xref AS cx
      WHERE p.product_id = '303823'
      AND c.category_id = '9'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  163. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=303823
  164. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=303823%'
      AND published=1
  165. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=9%'
      AND published=1
  166. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  167. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  168. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=9&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=303823'
  169. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=9%'
      AND published=1
  170. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  171. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=9&lang=fr&page=shop.browse'
  172. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM jos_vm_product AS p,jos_vm_category AS c,jos_vm_product_category_xref AS cx
      WHERE p.product_id = '300059'
      AND c.category_id = '281'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  173. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=300059
  174. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=300059%'
      AND published=1
  175. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=281%'
      AND published=1
  176. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  177. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  178. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=281&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=300059'
  179. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=281%'
      AND published=1
  180. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  181. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=281&lang=fr&page=shop.browse'
  182. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM jos_vm_product AS p,jos_vm_category AS c,jos_vm_product_category_xref AS cx
      WHERE p.product_id = '304133'
      AND c.category_id = '297'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  183. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=304133
  184. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=304133%'
      AND published=1
  185. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=297%'
      AND published=1
  186. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  187. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  188. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=297&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304133'
  189. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=297%'
      AND published=1
  190. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  191. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=297&lang=fr&page=shop.browse'
  192. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM jos_vm_product AS p,jos_vm_category AS c,jos_vm_product_category_xref AS cx
      WHERE p.product_id = '303848'
      AND c.category_id = '9'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  193. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=303848
  194. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=303848%'
      AND published=1
  195. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=9%'
      AND published=1
  196. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  197. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  198. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=9&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=303848'
  199. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=9%'
      AND published=1
  200. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  201. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=9&lang=fr&page=shop.browse'
  202. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM jos_vm_product AS p,jos_vm_category AS c,jos_vm_product_category_xref AS cx
      WHERE p.product_id = '381'
      AND c.category_id = '9'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  203. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=381
  204. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=381%'
      AND published=1
  205. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=9%'
      AND published=1
  206. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  207. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  208. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=9&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=381'
  209. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=9%'
      AND published=1
  210. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  211. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=9&lang=fr&page=shop.browse'
  212. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM jos_vm_product AS p,jos_vm_category AS c,jos_vm_product_category_xref AS cx
      WHERE p.product_id = '304137'
      AND c.category_id = '9'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  213. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=304137
  214. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=304137%'
      AND published=1
  215. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=9%'
      AND published=1
  216. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  217. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  218. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=9&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304137'
  219. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=9%'
      AND published=1
  220. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  221. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=9&lang=fr&page=shop.browse'
  222. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM jos_vm_product AS p,jos_vm_category AS c,jos_vm_product_category_xref AS cx
      WHERE p.product_id = '303814'
      AND c.category_id = '9'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  223. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=303814
  224. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=303814%'
      AND published=1
  225. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=9%'
      AND published=1
  226. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  227. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  228. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=9&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=303814'
  229. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=9%'
      AND published=1
  230. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  231. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=9&lang=fr&page=shop.browse'
  232. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM jos_vm_product AS p,jos_vm_category AS c,jos_vm_product_category_xref AS cx
      WHERE p.product_id = '1130'
      AND c.category_id = '13'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  233. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1130
  234. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1130%'
      AND published=1
  235. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=13%'
      AND published=1
  236. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  237. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  238. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=13&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=1130'
  239. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=13%'
      AND published=1
  240. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  241. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=13&lang=fr&page=shop.browse'
  242. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM jos_vm_product AS p,jos_vm_category AS c,jos_vm_product_category_xref AS cx
      WHERE p.product_id = '303873'
      AND c.category_id = '9'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  243. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=303873
  244. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=303873%'
      AND published=1
  245. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=9%'
      AND published=1
  246. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  247. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  248. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=9&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=303873'
  249. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=9%'
      AND published=1
  250. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  251. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=9&lang=fr&page=shop.browse'
  252. SELECT DISTINCT product_sku,jos_vm_product.product_id,product_name,product_s_desc,product_thumb_image, product_full_image, product_in_stock, product_url
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE
    (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')

      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id

      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id

      AND jos_vm_category.category_id='7'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  253. SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 1 OR mm.menuid = 0 )
      ORDER BY position, ordering
  254. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=488&id=106&lang=fr&view=article'
  255. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=492&id=13&lang=fr&layout=blog&view=section'
  256. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=212&lang=fr'
  257. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=281&id=15&lang=fr&layout=blog&view=section'
  258. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_contact&Itemid=274&id=1&lang=fr&view=contact'
  259. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&lang=fr&page=shop.search'
  260. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=277&lang=fr&page=shop.parameter_search_form&product_type_id=8'
  261. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  262. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=277&lang=fr&page=shop.parameter_search_form&product_type_id=12'
  263. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  264. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=277&lang=fr&page=shop.parameter_search_form&product_type_id=13'
  265. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  266. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=282&id=61&lang=fr&view=article'
  267. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=283&id=62&lang=fr&view=article'
  268. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=476&id=73&lang=fr&layout=blog&view=category'
  269. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=208&id=57&lang=fr&view=article'
  270. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=491&id=110&lang=fr&view=article'
  271. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=289&id=61&lang=fr&view=article'
  272. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=290&id=62&lang=fr&view=article'
  273. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_contact&Itemid=291&id=1&lang=fr&view=contact'
  274. SELECT category_id, category_description, category_name,category_child_id AS cid, category_parent_id AS pid,list_order, category_publish
                                                   
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category.category_publish='Y'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
  275. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=189%'
      AND published=1
  276. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  277. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=189&lang=fr&page=shop.browse'
  278. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=193%'
      AND published=1
  279. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  280. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=193&lang=fr&page=shop.browse'
  281. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=25%'
      AND published=1
  282. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  283. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=25&lang=fr&page=shop.browse'
  284. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=212%'
      AND published=1
  285. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  286. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=212&lang=fr&page=shop.browse'
  287. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=220%'
      AND published=1
  288. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  289. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=220&lang=fr&page=shop.browse'
  290. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=30%'
      AND published=1
  291. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  292. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=30&lang=fr&page=shop.browse'
  293. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=6%'
      AND published=1
  294. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  295. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=6&lang=fr&page=shop.browse'
  296. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=24%'
      AND published=1
  297. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  298. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=24&lang=fr&page=shop.browse'
  299. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=36%'
      AND published=1
  300. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  301. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=36&lang=fr&page=shop.browse'
  302. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=218%'
      AND published=1
  303. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  304. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=218&lang=fr&page=shop.browse'
  305. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=20%'
      AND published=1
  306. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  307. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=20&lang=fr&page=shop.browse'
  308. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=219%'
      AND published=1
  309. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  310. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=219&lang=fr&page=shop.browse'
  311. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=7%'
      AND published=1
  312. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  313. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=7&lang=fr&page=shop.browse'
  314. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=13%'
      AND published=1
  315. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  316. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=13&lang=fr&page=shop.browse'
  317. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=319%'
      AND published=1
  318. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  319. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=319&lang=fr&page=shop.browse'
  320. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=286%'
      AND published=1
  321. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  322. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=286&lang=fr&page=shop.browse'
  323. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=17%'
      AND published=1
  324. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  325. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=17&lang=fr&page=shop.browse'
  326. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=320%'
      AND published=1
  327. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  328. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=320&lang=fr&page=shop.browse'
  329. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=292&id=68&lang=fr&view=article'
  330. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=293&id=69&lang=fr&view=article'
  331. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=294&id=70&lang=fr&view=article'
  332. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_contact&Itemid=295&id=1&lang=fr&view=contact'
  333. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_user&lang=fr&view=reset'
  334. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_user&lang=fr&view=remind'
  335. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.registration%'
      AND published=1
  336. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&lang=fr&page=shop.registration'
  337. SELECT guest, usertype, client_id
      FROM jos_session
      WHERE client_id = 0
  338. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.search%'
      AND published=1
  339. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&lang=fr&page=shop.search'
  340. SELECT country,zip
      FROM jos_vm_user_info
      WHERE user_info_id=''
  341. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  342. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  343. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=102&lang=fr&page=shop.cart'
  344. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  345. SELECT currency_id, currency_code, currency_name
      FROM `jos_vm_currency`
      WHERE FIND_IN_SET(`currency_code`, 'GBP,CAD,EUR,CHF,USD,')
      ORDER BY `currency_name`
  346. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&category_id=7&lang=fr&page=shop.feed'
  347. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'

4 requêtes legacy achevées

  1. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  2. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

      ORDER BY g1.lft
  3. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  4. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft

Fichiers de langue chargés

Diagnostique des textes non traduits

Aucun

Textes non traduits

Aucun