select TA_UserID,convert(varchar, TA_Timestamp, 108) as time,TA_UserFirstName,TA_UserLastName,CASE DATENAME(dw,TA_Timestamp)

                when `saturday` then `السبت` 

                when `Sunday` then `الاحد`

                when `monday` then `الاثنين`

                when `tuesday` then `الثلاثاء` 

                when `wednesday` then `الاربعاء` 

                when `thursday` then `الخميس` 

                when `friday` then `الجمعة`

                 END as Days ,FORMAT(TA_Timestamp,`dd/MM/yyyy`,`ar`) AS Hijri,convert(varchar(11), TA_Timestamp, 103) AS Gregorian, 

   CASE TA_IDContext

        WHEN 100 THEN `دخول`

        WHEN 200 THEN `خروج`

        WHEN 0 THEN `admin`

    END as inout,TA_AccessPointID,

     CASE TA_AccessPointID

                when `1801B15B0016A700` then `3D_الامين` 

                when `D201B15A00163A00` then `3D_بوابة2`

                when `0601B17900169400` then `3D_تجهيزات`

                when `5901B15200161600` then `3D_الحاسب` 

                when `0F01B15B00167900` then `3D_الحركة` 

                when `1C01B15A0016B600` then `3D_مالية` 

                when `FB01B15A00161A00` then `3D_مصعد`

                when `5501B18200163500` then `3D_موظفيين`

                when `F901B15200164A00` then `3D_الخدمات`

                when `EA01DFEE00170800` then `3D_صحة`

                when `1F01DF7A00173900` then `3D_الاراضي`

                when `1301DFD500171800` then `3D_صيانة`

                when `0601DFEF00179100` then `3D_نسائي` 

                when `2901DFA400179A00` then `3D_الفنية`

                when `A501DF9100175B00` then `3D_عمراني`

                when `8901DF8300176F00` then `3D_البلديات`

                when `C101DF9100174400` then `3D_المختبر`

                when `1401DFEF0017A400` then `3D_الاسواق`

                when `7701DFC200172A00` then `3D_الترفيعات`

                when `0A01DFCE0017D900` then `3D_الزراعة`

                when `AC01DF910017CD00` then `3D_الاستثمار`

               when `9701DF910017D800` then `3D_صناعية`

                when `1801DF7A0017BC00` then `3D_بلاغات`

                when `FE01DFB30017F600` then `3D_معلومات`

                when `D201B15200160400` then `3D_engineer`

                  END as Devices

   from TBST_TARecords

   WHERE TA_UserID LIKE `1218` and (TA_Timestamp >= CONVERT(datetime, `01/05/1438`,131)+1) AND (TA_Timestamp <= CONVERT(datetime, `30/05/1438`,131) + 2)

    order by TA_Timestamp desc