Page 1 of 6, showing 50 records out of 286 total, starting on record 1, ending on 50
次回(第2047回)予想ナンバー
array(4) { ["degree"]=> int(2047) ["latest"]=> array(2) { ["numbers"]=> array(6) { [4]=> int(5) [5]=> int(21) [1]=> int(24) [3]=> int(29) [6]=> int(32) [2]=> int(37) } ["appearance"]=> array(3) { ["Appearance"]=> array(14) { ["id"]=> string(3) "265" ["target_degree"]=> string(4) "2046" ["parameter_id"]=> string(3) "265" ["pickup_id"]=> string(1) "1" ["json"]=> array(3) { ["totals"]=> array(7) { ["money"]=> int(32800) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(1) ["5_count"]=> int(26) ["match_count"]=> int(278) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } ["average_money"]=> string(3) "164" ["average_match_count"]=> string(4) "1.39" ["sample_count"]=> string(3) "200" ["average_1_count"]=> string(1) "0" ["average_2_count"]=> string(1) "0" ["average_3_count"]=> string(1) "0" ["created"]=> string(19) "2025-10-28 13:48:06" ["modified"]=> string(19) "2025-10-28 13:48:06" ["deleted"]=> bool(false) } ["Parameter"]=> array(2) { ["id"]=> string(3) "265" ["json"]=> array(4) { ["const"]=> int(0) ["base"]=> float(0.997) ["bonusRate"]=> int(0) ["count"]=> int(200) } } ["Pickup"]=> array(2) { ["id"]=> string(1) "1" ["json"]=> array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) } } } } ["pastAverageCount"]=> array(2) { ["numbers"]=> array(6) { [4]=> int(5) [5]=> int(21) [1]=> int(24) [3]=> int(29) [6]=> int(32) [2]=> int(37) } ["appearance"]=> array(3) { ["PastAppearance"]=> array(14) { ["id"]=> string(3) "265" ["target_degree"]=> string(4) "2046" ["parameter_id"]=> string(3) "265" ["pickup_id"]=> string(1) "1" ["json"]=> array(3) { ["totals"]=> array(7) { ["money"]=> int(32800) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(1) ["5_count"]=> int(26) ["match_count"]=> int(278) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } ["average_money"]=> string(3) "164" ["average_match_count"]=> string(4) "1.39" ["sample_count"]=> string(3) "200" ["average_1_count"]=> string(1) "0" ["average_2_count"]=> string(1) "0" ["average_3_count"]=> string(1) "0" ["created"]=> string(19) "2025-10-28 13:48:23" ["modified"]=> string(19) "2025-10-28 13:48:23" ["deleted"]=> bool(false) } ["Parameter"]=> array(2) { ["id"]=> string(3) "265" ["json"]=> array(4) { ["const"]=> int(0) ["base"]=> float(0.997) ["bonusRate"]=> int(0) ["count"]=> int(200) } } ["Pickup"]=> array(2) { ["id"]=> string(1) "1" ["json"]=> array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) } } } } ["pastAverageMoney"]=> array(2) { ["numbers"]=> array(6) { [1]=> int(2) [4]=> int(22) [16]=> int(24) [14]=> int(37) [5]=> int(38) [42]=> int(40) } ["appearance"]=> array(3) { ["PastAppearance"]=> array(14) { ["id"]=> string(4) "1718" ["target_degree"]=> string(4) "2040" ["parameter_id"]=> string(1) "1" ["pickup_id"]=> string(3) "175" ["json"]=> array(3) { ["totals"]=> array(7) { ["money"]=> int(400007000) ["1_count"]=> int(2) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(7) ["match_count"]=> int(173) } ["details"]=> array(2) { [0]=> array(5) { ["degree"]=> int(1950) ["prize"]=> int(1) ["match_numbers"]=> array(6) { [0]=> int(9) [1]=> int(20) [2]=> int(26) [3]=> int(28) [4]=> int(30) [5]=> int(42) } ["match_bonus_numbers"]=> array(0) { } ["other_info"]=> array(3) { ["targetNumbers"]=> array(6) { [0]=> string(1) "9" [1]=> string(2) "20" [2]=> string(2) "26" [3]=> string(2) "28" [4]=> string(2) "30" [5]=> string(2) "42" } ["expectNumbers"]=> array(6) { [14]=> int(9) [16]=> int(20) [4]=> int(26) [1]=> int(28) [42]=> int(30) [5]=> int(42) } ["expects"]=> array(43) { [28]=> float(22.402040048192) [1]=> float(19.874121305717) [6]=> float(16.779695601073) [26]=> float(16.341618228183) [42]=> float(15.730096771779) [31]=> float(14.057545479292) [39]=> float(9.644711305551) [21]=> float(7.348774880163) [14]=> float(7.327655727674) [33]=> float(3.999631899182) [15]=> float(3.681208679522) [7]=> float(3.446116007258) [32]=> float(3.338893220026) [9]=> float(2.103916654191) [16]=> float(1.982367501672) [20]=> float(1.058731550732) [5]=> float(-0.30567205364398) [35]=> float(-0.34032010360999) [12]=> float(-0.87176672058898) [34]=> float(-2.09522564151) [19]=> float(-2.115014057419) [4]=> float(-2.351518816296) [13]=> float(-5.497352690759) [11]=> float(-6.581049007308) [2]=> float(-7.014016650952) [37]=> float(-7.317735251725) [18]=> float(-7.482017720825) [22]=> float(-7.604992575677) [29]=> float(-7.713026776093) [40]=> float(-7.865237599053) [3]=> float(-8.030124847823) [43]=> float(-8.528243377489) [24]=> float(-8.593474039763) [25]=> float(-9.825414029312) [38]=> float(-12.628757035605) [17]=> float(-12.990261609426) [8]=> float(-15.165177686919) [23]=> float(-16.799047604791) [41]=> float(-19.721397391871) [36]=> float(-20.155552287044) [10]=> float(-21.43463347952) [30]=> float(-23.108571051098) [27]=> float(-25.227779736994) } } } [1]=> array(5) { ["degree"]=> int(1884) ["prize"]=> int(1) ["match_numbers"]=> array(6) { [0]=> int(20) [1]=> int(25) [2]=> int(29) [3]=> int(36) [4]=> int(38) [5]=> int(42) } ["match_bonus_numbers"]=> array(0) { } ["other_info"]=> array(3) { ["targetNumbers"]=> array(6) { [0]=> string(2) "20" [1]=> string(2) "25" [2]=> string(2) "29" [3]=> string(2) "36" [4]=> string(2) "38" [5]=> string(2) "42" } ["expectNumbers"]=> array(6) { [5]=> int(20) [14]=> int(25) [16]=> int(29) [42]=> int(36) [1]=> int(38) [4]=> int(42) } ["expects"]=> array(43) { [38]=> float(22.468521518643) [13]=> float(15.115066926848) [32]=> float(13.976013505694) [42]=> float(13.545126951547) [20]=> float(13.439092729993) [12]=> float(12.959263538484) [8]=> float(11.490862930716) [40]=> float(11.203419234095) [24]=> float(9.641169172717) [18]=> float(7.4494698402) [7]=> float(6.787629173266) [23]=> float(4.69107694398) [6]=> float(4.133606138842) [25]=> float(1.395721121438) [17]=> float(0.40914011655701) [29]=> float(0.37835809377001) [28]=> float(0.21615682437302) [34]=> float(0.065333237056016) [30]=> float(-0.068989849294993) [22]=> float(-0.09147706522098) [19]=> float(-1.551978109551) [41]=> float(-1.657601004824) [27]=> float(-2.355904771005) [10]=> float(-2.411013741062) [15]=> float(-4.333950502198) [39]=> float(-5.163731439964) [4]=> float(-5.512418812734) [3]=> float(-6.444218253222) [1]=> float(-7.020785600134) [5]=> float(-8.187764781405) [14]=> float(-9.351932153263) [43]=> float(-11.007356560883) [37]=> float(-13.34415435673) [16]=> float(-14.420459459031) [2]=> float(-15.389613630541) [35]=> float(-15.547718283747) [9]=> float(-16.930398371168) [26]=> float(-18.776555585177) [31]=> float(-20.072247879801) [11]=> float(-20.744878164071) [33]=> float(-21.676053550749) [36]=> float(-22.647842304107) [21]=> float(-22.902238751244) } } } } ["memos"]=> array(1) { [0]=> array(1) { ["01-04-05-14-16-42"]=> int(2) } } } ["average_money"]=> string(7) "2000040" ["average_match_count"]=> string(5) "0.865" ["sample_count"]=> string(3) "200" ["average_1_count"]=> string(4) "0.01" ["average_2_count"]=> string(1) "0" ["average_3_count"]=> string(1) "0" ["created"]=> string(19) "2025-10-28 13:49:50" ["modified"]=> string(19) "2025-10-28 13:49:50" ["deleted"]=> bool(false) } ["Parameter"]=> array(2) { ["id"]=> string(1) "1" ["json"]=> array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> int(0) ["count"]=> int(200) } } ["Pickup"]=> array(2) { ["id"]=> string(3) "175" ["json"]=> array(6) { [0]=> int(1) [1]=> int(4) [2]=> int(5) [3]=> int(14) [4]=> int(16) [5]=> int(42) } } } } }
ID 平均金額 平均一等回数 平均二等回数 平均三等回数 平均合致数 サンプル回数 json パラメーター ピックアップ
1 113 0 0 0 1.075 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(22600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(9) ["match_count"]=> int(215) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> int(0) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
2 113 0 0 0 1.075 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(22600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(9) ["match_count"]=> int(215) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.1) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
3 113 0 0 0 1.075 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(22600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(9) ["match_count"]=> int(215) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.2) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
4 113 0 0 0 1.075 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(22600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(9) ["match_count"]=> int(215) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.3) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
5 113 0 0 0 1.075 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(22600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(9) ["match_count"]=> int(215) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.4) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
6 113 0 0 0 1.075 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(22600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(9) ["match_count"]=> int(215) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.5) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
7 113 0 0 0 1.075 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(22600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(9) ["match_count"]=> int(215) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.6) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
8 113 0 0 0 1.075 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(22600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(9) ["match_count"]=> int(215) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.7) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
9 113 0 0 0 1.075 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(22600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(9) ["match_count"]=> int(215) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.8) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
10 113 0 0 0 1.075 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(22600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(9) ["match_count"]=> int(215) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.9) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
11 113 0 0 0 1.075 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(22600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(9) ["match_count"]=> int(215) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> int(1) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
12 108 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(21600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(8) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> int(0) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
13 108 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(21600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(8) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> float(0.1) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
14 108 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(21600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(8) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> float(0.2) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
15 108 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(21600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(8) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> float(0.3) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
16 108 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(21600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(8) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> float(0.4) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
17 108 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(21600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(8) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> float(0.5) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
18 108 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(21600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(8) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> float(0.6) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
19 108 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(21600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(8) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> float(0.7) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
20 108 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(21600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(8) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> float(0.8) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
21 108 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(21600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(8) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> float(0.9) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
22 108 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(21600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(2) ["5_count"]=> int(8) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> int(1) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
23 137 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(27400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(7) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.953) ["bonusRate"]=> int(0) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
24 137 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(27400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(7) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.953) ["bonusRate"]=> float(0.1) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
25 137 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(27400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(7) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.953) ["bonusRate"]=> float(0.2) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
26 137 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(27400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(7) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.953) ["bonusRate"]=> float(0.3) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
27 137 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(27400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(7) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.953) ["bonusRate"]=> float(0.4) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
28 137 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(27400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(7) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.953) ["bonusRate"]=> float(0.5) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
29 137 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(27400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(7) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.953) ["bonusRate"]=> float(0.6) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
30 137 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(27400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(7) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.953) ["bonusRate"]=> float(0.7) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
31 137 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(27400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(7) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.953) ["bonusRate"]=> float(0.8) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
32 137 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(27400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(7) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.953) ["bonusRate"]=> float(0.9) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
33 137 0 0 0 1.07 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(27400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(7) ["match_count"]=> int(214) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.953) ["bonusRate"]=> int(1) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
34 147 0 0 0 1.085 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(29400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(9) ["match_count"]=> int(217) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.955) ["bonusRate"]=> int(0) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
35 147 0 0 0 1.085 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(29400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(9) ["match_count"]=> int(217) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.955) ["bonusRate"]=> float(0.1) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
36 147 0 0 0 1.085 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(29400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(9) ["match_count"]=> int(217) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.955) ["bonusRate"]=> float(0.2) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
37 147 0 0 0 1.085 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(29400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(9) ["match_count"]=> int(217) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.955) ["bonusRate"]=> float(0.3) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
38 147 0 0 0 1.085 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(29400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(9) ["match_count"]=> int(217) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.955) ["bonusRate"]=> float(0.4) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
39 147 0 0 0 1.085 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(29400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(9) ["match_count"]=> int(217) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.955) ["bonusRate"]=> float(0.5) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
40 147 0 0 0 1.085 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(29400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(9) ["match_count"]=> int(217) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.955) ["bonusRate"]=> float(0.6) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
41 147 0 0 0 1.085 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(29400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(9) ["match_count"]=> int(217) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.955) ["bonusRate"]=> float(0.7) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
42 147 0 0 0 1.085 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(29400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(9) ["match_count"]=> int(217) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.955) ["bonusRate"]=> float(0.8) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
43 147 0 0 0 1.085 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(29400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(9) ["match_count"]=> int(217) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.955) ["bonusRate"]=> float(0.9) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
44 147 0 0 0 1.085 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(29400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(9) ["match_count"]=> int(217) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.955) ["bonusRate"]=> int(1) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
45 157 0 0 0 1.11 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(31400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(11) ["match_count"]=> int(222) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.957) ["bonusRate"]=> int(0) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
46 157 0 0 0 1.11 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(31400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(11) ["match_count"]=> int(222) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.957) ["bonusRate"]=> float(0.1) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
47 157 0 0 0 1.11 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(31400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(11) ["match_count"]=> int(222) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.957) ["bonusRate"]=> float(0.2) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
48 157 0 0 0 1.11 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(31400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(11) ["match_count"]=> int(222) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.957) ["bonusRate"]=> float(0.3) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
49 157 0 0 0 1.11 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(31400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(11) ["match_count"]=> int(222) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.957) ["bonusRate"]=> float(0.4) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
50 157 0 0 0 1.11 200 array(3) { ["totals"]=> array(7) { ["money"]=> int(31400) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(3) ["5_count"]=> int(11) ["match_count"]=> int(222) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } array(4) { ["const"]=> int(0) ["base"]=> float(0.957) ["bonusRate"]=> float(0.5) ["count"]=> int(200) } array(6) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) }
(default) 8 queries took 22 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Appearance`.`id`, `Appearance`.`target_degree`, `Appearance`.`parameter_id`, `Appearance`.`pickup_id`, `Appearance`.`json`, `Appearance`.`average_money`, `Appearance`.`average_match_count`, `Appearance`.`sample_count`, `Appearance`.`average_1_count`, `Appearance`.`average_2_count`, `Appearance`.`average_3_count`, `Appearance`.`created`, `Appearance`.`modified`, `Appearance`.`deleted`, `Parameter`.`id`, `Parameter`.`json`, `Pickup`.`id`, `Pickup`.`json` FROM `loto6`.`appearances` AS `Appearance` LEFT JOIN `loto6`.`parameters` AS `Parameter` ON (`Appearance`.`parameter_id` = `Parameter`.`id`) LEFT JOIN `loto6`.`pickups` AS `Pickup` ON (`Appearance`.`pickup_id` = `Pickup`.`id`) WHERE 1 = 1 ORDER BY `Appearance`.`id` ASC LIMIT 5050501
2SELECT COUNT(*) AS `count` FROM `loto6`.`appearances` AS `Appearance` LEFT JOIN `loto6`.`parameters` AS `Parameter` ON (`Appearance`.`parameter_id` = `Parameter`.`id`) LEFT JOIN `loto6`.`pickups` AS `Pickup` ON (`Appearance`.`pickup_id` = `Pickup`.`id`) WHERE 1 = 1111
3SELECT `Result`.`id`, `Result`.`degree`, `Result`.`result_date`, `Result`.`number_1`, `Result`.`number_2`, `Result`.`number_3`, `Result`.`number_4`, `Result`.`number_5`, `Result`.`number_6`, `Result`.`number_b` FROM `loto6`.`results` AS `Result` WHERE 1 = 1 ORDER BY `degree` DESC204720475
4SELECT `Appearance`.`id`, `Appearance`.`target_degree`, `Appearance`.`parameter_id`, `Appearance`.`pickup_id`, `Appearance`.`json`, `Appearance`.`average_money`, `Appearance`.`average_match_count`, `Appearance`.`sample_count`, `Appearance`.`average_1_count`, `Appearance`.`average_2_count`, `Appearance`.`average_3_count`, `Appearance`.`created`, `Appearance`.`modified`, `Appearance`.`deleted`, `Parameter`.`id`, `Parameter`.`json`, `Pickup`.`id`, `Pickup`.`json` FROM `loto6`.`appearances` AS `Appearance` LEFT JOIN `loto6`.`parameters` AS `Parameter` ON (`Appearance`.`parameter_id` = `Parameter`.`id`) LEFT JOIN `loto6`.`pickups` AS `Pickup` ON (`Appearance`.`pickup_id` = `Pickup`.`id`) WHERE 1 = 1 ORDER BY `Appearance`.`average_match_count` DESC, `Appearance`.`id` ASC LIMIT 1111
5SELECT `Result`.`id`, `Result`.`degree`, `Result`.`result_date`, `Result`.`number_1`, `Result`.`number_2`, `Result`.`number_3`, `Result`.`number_4`, `Result`.`number_5`, `Result`.`number_6`, `Result`.`number_b` FROM `loto6`.`results` AS `Result` WHERE 1 = 1 ORDER BY `degree` DESC204720475
6SELECT `PastAppearance`.`id`, `PastAppearance`.`target_degree`, `PastAppearance`.`parameter_id`, `PastAppearance`.`pickup_id`, `PastAppearance`.`json`, `PastAppearance`.`average_money`, `PastAppearance`.`average_match_count`, `PastAppearance`.`sample_count`, `PastAppearance`.`average_1_count`, `PastAppearance`.`average_2_count`, `PastAppearance`.`average_3_count`, `PastAppearance`.`created`, `PastAppearance`.`modified`, `PastAppearance`.`deleted`, `Parameter`.`id`, `Parameter`.`json`, `Pickup`.`id`, `Pickup`.`json` FROM `loto6`.`past_appearances` AS `PastAppearance` LEFT JOIN `loto6`.`parameters` AS `Parameter` ON (`PastAppearance`.`parameter_id` = `Parameter`.`id`) LEFT JOIN `loto6`.`pickups` AS `Pickup` ON (`PastAppearance`.`pickup_id` = `Pickup`.`id`) WHERE 1 = 1 ORDER BY `PastAppearance`.`average_match_count` DESC, `PastAppearance`.`id` ASC LIMIT 1112
7SELECT `Result`.`id`, `Result`.`degree`, `Result`.`result_date`, `Result`.`number_1`, `Result`.`number_2`, `Result`.`number_3`, `Result`.`number_4`, `Result`.`number_5`, `Result`.`number_6`, `Result`.`number_b` FROM `loto6`.`results` AS `Result` WHERE 1 = 1 ORDER BY `degree` DESC204720475
8SELECT `PastAppearance`.`id`, `PastAppearance`.`target_degree`, `PastAppearance`.`parameter_id`, `PastAppearance`.`pickup_id`, `PastAppearance`.`json`, `PastAppearance`.`average_money`, `PastAppearance`.`average_match_count`, `PastAppearance`.`sample_count`, `PastAppearance`.`average_1_count`, `PastAppearance`.`average_2_count`, `PastAppearance`.`average_3_count`, `PastAppearance`.`created`, `PastAppearance`.`modified`, `PastAppearance`.`deleted`, `Parameter`.`id`, `Parameter`.`json`, `Pickup`.`id`, `Pickup`.`json` FROM `loto6`.`past_appearances` AS `PastAppearance` LEFT JOIN `loto6`.`parameters` AS `Parameter` ON (`PastAppearance`.`parameter_id` = `Parameter`.`id`) LEFT JOIN `loto6`.`pickups` AS `Pickup` ON (`PastAppearance`.`pickup_id` = `Pickup`.`id`) WHERE 1 = 1 ORDER BY `PastAppearance`.`average_money` * `PastAppearance`.`average_match_count` DESC, `PastAppearance`.`id` ASC LIMIT 1112