Incorrect syntax near the keyword 'desc'.
SELECT TOP 25 * FROM (select top 1 * from (SELECT top 25 * FROM (SELECT ZIYTARIHI, ZIYEDEN, ZIYAMACI,ZIYID FROM MEDISOFTZIYARET) AS TBL WHERE 1=1 ORDER BY desc) as TBL ORDER BY asc) as TBL ORDER BY desc