SHARE
TWEET

Untitled

a guest Sep 14th, 2017 83 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. mysql>SELECT
  3.         events.*,
  4.         titles.msgtext as title,
  5.         subjects.msgtext as event
  6. FROM events
  7. left JOIN msgcodes AS titles
  8.         ON titles.fkey=events.id
  9.         AND titles.FIELD="title"
  10.         AND titles.msgtext <>""
  11. left JOIN msgcodes AS subjects
  12.         ON subjects.fkey=events.id
  13.         AND subjects.FIELD="event"
  14.         AND subjects.msgtext <>"" where events.id=1882 and (titles.lang="en" or titles.lang="de");
RAW Paste Data
Top