Here you can find music distributed by Unfun. Once we receive more albums, we will sort them out by genre and format. All cds are stocked by us in our inventory and are available for purchase immediately. Bands currently distributed by Unfun include, Smallpaul, The Singularity, Derge, Blue Water Boy, Half-String, Exploding Crustaceans, Gorehounds, Ned, Stalins War, Relik, and more. Please help support these bands, as many are unsigned acts, yet just as hard working. We hope to help aspiring groups move on to better prospects in their careers as musicians!
1054 - Unknown column 'p.products_id' in 'on clause'
select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '4'
