Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- s.name,
- t.user_id as src_type,
- h.text
- from
- src s
- join code_src_type t
- on s.src_type_id = t.id
- join src_hist h
- on s.id = h.src_id
- where
- s.name like '%KOSMOS%'
- and h.text like '%abc%'
- order by
- t.user_id,
- s.name,
- h.timestamp desc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement