dimmergeek
asked on
Need to filter SQL query results
I have a query that brings back the following recordset:
0301068 BR1 CB02B01 836 0 0
0301068 BR1 FCARRET 176 0 0
0301068 BR1 FCOFLOW 970 0 0
0301082 BR1 FC96A11 398 0 0
0301084 BR1 CB06C01 184 96 0
0301084 BR1 FF10B05 800 0 0
0301088 BR1 CB04F01 1932 96 0
0301089 BR1 FC95F07 131 0 0
0301094 BR1 FC86E01 675 0 0
0301095 BR1 FC95F09 2 0 0
0301106 BR1 FC92A01 111 0 0
0301107 BR1 CA16E01 494 144 0
0301107 BR1 FCARRET 9 0 0
0301110 BR1 FC93F09 21 0 0
0301112 BR1 FC93I01 276 0 0
0301126 BR1 FC86I01 400 0 0
030112601 BR1 FC90G02 100 0 0
030112603 BR1 FC87I01 200 0 0
0301255 BR1 CA13A01 240 0 0
0301273 BR1 FC57D02 474 0 0
0301276 BR1 FF08A03 9215 384 0
0301277 BR1 FC94I01 79 0 0
0301278 BR1 FC95C05 309 96 0
0301279 BR1 FC91G02 64 0 0
0301286 BR1 CB08B01 562 124 0
0301287 BR1 CB06E01 462 0 0
0301290 BR1 CA13G01 1118 0 0
0301293 BR1 CB01C01 530 602 0
0301293 BR1 FCARRET 10 0 0
0301294 BR1 CB05F01 1579 0 0
0301294 BR1 FCARRET 9 0 0
0301295 BR1 FC88I01 245 0 0
0301296 BR1 CA06B01 194 184 0
0301296 BR1 FCARRET 2 0 0
0301296 BR1 FCOFLOW 250 141 0
0301307 BR1 CA13I01 180 0 0
0301317 BR1 FG08A02 18985 3644 0
0301318 BR1 FC54C02 1241 0 0
0301322 BR1 FF02B03 2233 72 0
0301351 BR1 CA24B01 9111 718 0
0301355 BR1 FC63D01 787 0 0
0301356 BR1 FC89E03 352 0 0
0301358 BR1 CA05A03 152 0 0
0301359 BR1 CA04A06 163 0 0
0301362 BR1 CA07A04 52 0 0
0301363 BR1 FC92G02 254 0 0
0301366 BR1 FC93D11 97 0 0
0301367 BR1 FC92A03 132 0 0
0301370 BR1 CA01C01 125 0 0
0301374 BR1 CA10D01 4126 144 0
0301385 BR1 CA12A01 16 0 0
0301394 BR1 FC90I01 124 0 0
0301399 BR1 CA11B01 1299 0 0
0301400 BR1 CA12A02 23 0 0
0301404 BR1 CA06A01 208 0 0
0301405 BR1 CA06A02 25 0 0
0301407 BR1 FC54B02 158 0 0
0301408 BR1 FC51B01 303 0 0
0301409 BR1 FC91F01 214 0 0
0301410 BR1 FC90F01 2 0 0
0301411 BR1 FC94F09 100 0 0
0301412 BR1 FC95A11 6 0 0
0301413 BR1 FC95A13 6 0 0
0301414 BR1 FC88E03 162 6 0
0301415 BR1 CA08G01 185 184 0
0301415 BR1 FCARRET 1 0 0
0301416 BR1 CB09B01 4 0 0
0301416 BR1 FC58D01 400 0 0
0301427 BR1 FC91E05 191 0 0
0301428 BR1 FC95C06 12 0 0
0301468 BR1 FG16B02 2856 0 0
030148003 BR1 FC93A13 9 0 0
0301493 BR1 FC94A13 4 0 0
0301518 BR1 FC95C07 24 0 0
0301523 BR1 CA21A01 7000 59 0
0301523 BR1 FCARRET 7 0 0
0301523 BR1 FCOFLOW 235 0 0
0301526 BR1 CA03F01 856 0 0
0301540 BR1 CB12E01 1751 0 0
0301541 BR1 CB10B01 1503 0 0
0301541 BR1 FCARRET 1 0 0
0301543 BR1 FC87E03 277 0 0
0301597 BR1 FF06B01 4641 816 0
0301598 BR1 FG16C01 1419 0 0
0301599 BR1 CA23F01 1519 0 0
0301599 BR1 FF04A07 48 0 0
0301605 BR1 CA08D01 10170 384 0
0301610 BR1 CB11B01 3723 0 0
0301626 BR1 FC92C07 3380 384 0
0301629 BR1 FG19B06 900 300 0
0301631 BR1 CB07D02 432 0 0
0301631 BR1 FCOFLOW 500 0 0
030163101 BR1 CA02F02 712 0 0
030163103 BR1 CA02F02 6 0 0
030163103 BR1 FC95C08 72 48 0
0301637 BR1 FC96G13 127 48 0
0301641 BR1 FCOFLOW 2209 768 0
0301646 BR1 FCOFLOW 4405 0 0
0301650 BR1 FCOFLOW 6321 0 0
0301656 BR1 FCOFLOW 10746 0 0
030392 BR1 FC96I01 9 0 0
030578 BR1 CA01A03 831 0 0
030579 BR1 CA01A01 327 0 0
030705 BR1 FC93D03 411 58 0
030706 BR1 FC96D03 270 0 0
030707 BR1 CA11A02 1139 0 0
030724 BR1 FC49C01 3572 1000 0
030769 BR1 CA14D01 563 0 0
031362 BR1 FC56C01 1682 91 0
031376 BR1 CA08I02 108 0 0
032047 BR1 CB02I02 107 0 0
03204703 BR1 FC88D02 53 0 0
032355 BR1 CA09F01 200 0 0
032355 BR1 FCOFLOW 4 0 0
032365 BR1 FF12A04 12673 1020 0
032391 BR1 CA01G02 78 0 0
032391 BR1 FCOFLOW 100 0 0
033202 BR1 FC89I03 221 0 0
033203 BR1 CB07D01 249 0 0
033205 BR1 CA01B01 394 0 0
033206 BR1 CB02E01 500 0 0
033206 BR1 FCOFLOW 100 0 0
033207 BR1 FCOFLOW 1064 158 0
033208 BR1 CA08A03 48 0 0
033209 BR1 CB03C01 1189 0 0
033210 BR1 CA10A02 291 0 0
033211 BR1 CA10A01 274 35 0
033212 BR1 CB02I01 148 35 0
033217 BR1 CA11A01 101 0 0
033218 BR1 CA11I01 32 0 0
033226 BR1 FC53D01 455 0 0
033227 BR1 CA04A05 384 0 0
037207 BR1 FC96F09 50 0 0
037208 BR1 CA05A01 125 0 0
037209 BR1 CB03D01 1 164 0
037209 BR1 FCOFLOW 300 0 0
037210 BR1 CA07I01 18 0 0
037211 BR1 CA04A02 143 0 0
037212 BR1 FC95F11 23 23 0
037213 BR1 CA05A02 85 0 0
037228 BR1 CA10A03 31 0 0
037228 BR1 FC92H03 24 0 0
037229 BR1 CA08I03 4 0 0
037236 BR1 CA12A03 78 0 0
037237 BR1 CA18A02 54 0 0
040236 BR1 CA06D03 82 0 0
040371 BR1 CA06D01 104 48 0
041103 BR1 CA06D02 4 0 0
041112 BR1 CB04H03 288 0 0
043276 BR1 CA12A04 53 53 0
043276 BR1 FCOFLOW 24 24 0
044301 BR1 CA17A02 4 0 0
0471028 BR1 CA18F01 979 0 0
049201 BR1 FC49B01 8840 768 0
170194 BR1 FG16G02 2324 0 0
170194 BR1 FG19C01 287 48 0
170195 BR1 FG19C03 1031 0 0
170196 BR1 FF10A03 65 0 0
170283 BR1 FF14B01 166 0 0
170284 BR1 FF14B02 200 0 0
190135 BR1 FC91D01 670 0 0
190136 BR1 CA04E01 93 0 0
190136 BR1 FCARRET 2 0 0
190274 BR1 CA21C01 915 0 0
190332 BR1 FF02A06 628 0 0
19041303 BR1 FF16C03 100 0 0
19041325 BR1 FF18C03 43 43 0
19041341 BR1 FF20C03 10 0 0
19041342 BR1 FG15A06 102 96 0
19041403 BR1 FF18A03 279 0 0
190414122 BR1 FG02C03 5 0 0
190414123 BR1 FG04C03 50 0 0
19041414 BR1 FG06C03 25 0 0
190414142 BR1 FG07A06 1 0 0
190414143 BR1 FG07A05 100 0 0
19041427 BR1 FG07F02 3 0 0
19041433 BR1 FF20A03 90 0 0
19041470 BR1 FG07F01 452 0 0
19041475 BR1 FG07A04 89 0 0
19041476 BR1 FG09A01 1 0 0
19041477 BR1 FG05C02 57 0 0
19041478 BR1 CB06A01 61 0 0
19041478 BR1 FG09A02 100 0 0
190415122 BR1 FG17A03 3 0 0
190415142 BR1 FG17A08 2 0 0
190415145 BR1 CB19E01 35 0 0
19041533 BR1 FG17A07 1 0 0
19041575 BR1 CA04B01 54 0 0
19041576 BR1 FG17A05 45 0 0
19041577 BR1 FF16C01 23 0 0
190423 BR1 CB10A01 57 0 0
190424 BR1 CA12D01 36 0 0
190424 BR1 FCARRET 7 0 0
233111 BR1 CA16A01 313 0 0
233111 BR1 FCOFLOW 200 0 0
233273 BR1 FC63C02 4047 0 0
2411048 BR1 FH04C02 250 0 0
2411048 BR1 FH10D01 18 0 0
2411096 BR1 FH06C02 170 0 0
2411096 BR1 FH06E02 106 0 0
2411230 BR1 FH18C02 20 0 0
2411248113 BR1 FH10D02 44 0 0
2411574 BR1 FH14A01 50 0 0
2411623 BR1 FH08B01 500 0 0
2411624 BR1 FH02B01 25 0 0
2411636 BR1 FH04B02 11 0 0
2411688 BR1 FH12E01 54 0 0
2411701 BR1 FH12D02 70 0 0
241505 BR1 FH08E01 100 0 0
241507 BR1 FH18B01 5 0 0
241510 BR1 FH06D01 29 0 0
241510 BR1 FH06D02 50 0 0
241511 BR1 FH04D01 25 0 0
241511 BR1 FH06E01 36 0 0
241532 BR1 FH18B02 30 0 0
241538 BR1 FH18C01 26 0 0
241576 BR1 FH16A02 110 0 0
241577 BR1 FH04B01 104 0 0
241577 BR1 FH08D02 104 0 0
241579 BR1 FH16A01 22 0 0
241590 BR1 FH08B02 20 0 0
241591 BR1 FH16B01 53 0 0
241593 BR1 FH06A02 9 0 0
241595 BR1 FH08C02 103 0 0
241606 BR1 FH06B02 15 0 0
241615 BR1 FH08B01 94 0 0
241689 BR1 FH14B02 9 0 0
241690 BR1 FH12D01 28 0 0
241690 BR1 FH14B01 12 0 0
241714115 BR1 FH12A02 6 0 0
241720 BR1 FH02B01 11 0 0
241721 BR1 FH02B02 14 0 0
241724 BR1 FH06C01 36 0 0
241725 BR1 FH04C01 13 0 0
241725 BR1 FH04C02 10 0 0
241727 BR1 FH04D02 25 0 0
241729 BR1 FH08A01 15 0 0
241732 BR1 FH02C01 20 0 0
241732 BR1 FH04A01 2 0 0
241739 BR1 FH02A01 90 0 0
241740 BR1 FH02A02 116 0 0
241992115 BR1 FH12A01 10 0 0
2441062 BR1 FH02C01 19 0 0
244505 BR1 FH04A02 87 0 0
244516 BR1 FH18A01 14 0 0
244519 BR1 FH06B01 6 0 0
244524 BR1 FH06A01 9 0 0
244526 BR1 FH02B01 10 0 0
244783 BR1 FH10E02 25 0 0
244783 BR1 FH14C01 30 0 0
244784 BR1 FH08C01 7 0 0
244785 BR1 FH12E02 15 0 0
244785 BR1 FH14A02 17 0 0
244785 BR1 FH14C02 10 0 0
244786 BR1 FH08E02 34 0 0
244786 BR1 FH10E01 6 0 0
244786 BR1 FH10E02 34 0 0
244788 BR1 FH08D01 10 0 0
244788 BR1 FH16C01 20 0 0
244789 BR1 FH14C02 19 0 0
244980 BR1 FH16C02 20 0 0
244982 BR1 FH08A02 6 0 0
250905 BR1 FC93F11 151 151 0
254057 BR1 FC94D01 371 0 0
255043 BR1 FC94A01 195 0 0
255077 BR1 FC95D01 448 0 0
256114 BR1 CA06E01 589 0 0
262104 BR1 FC57C02 1859 35 0
280103227 BR1 FC84D02 4 0 0
280106725 BR1 FC82F03 107 0 0
280106727 BR1 CA26I01 98 0 0
280106741 BR1 FC81E01 194 0 0
280106744 BR1 FC81F03 124 0 0
280123203 BR1 FC96D09 244 0 0
280123227 BR1 CA02E01 13230 1244 0
280123227 BR1 FCARRET 1 0 0
280123241 BR1 CB09A01 360 0 0
280123242 BR1 CA01H02 1 0 0
280123243 BR1 FC94E09 141 0 0
280123244 BR1 CB03B02 261 0 0
280123244 BR1 FCOFLOW 1005 0 0
280127125 BR1 FC84D03 39 0 0
280127127 BR1 CA02A01 2249 0 0
280127144 BR1 CA01A01 34 0 0
280127144 BR1 FC81I01 1 1 0
280129103 BR1 FC95D11 22 0 0
280129125 BR1 FC96E09 99 0 0
280129141 BR1 FC91G04 533 0 0
280129143 BR1 CA04A01 52 0 0
280209327 BR1 FC95C11 167 0 0
280209341 BR1 CA18H02 2045 0 0
280209342 BR1 CA32B01 48 0 0
280209344 BR1 CB07E01 653 48 0
28032401 BR1 CA22C01 1030 0 0
28032441 BR1 FF08C04 1346 0 0
28032444 BR1 FF14C02 1858 0 0
28033801 BR1 CB05A01 197 0 0
28033844 BR1 FC49A02 1260 0 0
28049703 BR1 FG16C06 614 0 0
28049725 BR1 FG16C04 598 0 0
28049727 BR1 CA15B01 1340 0 0
28049741 BR1 CB01B01 558 0 0
28049742 BR1 FG18C02 522 0 0
28049743 BR1 CB04I01 316 0 0
28049744 BR1 FG18C05 771 0 0
28049803 BR1 FC53D03 88 0 0
280498122 BR1 FC90E01 137 0 0
280498124 BR1 FC92I01 118 48 0
280498125 BR1 CA08A02 49 0 0
28049814 BR1 CA06I01 2 0 0
28049814 BR1 FC55D01 219 0 0
280498142 BR1 FC55D02 309 0 0
280498143 BR1 CA30C02 38 0 0
280498145 BR1 FC52D03 149 0 0
28049827 BR1 CA05B01 202 0 0
28049833 BR1 FC91I03 86 0 0
28049870 BR1 CB06F01 48 0 0
28049872 BR1 FC90I03 96 0 0
28049875 BR1 FC91F03 100 0 0
28049876 BR1 FC49C02 66 0 0
28049877 BR1 CA04A04 120 0 0
28049878 BR1 FC57A01 163 0 0
28049882 BR1 FC90D02 70 0 0
28051025 BR1 FC95D13 488 0 0
28051027 BR1 FC93D09 399 0 0
28051041 BR1 FC58A01 2652 0 0
28051042 BR1 FC96A01 148 0 0
28051044 BR1 CA07A01 260 0 0
28051103 BR1 FC93D13 201 0 0
28051125 BR1 FC93D05 355 0 0
28051127 BR1 FC51C01 4885 622 0
28051141 BR1 CA01G03 388 0 0
28051141 BR1 FC95D03 200 0 0
28051142 BR1 CA08I01 137 0 0
28051143 BR1 CA03A01 81 0 0
28051144 BR1 FC87D01 1840 0 0
28051325 BR1 FC92D03 698 0 0
28068503 BR1 FC91A05 97 0 0
28068527 BR1 CA17I01 449 0 0
28068527 BR1 FCOFLOW 100 0 0
28068533 BR1 FC90A05 113 0 0
28068570 BR1 CA19E01 376 0 0
28068570 BR1 FCARRET 1 0 0
28077403 BR1 CA34G01 682 0 0
28077425 BR1 CA17B01 2082 0 0
28077427 BR1 CA04H01 3934 0 0
28077427 BR1 FCARRET 12 0 0
28077433 BR1 FC96E11 162 0 0
28077442 BR1 FC92E03 333 0 0
28077443 BR1 FC96A03 74 0 0
28077444 BR1 CA02G01 164 0 0
28077470 BR1 CA02G04 395 0 0
28077503 BR1 CA02G02 557 0 0
28077525 BR1 CB16H01 4129 0 0
28077527 BR1 CA01G01 1544 56 0
28077527 BR1 FCARRET 59 0 0
28077533 BR1 FC95E11 169 0 0
28077541 BR1 CB01E01 4251 0 0
28077542 BR1 FC96D07 32 0 0
28077543 BR1 FC94A03 70 0 0
28077544 BR1 CB04H01 72 0 0
28077570 BR1 CB04H02 468 0 0
28082301 BR1 FG12B01 9175 336 0
28082344 BR1 FG14B01 5971 336 0
28082627 BR1 FC84E01 316 0 0
28082703 BR1 FF06C01 1235 0 0
28082725 BR1 FF06A04 2888 0 0
28082727 BR1 FF14A02 537 0 0
28082741 BR1 FG10B01 3156 48 0
28082742 BR1 FF14A03 395 0 0
28082743 BR1 FC82F04 54 0 0
28082744 BR1 FG16C05 275 0 0
28084201 BR1 FC54E01 631 0 0
28084244 BR1 FC89A03 550 0 0
28094103 BR1 FC81F04 66 0 0
28094125 BR1 FC81B04 149 0 0
28094127 BR1 FC84E02 2 0 0
28094141 BR1 FC82G01 7 6 0
28095203 BR1 CA01H01 614 6 0
28095203 BR1 FCOFLOW 1000 0 0
28095225 BR1 CB05H01 188 528 0
28095225 BR1 FCARRET 1 0 0
28095225 BR1 FCOFLOW 367 0 0
28095227 BR1 FC90E07 961 0 0
28095241 BR1 CA02G03 655 0 0
28095244 BR1 FC92F07 1616 0 0
28099625 BR1 FC95A03 38 0 0
28099627 BR1 FC94D13 116 0 0
28099644 BR1 FC93A03 25 0 0
28099903 BR1 CA07A03 123 0 0
293014 BR1 FC58C01 9760 0 0
293080 BR1 FG20B01 1735 264 0
293089 BR1 FC49F01 76 0 0
293133 BR1 CA30E02 108 0 0
293135 BR1 FF02C01 2485 0 0
293136 BR1 FF10A01 34863 1806 0
293138 BR1 FF12A01 33116 1675 0
293146 BR1 CA18H01 429 0 0
293146 BR1 FCARRET 1 0 0
293148 BR1 FF08A01 31387 1375 0
293148 BR1 FG19B06 1200 0 0
293153 BR1 FG10C06 2213 35 0
294205 BR1 CA30G01 1481 0 0
322503 BR1 FC51C03 1711 0 0
33510025 BR1 CA04A03 87 0 0
33510027 BR1 FC84E03 2 0 0
33510041 BR1 FC82G02 116 0 0
33510044 BR1 FC81G02 159 0 0
33511103 BR1 FF10C01 18 18 0
33511125 BR1 FF10C02 1789 0 0
33511127 BR1 FG20B02 2387 288 0
33511141 BR1 FH03F01 1610 0 0
33511142 BR1 CB05C01 480 0 0
33511142 BR1 FCOFLOW 768 0 0
33511143 BR1 CA11F01 274 0 0
33511144 BR1 CA04C01 46 0 0
33511144 BR1 FCOFLOW 233 0 0
33511203 BR1 FC58D02 192 0 0
335112122 BR1 FC88D04 113 0 0
335112123 BR1 FC90G04 40 0 0
33511214 BR1 FC53D02 223 0 0
335112142 BR1 FC86A01 27 0 0
335112143 BR1 FC86D03 125 0 0
335112145 BR1 FC91A07 54 0 0
33511227 BR1 FC57C03 658 0 0
33511233 BR1 FC63A01 161 0 0
33511270 BR1 CA05B02 170 0 0
33511275 BR1 FC88A03 65 0 0
33511276 BR1 FC87D04 131 0 0
33511277 BR1 FC87F01 108 0 0
33511278 BR1 FC91D02 52 0 0
33511303 BR1 FC82G03 106 0 0
33511327 BR1 FC84E04 769 0 0
33511341 BR1 CA16B01 384 91 0
33511342 BR1 FC81G03 149 0 0
33511344 BR1 FC82I02 109 0 0
33511427 BR1 FC91I05 52 0 0
33511470 BR1 FC92D02 74 0 0
335115027 BR1 CB14D01 708 0 0
3351205413 BR1 CB09D01 738 0 0
335121503 BR1 FF15A04 16 0 0
335121525 BR1 CA24G01 75 0 0
335121541 BR1 FG14C03 128 0 0
335121542 BR1 CA26G01 58 0 0
335121543 BR1 CA24E01 178 0 0
335121544 BR1 FF15A05 90 0 0
335125127 BR1 FC84D01 255 0 0
335125141 BR1 CB10E01 1686 0 0
335125142 BR1 CA33E01 145 0 0
335125144 BR1 CA15D01 964 48 0
33513527 BR1 FC84F01 4 0 0
33513544 BR1 FC82G04 72 0 0
33514025 BR1 FC81I02 85 0 0
33514041 BR1 FC81G04 110 0 0
33514044 BR1 FC82H01 113 0 0
33523903 BR1 FF12C04 180 0 0
33523925 BR1 FF12C03 858 0 0
33523927 BR1 FC81H01 192 0 0
33523941 BR1 FC81E02 120 0 0
33523944 BR1 FF12C02 882 0 0
33524227 BR1 FC84F02 88 0 0
33555627 BR1 FC84F03 2 0 0
33561503 BR1 FC82D01 118 0 0
33561525 BR1 FC82E03 96 0 0
33561543 BR1 FC82I03 70 12 0
33564425 BR1 FF12C05 620 0 0
33564441 BR1 FC82D02 16 0 0
33569427 BR1 FC81D02 35 0 0
33572427 BR1 FC82D03 110 0 0
335726 BR1 CB07G01 181 0 0
350150203 BR1 FC51F01 22 0 0
3501502122 BR1 FC52F01 51 0 0
350150214 BR1 FG10C01 52 0 0
3501502142 BR1 FG10C02 19 0 0
3501502143 BR1 FG10C03 29 0 0
350150227 BR1 FG10C04 107 107 0
350150270 BR1 FG12C01 85 0 0
350150275 BR1 FC53F01 48 0 0
350150276 BR1 FC58B03 24 0 0
350150277 BR1 FG08C03 95 0 0
350176303 BR1 CA25D01 707 0 0
350176325 BR1 FC82A01 48 0 0
350176327 BR1 FCOFLOW 143 0 0
350176341 BR1 CB13D01 346 0 0
350176341 BR1 FCARRET 8 0 0
350176342 BR1 CB12D01 142 0 0
350176343 BR1 FC82A02 73 0 0
350176344 BR1 CA16A03 24 0 0
350176403 BR1 CA15A01 101 0 0
3501764122 BR1 FC86A02 48 0 0
350176414 BR1 FC87A02 75 0 0
3501764142 BR1 FC92A07 76 0 0
350176427 BR1 CA14A02 85 0 0
350176433 BR1 FC54F01 130 0 0
350176470 BR1 FC55F02 83 0 0
350176476 BR1 FC86B02 45 0 0
350176477 BR1 FC63A02 111 0 0
350176503 BR1 FC81A02 81 0 0
350176525 BR1 CB17F01 120 0 0
350176527 BR1 FG20C06 60 36 0
350176541 BR1 FC81I03 12 0 0
350176542 BR1 FC82A03 48 0 0
350176543 BR1 FC84F04 12 0 0
350176544 BR1 CA33A01 26 0 0
350176603 BR1 FC86D04 107 0 0
350176614 BR1 FC88A02 57 0 0
350176627 BR1 FC92G01 70 0 0
350176633 BR1 FC89A02 93 0 0
350176670 BR1 FC58A02 163 0 0
350176677 BR1 FC90A02 54 0 0
350176803 BR1 FC55F01 98 72 0
3501768122 BR1 FC96A05 27 0 0
350176814 BR1 FC56F01 121 0 0
3501768142 BR1 FC92D04 53 0 0
350176827 BR1 FC86E03 82 0 0
350176833 BR1 FC57F01 140 0 0
350176870 BR1 FC55E01 136 0 0
350176876 BR1 FC89A04 81 0 0
350176877 BR1 FC58F01 141 0 0
350178503 BR1 FC88F01 125 0 0
3501785122 BR1 FC89D01 132 0 0
3501785123 BR1 FC87A01 168 35 0
3501785124 BR1 FC91D04 94 48 0
3501785125 BR1 FC88A04 39 0 0
350178514 BR1 CA09A01 168 0 0
3501785142 BR1 FC51D01 243 0 0
3501785145 BR1 FC58E02 200 0 0
350178527 BR1 CB07C01 7 0 0
350178527 BR1 FCOFLOW 8 0 0
350178533 BR1 FC87A04 71 0 0
350178570 BR1 CB03G01 126 0 0
350178572 BR1 FC90D04 107 0 0
350178575 BR1 FC89E01 120 0 0
350178576 BR1 CB02G01 29 0 0
350178577 BR1 FC92D06 73 0 0
350178578 BR1 FC57A02 220 0 0
350178582 BR1 FC86A04 77 0 0
350182503 BR1 FC81E03 213 0 0
350182525 BR1 FC81D03 200 0 0
350182527 BR1 FG18B01 3385 836 0
350182541 BR1 CA23B01 835 0 0
350182542 BR1 FC82E04 106 0 0
350182543 BR1 FC82B04 48 0 0
350182544 BR1 CA19B01 1075 0 0
350182625 BR1 FC81A03 72 0 0
350182627 BR1 FC82A04 112 0 0
350182641 BR1 FC82C01 57 0 0
350182644 BR1 FC81C01 16 0 0
350182725 BR1 FC81E04 239 0 0
350182727 BR1 FC82D04 168 0 0
350182741 BR1 FF14C03 2275 0 0
350182742 BR1 FC81A04 60 0 0
350182744 BR1 CB09G01 22 0 0
350182803 BR1 FC81D04 102 0 0
350182825 BR1 FF13A01 335 0 0
350182827 BR1 FG10A01 9035 622 0
350182841 BR1 CA05C01 694 0 0
350182841 BR1 FCOFLOW 24 0 0
350182843 BR1 FC81F01 141 0 0
350182844 BR1 CA21E01 3488 0 0
350199327 BR1 FF06B05 101 0 0
350199370 BR1 FF04B05 98 0 0
350220803 BR1 FG12C03 113 0 0
350220825 BR1 FG08A01 3138 0 0
350220827 BR1 FF21G01 7500 0 0
350220827 BR1 FG19C05 2494 3314 0
350220841 BR1 FG19A01 994 65 0
350220841 BR1 FH01F01 11255 0 0
350220844 BR1 CA14B01 653 0 0
350220844 BR1 FCARRET 9 0 0
350239203 BR1 FC81B03 98 0 0
350239227 BR1 FC84G01 4 0 0
350239444 BR1 FC84A03 8 0 0
3502730 BR1 FG20C04 144 0 0
350277603 BR1 CB15B01 289 0 0
350277625 BR1 CA26A01 238 0 0
350277627 BR1 FG11F01 1757 0 0
350277641 BR1 CB01H01 323 0 0
350277642 BR1 CB15D01 314 0 0
350277643 BR1 CB09I01 288 0 0
350277644 BR1 CB14B01 83 0 0
350281403 BR1 FC63F01 82 0 0
350281427 BR1 CB08A01 100 0 0
350281433 BR1 FC94B03 8 0 0
350281470 BR1 CB04A01 94 0 0
350281477 BR1 FC91G06 25 0 0
350281503 BR1 FG08C01 666 0 0
3502815122 BR1 CA30I01 15 0 0
3502815123 BR1 FC89B02 52 0 0
350281514 BR1 FC63B03 27 0 0
3502815142 BR1 FC89E02 54 0 0
350281527 BR1 FG20C02 338 0 0
350281576 BR1 CA14A01 25 0 0
350281577 BR1 FC56B03 185 0 0
350282603 BR1 FF02C03 140 140 0
350282625 BR1 CB12B01 649 528 0
350282627 BR1 FC82E01 341 0 0
350282641 BR1 CB01F01 262 0 0
350282644 BR1 FF02A01 1 0 0
350290825 BR1 FC82B01 24 0 0
350304625 BR1 CA27I01 13 0 0
350304627 BR1 FC84B01 46 0 0
350307027 BR1 FC84B02 4 0 0
350322625 BR1 FC82B02 125 0 0
350322641 BR1 FC82F02 111 0 0
350322644 BR1 FC81B02 134 0 0
350334 BR1 FC93I03 5 0 0
350386803 BR1 FF13A05 210 0 0
350386825 BR1 FC84B03 6 0 0
350386827 BR1 CA08B01 302 0 0
350386842 BR1 FC82B03 60 0 0
350413303 BR1 FC87E02 65 0 0
350413327 BR1 FC55A02 12 12 0
350413370 BR1 FC57E02 75 0 0
350413403 BR1 FC84B04 6 0 0
350413425 BR1 FC82C02 24 0 0
350413427 BR1 FC81C02 72 0 0
350413441 BR1 FC82C03 48 0 0
350413442 BR1 FC81C03 23 0 0
350413443 BR1 FC84C01 4 0 0
350413444 BR1 FC84I02 8 0 0
350446203 BR1 FF06C02 1045 0 0
350446225 BR1 CA20B01 2319 0 0
350446227 BR1 CA13E01 525 0 0
350446227 BR1 FCARRET 3 0 0
350446227 BR1 FCOFLOW 648 0 0
350446241 BR1 CB08D01 90 0 0
350446242 BR1 FG18C04 289 0 0
350446243 BR1 FC82H02 59 0 0
350446244 BR1 CA06G01 6 0 0
350446303 BR1 FC81H02 54 0 0
350446325 BR1 CA17C01 1814 0 0
350446327 BR1 CB08I01 1 0 0
350446341 BR1 CA03D01 896 0 0
350446344 BR1 FC81F02 190 0 0
350446403 BR1 FC86A03 91 0 0
350446427 BR1 FC53E01 133 37 0
350446427 BR1 FCOFLOW 720 0 0
350446433 BR1 FC96I05 5 0 0
350446470 BR1 FC57D03 371 0 0
350446527 BR1 FC95I05 20 0 0
350446570 BR1 FC94I05 57 0 0
350472225 BR1 FC84I03 15 0 0
350472227 BR1 FF08A04 2381 0 0
350472241 BR1 FC84G03 8 0 0
350472244 BR1 FC82I04 153 0 0
370182 BR1 FH02C02 7500 0 0
390072 BR1 FCOFLOW 25 0 0
390161 BR1 FG18G02 1080 0 0
390290 BR1 FC31A02 25 0 0
390344 BR1 FG14G01 135 0 0
390371 BR1 FG06G02 750 750 0
390382 BR1 FC31A03 100 0 0
390388 BR1 FG14G02 960 0 0
390390 BR1 FG18F01 125 0 0
390391 BR1 FG20F01 60 0 0
390459 BR1 FH11F02 150 0 0
390473 BR1 FCOFLOW 8 0 0
390534 BR1 FG16F01 750 0 0
390535 BR1 FG18F02 960 0 0
390536 BR1 FH07F01 700 0 0
390537 BR1 FH07F02 1000 0 0
390540 BR1 FG20F02 2100 0 0
390541 BR1 FG16G01 1200 0 0
390544 BR1 FH01G02 1500 0 0
390545 BR1 FH09G01 250 0 0
390554 BR1 FG14F01 60 0 0
390555 BR1 FG14F02 2160 2160 0
390557 BR1 FG15G01 4200 3780 0
390730 BR1 FG13F01 750 0 0
390734 BR1 FG11F02 600 0 0
390741 BR1 FC31A04 5 0 0
390744 BR1 FC31A05 20 0 0
390892 BR1 FH09G02 520 0 0
390893 BR1 FH03A01 625 0 0
390894 BR1 FC31A06 40 0 0
390906 BR1 FCOFLOW 765 0 0
390907 BR1 FH03A02 780 0 0
390914 BR1 FC31A07 40 0 0
400054 BR1 FC95C14 12 0 0
400063 BR1 FC49B02 127 0 0
4001278 BR1 FC93I05 6 0 0
4001508 BR1 FF10A06 230 0 0
4001536 BR1 FG05G02 716 0 0
4001537 BR1 FG05G01 1000 0 0
4001539 BR1 FG03G01 8960 0 0
400164 BR1 FC54F02 2 0 0
400165 BR1 FCOFLOW 147 0 0
4001669 BR1 FC95A05 100 0 0
400170 BR1 FC58D03 128 56 0
4001763 BR1 FC54A02 202 0 0
4001811 BR1 FCOFLOW 63 0 0
4001821 BR1 FC87H02 4 0 0
4001823 BR1 FC94H07 89 0 0
4001824 BR1 FF04A03 230 0 0
4001825 BR1 FF04B04 220 0 0
4001859 BR1 FF06B04 250 0 0
4002050 BR1 FG16B01 550 0 0
4002168 BR1 FC91D06 102 0 0
4002171 BR1 FF13A02 256 0 0
4002172 BR1 FG08G01 3840 0 0
4002174 BR1 FF13A03 312 0 0
4002175 BR1 FF13A04 156 0 0
4002234 BR1 FH11G02 1000 0 0
4002386 BR1 FC86E02 108 0 0
4002388 BR1 FC57A03 107 0 0
4002394 BR1 FC95I07 24 0 0
4002407 BR1 FC52B02 83 0 0
400244 BR1 FC91A02 78 0 0
4002464 BR1 FC94I07 2 0 0
4002467 BR1 FC89B01 132 0 0
4002468 BR1 FC96I09 57 0 0
4002471 BR1 FC49D02 216 0 0
4002478 BR1 FC53B02 129 0 0
4002484 BR1 FC95I09 7 0 0
4002486 BR1 FC87E04 58 0 0
4002514 BR1 CB07B01 250 0 0
4002526 BR1 FC52A02 279 0 0
4002551 BR1 FC90D06 56 0 0
4002564 BR1 FC93G04 101 0 0
4002597 BR1 FC90A07 146 6 0
4002683 BR1 FH13G01 4000 0 0
4002728 BR1 FC91D08 276 0 0
4002730 BR1 FC89F03 270 0 0
4002865 BR1 FC90G08 51 0 0
4002929 BR1 FG07G01 8704 0 0
400295 BR1 FC93I09 2 0 0
4002968 BR1 FC92H05 12 0 0
400298 BR1 FC96I11 2 0 0
4003032 BR1 FC96B03 4 0 0
4003035 BR1 FC87B01 130 0 0
4003036 BR1 FC94A05 55 0 0
4003038 BR1 FC91G01 30 0 0
4003039 BR1 FC95B05 23 0 0
4003046 BR1 FC93B05 6 0 0
4003047 BR1 CA25F01 458 0 0
4003060 BR1 FF15A01 160 0 0
4003124 BR1 FC96G04 32 0 0
4003162 BR1 FF15A03 140 0 0
4003217 BR1 FF14A04 525 0 0
4003283 BR1 FC95B07 25 0 0
4003284 BR1 FC93B07 25 0 0
4003286 BR1 CA18A01 60 0 0
4003292 BR1 CA29A01 241 0 0
4003292 BR1 FCOFLOW 240 0 0
4003299 BR1 FG09G01 3150 0 0
4003315 BR1 CA19A01 701 0 0
4003322 BR1 CA17A01 3 0 0
4003326 BR1 FC94B07 6 0 0
4003327 BR1 CB03A01 339 0 0
4003328 BR1 FC51E01 193 0 0
4003330 BR1 FC88F03 104 0 0
4003331 BR1 FC49A03 46 0 0
4003435 BR1 FC96B07 100 48 0
4003443 BR1 CA10B01 1112 0 0
4003444 BR1 CB14F01 618 0 0
4003445 BR1 CA26E01 560 0 0
4003446 BR1 CA27E01 1200 0 0
4003447 BR1 CA26B01 138 0 0
4003448 BR1 FC49B03 156 0 0
4003449 BR1 CA26C01 762 0 0
4003450 BR1 FC49E01 77 0 0
4003451 BR1 FC91H01 67 0 0
4003452 BR1 CA25I01 604 0 0
4003454 BR1 CA23A01 124 0 0
4003455 BR1 FC91H02 50 0 0
4003476 BR1 FC49C03 210 0 0
4003477 BR1 FC54B03 198 0 0
4003485 BR1 FC95B09 115 0 0
4003498 BR1 FC54A03 118 118 0
4003500 BR1 FC92H02 50 0 0
4003501 BR1 FC88B01 103 0 0
4003506 BR1 FF02B01 607 0 0
4003507 BR1 FC93B09 4 0 0
4003508 BR1 FC51A02 145 0 0
4003510 BR1 CA03I01 194 0 0
4003510 BR1 FCOFLOW 192 0 0
4003511 BR1 FC94B09 66 0 0
4003513 BR1 CA29B01 200 0 0
4003517 BR1 FC90H02 50 0 0
4003520 BR1 FG18B02 1564 96 0
4003521 BR1 FC58B01 125 0 0
4003521 BR1 FC58D01 48 0 0
4003523 BR1 FC57B01 154 0 0
4003526 BR1 CA04I01 246 0 0
4003527 BR1 FC96B09 113 0 0
4003528 BR1 FC93B11 8 0 0
4003529 BR1 CA10G01 160 0 0
4003531 BR1 FC87F02 69 0 0
4003534 BR1 CA20A01 25 0 0
4003535 BR1 FC96B11 29 0 0
4003536 BR1 FC95B11 35 0 0
4003537 BR1 FC93G06 30 0 0
4003541 BR1 FC55B03 88 0 0
4003543 BR1 FC63B01 157 0 0
4003544 BR1 FC54D03 126 0 0
4003545 BR1 FC93B13 25 0 0
4003546 BR1 FC94B13 25 0 0
4003549 BR1 CA29E03 19 0 0
4003550 BR1 FCOFLOW 15 0 0
4003552 BR1 FC86E04 84 0 0
4003554 BR1 FC96B13 5 0 0
4003555 BR1 FC95B13 6 0 0
4003556 BR1 FC93C01 13 0 0
4003560 BR1 FG08B01 1000 0 0
4003563 BR1 CA12H01 960 0 0
4003564 BR1 CA16A02 4 0 0
4003565 BR1 FC55E02 75 0 0
4003566 BR1 CA20A02 48 0 0
4003567 BR1 FC92H04 60 0 0
4003569 BR1 CA22H01 401 0 0
4003570 BR1 CA22E01 400 0 0
4003571 BR1 FC94C01 25 0 0
4003572 BR1 FC58F02 199 0 0
4003577 BR1 FC63E03 114 0 0
4003580 BR1 FC88F02 98 0 0
4003581 BR1 FC56B01 138 0 0
4003582 BR1 CA15A02 189 0 0
4003583 BR1 CA34E01 133 142 0
4003583 BR1 FCOFLOW 400 0 0
4003584 BR1 FC63D03 250 0 0
4003586 BR1 FC91H04 86 0 0
4003587 BR1 FC93G08 51 0 0
4003588 BR1 CA27B01 979 0 0
4003589 BR1 FC57F02 150 0 0
4003590 BR1 CA29E02 72 0 0
4003591 BR1 CA29A02 218 0 0
4003593 BR1 FC90H04 74 0 0
4003594 BR1 FC56E03 185 0 0
4003595 BR1 FC96G08 28 0 0
4003596 BR1 CA21H01 475 21 0
4003597 BR1 CB08G01 456 144 0
4003599 BR1 CA14F01 128 0 0
4003606 BR1 FC96C01 25 0 0
4003607 BR1 CB04D01 346 0 0
4003609 BR1 FCOFLOW 4 4 0
4003610 BR1 FC95C01 11 0 0
4003615 BR1 FC58E03 104 0 0
4003616 BR1 CA30E01 159 0 0
4003619 BR1 CB04C01 698 0 0
4003620 BR1 CB05I01 40 0 0
4003620 BR1 FC88H02 15 0 0
4003623 BR1 FC92H06 168 35 0
4003624 BR1 CB06H01 125 0 0
4003625 BR1 FC92A02 90 0 0
4003626 BR1 FC91H06 50 0 0
4003627 BR1 CA05H01 359 0 0
4003627 BR1 FC57E03 250 0 0
4003629 BR1 CA01I01 4 72 0
4003629 BR1 FCOFLOW 72 0 0
4003630 BR1 FC52A03 160 0 0
4003635 BR1 FC53E02 141 0 0
4003637 BR1 CA09B01 131 0 0
4003639 BR1 CA22F01 205 0 0
4003640 BR1 FC93G10 77 0 0
4003647 BR1 CA09H01 217 0 0
4003652 BR1 CB18A01 1354 0 0
4003652 BR1 FCARRET 47 0 0
4003654 BR1 FC93C03 10 0 0
4003655 BR1 FC94C03 18 0 0
4003659 BR1 CB17A01 380 48 0
4003667 BR1 FC87F04 89 0 0
4003668 BR1 FF02B02 1420 0 0
4003669 BR1 CA30A01 125 0 0
4003675 BR1 CA32A02 6 0 0
4003676 BR1 CA14H02 505 146 0
4003678 BR1 CA16I01 32 0 0
4003679 BR1 CB01A01 51 0 0
4003679 BR1 FC92H07 49 0 0
4003682 BR1 CB16B01 2122 0 0
4003683 BR1 CA22H02 516 0 0
4003686 BR1 CA22A01 547 0 0
4003687 BR1 CB05D01 110 0 0
4003688 BR1 CB04E01 425 2 0
4003689 BR1 CA12B01 1004 0 0
4003690 BR1 CA03B01 671 128 0
4003694 BR1 CB18F01 13 0 0
4003703 BR1 FG10G02 7424 0 0
4003717 BR1 CA29F01 249 0 0
4003719 BR1 FCOFLOW 17 17 0
4003728 BR1 CA13B01 364 0 0
4003734 BR1 FC92F03 98 0 0
4003745 BR1 CA05F01 518 0 0
4003745 BR1 FCOFLOW 144 0 0
4003746 BR1 CB05B01 135 0 0
4003748 BR1 FC91H05 410 139 0
4003749 BR1 CA07B01 2406 0 0
4003749 BR1 FCOFLOW 112 0 0
4003750 BR1 CB02D01 1217 0 0
4003760 BR1 FCOFLOW 4704 0 0
400444 BR1 FG10B02 50 0 0
400571 BR1 FC95C03 49 0 0
401393 BR1 CA14H01 14212 528 0
401393 BR1 FCARRET 46 0 0
401393 BR1 FCOFLOW 732 48 0
405100 BR1 CA01D01 3595 3278 0
405101 BR1 CB01D01 2272 59 0
405101 BR1 FCARRET 2 0 0
405106 BR1 FF14C01 8609 240 0
405111 BR1 FC96D13 135 0 0
405220 BR1 FC94C05 128 0 0
405230 BR1 FC93G12 572 0 0
405231 BR1 FC94E13 351 0 0
405232 BR1 FC93G14 11 0 0
405235 BR1 FC96G10 322 0 0
405237 BR1 CA25B01 5643 0 0
405243 BR1 CA18B01 83 0 0
405244 BR1 CA29B02 11 0 0
405244 BR1 FCOFLOW 100 0 0
405246 BR1 FCOFLOW 48 0 0
405247 BR1 FC94D03 482 0 0
405320 BR1 FC91B01 586 0 0
405321 BR1 FC55B01 304 0 0
405334 BR1 FC92F05 304 288 0
405338 BR1 FC95E13 10954 384 0
405350 BR1 FC49E02 1920 1610 0
405351 BR1 CB16D01 6822 0 0
405365 BR1 CA29C02 8316 0 0
405366 BR1 FC92I04 748 0 0
405373 BR1 CA28A01 10800 0 0
4061001 BR1 FC57F03 412 0 0
4061003 BR1 FC90H06 10 0 0
4061004 BR1 FC49D03 584 0 0
4061005 BR1 CA17F01 385 0 0
4061006 BR1 FC63F03 100 0 0
4061007 BR1 FC92A04 59 59 0
4061008 BR1 FC54B01 850 0 0
4061012 BR1 FC92D08 7108 0 0
4061015 BR1 FC89H02 99 0 0
4061016 BR1 CB02A01 998 0 0
4061033 BR1 FC96A07 192 0 0
4061034 BR1 FC91A04 100 0 0
4061045 BR1 FC86B01 1052 528 0
4061047 BR1 FC90G01 1210 0 0
4061048 BR1 FC95A07 329 0 0
4061052 BR1 FC90A04 1092 0 0
4061053 BR1 FC90D08 457 0 0
4061054 BR1 FC95E01 401 0 0
4061056 BR1 FC94A07 158 0 0
4061057 BR1 FC89B03 698 0 0
4061063 BR1 FC91I01 352 0 0
4061068 BR1 FC93C07 399 0 0
4061069 BR1 FC91G03 180 0 0
4061070 BR1 FC96G12 162 0 0
4061072 BR1 FC93A02 4 0 0
4061079 BR1 FC91E01 368 0 0
4061080 BR1 FC92G05 451 0 0
4061081 BR1 FC93C08 37 0 0
4061085 BR1 FC93E01 298 0 0
4061087 BR1 FC94A02 10 0 0
4061090 BR1 CB05H02 194 0 0
4061090 BR1 FC90E03 400 0 0
4061091 BR1 FC93F01 306 124 0
4061096 BR1 CB08B01 1066 0 0
4061106 BR1 CA11D01 184 0 0
4061107 BR1 FC57E01 43 0 0
4061110 BR1 FC87G01 249 144 0
4061115 BR1 FC51A03 1884 0 0
4061122 BR1 FC89G01 243 0 0
4061123 BR1 FC91E02 525 384 0
4061124 BR1 FC58B02 1293 0 0
4061125 BR1 CA30C01 1991 0 0
4061126 BR1 CA09D01 227 0 0
4061127 BR1 FC96A09 183 0 0
4061128 BR1 FC95A02 103 0 0
4061130 BR1 FC90G03 493 0 0
4061132 BR1 FC92E02 685 0 0
4061133 BR1 FC88B03 590 0 0
4061135 BR1 FC96A02 2642 0 0
4061136 BR1 FC87B03 770 0 0
4061137 BR1 FC94A11 124 0 0
4061138 BR1 FC53B03 88 0 0
4061139 BR1 CB07F01 317 0 0
4061141 BR1 FC96E01 304 0 0
4061142 BR1 FC93C09 314 96 0
4061143 BR1 FC95A09 100 0 0
4061144 BR1 FC96A04 1 0 0
4061145 BR1 FC94F01 251 0 0
4061146 BR1 FC94A09 108 0 0
4061147 BR1 FCOFLOW 5 0 0
4061148 BR1 FC93A09 200 0 0
4061150 BR1 FC94F11 99 0 0
4061151 BR1 FC94E01 100 0 0
4061154 BR1 FC92A06 50 0 0
4061155 BR1 FC94A04 249 48 0
4061156 BR1 FC95A04 124 0 0
4061157 BR1 FC89C01 54 48 0
4061159 BR1 FC96D11 251 0 0
406116 BR1 CA24A01 463 0 0
4061160 BR1 FC95F13 182 0 0
4061161 BR1 FC92B01 305 0 04061162 BR1 FC93A04 10 0 0
4061163 BR1 FC96F01 338 0 0
4061164 BR1 FC90E02 700 0 0
4061165 BR1 FC90E05 259 0 0
4061166 BR1 FC95E03 210 0 0
4061167 BR1 FC96A06 60 0 0
4061169 BR1 FC95A06 79 0 0
406117 BR1 FC93C10 120 0 0
4061171 BR1 FC93F13 164 0 0
4061177 BR1 FC95F01 145 0 0
4061178 BR1 FC94F13 81 0 0
4061179 BR1 FC54E03 1327 0 0
4061180 BR1 FC96F13 104 0 0
4061181 BR1 FC90B01 328 0 0
4061182 BR1 FC93F03 268 0 0
4061183 BR1 CA30A02 919 0 0
4061184 BR1 FC63B02 1040 0 0
4061190 BR1 FC94F03 136 0 0
4061202 BR1 FC93E03 126 0 0
4061217 BR1 FC94A06 294 0 0
4061218 BR1 FC92H08 14 0 0
4061219 BR1 FC88G01 485 0 0
4061220 BR1 FC92B03 237 0 0
4061221 BR1 FC56D03 1525 0 0
4061222 BR1 CA27C01 3170 0 0
4061223 BR1 FC91B03 510 0 0
4061224 BR1 FC93A06 23 0 0
4061225 BR1 FC96A08 18 0 0
4061226 BR1 FC93C11 69 0 0
4061227 BR1 FC93C12 35 0 0
4061228 BR1 CA05D01 29 0 0
4061229 BR1 CA24A02 15 0 0
4061230 BR1 FCOFLOW 71 0 0
4061231 BR1 CA02H01 569 0 0
4061231 BR1 FCOFLOW 180 0 0
4061232 BR1 FC93C13 350 0 0
4061234 BR1 FC94A08 92 0 0
4061235 BR1 FC93C14 36 0 0
4061236 BR1 FC88G03 876 0 0
4061237 BR1 FC92E07 268 0 0
4061238 BR1 FC90B03 666 0 0
4061243 BR1 FC95G01 130 0 0
4061244 BR1 FC93G01 116 0 0
4061247 BR1 FC96G01 59 0 0
4061248 BR1 FCOFLOW 63 0 0
4061249 BR1 FC91H08 32 0 0
4061254 BR1 FC96A10 10 0 0
4061262 BR1 FC94G01 141 0 0
4061263 BR1 FC96F03 163 0 0
4061268 BR1 FC95F03 629 0 0
4061270 BR1 FC95A10 79 0 0
4061271 BR1 FC94A10 47 0 0
4061272 BR1 FC95G03 118 0 0
4061273 BR1 FC93A10 139 0 0
4061274 BR1 FC93G03 104 0 0
4061275 BR1 CA25A01 194 0 0
4061278 BR1 FC87C01 753 0 0
4061279 BR1 FC86B03 745 0 0
406128 BR1 CA29E01 44 0 0
4061280 BR1 FC52D02 1017 0 0
4061282 BR1 FC95D09 299 0 0
4061284 BR1 FC96A12 180 0 0
406129 BR1 FCOFLOW 149 0 0
4061302 BR1 FC94E03 285 0 0
4061303 BR1 FC92E05 313 0 0
4061306 BR1 CA27A01 5498 0 0
4061307 BR1 CB07A01 998 0 0
4061308 BR1 FC92E04 210 0 0
4061310 BR1 FC91E04 304 0 0
4061311 BR1 FC94G03 225 0 0
4061312 BR1 FC96G03 300 0 0
4061313 BR1 FC91G05 315 0 0
4061314 BR1 FC90E04 302 0 0
4061315 BR1 FC92B05 135 0 0
4061316 BR1 FC93F05 166 0 0
4061317 BR1 FC96E03 162 0 0
4061318 BR1 FC88C01 558 0 0
4061319 BR1 FC90H08 300 0 0
4061320 BR1 CB16G01 410 0 0
4061321 BR1 FC56B02 186 0 0
4061322 BR1 FC51E02 1711 0 0
4061333 BR1 CA29C01 2713 0 0
4061342 BR1 FC90F03 323 96 0
4061343 BR1 FC91B05 316 0 0
4061345 BR1 FC93A11 154 0 0
4061346 BR1 CB17H01 102 0 0
4061358 BR1 FC93D07 1 0 0
4061361 BR1 FC92I02 3307 0 0
4061364 BR1 FC94A12 121 0 0
4061365 BR1 FC57B02 958 384 0
4061368 BR1 FG20C03 63 35 0
4061371 BR1 FC93A12 111 0 0
4061373 BR1 FC95A12 14 0 0
4061374 BR1 FC86D02 1372 0 0
4061378 BR1 FF14B04 1096 0 0
4061379 BR1 FC95A14 14 0 0
4061381 BR1 FC93A14 12 0 0
4061383 BR1 FC95G05 384 0 0
4061388 BR1 CB15F01 6793 0 0
4061391 BR1 CB12A01 135 0 0
4061398 BR1 FC56F03 298 0 0
4061402 BR1 FCOFLOW 20 0 0
4061405 BR1 FC87E01 738 0 0
4061406 BR1 FC93H01 108 0 0
4061408 BR1 CA33B01 450 450 0
4061409 BR1 CA22B01 1955 0 0
4061410 BR1 CA16G01 1933 0 0
4061414 BR1 CA07H01 229 0 0
4061428 BR1 CB17C01 391 0 0
4061429 BR1 CB05F02 396 0 0
406143 BR1 FC88H04 100 0 0
4061430 BR1 CB17G01 87 0 0
4061432 BR1 CA07F01 493 0 0
4061432 BR1 FCOFLOW 448 48 0
4061433 BR1 CB18E01 876 0 0
4061436 BR1 FC91C05 738 0 0
4061437 BR1 CB17D01 4288 0 0
4061438 BR1 FC51B03 1624 0 0
4061439 BR1 FC91C06 833 0 0
4061444 BR1 CB28H01 136 0 0
4061445 BR1 FCOFLOW 146 0 0
4061446 BR1 CB28H02 189 0 0
4061447 BR1 FCOFLOW 65 0 0
4061449 BR1 FCOFLOW 2000 0 0
4061459 BR1 CB19C01 1104 0 0
4061463 BR1 CB28D02 595 0 0
4061467 BR1 CB28E01 1533 0 0
4061468 BR1 CA34F01 62 0 0
4061469 BR1 CB19C02 840 0 0
4061470 BR1 CA34F02 111 0 0
4061471 BR1 CB11A01 116 0 0
4061487 BR1 CA32C03 384 0 0
4061488 BR1 CA32C02 336 0 0
406151 BR1 FCOFLOW 1 0 0
406152 BR1 FCOFLOW 6 0 0
406153 BR1 FC52B03 2163 0 0
406157 BR1 FC94A14 16 0 0
406174 BR1 FC86F02 201 0 0
406191 BR1 FC90B05 286 0 0
406192 BR1 FC92B07 321 0 0
406196 BR1 FCOFLOW 34 0 0
406200 BR1 CB04B01 1538 0 0
406201 BR1 FC53F02 4421 2640 0
406204 BR1 FC87G03 313 0 0
406214 BR1 FC89G03 151 0 0
406233 BR1 FC90D05 308 0 0
406236 BR1 FC91E07 300 0 0
406238 BR1 FC91D07 392 0 0
406240 BR1 FC92D01 405 0 0
406241 BR1 FC91A06 369 0 0
406242 BR1 FC92D07 510 0 0
406244 BR1 FC96A14 81 0 0
406251 BR1 FC95B02 54 0 0
406263 BR1 FC93G05 151 0 0
406272 BR1 FC93B02 13 0 0
406277 BR1 FC94G05 100 0 0
406282 BR1 FC95E05 152 0 0
406283 BR1 FC93E05 203 0 0
406287 BR1 FC96G05 100 0 0
406338 BR1 FC89F04 271 0 0
406344 BR1 FC92E06 119 0 0
406345 BR1 FC55E03 1206 816 0
406347 BR1 FC91E06 279 0 0
406352 BR1 FC88F04 884 0 0
406357 BR1 FC91B07 100 0 0
406359 BR1 FC49A01 413 0 0
406363 BR1 CA30B01 736 0 0
406364 BR1 FC95G07 103 0 0
406366 BR1 FC53E03 1929 336 0
406367 BR1 FC94F05 205 0 0
406368 BR1 FC86F04 419 0 0
406370 BR1 FC90B07 403 0 0
406371 BR1 FC92C01 316 0 0
406372 BR1 FC96E05 531 0 0
406373 BR1 CA32C01 48 0 0
406374 BR1 FC96B02 9 0 0
406375 BR1 FC93G07 302 0 0
406405 BR1 FC96G07 226 0 0
406409 BR1 FC91A08 102 0 0
406412 BR1 FC94G07 100 0 0
406413 BR1 FCOFLOW 7 0 0
406414 BR1 FC94B02 103 0 0
406419 BR1 FC94D11 465 0 0
406430 BR1 FC95G09 127 0 0
406437 BR1 FC90E06 145 0 0
406443 BR1 FC92A08 100 0 0
406445 BR1 FC96F05 88 0 0
406446 BR1 CB19B02 48 0 0
406447 BR1 CA10I01 1370 382 0
406449 BR1 FC95B04 10 0 0
406450 BR1 FC93B04 100 0 0
406477 BR1 FC91C01 680 0 0
406487 BR1 FC90I05 163 0 0
406488 BR1 FC90A08 57 0 0
406489 BR1 FC91B02 61 0 0
406490 BR1 FC92E08 166 0 0
406494 BR1 FC94B04 100 0 0
406497 BR1 FC96B04 160 0 0
406521 BR1 FC89B04 294 0 0
406616 BR1 FC91E08 57 0 0
406650 BR1 FC53B01 2894 0 0
406651 BR1 FC88H01 85 336 0
406652 BR1 FC52A01 752 0 0
406675 BR1 FC93G09 147 0 0
406678 BR1 FC96G09 219 0 0
406696 BR1 FC87G02 2501 0 0
406697 BR1 FC94G09 52 0 0
406698 BR1 FCOFLOW 3 0 0
406700 BR1 FC94E05 212 0 0
406705 BR1 FC90C01 276 0 0
406706 BR1 FC52B01 1411 0 0
406709 BR1 FC93H03 21 0 0
406710 BR1 FC92G07 208 0 0
406714 BR1 FC55B02 1067 0 0
406717 BR1 FC90E08 497 0 0
406718 BR1 FC95F05 268 0 0
406727 BR1 FC93F07 125 0 0
406732 BR1 FC94F07 149 0 0
406754 BR1 FC95G11 172 0 0
406755 BR1 FC93G11 108 0 0
406759 BR1 FC87B04 193 0 0
406760 BR1 FC89G02 100 0 0
406767 BR1 FC92F02 104 0 0
406768 BR1 FC92B02 55 0 0
406772 BR1 CA16I02 692 0 0
406787 BR1 FC96G11 257 0 0
406793 BR1 CA18D01 828 0 0
406794 BR1 FC88I03 159 96 0
406795 BR1 FC90G05 121 0 0
406798 BR1 FC91F02 127 0 0
406803 BR1 FC90F02 145 0 0
406806 BR1 FC91F04 41 0 0
406810 BR1 FC94G11 104 0 0
406816 BR1 FC93B06 2 0 0
406819 BR1 FC95G13 133 0 0
406831 BR1 FC95E07 248 0 0
406835 BR1 FC93H05 97 0 0
406836 BR1 FC91C03 833 0 0
406837 BR1 FC91G07 600 0 0
406838 BR1 FC92H01 541 0 0
406839 BR1 FC96F07 128 0 0
406841 BR1 FC54A01 1341 288 0
406842 BR1 FC96B06 66 0 0
406844 BR1 CB16A01 596 0 0
406845 BR1 FC90B02 53 0 0
406847 BR1 FC92B04 129 0 0
406850 BR1 FC93E07 202 0 0
406852 BR1 FC94E07 208 0 0
406853 BR1 FC96E07 100 0 0
406857 BR1 FC95E09 200 0 0
406858 BR1 FC94B06 199 0 0
406992 BR1 FC88B04 206 0 0
460381 BR1 FH04A01 711 0 0
50010146 BR1 FC93B08 500 0 0
50010147 BR1 FC94B08 250 0 0
50010149 BR1 FC95B10 155 0 0
50010284 BR1 FC93B12 10000 0 0
50010422 BR1 FC94H02 2500 0 0
50010437 BR1 FC55F03 10000 0 0
50010476 BR1 FC95H02 5000 0 0
50010477 BR1 FC91B04 5000 0 0
50010858 BR1 FC92B06 8000 0 0
50010872 BR1 FC96H04 5000 0 0
50010973 BR1 FC87H04 1000 0 0
50011119 BR1 FC86H04 2000 0 0
50011255 BR1 FC95H04 500 0 0
50011259 BR1 FC96H06 500 0 0
50011260 BR1 FC95H06 500 0 0
50011261 BR1 FC94H06 500 0 0
50011262 BR1 FC93H06 1000 0 0
50011264 BR1 CB28D01 3998 0 0
50011268 BR1 FC96H08 500 0 0
50011289 BR1 FC95H08 1500 0 0
50011290 BR1 FC93H08 1250 0 0
50011291 BR1 FC94H08 275 0 0
50011298 BR1 FC96H10 1250 0 0
50011299 BR1 FC95H10 500 0 0
50011300 BR1 FC94H10 250 0 0
50011354 BR1 FC93H10 250 0 0
50011356 BR1 FC96H12 250 0 0
50013148 BR1 FC94H12 500 0 0
50013149 BR1 CA03A03 1000 0 0
50013284 BR1 FC93H12 500 0 0
50013305 BR1 FC95H12 760 0 0
50013309 BR1 FC95H14 97 0 0
50013318 BR1 FC94H14 96 0 0
50013319 BR1 FC94B12 270 0 0
50013320 BR1 FC96B12 337 0 0
50013371 BR1 FC95B12 548 0 0
50013372 BR1 FC93B14 500 0 0
50013373 BR1 FC96H14 500 0 0
50013380 BR1 FC95I02 2000 0 0
50013401 BR1 FC93I02 500 0 0
50013404 BR1 FC87I02 3000 0 0
50013549 BR1 FC96I02 1000 0 0
50013550 BR1 FC94I02 1000 0 0
50013614 BR1 FC91B06 1250 0 0
50013654 BR1 FC54F03 2000 0 0
50013663 BR1 FC95I04 1500 0 0
50013664 BR1 FC93I04 500 0 0
50013843 BR1 FC90B06 3000 0 0
50013964 BR1 FC94I04 500 0 0
50013965 BR1 FC96I04 500 0 0
50013967 BR1 CB19A04 500 0 0
50013968 BR1 CA32B03 828 0 0
50013969 BR1 CA03A02 500 0 0
50013973 BR1 FC91B08 500 0 0
50014023 BR1 FC93I06 500 0 0
50014024 BR1 FC96I06 500 0 0
50014025 BR1 FC94I06 500 0 0
50014030 BR1 FC95I08 500 0 0
50014157 BR1 FC94I08 500 0 0
50014158 BR1 FC96I08 500 0 0
50014167 BR1 FC90B08 1500 0 0
50014328 BR1 FC95D02 500 0 0
50014332 BR1 FC88I02 1500 0 0
50014334 BR1 CA32A03 500 0 0
50014337 BR1 FC96D02 550 0 0
50014636 BR1 FC89C02 2000 0 0
50014639 BR1 FC96D04 1000 0 0
50014645 BR1 FC94D04 1250 0 0
50014704 BR1 CB19A02 1000 0 0
50014737 BR1 FC95D04 1011 0 0
50014797 BR1 FC93D04 500 0 0
50014800 BR1 FC86B04 1500 0 0
50014801 BR1 FC96D06 500 0 0
50014802 BR1 FC95D06 1000 0 0
50014809 BR1 FC93D08 500 0 0
50014810 BR1 FC94D08 500 0 0
50014890 BR1 FC91C07 2250 0 0
50014934 BR1 CB19A01 346 0 0
50014940 BR1 CA32B02 500 0 0
50014954 BR1 CB19B01 500 0 0
50014980 BR1 FCOFLOW 2000 0 0
50014990 BR1 FCOFLOW 5000 0 0
50015082 BR1 CA25A02 250 0 0
50015083 BR1 CB19A03 500 0 0
5006900 BR1 FC89I04 10000 0 0
5006932 BR1 FC93D10 5000 0 0
5006961 BR1 FC94D12 250 0 0
5006966 BR1 FC95D12 250 0 0
5006977 BR1 FCOFLOW 500 0 0
5006979 BR1 FC95E02 250 0 0
5006980 BR1 FC92C02 500 0 0
5006984 BR1 FC96E02 250 0 0
5006987 BR1 FC95E04 540 0 0
5007035 BR1 CA25A03 540 0 0
5007036 BR1 FC93E08 250 0 0
5007037 BR1 FC94E08 84 0 0
5007038 BR1 FC96E08 250 0 0
5007039 BR1 FC95E10 250 0 0
5007075 BR1 FC96E12 250 0 0
5007078 BR1 FC95E12 250 0 0
5007079 BR1 FC91C02 500 0 0
5007080 BR1 FC93E14 250 0 0
5007081 BR1 FC94E14 250 0 0
5007084 BR1 FC95E14 250 0 0
5007089 BR1 FC94F02 250 0 0
5007099 BR1 FC95F02 99 0 0
5007119 BR1 FC93C02 250 0 0
5007122 BR1 FC96C02 250 0 0
5007135 BR1 FC95C02 250 0 0
5007150 BR1 FC94C04 250 0 0
5007152 BR1 FC96C04 250 0 0
5007595 BR1 FC94C06 250 0 0
5007863 BR1 FC51F02 1000 0 0
5007930 BR1 FC90C02 17500 0 0
5008079 BR1 FC95F06 1000 0 0
5008080 BR1 CA30B02 4019 0 0
5008251 BR1 FC93F08 500 0 0
5008662 BR1 FC96F08 5000 0 0
5008673 BR1 FC95F08 9840 0 0
5008718 BR1 FC95F10 250 0 0
5008728 BR1 FC93F10 1000 0 0
5008751 BR1 FC90I02 5000 0 0
5008761 BR1 CB11A03 1000 0 0
5008819 BR1 CB11E01 9500 0 0
5008884 BR1 FC95F12 250 0 0
5008885 BR1 FC93F12 250 0 0
5008886 BR1 FC94F12 250 0 0
5009124 BR1 FC94F14 500 0 0
5009153 BR1 FC96F14 2500 0 0
5009273 BR1 FC96G02 1000 0 0
5009452 BR1 FC94G02 5000 0 0
5009466 BR1 FC91C04 1000 0 0
5009641 BR1 CB11G01 25404 0 0
5009719 BR1 FC95G04 250 0 0
5009997 BR1 FC96C06 500 0 0
Part numbers are the first column.
Shelf location are in col 3.
PROBLEM:
I need to refine the query so that only part numbers with at least one location starting with 'C' and at least one location starting with 'F' are returned.
So part numbers 0301646, 0301650, 0301656 and 030392 amongst others would NOT be returned (They ONLY have 'F' locations).
Any ideas?
0301068 BR1 CB02B01 836 0 0
0301068 BR1 FCARRET 176 0 0
0301068 BR1 FCOFLOW 970 0 0
0301082 BR1 FC96A11 398 0 0
0301084 BR1 CB06C01 184 96 0
0301084 BR1 FF10B05 800 0 0
0301088 BR1 CB04F01 1932 96 0
0301089 BR1 FC95F07 131 0 0
0301094 BR1 FC86E01 675 0 0
0301095 BR1 FC95F09 2 0 0
0301106 BR1 FC92A01 111 0 0
0301107 BR1 CA16E01 494 144 0
0301107 BR1 FCARRET 9 0 0
0301110 BR1 FC93F09 21 0 0
0301112 BR1 FC93I01 276 0 0
0301126 BR1 FC86I01 400 0 0
030112601 BR1 FC90G02 100 0 0
030112603 BR1 FC87I01 200 0 0
0301255 BR1 CA13A01 240 0 0
0301273 BR1 FC57D02 474 0 0
0301276 BR1 FF08A03 9215 384 0
0301277 BR1 FC94I01 79 0 0
0301278 BR1 FC95C05 309 96 0
0301279 BR1 FC91G02 64 0 0
0301286 BR1 CB08B01 562 124 0
0301287 BR1 CB06E01 462 0 0
0301290 BR1 CA13G01 1118 0 0
0301293 BR1 CB01C01 530 602 0
0301293 BR1 FCARRET 10 0 0
0301294 BR1 CB05F01 1579 0 0
0301294 BR1 FCARRET 9 0 0
0301295 BR1 FC88I01 245 0 0
0301296 BR1 CA06B01 194 184 0
0301296 BR1 FCARRET 2 0 0
0301296 BR1 FCOFLOW 250 141 0
0301307 BR1 CA13I01 180 0 0
0301317 BR1 FG08A02 18985 3644 0
0301318 BR1 FC54C02 1241 0 0
0301322 BR1 FF02B03 2233 72 0
0301351 BR1 CA24B01 9111 718 0
0301355 BR1 FC63D01 787 0 0
0301356 BR1 FC89E03 352 0 0
0301358 BR1 CA05A03 152 0 0
0301359 BR1 CA04A06 163 0 0
0301362 BR1 CA07A04 52 0 0
0301363 BR1 FC92G02 254 0 0
0301366 BR1 FC93D11 97 0 0
0301367 BR1 FC92A03 132 0 0
0301370 BR1 CA01C01 125 0 0
0301374 BR1 CA10D01 4126 144 0
0301385 BR1 CA12A01 16 0 0
0301394 BR1 FC90I01 124 0 0
0301399 BR1 CA11B01 1299 0 0
0301400 BR1 CA12A02 23 0 0
0301404 BR1 CA06A01 208 0 0
0301405 BR1 CA06A02 25 0 0
0301407 BR1 FC54B02 158 0 0
0301408 BR1 FC51B01 303 0 0
0301409 BR1 FC91F01 214 0 0
0301410 BR1 FC90F01 2 0 0
0301411 BR1 FC94F09 100 0 0
0301412 BR1 FC95A11 6 0 0
0301413 BR1 FC95A13 6 0 0
0301414 BR1 FC88E03 162 6 0
0301415 BR1 CA08G01 185 184 0
0301415 BR1 FCARRET 1 0 0
0301416 BR1 CB09B01 4 0 0
0301416 BR1 FC58D01 400 0 0
0301427 BR1 FC91E05 191 0 0
0301428 BR1 FC95C06 12 0 0
0301468 BR1 FG16B02 2856 0 0
030148003 BR1 FC93A13 9 0 0
0301493 BR1 FC94A13 4 0 0
0301518 BR1 FC95C07 24 0 0
0301523 BR1 CA21A01 7000 59 0
0301523 BR1 FCARRET 7 0 0
0301523 BR1 FCOFLOW 235 0 0
0301526 BR1 CA03F01 856 0 0
0301540 BR1 CB12E01 1751 0 0
0301541 BR1 CB10B01 1503 0 0
0301541 BR1 FCARRET 1 0 0
0301543 BR1 FC87E03 277 0 0
0301597 BR1 FF06B01 4641 816 0
0301598 BR1 FG16C01 1419 0 0
0301599 BR1 CA23F01 1519 0 0
0301599 BR1 FF04A07 48 0 0
0301605 BR1 CA08D01 10170 384 0
0301610 BR1 CB11B01 3723 0 0
0301626 BR1 FC92C07 3380 384 0
0301629 BR1 FG19B06 900 300 0
0301631 BR1 CB07D02 432 0 0
0301631 BR1 FCOFLOW 500 0 0
030163101 BR1 CA02F02 712 0 0
030163103 BR1 CA02F02 6 0 0
030163103 BR1 FC95C08 72 48 0
0301637 BR1 FC96G13 127 48 0
0301641 BR1 FCOFLOW 2209 768 0
0301646 BR1 FCOFLOW 4405 0 0
0301650 BR1 FCOFLOW 6321 0 0
0301656 BR1 FCOFLOW 10746 0 0
030392 BR1 FC96I01 9 0 0
030578 BR1 CA01A03 831 0 0
030579 BR1 CA01A01 327 0 0
030705 BR1 FC93D03 411 58 0
030706 BR1 FC96D03 270 0 0
030707 BR1 CA11A02 1139 0 0
030724 BR1 FC49C01 3572 1000 0
030769 BR1 CA14D01 563 0 0
031362 BR1 FC56C01 1682 91 0
031376 BR1 CA08I02 108 0 0
032047 BR1 CB02I02 107 0 0
03204703 BR1 FC88D02 53 0 0
032355 BR1 CA09F01 200 0 0
032355 BR1 FCOFLOW 4 0 0
032365 BR1 FF12A04 12673 1020 0
032391 BR1 CA01G02 78 0 0
032391 BR1 FCOFLOW 100 0 0
033202 BR1 FC89I03 221 0 0
033203 BR1 CB07D01 249 0 0
033205 BR1 CA01B01 394 0 0
033206 BR1 CB02E01 500 0 0
033206 BR1 FCOFLOW 100 0 0
033207 BR1 FCOFLOW 1064 158 0
033208 BR1 CA08A03 48 0 0
033209 BR1 CB03C01 1189 0 0
033210 BR1 CA10A02 291 0 0
033211 BR1 CA10A01 274 35 0
033212 BR1 CB02I01 148 35 0
033217 BR1 CA11A01 101 0 0
033218 BR1 CA11I01 32 0 0
033226 BR1 FC53D01 455 0 0
033227 BR1 CA04A05 384 0 0
037207 BR1 FC96F09 50 0 0
037208 BR1 CA05A01 125 0 0
037209 BR1 CB03D01 1 164 0
037209 BR1 FCOFLOW 300 0 0
037210 BR1 CA07I01 18 0 0
037211 BR1 CA04A02 143 0 0
037212 BR1 FC95F11 23 23 0
037213 BR1 CA05A02 85 0 0
037228 BR1 CA10A03 31 0 0
037228 BR1 FC92H03 24 0 0
037229 BR1 CA08I03 4 0 0
037236 BR1 CA12A03 78 0 0
037237 BR1 CA18A02 54 0 0
040236 BR1 CA06D03 82 0 0
040371 BR1 CA06D01 104 48 0
041103 BR1 CA06D02 4 0 0
041112 BR1 CB04H03 288 0 0
043276 BR1 CA12A04 53 53 0
043276 BR1 FCOFLOW 24 24 0
044301 BR1 CA17A02 4 0 0
0471028 BR1 CA18F01 979 0 0
049201 BR1 FC49B01 8840 768 0
170194 BR1 FG16G02 2324 0 0
170194 BR1 FG19C01 287 48 0
170195 BR1 FG19C03 1031 0 0
170196 BR1 FF10A03 65 0 0
170283 BR1 FF14B01 166 0 0
170284 BR1 FF14B02 200 0 0
190135 BR1 FC91D01 670 0 0
190136 BR1 CA04E01 93 0 0
190136 BR1 FCARRET 2 0 0
190274 BR1 CA21C01 915 0 0
190332 BR1 FF02A06 628 0 0
19041303 BR1 FF16C03 100 0 0
19041325 BR1 FF18C03 43 43 0
19041341 BR1 FF20C03 10 0 0
19041342 BR1 FG15A06 102 96 0
19041403 BR1 FF18A03 279 0 0
190414122 BR1 FG02C03 5 0 0
190414123 BR1 FG04C03 50 0 0
19041414 BR1 FG06C03 25 0 0
190414142 BR1 FG07A06 1 0 0
190414143 BR1 FG07A05 100 0 0
19041427 BR1 FG07F02 3 0 0
19041433 BR1 FF20A03 90 0 0
19041470 BR1 FG07F01 452 0 0
19041475 BR1 FG07A04 89 0 0
19041476 BR1 FG09A01 1 0 0
19041477 BR1 FG05C02 57 0 0
19041478 BR1 CB06A01 61 0 0
19041478 BR1 FG09A02 100 0 0
190415122 BR1 FG17A03 3 0 0
190415142 BR1 FG17A08 2 0 0
190415145 BR1 CB19E01 35 0 0
19041533 BR1 FG17A07 1 0 0
19041575 BR1 CA04B01 54 0 0
19041576 BR1 FG17A05 45 0 0
19041577 BR1 FF16C01 23 0 0
190423 BR1 CB10A01 57 0 0
190424 BR1 CA12D01 36 0 0
190424 BR1 FCARRET 7 0 0
233111 BR1 CA16A01 313 0 0
233111 BR1 FCOFLOW 200 0 0
233273 BR1 FC63C02 4047 0 0
2411048 BR1 FH04C02 250 0 0
2411048 BR1 FH10D01 18 0 0
2411096 BR1 FH06C02 170 0 0
2411096 BR1 FH06E02 106 0 0
2411230 BR1 FH18C02 20 0 0
2411248113 BR1 FH10D02 44 0 0
2411574 BR1 FH14A01 50 0 0
2411623 BR1 FH08B01 500 0 0
2411624 BR1 FH02B01 25 0 0
2411636 BR1 FH04B02 11 0 0
2411688 BR1 FH12E01 54 0 0
2411701 BR1 FH12D02 70 0 0
241505 BR1 FH08E01 100 0 0
241507 BR1 FH18B01 5 0 0
241510 BR1 FH06D01 29 0 0
241510 BR1 FH06D02 50 0 0
241511 BR1 FH04D01 25 0 0
241511 BR1 FH06E01 36 0 0
241532 BR1 FH18B02 30 0 0
241538 BR1 FH18C01 26 0 0
241576 BR1 FH16A02 110 0 0
241577 BR1 FH04B01 104 0 0
241577 BR1 FH08D02 104 0 0
241579 BR1 FH16A01 22 0 0
241590 BR1 FH08B02 20 0 0
241591 BR1 FH16B01 53 0 0
241593 BR1 FH06A02 9 0 0
241595 BR1 FH08C02 103 0 0
241606 BR1 FH06B02 15 0 0
241615 BR1 FH08B01 94 0 0
241689 BR1 FH14B02 9 0 0
241690 BR1 FH12D01 28 0 0
241690 BR1 FH14B01 12 0 0
241714115 BR1 FH12A02 6 0 0
241720 BR1 FH02B01 11 0 0
241721 BR1 FH02B02 14 0 0
241724 BR1 FH06C01 36 0 0
241725 BR1 FH04C01 13 0 0
241725 BR1 FH04C02 10 0 0
241727 BR1 FH04D02 25 0 0
241729 BR1 FH08A01 15 0 0
241732 BR1 FH02C01 20 0 0
241732 BR1 FH04A01 2 0 0
241739 BR1 FH02A01 90 0 0
241740 BR1 FH02A02 116 0 0
241992115 BR1 FH12A01 10 0 0
2441062 BR1 FH02C01 19 0 0
244505 BR1 FH04A02 87 0 0
244516 BR1 FH18A01 14 0 0
244519 BR1 FH06B01 6 0 0
244524 BR1 FH06A01 9 0 0
244526 BR1 FH02B01 10 0 0
244783 BR1 FH10E02 25 0 0
244783 BR1 FH14C01 30 0 0
244784 BR1 FH08C01 7 0 0
244785 BR1 FH12E02 15 0 0
244785 BR1 FH14A02 17 0 0
244785 BR1 FH14C02 10 0 0
244786 BR1 FH08E02 34 0 0
244786 BR1 FH10E01 6 0 0
244786 BR1 FH10E02 34 0 0
244788 BR1 FH08D01 10 0 0
244788 BR1 FH16C01 20 0 0
244789 BR1 FH14C02 19 0 0
244980 BR1 FH16C02 20 0 0
244982 BR1 FH08A02 6 0 0
250905 BR1 FC93F11 151 151 0
254057 BR1 FC94D01 371 0 0
255043 BR1 FC94A01 195 0 0
255077 BR1 FC95D01 448 0 0
256114 BR1 CA06E01 589 0 0
262104 BR1 FC57C02 1859 35 0
280103227 BR1 FC84D02 4 0 0
280106725 BR1 FC82F03 107 0 0
280106727 BR1 CA26I01 98 0 0
280106741 BR1 FC81E01 194 0 0
280106744 BR1 FC81F03 124 0 0
280123203 BR1 FC96D09 244 0 0
280123227 BR1 CA02E01 13230 1244 0
280123227 BR1 FCARRET 1 0 0
280123241 BR1 CB09A01 360 0 0
280123242 BR1 CA01H02 1 0 0
280123243 BR1 FC94E09 141 0 0
280123244 BR1 CB03B02 261 0 0
280123244 BR1 FCOFLOW 1005 0 0
280127125 BR1 FC84D03 39 0 0
280127127 BR1 CA02A01 2249 0 0
280127144 BR1 CA01A01 34 0 0
280127144 BR1 FC81I01 1 1 0
280129103 BR1 FC95D11 22 0 0
280129125 BR1 FC96E09 99 0 0
280129141 BR1 FC91G04 533 0 0
280129143 BR1 CA04A01 52 0 0
280209327 BR1 FC95C11 167 0 0
280209341 BR1 CA18H02 2045 0 0
280209342 BR1 CA32B01 48 0 0
280209344 BR1 CB07E01 653 48 0
28032401 BR1 CA22C01 1030 0 0
28032441 BR1 FF08C04 1346 0 0
28032444 BR1 FF14C02 1858 0 0
28033801 BR1 CB05A01 197 0 0
28033844 BR1 FC49A02 1260 0 0
28049703 BR1 FG16C06 614 0 0
28049725 BR1 FG16C04 598 0 0
28049727 BR1 CA15B01 1340 0 0
28049741 BR1 CB01B01 558 0 0
28049742 BR1 FG18C02 522 0 0
28049743 BR1 CB04I01 316 0 0
28049744 BR1 FG18C05 771 0 0
28049803 BR1 FC53D03 88 0 0
280498122 BR1 FC90E01 137 0 0
280498124 BR1 FC92I01 118 48 0
280498125 BR1 CA08A02 49 0 0
28049814 BR1 CA06I01 2 0 0
28049814 BR1 FC55D01 219 0 0
280498142 BR1 FC55D02 309 0 0
280498143 BR1 CA30C02 38 0 0
280498145 BR1 FC52D03 149 0 0
28049827 BR1 CA05B01 202 0 0
28049833 BR1 FC91I03 86 0 0
28049870 BR1 CB06F01 48 0 0
28049872 BR1 FC90I03 96 0 0
28049875 BR1 FC91F03 100 0 0
28049876 BR1 FC49C02 66 0 0
28049877 BR1 CA04A04 120 0 0
28049878 BR1 FC57A01 163 0 0
28049882 BR1 FC90D02 70 0 0
28051025 BR1 FC95D13 488 0 0
28051027 BR1 FC93D09 399 0 0
28051041 BR1 FC58A01 2652 0 0
28051042 BR1 FC96A01 148 0 0
28051044 BR1 CA07A01 260 0 0
28051103 BR1 FC93D13 201 0 0
28051125 BR1 FC93D05 355 0 0
28051127 BR1 FC51C01 4885 622 0
28051141 BR1 CA01G03 388 0 0
28051141 BR1 FC95D03 200 0 0
28051142 BR1 CA08I01 137 0 0
28051143 BR1 CA03A01 81 0 0
28051144 BR1 FC87D01 1840 0 0
28051325 BR1 FC92D03 698 0 0
28068503 BR1 FC91A05 97 0 0
28068527 BR1 CA17I01 449 0 0
28068527 BR1 FCOFLOW 100 0 0
28068533 BR1 FC90A05 113 0 0
28068570 BR1 CA19E01 376 0 0
28068570 BR1 FCARRET 1 0 0
28077403 BR1 CA34G01 682 0 0
28077425 BR1 CA17B01 2082 0 0
28077427 BR1 CA04H01 3934 0 0
28077427 BR1 FCARRET 12 0 0
28077433 BR1 FC96E11 162 0 0
28077442 BR1 FC92E03 333 0 0
28077443 BR1 FC96A03 74 0 0
28077444 BR1 CA02G01 164 0 0
28077470 BR1 CA02G04 395 0 0
28077503 BR1 CA02G02 557 0 0
28077525 BR1 CB16H01 4129 0 0
28077527 BR1 CA01G01 1544 56 0
28077527 BR1 FCARRET 59 0 0
28077533 BR1 FC95E11 169 0 0
28077541 BR1 CB01E01 4251 0 0
28077542 BR1 FC96D07 32 0 0
28077543 BR1 FC94A03 70 0 0
28077544 BR1 CB04H01 72 0 0
28077570 BR1 CB04H02 468 0 0
28082301 BR1 FG12B01 9175 336 0
28082344 BR1 FG14B01 5971 336 0
28082627 BR1 FC84E01 316 0 0
28082703 BR1 FF06C01 1235 0 0
28082725 BR1 FF06A04 2888 0 0
28082727 BR1 FF14A02 537 0 0
28082741 BR1 FG10B01 3156 48 0
28082742 BR1 FF14A03 395 0 0
28082743 BR1 FC82F04 54 0 0
28082744 BR1 FG16C05 275 0 0
28084201 BR1 FC54E01 631 0 0
28084244 BR1 FC89A03 550 0 0
28094103 BR1 FC81F04 66 0 0
28094125 BR1 FC81B04 149 0 0
28094127 BR1 FC84E02 2 0 0
28094141 BR1 FC82G01 7 6 0
28095203 BR1 CA01H01 614 6 0
28095203 BR1 FCOFLOW 1000 0 0
28095225 BR1 CB05H01 188 528 0
28095225 BR1 FCARRET 1 0 0
28095225 BR1 FCOFLOW 367 0 0
28095227 BR1 FC90E07 961 0 0
28095241 BR1 CA02G03 655 0 0
28095244 BR1 FC92F07 1616 0 0
28099625 BR1 FC95A03 38 0 0
28099627 BR1 FC94D13 116 0 0
28099644 BR1 FC93A03 25 0 0
28099903 BR1 CA07A03 123 0 0
293014 BR1 FC58C01 9760 0 0
293080 BR1 FG20B01 1735 264 0
293089 BR1 FC49F01 76 0 0
293133 BR1 CA30E02 108 0 0
293135 BR1 FF02C01 2485 0 0
293136 BR1 FF10A01 34863 1806 0
293138 BR1 FF12A01 33116 1675 0
293146 BR1 CA18H01 429 0 0
293146 BR1 FCARRET 1 0 0
293148 BR1 FF08A01 31387 1375 0
293148 BR1 FG19B06 1200 0 0
293153 BR1 FG10C06 2213 35 0
294205 BR1 CA30G01 1481 0 0
322503 BR1 FC51C03 1711 0 0
33510025 BR1 CA04A03 87 0 0
33510027 BR1 FC84E03 2 0 0
33510041 BR1 FC82G02 116 0 0
33510044 BR1 FC81G02 159 0 0
33511103 BR1 FF10C01 18 18 0
33511125 BR1 FF10C02 1789 0 0
33511127 BR1 FG20B02 2387 288 0
33511141 BR1 FH03F01 1610 0 0
33511142 BR1 CB05C01 480 0 0
33511142 BR1 FCOFLOW 768 0 0
33511143 BR1 CA11F01 274 0 0
33511144 BR1 CA04C01 46 0 0
33511144 BR1 FCOFLOW 233 0 0
33511203 BR1 FC58D02 192 0 0
335112122 BR1 FC88D04 113 0 0
335112123 BR1 FC90G04 40 0 0
33511214 BR1 FC53D02 223 0 0
335112142 BR1 FC86A01 27 0 0
335112143 BR1 FC86D03 125 0 0
335112145 BR1 FC91A07 54 0 0
33511227 BR1 FC57C03 658 0 0
33511233 BR1 FC63A01 161 0 0
33511270 BR1 CA05B02 170 0 0
33511275 BR1 FC88A03 65 0 0
33511276 BR1 FC87D04 131 0 0
33511277 BR1 FC87F01 108 0 0
33511278 BR1 FC91D02 52 0 0
33511303 BR1 FC82G03 106 0 0
33511327 BR1 FC84E04 769 0 0
33511341 BR1 CA16B01 384 91 0
33511342 BR1 FC81G03 149 0 0
33511344 BR1 FC82I02 109 0 0
33511427 BR1 FC91I05 52 0 0
33511470 BR1 FC92D02 74 0 0
335115027 BR1 CB14D01 708 0 0
3351205413 BR1 CB09D01 738 0 0
335121503 BR1 FF15A04 16 0 0
335121525 BR1 CA24G01 75 0 0
335121541 BR1 FG14C03 128 0 0
335121542 BR1 CA26G01 58 0 0
335121543 BR1 CA24E01 178 0 0
335121544 BR1 FF15A05 90 0 0
335125127 BR1 FC84D01 255 0 0
335125141 BR1 CB10E01 1686 0 0
335125142 BR1 CA33E01 145 0 0
335125144 BR1 CA15D01 964 48 0
33513527 BR1 FC84F01 4 0 0
33513544 BR1 FC82G04 72 0 0
33514025 BR1 FC81I02 85 0 0
33514041 BR1 FC81G04 110 0 0
33514044 BR1 FC82H01 113 0 0
33523903 BR1 FF12C04 180 0 0
33523925 BR1 FF12C03 858 0 0
33523927 BR1 FC81H01 192 0 0
33523941 BR1 FC81E02 120 0 0
33523944 BR1 FF12C02 882 0 0
33524227 BR1 FC84F02 88 0 0
33555627 BR1 FC84F03 2 0 0
33561503 BR1 FC82D01 118 0 0
33561525 BR1 FC82E03 96 0 0
33561543 BR1 FC82I03 70 12 0
33564425 BR1 FF12C05 620 0 0
33564441 BR1 FC82D02 16 0 0
33569427 BR1 FC81D02 35 0 0
33572427 BR1 FC82D03 110 0 0
335726 BR1 CB07G01 181 0 0
350150203 BR1 FC51F01 22 0 0
3501502122 BR1 FC52F01 51 0 0
350150214 BR1 FG10C01 52 0 0
3501502142 BR1 FG10C02 19 0 0
3501502143 BR1 FG10C03 29 0 0
350150227 BR1 FG10C04 107 107 0
350150270 BR1 FG12C01 85 0 0
350150275 BR1 FC53F01 48 0 0
350150276 BR1 FC58B03 24 0 0
350150277 BR1 FG08C03 95 0 0
350176303 BR1 CA25D01 707 0 0
350176325 BR1 FC82A01 48 0 0
350176327 BR1 FCOFLOW 143 0 0
350176341 BR1 CB13D01 346 0 0
350176341 BR1 FCARRET 8 0 0
350176342 BR1 CB12D01 142 0 0
350176343 BR1 FC82A02 73 0 0
350176344 BR1 CA16A03 24 0 0
350176403 BR1 CA15A01 101 0 0
3501764122 BR1 FC86A02 48 0 0
350176414 BR1 FC87A02 75 0 0
3501764142 BR1 FC92A07 76 0 0
350176427 BR1 CA14A02 85 0 0
350176433 BR1 FC54F01 130 0 0
350176470 BR1 FC55F02 83 0 0
350176476 BR1 FC86B02 45 0 0
350176477 BR1 FC63A02 111 0 0
350176503 BR1 FC81A02 81 0 0
350176525 BR1 CB17F01 120 0 0
350176527 BR1 FG20C06 60 36 0
350176541 BR1 FC81I03 12 0 0
350176542 BR1 FC82A03 48 0 0
350176543 BR1 FC84F04 12 0 0
350176544 BR1 CA33A01 26 0 0
350176603 BR1 FC86D04 107 0 0
350176614 BR1 FC88A02 57 0 0
350176627 BR1 FC92G01 70 0 0
350176633 BR1 FC89A02 93 0 0
350176670 BR1 FC58A02 163 0 0
350176677 BR1 FC90A02 54 0 0
350176803 BR1 FC55F01 98 72 0
3501768122 BR1 FC96A05 27 0 0
350176814 BR1 FC56F01 121 0 0
3501768142 BR1 FC92D04 53 0 0
350176827 BR1 FC86E03 82 0 0
350176833 BR1 FC57F01 140 0 0
350176870 BR1 FC55E01 136 0 0
350176876 BR1 FC89A04 81 0 0
350176877 BR1 FC58F01 141 0 0
350178503 BR1 FC88F01 125 0 0
3501785122 BR1 FC89D01 132 0 0
3501785123 BR1 FC87A01 168 35 0
3501785124 BR1 FC91D04 94 48 0
3501785125 BR1 FC88A04 39 0 0
350178514 BR1 CA09A01 168 0 0
3501785142 BR1 FC51D01 243 0 0
3501785145 BR1 FC58E02 200 0 0
350178527 BR1 CB07C01 7 0 0
350178527 BR1 FCOFLOW 8 0 0
350178533 BR1 FC87A04 71 0 0
350178570 BR1 CB03G01 126 0 0
350178572 BR1 FC90D04 107 0 0
350178575 BR1 FC89E01 120 0 0
350178576 BR1 CB02G01 29 0 0
350178577 BR1 FC92D06 73 0 0
350178578 BR1 FC57A02 220 0 0
350178582 BR1 FC86A04 77 0 0
350182503 BR1 FC81E03 213 0 0
350182525 BR1 FC81D03 200 0 0
350182527 BR1 FG18B01 3385 836 0
350182541 BR1 CA23B01 835 0 0
350182542 BR1 FC82E04 106 0 0
350182543 BR1 FC82B04 48 0 0
350182544 BR1 CA19B01 1075 0 0
350182625 BR1 FC81A03 72 0 0
350182627 BR1 FC82A04 112 0 0
350182641 BR1 FC82C01 57 0 0
350182644 BR1 FC81C01 16 0 0
350182725 BR1 FC81E04 239 0 0
350182727 BR1 FC82D04 168 0 0
350182741 BR1 FF14C03 2275 0 0
350182742 BR1 FC81A04 60 0 0
350182744 BR1 CB09G01 22 0 0
350182803 BR1 FC81D04 102 0 0
350182825 BR1 FF13A01 335 0 0
350182827 BR1 FG10A01 9035 622 0
350182841 BR1 CA05C01 694 0 0
350182841 BR1 FCOFLOW 24 0 0
350182843 BR1 FC81F01 141 0 0
350182844 BR1 CA21E01 3488 0 0
350199327 BR1 FF06B05 101 0 0
350199370 BR1 FF04B05 98 0 0
350220803 BR1 FG12C03 113 0 0
350220825 BR1 FG08A01 3138 0 0
350220827 BR1 FF21G01 7500 0 0
350220827 BR1 FG19C05 2494 3314 0
350220841 BR1 FG19A01 994 65 0
350220841 BR1 FH01F01 11255 0 0
350220844 BR1 CA14B01 653 0 0
350220844 BR1 FCARRET 9 0 0
350239203 BR1 FC81B03 98 0 0
350239227 BR1 FC84G01 4 0 0
350239444 BR1 FC84A03 8 0 0
3502730 BR1 FG20C04 144 0 0
350277603 BR1 CB15B01 289 0 0
350277625 BR1 CA26A01 238 0 0
350277627 BR1 FG11F01 1757 0 0
350277641 BR1 CB01H01 323 0 0
350277642 BR1 CB15D01 314 0 0
350277643 BR1 CB09I01 288 0 0
350277644 BR1 CB14B01 83 0 0
350281403 BR1 FC63F01 82 0 0
350281427 BR1 CB08A01 100 0 0
350281433 BR1 FC94B03 8 0 0
350281470 BR1 CB04A01 94 0 0
350281477 BR1 FC91G06 25 0 0
350281503 BR1 FG08C01 666 0 0
3502815122 BR1 CA30I01 15 0 0
3502815123 BR1 FC89B02 52 0 0
350281514 BR1 FC63B03 27 0 0
3502815142 BR1 FC89E02 54 0 0
350281527 BR1 FG20C02 338 0 0
350281576 BR1 CA14A01 25 0 0
350281577 BR1 FC56B03 185 0 0
350282603 BR1 FF02C03 140 140 0
350282625 BR1 CB12B01 649 528 0
350282627 BR1 FC82E01 341 0 0
350282641 BR1 CB01F01 262 0 0
350282644 BR1 FF02A01 1 0 0
350290825 BR1 FC82B01 24 0 0
350304625 BR1 CA27I01 13 0 0
350304627 BR1 FC84B01 46 0 0
350307027 BR1 FC84B02 4 0 0
350322625 BR1 FC82B02 125 0 0
350322641 BR1 FC82F02 111 0 0
350322644 BR1 FC81B02 134 0 0
350334 BR1 FC93I03 5 0 0
350386803 BR1 FF13A05 210 0 0
350386825 BR1 FC84B03 6 0 0
350386827 BR1 CA08B01 302 0 0
350386842 BR1 FC82B03 60 0 0
350413303 BR1 FC87E02 65 0 0
350413327 BR1 FC55A02 12 12 0
350413370 BR1 FC57E02 75 0 0
350413403 BR1 FC84B04 6 0 0
350413425 BR1 FC82C02 24 0 0
350413427 BR1 FC81C02 72 0 0
350413441 BR1 FC82C03 48 0 0
350413442 BR1 FC81C03 23 0 0
350413443 BR1 FC84C01 4 0 0
350413444 BR1 FC84I02 8 0 0
350446203 BR1 FF06C02 1045 0 0
350446225 BR1 CA20B01 2319 0 0
350446227 BR1 CA13E01 525 0 0
350446227 BR1 FCARRET 3 0 0
350446227 BR1 FCOFLOW 648 0 0
350446241 BR1 CB08D01 90 0 0
350446242 BR1 FG18C04 289 0 0
350446243 BR1 FC82H02 59 0 0
350446244 BR1 CA06G01 6 0 0
350446303 BR1 FC81H02 54 0 0
350446325 BR1 CA17C01 1814 0 0
350446327 BR1 CB08I01 1 0 0
350446341 BR1 CA03D01 896 0 0
350446344 BR1 FC81F02 190 0 0
350446403 BR1 FC86A03 91 0 0
350446427 BR1 FC53E01 133 37 0
350446427 BR1 FCOFLOW 720 0 0
350446433 BR1 FC96I05 5 0 0
350446470 BR1 FC57D03 371 0 0
350446527 BR1 FC95I05 20 0 0
350446570 BR1 FC94I05 57 0 0
350472225 BR1 FC84I03 15 0 0
350472227 BR1 FF08A04 2381 0 0
350472241 BR1 FC84G03 8 0 0
350472244 BR1 FC82I04 153 0 0
370182 BR1 FH02C02 7500 0 0
390072 BR1 FCOFLOW 25 0 0
390161 BR1 FG18G02 1080 0 0
390290 BR1 FC31A02 25 0 0
390344 BR1 FG14G01 135 0 0
390371 BR1 FG06G02 750 750 0
390382 BR1 FC31A03 100 0 0
390388 BR1 FG14G02 960 0 0
390390 BR1 FG18F01 125 0 0
390391 BR1 FG20F01 60 0 0
390459 BR1 FH11F02 150 0 0
390473 BR1 FCOFLOW 8 0 0
390534 BR1 FG16F01 750 0 0
390535 BR1 FG18F02 960 0 0
390536 BR1 FH07F01 700 0 0
390537 BR1 FH07F02 1000 0 0
390540 BR1 FG20F02 2100 0 0
390541 BR1 FG16G01 1200 0 0
390544 BR1 FH01G02 1500 0 0
390545 BR1 FH09G01 250 0 0
390554 BR1 FG14F01 60 0 0
390555 BR1 FG14F02 2160 2160 0
390557 BR1 FG15G01 4200 3780 0
390730 BR1 FG13F01 750 0 0
390734 BR1 FG11F02 600 0 0
390741 BR1 FC31A04 5 0 0
390744 BR1 FC31A05 20 0 0
390892 BR1 FH09G02 520 0 0
390893 BR1 FH03A01 625 0 0
390894 BR1 FC31A06 40 0 0
390906 BR1 FCOFLOW 765 0 0
390907 BR1 FH03A02 780 0 0
390914 BR1 FC31A07 40 0 0
400054 BR1 FC95C14 12 0 0
400063 BR1 FC49B02 127 0 0
4001278 BR1 FC93I05 6 0 0
4001508 BR1 FF10A06 230 0 0
4001536 BR1 FG05G02 716 0 0
4001537 BR1 FG05G01 1000 0 0
4001539 BR1 FG03G01 8960 0 0
400164 BR1 FC54F02 2 0 0
400165 BR1 FCOFLOW 147 0 0
4001669 BR1 FC95A05 100 0 0
400170 BR1 FC58D03 128 56 0
4001763 BR1 FC54A02 202 0 0
4001811 BR1 FCOFLOW 63 0 0
4001821 BR1 FC87H02 4 0 0
4001823 BR1 FC94H07 89 0 0
4001824 BR1 FF04A03 230 0 0
4001825 BR1 FF04B04 220 0 0
4001859 BR1 FF06B04 250 0 0
4002050 BR1 FG16B01 550 0 0
4002168 BR1 FC91D06 102 0 0
4002171 BR1 FF13A02 256 0 0
4002172 BR1 FG08G01 3840 0 0
4002174 BR1 FF13A03 312 0 0
4002175 BR1 FF13A04 156 0 0
4002234 BR1 FH11G02 1000 0 0
4002386 BR1 FC86E02 108 0 0
4002388 BR1 FC57A03 107 0 0
4002394 BR1 FC95I07 24 0 0
4002407 BR1 FC52B02 83 0 0
400244 BR1 FC91A02 78 0 0
4002464 BR1 FC94I07 2 0 0
4002467 BR1 FC89B01 132 0 0
4002468 BR1 FC96I09 57 0 0
4002471 BR1 FC49D02 216 0 0
4002478 BR1 FC53B02 129 0 0
4002484 BR1 FC95I09 7 0 0
4002486 BR1 FC87E04 58 0 0
4002514 BR1 CB07B01 250 0 0
4002526 BR1 FC52A02 279 0 0
4002551 BR1 FC90D06 56 0 0
4002564 BR1 FC93G04 101 0 0
4002597 BR1 FC90A07 146 6 0
4002683 BR1 FH13G01 4000 0 0
4002728 BR1 FC91D08 276 0 0
4002730 BR1 FC89F03 270 0 0
4002865 BR1 FC90G08 51 0 0
4002929 BR1 FG07G01 8704 0 0
400295 BR1 FC93I09 2 0 0
4002968 BR1 FC92H05 12 0 0
400298 BR1 FC96I11 2 0 0
4003032 BR1 FC96B03 4 0 0
4003035 BR1 FC87B01 130 0 0
4003036 BR1 FC94A05 55 0 0
4003038 BR1 FC91G01 30 0 0
4003039 BR1 FC95B05 23 0 0
4003046 BR1 FC93B05 6 0 0
4003047 BR1 CA25F01 458 0 0
4003060 BR1 FF15A01 160 0 0
4003124 BR1 FC96G04 32 0 0
4003162 BR1 FF15A03 140 0 0
4003217 BR1 FF14A04 525 0 0
4003283 BR1 FC95B07 25 0 0
4003284 BR1 FC93B07 25 0 0
4003286 BR1 CA18A01 60 0 0
4003292 BR1 CA29A01 241 0 0
4003292 BR1 FCOFLOW 240 0 0
4003299 BR1 FG09G01 3150 0 0
4003315 BR1 CA19A01 701 0 0
4003322 BR1 CA17A01 3 0 0
4003326 BR1 FC94B07 6 0 0
4003327 BR1 CB03A01 339 0 0
4003328 BR1 FC51E01 193 0 0
4003330 BR1 FC88F03 104 0 0
4003331 BR1 FC49A03 46 0 0
4003435 BR1 FC96B07 100 48 0
4003443 BR1 CA10B01 1112 0 0
4003444 BR1 CB14F01 618 0 0
4003445 BR1 CA26E01 560 0 0
4003446 BR1 CA27E01 1200 0 0
4003447 BR1 CA26B01 138 0 0
4003448 BR1 FC49B03 156 0 0
4003449 BR1 CA26C01 762 0 0
4003450 BR1 FC49E01 77 0 0
4003451 BR1 FC91H01 67 0 0
4003452 BR1 CA25I01 604 0 0
4003454 BR1 CA23A01 124 0 0
4003455 BR1 FC91H02 50 0 0
4003476 BR1 FC49C03 210 0 0
4003477 BR1 FC54B03 198 0 0
4003485 BR1 FC95B09 115 0 0
4003498 BR1 FC54A03 118 118 0
4003500 BR1 FC92H02 50 0 0
4003501 BR1 FC88B01 103 0 0
4003506 BR1 FF02B01 607 0 0
4003507 BR1 FC93B09 4 0 0
4003508 BR1 FC51A02 145 0 0
4003510 BR1 CA03I01 194 0 0
4003510 BR1 FCOFLOW 192 0 0
4003511 BR1 FC94B09 66 0 0
4003513 BR1 CA29B01 200 0 0
4003517 BR1 FC90H02 50 0 0
4003520 BR1 FG18B02 1564 96 0
4003521 BR1 FC58B01 125 0 0
4003521 BR1 FC58D01 48 0 0
4003523 BR1 FC57B01 154 0 0
4003526 BR1 CA04I01 246 0 0
4003527 BR1 FC96B09 113 0 0
4003528 BR1 FC93B11 8 0 0
4003529 BR1 CA10G01 160 0 0
4003531 BR1 FC87F02 69 0 0
4003534 BR1 CA20A01 25 0 0
4003535 BR1 FC96B11 29 0 0
4003536 BR1 FC95B11 35 0 0
4003537 BR1 FC93G06 30 0 0
4003541 BR1 FC55B03 88 0 0
4003543 BR1 FC63B01 157 0 0
4003544 BR1 FC54D03 126 0 0
4003545 BR1 FC93B13 25 0 0
4003546 BR1 FC94B13 25 0 0
4003549 BR1 CA29E03 19 0 0
4003550 BR1 FCOFLOW 15 0 0
4003552 BR1 FC86E04 84 0 0
4003554 BR1 FC96B13 5 0 0
4003555 BR1 FC95B13 6 0 0
4003556 BR1 FC93C01 13 0 0
4003560 BR1 FG08B01 1000 0 0
4003563 BR1 CA12H01 960 0 0
4003564 BR1 CA16A02 4 0 0
4003565 BR1 FC55E02 75 0 0
4003566 BR1 CA20A02 48 0 0
4003567 BR1 FC92H04 60 0 0
4003569 BR1 CA22H01 401 0 0
4003570 BR1 CA22E01 400 0 0
4003571 BR1 FC94C01 25 0 0
4003572 BR1 FC58F02 199 0 0
4003577 BR1 FC63E03 114 0 0
4003580 BR1 FC88F02 98 0 0
4003581 BR1 FC56B01 138 0 0
4003582 BR1 CA15A02 189 0 0
4003583 BR1 CA34E01 133 142 0
4003583 BR1 FCOFLOW 400 0 0
4003584 BR1 FC63D03 250 0 0
4003586 BR1 FC91H04 86 0 0
4003587 BR1 FC93G08 51 0 0
4003588 BR1 CA27B01 979 0 0
4003589 BR1 FC57F02 150 0 0
4003590 BR1 CA29E02 72 0 0
4003591 BR1 CA29A02 218 0 0
4003593 BR1 FC90H04 74 0 0
4003594 BR1 FC56E03 185 0 0
4003595 BR1 FC96G08 28 0 0
4003596 BR1 CA21H01 475 21 0
4003597 BR1 CB08G01 456 144 0
4003599 BR1 CA14F01 128 0 0
4003606 BR1 FC96C01 25 0 0
4003607 BR1 CB04D01 346 0 0
4003609 BR1 FCOFLOW 4 4 0
4003610 BR1 FC95C01 11 0 0
4003615 BR1 FC58E03 104 0 0
4003616 BR1 CA30E01 159 0 0
4003619 BR1 CB04C01 698 0 0
4003620 BR1 CB05I01 40 0 0
4003620 BR1 FC88H02 15 0 0
4003623 BR1 FC92H06 168 35 0
4003624 BR1 CB06H01 125 0 0
4003625 BR1 FC92A02 90 0 0
4003626 BR1 FC91H06 50 0 0
4003627 BR1 CA05H01 359 0 0
4003627 BR1 FC57E03 250 0 0
4003629 BR1 CA01I01 4 72 0
4003629 BR1 FCOFLOW 72 0 0
4003630 BR1 FC52A03 160 0 0
4003635 BR1 FC53E02 141 0 0
4003637 BR1 CA09B01 131 0 0
4003639 BR1 CA22F01 205 0 0
4003640 BR1 FC93G10 77 0 0
4003647 BR1 CA09H01 217 0 0
4003652 BR1 CB18A01 1354 0 0
4003652 BR1 FCARRET 47 0 0
4003654 BR1 FC93C03 10 0 0
4003655 BR1 FC94C03 18 0 0
4003659 BR1 CB17A01 380 48 0
4003667 BR1 FC87F04 89 0 0
4003668 BR1 FF02B02 1420 0 0
4003669 BR1 CA30A01 125 0 0
4003675 BR1 CA32A02 6 0 0
4003676 BR1 CA14H02 505 146 0
4003678 BR1 CA16I01 32 0 0
4003679 BR1 CB01A01 51 0 0
4003679 BR1 FC92H07 49 0 0
4003682 BR1 CB16B01 2122 0 0
4003683 BR1 CA22H02 516 0 0
4003686 BR1 CA22A01 547 0 0
4003687 BR1 CB05D01 110 0 0
4003688 BR1 CB04E01 425 2 0
4003689 BR1 CA12B01 1004 0 0
4003690 BR1 CA03B01 671 128 0
4003694 BR1 CB18F01 13 0 0
4003703 BR1 FG10G02 7424 0 0
4003717 BR1 CA29F01 249 0 0
4003719 BR1 FCOFLOW 17 17 0
4003728 BR1 CA13B01 364 0 0
4003734 BR1 FC92F03 98 0 0
4003745 BR1 CA05F01 518 0 0
4003745 BR1 FCOFLOW 144 0 0
4003746 BR1 CB05B01 135 0 0
4003748 BR1 FC91H05 410 139 0
4003749 BR1 CA07B01 2406 0 0
4003749 BR1 FCOFLOW 112 0 0
4003750 BR1 CB02D01 1217 0 0
4003760 BR1 FCOFLOW 4704 0 0
400444 BR1 FG10B02 50 0 0
400571 BR1 FC95C03 49 0 0
401393 BR1 CA14H01 14212 528 0
401393 BR1 FCARRET 46 0 0
401393 BR1 FCOFLOW 732 48 0
405100 BR1 CA01D01 3595 3278 0
405101 BR1 CB01D01 2272 59 0
405101 BR1 FCARRET 2 0 0
405106 BR1 FF14C01 8609 240 0
405111 BR1 FC96D13 135 0 0
405220 BR1 FC94C05 128 0 0
405230 BR1 FC93G12 572 0 0
405231 BR1 FC94E13 351 0 0
405232 BR1 FC93G14 11 0 0
405235 BR1 FC96G10 322 0 0
405237 BR1 CA25B01 5643 0 0
405243 BR1 CA18B01 83 0 0
405244 BR1 CA29B02 11 0 0
405244 BR1 FCOFLOW 100 0 0
405246 BR1 FCOFLOW 48 0 0
405247 BR1 FC94D03 482 0 0
405320 BR1 FC91B01 586 0 0
405321 BR1 FC55B01 304 0 0
405334 BR1 FC92F05 304 288 0
405338 BR1 FC95E13 10954 384 0
405350 BR1 FC49E02 1920 1610 0
405351 BR1 CB16D01 6822 0 0
405365 BR1 CA29C02 8316 0 0
405366 BR1 FC92I04 748 0 0
405373 BR1 CA28A01 10800 0 0
4061001 BR1 FC57F03 412 0 0
4061003 BR1 FC90H06 10 0 0
4061004 BR1 FC49D03 584 0 0
4061005 BR1 CA17F01 385 0 0
4061006 BR1 FC63F03 100 0 0
4061007 BR1 FC92A04 59 59 0
4061008 BR1 FC54B01 850 0 0
4061012 BR1 FC92D08 7108 0 0
4061015 BR1 FC89H02 99 0 0
4061016 BR1 CB02A01 998 0 0
4061033 BR1 FC96A07 192 0 0
4061034 BR1 FC91A04 100 0 0
4061045 BR1 FC86B01 1052 528 0
4061047 BR1 FC90G01 1210 0 0
4061048 BR1 FC95A07 329 0 0
4061052 BR1 FC90A04 1092 0 0
4061053 BR1 FC90D08 457 0 0
4061054 BR1 FC95E01 401 0 0
4061056 BR1 FC94A07 158 0 0
4061057 BR1 FC89B03 698 0 0
4061063 BR1 FC91I01 352 0 0
4061068 BR1 FC93C07 399 0 0
4061069 BR1 FC91G03 180 0 0
4061070 BR1 FC96G12 162 0 0
4061072 BR1 FC93A02 4 0 0
4061079 BR1 FC91E01 368 0 0
4061080 BR1 FC92G05 451 0 0
4061081 BR1 FC93C08 37 0 0
4061085 BR1 FC93E01 298 0 0
4061087 BR1 FC94A02 10 0 0
4061090 BR1 CB05H02 194 0 0
4061090 BR1 FC90E03 400 0 0
4061091 BR1 FC93F01 306 124 0
4061096 BR1 CB08B01 1066 0 0
4061106 BR1 CA11D01 184 0 0
4061107 BR1 FC57E01 43 0 0
4061110 BR1 FC87G01 249 144 0
4061115 BR1 FC51A03 1884 0 0
4061122 BR1 FC89G01 243 0 0
4061123 BR1 FC91E02 525 384 0
4061124 BR1 FC58B02 1293 0 0
4061125 BR1 CA30C01 1991 0 0
4061126 BR1 CA09D01 227 0 0
4061127 BR1 FC96A09 183 0 0
4061128 BR1 FC95A02 103 0 0
4061130 BR1 FC90G03 493 0 0
4061132 BR1 FC92E02 685 0 0
4061133 BR1 FC88B03 590 0 0
4061135 BR1 FC96A02 2642 0 0
4061136 BR1 FC87B03 770 0 0
4061137 BR1 FC94A11 124 0 0
4061138 BR1 FC53B03 88 0 0
4061139 BR1 CB07F01 317 0 0
4061141 BR1 FC96E01 304 0 0
4061142 BR1 FC93C09 314 96 0
4061143 BR1 FC95A09 100 0 0
4061144 BR1 FC96A04 1 0 0
4061145 BR1 FC94F01 251 0 0
4061146 BR1 FC94A09 108 0 0
4061147 BR1 FCOFLOW 5 0 0
4061148 BR1 FC93A09 200 0 0
4061150 BR1 FC94F11 99 0 0
4061151 BR1 FC94E01 100 0 0
4061154 BR1 FC92A06 50 0 0
4061155 BR1 FC94A04 249 48 0
4061156 BR1 FC95A04 124 0 0
4061157 BR1 FC89C01 54 48 0
4061159 BR1 FC96D11 251 0 0
406116 BR1 CA24A01 463 0 0
4061160 BR1 FC95F13 182 0 0
4061161 BR1 FC92B01 305 0 04061162 BR1 FC93A04 10 0 0
4061163 BR1 FC96F01 338 0 0
4061164 BR1 FC90E02 700 0 0
4061165 BR1 FC90E05 259 0 0
4061166 BR1 FC95E03 210 0 0
4061167 BR1 FC96A06 60 0 0
4061169 BR1 FC95A06 79 0 0
406117 BR1 FC93C10 120 0 0
4061171 BR1 FC93F13 164 0 0
4061177 BR1 FC95F01 145 0 0
4061178 BR1 FC94F13 81 0 0
4061179 BR1 FC54E03 1327 0 0
4061180 BR1 FC96F13 104 0 0
4061181 BR1 FC90B01 328 0 0
4061182 BR1 FC93F03 268 0 0
4061183 BR1 CA30A02 919 0 0
4061184 BR1 FC63B02 1040 0 0
4061190 BR1 FC94F03 136 0 0
4061202 BR1 FC93E03 126 0 0
4061217 BR1 FC94A06 294 0 0
4061218 BR1 FC92H08 14 0 0
4061219 BR1 FC88G01 485 0 0
4061220 BR1 FC92B03 237 0 0
4061221 BR1 FC56D03 1525 0 0
4061222 BR1 CA27C01 3170 0 0
4061223 BR1 FC91B03 510 0 0
4061224 BR1 FC93A06 23 0 0
4061225 BR1 FC96A08 18 0 0
4061226 BR1 FC93C11 69 0 0
4061227 BR1 FC93C12 35 0 0
4061228 BR1 CA05D01 29 0 0
4061229 BR1 CA24A02 15 0 0
4061230 BR1 FCOFLOW 71 0 0
4061231 BR1 CA02H01 569 0 0
4061231 BR1 FCOFLOW 180 0 0
4061232 BR1 FC93C13 350 0 0
4061234 BR1 FC94A08 92 0 0
4061235 BR1 FC93C14 36 0 0
4061236 BR1 FC88G03 876 0 0
4061237 BR1 FC92E07 268 0 0
4061238 BR1 FC90B03 666 0 0
4061243 BR1 FC95G01 130 0 0
4061244 BR1 FC93G01 116 0 0
4061247 BR1 FC96G01 59 0 0
4061248 BR1 FCOFLOW 63 0 0
4061249 BR1 FC91H08 32 0 0
4061254 BR1 FC96A10 10 0 0
4061262 BR1 FC94G01 141 0 0
4061263 BR1 FC96F03 163 0 0
4061268 BR1 FC95F03 629 0 0
4061270 BR1 FC95A10 79 0 0
4061271 BR1 FC94A10 47 0 0
4061272 BR1 FC95G03 118 0 0
4061273 BR1 FC93A10 139 0 0
4061274 BR1 FC93G03 104 0 0
4061275 BR1 CA25A01 194 0 0
4061278 BR1 FC87C01 753 0 0
4061279 BR1 FC86B03 745 0 0
406128 BR1 CA29E01 44 0 0
4061280 BR1 FC52D02 1017 0 0
4061282 BR1 FC95D09 299 0 0
4061284 BR1 FC96A12 180 0 0
406129 BR1 FCOFLOW 149 0 0
4061302 BR1 FC94E03 285 0 0
4061303 BR1 FC92E05 313 0 0
4061306 BR1 CA27A01 5498 0 0
4061307 BR1 CB07A01 998 0 0
4061308 BR1 FC92E04 210 0 0
4061310 BR1 FC91E04 304 0 0
4061311 BR1 FC94G03 225 0 0
4061312 BR1 FC96G03 300 0 0
4061313 BR1 FC91G05 315 0 0
4061314 BR1 FC90E04 302 0 0
4061315 BR1 FC92B05 135 0 0
4061316 BR1 FC93F05 166 0 0
4061317 BR1 FC96E03 162 0 0
4061318 BR1 FC88C01 558 0 0
4061319 BR1 FC90H08 300 0 0
4061320 BR1 CB16G01 410 0 0
4061321 BR1 FC56B02 186 0 0
4061322 BR1 FC51E02 1711 0 0
4061333 BR1 CA29C01 2713 0 0
4061342 BR1 FC90F03 323 96 0
4061343 BR1 FC91B05 316 0 0
4061345 BR1 FC93A11 154 0 0
4061346 BR1 CB17H01 102 0 0
4061358 BR1 FC93D07 1 0 0
4061361 BR1 FC92I02 3307 0 0
4061364 BR1 FC94A12 121 0 0
4061365 BR1 FC57B02 958 384 0
4061368 BR1 FG20C03 63 35 0
4061371 BR1 FC93A12 111 0 0
4061373 BR1 FC95A12 14 0 0
4061374 BR1 FC86D02 1372 0 0
4061378 BR1 FF14B04 1096 0 0
4061379 BR1 FC95A14 14 0 0
4061381 BR1 FC93A14 12 0 0
4061383 BR1 FC95G05 384 0 0
4061388 BR1 CB15F01 6793 0 0
4061391 BR1 CB12A01 135 0 0
4061398 BR1 FC56F03 298 0 0
4061402 BR1 FCOFLOW 20 0 0
4061405 BR1 FC87E01 738 0 0
4061406 BR1 FC93H01 108 0 0
4061408 BR1 CA33B01 450 450 0
4061409 BR1 CA22B01 1955 0 0
4061410 BR1 CA16G01 1933 0 0
4061414 BR1 CA07H01 229 0 0
4061428 BR1 CB17C01 391 0 0
4061429 BR1 CB05F02 396 0 0
406143 BR1 FC88H04 100 0 0
4061430 BR1 CB17G01 87 0 0
4061432 BR1 CA07F01 493 0 0
4061432 BR1 FCOFLOW 448 48 0
4061433 BR1 CB18E01 876 0 0
4061436 BR1 FC91C05 738 0 0
4061437 BR1 CB17D01 4288 0 0
4061438 BR1 FC51B03 1624 0 0
4061439 BR1 FC91C06 833 0 0
4061444 BR1 CB28H01 136 0 0
4061445 BR1 FCOFLOW 146 0 0
4061446 BR1 CB28H02 189 0 0
4061447 BR1 FCOFLOW 65 0 0
4061449 BR1 FCOFLOW 2000 0 0
4061459 BR1 CB19C01 1104 0 0
4061463 BR1 CB28D02 595 0 0
4061467 BR1 CB28E01 1533 0 0
4061468 BR1 CA34F01 62 0 0
4061469 BR1 CB19C02 840 0 0
4061470 BR1 CA34F02 111 0 0
4061471 BR1 CB11A01 116 0 0
4061487 BR1 CA32C03 384 0 0
4061488 BR1 CA32C02 336 0 0
406151 BR1 FCOFLOW 1 0 0
406152 BR1 FCOFLOW 6 0 0
406153 BR1 FC52B03 2163 0 0
406157 BR1 FC94A14 16 0 0
406174 BR1 FC86F02 201 0 0
406191 BR1 FC90B05 286 0 0
406192 BR1 FC92B07 321 0 0
406196 BR1 FCOFLOW 34 0 0
406200 BR1 CB04B01 1538 0 0
406201 BR1 FC53F02 4421 2640 0
406204 BR1 FC87G03 313 0 0
406214 BR1 FC89G03 151 0 0
406233 BR1 FC90D05 308 0 0
406236 BR1 FC91E07 300 0 0
406238 BR1 FC91D07 392 0 0
406240 BR1 FC92D01 405 0 0
406241 BR1 FC91A06 369 0 0
406242 BR1 FC92D07 510 0 0
406244 BR1 FC96A14 81 0 0
406251 BR1 FC95B02 54 0 0
406263 BR1 FC93G05 151 0 0
406272 BR1 FC93B02 13 0 0
406277 BR1 FC94G05 100 0 0
406282 BR1 FC95E05 152 0 0
406283 BR1 FC93E05 203 0 0
406287 BR1 FC96G05 100 0 0
406338 BR1 FC89F04 271 0 0
406344 BR1 FC92E06 119 0 0
406345 BR1 FC55E03 1206 816 0
406347 BR1 FC91E06 279 0 0
406352 BR1 FC88F04 884 0 0
406357 BR1 FC91B07 100 0 0
406359 BR1 FC49A01 413 0 0
406363 BR1 CA30B01 736 0 0
406364 BR1 FC95G07 103 0 0
406366 BR1 FC53E03 1929 336 0
406367 BR1 FC94F05 205 0 0
406368 BR1 FC86F04 419 0 0
406370 BR1 FC90B07 403 0 0
406371 BR1 FC92C01 316 0 0
406372 BR1 FC96E05 531 0 0
406373 BR1 CA32C01 48 0 0
406374 BR1 FC96B02 9 0 0
406375 BR1 FC93G07 302 0 0
406405 BR1 FC96G07 226 0 0
406409 BR1 FC91A08 102 0 0
406412 BR1 FC94G07 100 0 0
406413 BR1 FCOFLOW 7 0 0
406414 BR1 FC94B02 103 0 0
406419 BR1 FC94D11 465 0 0
406430 BR1 FC95G09 127 0 0
406437 BR1 FC90E06 145 0 0
406443 BR1 FC92A08 100 0 0
406445 BR1 FC96F05 88 0 0
406446 BR1 CB19B02 48 0 0
406447 BR1 CA10I01 1370 382 0
406449 BR1 FC95B04 10 0 0
406450 BR1 FC93B04 100 0 0
406477 BR1 FC91C01 680 0 0
406487 BR1 FC90I05 163 0 0
406488 BR1 FC90A08 57 0 0
406489 BR1 FC91B02 61 0 0
406490 BR1 FC92E08 166 0 0
406494 BR1 FC94B04 100 0 0
406497 BR1 FC96B04 160 0 0
406521 BR1 FC89B04 294 0 0
406616 BR1 FC91E08 57 0 0
406650 BR1 FC53B01 2894 0 0
406651 BR1 FC88H01 85 336 0
406652 BR1 FC52A01 752 0 0
406675 BR1 FC93G09 147 0 0
406678 BR1 FC96G09 219 0 0
406696 BR1 FC87G02 2501 0 0
406697 BR1 FC94G09 52 0 0
406698 BR1 FCOFLOW 3 0 0
406700 BR1 FC94E05 212 0 0
406705 BR1 FC90C01 276 0 0
406706 BR1 FC52B01 1411 0 0
406709 BR1 FC93H03 21 0 0
406710 BR1 FC92G07 208 0 0
406714 BR1 FC55B02 1067 0 0
406717 BR1 FC90E08 497 0 0
406718 BR1 FC95F05 268 0 0
406727 BR1 FC93F07 125 0 0
406732 BR1 FC94F07 149 0 0
406754 BR1 FC95G11 172 0 0
406755 BR1 FC93G11 108 0 0
406759 BR1 FC87B04 193 0 0
406760 BR1 FC89G02 100 0 0
406767 BR1 FC92F02 104 0 0
406768 BR1 FC92B02 55 0 0
406772 BR1 CA16I02 692 0 0
406787 BR1 FC96G11 257 0 0
406793 BR1 CA18D01 828 0 0
406794 BR1 FC88I03 159 96 0
406795 BR1 FC90G05 121 0 0
406798 BR1 FC91F02 127 0 0
406803 BR1 FC90F02 145 0 0
406806 BR1 FC91F04 41 0 0
406810 BR1 FC94G11 104 0 0
406816 BR1 FC93B06 2 0 0
406819 BR1 FC95G13 133 0 0
406831 BR1 FC95E07 248 0 0
406835 BR1 FC93H05 97 0 0
406836 BR1 FC91C03 833 0 0
406837 BR1 FC91G07 600 0 0
406838 BR1 FC92H01 541 0 0
406839 BR1 FC96F07 128 0 0
406841 BR1 FC54A01 1341 288 0
406842 BR1 FC96B06 66 0 0
406844 BR1 CB16A01 596 0 0
406845 BR1 FC90B02 53 0 0
406847 BR1 FC92B04 129 0 0
406850 BR1 FC93E07 202 0 0
406852 BR1 FC94E07 208 0 0
406853 BR1 FC96E07 100 0 0
406857 BR1 FC95E09 200 0 0
406858 BR1 FC94B06 199 0 0
406992 BR1 FC88B04 206 0 0
460381 BR1 FH04A01 711 0 0
50010146 BR1 FC93B08 500 0 0
50010147 BR1 FC94B08 250 0 0
50010149 BR1 FC95B10 155 0 0
50010284 BR1 FC93B12 10000 0 0
50010422 BR1 FC94H02 2500 0 0
50010437 BR1 FC55F03 10000 0 0
50010476 BR1 FC95H02 5000 0 0
50010477 BR1 FC91B04 5000 0 0
50010858 BR1 FC92B06 8000 0 0
50010872 BR1 FC96H04 5000 0 0
50010973 BR1 FC87H04 1000 0 0
50011119 BR1 FC86H04 2000 0 0
50011255 BR1 FC95H04 500 0 0
50011259 BR1 FC96H06 500 0 0
50011260 BR1 FC95H06 500 0 0
50011261 BR1 FC94H06 500 0 0
50011262 BR1 FC93H06 1000 0 0
50011264 BR1 CB28D01 3998 0 0
50011268 BR1 FC96H08 500 0 0
50011289 BR1 FC95H08 1500 0 0
50011290 BR1 FC93H08 1250 0 0
50011291 BR1 FC94H08 275 0 0
50011298 BR1 FC96H10 1250 0 0
50011299 BR1 FC95H10 500 0 0
50011300 BR1 FC94H10 250 0 0
50011354 BR1 FC93H10 250 0 0
50011356 BR1 FC96H12 250 0 0
50013148 BR1 FC94H12 500 0 0
50013149 BR1 CA03A03 1000 0 0
50013284 BR1 FC93H12 500 0 0
50013305 BR1 FC95H12 760 0 0
50013309 BR1 FC95H14 97 0 0
50013318 BR1 FC94H14 96 0 0
50013319 BR1 FC94B12 270 0 0
50013320 BR1 FC96B12 337 0 0
50013371 BR1 FC95B12 548 0 0
50013372 BR1 FC93B14 500 0 0
50013373 BR1 FC96H14 500 0 0
50013380 BR1 FC95I02 2000 0 0
50013401 BR1 FC93I02 500 0 0
50013404 BR1 FC87I02 3000 0 0
50013549 BR1 FC96I02 1000 0 0
50013550 BR1 FC94I02 1000 0 0
50013614 BR1 FC91B06 1250 0 0
50013654 BR1 FC54F03 2000 0 0
50013663 BR1 FC95I04 1500 0 0
50013664 BR1 FC93I04 500 0 0
50013843 BR1 FC90B06 3000 0 0
50013964 BR1 FC94I04 500 0 0
50013965 BR1 FC96I04 500 0 0
50013967 BR1 CB19A04 500 0 0
50013968 BR1 CA32B03 828 0 0
50013969 BR1 CA03A02 500 0 0
50013973 BR1 FC91B08 500 0 0
50014023 BR1 FC93I06 500 0 0
50014024 BR1 FC96I06 500 0 0
50014025 BR1 FC94I06 500 0 0
50014030 BR1 FC95I08 500 0 0
50014157 BR1 FC94I08 500 0 0
50014158 BR1 FC96I08 500 0 0
50014167 BR1 FC90B08 1500 0 0
50014328 BR1 FC95D02 500 0 0
50014332 BR1 FC88I02 1500 0 0
50014334 BR1 CA32A03 500 0 0
50014337 BR1 FC96D02 550 0 0
50014636 BR1 FC89C02 2000 0 0
50014639 BR1 FC96D04 1000 0 0
50014645 BR1 FC94D04 1250 0 0
50014704 BR1 CB19A02 1000 0 0
50014737 BR1 FC95D04 1011 0 0
50014797 BR1 FC93D04 500 0 0
50014800 BR1 FC86B04 1500 0 0
50014801 BR1 FC96D06 500 0 0
50014802 BR1 FC95D06 1000 0 0
50014809 BR1 FC93D08 500 0 0
50014810 BR1 FC94D08 500 0 0
50014890 BR1 FC91C07 2250 0 0
50014934 BR1 CB19A01 346 0 0
50014940 BR1 CA32B02 500 0 0
50014954 BR1 CB19B01 500 0 0
50014980 BR1 FCOFLOW 2000 0 0
50014990 BR1 FCOFLOW 5000 0 0
50015082 BR1 CA25A02 250 0 0
50015083 BR1 CB19A03 500 0 0
5006900 BR1 FC89I04 10000 0 0
5006932 BR1 FC93D10 5000 0 0
5006961 BR1 FC94D12 250 0 0
5006966 BR1 FC95D12 250 0 0
5006977 BR1 FCOFLOW 500 0 0
5006979 BR1 FC95E02 250 0 0
5006980 BR1 FC92C02 500 0 0
5006984 BR1 FC96E02 250 0 0
5006987 BR1 FC95E04 540 0 0
5007035 BR1 CA25A03 540 0 0
5007036 BR1 FC93E08 250 0 0
5007037 BR1 FC94E08 84 0 0
5007038 BR1 FC96E08 250 0 0
5007039 BR1 FC95E10 250 0 0
5007075 BR1 FC96E12 250 0 0
5007078 BR1 FC95E12 250 0 0
5007079 BR1 FC91C02 500 0 0
5007080 BR1 FC93E14 250 0 0
5007081 BR1 FC94E14 250 0 0
5007084 BR1 FC95E14 250 0 0
5007089 BR1 FC94F02 250 0 0
5007099 BR1 FC95F02 99 0 0
5007119 BR1 FC93C02 250 0 0
5007122 BR1 FC96C02 250 0 0
5007135 BR1 FC95C02 250 0 0
5007150 BR1 FC94C04 250 0 0
5007152 BR1 FC96C04 250 0 0
5007595 BR1 FC94C06 250 0 0
5007863 BR1 FC51F02 1000 0 0
5007930 BR1 FC90C02 17500 0 0
5008079 BR1 FC95F06 1000 0 0
5008080 BR1 CA30B02 4019 0 0
5008251 BR1 FC93F08 500 0 0
5008662 BR1 FC96F08 5000 0 0
5008673 BR1 FC95F08 9840 0 0
5008718 BR1 FC95F10 250 0 0
5008728 BR1 FC93F10 1000 0 0
5008751 BR1 FC90I02 5000 0 0
5008761 BR1 CB11A03 1000 0 0
5008819 BR1 CB11E01 9500 0 0
5008884 BR1 FC95F12 250 0 0
5008885 BR1 FC93F12 250 0 0
5008886 BR1 FC94F12 250 0 0
5009124 BR1 FC94F14 500 0 0
5009153 BR1 FC96F14 2500 0 0
5009273 BR1 FC96G02 1000 0 0
5009452 BR1 FC94G02 5000 0 0
5009466 BR1 FC91C04 1000 0 0
5009641 BR1 CB11G01 25404 0 0
5009719 BR1 FC95G04 250 0 0
5009997 BR1 FC96C06 500 0 0
Part numbers are the first column.
Shelf location are in col 3.
PROBLEM:
I need to refine the query so that only part numbers with at least one location starting with 'C' and at least one location starting with 'F' are returned.
So part numbers 0301646, 0301650, 0301656 and 030392 amongst others would NOT be returned (They ONLY have 'F' locations).
Any ideas?
Is this Microsoft SQL?
If it is, I might have an idea that could work.
If it is, I might have an idea that could work.
ASKER
This is ShowCase Vista querying iSeries
ASKER
I got my query to KIND OF work with:
SELECT
IBLITM,
LIMCU,
LILOCN,
LIPQOH,
LIHCOM,
LIPBCK
FROM
*LIBL.F4102 v,
*LIBL.F41021 f
WHERE
V.IBITM = F.LIITM
AND V.IBMCU = F.LIMCU
AND ( ( ( ( LIMCU = 'BR1'
AND LIPQOH > 0
AND IBGLPT = 'IN10'
AND LILOCN BETWEEN 'CA01A01' AND 'FH99Z99')))
AND LIITM in(
SELECT
B.LIITM
FROM
*LIBL.F41021 B
WHERE
B.LILOCN like 'C%'
AND F.LIMCU = B.LIMCU
)
AND LIITM in(
SELECT
C.LIITM
FROM
*LIBL.F41021 C
WHERE
C.LILOCN like 'F%'
AND F.LIMCU = C.LIMCU
))
ORDER BY
1,
3
But some items are coming back that ONLY have a 'C%' location.
Nothing is coming back with only an 'F%' location....
SELECT
IBLITM,
LIMCU,
LILOCN,
LIPQOH,
LIHCOM,
LIPBCK
FROM
*LIBL.F4102 v,
*LIBL.F41021 f
WHERE
V.IBITM = F.LIITM
AND V.IBMCU = F.LIMCU
AND ( ( ( ( LIMCU = 'BR1'
AND LIPQOH > 0
AND IBGLPT = 'IN10'
AND LILOCN BETWEEN 'CA01A01' AND 'FH99Z99')))
AND LIITM in(
SELECT
B.LIITM
FROM
*LIBL.F41021 B
WHERE
B.LILOCN like 'C%'
AND F.LIMCU = B.LIMCU
)
AND LIITM in(
SELECT
C.LIITM
FROM
*LIBL.F41021 C
WHERE
C.LILOCN like 'F%'
AND F.LIMCU = C.LIMCU
))
ORDER BY
1,
3
But some items are coming back that ONLY have a 'C%' location.
Nothing is coming back with only an 'F%' location....
Hopefully your SQL engine likes the "CASE" clause.
If so, here's something that could help.
Give it a try and let us know.
If so, here's something that could help.
Give it a try and let us know.
SELECT
IBLITM,
LIMCU,
LILOCN,
LIPQOH,
LIHCOM,
LIPBCK
FROM
*LIBL.F4102 F4102,
*LIBL.F41021 F41021
WHERE
F4102.IBITM = F41021.LIITM
AND F4102.IBMCU = F41021.LIMCU
AND ( ( ( ( LIMCU = 'BR1'
AND LIPQOH > 0
AND IBGLPT = 'IN10'
AND LILOCN BETWEEN 'CA01A01' AND 'FH99Z99'))))
AND IBLITM IN
(
SELECT
IBLITM,
SUM(CASE WHEN LILOCN LIKE 'C%' THEN 1 ELSE 0 END) AS TOTAL_C,
SUM(CASE WHEN LILOCN LIKE 'F%' THEN 1 ELSE 0 END) AS TOTAL_C
FROM
*LIBL.F4102 F4102,
*LIBL.F41021 F41021
WHERE
F4102.IBITM = F41021.LIITM
AND F4102.IBMCU = F41021.LIMCU
AND ( ( ( ( LIMCU = 'BR1'
AND LIPQOH > 0
AND IBGLPT = 'IN10'
AND LILOCN BETWEEN 'CA01A01' AND 'FH99Z99'))))
GROUP BY IBLITM
HAVING
SUM(CASE WHEN LILOCN LIKE 'C%' THEN 1 ELSE 0 END) >= 1 AND
SUM(CASE WHEN LILOCN LIKE 'F%' THEN 1 ELSE 0 END) >= 1
)
ORDER BY
1,
3
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi Geek,
I think that you're making this tougher than it has to be. If you add a sub-query that returns the part numbers with both 'C' and 'F' locations you'll have filtered out the chaff. Then just inner join that to the original query on the part number.
What version of DB2 for Series are you running? I'm just wondering if it supports the CTE syntax.
I don't know enough about your data (which tables the columns come from) to write the sub-query.
Kent
I think that you're making this tougher than it has to be. If you add a sub-query that returns the part numbers with both 'C' and 'F' locations you'll have filtered out the chaff. Then just inner join that to the original query on the part number.
What version of DB2 for Series are you running? I'm just wondering if it supports the CTE syntax.
I don't know enough about your data (which tables the columns come from) to write the sub-query.
Kent
Try the following script
Let me know if this works for you than we can try to modify it to fit your query
-------------------------------------------------------------------------------------------
SELECT
*
INTO
#TABLE
FROM
(
SELECT '33511127' AS PartNumber, 'BR1' AS C2, 'FG20B02' AS Shelf, '2387' AS C4, '288' AS C5, '0' AS C6
UNION
SELECT '33511141', 'BR1', 'FH03F01', '1610', '0', '0'
UNION
SELECT '33511142', 'BR1', 'CB05C01', '480', '0', '0'
UNION
SELECT '33511142', 'BR1', 'FCOFLOW', '768', '0', '0'
UNION
SELECT '33511143', 'BR1', 'CA11F01', '274', '0', '0'
UNION
SELECT '33511144', 'BR1', 'CA04C01', '46', '0', '0'
UNION
SELECT '33511144', 'BR1', 'FCOFLOW', '233', '0', '0'
UNION
SELECT '33511203', 'BR1', 'FC58D02', '192', '0', '0'
)a
-------------------------------------------------------------------------------------------
;WITH cteShelfCheck AS (
SELECT
PartNumber,
SUM(CASE WHEN UPPER(LEFT(Shelf,1)) = 'F' THEN 1 ELSE 0 END) AS ShelfWithF,
SUM(CASE WHEN UPPER(LEFT(Shelf,1)) = 'C' THEN 1 ELSE 0 END) AS ShelfWithC
FROM
#TABLE
GROUP BY
PartNumber
)
SELECT
t.*
FROM
cteShelfCheck c
INNER JOIN #TABLE t ON c.PartNumber = t.PartNumber
WHERE
c.ShelfWithC >= 1
AND c.ShelfWithF >= 1
-------------------------------------------------------------------------------------------
DROP TABLE #TABLE
Let me know if this works for you than we can try to modify it to fit your query
ASKER
Perfect!
Thank you!
Thank you!
ASKER
SELECT
IBLITM,
LIMCU,
LILOCN,
LIPQOH,
LIHCOM,
LIPBCK
FROM
*LIBL.F4102 F4102,
*LIBL.F41021 F41021
WHERE
F4102.IBITM = F41021.LIITM
AND F4102.IBMCU = F41021.LIMCU
AND ( ( ( ( LIMCU = 'BR1'
AND LIPQOH > 0
AND IBGLPT = 'IN10'
AND LILOCN BETWEEN 'CA01A01' AND 'FH99Z99'))))
ORDER BY
1,
3