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