Amy Flower Shop My Account  Cart Contents  Checkout  
  Top » Catalog » Grand Opening 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 34
VA 34
RM200
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 
 FS 1   FS 1   RM200  Buy Now 
 FS 10   FS 10   RM250  Buy Now 
 FS 11   FS 11   RM350  Buy Now 
 FS 12   FS 12   RM250  Buy Now 
 FS 13   FS 13   RM200  Buy Now 
 FS 14   FS 14   RM350  Buy Now 
 FS 15   FS 15   RM400  Buy Now 
 FS 16   FS 16   RM450  Buy Now 
 FS 17   FS 17   RM700  Buy Now 
 FS 18   FS 18   RM650  Buy Now 
 FS 19   FS 19   RM700  Buy Now 
 FS 20   FS 20   RM700  Buy Now 
 FS 21   FS 21   RM1000  Buy Now 
 FS 22   FS 22   RM3000  Buy Now 
 FS 23   FS 23   RM3000  Buy Now 
 FS 24   FS 24   RM1800  Buy Now 
 FS 25   FS 25   RM2000  Buy Now 
 FS 3   FS 3   RM250  Buy Now 
 FS 4   FS 4   RM200  Buy Now 
 FS 5   FS 5   RM280  Buy Now 
Displaying 1 to 20 (of 24 products) Result Pages:  1  2  [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 '53' 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