Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT e.eventId, e.userId, e.typeEventId, e.churchId, u.name AS userName, u.lastname, c.churchId, c.name AS churchName, e.latitude, e.longetude, e.name, e.createdDate, tp.name AS typeEventName, lk.LIKE, u.thumb
- FROM event e
- LEFT JOIN USER u ON u.userId = e.userId
- LEFT JOIN church c ON c.churchId = e.churchId
- LEFT JOIN typeevent tp ON tp.typeEventId = e.typeEventId
- LEFT JOIN LIKE lk ON lk.eventId = e.eventId
- WHERE e.churchId = "AEXdbCapWi"
- AND lk.userId = "ncul61I8fi"
- ORDER BY e.createdDate DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement