Advertisement
Guest User

Untitled

a guest
Jan 27th, 2015
169
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. select
  2. s.name,
  3. t.user_id as src_type,
  4. h.text
  5. from
  6. src s
  7. join code_src_type t
  8. on s.src_type_id = t.id
  9. join src_hist h
  10. on s.id = h.src_id
  11. where
  12. s.name like '%KOSMOS%'
  13. and h.text like '%abc%'
  14. order by
  15. t.user_id,
  16. s.name,
  17. h.timestamp desc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement