SELECT *

FROM 4_2_products_from_orders_yandex_market

JOIN 11_3_orders_yandex_market_from_shipments ON 4_2_products_from_orders_yandex_market.order_number = 11_3_orders_yandex_market_from_shipments.number_order_yandex_market

LEFT JOIN 4_3_status_yandex_market ON 11_3_orders_yandex_market_from_shipments.number_order_yandex_market = 4_3_status_yandex_market.number_order_yandex_market AND 4_3_status_yandex_market.status = 'CANCELLED'

WHERE (4_2_products_from_orders_yandex_market.status_application = '2.1. Товар в зарезервирован на 3 дня'

        OR 4_2_products_from_orders_yandex_market.status_application = '2.2. Товар в зарезервирован на 7 дней')

    AND 4_2_products_from_orders_yandex_market.order_sima_land = 0

    AND 4_3_status_yandex_market.number_order_yandex_market IS NULL

    AND 11_3_orders_yandex_market_from_shipments.number_shipment = 44659422;

SELECT t1.*, t2.*

FROM 4_2_products_from_orders_yandex_market AS t1

JOIN 11_3_orders_yandex_market_from_shipments AS t2 ON t1.order_number = t2.number_order_yandex_market

LEFT JOIN 4_3_status_yandex_market AS t3 ON t2.number_order_yandex_market = t3.number_order_yandex_market

                                        AND t3.status = 'CANCELLED'

WHERE t1.status_application IN ('2.1. Товар в зарезервирован на 3 дня', '2.2. Товар в зарезервирован на 7 дней')

    AND t1.order_sima_land = 0

    AND t2.number_shipment = 44659422

    AND t3.number_order_yandex_market IS NULL;

SELECT *

FROM 4_2_products_from_orders_yandex_market AS t1

JOIN 11_3_orders_yandex_market_from_shipments AS t2 ON t1.order_number = t2.number_order_yandex_market

WHERE t1.status_application IN ('2.1. Товар в зарезервирован на 3 дня', '2.2. Товар в зарезервирован на 7 дней')

    AND t1.order_sima_land = 0

    AND t2.number_shipment = 44659422

    AND NOT EXISTS (

        SELECT NULL

        FROM 4_3_status_yandex_market AS t3

        WHERE t2.number_order_yandex_market = t3.number_order_yandex_market

          AND t3.status = 'CANCELLED'

        );