Public Pastes
Guest

Untitled

By: a guest on Jan 28th, 2012  |  syntax: None  |  size: 0.24 KB  |  hits: 20  |  expires: Never
download  |  raw  |  embed  |  report abuse
Copied
  1. select GROUP_CONCAT(DISTINCT users.id)
  2. from users
  3. where users.id not in(select concat(group_concat(group_manager_id),group_concat(group_manager_two),group_concat(group_manager_three)) from shops)
  4. where users.last_login < '2008-02-02 00:00:00'
create a new version of this paste RAW Paste Data