SELECT area_name as meja, booking, nama as pelanggan, biaya, status, DATE(CONVERT_TZ(from_unixtime(masuk),@@session.time_zone, '+07:00')) as Tanggal, masuk, keluar, ELT(WEEKDAY(from_unixtime(masuk)) + 1, 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun') as hari, (billiard) AS Tarif, (fnb) as fnb, token_api as token FROM tb_pengunjung_ol WHERE token_api='NOTOKEN' AND DATE(CONVERT_TZ(from_unixtime(masuk),@@session.time_zone, '+07:00')) between '2026-03-13' and '2026-03-13' ORDER by timestamp(CONVERT_TZ(from_unixtime(keluar),@@session.time_zone, '+07:00')) DESC
CLOUD IndoBilliard
