ESSENTIEL : La Boutique

Informations

Application afterLoad: 0.000 seconds, 0.23 MB

Application afterInitialise: 0.064 seconds, 5.12 MB

Application afterRoute: 0.094 seconds, 6.97 MB

Application afterDispatch: 0.560 seconds, 13.21 MB

Application afterRender: 0.966 seconds, 14.76 MB

Utilisation de la mémoire

15522352

557 requêtes achevées

DELETE
FROM jos_session
WHERE ( time < '1337337196' )
SELECT *
FROM jos_session
WHERE session_id = '5ee0c48e242a9c746a753215b17193ee'
UPDATE `jos_session`
SET `time`='1337367196',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0'
WHERE session_id='5ee0c48e242a9c746a753215b17193ee'
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
  FROM jos_plugins
  WHERE published >= 1
  AND access <= 0
  ORDER BY ordering
SELECT name,player_id,ripper_id,postreplace
FROM jos_avr_tags
SELECT name,player_id,ripper_id,postreplace
FROM jos_avr_tags
SELECT count(*)
FROM jos_menu_types
WHERE `menutype`='magazin'
SELECT `id`,`title`,`published`
FROM jos_sections
WHERE `published`<>-2
SELECT name,id,published,parent,link,home
  FROM `jos_menu`
  WHERE `menutype`='magazin'
  AND `published`<>-2
SELECT id,title,section
  FROM `jos_categories`
  WHERE `section`='13'
  AND `published`<>-2
SELECT id,title,section
  FROM `jos_categories`
  WHERE `section`='14'
  AND `published`<>-2
SELECT id,title,section
  FROM `jos_categories`
  WHERE `section`='15'
  AND `published`<>-2
SELECT id,title,section
  FROM `jos_categories`
  WHERE `section`='17'
  AND `published`<>-2
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'Magazine-ESSENTIEL/ESSENTIEL-La-Boutique%' OR sefurl LIKE 'Magazine-ESSENTIEL/ESSENTIEL-La-Boutique%'
SELECT `id`,`link`
  FROM jos_menu
  WHERE ((`name` LIKE '%Magazine ESSENTIEL%')
  AND (`published` > 0))
SELECT oldurl, newurl
  FROM jos_redirection
  WHERE oldurl = 'Magazine-ESSENTIEL/ESSENTIEL-La-Boutique'
  ORDER BY rank ASC
  LIMIT 1
UPDATE jos_redirection
  SET cpt=(cpt+1)
  WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&lang=fr&limit=100&limitstart=0&page=shop.browse'
  AND `oldurl` = 'Magazine-ESSENTIEL/ESSENTIEL-La-Boutique'
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
SELECT template
  FROM jos_templates_menu
  WHERE client_id = 0
  AND (menuid = 0 OR menuid = 0)
  ORDER BY menuid DESC
  LIMIT 0, 1
SELECT group_id,group_name,group_level
FROM `jos_vm_auth_group`
ORDER BY group_level
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'
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`);
SELECT module_perms
FROM jos_vm_module
WHERE module_name='shop'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND published=1
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`=328

  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'
SELECT category_id, category_name
FROM jos_vm_category
WHERE category_id='328'
SELECT category_id, category_description
FROM jos_vm_category
WHERE category_id='328'
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='328'
  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
SELECT category_id, category_name,category_parent_id
  FROM jos_vm_category, jos_vm_category_xref
  WHERE jos_vm_category_xref.category_child_id='328'
  AND jos_vm_category.category_id='328'
