blueFreya
  Top » Catalog » BlueFreya » My Account  |  Cart Contents  |  Checkout   
Categories
BlueFreya (9)
Ravenheart (8)
What's New? more
Only Fate Remains - Breathe
Only Fate Remains - Breathe
$15.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
Where Angels Fall - Marionettes $12.50

*** Free Shipping Worldwide ***

1. Marionettes (Again) (4:15)
2. Freeze Me (4:40)
3. Freed On Depression (4:17)
4. Kyrie (5:08)
5. Mystifying Grief (6:02)
6. Invisible (4:25)
7. Freedom Is Finite (3:25)
8. Path of Sorrow (5:37)
9. Female Stigma (5:06)

*** 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 = '30' and opa.orders_id = opb.orders_id and opb.products_id != '30' 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]