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
Born of Sand and Snow
Born of Sand and Snow
$13.00
Temujin - 1000 Tears $13.00

*** Free Shipping Worldwide ***

Australian Gothic Metal - 13 blistering tracks featuring the vocals of Kelly Lean.

01. Find Me
02. 1000 Tears
03. So Near
04. Let You Go
05. Spiral
06. Down
07. Blue Jay
08. Taken
09. Sheltered
10. Haunted
11. All of You
12. Throwing Stones
13. Heart and Soul

Autographed copies available on request (leave message when making purchase)

*** Free Shipping Worldwide ***

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