Advertisement
Guest User

Untitled

a guest
May 27th, 2019
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. SELECT
  2. gt_star.id,
  3. gt_star.name,
  4. gt_actual.id,
  5. gt_actual.name
  6. FROM geo_tags gt_star
  7. JOIN geo_tags gt_actual ON to_tsvector('russian', gt_actual.name) @@ plainto_tsquery('russian', gt_star.name)
  8. AND gt_actual.id <> gt_star.id
  9. AND gt_actual.is_archive = 0
  10. AND gt_actual.name NOT LIKE '%*%'
  11. AND gt_actual.level = gt_star.level
  12. WHERE gt_star.name like '%*%' AND gt_star.is_archive = 0;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement