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
Tools & Brushes
Home kit tools & accessories tools & brushes

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

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

Tools & Brushes


Order by:
6 Piece Synthetic Brush Set
6 Piece Synthetic Brush Set
25% off this amazing 6 piece synthetic brush set - road tested by pro artists - brilliant quality and value.
More Details...
SKU: 121006
Price: £15.00
Average customer rating:
0 stars  Total votes: 0

7 Piece Natural + Synthetic Brush Case Set
7 Piece Natural + Synthetic Brush Case Set
7 piece personal makeup brush set in a case with a great internal pocket to pop in your range of disposable mascara wands.
More Details...
SKU: 121007
Price: £30.00
Average customer rating:
0 stars  Total votes: 0

Colour Wheel
Colour Wheel
The indispensible colourwheel is a must have in all makeup bags. Ensure you never put a foot wrong a...
More Details...
SKU: 121101
Price: £4.50
Average customer rating:
0 stars  Total votes: 0

Deluxe Velour Puff
Deluxe Velour Puff
Use this deluxe velour puff with satin band to pick up, hold and apply any powder products to the fa...
More Details...
SKU: 121002
Price: £4.00
Average customer rating:
0 stars  Total votes: 0

Ergonomic Stainless Steel Tweezers
Ergonomic Stainless Steel Tweezers
30% discount these high qualilty ergonomically-designed stainless steel tweezers.
More Details...
SKU: 121427
piece
Price: £10.00
Average customer rating:
0 stars  Total votes: 0

Essential Tool Starter Kit
Essential Tool Starter Kit
Brilliant essential makeup artist pro kit of "must have" tools and represents 15% disount. Great for course and college starters.
More Details...
SKU: 111104
piece
Price: £20.40
Average customer rating:
0 stars  Total votes: 0

Eye Brow Dual Brush & Comb
Eye Brow Dual Brush & Comb
This dual head brush features a synthetic-bristle brush for grooming brows, and a plastic comb for ...
More Details...
SKU: 121005
Price: £2.50
Average customer rating:
0 stars  Total votes: 0

Flat Head Black Tweezer
Flat Head Black Tweezer
Black flat head stainless steel tweezer that makes pulling those unwanted hairs an effortless task....
More Details...
SKU: 121417
Price: £1.99
Average customer rating:
0 stars  Total votes: 0

Handheld Mirror
Handheld Mirror
25% discount on this quality black hand held mirror for home and pro use.
More Details...
SKU: 121103
Price: £5.00
Average customer rating:
0 stars  Total votes: 0

Natural Hair Kabuki Brush with Black Handle
Natural Hair Kabuki Brush with Black Handle
25% discount on this high quality natural hair kabuki brush. Essential for all kits and home beauty bags.
More Details...
SKU: 121003
Price: £17.50
Average customer rating:
0 stars  Total votes: 0

Natural Hair Long Handled Blush, Highlight & Contour Brush
Natural Hair Long Handled Blush, Highlight & Contour Brush
25% discount on this sleek natural hair blush/bronze brush for personal and pro use.
More Details...
SKU: 121004
Price: £9.00
Average customer rating:
0 stars  Total votes: 0

Pointed Black Tweezer
Pointed Black Tweezer
Black stainless stell pointed tip tweezer perfect for stubble and ingorwn hair...
More Details...
SKU: 121418
Price: £2.99
Average customer rating:
0 stars  Total votes: 0

Single Use Essentials Kit
Single Use Essentials Kit
Tried and tested single use and disposable essential starter kit. Truly the most important part of your kit.
More Details...
SKU: 101033
piece
Price: £51.40
Average customer rating:
0 stars  Total votes: 0

Synthetic Hair Kabuki Brush with Aluminum Handle
Synthetic Hair Kabuki Brush with Aluminum Handle
25% discount on this luxuriously soft synthetic hair kabuki brush.
More Details...
SKU: 121008
Price: £15.00
Average customer rating:
0 stars  Total votes: 0


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


