Amy Flower Shop My Account  Cart Contents  Checkout  
  Top » Catalog » 2021 Valentine's Day 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 31
VA 31
RM300
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 
 VA 1   VA 1   RM220  Buy Now 
 VA 10   VA 10   RM190  Buy Now 
 VA 11   VA 11   RM190  Buy Now 
 VA 12   VA 12   RM220  Buy Now 
 VA 14   VA 14   RM220  Buy Now 
 VA 15   VA 15   RM190  Buy Now 
 VA 17   VA 17   RM280  Buy Now 
 VA 18   VA 18   RM300  Buy Now 
 VA 19   VA 19   RM300  Buy Now 
 VA 2   VA 2   RM250  Buy Now 
 VA 20   VA 20   RM250  Buy Now 
 VA 22   VA 22   RM300  Buy Now 
 VA 23   VA 23   RM300  Buy Now 
 VA 25   VA 25   RM300  Buy Now 
 VA 26   VA 26   RM350  Buy Now 
 VA 27   VA 27   RM330  Buy Now 
 VA 29   VA 29   RM350  Buy Now 
 VA 30   VA 30   RM450  Buy Now 
 VA 31   VA 31   RM300  Buy Now 
 VA 32   VA 32   RM200  Buy Now 
Displaying 1 to 20 (of 27 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 '64' 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