Edit Report:EDUCATION REGISTRATION (LAST 50)
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- EDUCATION REGISTRATION (LAST 50)
--
--
SELECT
eh.date_added,
e.code as 'code',
e.name as 'event',
ed.customer_id,
ed.salonname,
ed. registrant,
ed.phone,
ed. email,
ed.instagram,
ed.discounted,
ed.notes
FROM
events_history_details ed
JOIN events e on e.events_id = ed.events_id
left join events_history eh on eh.events_history_id = ed.history_id
ORDER BY
history_details_id DESC
LIMIT 0, 50