SELECT
 static.country_dst,
 "operator".banner_id,
 "operator".operator_id,
 "operator".crm_id,
 "operator".name,
 "operator".city_id,
 "operator".city_name,
 "operator".subway_id,
 "operator".subway_name,
 "operator".address,
 "operator".fax,
 "operator".phone,
 "operator".email,
 "operator".www,
 "operator".contact_url,
 "operator".buy_info_url,
 "operator".legal_info_url,
 "operator".person_info_url,
 "operator".logo_ext,
 "operator".ur_capital,
 "operator".direction_count,
 "operator".city_depart_count,
 "operator".updated,
 "operator".price_url,
 "operator".name_url,
 "operator".logo_url,
 "operator".trash,
 placement.trash OR static.country_dst IS NULL AS placement_trash,
 "operator".trash OR (placement.trash OR static.country_dst IS NULL) AS total_trash, -- общий треш
 CASE
   WHEN "operator".updated > placement.updated
   THEN "operator".updated
   ELSE placement.updated
 END AS total_updated,
 placement.banner_uniq,
 placement.id AS placement_id
FROM (
      SELECT
	adv_operator.banner_id,
	adv_operator.operator_id,
	adv_operator.crm_id,
	adv_operator.name,
	adv_operator.city_id,
	adv_operator.city_name,
	adv_operator.subway_id,
	adv_operator.subway_name,
	adv_operator.address,
	adv_operator.fax,
	adv_operator.phone,
	adv_operator.email,
	adv_operator.www,
	adv_operator.contact_url,
	adv_operator.buy_info_url,
	adv_operator.legal_info_url,
	adv_operator.person_info_url,
	adv_operator.logo_ext,
	adv_operator.ur_capital,
	adv_operator.direction_count,
	adv_operator.city_depart_count,
	adv_operator.trash,
	adv_operator.updated,
	adv_operator.price_url,
	adv_operator.name_url,
	adv_operator.logo_url
      FROM adv.adv_operator

    ) AS "operator"
 JOIN (
	SELECT
	  DISTINCT ON (placement.banner_id, placement.banner_uniq) placement.banner_id,
	  placement.id,
	  placement.updated,
	  placement.trash,
	  placement.banner_uniq
	FROM (
	       SELECT
		 banner_id,
		 id,
		 updated,
		 (NOT visible OR trash) AS trash,
		 row_number() OVER (PARTITION BY banner_id)::integer AS banner_uniq
	       FROM adv.adv_operator_placement
	       ORDER BY
		 banner_id DESC
	     ) AS placement
	ORDER BY
	  placement.banner_id,
	  placement.banner_uniq DESC
      ) AS placement ON "operator".banner_id = placement.banner_id
 LEFT JOIN adv.vw_adv_operator_placement_static AS static ON static.placement_id = placement.id
 WHERE "operator".banner_id IN (SELECT DISTINCT banner_id as id FROM export.vw_export_operator WHERE trash = 1);