Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE external_match SET approved = TRUE FROM (
- SELECT em.external_object_id, em.partner_button_type_code
- FROM
- external_match em
- JOIN external_object eo ON em.external_object_id = eo.id
- WHERE
- em.match_precision = 100
- AND em.approved IS FALSE
- AND eo.partner_id = 11
- GROUP BY eo.partner_id, em.external_object_id, em.partner_button_type_code
- HAVING COUNT(external_object_id) = 1
- ) exact_ext, (
- SELECT place_id
- FROM
- external_match em2
- JOIN external_object eo ON em2.external_object_id = eo.id
- WHERE
- em2.match_precision = 100
- AND em2.approved IS FALSE
- AND eo.partner_id = 11
- GROUP BY eo.partner_id, em2.place_id
- HAVING COUNT(em2.place_id) = 1
- ) exact_poi
- WHERE
- external_match.external_object_id = exact_ext.external_object_id
- AND external_match.external_object_id NOT IN (
- SELECT
- DISTINCT external_object_id
- FROM
- external_match
- WHERE
- approved IS TRUE
- )
- AND external_match.place_id = exact_poi.place_id
- AND external_match.place_id NOT IN (
- SELECT
- DISTINCT em2.place_id
- FROM
- external_match em2
- WHERE
- em2.approved IS TRUE
- AND em2.partner_button_type_code = exact_ext.partner_button_type_code
- )
- AND match_precision = 100
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement