Amy Flower Shop My Account  Cart Contents  Checkout  
  Top » Catalog » Condoleces 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 44
VA 44
RM390
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Information
Shipping & Returns
Coverage
Conditions of Use
Contact Us
Let's See What We Have Here Let's See What We Have Here
    Product Name+   Price   Buy Now 
 WA 1   WA 1   RM200  Buy Now 
 WA 10   WA 10   RM280  Buy Now 
 WA 11   WA 11   RM280  Buy Now 
 WA 12   WA 12   RM220  Buy Now 
 WA 13   WA 13   RM250  Buy Now 
 WA 14   WA 14   RM250  Buy Now 
 WA 15   WA 15   RM250  Buy Now 
 WA 16   WA 16   RM220  Buy Now 
 WA 17   WA 17   RM220  Buy Now 
 WA 18   WA 18   RM280  Buy Now 
 WA 19   WA 19   RM250  Buy Now 
 WA 2   WA 2   RM300  Buy Now 
 WA 20   WA 20   RM380  Buy Now 
 WA 21   WA 21   RM400  Buy Now 
 WA 22   WA 22   RM250  Buy Now 
 WA 23   WA 23   RM480  Buy Now 
 WA 24   WA 24   RM400  Buy Now 
 WA 25   WA 25   RM450  Buy Now 
 WA 26   WA 26   RM280  Buy Now 
 WA 27   WA 27   RM280  Buy Now 
Displaying 1 to 20 (of 52 products) Result Pages:  1  2  3  [Next >>] 
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, products_to_categories p2c, categories c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '54' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit 10

[TEP STOP]

Shopping Cart more
0 items