Untitled

SELECT od.*,e.name,e.domain,e.domainTwo,e.logo,e.venue,e.startDate,e.endDate
FROM daftarmana.order_attendees od
LEFT JOIN daftarmana.orders o ON od.orderId = o.id
LEFT JOIN daftarmana.event e ON e.id=o.eventId
LEFT JOIN daftarmana.order_package op ON op.orderId = o.id
WHERE o.orderStatusId = 5 AND o.eventId = 16 AND o.participantTypeId = 26
AND (op.ticketId LIKE 56);