Display #  
Results 1 - 14 of 14

Featured Products

Ergonomic Stainless Steel Tweezers

 £10.00
Ergonomic Stainless Steel Tweezers

30% discount these high qualilty ergonomically-designed stainless steel tweezers.

Synthetic Hair Kabuki Brush with Aluminum Handle

 £15.00
Synthetic Hair Kabuki Brush with Aluminum Handle

25% discount on this luxuriously soft synthetic hair kabuki brush.

Handheld Mirror

 £5.00
Handheld Mirror

25% discount on this quality black hand held mirror for home and pro use.

Natural Hair Long Handled Blush, Highlight & Contour Brush

 £9.00
Natural Hair Long Handled Blush, Highlight & Contour Brush

25% discount on this sleek natural hair blush/bronze brush for personal and pro use.

Single Use Essentials Kit

 £51.40
Single Use Essentials Kit

Tried and tested single use and disposable essential starter kit. Truly the most important part of your kit.

6 Piece Synthetic Brush Set

 £15.00
6 Piece Synthetic Brush Set

25% off this amazing 6 piece synthetic brush set - road tested by pro artists - brilliant quality and value.

Natural Hair Kabuki Brush with Black Handle

 £17.50
Natural Hair Kabuki Brush with Black Handle

25% discount on this high quality natural hair kabuki brush. Essential for all kits and home beauty bags.

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

Ergonomic Stainless Steel Tweezers
Ergonomic Stainless Steel Tweezers
"Liquid Lily" NEW! Long Tipped Eyeliner Applicator

"Particular Polly" Mini Precision Mascara Brush

Latest Products

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

Profile Information

Application afterLoad: 0.001 seconds, 0.21 MB
Application afterInitialise: 0.182 seconds, 3.85 MB
Application afterRoute: 0.199 seconds, 4.50 MB
Application afterDispatch: 0.548 seconds, 10.41 MB
Application afterRender: 0.689 seconds, 11.41 MB

Memory Usage

12003160