SELECT category_id, category_name,category_parent_id
  FROM jos_vm_category, jos_vm_category_xref
  WHERE jos_vm_category_xref.category_child_id='327'
  AND jos_vm_category.category_id='327'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=327%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
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
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=327&lang=fr&page=shop.browse'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&lang=fr&page=shop.browse'
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`=328

  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
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=304928%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304928'
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=304928
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='304928'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304928
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='0'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT vendor_id
FROM jos_vm_product
WHERE product_id='304928'
SELECT shopper_group_id,shopper_group_discount
  FROM jos_vm_shopper_group
  WHERE vendor_id='1'
  AND `default`='1'
SELECT `product_price`, `product_price_id`, `product_currency`
  FROM `jos_vm_product_price`
  WHERE product_id=304928
  AND shopper_group_id=5
  ORDER BY price_quantity_start
SELECT country
FROM jos_vm_user_info
WHERE user_info_id=''
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304928
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304928
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304928
  AND `file_is_image`=1
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304928
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=1
  AND `file_published`=1
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304928
  AND `file_is_image`=0
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id='304928'
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=0
  AND `file_published`=1
SELECT votes, allvotes, rating
FROM jos_vm_product_votes
WHERE product_id='304928'
SELECT `product_id`
FROM `jos_vm_product_attribute_sku`
WHERE `product_id`=304928
SELECT `attribute`,`custom_attribute`
FROM `jos_vm_product`
WHERE `product_id`=304928
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=304927%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304927'
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=304927
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='304927'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304927
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='0'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT vendor_id
FROM jos_vm_product
WHERE product_id='304927'
SELECT `product_price`, `product_price_id`, `product_currency`
  FROM `jos_vm_product_price`
  WHERE product_id=304927
  AND shopper_group_id=5
  ORDER BY price_quantity_start
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304927
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304927
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304927
  AND `file_is_image`=1
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304927
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=1
  AND `file_published`=1
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304927
  AND `file_is_image`=0
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id='304927'
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=0
  AND `file_published`=1
SELECT votes, allvotes, rating
FROM jos_vm_product_votes
WHERE product_id='304927'
SELECT `product_id`
FROM `jos_vm_product_attribute_sku`
WHERE `product_id`=304927
SELECT `attribute`,`custom_attribute`
FROM `jos_vm_product`
WHERE `product_id`=304927
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=304926%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304926'
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=304926
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='304926'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304926
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='0'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT vendor_id
FROM jos_vm_product
WHERE product_id='304926'
SELECT `product_price`, `product_price_id`, `product_currency`
  FROM `jos_vm_product_price`
  WHERE product_id=304926
  AND shopper_group_id=5
  ORDER BY price_quantity_start
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304926
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304926
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304926
  AND `file_is_image`=1
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304926
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=1
  AND `file_published`=1
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304926
  AND `file_is_image`=0
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id='304926'
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=0
  AND `file_published`=1
SELECT votes, allvotes, rating
FROM jos_vm_product_votes
WHERE product_id='304926'
SELECT `product_id`
FROM `jos_vm_product_attribute_sku`
WHERE `product_id`=304926
SELECT `attribute`,`custom_attribute`
FROM `jos_vm_product`
WHERE `product_id`=304926
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=304909%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304909'
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=304909
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='304909'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304909
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='0'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT `product_price`, `product_price_id`, `product_currency`
  FROM `jos_vm_product_price`
  WHERE product_id=304909
  AND shopper_group_id=5
  ORDER BY price_quantity_start
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304909
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304909
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304909
  AND `file_is_image`=1
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304909
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=1
  AND `file_published`=1
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304909
  AND `file_is_image`=0
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id='304909'
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=0
  AND `file_published`=1
SELECT votes, allvotes, rating
FROM jos_vm_product_votes
WHERE product_id='304909'
SELECT `product_id`
FROM `jos_vm_product_attribute_sku`
WHERE `product_id`=304909
SELECT `attribute`,`custom_attribute`
FROM `jos_vm_product`
WHERE `product_id`=304909
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=304899%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304899'
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=304899
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='304899'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304899
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='0'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT `product_price`, `product_price_id`, `product_currency`
  FROM `jos_vm_product_price`
  WHERE product_id=304899
  AND shopper_group_id=5
  ORDER BY price_quantity_start
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304899
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304899
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304899
  AND `file_is_image`=1
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304899
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=1
  AND `file_published`=1
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304899
  AND `file_is_image`=0
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id='304899'
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=0
  AND `file_published`=1
SELECT votes, allvotes, rating
FROM jos_vm_product_votes
WHERE product_id='304899'
SELECT `product_id`
FROM `jos_vm_product_attribute_sku`
WHERE `product_id`=304899
SELECT `attribute`,`custom_attribute`
FROM `jos_vm_product`
WHERE `product_id`=304899
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=304846%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304846'
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=304846
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='304846'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304846
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='0'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT vendor_id
FROM jos_vm_product
WHERE product_id='304846'
SELECT `product_price`, `product_price_id`, `product_currency`
  FROM `jos_vm_product_price`
  WHERE product_id=304846
  AND shopper_group_id=5
  ORDER BY price_quantity_start
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304846
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304846
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304846
  AND `file_is_image`=1
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304846
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=1
  AND `file_published`=1
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304846
  AND `file_is_image`=0
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id='304846'
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=0
  AND `file_published`=1
SELECT votes, allvotes, rating
FROM jos_vm_product_votes
WHERE product_id='304846'
SELECT `product_id`
FROM `jos_vm_product_attribute_sku`
WHERE `product_id`=304846
SELECT `attribute`,`custom_attribute`
FROM `jos_vm_product`
WHERE `product_id`=304846
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=304845%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304845'
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=304845
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='304845'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304845
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='0'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT vendor_id
FROM jos_vm_product
WHERE product_id='304845'
SELECT `product_price`, `product_price_id`, `product_currency`
  FROM `jos_vm_product_price`
  WHERE product_id=304845
  AND shopper_group_id=5
  ORDER BY price_quantity_start
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304845
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304845
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304845
  AND `file_is_image`=1
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304845
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=1
  AND `file_published`=1
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304845
  AND `file_is_image`=0
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id='304845'
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=0
  AND `file_published`=1
SELECT votes, allvotes, rating
FROM jos_vm_product_votes
WHERE product_id='304845'
SELECT `product_id`
FROM `jos_vm_product_attribute_sku`
WHERE `product_id`=304845
SELECT `attribute`,`custom_attribute`
FROM `jos_vm_product`
WHERE `product_id`=304845
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=304843%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304843'
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=304843
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='304843'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304843
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='0'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT vendor_id
FROM jos_vm_product
WHERE product_id='304843'
SELECT `product_price`, `product_price_id`, `product_currency`
  FROM `jos_vm_product_price`
  WHERE product_id=304843
  AND shopper_group_id=5
  ORDER BY price_quantity_start
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304843
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304843
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304843
  AND `file_is_image`=1
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304843
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=1
  AND `file_published`=1
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304843
  AND `file_is_image`=0
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id='304843'
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=0
  AND `file_published`=1
SELECT votes, allvotes, rating
FROM jos_vm_product_votes
WHERE product_id='304843'
SELECT `product_id`
FROM `jos_vm_product_attribute_sku`
WHERE `product_id`=304843
SELECT `attribute`,`custom_attribute`
FROM `jos_vm_product`
WHERE `product_id`=304843
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=304841%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304841'
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=304841
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='304841'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304841
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='0'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT vendor_id
FROM jos_vm_product
WHERE product_id='304841'
SELECT `product_price`, `product_price_id`, `product_currency`
  FROM `jos_vm_product_price`
  WHERE product_id=304841
  AND shopper_group_id=5
  ORDER BY price_quantity_start
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304841
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304841
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304841
  AND `file_is_image`=1
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304841
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=1
  AND `file_published`=1
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304841
  AND `file_is_image`=0
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id='304841'
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=0
  AND `file_published`=1
SELECT votes, allvotes, rating
FROM jos_vm_product_votes
WHERE product_id='304841'
SELECT `product_id`
FROM `jos_vm_product_attribute_sku`
WHERE `product_id`=304841
SELECT `attribute`,`custom_attribute`
FROM `jos_vm_product`
WHERE `product_id`=304841
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=304830%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304830'
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=304830
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='304830'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304830
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='0'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT `product_price`, `product_price_id`, `product_currency`
  FROM `jos_vm_product_price`
  WHERE product_id=304830
  AND shopper_group_id=5
  ORDER BY price_quantity_start
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304830
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304830
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304830
  AND `file_is_image`=1
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304830
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=1
  AND `file_published`=1
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304830
  AND `file_is_image`=0
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id='304830'
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=0
  AND `file_published`=1
SELECT votes, allvotes, rating
FROM jos_vm_product_votes
WHERE product_id='304830'
SELECT `product_id`
FROM `jos_vm_product_attribute_sku`
WHERE `product_id`=304830
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=304826%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304826'
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=304826
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='304826'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304826
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='0'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT `product_price`, `product_price_id`, `product_currency`
  FROM `jos_vm_product_price`
  WHERE product_id=304826
  AND shopper_group_id=5
  ORDER BY price_quantity_start
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304826
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304826
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304826
  AND `file_is_image`=1
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304826
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=1
  AND `file_published`=1
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304826
  AND `file_is_image`=0
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id='304826'
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=0
  AND `file_published`=1
SELECT votes, allvotes, rating
FROM jos_vm_product_votes
WHERE product_id='304826'
SELECT `product_id`
FROM `jos_vm_product_attribute_sku`
WHERE `product_id`=304826
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=304655%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304655'
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=304655
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='304655'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304655
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='0'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT `product_price`, `product_price_id`, `product_currency`
  FROM `jos_vm_product_price`
  WHERE product_id=304655
  AND shopper_group_id=5
  ORDER BY price_quantity_start
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304655
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304655
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304655
  AND `file_is_image`=1
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304655
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=1
  AND `file_published`=1
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304655
  AND `file_is_image`=0
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id='304655'
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=0
  AND `file_published`=1
SELECT votes, allvotes, rating
FROM jos_vm_product_votes
WHERE product_id='304655'
SELECT `product_id`
FROM `jos_vm_product_attribute_sku`
WHERE `product_id`=304655
SELECT `attribute`,`custom_attribute`
FROM `jos_vm_product`
WHERE `product_id`=304655
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=304346%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304346'
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=304346
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='304346'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304346
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='0'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT `product_price`, `product_price_id`, `product_currency`
  FROM `jos_vm_product_price`
  WHERE product_id=304346
  AND shopper_group_id=5
  ORDER BY price_quantity_start
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304346
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=304346
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304346
  AND `file_is_image`=1
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=304346
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=1
  AND `file_published`=1
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=304346
  AND `file_is_image`=0
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id='304346'
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=0
  AND `file_published`=1
SELECT votes, allvotes, rating
FROM jos_vm_product_votes
WHERE product_id='304346'
SELECT `product_id`
FROM `jos_vm_product_attribute_sku`
WHERE `product_id`=304346
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=952%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=952'
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=952
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='952'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=952
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='0'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT `product_price`, `product_price_id`, `product_currency`
  FROM `jos_vm_product_price`
  WHERE product_id=952
  AND shopper_group_id=5
  ORDER BY price_quantity_start
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=952
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=952
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=952
  AND `file_is_image`=1
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=952
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=1
  AND `file_published`=1
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=952
  AND `file_is_image`=0
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id='952'
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=0
  AND `file_published`=1
SELECT votes, allvotes, rating
FROM jos_vm_product_votes
WHERE product_id='952'
SELECT `product_id`
FROM `jos_vm_product_attribute_sku`
WHERE `product_id`=952
SELECT `attribute`,`custom_attribute`
FROM `jos_vm_product`
WHERE `product_id`=952
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=318%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=318'
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=318
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='318'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=318
SELECT amount,is_percent
  FROM jos_vm_product,jos_vm_product_discount
  WHERE product_id='0'
  AND (start_date<='1337367197' OR start_date=0)
  AND (end_date>='1337297760' OR end_date=0)
  AND product_discount_id=discount_id
SELECT vendor_id
FROM jos_vm_product
WHERE product_id='318'
SELECT `product_price`, `product_price_id`, `product_currency`
  FROM `jos_vm_product_price`
  WHERE product_id=318
  AND shopper_group_id=5
  ORDER BY price_quantity_start
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=318
SELECT tax_rate
  FROM jos_vm_product, jos_vm_tax_rate
  WHERE product_tax_id=tax_rate_id
  AND product_id=318
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=318
  AND `file_is_image`=1
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id=318
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=1
  AND `file_published`=1
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=318
  AND `file_is_image`=0
  AND `file_published`=1
SELECT product_parent_id
FROM jos_vm_product
WHERE product_id='318'
SELECT *
  FROM `jos_vm_product_files`
  WHERE `file_product_id`=0
  AND `file_is_image`=0
  AND `file_published`=1
SELECT votes, allvotes, rating
FROM jos_vm_product_votes
WHERE product_id='318'
SELECT `product_id`
FROM `jos_vm_product_attribute_sku`
WHERE `product_id`=318
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&lang=fr&limit=5&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&lang=fr&limit=10&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&lang=fr&limit=15&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&lang=fr&limit=20&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&lang=fr&limit=25&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&lang=fr&limit=30&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&lang=fr&limit=50&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&lang=fr&limit=100&limitstart=0&page=shop.browse'
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 = '305012'
  AND c.category_id = '207'
  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
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=305012
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=305012%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=305012'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&lang=fr&page=shop.browse'
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 = '1144'
  AND c.category_id = '207'
  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
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=1144
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=1144%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=1144'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&lang=fr&page=shop.browse'
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 = '991'
  AND c.category_id = '207'
  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
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=991
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=991%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=991'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&lang=fr&page=shop.browse'
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 = '1279'
  AND c.category_id = '207'
  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
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=1279
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=1279%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=1279'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&lang=fr&page=shop.browse'
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 = '1275'
  AND c.category_id = '207'
  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
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=1275
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=1275%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=1275'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&lang=fr&page=shop.browse'
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 = '300353'
  AND c.category_id = '207'
  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
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=300353
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=300353%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=300353'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&lang=fr&page=shop.browse'
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 = '1264'
  AND c.category_id = '207'
  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
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=1264
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=1264%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=1264'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&lang=fr&page=shop.browse'
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 = '1274'
  AND c.category_id = '207'
  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
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=1274
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=1274%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=1274'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&lang=fr&page=shop.browse'
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 = '5016'
  AND c.category_id = '207'
  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
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=5016
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=5016%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=5016'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&lang=fr&page=shop.browse'
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 = '207'
  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
SELECT product_id, `jos_vm_product`.*
FROM `jos_vm_product`
WHERE `product_id`=304133
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%product_id=304133%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%flypage=flypage.tpl%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.product_details%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304133'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=207%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&lang=fr&page=shop.browse'
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='328'

  AND jos_vm_product.product_publish='Y'

  AND jos_vm_product.product_special='Y'

  ORDER BY RAND()
  LIMIT 0, 10
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
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=488&id=106&lang=fr&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=492&id=13&lang=fr&layout=blog&view=section'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=212&lang=fr'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=281&id=15&lang=fr&layout=blog&view=section'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_contact&Itemid=274&id=1&lang=fr&view=contact'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&lang=fr&page=shop.search'
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'
SELECT name, link,id
  FROM jos_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
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'
SELECT name, link,id
  FROM jos_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
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'
SELECT name, link,id
  FROM jos_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=282&id=61&lang=fr&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=283&id=62&lang=fr&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=476&id=73&lang=fr&layout=blog&view=category'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=208&id=57&lang=fr&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=491&id=110&lang=fr&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=289&id=61&lang=fr&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=290&id=62&lang=fr&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_contact&Itemid=291&id=1&lang=fr&view=contact'
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
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=189%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=189&lang=fr&page=shop.browse'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=193%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=193&lang=fr&page=shop.browse'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=25%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=25&lang=fr&page=shop.browse'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=212%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=212&lang=fr&page=shop.browse'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=220%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=220&lang=fr&page=shop.browse'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=30%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=30&lang=fr&page=shop.browse'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=286%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=286&lang=fr&page=shop.browse'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=17%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=17&lang=fr&page=shop.browse'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=320%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=320&lang=fr&page=shop.browse'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=327%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=327&lang=fr&page=shop.browse'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=328%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=328&lang=fr&page=shop.browse'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=333%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=333&lang=fr&page=shop.browse'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=346%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=346&lang=fr&page=shop.browse'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=334%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=334&lang=fr&page=shop.browse'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=339%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=339&lang=fr&page=shop.browse'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%category_id=352%'
  AND published=1
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.browse%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=352&lang=fr&page=shop.browse'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=292&id=68&lang=fr&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=293&id=69&lang=fr&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=294&id=70&lang=fr&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_contact&Itemid=295&id=1&lang=fr&view=contact'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_user&lang=fr&view=reset'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_user&lang=fr&view=remind'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.registration%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&lang=fr&page=shop.registration'
SELECT guest, usertype, client_id
FROM jos_session
WHERE client_id = 0
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.search%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&lang=fr&page=shop.search'
SELECT country,zip
FROM jos_vm_user_info
WHERE user_info_id=''
SELECT user_info_id
  FROM `jos_vm_user_info`
  WHERE user_id='0'
  AND address_type='BT'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.cart%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=102&lang=fr&page=shop.cart'
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND params LIKE '%page=shop.cart%'
  AND published=1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&category_id=328&lang=fr&page=shop.feed'
SELECT name, link,id
  FROM jos_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'

4 requêtes legacy achevées

SELECT `lft`, `rgt`
FROM `jos_core_acl_aro_groups`
WHERE `name`='Public Frontend'
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
SELECT `lft`, `rgt`
FROM `jos_core_acl_aro_groups`
WHERE `name`='Public Backend'
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

/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.ini 1
/homepages/37/d353207716/htdocs/BE/administrator/language/fr-FR/fr-FR.plg_content_avreloaded.ini 1
/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.plg_system_gwcoupons.ini
/homepages/37/d353207716/htdocs/BE/language/en-GB/en-GB.plg_system_gwcoupons.ini
/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.plg_system_gwvalidity.ini
/homepages/37/d353207716/htdocs/BE/language/en-GB/en-GB.plg_system_gwvalidity.ini
/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.plg_system_debug.ini 1
/homepages/37/d353207716/htdocs/BE/administrator/language/fr-FR/fr-FR.plg_system_osolcaptcha.ini 1
/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.com_virtuemart.ini
/homepages/37/d353207716/htdocs/BE/language/en-GB/en-GB.com_virtuemart.ini
/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.plg_content_pagebreak.ini 1
/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.tpl_jamesoliteavril2010.ini
/homepages/37/d353207716/htdocs/BE/language/en-GB/en-GB.tpl_jamesoliteavril2010.ini
/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.mod_footer.ini 1
/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.mod_mainmenu.ini 1
/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.mod_product_categories.ini
/homepages/37/d353207716/htdocs/BE/language/en-GB/en-GB.mod_product_categories.ini
/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.mod_html.ini
/homepages/37/d353207716/htdocs/BE/language/en-GB/en-GB.mod_html.ini
/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.mod_virtuemart_login.ini
/homepages/37/d353207716/htdocs/BE/language/en-GB/en-GB.mod_virtuemart_login.ini
/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.mod_whosonline.ini 1
/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.mod_breadcrumbs.ini 1
/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.mod_vm_jaslideshow.ini
/homepages/37/d353207716/htdocs/BE/language/en-GB/en-GB.mod_vm_jaslideshow.ini
/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.mod_virtuemart_search.ini
/homepages/37/d353207716/htdocs/BE/language/en-GB/en-GB.mod_virtuemart_search.ini
/homepages/37/d353207716/htdocs/BE/language/fr-FR/fr-FR.mod_virtuemart_cart.ini
/homepages/37/d353207716/htdocs/BE/language/en-GB/en-GB.mod_virtuemart_cart.ini

Diagnostique des textes non traduits

Aucun

Textes non traduits

Aucun

Boutique Essénienne - Sagesse pratique au quotidien

Votre Panier

Collier Pendentif tube verre et son cordon

Bioéconomie et solidarisme

Etre végétarien, une urgence pour la planête

Les Mystères de l'Esprit

Dialogue Théurgique avec la Mère

L'après-vie confimée par la science

120 Méthodes Esséniennes

Le Bracelet Angelique

Dolphin Spirit

Solve & Coagula

Les 22 Arcanas

Evangile Essénien - Archange Ouriel t.20 - Aux portes de la terre promise

Le Livre de la Fraternité

Statue égyptienne - Isis à l'enfant

Beltane

Produits vus récemment

TOUS NOS PRODUITS

Catalogues à télécharger

Services

Newsletter gratuite

Je m'enregistre

Paiement sécurisé

Qui est en ligne

Annonces