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
Airbrushing
Home airbrushing

Notice: Use of undefined constant category_id - assumed 'category_id' in /var/www/vhosts/thepromakeupstore.co.uk/httpdocs/administrator/components/com_virtuemart/classes/ps_product_category.php on line 1245
Print
airbrushing2

Airbrushing designed by professionals for professionals is one of the fastest growing beauty makeup application techniques in the industry. We are pleased to be working with AIRBASE and offer you their great range of silicone based foundations, blusher and bronzer along with the appropriate primer, cleaning goodies and, of course, the amazing airbrush.

Designed by Oscar-nominated makeup artist, Anni Buchanan, the silicone based products produce amazing results. It is long lasting, provides a flawless finish, allows skin to breathe, doesn't require touch ups, looks smooth and natural and can be applied both with the airbrush as well as with a good foundation brush or fingers. It provides durability to the film and beauty industry that makeup requires with the practicability of every day makeup. Perfect for brides (stays put even through tears), for professional makeup artists, salon owners and for everyday consumers.


Order by:
Airbase 01 blush shade 30 ml
Airbase 01 blush shade 30 ml
Airbase silicone blush 02 shade. A warm, rosey tone for perfect blush, this beautiful shade will add definition or highlight.
More Details...
SKU: 156207
piece
Price: £29.95
Average customer rating:
0 stars  Total votes: 0

Airbase 01 foundation 30 ml
Airbase 01 foundation 30 ml
Airbase foundation in 01 shade. Containing both vitamin A and E, this foundation is the palest and perfect for fair caucasion skin.
More Details...
SKU: 156201
piece
Price: £29.95
Average customer rating:
0 stars  Total votes: 0

Airbase 02 blush shade 30 ml
Airbase 02 blush shade 30 ml
Airbase silicone blush 02 shade. A softer, peachy shade for beautiful warmth and natural beauty.
More Details...
SKU: 156208
piece
Price: £29.95
Average customer rating:
0 stars  Total votes: 0

Airbase 02 foundation 30 ml
Airbase 02 foundation 30 ml
Airbase foundation in 02 shade for fair skin. Not as pale as 01 and a great all rounder along with shade 03.
More Details...
SKU: 156202
piece
Price: £29.95
Average customer rating:
0 stars  Total votes: 0

Airbase 03 foundation 30 ml
Airbase 03 foundation 30 ml
Airbase foundation in 03 shade. One of the two most popular shades of this flawless finish silicone makeup.
More Details...
SKU: 156203
piece
Price: £29.95
Average customer rating:
0 stars  Total votes: 0

Airbase 04 foundation 30 ml
Airbase 04 foundation 30 ml
Airbase shade 04 is for darker compexions and mixes well with 01 and 02 for the pefect match.
More Details...
SKU: 156204
piece
Price: £29.95
Average customer rating:
0 stars  Total votes: 0

Airbase 05 foundation 30 ml
Airbase 05 foundation 30 ml
Airbase 05 shade foundation. The darkest tone which when mixed with shade 01 or 02, is pefect for Asian skin tones. Full of vitamin A & E.
More Details...
SKU: 156205
piece
Price: £29.95
Average customer rating:
0 stars  Total votes: 0

Airbase airbrush & compressor
Airbase airbrush & compressor
Airbase airbrush and compressor designed for application of silicone based makeup. Neat and light weight for pro and home use.
More Details...
SKU: 156215
piece
Price: £134.95
Average customer rating:
0 stars  Total votes: 0

Airbase airbrush cleaner (100 ml)
Airbase airbrush cleaner (100 ml)
Airbase Cleaner for airbrush is required to keep your airbrush in working condition. An absolute must have.
More Details...
SKU: 156212
piece
Price: £17.50
Average customer rating:
0 stars  Total votes: 0

Airbase bronzer 30 ml
Airbase bronzer 30 ml
Bronzer that adds a wonderful glow to all skin types whilst also adding contour and definition.
More Details...
SKU: 156209
piece
Price: £29.95
Average customer rating:
0 stars  Total votes: 0

Airbase primer 30 ml
Airbase primer 30 ml
Airbase Primer. Prepare the skin for a perfect base for the silicone based foundation.
More Details...
SKU: 156211
piece
Price: £39.95
Average customer rating:
0 stars  Total votes: 0

Airbase professional package
Airbase professional package
For the professionally trained makeup artist, a complete kit for all types of application and clients.
More Details...
SKU: 156220
piece
Price: £324.95
Average customer rating:
0 stars  Total votes: 0

Airbase rechargable battery
Airbase rechargable battery
A second battery for the rechargable battery set. Keep both charged up and have your spare ready.
More Details...
SKU: 156217
1
Price: £60.00
Average customer rating:
0 stars  Total votes: 0

