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
terms of sale
Home terms of sale

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
terms of sale

Please read these terms of sale carefully.

You will be asked to expressly agree to these terms of sale before you place an order for products from our website.

In these terms of sale, “we” means THEPROMAKEUPSHOP.COM (and “us” and “our” will be construed accordingly); and “you” means our customer or potential customer for products (and “your” will be construed accordingly).

The advertising of products on our website constitutes an “invitation to treat”; and your order for products constitutes a contractual offer. No contract will come into force between you and us unless and until we accept your order in accordance with the procedure detailed below.

In order to enter into a contract to purchase products from us, you will need to take the following steps: (i) you must add any the products you wish to purchase to your shopping cart, and then proceed to the checkout; (ii) if you are a new customer, you must then create an account with us and log in; if you are an existing customer, you must enter your login details; (iii) once you are logged in, you must select your preferred method of delivery and confirm your order and your consent to these terms of sale; (iv) you will be transferred to the Protx website, and Protx will handle your payment; (v) we will then send you an initial acknowledgment and (vi) once we have checked whether we are able to meet your order, we will either send you an order confirmation (at which point your order will become a binding contract) or we will confirm by email that “we are unable to meet your order.”

We will not file a copy of these terms of sale specifically in relation to your order. We may update the version of these terms of sale on the website from time to time, and we do not guarantee that the version you have agreed to will remain accessible. We therefore recommend that you download, print and retain a copy of these terms of sale for your records.

The only language in which we provide these terms of sale is English.

Before you place your order, you will have the opportunity of identifying whether you have made any input errors by checking your shopping cart before proceeding to checkout and pay. You may correct those input errors before placing your order by amending quantities or adding and deleting items from your shopping cart.

As described in the web shop under product details.

Prices for products are quoted on our website. The website contains a large number of products and it is always possible that some of the prices on the website may be incorrect. We will verify prices as part of our sale procedures so that a product's correct price will be stated when you pay for the product.

In addition to the price of the products, you will/may have to pay a delivery charge, which will be as stated depending on your selected delivery method.

Payment must be made upon the submission of your order. We may withhold the products and/or cancel the contract between us if the price is not received from you in full in cleared funds.

The prices on the website include all value added taxes (where applicable).

Payment for all products must be made by debit or credit card OR any method detailed on the website from time to time.

Prices for products are liable to change at any time, but changes will not affect contracts which have come into force.

You warrant to us that:

(a) you are legally capable of entering into binding contracts, and you have full authority, power and capacity to agree to these terms of sale;

(b) the information provided in your order is accurate and complete; and

(c) you will be able to accept delivery of the products.

We will arrange for the products to be delivered to the address for delivery indicated in your order.

We will use reasonable endeavours to deliver products on or before the date for delivery set out in our order confirmation or, if no date is set out in our order confirmation, within 14 days of the date of our order confirmation. However, we cannot guarantee delivery by the relevant date. We do however guarantee that unless there are exceptional circumstances all deliveries of products will be dispatched within 30 days of the later of receipt of payment and the date of our order confirmation.

The products will be at your risk from the time of delivery. Ownership of the products will only pass to you upon the later of:

(a) delivery of the products; and

(b) receipt by us of full payment of all sums due in respect of the products (including delivery charges).

Until ownership of the products has passed to you, you will possess the products as our fiduciary agent and bailee, and if you are a business customer you must store the products separately from other goods and ensure that the products are clearly identifiable as belonging to us.

We will be entitled to recover payment for the products even where ownership has not passed to you.

You may cancel a contract to purchase a product or products at any time within 14 working days after the day you received the relevant products or products (subject to the limitations set out below).

You will not have any such right insofar as a contract relates to: (i) the supply of any products which constitute hygiene related products that have been unsealed by you; (ii) the supply of products the price of which is dependent upon fluctuations in financial markets which we cannot control; (iv) the supply of goods made to your specifications or clearly personalised;

If you cancel a contract on this basis, you must inform us in writing and return the products to us immediately, in the same condition in which you received them. Products returned by you in accordance with this Section will be refunded in full (including the cost of sending the products to you). However, you will be responsible for paying the cost of returning the product to us.

If you cancel a contract on this basis and you do not return to the products to us, we may recover the products and charge you for the costs we incur in doing so. Similarly, if you return the products at our expense, we may pass that expense on to you.

Nothing in these terms of sale affects any statutory rights you may have as a consumer.

