QUERY: SELECT count(*) Cnt FROM product p WHERE (status=1 Or status=4) AND (start_date <= now() Or start_date is null Or start_date = '0000-00-00') And (end_date >= now() Or end_date is null Or end_date = '0000-00-00') AND Multiple_CatNo like '%,111,%' Order by price%7CASC
ERROR: Unknown column '7CASC' in 'order clause'