It looks like you have pasted a portion of your query a second time. Look where the first ORDER BY is, you then have FROM ... the same sql as before it.

Total shot in the dark but maybe this is what you are looking for. BTW, I ran this through a formatter so it is legible.

SELECT ID

,ShipTo

,ShipToID

,ShipToCompany

,BillTo

,BillToCompany

,PaymentType

,DateCreated

,EmployeeID

,Type

,Frequency

,CCPartial

FROM Aptify.dbo.vwStandingOrders

WHERE --- we'll only study active future fulfillments

(

STATUS LIKE 'Active'

AND (

DateExpires > GETDATE()

OR DateExpires < '1/2/1901'

)

)

AND ID IN -- find only stabding orders for dues products

(

SELECT StandingOrderID

FROM vwStandingOrProd sop

INNER JOIN vwProducts prod ON sop.productID = prod.id

AND prod.categoryID IN (

1

,8

,9

,10

,11

)

)

AND PaymentTypeID IN (

11

,12

,18

,19

,20

,21

,22

,26

,27

,28

,29

)

AND (

(isNull(PONumber, '') = '')

OR (isNull(Terms, '') = '')

)

ORDER BY Aptify.dbo.vwStandingOrders.[DateCreated] DESC