SELECT id_card, id_card_type, c.id_card_company, cc.name, value
                      FROM bell.card c
                     inner join bell.card_company cc using(id_card_company)
                     where cc.active='y'
                       and (active_nn>reserve_nn or id_card_type>2)
                       and value>4
                      order by cc.name, value
                     

0 1 2 3 4 149 3 43 Bizon 5.00 150 3 43 Bizon 10.00 151 3 43 Bizon 20.00 152 3 43 Bizon 50.00 153 3 43 Bizon 100.00 173 3 43 Bizon 250.00 115 3 30 Mozart 5.00 104 3 30 Mozart 10.00 105 3 30 Mozart 20.00 106 3 30 Mozart 50.00 107 3 30 Mozart 100.00 108 3 30 Mozart 250.00