Loto 7: Publics

Notice (8): Undefined index: numbers [APP/Controller/Component/CalcComponent.php, line 202]

            ),
            'pastAverageCount' => array(
                'numbers' => $pastExpectNumbers['numbers'],

$expectNumbers = array(
	'numbers' => array(
		(int) 4 => (int) 6,
		(int) 5 => (int) 8,
		(int) 7 => (int) 15,
		(int) 2 => (int) 17,
		(int) 3 => (int) 18,
		(int) 6 => (int) 19,
		(int) 1 => (int) 22
	),
	'appearance' => array(
		'Appearance' => array(
			'id' => '1',
			'target_degree' => '679',
			'parameter_id' => '1',
			'pickup_id' => '1',
			'json' => array(
				[maximum depth reached]
			),
			'average_money' => '166',
			'average_match_count' => '1.84',
			'sample_count' => '100',
			'average_1_count' => '0',
			'average_2_count' => '0',
			'average_3_count' => '0',
			'created' => '2026-05-31 10:13:00',
			'modified' => '2026-05-31 10:13:00',
			'deleted' => false
		),
		'Parameter' => array(
			'id' => '1',
			'json' => array(
				[maximum depth reached]
			)
		),
		'Pickup' => array(
			'id' => '1',
			'json' => array(
				[maximum depth reached]
			)
		)
	)
)
$pastExpectNumbers = array()
$pastMoneyExpectNumbers = array()
$nextDegree = (int) 680

CalcComponent::getExpectNumbersByApperancesLatestAndPast() - APP/Controller/Component/CalcComponent.php, line 202
PublicsController::showAppearanceList() - APP/Controller/PublicsController.php, line 125
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Notice (8): Undefined index: appearance [APP/Controller/Component/CalcComponent.php, line 203]

Code Context

            'pastAverageCount' => array(
                'numbers' => $pastExpectNumbers['numbers'],
                'appearance' => $pastExpectNumbers['appearance'],

$expectNumbers = array(
	'numbers' => array(
		(int) 4 => (int) 6,
		(int) 5 => (int) 8,
		(int) 7 => (int) 15,
		(int) 2 => (int) 17,
		(int) 3 => (int) 18,
		(int) 6 => (int) 19,
		(int) 1 => (int) 22
	),
	'appearance' => array(
		'Appearance' => array(
			'id' => '1',
			'target_degree' => '679',
			'parameter_id' => '1',
			'pickup_id' => '1',
			'json' => array(
				[maximum depth reached]
			),
			'average_money' => '166',
			'average_match_count' => '1.84',
			'sample_count' => '100',
			'average_1_count' => '0',
			'average_2_count' => '0',
			'average_3_count' => '0',
			'created' => '2026-05-31 10:13:00',
			'modified' => '2026-05-31 10:13:00',
			'deleted' => false
		),
		'Parameter' => array(
			'id' => '1',
			'json' => array(
				[maximum depth reached]
			)
		),
		'Pickup' => array(
			'id' => '1',
			'json' => array(
				[maximum depth reached]
			)
		)
	)
)
$pastExpectNumbers = array()
$pastMoneyExpectNumbers = array()
$nextDegree = (int) 680

CalcComponent::getExpectNumbersByApperancesLatestAndPast() - APP/Controller/Component/CalcComponent.php, line 203
PublicsController::showAppearanceList() - APP/Controller/PublicsController.php, line 125
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Notice (8): Undefined index: numbers [APP/Controller/Component/CalcComponent.php, line 206]

Code Context

            ),
            'pastAverageMoney' => array(
                'numbers' => $pastMoneyExpectNumbers['numbers'],

$expectNumbers = array(
	'numbers' => array(
		(int) 4 => (int) 6,
		(int) 5 => (int) 8,
		(int) 7 => (int) 15,
		(int) 2 => (int) 17,
		(int) 3 => (int) 18,
		(int) 6 => (int) 19,
		(int) 1 => (int) 22
	),
	'appearance' => array(
		'Appearance' => array(
			'id' => '1',
			'target_degree' => '679',
			'parameter_id' => '1',
			'pickup_id' => '1',
			'json' => array(
				[maximum depth reached]
			),
			'average_money' => '166',
			'average_match_count' => '1.84',
			'sample_count' => '100',
			'average_1_count' => '0',
			'average_2_count' => '0',
			'average_3_count' => '0',
			'created' => '2026-05-31 10:13:00',
			'modified' => '2026-05-31 10:13:00',
			'deleted' => false
		),
		'Parameter' => array(
			'id' => '1',
			'json' => array(
				[maximum depth reached]
			)
		),
		'Pickup' => array(
			'id' => '1',
			'json' => array(
				[maximum depth reached]
			)
		)
	)
)
$pastExpectNumbers = array()
$pastMoneyExpectNumbers = array()
$nextDegree = (int) 680

CalcComponent::getExpectNumbersByApperancesLatestAndPast() - APP/Controller/Component/CalcComponent.php, line 206
PublicsController::showAppearanceList() - APP/Controller/PublicsController.php, line 125
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Notice (8): Undefined index: appearance [APP/Controller/Component/CalcComponent.php, line 207]

Code Context

            'pastAverageMoney' => array(
                'numbers' => $pastMoneyExpectNumbers['numbers'],
                'appearance' => $pastMoneyExpectNumbers['appearance'],

$expectNumbers = array(
	'numbers' => array(
		(int) 4 => (int) 6,
		(int) 5 => (int) 8,
		(int) 7 => (int) 15,
		(int) 2 => (int) 17,
		(int) 3 => (int) 18,
		(int) 6 => (int) 19,
		(int) 1 => (int) 22
	),
	'appearance' => array(
		'Appearance' => array(
			'id' => '1',
			'target_degree' => '679',
			'parameter_id' => '1',
			'pickup_id' => '1',
			'json' => array(
				[maximum depth reached]
			),
			'average_money' => '166',
			'average_match_count' => '1.84',
			'sample_count' => '100',
			'average_1_count' => '0',
			'average_2_count' => '0',
			'average_3_count' => '0',
			'created' => '2026-05-31 10:13:00',
			'modified' => '2026-05-31 10:13:00',
			'deleted' => false
		),
		'Parameter' => array(
			'id' => '1',
			'json' => array(
				[maximum depth reached]
			)
		),
		'Pickup' => array(
			'id' => '1',
			'json' => array(
				[maximum depth reached]
			)
		)
	)
)
$pastExpectNumbers = array()
$pastMoneyExpectNumbers = array()
$nextDegree = (int) 680

CalcComponent::getExpectNumbersByApperancesLatestAndPast() - APP/Controller/Component/CalcComponent.php, line 207
PublicsController::showAppearanceList() - APP/Controller/PublicsController.php, line 125
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Page 1 of 1, showing 9 records out of 9 total, starting on record 1, ending on 9

import

remake

calcAp

mailAp

次回（第680回）予想ナンバー

array(4) { ["degree"]=> int(680) ["latest"]=> array(2) { ["numbers"]=> array(7) { [4]=> int(6) [5]=> int(8) [7]=> int(15) [2]=> int(17) [3]=> int(18) [6]=> int(19) [1]=> int(22) } ["appearance"]=> array(3) { ["Appearance"]=> array(14) { ["id"]=> string(1) "1" ["target_degree"]=> string(3) "679" ["parameter_id"]=> string(1) "1" ["pickup_id"]=> string(1) "1" ["json"]=> array(3) { ["totals"]=> array(8) { ["money"]=> int(16600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(1) ["5_count"]=> int(5) ["6_count"]=> int(0) ["match_count"]=> int(184) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } ["average_money"]=> string(3) "166" ["average_match_count"]=> string(4) "1.84" ["sample_count"]=> string(3) "100" ["average_1_count"]=> string(1) "0" ["average_2_count"]=> string(1) "0" ["average_3_count"]=> string(1) "0" ["created"]=> string(19) "2026-05-31 10:13:00" ["modified"]=> string(19) "2026-05-31 10:13:00" ["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(100) } } ["Pickup"]=> array(2) { ["id"]=> string(1) "1" ["json"]=> array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) } } } } ["pastAverageCount"]=> array(2) { ["numbers"]=> NULL ["appearance"]=> NULL } ["pastAverageMoney"]=> array(2) { ["numbers"]=> NULL ["appearance"]=> NULL } }

ID	平均金額	平均合致数	サンプル回数	json	パラメーター	ピックアップ
1	166	1.84	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(16600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(1) ["5_count"]=> int(5) ["6_count"]=> int(0) ["match_count"]=> int(184) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> int(0) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
2	166	1.84	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(16600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(1) ["5_count"]=> int(5) ["6_count"]=> int(0) ["match_count"]=> int(184) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.1) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
3	166	1.84	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(16600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(1) ["5_count"]=> int(5) ["6_count"]=> int(0) ["match_count"]=> int(184) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.2) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
4	166	1.84	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(16600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(1) ["5_count"]=> int(5) ["6_count"]=> int(0) ["match_count"]=> int(184) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.3) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
5	166	1.84	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(16600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(1) ["5_count"]=> int(5) ["6_count"]=> int(0) ["match_count"]=> int(184) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.4) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
6	166	1.84	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(16600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(1) ["5_count"]=> int(5) ["6_count"]=> int(0) ["match_count"]=> int(184) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.5) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
7	166	1.84	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(16600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(1) ["5_count"]=> int(5) ["6_count"]=> int(0) ["match_count"]=> int(184) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.6) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
8	166	1.84	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(16600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(1) ["5_count"]=> int(5) ["6_count"]=> int(0) ["match_count"]=> int(184) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.7) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
9	166	1.84	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(16600) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(1) ["5_count"]=> int(5) ["6_count"]=> int(0) ["match_count"]=> int(184) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.8) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }

(default) 7 queries took 7 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `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 `loto7`.`appearances` AS `Appearance` LEFT JOIN `loto7`.`parameters` AS `Parameter` ON (`Appearance`.`parameter_id` = `Parameter`.`id`) LEFT JOIN `loto7`.`pickups` AS `Pickup` ON (`Appearance`.`pickup_id` = `Pickup`.`id`) WHERE 1 = 1 ORDER BY `Appearance`.`id` ASC LIMIT 50	9	9	1
2	SELECT `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_7`, `Result`.`number_b1`, `Result`.`number_b2` FROM `loto7`.`results` AS `Result` WHERE 1 = 1 ORDER BY `degree` DESC	680	680	2
3	SELECT `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 `loto7`.`appearances` AS `Appearance` LEFT JOIN `loto7`.`parameters` AS `Parameter` ON (`Appearance`.`parameter_id` = `Parameter`.`id`) LEFT JOIN `loto7`.`pickups` AS `Pickup` ON (`Appearance`.`pickup_id` = `Pickup`.`id`) WHERE 1 = 1 ORDER BY `Appearance`.`average_match_count` DESC, `Appearance`.`id` ASC LIMIT 1	1	1	0
4	SELECT `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_7`, `Result`.`number_b1`, `Result`.`number_b2` FROM `loto7`.`results` AS `Result` WHERE 1 = 1 ORDER BY `degree` DESC	680	680	2
5	SELECT `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 `loto7`.`past_appearances` AS `PastAppearance` LEFT JOIN `loto7`.`parameters` AS `Parameter` ON (`PastAppearance`.`parameter_id` = `Parameter`.`id`) LEFT JOIN `loto7`.`pickups` AS `Pickup` ON (`PastAppearance`.`pickup_id` = `Pickup`.`id`) WHERE 1 = 1 ORDER BY `PastAppearance`.`average_match_count` DESC, `PastAppearance`.`id` ASC LIMIT 1	0	0	0
6	SELECT `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_7`, `Result`.`number_b1`, `Result`.`number_b2` FROM `loto7`.`results` AS `Result` WHERE 1 = 1 ORDER BY `degree` DESC	680	680	2
7	SELECT `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 `loto7`.`past_appearances` AS `PastAppearance` LEFT JOIN `loto7`.`parameters` AS `Parameter` ON (`PastAppearance`.`parameter_id` = `Parameter`.`id`) LEFT JOIN `loto7`.`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 1	0	0	0

(default) 7 queries took 7 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `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 `loto7`.`appearances` AS `Appearance` LEFT JOIN `loto7`.`parameters` AS `Parameter` ON (`Appearance`.`parameter_id` = `Parameter`.`id`) LEFT JOIN `loto7`.`pickups` AS `Pickup` ON (`Appearance`.`pickup_id` = `Pickup`.`id`) WHERE 1 = 1 ORDER BY `Appearance`.`id` ASC LIMIT 50

SELECT `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_7`, `Result`.`number_b1`, `Result`.`number_b2` FROM `loto7`.`results` AS `Result` WHERE 1 = 1 ORDER BY `degree` DESC

680

SELECT `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 `loto7`.`past_appearances` AS `PastAppearance` LEFT JOIN `loto7`.`parameters` AS `Parameter` ON (`PastAppearance`.`parameter_id` = `Parameter`.`id`) LEFT JOIN `loto7`.`pickups` AS `Pickup` ON (`PastAppearance`.`pickup_id` = `Pickup`.`id`) WHERE 1 = 1 ORDER BY `PastAppearance`.`average_match_count` DESC, `PastAppearance`.`id` ASC LIMIT 1

680

SELECT `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 `loto7`.`past_appearances` AS `PastAppearance` LEFT JOIN `loto7`.`parameters` AS `Parameter` ON (`PastAppearance`.`parameter_id` = `Parameter`.`id`) LEFT JOIN `loto7`.`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 1