      cve      |  id  |  mdksaid   | published  |    date    
---------------+------+------------+------------+------------
 CAN-2001-1034 | 3357 | 2002:055   | 2001-09-23 | 2002-08-28
 CAN-2001-1267 | 3024 | 2002:066   | 2001-07-12 | 2002-10-10
 CAN-2001-1268 | 5835 | 2002:065   | 2001-07-12 | 2002-10-10
 CAN-2002-0374 | 4679 | 2002:075   | 2002-05-06 | 2002-11-07
 CAN-2002-0384 | 5406 | 2002:054   | 2002-08-06 | 2002-08-01
 CAN-2002-0384 | 5406 | 2002:054-1 | 2002-08-06 | 2002-08-29
 CAN-2002-0391 | 5356 | 2002:057   | 2002-07-30 | 2002-09-09
 CAN-2002-0399 | 5834 | 2002:066   | 2002-09-30 | 2002-10-10
 CAN-2002-0825 | 6129 | 2002:075   | 2002-08-30 | 2002-11-07
 CAN-2002-0836 | 5978 | 2002:070   | 2002-10-16 | 2002-10-23
 CAN-2002-0836 | 5978 | 2002:071   | 2002-10-16 | 2002-10-24
 CAN-2002-0838 | 5808 | 2002:069   | 2002-09-26 | 2002-10-21
 CAN-2002-0839 | 5884 | 2002:068-1 | 2002-10-03 | 2002-10-15
 CAN-2002-0840 | 5847 | 2002:068-1 | 2002-10-02 | 2002-10-15
 CAN-2002-0843 | 5995 | 2002:068-1 | 2002-10-03 | 2002-10-15
 CAN-2002-0843 | 5996 | 2002:068-1 | 2002-10-03 | 2002-10-15
 CAN-2002-0972 | 5528 | 2002:062-1 | 2002-08-20 | 2002-10-01
 CAN-2002-0989 | 5574 | 2002:054   | 2002-08-27 | 2002-08-01
 CAN-2002-0989 | 5574 | 2002:054-1 | 2002-08-27 | 2002-08-29
 CAN-2002-1091 | 5665 | 2002:074   | 2002-09-06 | 2002-10-31
 CAN-2002-1119 | 5581 | 2002:082   | 2002-08-28 | 2002-11-25
 CAN-2002-1119 | 5581 | 2002:082-1 | 2002-08-28 | 2002-11-25
 CAN-2002-1126 | 5694 | 2002:074   | 2002-09-11 | 2002-10-31
 CAN-2002-1155 | 7790 | 2003:064   | 2003-06-03 | 2003-06-05
 CAN-2002-1157 | 6029 | 2002:072   | 2002-10-22 | 2002-10-24
 CAN-2002-1160 | 6753 | 2003:017   | 2003-02-03 | 2003-02-18
 CAN-2002-1165 | 5845 | 2002:083   | 2002-10-01 | 2002-11-28
 CAN-2002-1219 | 6160 | 2002:077   | 2002-11-12 | 2002-11-14
 CAN-2002-1220 | 6161 | 2002:077   | 2002-11-12 | 2002-11-14
 CAN-2002-1221 | 6159 | 2002:077   | 2002-11-12 | 2002-11-14
 CAN-2002-1235 | 6024 | 2002:073   | 2002-10-21 | 2002-10-29
 CAN-2002-1235 | 6024 | 2002:073-1 | 2002-10-21 | 2002-10-29
 CAN-2002-1277 | 6119 | 2002:085   | 2002-11-07 | 2002-12-02
 CAN-2002-1320 | 6120 | 2002:084   | 2002-11-07 | 2002-12-02
 CAN-2002-1336 | 5296 | 2003:022   | 2002-07-24 | 2003-02-24
 CAN-2002-1337 | 6991 | 2003:028   | 2003-03-02 | 2003-03-03
 CAN-2002-1344 | 6352 | 2002:086   | 2002-12-10 | 2002-12-11
 CAN-2002-1365 | 6390 | 2003:011   | 2002-12-13 | 2003-01-27
 CAN-2002-1373 | 6368 | 2002:087   | 2002-12-12 | 2002-12-18
 CAN-2002-1374 | 6373 | 2002:087   | 2002-12-12 | 2002-12-18
 CAN-2002-1375 | 6375 | 2002:087   | 2002-12-12 | 2002-12-18
 CAN-2002-1376 | 6370 | 2002:087   | 2002-12-12 | 2002-12-18
 CAN-2002-1376 | 6374 | 2002:087   | 2002-12-12 | 2002-12-18
 CAN-2002-1379 | 6620 | 2003:006   | 2002-12-06 | 2003-01-14
 CAN-2002-1380 | 6420 | 2003:039   | 2002-12-17 | 2003-03-27
 CAN-2002-1396 | 6488 | 2003:019   | 2002-12-27 | 2003-02-19
 CAN-2002-1398 | 6612 | 2002:062-1 | 2002-08-19 | 2002-10-01
 CAN-2002-1401 | 6610 | 2002:062-1 | 2002-08-28 | 2002-10-01
 CAN-2002-1401 | 6614 | 2002:062-1 | 2002-08-28 | 2002-10-01
 CAN-2002-1401 | 6615 | 2002:062-1 | 2002-08-19 | 2002-10-01
 CAN-2002-1402 | 6611 | 2002:062-1 | 2002-08-19 | 2002-10-01
 CAN-2002-1402 | 6613 | 2002:062-1 | 2002-08-19 | 2002-10-01
 CAN-2002-1509 | 6897 | 2003:026   | 2003-02-20 | 2003-02-26
 CAN-2002-1511 | 6905 | 2003:022   | 2002-11-15 | 2003-02-24
 CAN-2003-0001 | 6535 | 2003:039   | 2003-01-06 | 2003-03-27
 CAN-2003-0001 | 6535 | 2003:066   | 2003-01-06 | 2003-06-11
 CAN-2003-0015 | 6650 | 2003:009   | 2003-01-20 | 2003-01-20
 CAN-2003-0021 | 6936 | 2003:040   | 2003-02-24 | 2003-04-01
 CAN-2003-0022 | 6938 | 2003:034   | 2003-02-24 | 2003-03-25
 CAN-2003-0023 | 6947 | 2003:034   | 2003-02-24 | 2003-03-25
 CAN-2003-0026 | 6627 | 2003:007   | 2003-01-15 | 2003-01-17
 CAN-2003-0028 | 7123 | 2003:037   | 2003-03-17 | 2003-03-25
 CAN-2003-0033 | 6963 | 2003:029   | 2003-03-03 | 2003-03-06
 CAN-2003-0066 | 6953 | 2003:034   | 2003-02-24 | 2003-03-25
 CAN-2003-0078 | 6884 | 2003:020   | 2003-02-19 | 2003-02-21
 CAN-2003-0081 | 7049 | 2003:051   | 2003-03-08 | 2003-03-24
 CAN-2003-0101 | 6915 | 2003:025   | 2003-02-20 | 2003-02-26
 CAN-2003-0102 | 7008 | 2003:030   | 2003-03-04 | 2003-03-06
 CAN-2003-0102 | 7009 | 2003:030   | 2003-03-04 | 2003-03-06
 CAN-2003-0108 | 6974 | 2003:027   | 2003-02-27 | 2003-03-03
 CAN-2003-0127 | 7112 | 2003:038   | 2003-03-17 | 2003-03-27
 CAN-2003-0127 | 7112 | 2003:038-1 | 2003-03-17 | 2003-03-27
 CAN-2003-0127 | 7112 | 2003:039   | 2003-03-17 | 2003-03-27
 CAN-2003-0131 | 7148 | 2003:035   | 2003-03-19 | 2003-03-25
 CAN-2003-0136 | 7334 | 2003:060   | 2003-04-14 | 2003-05-21
 CAN-2003-0144 | 7025 | 2003:059   | 1998-04-22 | 2003-05-21
 CAN-2003-0146 | 6979 | 2003:036   | 2003-02-28 | 2003-03-25
 CAN-2003-0147 | 7101 | 2003:035   | 2003-03-14 | 2003-03-25
 CAN-2003-0150 | 7052 | 2003:057   | 2003-03-08 | 2003-05-14
 CAN-2003-0159 | 7050 | 2003:051   | 2003-03-08 | 2003-03-24
 CAN-2003-0189 | 7725 | 2003:063   | 2003-05-28 | 2003-05-30
 CAN-2003-0195 | 7637 | 2003:062   | 2003-05-20 | 2003-05-29
 CAN-2003-0196 | 7295 | 2003:044   | 2003-04-07 | 2003-04-07
 CAN-2003-0201 | 7294 | 2003:044   | 2003-04-07 | 2003-04-07
 CAN-2003-0209 | 7178 | 2003:052   | 2003-04-15 | 2003-04-28
 CAN-2003-0211 | 7382 | 2003:056   | 2003-04-18 | 2003-05-14
 CAN-2003-0244 | 7601 | 2003:066   | 2003-05-14 | 2003-06-11
 CAN-2003-0245 | 7723 | 2003:063   | 2003-05-28 | 2003-05-30
 CAN-2003-0246 | 7600 | 2003:066   | 2003-05-14 | 2003-06-11
 CAN-2003-0247 | 7791 | 2003:066   | 2003-06-03 | 2003-06-11
 CAN-2003-0248 | 7793 | 2003:066   | 2003-06-03 | 2003-06-11
 CAN-2003-0251 | 8031 | 2003:072   | 2003-02-05 | 2003-06-27
 CAN-2003-0255 | 7497 | 2003:061   | 2003-05-05 | 2003-05-22
 CAN-2003-0289 | 7565 | 2003:058   | 2003-05-13 | 2003-05-15
 CAN-2003-0289 | 7565 | 2003:058-1 | 2003-05-13 | 2003-05-15
 CAN-2003-0334 | 7551 | 2003:069   | 2003-05-10 | 2003-06-17
 CAN-2003-0356 | 7493 | 2003:067   | 2003-05-03 | 2003-06-16
 CAN-2003-0357 | 7494 | 2003:067   | 2003-05-03 | 2003-06-16
 CAN-2003-0357 | 7495 | 2003:067   | 2003-05-03 | 2003-06-16
 CAN-2003-0367 | 7872 | 2003:068   | 2003-06-11 | 2003-06-16
 CAN-2003-0428 | 7878 | 2003:070   | 2003-06-11 | 2003-06-23
 CAN-2003-0429 | 7880 | 2003:070   | 2003-06-11 | 2003-06-23
 CAN-2003-0431 | 7883 | 2003:070   | 2003-06-11 | 2003-06-23
 CAN-2003-0432 | 7881 | 2003:070   | 2003-06-11 | 2003-06-23
(104 rows)

select cvemdksa.cve,bugtraq.id,mdksa.mdksaid,bugtraq.published,mdksa.date from mdksa,cvemdksa,bugtraq where mdksa.mdksaid=cvemdksa.mdksaid and cvemdksa.cve=bugtraq.cve group by cvemdksa.cve,bugtraq.id,mdksa.mdksaid,bugtraq.published,mdksa.date ;

