Notice: Trying to get property of non-object in /var/www/vhosts/thepromakeupstore.co.uk/httpdocs/plugins/system/redirect_failed_login.php on line 33

Notice: Undefined variable: top_userleft in /var/www/vhosts/thepromakeupstore.co.uk/httpdocs/templates/jxtc_teqmart_2_0/layout_vars.php on line 36

Notice: Undefined variable: top_userleft in /var/www/vhosts/thepromakeupstore.co.uk/httpdocs/templates/jxtc_teqmart_2_0/layout_vars.php on line 38
returns policy
Home returns policy

Notice: Undefined index: print in /var/www/vhosts/thepromakeupstore.co.uk/httpdocs/plugins/content/jwts.php on line 81

Notice: Undefined index: format in /var/www/vhosts/thepromakeupstore.co.uk/httpdocs/plugins/content/jwts.php on line 81

Notice: Undefined index: print in /var/www/vhosts/thepromakeupstore.co.uk/httpdocs/plugins/content/jwts.php on line 139

Notice: Undefined index: format in /var/www/vhosts/thepromakeupstore.co.uk/httpdocs/plugins/content/jwts.php on line 139
returns policy

At THEPROMAKEUPSHOP.COM it’s really important to us that you are happy with your purchases. If for any reason you are not, then we are happy to offer a refund on items returned to us in perfect condition within 14 days of receipt of order with proof of purchase. Please understand, however, that as many of our products are hygiene related, all products must be returned to us unused, in their original packaging with any tamper seals intact. We appreciate your understanding.

 

1. Introduction

We understand that from time to time you may wish to return a product to us.

We have created this 14 day returns policy to enable you to return products to us in appropriate circumstances.

This returns policy applies to customers irrespective of geographical location.

This policy does not affect any statutory rights you may have (such consumer rights under the Consumer Protection (Distance Selling) Regulations 2000).

2. Returns

Where you have no other legal right to return a product and receive a refund or exchange, then you will nonetheless be entitled to return a product to us where:

(a) we receive the returned product within 14 days following the date of purchase of the product;

(b) the returned product is unused, in its original unopened packaging with any seal or shrink-wrap intact and with any labels still attached, and otherwise in a condition enabling us to sell the product as new;

(c) you comply with the returns procedure set out below; and

(d) none of the exclusions set out below apply.

3. Returns procedure

Please ensure that returns are packed and labelled carefully so that they are not lost or damaged in transit. We recommend sending returns by recorded delivery and keeping proof of purchase as we cannot be held responsible for packages that fail to reach us. Please note that THEPROMAKEUPSHOP.COM is not responsible for return postage costs other than for incorrect or faulty items. Refunds will only be given provided we receive an appropriately completed returns form. Replacements for exchange of damaged goods will not be dispatched until the original item has been received at our warehouse.

In order to take advantage of your rights under this returns policy, you must:
Notify our customer services in writing to This e-mail address is being protected from spambots. You need JavaScript enabled to view it within 7 days of receiving any airbrushing equipment you wish to return.

Returns address
THEPROMAKEUPSHOP.COM
“Returns”
20 Mortlake High Street
London
SW14 8JN

If you are returning goods which were bought using a discount or offer, we will adjust the refund accordingly if you fall below the discount/offer threshold, as that discount or offer will no longer apply.

4. Exclusions

The following kinds of products may not be returned under this policy:

(a) All single use and disposable products due to the hygiene nature of this category unless otherwise notified by telephone within seven (7) days of receipt and that the packaging has not been tampered with and any seals must be intact

(b) Airbrushing equipment that has been deemed faulty. The equipment first needs to be sent directly to the manufacturer for checking prior to any replacement product or refund being issued. This is due to the delicate nature of the goods. All airbrushing equipment supplied by THEPROMAKEUPSHOP.COM has been checked and guaranteed by the manufacturer prior to shipment. It is recommended that any guarantees are taken up on receipt of goods

(c) Items returned after 14 days

(d) Gift vouchers

5. Refunds

We will send you a refund for the full price of any product properly returned by you in accordance with the terms of this returns policy excluding the original delivery charges and excluding the costs of returning the product to us.

We will usually refund any money received from you using the same method originally used by you to pay for your purchase.

We will process the refund due to you as soon as possible and, in any event, within 30 days of the day we received your returned product.

6. Improper returns

Where you return a product in contravention of this policy (and where you do not have any other legal right to return the product):