If you cancel a contract and are entitled to a refund, 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 valid notice of cancellation.

In this Section and Section 15 below, “force majeure event” means:

(a) any event which is beyond our reasonable control;

(b) the unavailability of raw materials, components or products; and/or

(c) power failure, industrial disputes affecting any third party, governmental regulations, fires, floods, disasters, civil riots, terrorist attacks or wars.

Where a force majeure event gives rise to a failure or delay in us performing our obligations under these terms of sale, those obligations will be suspended for the duration of the force majeure event.

Nothing in these terms of sale will limit or exclude your or our liability for: (i) death or personal injury caused by negligence; (ii) fraud or fraudulent misrepresentation; or (iii) any matter for which it would be illegal to limit or exclude, or attempt to limit or exclude, liability.

Subject to this:

(a) we will not be liable for any losses arising out of a force majeure event;

(b) we will not be liable in respect of any defect in the products arising from fair wear and tear, wilful damage, accident, negligence by you or a third party, use otherwise than in accordance with the manufacturer's or our instructions or recommendations, or any alteration carried out by you or any third party; and

(c) if you are a business customer: (i) our liability in connection with any product purchased through our website is strictly limited to the higher of the purchase price of the relevant product and the replacement cost of the relevant product; and (ii) we will not be liable for any loss of income or revenue, loss of business, loss of profits or contracts, loss of anticipated savings, loss of data or waste of management or office time, or loss of goodwill or reputational damage.

We may cancel a contract to supply products made under these terms of sale immediately by written notice to you if you fail to pay, on time and in full, any amount due to use under the contract, or commit any material breach of your obligations to us under the contract.

If you are a business customer, we may cancel a contract to supply products made under these terms of sale if:

(a) you cease to trade;

(b) you become insolvent or unable to pay your debts within the meaning of the insolvency legislation applicable to you;

(c) a person (including the holder of a charge or other security interest) is appointed to manage or take control of the whole or part of your business or assets, or notice of an intention to appoint such a person is given or documents relating to such an appointment are filed with any court;

(d) the ability of your creditors to take any action to enforce their debts is suspended, restricted or prevented or some or all of that your creditors accept, by agreement or pursuant to a court order, an amount of less than the sums owing to them in satisfaction of those sums; or

(e) any process is instituted which could lead to you being dissolved and your assets being distributed to your creditors, shareholders or other contributors (other than for the purposes of solvent amalgamation or reconstruction).

Upon the cancellation of a contract in accordance with Section [17]:

(a) we will cease to have any obligation to deliver products which are undelivered at the date of cancellation;

(b) you will continue to have an obligation where applicable to pay for products which have been delivered at the date of cancellation (without prejudice to any right we may have to recover the products); and

(c) all the other provisions of these terms of sale will cease to have effect, except that Sections 8, 11, 12, 15, 16, 18 and 20 will survive termination and have effect indefinitely.

These terms of sale do not constitute or contain any assignment or licence of any intellectual property rights, do not govern the licensing of works comprised or stored in products, and do not govern the provision of any services by us or any third party in relation to the products.

Images of products on our website are for illustrative purposes; actual products may differ from such images.

We will treat all your personal information that we collect in connection with your order in accordance with the terms of our privacy policy; use of our website will be subject to our website terms of use.

Contracts under these terms of sale may only be varied by an instrument in writing signed by both you and us. We may revise these terms of sale from time-to-time, but such revisions will not affect the terms of any contracts which we have entered into with you.

If any provision of these terms of sale is held invalid or unenforceable by a court of competent jurisdiction, the remaining provisions will remain in full force and effect, and such invalid or unenforceable provisions or portion thereof will be deemed omitted.

No waiver of any provision of these terms of sale, whether by conduct or otherwise, in any one or more instances, will be deemed to be, or be construed as, a further or continuing waiver of that provision or any other provision of these terms of sale.

You may not assign, charge, sub-contract or otherwise transfer any of your rights or obligations arising under these terms of sale. Any attempt by you to do so will be null and void. We may assign, charge, sub-contract or otherwise transfer any of our rights or obligations arising under these terms of sale, at any time – providing where you are a consumer that such action does not serve to reduce the guarantees benefiting you under these terms of sale.

Each contract under these terms of sale is made for the benefit of the parties to it and is not intended to benefit, or be enforceable by, any other person. The right of the parties to terminate, rescind, or agree any amendment, variation, waiver or settlement under such contracts is not subject to the consent of any person who is not a party to the relevant contract.

