Untitled

 avatar
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