(a) we will not refund or exchange the product;

(b) we may retain the returned product until you pay to us such additional amount as we may charge for re-delivery of the returned product; and

(c) if we do not receive payment of such additional amount within 14 days of issuing a request for payment, we may destroy or otherwise dispose of the returned product in our sole discretion without any liability to you.

7. About us

THEPROMAKEUPSHOP.COM
Registered office: 2 Buckminster Road, Sproxton, Leics LE14 4PX
Principal trading address: 20 Mortlake High Street, London SW14 8JN
Company registration number: 6667415.
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
VAT number: 939809763
 

Quicklinks

Summer Sale
Student Kits
Latest Products
Kits for Schools
Become a Sales Rep

Your Basket


Notice: Undefined variable: my_taxrate in /var/www/vhosts/thepromakeupstore.co.uk/httpdocs/administrator/components/com_virtuemart/html/shop.basket_short.php on line 156

Notice: Undefined variable: total in /var/www/vhosts/thepromakeupstore.co.uk/httpdocs/administrator/components/com_virtuemart/html/shop.basket_short.php on line 156

Notice: Undefined variable: my_taxrate in /var/www/vhosts/thepromakeupstore.co.uk/httpdocs/administrator/components/com_virtuemart/html/shop.basket_short.php on line 156
Your basket is currently empty.

Best Sellers

01 Papaw Ointment
02 "Magic 9" Mascara Brush Collection
03 Black Plastic Spatula
04 Acrylic Mixing Dish Round (9cm Diameter)
05 Latex Free Sponges
06 "Famous Five" Mascara Brush Collection

Featured Products

The Pro Collection
The Pro Collection
"Famous Five" Mascara Brush Collection

Collapsible Lantern Bin
Collapsible Lantern Bin

Latest Products

Jar Mix & Match Kit
Jar Mix & Match Kit
Airbrush starter kit
Airbrush starter kit
Essential Tool Starter Kit
Essential Tool Starter Kit

Profile Information

Application afterLoad: 0.002 seconds, 0.21 MB
Application afterInitialise: 0.186 seconds, 3.82 MB
Application afterRoute: 0.203 seconds, 4.47 MB
Application afterDispatch: 0.329 seconds, 9.68 MB
Application afterRender: 0.483 seconds, 11.12 MB

Memory Usage

11699320

