B & V Traders

A site specializing in the sale of miniatures and terrain.
HOME WHAT'S NEW? SPECIALS REVIEWS LOGIN CATALOG
Categories
Decals
Exclusive BVT Items
Hobby Related
Miniatures
  Cold Navy
  Dream Pod 9
  Iron Wind Metals
    Aerospace & VTOLs
    Aerotech 2
    Clan Mechs
    Dark Age Mechs
    Foam & Resin
    Infantry
    Inner Sphere Mechs
    Protomechs
    Tanks & Vehicles
  Monday Knight Productions
  Reaper Miniatures
  RPE/Mechforce U.K.
  Talon Games
Miscellaneous
Pirates of the Cursed Seas
Sourcebooks & Novels
Terrain
Used Miniatures
Latest products more
LOTB Military Hat-Green
LOTB Military Hat-Green
$20.00
Manufactures
Information
Returns
Privacy Notice
Shipping, International
Shipping, U.S.
Contact Info
Graphics Copyrights
Legal
About Us
Contact Us
Tell A Friend
 
Tell someone you know about this product.
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Links
Links
Viper
[20-663]		 $7.95
 
box_bg_l.gif.

Viper. Now OOP.
This product was added to our catalog on Wednesday 16 June, 2004.
box_bg_r.gif.
Reviews
1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '635' and opa.orders_id = opb.orders_id and opb.products_id != '635' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6

[TEP STOP]