Amy Flower Shop My Account  Cart Contents  Checkout  
  Top » Catalog My Account  |  Cart Contents  |  Checkout   
Categories
2021 Valentine's Day (27)
Condoleces (52)
Floral Basket
Flowers and Bear
Flowers and Chocolate
Grand Opening (24)
Hand Bouquet
Mother's Day
Vase Arrangement
What's New? more
VA 11
VA 11
RM190
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Information
Shipping & Returns
Coverage
Conditions of Use
Contact Us
Welcome to Amy Flower Shop! Welcome to Amy Flower Shop!
Welcome Guest! Would you like to log yourself in? Or would you prefer to create an account?
Welcome to our online catalogue of our flower arrangements. Please browse through our display and place your order with us. We will contact you regarding payment arrangement after that.
New Products For August
VA 11
VA 11
RM190
VA 10
VA 10
RM190
VA 15
VA 15
RM190
VA 2
VA 2
RM250
VA 39
VA 39
RM350
VA 23
VA 23
RM300
VA 40
VA 40
RM230
VA 31
VA 31
RM300
VA 34
VA 34
RM200
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'amyflow_db.p.products_ordered' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10

[TEP STOP]

Shopping Cart more
0 items