Airbase wireless pack
Airbase wireless pack
Portable battery pack for the airbrush for times when there is no electricity.
More Details...
SKU: 156216
piece
Price: £95.00
Average customer rating:
0 stars  Total votes: 0

Airbrush starter kit
Airbrush starter kit
Perfect starter kit for pros or home use representing 15% discount.
More Details...
SKU: 156222
4
Price: £183.13
Average customer rating:
0 stars  Total votes: 0

Cleansing mitt
Cleansing mitt
This cleansing mitt removes Airbase makeup without the need for cleanser. Resusable by washing at 40 degrees.
More Details...
SKU: 156213
piece
Price: £5.00
Average customer rating:
0 stars  Total votes: 0

Fine Tip Cleaner (Airbrush)
Fine Tip Cleaner (Airbrush)
This handy fine tipped gem can be used for numerous tasks; ultra precision and blending. Cleans your airbrush nozzel.
More Details...
SKU: 101023
Pack of 100
Price: £7.50
Average customer rating:
0 stars  Total votes: 0


  • «« Start
  • « Prev
  • 1
  • Next »
  • End »»


Display #  
Results 1 - 17 of 17

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

Flare individual false eyelashes
Flare individual false eyelashes
Handheld Mirror
Handheld Mirror
Synthetic Hair Kabuki Brush with Aluminum Handle
Synthetic Hair Kabuki Brush with Aluminum Handle

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.85 MB
Application afterRoute: 0.201 seconds, 4.51 MB
Application afterDispatch: 0.535 seconds, 10.44 MB
Application afterRender: 0.682 seconds, 11.43 MB

Memory Usage

12025216

