Untitled

SELECT 
    ot.name,ot.phone,ot.email,ot.barcode,ot.position,ot.company
FROM
    daftarmana.order_attendees ot
        INNER JOIN
    daftarmana.attendees_log al ON al.orderAttendeesId = ot.id
    where al.times like "%2024-08-09%" and ot.name!=""
GROUP BY ot.id;