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
New in Store
Home the one to have new in store

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

New in Store

Take a look at our new product lines.  We have just launched our EYELASH WARDROBE along with flawless skin with our range of silicone based foundation and blusher from AIRBASE.  Need great tweezers, look no further - our specially-designed ERGONOMIC STAINLESS STEEL TWEEZERS are brilliant and incredible value at only £10.00. Take a look at our PERSONAL BRUSH SETS - again really affordable compared to the high street.


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

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

CATWALK false eyelashes
CATWALK false eyelashes
25% discount on these fun, funky and definitely cutting edge false eye lashes.
More Details...
SKU: 121406
1
Price: £4.50
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

False Eyelash Kit
False Eyelash Kit
Great value kit, 3 types of lashes, Duo Adhesive and Eylure Lift Off. 10% Saving as a package.
More Details...
SKU: 121407
1
Price: £26.25
Average customer rating:
0 stars  Total votes: 0

False eyelash set (3 types)
False eyelash set (3 types)
Get one set of NATURAL, GLAMOUR and CATWALK false lashes and save with our special launch offer.
More Details...
SKU: 121426
3
Price: £12.10
Average customer rating:
0 stars  Total votes: 0

Flare individual false eyelashes
Flare individual false eyelashes
15% discount on natural single lashes - add old style glamour to the corner of your eyes.
More Details...
SKU: 121410
1
Price: £4.50
Average customer rating:
0 stars  Total votes: 0

GLAMOUR false eyelashes
GLAMOUR false eyelashes
25% discount on these Hollywood glamour false eye lashes.
More Details...
SKU: 121405
1
Price: £4.50
Average customer rating:
0 stars  Total votes: 0

Jar Mix & Match Kit
Jar Mix & Match Kit
20% discount on this pefect jar kit - 3 way wheel mixing jar, two medium jars and lids (one with clear sifter.
More Details...
SKU: 121216
piece
Price: £4.00
Average customer rating:
0 stars  Total votes: 0

NATURAL false eyelashes
NATURAL false eyelashes
25% discount on these beautiful girl next door NATURAL false eye lashes.
More Details...
SKU: 121404
1
Price: £4.50
Average customer rating:
0 stars  Total votes: 0

Single individual false eyelashes
Single individual false eyelashes
25% discount on these single individual false eye lashes.
More Details...
SKU: 121409
1
Price: £4.50
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


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


Display #  
Results 1 - 14 of 14

Featured Products

NATURAL false eyelashes

 £4.50
NATURAL false eyelashes

25% discount on these beautiful girl next door NATURAL false eye lashes.

Ergonomic Stainless Steel Tweezers

 £10.00
Ergonomic Stainless Steel Tweezers

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

Single individual false eyelashes

 £4.50
Single individual false eyelashes

25% discount on these single individual false eye lashes.

Flare individual false eyelashes

 £4.50
Flare individual false eyelashes

15% discount on natural single lashes - add old style glamour to the corner of your eyes.

GLAMOUR false eyelashes

 £4.50
GLAMOUR false eyelashes

25% discount on these Hollywood glamour false eye lashes.

Jar Mix & Match Kit

 £4.00
Jar Mix & Match Kit

20% discount on this pefect jar kit - 3 way wheel mixing jar, two medium jars and lids (one with clear sifter.

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.

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.

CATWALK false eyelashes

 £4.50
CATWALK false eyelashes

25% discount on these fun, funky and definitely cutting edge false eye lashes.

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

Single individual false eyelashes
Single individual false eyelashes
Large Plastic Bottle (118ml)
Large Plastic Bottle (118ml)
"Magic 9" Mascara Brush Collection

Latest Products

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

Profile Information

Application afterLoad: 0.002 seconds, 0.21 MB
Application afterInitialise: 0.185 seconds, 3.84 MB
Application afterRoute: 0.202 seconds, 4.49 MB
Application afterDispatch: 0.581 seconds, 10.42 MB
Application afterRender: 0.728 seconds, 11.42 MB

Memory Usage

12012120

240 queries logged

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

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  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`='256'
  191. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='256'
  192. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=256
  193. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=256
  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`='257'
  195. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='257'
  196. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=257
  197. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=257
  198. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='149'
  199. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=149
  200. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=149
  201. 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`='150'
  202. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='150'
  203. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=150
  204. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=150
  205. 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`='145'
  206. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='145'
  207. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=145
  208. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=145
  209. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='262'
  210. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=262
  211. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=262
  212. 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`='134'
  213. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='134'
  214. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=134
  215. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=134
  216. 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`='258'
  217. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='258'
  218. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=258
  219. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=258
  220. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='146'
  221. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='146'
  222. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=146
  223. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=146
  224. 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 = 173 OR mm.menuid = 0 )
      ORDER BY position, ordering
  225. SELECT products_per_row
      FROM jos_vm_category
      WHERE category_id=53
  226. 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
  227. 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
  228. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121409'
  229. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='149'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  230. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121211'
  231. 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
  232. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='101032'
  233. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='237'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  234. 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
  235. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='121216'
  236. 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
  237. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='156222'
  238. 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
  239. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='111104'
  240. 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

240 legacy queries logged

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

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  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`='256'
  191. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='256'
  192. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=256
  193. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=256
  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`='257'
  195. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='257'
  196. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=257