33 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'c17bo2uvvgbphvin97rcf85ee7'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1268332886' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'c17bo2uvvgbphvin97rcf85ee7'
  4. UPDATE `jos_session`
      SET `time`='1268333786',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:12;s:19:\"session.timer.start\";i:1268333716;s:18:\"session.timer.last\";i:1268333773;s:17:\"session.timer.now\";i:1268333778;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:15:\"Public Frontend\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:88:\"/var/www/vhosts/thepromakeupstore.co.uk/httpdocs/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"749e112eeaf3a38a3e277501ef5a02b5\";}userstate|a:1:{s:10:\"product_id\";i:0;}auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:1:{s:3:\"idx\";i:0;}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:3:\"GBP\";last_page|s:11:\"shop.browse\";last_browse_parameters|a:7:{s:11:\"category_id\";s:2:\"41\";s:15:\"manufacturer_id\";i:0;s:7:\"keyword\";b:0;s:8:\"keyword1\";s:0:\"\";s:8:\"keyword2\";s:0:\"\";s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}vmUseGreyBox|s:1:\"0\";vmCartDirection|s:1:\"0\";product_sess|a:16:{i:134;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:81;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:127;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:262;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:260;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:259;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:191;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:132;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:120;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:146;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:150;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:213;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:257;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:92;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:256;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:116;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}}'
      WHERE session_id='c17bo2uvvgbphvin97rcf85ee7'
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. 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
  8. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 119)
      ORDER BY menuid DESC
      LIMIT 0, 1
  9. SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access 
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = cc.section
      AND s.scope = "content"
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE a.id = 74
      AND (  ( a.created_by = 0 )    OR  ( a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-11 18:56:26' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-11 18:56:26' )   )    OR  ( a.state = -1 )  )
  10. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='74'
  11. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  12. 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'
  13. 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`);
  14. 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 = 119 OR mm.menuid = 0 )
      ORDER BY position, ordering
  15. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  16. SELECT p.product_id, p.product_sales AS sales, p.product_parent_id, p.product_name, c.category_id, c.category_flypage
      FROM jos_vm_product p, jos_vm_product_category_xref pc, jos_vm_category c
      WHERE p.product_publish='Y'
      AND pc.product_id = p.product_id
      AND pc.category_id = c.category_id
      AND p.product_sales > 0
      GROUP BY p.product_id
      ORDER BY sales DESC, p.product_name 
      LIMIT 0, 6
  17. SELECT DISTINCT product_sku
      FROM jos_vm_product
      WHERE (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')
      AND vendor_id='1'
      AND jos_vm_product.product_publish='Y'
      AND jos_vm_product.product_special='Y'
      ORDER BY RAND()
      LIMIT 0, 3
  18. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='101031'
  19. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='236'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  20. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='236'
  21. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='101030'
  22. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='235'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  23. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='235'
  24. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='119901'
  25. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='107'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  26. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='107'
  27. SELECT DISTINCT product_sku
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE product_parent_id=''
      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_product.product_publish='Y'
      ORDER BY jos_vm_product.product_id DESC
      LIMIT 0, 3
  28. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121216'
  29. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='262'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  30. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='156222'
  31. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='260'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  32. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='111104'
  33. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='259'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id

33 legacy queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'c17bo2uvvgbphvin97rcf85ee7'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1268332886' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'c17bo2uvvgbphvin97rcf85ee7'
  4. UPDATE `jos_session`
      SET `time`='1268333786',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:12;s:19:\"session.timer.start\";i:1268333716;s:18:\"session.timer.last\";i:1268333773;s:17:\"session.timer.now\";i:1268333778;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:15:\"Public Frontend\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:88:\"/var/www/vhosts/thepromakeupstore.co.uk/httpdocs/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"749e112eeaf3a38a3e277501ef5a02b5\";}userstate|a:1:{s:10:\"product_id\";i:0;}auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:1:{s:3:\"idx\";i:0;}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:3:\"GBP\";last_page|s:11:\"shop.browse\";last_browse_parameters|a:7:{s:11:\"category_id\";s:2:\"41\";s:15:\"manufacturer_id\";i:0;s:7:\"keyword\";b:0;s:8:\"keyword1\";s:0:\"\";s:8:\"keyword2\";s:0:\"\";s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}vmUseGreyBox|s:1:\"0\";vmCartDirection|s:1:\"0\";product_sess|a:16:{i:134;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:81;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:127;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:262;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:260;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:259;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:191;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:132;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:120;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:146;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:150;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:213;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:257;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:92;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:256;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:116;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}}'
      WHERE session_id='c17bo2uvvgbphvin97rcf85ee7'
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. 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
  8. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 119)
      ORDER BY menuid DESC
      LIMIT 0, 1
  9. SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access 
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = cc.section
      AND s.scope = "content"
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE a.id = 74
      AND (  ( a.created_by = 0 )    OR  ( a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-11 18:56:26' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-11 18:56:26' )   )    OR  ( a.state = -1 )  )
  10. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='74'
  11. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  12. 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'
  13. 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`);
  14. 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 = 119 OR mm.menuid = 0 )
      ORDER BY position, ordering
  15. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  16. SELECT p.product_id, p.product_sales AS sales, p.product_parent_id, p.product_name, c.category_id, c.category_flypage
      FROM jos_vm_product p, jos_vm_product_category_xref pc, jos_vm_category c
      WHERE p.product_publish='Y'
      AND pc.product_id = p.product_id
      AND pc.category_id = c.category_id
      AND p.product_sales > 0
      GROUP BY p.product_id
      ORDER BY sales DESC, p.product_name 
      LIMIT 0, 6
  17. SELECT DISTINCT product_sku
      FROM jos_vm_product
      WHERE (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')
      AND vendor_id='1'
      AND jos_vm_product.product_publish='Y'
      AND jos_vm_product.product_special='Y'
      ORDER BY RAND()
      LIMIT 0, 3
  18. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='101031'
  19. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='236'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  20. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='236'
  21. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='101030'
  22. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='235'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  23. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='235'
  24. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='119901'
  25. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='107'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  26. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='107'
  27. SELECT DISTINCT product_sku
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE product_parent_id=''
      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_product.product_publish='Y'
      ORDER BY jos_vm_product.product_id DESC
      LIMIT 0, 3
  28. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121216'
  29. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='262'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  30. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='156222'
  31. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='260'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  32. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='111104'
  33. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='259'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None