blueFreya
  Top » Catalog » BlueFreya » My Account  |  Cart Contents  |  Checkout   
Categories
BlueFreya (9)
Ravenheart (8)
What's New? more
Vulvagun - Cold Moon Over Babylon
Vulvagun - Cold Moon Over Babylon
$14.00
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Information
Shipping & Returns
Featured Products
Privacy Notice
Contact Us
Featured more
Temujin - 1000 Tears
Temujin - 1000 Tears
$13.00
Angelical Tears - Angelical Tears $8.00

*** Free Shipping Worldwide ***

6 Track Debut release from Oklahoma's finest Goth/Metal band.
1. No More
2. Save Me
3. Dreams
4. Tomorrow Happens Now
5. Darkness
6. Chasing Eternity

*** Free Shipping Worldwide ***

This product was added to our catalog on Sunday 17 October, 2010.
Reviews
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'temujinb_osc1.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 orders_products opa, orders_products opb, orders o, products p where opa.products_id = '51' and opa.orders_id = opb.orders_id and opb.products_id != '51' 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]