229 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'tsj8pgqg5e8t9ddiqn96ps6fc1'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1268275882' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'tsj8pgqg5e8t9ddiqn96ps6fc1'
  4. UPDATE `jos_session`
      SET `time`='1268276782',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:8;s:19:\"session.timer.start\";i:1268276692;s:18:\"session.timer.last\";i:1268276759;s:17:\"session.timer.now\";i:1268276764;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:\"53\";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:51:{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:1268276765;}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:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}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:1268276764;}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:1268276764;}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:1268276764;}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:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";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 = 164)
      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`=47
     
      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='47'
  16. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='47'
  17. SELECT category_parent_id
      FROM jos_vm_category_xref
      WHERE category_child_id='47'
  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='47'
      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='47'
      AND jos_vm_category.category_id='47'
  20. SELECT category_id, category_name,category_parent_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='33'
      AND jos_vm_category.category_id='33'
  21. 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`=47
     
      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
  22. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=134
  23. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='134'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  24. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=134
  25. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  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=134
      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='134'
  29. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='134'
  30. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=134
      AND `file_published`=1
  31. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='134'
  32. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=134
  33. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=134
  34. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=135
  35. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='135'
      AND (start_date<='1268276782' 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=135
  37. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  38. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=135
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  39. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='135'
  40. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='135'
  41. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=135
      AND `file_published`=1
  42. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='135'
  43. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=135
  44. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=135
  45. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=211
  46. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='211'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  47. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=211
  48. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  49. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='211'
  50. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=211
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  51. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='211'
  52. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='211'
  53. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=211
      AND `file_published`=1
  54. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='211'
  55. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=211
  56. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=211
  57. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=129
  58. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='129'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  59. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=129
  60. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  61. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='129'
  62. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=129
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  63. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='129'
  64. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='129'
  65. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=129
      AND `file_published`=1
  66. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='129'
  67. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=129
  68. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=129
  69. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=257
  70. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='257'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  71. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=257
  72. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  73. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=257
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  74. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='257'
  75. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='257'
  76. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=257
      AND `file_published`=1
  77. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='257'
  78. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=257
  79. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=257
  80. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=259
  81. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='259'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  82. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=259
  83. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  84. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=259
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  85. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='259'
  86. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='259'
  87. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=259
      AND `file_published`=1
  88. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='259'
  89. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=259
  90. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=259
  91. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=133
  92. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='133'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  93. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=133
  94. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  95. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='133'
  96. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=133
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  97. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='133'
  98. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='133'
  99. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=133
      AND `file_published`=1
  100. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='133'
  101. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=133
  102. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=133
  103. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=157
  104. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='157'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  105. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=157
  106. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  107. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='157'
  108. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=157
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  109. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='157'
  110. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='157'
  111. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=157
      AND `file_published`=1
  112. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='157'
  113. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=157
  114. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=157
  115. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=213
  116. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='213'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  117. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=213
  118. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  119. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='213'
  120. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=213
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  121. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='213'
  122. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='213'
  123. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=213
      AND `file_published`=1
  124. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='213'
  125. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=213
  126. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=213
  127. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=130
  128. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='130'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  129. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=130
  130. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  131. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='130'
  132. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=130
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  133. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='130'
  134. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='130'
  135. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=130
      AND `file_published`=1
  136. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='130'
  137. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=130
  138. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=130
  139. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=132
  140. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='132'
      AND (start_date<='1268276783' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  141. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=132
  142. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276783' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  143. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='132'
  144. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=132
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  145. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='132'
  146. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='132'
  147. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=132
      AND `file_published`=1
  148. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='132'
  149. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=132
  150. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=132
  151. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=158
  152. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='158'
      AND (start_date<='1268276783' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  153. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=158
  154. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276783' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  155. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='158'
  156. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=158
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  157. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='158'
  158. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='158'
  159. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=158
      AND `file_published`=1
  160. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='158'
  161. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=158
  162. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=158
  163. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=258
  164. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='258'
      AND (start_date<='1268276783' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  165. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=258
  166. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276783' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=258
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  168. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='258'
  169. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='258'
  170. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=258
      AND `file_published`=1
  171. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='258'
  172. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=258
  173. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=258
  174. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=131
  175. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='131'
      AND (start_date<='1268276783' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  176. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=131
  177. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276783' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  178. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='131'
  179. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=131
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  180. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='131'
  181. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='131'
  182. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=131
      AND `file_published`=1
  183. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='131'
  184. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=131
  185. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=131
  186. 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='47'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  187. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='257'
  188. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=257
  189. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=257
  190. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='131'
  191. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='131'
  192. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=131
  193. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=131
  194. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='213'
  195. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='213'
  196. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=213
  197. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=213
  198. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='132'
  199. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=132
  200. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=132
  201. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='258'
  202. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=258
  203. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=258
  204. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='134'
  205. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=134
  206. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=134
  207. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='130'
  208. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='130'
  209. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=130
  210. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=130
  211. 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 = 164 OR mm.menuid = 0 )
      ORDER BY position, ordering
  212. SELECT products_per_row
      FROM jos_vm_category
      WHERE category_id=47
  213. 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
  214. 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
  215. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121427'
  216. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='257'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  217. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='101020'
  218. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='87'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  219. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='87'
  220. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='101010'
  221. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='81'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  222. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='81'
  223. 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
  224. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121216'
  225. 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
  226. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='156222'
  227. 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
  228. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='111104'
  229. 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

229 legacy queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'tsj8pgqg5e8t9ddiqn96ps6fc1'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1268275882' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'tsj8pgqg5e8t9ddiqn96ps6fc1'
  4. UPDATE `jos_session`
      SET `time`='1268276782',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:8;s:19:\"session.timer.start\";i:1268276692;s:18:\"session.timer.last\";i:1268276759;s:17:\"session.timer.now\";i:1268276764;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:\"53\";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:51:{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:1268276765;}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:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}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:1268276764;}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:1268276764;}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:1268276764;}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:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";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 = 164)
      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`=47
     
      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='47'
  16. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='47'
  17. SELECT category_parent_id
      FROM jos_vm_category_xref
      WHERE category_child_id='47'
  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='47'
      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='47'
      AND jos_vm_category.category_id='47'
  20. SELECT category_id, category_name,category_parent_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='33'
      AND jos_vm_category.category_id='33'
  21. 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`=47
     
      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
  22. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=134
  23. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='134'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  24. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=134
  25. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  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=134
      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='134'
  29. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='134'
  30. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=134
      AND `file_published`=1
  31. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='134'
  32. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=134
  33. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=134
  34. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=135
  35. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='135'
      AND (start_date<='1268276782' 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=135
  37. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  38. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=135
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  39. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='135'
  40. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='135'
  41. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=135
      AND `file_published`=1
  42. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='135'
  43. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=135
  44. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=135
  45. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=211
  46. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='211'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  47. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=211
  48. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  49. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='211'
  50. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=211
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  51. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='211'
  52. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='211'
  53. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=211
      AND `file_published`=1
  54. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='211'
  55. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=211
  56. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=211
  57. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=129
  58. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='129'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  59. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=129
  60. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  61. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='129'
  62. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=129
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  63. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='129'
  64. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='129'
  65. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=129
      AND `file_published`=1
  66. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='129'
  67. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=129
  68. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=129
  69. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=257
  70. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='257'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  71. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=257
  72. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  73. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=257
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  74. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='257'
  75. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='257'
  76. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=257
      AND `file_published`=1
  77. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='257'
  78. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=257
  79. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=257
  80. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=259
  81. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='259'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  82. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=259
  83. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  84. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=259
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  85. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='259'
  86. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='259'
  87. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=259
      AND `file_published`=1
  88. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='259'
  89. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=259
  90. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=259
  91. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=133
  92. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='133'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  93. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=133
  94. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  95. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='133'
  96. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=133
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  97. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='133'
  98. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='133'
  99. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=133
      AND `file_published`=1
  100. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='133'
  101. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=133
  102. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=133
  103. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=157
  104. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='157'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  105. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=157
  106. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  107. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='157'
  108. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=157
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  109. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='157'
  110. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='157'
  111. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=157
      AND `file_published`=1
  112. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='157'
  113. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=157
  114. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=157
  115. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=213
  116. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='213'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  117. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=213
  118. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  119. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='213'
  120. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=213
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  121. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='213'
  122. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='213'
  123. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=213
      AND `file_published`=1
  124. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='213'
  125. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=213
  126. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=213
  127. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=130
  128. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='130'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  129. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=130
  130. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276782' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  131. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='130'
  132. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=130
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  133. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='130'
  134. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='130'
  135. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=130
      AND `file_published`=1
  136. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='130'
  137. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=130
  138. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=130
  139. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=132
  140. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='132'
      AND (start_date<='1268276783' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  141. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=132
  142. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276783' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  143. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='132'
  144. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=132
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  145. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='132'
  146. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='132'
  147. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=132
      AND `file_published`=1
  148. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='132'
  149. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=132
  150. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=132
  151. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=158
  152. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='158'
      AND (start_date<='1268276783' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  153. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=158
  154. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276783' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  155. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='158'
  156. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=158
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  157. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='158'
  158. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='158'
  159. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=158
      AND `file_published`=1
  160. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='158'
  161. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=158
  162. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=158
  163. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=258
  164. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='258'
      AND (start_date<='1268276783' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  165. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=258
  166. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276783' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=258
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  168. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='258'
  169. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='258'
  170. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=258
      AND `file_published`=1
  171. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='258'
  172. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=258
  173. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=258
  174. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=131
  175. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='131'
      AND (start_date<='1268276783' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  176. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=131
  177. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268276783' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
  178. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1