242 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'tsj8pgqg5e8t9ddiqn96ps6fc1'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1268275900' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'tsj8pgqg5e8t9ddiqn96ps6fc1'
  4. UPDATE `jos_session`
      SET `time`='1268276800',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:9;s:19:\"session.timer.start\";i:1268276692;s:18:\"session.timer.last\";i:1268276764;s:17:\"session.timer.now\";i:1268276782;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:\"dd141e6c2c95e2049bee72e1cb824f15\";}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:\"47\";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:61:{i:99;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:226;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:237;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:262;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:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:260;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:1268276764;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:259;a:4:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:223;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276702;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:222;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276702;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:224;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276702;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:225;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276702;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:107;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:239;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276702;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:116;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:93;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:101;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:149;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:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:121;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:191;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:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:206;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:207;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:205;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:187;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:188;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:202;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:200;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:186;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:185;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:199;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:194;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:184;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:198;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:132;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:1268276783;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:227;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:138;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:136;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:232;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:233;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:228;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:236;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:235;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:234;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:134;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:135;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:146;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276764;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:257;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:147;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:144;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:150;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:145;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:256;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:258;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276783;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:211;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:129;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:133;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:157;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:213;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:130;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:158;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276783;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:131;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276783;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:87;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:81;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}}'
      WHERE session_id='tsj8pgqg5e8t9ddiqn96ps6fc1'
  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 = 67)
      ORDER BY menuid DESC
      LIMIT 0, 1
  9. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  10. 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'
  11. 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`);
  12. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  13. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  14. SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) AS num_rows
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=43
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND ((`product_parent_id`='0') OR (`product_parent_id`=''))
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
  15. SELECT category_id, category_name
      FROM jos_vm_category
      WHERE category_id='43'
  16. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='43'
  17. SELECT category_parent_id
      FROM jos_vm_category_xref
      WHERE category_child_id='43'
  18. SELECT category_id, category_thumb_image, category_child_id,category_name
      FROM jos_vm_category,jos_vm_category_xref
      WHERE jos_vm_category_xref.category_parent_id='43'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      AND jos_vm_category.vendor_id='1'
      AND jos_vm_category.category_publish='Y'
      ORDER BY jos_vm_category.list_order, jos_vm_category.category_name ASC
  19. SELECT category_id, category_name,category_parent_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='43'
      AND jos_vm_category.category_id='43'
  20. SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`jos_vm_category`.`category_id`,
                                    `jos_vm_product`.`product_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`,
                                    `product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`, `product_unit`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=43
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND ((`product_parent_id`='0') OR (`product_parent_id`=''))
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 0, 20
  21. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=247
  22. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='247'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  23. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=247
  24. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  25. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='247'
  26. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  27. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=247
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  28. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='247'
  29. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='247'
  30. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=247
      AND `file_published`=1
  31. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='247'
  32. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=247
  33. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=247
  34. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=242
  35. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='242'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  36. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=242
  37. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  38. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='242'
  39. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=242
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  40. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='242'
  41. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='242'
  42. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=242
      AND `file_published`=1
  43. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='242'
  44. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=242
  45. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=242
  46. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=248
  47. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='248'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  48. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=248
  49. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  50. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='248'
  51. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=248
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  52. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='248'
  53. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='248'
  54. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=248
      AND `file_published`=1
  55. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='248'
  56. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=248
  57. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=248
  58. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=243
  59. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='243'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  60. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=243
  61. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  62. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='243'
  63. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=243
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  64. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='243'
  65. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='243'
  66. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=243
      AND `file_published`=1
  67. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='243'
  68. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=243
  69. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=243
  70. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=244
  71. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='244'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  72. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=244
  73. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  74. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='244'
  75. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=244
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  76. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='244'
  77. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='244'
  78. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=244
      AND `file_published`=1
  79. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='244'
  80. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=244
  81. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=244
  82. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=245
  83. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='245'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  84. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=245
  85. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  86. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='245'
  87. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=245
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  88. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='245'
  89. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='245'
  90. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=245
      AND `file_published`=1
  91. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='245'
  92. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=245
  93. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=245
  94. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=246
  95. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='246'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  96. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=246
  97. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  98. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='246'
  99. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=246
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  100. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='246'
  101. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='246'
  102. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=246
      AND `file_published`=1
  103. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='246'
  104. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=246
  105. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=246
  106. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=250
  107. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='250'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  108. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=250
  109. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  110. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='250'
  111. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=250
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  112. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='250'
  113. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='250'
  114. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=250
      AND `file_published`=1
  115. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='250'
  116. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=250
  117. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=250
  118. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=255
  119. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='255'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  120. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=255
  121. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  122. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='255'
  123. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=255
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  124. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='255'
  125. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='255'
  126. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=255
      AND `file_published`=1
  127. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='255'
  128. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=255
  129. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=255
  130. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=249
  131. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='249'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  132. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=249
  133. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  134. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='249'
  135. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=249
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  136. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='249'
  137. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='249'
  138. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=249
      AND `file_published`=1
  139. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='249'
  140. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=249
  141. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=249
  142. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=241
  143. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='241'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  144. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=241
  145. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  146. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='241'
  147. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=241
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  148. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='241'
  149. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='241'
  150. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=241
      AND `file_published`=1
  151. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='241'
  152. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=241
  153. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=241
  154. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=251
  155. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='251'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  156. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=251
  157. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  158. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='251'
  159. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=251
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  160. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='251'
  161. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='251'
  162. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=251
      AND `file_published`=1
  163. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='251'
  164. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=251
  165. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=251
  166. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=254
  167. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='254'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  168. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=254
  169. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  170. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='254'
  171. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=254
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  172. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='254'
  173. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='254'
  174. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=254
      AND `file_published`=1
  175. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='254'
  176. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=254
  177. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=254
  178. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=253
  179. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='253'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  180. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=253
  181. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  182. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='253'
  183. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=253
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  184. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='253'
  185. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='253'
  186. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=253
      AND `file_published`=1
  187. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='253'
  188. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=253
  189. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=253
  190. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=260
  191. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='260'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  192. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=260
  193. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  194. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=260
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  195. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='260'
  196. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='260'
  197. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=260
      AND `file_published`=1
  198. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='260'
  199. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=260
  200. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=260
  201. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=252
  202. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='252'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  203. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=252
  204. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  205. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='252'
  206. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=252
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  207. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='252'
  208. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='252'
  209. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=252
      AND `file_published`=1
  210. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='252'
  211. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=252
  212. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=252
  213. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=98
  214. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='98'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  215. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=98
  216. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  217. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='98'
  218. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=98
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  219. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='98'
  220. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='98'
  221. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=98
      AND `file_published`=1
  222. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='98'
  223. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=98
  224. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=98
  225. SELECT DISTINCT product_sku,jos_vm_product.product_id,product_name,product_s_desc,product_thumb_image, product_full_image, product_in_stock, product_url
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE
    (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')

      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id

      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id

      AND jos_vm_category.category_id='43'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  226. 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 = 67 OR mm.menuid = 0 )
      ORDER BY position, ordering
  227. SELECT products_per_row
      FROM jos_vm_category
      WHERE category_id=43
  228. 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
  229. 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
  230. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121410'
  231. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='150'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  232. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121103'
  233. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='213'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  234. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121008'
  235. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='131'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  236. 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
  237. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121216'
  238. 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
  239. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='156222'
  240. 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
  241. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='111104'
  242. 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

242 legacy queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'tsj8pgqg5e8t9ddiqn96ps6fc1'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1268275900' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'tsj8pgqg5e8t9ddiqn96ps6fc1'
  4. UPDATE `jos_session`
      SET `time`='1268276800',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:9;s:19:\"session.timer.start\";i:1268276692;s:18:\"session.timer.last\";i:1268276764;s:17:\"session.timer.now\";i:1268276782;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:\"dd141e6c2c95e2049bee72e1cb824f15\";}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:\"47\";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:61:{i:99;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:226;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:237;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:262;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:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:260;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:1268276764;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:259;a:4:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:223;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276702;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:222;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276702;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:224;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276702;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:225;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276702;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:107;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:239;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276702;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:116;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:93;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:101;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:149;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:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:121;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:191;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:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:206;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:207;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:205;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:187;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:188;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:202;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:200;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:186;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:185;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:199;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:194;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:184;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:198;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:132;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:1268276783;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:227;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:138;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:136;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:232;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:233;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:228;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:236;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:235;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:234;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:134;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:135;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:146;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276764;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:257;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:147;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:144;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:150;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:145;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:256;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:258;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276783;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:211;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:129;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:133;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:157;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:213;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:130;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:158;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276783;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:131;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276783;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:87;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:81;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}}'
      WHERE session_id='tsj8pgqg5e8t9ddiqn96ps6fc1'
  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 = 67)
      ORDER BY menuid DESC
      LIMIT 0, 1
  9. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  10. 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'
  11. 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`);
  12. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  13. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  14. SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) AS num_rows
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=43
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND ((`product_parent_id`='0') OR (`product_parent_id`=''))
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
  15. SELECT category_id, category_name
      FROM jos_vm_category
      WHERE category_id='43'
  16. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='43'
  17. SELECT category_parent_id
      FROM jos_vm_category_xref
      WHERE category_child_id='43'
  18. SELECT category_id, category_thumb_image, category_child_id,category_name
      FROM jos_vm_category,jos_vm_category_xref
      WHERE jos_vm_category_xref.category_parent_id='43'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      AND jos_vm_category.vendor_id='1'
      AND jos_vm_category.category_publish='Y'
      ORDER BY jos_vm_category.list_order, jos_vm_category.category_name ASC
  19. SELECT category_id, category_name,category_parent_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='43'
      AND jos_vm_category.category_id='43'
  20. SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`jos_vm_category`.`category_id`,
                                    `jos_vm_product`.`product_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`,
                                    `product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`, `product_unit`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=43
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND ((`product_parent_id`='0') OR (`product_parent_id`=''))
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 0, 20
  21. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=247
  22. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='247'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  23. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=247
  24. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  25. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='247'
  26. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  27. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=247
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  28. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='247'
  29. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='247'
  30. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=247
      AND `file_published`=1
  31. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='247'
  32. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=247
  33. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=247
  34. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=242
  35. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='242'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  36. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=242
  37. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  38. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='242'
  39. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=242
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  40. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='242'
  41. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='242'
  42. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=242
      AND `file_published`=1
  43. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='242'
  44. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=242
  45. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=242
  46. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=248
  47. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='248'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  48. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=248
  49. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  50. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='248'
  51. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=248
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  52. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='248'
  53. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='248'
  54. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=248
      AND `file_published`=1
  55. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='248'
  56. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=248
  57. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=248
  58. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=243
  59. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='243'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  60. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=243
  61. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  62. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='243'
  63. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=243
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  64. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='243'
  65. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='243'
  66. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=243
      AND `file_published`=1
  67. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='243'
  68. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=243
  69. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=243
  70. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=244
  71. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='244'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  72. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=244
  73. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  74. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='244'
  75. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=244
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  76. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='244'
  77. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='244'
  78. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=244
      AND `file_published`=1
  79. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='244'
  80. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=244
  81. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=244
  82. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=245
  83. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='245'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  84. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=245
  85. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  86. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='245'
  87. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=245
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  88. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='245'
  89. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='245'
  90. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=245
      AND `file_published`=1
  91. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='245'
  92. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=245
  93. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=245
  94. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=246
  95. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='246'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  96. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=246
  97. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  98. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='246'
  99. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=246
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  100. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='246'
  101. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='246'
  102. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=246
      AND `file_published`=1
  103. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='246'
  104. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=246
  105. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=246
  106. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=250
  107. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='250'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  108. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=250
  109. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  110. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='250'
  111. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=250
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  112. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='250'
  113. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='250'
  114. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=250
      AND `file_published`=1
  115. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='250'
  116. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=250
  117. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=250
  118. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=255
  119. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='255'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  120. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=255
  121. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  122. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='255'
  123. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=255
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  124. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='255'
  125. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='255'
  126. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=255
      AND `file_published`=1
  127. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='255'
  128. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=255
  129. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=255
  130. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=249
  131. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='249'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  132. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=249
  133. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  134. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='249'
  135. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=249
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  136. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='249'
  137. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='249'
  138. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=249
      AND `file_published`=1
  139. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='249'
  140. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=249
  141. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=249
  142. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=241
  143. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='241'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  144. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=241
  145. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276800' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  146. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='241'
  147. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=241
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  148. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='241'
  149. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='241'
  150. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=241
      AND `file_published`=1
  151. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='241'
  152. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=241
  153. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=241