Query: SELECT  R.id, R.parent_id, R.sort_order, R.active, R.is_category, A.news_date, A.page_id, A.title, A.summary, A.description, A.image, A.mail FROM fenix_news A LEFT JOIN fenix_record R ON(R.id=A.record_id) WHERE  A.lng='lt' AND R.is_category='0' AND R.parent_id='909' ORDER BY  A. A.news_date DESC,  R.sort_order - Error:Unknown column 'A.A.news_date' in 'order clause'