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
                     

2755 1 126 AT&T 45.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 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 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 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 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 437 3 107 Master Cent 5.00 438 3 107 Master Cent 10.00 439 3 107 Master Cent 20.00 440 3 107 Master Cent 50.00 441 3 107 Master Cent 100.00 442 3 107 Master Cent 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 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 510 3 117 Royal Call 7.79 511 3 117 Royal Call 15.59 512 3 117 Royal Call 38.97 513 3 117 Royal Call 77.94 514 3 117 Royal Call 194.86 2763 3 117 Royal Call 250.00 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 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