Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- gt_star.id,
- gt_star.name,
- gt_actual.id,
- gt_actual.name
- FROM geo_tags gt_star
- JOIN geo_tags gt_actual ON to_tsvector('russian', gt_actual.name) @@ plainto_tsquery('russian', gt_star.name)
- AND gt_actual.id <> gt_star.id
- AND gt_actual.is_archive = 0
- AND gt_actual.name NOT LIKE '%*%'
- AND gt_actual.level = gt_star.level
- WHERE gt_star.name like '%*%' AND gt_star.is_archive = 0;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement