English عربي   Francais

 :: Advanced Search 
: Advanced Search
Browse Categories:

   Assorted Baklava
   Baklava Pistachios
   Baklava Pines
   Dried Fruits
   Lite Products
   Ashta Products
Shopping Cart Contents
..is empty!

 Enter Search Criteria    Enter Search Criteria  

 Categories:    (  includes subcategories ) 
 (one or more keywords/phrases) 
 Date Added from:     To:    (eg. 21/05/1970)
 Price from:     To:   
 Advanced Search Tips

The search engine allows you to do a keyword search on the Product Model, Name, Description and Manufacturer Name.

When doing a keyword search, you can separate words and phrases by AND or OR. For example, you can enter Microsoft AND mouse. This search would generate results that have both words in them. However, if you type in mouse OR keyboard, you will get a list of products that have both or either words in them. If words are not separated by AND or OR, search will default the logical operator to AND.

You can also search for exact matches of words by enclosing them in quotes. For example, if you search for "notebook computer", you will get a list of products that have that exact string in them.

Brackets can be used to control the order of the logical operations. For example, you can enter Microsoft and (keyboard or mouse or "visual basic").
1030 - Got error 122 from storage engine

select p.products_id, p.products_name, p.products_description, p.products_price, p.products_image, sum(op.products_quantity) as ordersum from products p, orders_products op where p.products_status = '1' and p.products_id = op.products_id group by p.products_id order by ordersum DESC, p.products_name limit 4