Subject to the first paragraph of Section 15, these terms of sale contain the entire agreement and understanding of the parties in relation to the purchase of products from our website, and supersede all previous agreements and understandings between the parties in relation to the purchase of products from our website; and each party acknowledges that no representations not expressly contained in these terms of sale have been made by or on behalf of the other party in relation to the purchase of products from our website.

These terms of sale will be governed by and construed in accordance with English law, and the courts of England and Wales will have non-exclusive jurisdiction to adjudicate any dispute arising under or in relation to these terms of sale.

 

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.

Featured Products

CATWALK false eyelashes
CATWALK false eyelashes
Collapsible Lantern Bin
Collapsible Lantern Bin
"Magic 9" Mascara Brush Collection

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.001 seconds, 0.21 MB
Application afterInitialise: 0.181 seconds, 3.82 MB
Application afterRoute: 0.198 seconds, 4.48 MB
Application afterDispatch: 0.316 seconds, 9.71 MB
Application afterRender: 0.466 seconds, 11.15 MB

Memory Usage

11737792

31 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'bis465ncj1p8akm2oponc76lb0'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1268166715' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'bis465ncj1p8akm2oponc76lb0'
  4. UPDATE `jos_session`
      SET `time`='1268167615',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:23;s:19:\"session.timer.start\";i:1268167376;s:18:\"session.timer.last\";i:1268167594;s:17:\"session.timer.now\";i:1268167607;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:\"65ae131d76a1f29ade21e4b13ef3ef8d\";}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\";vmUseGreyBox|s:1:\"0\";vmCartDirection|s:1:\"0\";product_sess|a:38:{i:226;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:111;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:107;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:235;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:202;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:150;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:191;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:93;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:78;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:199;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:237;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:194;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:121;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268167594;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:120;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:236;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:116;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:106;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:81;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:257;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:134;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:101;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:119;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:256;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:130;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:87;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:200;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:99;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:112;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:127;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268167594;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:122;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268167594;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:123;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268167594;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:124;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268167594;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:125;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268167594;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:126;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268167594;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:198;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}}last_page|s:11:\"shop.browse\";last_browse_parameters|a:7:{s:11:\"category_id\";s:2:\"34\";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\";}'
      WHERE session_id='bis465ncj1p8akm2oponc76lb0'
  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 = 103)
      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 = 71
      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-09 20:46:55' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-09 20:46:55' )   )    OR  ( a.state = -1 )  )
  10. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='71'
  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 = 103 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='121406'
  19. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='146'
      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`='146'
  21. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='119901'
  22. 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
  23. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='101032'
  24. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='237'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  25. 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
  26. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121216'
  27. 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
  28. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='156222'
  29. 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
  30. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='111104'
  31. 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

31 legacy queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'bis465ncj1p8akm2oponc76lb0'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1268166715' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'bis465ncj1p8akm2oponc76lb0'
  4. UPDATE `jos_session`
      SET `time`='1268167615',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:23;s:19:\"session.timer.start\";i:1268167376;s:18:\"session.timer.last\";i:1268167594;s:17:\"session.timer.now\";i:1268167607;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:\"65ae131d76a1f29ade21e4b13ef3ef8d\";}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\";vmUseGreyBox|s:1:\"0\";vmCartDirection|s:1:\"0\";product_sess|a:38:{i:226;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:111;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:107;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:235;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:202;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:150;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:191;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:93;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:78;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:199;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:237;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:194;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:121;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268167594;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:120;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:236;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:116;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:106;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:81;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:257;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:134;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:101;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:119;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:256;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:130;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:87;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:200;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:99;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:112;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:127;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268167594;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:122;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268167594;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:123;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268167594;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:124;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268167594;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:125;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268167594;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:126;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268167594;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:198;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}}last_page|s:11:\"shop.browse\";last_browse_parameters|a:7:{s:11:\"category_id\";s:2:\"34\";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\";}'
      WHERE session_id='bis465ncj1p8akm2oponc76lb0'
  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 = 103)
      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 = 71
      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-09 20:46:55' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-09 20:46:55' )   )    OR  ( a.state = -1 )  )
  10. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='71'
  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 = 103 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='121406'
  19. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='146'
      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`='146'
  21. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='119901'
  22. 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
  23. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='101032'
  24. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='237'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  25. 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
  26. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121216'
  27. 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
  28. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='156222'
  29. 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
  30. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='111104'
  31. 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