Invalid query: <strong>SELECT PropertySearch.ProvinceID,
                                   PropertySearch.RegionID,
                                   PropertySearch.SuburbID,
                                   PropertySearch.PropertyID,
                                   PropertySearch.WebRef,
                                   PropertySearch.TransactionID,
                                   PropertySearch.TypeID,
                                   PropertySearch.PaymentID,
                                   PropertySearch.MandatePrice,
                                   PropertySearch.PriceRange,
                                   PropertySearch.DateSold,
                                   PropertySearch.ShowPrice,
                                   PropertySearch.Bedrooms,
                                   PropertySearch.Bathrooms,
                                   PropertySearch.Parking,
                                   PropertySearch.Garage ,
                                   PropertySearch.DateAdded,
                                   PropertySearch.SuburbGroupingID,
                                   PropertySearch.OfficeID,
                                   PropertySearch.UserID,
                                   PropTransactions.ListingMethodID,
                                   PropTransactions.DateListed,PropType.TypeName
					       FROM PropertySearch
                                LEFT JOIN PropTransactions
                                    ON PropTransactions.TransactionID  = PropertySearch.TransactionID
                                LEFT JOIN PropAssociatedAgents ON PropAssociatedAgents.PropertyID = PropertySearch.PropertyID
                                 LEFT JOIN PropType ON PropType.PropTypeID = PropertySearch.TypeID 
					 WHERE 1 AND
                                PropTransactions.ShowOnWeb = 1
					 	    
					  	    AND PropAssociatedAgents.UserID     IN (96712)
                            GROUP BY PropertySearch.TransactionID	 
					  	   ORDER
				        		BY About-Us DESC
					  	    limit 0,8</strong> <br /> Error: (1054) Unknown column 'About' in 'order clause'