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
reduce the risks
Home reduce the risks
reduce the risks

Hygiene Watchpoints for Professional Makeup Artists

  • Personal hygiene – clean hands and wardrobe (have your hand sanitising gel with you at all times - a tube attached to your belt and a pump on your work space) - even more important with swine flu
  • No false nails as they harbour bacteria
  • Keep your hair out of your face as you won’t be tempted to keep brushing it aside and then contaminating your client
  • Only use single-use, disposable brushes and applicators
  • Single use means single use – one loading of product, one application and into the bin. NEVER double dip into products.
  • Cut off the brush or applicator from a new mascara, eyeliner and lipgloss and throw it away, then you will never forget to use a single-use, disposable applicator
  • Ensure your kit is hygiene-friendly (don’t use any tools that can’t be 100% sanitised or thrown away). Keep it spotless
  • Ensure you have enough single-use tools to do the job at hand so you are not compromising your client and your reputation
  • Don’t use makeup straight from the container – transfer with a spatula to a mixing palette, jar or to the back of a clean hand before applying
  • Don't blow on your brushes, on your product palettes or into pans of any cosmetics
  • Don’t touch a client’s face then your own face or hair and then the client’s face again (double dipping of a different kind)
  • Never share personal or professional makeup tools and products
  • Respect the published product shelf life
  • Use common sense – if something doesn’t look or smell right, don’t use it.

©thepromakeupshop.com
 

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

Deluxe Extra Large Jar with Black Lid (150 ml)
Deluxe Extra Large Jar with Black Lid (150 ml)
Natural Hair Long Handled Blush, Highlight & Contour Brush
Natural Hair Long Handled Blush, Highlight & Contour Brush
Chrome 6 Well Mixing Palette
Chrome 6 Well Mixing Palette

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.184 seconds, 3.81 MB
Application afterRoute: 0.203 seconds, 4.47 MB
Application afterDispatch: 0.324 seconds, 9.64 MB
Application afterRender: 0.479 seconds, 11.07 MB

Memory Usage

11649720

33 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'c17bo2uvvgbphvin97rcf85ee7'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1268332828' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'c17bo2uvvgbphvin97rcf85ee7'
  4. UPDATE `jos_session`
      SET `time`='1268333728',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1268333716;s:18:\"session.timer.last\";i:1268333716;s:17:\"session.timer.now\";i:1268333720;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:\"43\";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:6:{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\";}}'
      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 = 122)
      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 = 77
      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:55:28' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-11 18:55:28' )   )    OR  ( a.state = -1 )  )
  10. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='77'
  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 = 122 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='121204'
  19. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='191'
      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`='191'
  21. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121004'
  22. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='132'
      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`='132'
  24. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='111102'
  25. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='120'
      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`='120'
  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 < '1268332828' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'c17bo2uvvgbphvin97rcf85ee7'
  4. UPDATE `jos_session`
      SET `time`='1268333728',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1268333716;s:18:\"session.timer.last\";i:1268333716;s:17:\"session.timer.now\";i:1268333720;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:\"43\";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:6:{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\";}}'
      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 = 122)
      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 = 77
      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:55:28' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-11 18:55:28' )   )    OR  ( a.state = -1 )  )
  10. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='77'
  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 = 122 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='121204'
  19. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='191'
      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`='191'
  21. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121004'
  22. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='132'
      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`='132'
  24. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='111102'
  25. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='120'
      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`='120'
  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