with
        inp_arg as(
          select p.word as pattern, p.i
          from split_into_words( :a_pattern ) p
        )
        ,inp_pat  as(
          select
            i.pattern, i.i
            ,(select count(distinct pattern) from inp_arg) cnt_unq
            ,(select count(*) from inp_arg x where x.pattern=i.pattern ) cnt_occ
          from inp_arg i
        )
        --with inp_pat as(select 'qwe' pattern, 0 i, 1 cnt_unq, 1 cnt_occ from rdb$database)
        ,prod_pat as(
            select --pp.prod_id, i.pattern, i.i, i.cnt_all, i.cnt_occ, pw.id pw_id, pw.name pw_word, ps.name
            pp.prod_id
            ,i.pattern
            ,max(i.cnt_unq) cnt_unq
            ,max(i.cnt_occ) cnt_occ
            from inp_pat i
             INNER  join pwords pw on pw.name starting with i.pattern
             INNER  join prod_w pp on pw.id = pp.word_id
            group by pp.prod_id, i.pattern
            having count(distinct pw.id) >= max(i.cnt_occ)
        )
        -- select * from  prod_pat

        ,prod_fin as (
            select pp.prod_id
            from prod_pat pp
            group by pp.prod_id
            having count(*) = max(cnt_unq)
        )
        select pf.prod_id, ps.name
        from prod_fin pf
        join prod ps on pf.prod_id = ps.id