SELECT b.*, l.OLNAM FROM ota_bill b INNER JOIN ota_lead l ON b.OLID = l.OLID
| 21051 |
0 |
Kong Wei Hao |
0 |
0.00 |
|
|
| 21053 |
1,2,3 |
Kong Wei Hao |
88 |
8.00 |
|
|
| 21054 |
4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22 |
Kong Wei Hao |
693 |
63.00 |
|
|
| 21055 |
31,34,38,28,36,25,39,26,33,27,23,37,24,32,29,30,35 |
Kong Wei Hao |
671 |
61.00 |
|
|
| 21056 |
44,50,54,58,59,47,49,55,48,41,42,57,51,43,53,46,40,45,56,52 |
Kong Wei Hao |
726 |
66.00 |
|
|
| 21057 |
66,72,74,64,69,60,71,63,73,65,67,61,62,75,70,68 |
Kong Wei Hao |
676.5 |
61.50 |
|
|
| 21058 |
83,86,90,92,79,89,78,80,82,81,85,84,87,76,77,88,91 |
Kong Wei Hao |
737 |
67.00 |
|
|
| 21059 |
99,104,107,96,102,97,101,103,93,94,105,106,95,98,100 |
Kong Wei Hao |
605 |
55.00 |
|
|
| 21060 |
115,121,108,109,113,110,112,118,114,111,120,116,117,119 |
Kong Wei Hao |
583 |
53.00 |
|
|
| 21061 |
126,131,134,123,125,127,133,128,124,130,122,129,135,132 |
Kong Wei Hao |
506 |
46.00 |
|
|
| 21062 |
136,146,152,156,144,150,140,143,153,142,138,139,151,147,137,145,154,149,141,155,148,157 |
Kong Wei Hao |
825 |
75.00 |
|
|
| 21063 |
159,163,168,173,169,167,165,166,164,160,170,158,161,171,162,172 |
Kong Wei Hao |
649 |
59.00 |
|
|
| 21064 |
178,182,186,189,193,176,175,187,183,179,191,188,174,181,184,180,192,177,185,190 |
Kong Wei Hao |
825 |
75.00 |
|
|
| 21065 |
196,199,209,212,200,194,206,201,208,207,211,204,197,213,195,203,205,198,202,210 |
Kong Wei Hao |
924 |
84.00 |
|
|
| 21066 |
215,221,228,235,236,225,214,217,218,232,231,227,229,222,226,220,233,216,224,230,234,219,223 |
Kong Wei Hao |
1045 |
95.00 |
|
|
| 21067 |
243,250,253,249,237,244,240,251,238,242,245,252,248,239,247,241,246 |
Kong Wei Hao |
726 |
66.00 |
|
|
| 21068 |
254,258,261,266,263,255,262,259,257,260,256,267,265,264 |
Kong Wei Hao |
605 |
55.00 |
|
|
| 21069 |
272,270,273,279,285,282,269,271,274,275,278,268,276,281,280,286,284,283,277 |
Kong Wei Hao |
748 |
68.00 |
|
|
| 21070 |
288,292,295,297,296,287,291,294,293,299,289,298,290 |
Kong Wei Hao |
528 |
48.00 |
|
|
| 21071 |
308,311,310,300,309,306,302,303,312,301,314,304,307,313,305 |
Kong Wei Hao |
649 |
59.00 |
|
|
| 21072 |
318,325,328,330,326,317,323,322,315,316,321,327,319,324,329,320 |
Kong Wei Hao |
704 |
64.00 |
|
|
| 21073 |
339,341,342,331,334,338,335,333,336,343,332,337,340 |
Kong Wei Hao |
583 |
53.00 |
|
|
| 21074 |
348,358,347,359,349,345,355,344,350,354,346,352,351,353,356,357 |
Kong Wei Hao |
803 |
73.00 |
|
|
| 21075 |
364,362,373,370,361,363,366,372,360,371,367,368,369,365,374 |
Kong Wei Hao |
770 |
70.00 |
|
|
| 21076 |
379,378,387,383,386,377,381,388,376,382,380,390,375,384,385,389 |
Kong Wei Hao |
825 |
75.00 |
|
|
| 21077 |
397,395,404,398,394,396,402,391,399,393,392,401,400,403 |
Kong Wei Hao |
836 |
76.00 |
|
|
| 21078 |
410,405,415,411,407,414,419,406,408,412,409,417,413,420,416,418 |
Kong Wei Hao |
737 |
67.00 |
|
|
| 21079 |
429,422,427,426,421,425,432,423,424,434,428,431,430,433 |
Kong Wei Hao |
797.5 |
72.50 |
|
|
| 21080 |
439,445,435,448,438,440,442,436,437,441,447,446,449,450,443,451,444,452 |
Kong Wei Hao |
962.5 |
87.50 |
|
|
| 21081 |
471,453,467,458,463,459,460,461,457,455,469,454,456,462,465,464,468,466,470 |
Kong Wei Hao |
1149.5 |
104.50 |
|
|
| 21082 |
491,472,483,479,480,475,476,486,477,485,474,481,482,487,473,489,490,492,478,488,484 |
Kong Wei Hao |
1221 |
111.00 |
|
|
| 21083 |
494,507,501,495,510,497,509,496,504,493,506,502,505,498,499,500,503,511,508,512 |
Kong Wei Hao |
1039.5 |
94.50 |
|
|
| 21084 |
515,514,527,517,518,520,521,513,528,526,516,519,524,530,523,522,529,525 |
Kong Wei Hao |
913 |
83.00 |
|
|
| 21085 |
551,531,543,537,552,539,540,532,538,542,534,548,546,535,536,533,547,550,541,549,544,545 |
Kong Wei Hao |
1138.5 |
103.50 |
|
|
| 21086 |
568,554,557,558,565,564,563,566,561,569,553,556,555,560,559,562,567 |
Kong Wei Hao |
1045 |
95.00 |
|
|
| 21087 |
583,572,580,574,581,577,579,578,576,575,571,573,570,584,585,582 |
Kong Wei Hao |
885.5 |
80.50 |
|
|
| 21088 |
587,598,593,600,589,596,592,599,588,594,591,586,590,597,595,603,601,602 |
Kong Wei Hao |
858 |
78.00 |
|
|
| 21089 |
608,606,615,613,605,618,619,604,612,609,607,614,611,610,617,616 |
Kong Wei Hao |
946 |
86.00 |
|
|
| 21090 |
626,621,635,632,624,631,639,625,634,620,633,630,622,636,627,623,628,629,638,637 |
Kong Wei Hao |
1199 |
109.00 |
|
|
| 21091 |
644,640,648,650,656,649,641,647,643,645,655,642,651,646,654,652,653 |
Kong Wei Hao |
1023 |
93.00 |
|
|
| 21092 |
660,657,668,669,664,663,658,665,659,661,670,662,667,666 |
Kong Wei Hao |
858 |
78.00 |
|
|
| 21093 |
680,672,681,678,677,673,671,679,675,674,684,676,683,682 |
Kong Wei Hao |
913 |
83.00 |
|
|
| 21094 |
685,694,689,690,691,686,693,688,687,696,692,697,695 |
Kong Wei Hao |
792 |
72.00 |
|
|
| 21095 |
712,698,705,707,704,711,703,700,706,702,699,701,714,708,713,710,709 |
Kong Wei Hao |
918.5 |
83.50 |
|
|
| 21096 |
715,723,719,721,722,716,720,717,718,726,724,725 |
Kong Wei Hao |
660 |
60.00 |
|
|
| 21097 |
740,727,738,735,734,728,729,730,733,739,731,732,737,736 |
Kong Wei Hao |
737 |
67.00 |
|
|
| 21098 |
742,753,746,748,743,745,741,749,747,744,750,752,751 |
Kong Wei Hao |
660 |
60.00 |
|
|
| 21099 |
756,754,765,761,755,760,763,764,762,759,757,758,767,766 |
Kong Wei Hao |
770 |
70.00 |
|
|
| 21100 |
774,768,779,776,771,769,775,785,780,781,773,786,770,772,777,784,778,782,783 |
Kong Wei Hao |
891 |
81.00 |
|
|
| 21101 |
789,787,796,793,798,799,800,791,792,794,790,788,795,797 |
Kong Wei Hao |
759 |
69.00 |
|
|
| 21102 |
806,801,812,802,807,814,809,815,808,803,810,805,813,811,804 |
Kong Wei Hao |
715 |
65.00 |
|
|
| 21103 |
818,824,819,825,826,822,816,823,821,817,820,828,827,829 |
Kong Wei Hao |
627 |
57.00 |
|
|
| 21104 |
846,831,837,844,834,845,832,841,830,842,835,833,840,838,843,836,839 |
Kong Wei Hao |
770 |
70.00 |
|
|
| 21105 |
854,863,849,852,855,847,857,850,853,856,862,858,859,860,861,848,851 |
Kong Wei Hao |
737 |
67.00 |
|
|
| 21106 |
866,865,870,873,867,878,864,872,871,882,868,880,876,883,869,877,874,885,875,879,881,884 |
Kong Wei Hao |
984.5 |
89.50 |
|
|
| 21107 |
901,914,899,907,890,887,900,924,898,913,920,905,916,923,886,897,910,891,909,922,921,893,903,915,918,912,906,896,888,889,892,894,895,902,904,908,911,917,919 |
Kong Wei Hao |
1661 |
151.00 |
|
|
| 21108 |
937,941,927,936,929,933,928,931,930,926,934,932,938,935,939,925,940 |
Kong Wei Hao |
907.5 |
82.50 |
|
|
| 21109 |
937,947,945,948,941,927,944,946,950,936,951,929,933,928,949,931,930,926,934,932,938,935,939,925,942,940,943 |
Kong Wei Hao |
1369.5 |
124.50 |
|
|
