Ice Cream Dreams - Snuffy


This is a first for U.Q.; to distribute a 12 TRACK full length album that is not of the House or Techno Realm. Snuffy.NYC aka Snuffy as he is commonly referred to, has been locked underground making sounds since 2008. Fast forward, 2018, Underground Quality and DJ Jus Ed dragged him from his Cave to bring you Snuffy's debut album ICE CREAM DREAMS. ICD is disorienting, each track detached from time and yet, elements of classic hip hop and dance creep in. When he isn't sound making you might find him Tattooing in Brooklyn NY. You also might not find him at all. Here's where you can start - - @SNUFFY.NYC

Add to Cart:

  • Model: Snuffy-NYC-001
  • Artist: Snuffy
  • Music Genre: Hip Hop/Electro/Dance/Low-Fi

This product was added to our catalog on Sunday 16 September, 2018.

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'jused_zc1.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[select p.products_id, p.products_image from zen_orders_products opa, zen_orders_products opb, zen_orders o, zen_products p where opa.products_id = '200' and opa.orders_id = opb.orders_id and opb.products_id != '200' 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 3]