osCommerce My Account  Cart Contents  Checkout  
  Top » Catalog » Shop By Country » United States » 311 My Account  |  Cart Contents  |  Checkout   
Categories
Box Sets (10)
Shop By Country-> (1285)
  Belgium (16)
  British Isles (221)
  Canada (60)
  France (73)
  Germany (17)
  Holland & Scandanavia (75)
  Italy (162)
  Japan & Asia (30)
  Misc. Artists - Other Countries (55)
  South America (46)
  Spain (9)
  Switzerland (25)
  United States (496)
Shop By Label-> (296)
Special Categories-> (70)
Quicklist by Artist
What's New? more
Helmet of Gnats "High Street"
Helmet of Gnats "High Street"
$15.00
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Information
Shipping & Returns
Privacy Notice
Contact Us
Hobson's Choice
Hobson's Choice "New Horizons"
[311]
$12.99
Hobson's Choice "New Horizons"

Superb symphonic rock from New Orleans! Recorded in 1996 but sounds like late 70s!! Except for being a bit late in entering the race, this is every bit as good as other classic American prog bands like Lift, Easter Island, Mirthrandir, Ethos, or Happy the Man!! Although there are obvious influences they never intrude on the songwriting/composing which is stellar throughout! The band consists of Richard Bird-guitars, vocals ; David Stocker-piano, Hammond, synths, vocals ; Joel Webb-electric bass ; Tom Larson-drums ; and Mark Whitaker-percussions. A totally unknown CD at the time of its release Hobson's Choice really deserve massive amounts of attention now that we have found them!!

This product was added to our catalog on Monday 21 June, 2004.
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 = '4454' and opa.orders_id = opb.orders_id and opb.products_id != '4454' 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]