We use a local courier service who do a daily pickup service if you wish the items to be delivered. 25kg max (A small fee will apply) Your order will be normally sent out to you the same day, depending on stock levels. Should an item not be in stock then it could take a little longer. We will keep you informed. We cannot take responsibility for any delays, or failures of the postal services to deliver an item in the specified time.
If you have your own courier service and would like to use it for your deliveries then all we need is the courier company details and account number. We would be pleased to accomidate your requirements.
All deliveries will be made to you at the address specified by you in the order. If we cannot deliver the products to you at the address you have specified for any reason (other than when we are at fault), we will notify you and store the products.
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'porterag_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