osCommerce My Account  Cart Contents  Checkout  
  Top » Catalog » Shop By Country » United States » Rune269 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
Ideal Bread "Transmit"
Ideal Bread "Transmit"
$15.00
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Information
Shipping & Returns
Privacy Notice
Contact Us
Revolutionary Snake Ensemble
Revolutionary Snake Ensemble "Forked Tongue"
[Rune269]
$15.00
Revolutionary Snake Ensemble "Forked Tongue"

New-jazz ensemble combining brass band, New Orleans early jazz, funk, and composed 'new music' ala Carla Bley into a satisfying pastiche! RSE consists of alto sax, trumpet, trombone, tenor sax, acoustic bass & two drummers. Imaginative arrangements of traditional tunes and standards and even a 'cover' of Billy Idol's "White Wedding" (that is hilarious, by the way!) make up the lion's share of the album but it is the four original tunes by leader/altoist Ken Field that really shine! Fans of well-played jazz ensemble music as well as world musics and 'roots' jazz will find "Forked Tongue" a really appealing listen.

This product was added to our catalog on Wednesday 23 July, 2008.
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 = '6241' and opa.orders_id = opb.orders_id and opb.products_id != '6241' 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]