id card type card type description 1 No Connection charge 2 Connection charge 3 Permanent assigned_PIN 4 ANI/PIN 5 Permanent generated_PIN/ANI 6 PC2Phone 7 Callback 8 Callplan 10 EuroBaseCard 9 Topup 11 Travel SIM Buy 12 Travel SIM Refill

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
                     

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