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