Advertisement
rlfprog

Subquery with too many columns

Jan 14th, 2015
318
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.43 KB | None | 0 0
  1. SELECT m.from_user_id,
  2.        m.message,
  3.        m.send_date
  4. FROM message m
  5. WHERE m.conversation_id IN (
  6.   SELECT cu.id,
  7.          cu.conversation_id,
  8.          cu.user_id,
  9.          au.username
  10.   FROM conversation_user cu
  11.   INNER JOIN auth_user au ON cu.user_id = au.id WHERE conversation_id IN
  12.     (SELECT conversation_id
  13.      FROM conversation_user
  14.      WHERE user_id = 32)
  15.   AND user_id != 32
  16. )
  17. ORDER BY send_date DESC LIMIT 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement