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
Hygiene Essentials
Home hygiene essentials

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
hygiene-essentials2

A carefully selected range of items every beauty lover, makeup pro, student and educator should have in their kit. A great "sealed" large/small pencil sharpener so you don't cross-contaminate and get wax all over your makeup bag, precision mini point cotton buds for fine eyes and perfect pouts (as recommended in June's Tatler), a brilliant dual ended metal spatula, mixing wells and dishes. A must have brilliant space-saving bin to pop lantern bin to pop in all those single use, disposables after use - perfect to keeping brushes in as well (all the top MUA are loving this item - don't miss out).

We offer student and educational bulk kits. Email us at This e-mail address is being protected from spambots. You need JavaScript enabled to view it


Order by:
3 Way Wheel Jar with Lid
3 Way Wheel Jar with Lid
This 10 fl oz three way jar is ideal for neatly decanting and mixing products - perfect for lipstick and gloss.
More Details...
SKU: 111201
Price: £1.50
Average customer rating:
0 stars  Total votes: 0

Black Plastic Spatula
Black Plastic Spatula
A hygiene kit essential, use these black spatulas to transfer product to a mixing palette, jar or bac...
More Details...
SKU: 101101
Pack of 25
Price: £2.00
Average customer rating:
0 stars  Total votes: 0

Brush & Hygiene Applicator Holder
Brush & Hygiene Applicator Holder
Organise applicators and sundries hygienically in this lightweight handy clear plastic organiser. Products not included.
More Details...
SKU: 121213
Price: £13.50
Average customer rating:
0 stars  Total votes: 0

Chrome 6 Well Mixing Palette
Chrome 6 Well Mixing Palette
A hygiene kit essential, 6 well palette for decanting liquid and other makeup products with spatulas.
More Details...
SKU: 111102
1
Price: £3.50
Average customer rating:
0 stars  Total votes: 0

Collapsible Lantern Bin
Collapsible Lantern Bin
This handy and net collapsible lantern bin is fast becoming an insider secret for every pro and makeup lover.
More Details...
SKU: 119901
Price: £3.99
Average customer rating:
0 stars  Total votes: 0

Dual Large and Small Sharpener with Flip Top Lid
Dual Large and Small Sharpener with Flip Top Lid
A hygiene kit essential, keep bacteria from shavings locked up in the compartment while you work.
More Details...
SKU: 119907
Price: £2.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

Eyebrow Razor Disposable
Eyebrow Razor Disposable
Create shape around the eyebrow, and remove coarse hair with this disposable stainless steel razor blade....
More Details...
SKU: 101024
Pack of 5
Price: £2.50
Average customer rating:
0 stars  Total votes: 0

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

Hand Sanitiser Clip
Hand Sanitiser Clip
These belt clips, complete with retractable extending cord, easily attachs to a belt...
More Details...
SKU: 119905A
Price: £1.99
Average customer rating:
0 stars  Total votes: 0

Hand Sanitiser Pump (60ml)
Hand Sanitiser Pump (60ml)
This pocket sized instant hand sanitizer ensures clean hands anytime, anywhere. Fragrance free, this...
More Details...
SKU: 119905
Price: £2.99
Average customer rating:
0 stars  Total votes: 0

Large Static Sifter Labels
Large Static Sifter Labels
A hygiene essential, keep cross contamination to a thing of the past with these sifter labels. Ideal...
More Details...
SKU: 111203
Pack of 10
Price: £1.50
Average customer rating:
0 stars  Total votes: 0

Latex Free Sponges
Latex Free Sponges
Latex-free, smooth easy to use black wedge-shaped sponges for blending or applying a variety of prod...
More Details...
SKU: 101013
Pack of 8
Price: £1.50
Average customer rating:
0 stars  Total votes: 0

Makeover Capes
Makeover Capes
Keep clients spotless with these simple makeover capes with great coverage to catch any unwanted pro...
More Details...
SKU: 109903
Pack of 2
Price: £4.50
Average customer rating:
0 stars  Total votes: 0

Medium Static Sifter Labels
Medium Static Sifter Labels
A hygiene essential, keep cross contamination to a thing of the past with these sifter labels. Ideal...
More Details...
SKU: 111202
Pack of 10
Price: £1.50
Average customer rating:
0 stars  Total votes: 0

Metal Spatula
Metal Spatula
Exceptional quality stainless steel metal spatula with scoop and pointed end to transfer product whe...
More Details...
SKU: 111101
Price: £5.00
Average customer rating:
0 stars  Total votes: 0

Precision Mini Point Cotton Buds
Precision Mini Point Cotton Buds
25% discount - as recommended buy Tatler, precision q-tips for perfect touch up, lips and eyes.
More Details...
SKU: 109901
Pack of 25
Price: £2.50
Average customer rating:
0 stars  Total votes: 0

Round/Point Dual Ended Cotton Buds
Round/Point Dual Ended Cotton Buds
A kit essential for fixing, cleaning and dealing with the details. Two different tips for multipurpo...
More Details...
SKU: 109902
Pack of 50
Price: £1.75
Average customer rating:
0 stars  Total votes: 0


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


Display #  
Results 1 - 18 of 18

Featured Products

Makeover Capes

 £4.50
Makeover Capes

Keep clients spotless with these simple makeover capes with great coverage to catch any unwanted pro...

Latex Free Sponges

 £1.50
Latex Free Sponges

Latex-free, smooth easy to use black wedge-shaped sponges for blending or applying a variety of prod...

Chrome 6 Well Mixing Palette

 £3.50
Chrome 6 Well Mixing Palette

A hygiene kit essential, 6 well palette for decanting liquid and other makeup products with spatulas.

Precision Mini Point Cotton Buds

 £2.50
Precision Mini Point Cotton Buds

25% discount - as recommended buy Tatler, precision q-tips for perfect touch up, lips and eyes.

Metal Spatula

 £5.00
Metal Spatula

Exceptional quality stainless steel metal spatula with scoop and pointed end to transfer product whe...

Collapsible Lantern Bin

 £3.99
Collapsible Lantern Bin

This handy and net collapsible lantern bin is fast becoming an insider secret for every pro and makeup lover.

Hand Sanitiser Clip

 £1.99
Hand Sanitiser Clip

These belt clips, complete with retractable extending cord, easily attachs to a belt...

3 Way Wheel Jar with Lid

 £1.50
3 Way Wheel Jar with Lid

This 10 fl oz three way jar is ideal for neatly decanting and mixing products - perfect for lipstick and gloss.

Dual Large and Small Sharpener with Flip Top Lid

 £2.00
Dual Large and Small Sharpener with Flip Top Lid

A hygiene kit essential, keep bacteria from shavings locked up in the compartment while you work.

Black Plastic Spatula

 £2.00
Black Plastic Spatula

A hygiene kit essential, use these black spatulas to transfer product to a mixing palette, jar or bac...


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

Latex Free Sponges
Latex Free Sponges
"Fab Four" Mascara Brush Collection

"Famous Five" Mascara Brush Collection

Random Products

PVC Bag Small Square
PVC Bag Small Square
Large Plastic Bottle (118ml)
Large Plastic Bottle (118ml)
"Curvy Carolina" Curved 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.002 seconds, 0.21 MB
Application afterInitialise: 0.189 seconds, 3.87 MB
Application afterRoute: 0.206 seconds, 4.52 MB
Application afterDispatch: 0.664 seconds, 10.50 MB
Application afterRender: 0.829 seconds, 11.53 MB

Memory Usage

12129488

296 queries logged

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

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  237. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='101'
  238. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=101
  239. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=101
  240. 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`='104'
  241. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='104'
  242. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=104
  243. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=104
  244. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='120'
  245. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='120'
  246. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=120
  247. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=120
  248. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='99'
  249. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=99
  250. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=99
  251. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='119'
  252. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=119
  253. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=119
  254. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='107'
  255. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=107
  256. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=107
  257. 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`='112'
  258. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='112'
  259. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=112
  260. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=112
  261. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='116'
  262. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=116
  263. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=116
  264. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='114'
  265. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=114
  266. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=114
  267. 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`='106'
  268. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='106'
  269. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=106
  270. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=106
  271. 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 = 73 OR mm.menuid = 0 )
      ORDER BY position, ordering
  272. SELECT products_per_row
      FROM jos_vm_category
      WHERE category_id=39
  273. 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
  274. 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
  275. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='101013'
  276. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='104'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  277. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='101029'
  278. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='234'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  279. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='101030'
  280. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='235'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  281. SELECT DISTINCT product_sku
      FROM jos_vm_product
      WHERE product_parent_id=''
      AND vendor_id='1'
      AND jos_vm_product.product_publish='Y'
      ORDER BY product_name DESC
  282. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121706'
  283. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='124'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  284. 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`='124'
  285. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121211'
  286. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='200'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  287. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='101009'
  288. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='80'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  289. 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`='80'
  290. 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
  291. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121216'
  292. 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
  293. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='156222'
  294. 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
  295. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='111104'
  296. 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

296 legacy queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'tsj8pgqg5e8t9ddiqn96ps6fc1'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1268276048' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'tsj8pgqg5e8t9ddiqn96ps6fc1'
  4. UPDATE `jos_session`
      SET `time`='1268276948',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:13;s:19:\"session.timer.start\";i:1268276692;s:18:\"session.timer.last\";i:1268276932;s:17:\"session.timer.now\";i:1268276944;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:\"37\";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:79:{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:1268276800;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:259;a:4:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:223;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276932;}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:1268276932;}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:1268276932;}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:1268276932;}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:1268276932;}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:1268276932;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:116;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:93;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:101;a:1:{s:7:\"flypage\";s:18:\"flypage_images.tpl\";}i:149;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:121;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:191;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:206;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:207;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:205;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:187;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:188;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:202;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:200;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:186;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:185;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:199;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:194;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:184;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:198;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:132;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276783;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:227;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:138;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:136;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:232;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:233;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:228;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276747;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:236;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:235;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:234;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:134;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:135;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:146;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276764;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:257;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:147;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:144;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:150;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:145;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:256;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276765;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:258;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276783;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:211;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:129;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:133;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:157;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:213;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:130;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276782;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:158;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276783;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:131;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276783;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";s:7:\"flypage\";s:11:\"flypage.tpl\";}i:87;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:81;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:247;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276800;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:242;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276800;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:248;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276800;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:243;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276800;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:244;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276800;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:245;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276800;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:246;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276800;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:250;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276800;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:255;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276800;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:249;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276800;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:241;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276800;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:251;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276800;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:254;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1268276800;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1500\";}i:253;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:12