SELECT releases.*, sales.sale_price, sales.sales_pitch, artists.name AS artistName FROM releases LEFT JOIN artists ON releases.artist = artists.id LEFT JOIN sales ON (releases.id = sales.release_id AND sales.start_date <= CURDATE() AND sales.end_date >= CURDATE()) WHERE in_stock=1 AND FumpFest=1 ORDER BY avail_date DESC LIMIT 0,15

The FuMP Store

Shopping Cart

Available Releases

Select an album for more information and to hear samples from its songs.

Page: of 2

by