Untitled
unknown
plain_text
a year ago
959 B
5
Indexable
//query gak check in 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.attendees_log al ON al.orderAttendeesId = od.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) AND al.orderAttendeesId IS NULL; //query gak check in SELECT od.*,e.name,e.domain,e.domainTwo,e.logo,e.venue,e.startDate,e.endDate FROM daftarmana.order_attendees od inner JOIN daftarmana.orders o ON od.orderId = o.id inner JOIN daftarmana.attendees_log al ON al.orderAttendeesId = od.id inner JOIN daftarmana.event e ON e.id=o.eventId inner 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);
Editor is loading...
Leave a Comment