Advertisement
RafaelKowal

SQLite

Jan 8th, 2017
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.50 KB | None | 0 0
  1. 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
  2. FROM  event e
  3. LEFT JOIN USER u ON u.userId = e.userId
  4. LEFT JOIN church c ON c.churchId = e.churchId
  5. LEFT JOIN typeevent tp ON tp.typeEventId = e.typeEventId
  6. LEFT JOIN LIKE lk ON lk.eventId = e.eventId
  7. WHERE e.churchId = "AEXdbCapWi"
  8. AND lk.userId = "ncul61I8fi"
  9. ORDER BY e.createdDate DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement