SELECT    DISTINCT a.office_id, a.product_id, a.article FROM (    SELECT        o.office_id,        p.product_id,        p.article,        row_number() OVER (PARTITION BY o.office_id, p.product_id, pl.price_list_id ORDER BY pl.price_start_date DESC) r    FROM        esb_products p,        esb_price_lists_details pl,        esb_offices o,        esb_organizations org    WHERE        p.product_id = pl.product_id AND pl.price_list_id = o.price_list_id AND org.organization_id = o.organization_id        AND p.deleted = FALSE AND pl.deleted = FALSE AND o.deleted = FALSE        AND o.status = '2' AND o.available_pre_order = TRUE AND pl.price_start_date <= now()        AND p.product_id IN ('154d1fe8-7cb2-4668-abba-180f1228ca3d','30bd2089-a1c5-4685-b77e-2b0062fd9732','082372c8-71d8-4032-9948-c4eed55fc85f') AND (org.property_type IN ('2', '3'))        AND (o.address <> '' OR (o.noctidial IS NOT NULL AND o.longitude IS NOT NULL))        AND (NOT true OR (LOWER(o.name) NOT LIKE '%test%' AND LOWER(o.name) NOT LIKE '%тест%'))        AND o.city_id IS NOT NULL        AND p.product_id IN (            SELECT DISTINCT prod.product_id            FROM esb_products AS prod            WHERE prod.product_id in ('154d1fe8-7cb2-4668-abba-180f1228ca3d','30bd2089-a1c5-4685-b77e-2b0062fd9732','082372c8-71d8-4032-9948-c4eed55fc85f') AND prod.deleted = FALSE                AND p.product_id IN (                    SELECT DISTINCT gr.product_id FROM (                        SELECT                            p.product_id,                            sg.technical_sub_group,                            gp.group_product_id,                            gp.technical_group                        FROM                            esb_products p                        JOIN esb_sub_group_products sg                            ON p.sub_group_product_id = sg.sub_group_product_id AND sg.deleted = FALSE                        JOIN esb_group_products gp                            ON gp.group_product_id = sg.group_product_id AND gp.deleted = FALSE                            where p.technical_product <> '2'                             and gp.technical_group <> '2'                             and sg.technical_sub_group <> '2'                         UNION                        SELECT                            p.product_id,                            sg.technical_sub_group,                            gp.group_product_id,                            gp.technical_group                        FROM                            esb_products p                        JOIN esb_relation_article_and_article_groups ra                            ON ra.product_id = p.product_id AND ra.deleted = FALSE                        JOIN esb_sub_group_products sg                            ON sg.sub_group_product_id = ra.sub_group_product_id AND sg.deleted = FALSE                        JOIN esb_group_products gp                            ON gp.group_product_id = sg.group_product_id AND gp.deleted = FALSE) AS gr                        WHERE                            (gr.technical_sub_group IS NULL OR gr.technical_sub_group <> '2')                            AND gr.technical_group IS NULL OR gr.technical_group <> '2'                            AND gr.group_product_id <> '3C49DD62-107D-42B3-87A6-FD74C0961E35'                )                AND prod.only_profile = FALSE                AND prod.technical_product <> '2'                AND prod.type <> '2'                 AND o.region_id = 'ab4d9aae-875d-4b4e-b08a-ad40188e0206'                AND prod.article NOT IN (                    'АКЦ1В-ГИН',                    'АКЦКАП',                    'ГИЭ4',                    'ППМЭВ',                    'ППМЭД',                    'ППМЭК',                    'ППМЭМ',                    'ППМЭМС',                    'ППМЭН',                    'МС',                    '596',                    'ППМЭС'                )            LIMIT 50        ) ) a WHERE a.r = 1;