select
  CONVERT(VARCHAR(10), o.orderdate, 101) as 'Order Date'
  ,o.remake_orderid
  --,o.remake_reason
  --,o.remakereasonid
  --,e.firstname
  ,d.domain
from orders o
LEFT OUTER JOIN domain d on d.domainid = o.remakereasonid
--LEFT OUTER JOIN employee e on e.employeeid = o.orderedbyemployeeid
where remake_orderid is not null
and orderdate between '2016-10-01' and '2016-10-12'