Expression #1 of ORDER BY clause is not in SELECT list, references column 'atvshop_db.products.pPrice' which is not in SELECT list; this is incompatible with DISTINCT

Expression #1 of ORDER BY clause is not in SELECT list, references column 'atvshop_db.coupons.cpnID' which is not in SELECT list; this is incompatible with DISTINCT Home » Logic Equipment » Trailers   Please Select... £600 - £700 £700 - £800 £800 - £900 £900 - £1,000 £1,000 - £1,100 £1,100 - £1,200 £1,200 - £1,300 £1,300 - £1,400 £1,400 - £1,500 £1,500 - £1,600 £1,600 - £1,700 £1,700 - £1,800 £1,800 - £1,900 £1,900 - £2,000 £2,000 - £2,100 £2,100 - £2,200 £2,200 - £2,300 £2,300 - £2,400 £2,400 - £2,500 £2,500 - £2,600 Please Select... Sort AlphabeticallyPrice (Lowest First)Price (Highest First)No Sort 9 Per Page18 Per Page27 Per Page36 Per Page45 Per Page No products are currently available in this category.