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

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
                     

123	1	35	Africa	10.00
124	1	35	Africa	20.00
125	1	35	Africa	50.00
156	3	44	Arbat	10.00
157	3	44	Arbat	20.00
158	3	44	Arbat	50.00
159	3	44	Arbat	100.00
566	1	126	AT&T	50.00
166	1	19	AT&T-100	100.00
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
172	3	6	Cardinal	5.00
181	3	6	Cardinal	7.00
16	3	6	Cardinal	10.00
17	3	6	Cardinal	20.00
48	3	6	Cardinal	50.00
171	3	6	Cardinal	100.00
174	3	6	Cardinal	250.00
136	3	31	Champion	5.00
111	3	31	Champion	10.00
193	3	31	Champion	15.00
112	3	31	Champion	20.00
194	3	31	Champion	30.00
113	3	31	Champion	50.00
114	3	31	Champion	100.00
175	3	31	Champion	250.00
482	3	112	Cheap Call	5.00
483	3	112	Cheap Call	10.00
484	3	112	Cheap Call	20.00
485	3	112	Cheap Call	50.00
486	3	112	Cheap Call	100.00
399	3	104	CheapStreet	5.00
400	3	104	CheapStreet	10.00
401	3	104	CheapStreet	20.00
405	3	104	CheapStreet	50.00
479	3	104	CheapStreet	100.00
133	1	34	Chopin	10.00
134	1	34	Chopin	20.00
135	1	34	Chopin	50.00
445	3	109	Continental	5.00
478	3	109	Continental	7.00
446	3	109	Continental	10.00
447	3	109	Continental	20.00
448	3	109	Continental	50.00
457	3	109	Continental	100.00
458	3	109	Continental	250.00
559	3	125	Discovery	5.00
560	3	125	Discovery	10.00
561	3	125	Discovery	20.00
562	3	125	Discovery	50.00
563	3	125	Discovery	100.00
564	3	125	Discovery	250.00
117	1	33	EastWest	10.00
118	1	33	EastWest	20.00
119	1	33	EastWest	50.00
276	3	50	El Toro	5.00
277	3	50	El Toro	10.00
278	3	50	El Toro	20.00
279	3	50	El Toro	50.00
280	3	50	El Toro	100.00
281	3	50	El Toro	250.00
289	1	59	EuroMaster	10.00
290	1	59	EuroMaster	20.00
291	1	59	EuroMaster	50.00
268	3	52	Everest	5.00
269	3	52	Everest	10.00
270	3	52	Everest	20.00
271	3	52	Everest	50.00
272	3	52	Everest	100.00
273	3	52	Everest	250.00
138	3	28	Express	5.00
91	3	28	Express	10.00
92	3	28	Express	20.00
93	3	28	Express	50.00
94	3	28	Express	100.00
176	3	28	Express	250.00
452	3	110	FastWorld	5.00
453	3	110	FastWorld	10.00
454	3	110	FastWorld	20.00
455	3	110	FastWorld	50.00
456	3	110	FastWorld	100.00
531	3	120	Golden Lotus	5.00
532	3	120	Golden Lotus	10.00
533	3	120	Golden Lotus	20.00
534	3	120	Golden Lotus	50.00
535	3	120	Golden Lotus	100.00
536	3	120	Golden Lotus	250.00
491	3	114	Hello from UK	5.00
492	3	114	Hello from UK	10.00
493	3	114	Hello from UK	20.00
494	3	114	Hello from UK	50.00
495	3	114	Hello from UK	100.00
496	3	114	Hello from UK	250.00
137	4	22	Jupiter	5.00
81	4	22	Jupiter	10.00
82	4	22	Jupiter	20.00
182	4	22	Jupiter	30.00
83	4	22	Jupiter	50.00
84	4	22	Jupiter	100.00
177	4	22	Jupiter	250.00
543	3	123	Lucky Minutes	5.00
544	3	123	Lucky Minutes	10.00
545	3	123	Lucky Minutes	20.00
546	3	123	Lucky Minutes	50.00
547	3	123	Lucky Minutes	100.00
522	3	119	Mariachi	5.00
523	3	119	Mariachi	10.00
524	3	119	Mariachi	20.00
525	3	119	Mariachi	50.00
526	3	119	Mariachi	100.00
527	3	119	Mariachi	250.00
130	1	36	Middle East	10.00
131	1	36	Middle East	20.00
132	1	36	Middle East	50.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
302	3	60	Partner	5.00
303	3	60	Partner	10.00
304	3	60	Partner	20.00
305	3	60	Partner	50.00
306	3	60	Partner	100.00
307	3	60	Partner	250.00
437	3	107	Penny Boss	5.00
438	3	107	Penny Boss	10.00
439	3	107	Penny Boss	20.00
440	3	107	Penny Boss	50.00
441	3	107	Penny Boss	100.00
442	3	107	Penny Boss	250.00
509	3	117	Royal Call	4.66
510	3	117	Royal Call	9.33
511	3	117	Royal Call	18.66
512	3	117	Royal Call	46.64
513	3	117	Royal Call	93.28
514	3	117	Royal Call	233.21
187	3	51	Sahara	5.00
188	3	51	Sahara	10.00
189	3	51	Sahara	20.00
190	3	51	Sahara	50.00
191	3	51	Sahara	100.00
192	3	51	Sahara	250.00
317	3	62	Saturn	5.00
312	3	62	Saturn	10.00
313	3	62	Saturn	20.00
318	3	62	Saturn	50.00
319	3	62	Saturn	100.00
320	3	62	Saturn	250.00
465	3	111	Simply	5.00
466	3	111	Simply	10.00
467	3	111	Simply	20.00
468	3	111	Simply	50.00
469	3	111	Simply	100.00
470	3	111	Simply	250.00
551	3	124	Solaris	5.00
552	3	124	Solaris	10.00
553	3	124	Solaris	20.00
554	3	124	Solaris	50.00
555	3	124	Solaris	100.00
126	1	39	StarCall	10.00
127	1	39	StarCall	20.00
129	1	39	StarCall	50.00
120	1	37	Tiger	10.00
121	1	37	Tiger	20.00
122	1	37	Tiger	50.00
283	3	49	Tigris	5.00
284	3	49	Tigris	10.00
285	3	49	Tigris	20.00
286	3	49	Tigris	50.00
287	3	49	Tigris	100.00
288	3	49	Tigris	250.00
50	1	16	TravelGlobe	10.00
51	1	16	TravelGlobe	20.00
52	1	16	TravelGlobe	50.00