*************************** 1. row *************************** QUERY: SELECT extradata, pagename, date, icon, icondark, shortname, tournament, series, opponentname, opponenttemplate, opponentplayers, opponenttype FROM `wikifortnite_lpdb_placement` `lpdb_placement` WHERE ((`date` != '0000-01-01 00:00:00.000000' AND month(date) = '8' AND day(date) = '12' AND year(date) < '2026' AND `placement` = '1' AND `opponentname` != 'TBD' AND `prizepoolindex` = '1' AND (`liquipediatier` = '1' OR `liquipediatier` = '2') AND `liquipediatiertype` != 'Qualifier')) AND `namespace` = 0 ORDER BY date ASC, pagename ASC LIMIT 10000 TRACE: { "steps": [ { "join_preparation": { "select_id": 1, "steps": [ { "expanded_query": "select lpdb_placement.extradata AS extradata,lpdb_placement.pagename AS pagename,lpdb_placement.`date` AS `date`,lpdb_placement.icon AS icon,lpdb_placement.icondark AS icondark,lpdb_placement.shortname AS shortname,lpdb_placement.tournament AS tournament,lpdb_placement.series AS series,lpdb_placement.opponentname AS opponentname,lpdb_placement.opponenttemplate AS opponenttemplate,lpdb_placement.opponentplayers AS opponentplayers,lpdb_placement.opponenttype AS opponenttype from wikifortnite_lpdb_placement lpdb_placement where lpdb_placement.`date` <> '0000-01-01 00:00:00.000000' and month(lpdb_placement.`date`) = '8' and dayofmonth(lpdb_placement.`date`) = '12' and year(lpdb_placement.`date`) < '2026' and lpdb_placement.placement = '1' and lpdb_placement.opponentname <> 'TBD' and lpdb_placement.prizepoolindex = '1' and (lpdb_placement.liquipediatier = '1' or lpdb_placement.liquipediatier = '2') and lpdb_placement.liquipediatiertype <> 'Qualifier' and lpdb_placement.namespace = 0 order by lpdb_placement.`date`,lpdb_placement.pagename limit 10000" } ] } }, { "join_optimization": { "select_id": 1, "steps": [ { "condition_processing": { "condition": "WHERE", "original_condition": "lpdb_placement.`date` <> '0000-01-01 00:00:00.000000' and month(lpdb_placement.`date`) = '8' and dayofmonth(lpdb_placement.`date`) = '12' and year(lpdb_placement.`date`) < '2026' and lpdb_placement.placement = '1' and lpdb_placement.opponentname <> 'TBD' and lpdb_placement.prizepoolindex = '1' and (lpdb_placement.liquipediatier = '1' or lpdb_placement.liquipediatier = '2') and lpdb_placement.liquipediatiertype <> 'Qualifier' and lpdb_placement.namespace = 0", "steps": [ { "transformation": "equality_propagation", "resulting_condition": "lpdb_placement.`date` <> '0000-01-01 00:00:00.000000' and month(lpdb_placement.`date`) = '8' and dayofmonth(lpdb_placement.`date`) = '12' and year(lpdb_placement.`date`) < '2026' and lpdb_placement.opponentname <> 'TBD' and lpdb_placement.prizepoolindex = '1' and (multiple equal('1', lpdb_placement.liquipediatier) or multiple equal('2', lpdb_placement.liquipediatier)) and lpdb_placement.liquipediatiertype <> 'Qualifier' and multiple equal('1', lpdb_placement.placement) and multiple equal(0, lpdb_placement.namespace)" }, { "transformation": "constant_propagation", "resulting_condition": "lpdb_placement.`date` <> '0000-01-01 00:00:00.000000' and month(lpdb_placement.`date`) = '8' and dayofmonth(lpdb_placement.`date`) = '12' and year(lpdb_placement.`date`) < '2026' and lpdb_placement.opponentname <> 'TBD' and lpdb_placement.prizepoolindex = '1' and (multiple equal('1', lpdb_placement.liquipediatier) or multiple equal('2', lpdb_placement.liquipediatier)) and lpdb_placement.liquipediatiertype <> 'Qualifier' and multiple equal('1', lpdb_placement.placement) and multiple equal(0, lpdb_placement.namespace)" }, { "transformation": "trivial_condition_removal", "resulting_condition": "lpdb_placement.`date` <> '0000-01-01 00:00:00.000000' and month(lpdb_placement.`date`) = '8' and dayofmonth(lpdb_placement.`date`) = '12' and year(lpdb_placement.`date`) < '2026' and lpdb_placement.opponentname <> 'TBD' and lpdb_placement.prizepoolindex = '1' and (multiple equal('1', lpdb_placement.liquipediatier) or multiple equal('2', lpdb_placement.liquipediatier)) and lpdb_placement.liquipediatiertype <> 'Qualifier' and multiple equal('1', lpdb_placement.placement) and multiple equal(0, lpdb_placement.namespace)" } ] } }, { "table_dependencies": [ { "table": "lpdb_placement", "row_may_be_null": false, "map_bit": 0, "depends_on_map_bits": [] } ] }, { "ref_optimizer_key_uses": [ { "table": "lpdb_placement", "index": "namespace", "field": "namespace", "equals": "0", "null_rejecting": false } ] }, { "rows_estimation": [ { "table": "lpdb_placement", "range_analysis": { "table_scan": { "rows": 447115, "cost": 100.4972206 }, "potential_range_indexes": [ { "index": "objectname", "usable": false, "cause": "not applicable" }, { "index": "pageid", "usable": false, "cause": "not applicable" }, { "index": "pagename", "usable": false, "cause": "not applicable" }, { "index": "namespace", "usable": true, "key_parts": ["namespace", "objectname"] }, { "index": "participant", "usable": false, "cause": "not applicable" }, { "index": "parent", "usable": false, "cause": "not applicable" }, { "index": "opponentname", "usable": true, "key_parts": ["opponentname", "objectname"] }, { "index": "opponenttemplate", "usable": false, "cause": "not applicable" }, { "index": "opponenttype", "usable": false, "cause": "not applicable" } ], "setup_range_conditions": [], "analyzing_range_alternatives": { "range_scan_alternatives": [ { "index": "namespace", "ranges": ["(0) <= (namespace) <= (0)"], "rowid_ordered": true, "using_mrr": false, "index_only": false, "rows": 435675, "cost": 467.0335666, "chosen": false, "cause": "cost" }, { "index": "opponentname", "ranges": [ "(opponentname) < (TBD)", "(TBD) < (opponentname)" ], "rowid_ordered": false, "using_mrr": false, "index_only": false, "rows": 435675, "cost": 475.0439022, "chosen": false, "cause": "cost" } ], "analyzing_roworder_intersect": { "cause": "too few roworder scans" }, "analyzing_index_merge_union": [] }, "group_index_range": { "chosen": false, "cause": "no group by or distinct" } } }, { "selectivity_for_indexes": [ { "index_name": "namespace", "selectivity_from_index": 0.974413741 }, { "index_name": "opponentname", "selectivity_from_index": 0.974413741 } ], "selectivity_for_columns": [ { "column_name": "date", "ranges": [ "date < 0000-01-01 00:00:00", "0000-01-01 00:00:00 < date" ], "selectivity_from_histogram": 0.95446138 }, { "column_name": "placement", "ranges": ["1 <= placement <= 1"], "selectivity_from_histogram": 0.039712378 }, { "column_name": "prizepoolindex", "ranges": ["1 <= prizepoolindex <= 1"], "selectivity_from_histogram": 0.96873064 }, { "column_name": "liquipediatier", "ranges": [ "1 <= liquipediatier <= 1", "2 <= liquipediatier <= 2" ], "selectivity_from_histogram": 0.368108875 }, { "column_name": "liquipediatiertype", "ranges": [ "liquipediatiertype < Qualifier", "Qualifier < liquipediatiertype" ], "selectivity_from_histogram": 0.91979692 } ], "cond_selectivity": 0.011804357 } ] }, { "considered_execution_plans": [ { "plan_prefix": "", "get_costs_for_tables": [ { "best_access_path": { "table": "lpdb_placement", "plan_details": { "record_count": 1 }, "considered_access_paths": [ { "access_type": "ref", "index": "namespace", "used_range_estimates": true, "rows": 435675, "cost": 467.0327755, "chosen": true }, { "access_type": "scan", "rows": 447115, "rows_after_filter": 5277.905006, "rows_out": 5277.905006, "cost": 100.4972206, "index_only": false, "chosen": true, "use_tmp_table": true } ], "chosen_access_method": { "type": "scan", "rows_read": 5277.905006, "rows_out": 5277.905006, "cost": 100.4972206, "uses_join_buffering": false } } } ] }, { "plan_prefix": "", "table": "lpdb_placement", "rows_for_plan": 5277.905006, "cost_for_plan": 100.4972206, "cost_for_sorting": 3.488276893 } ] }, { "best_join_order": ["lpdb_placement"], "rows": 5277.905006, "cost": 103.9854975 }, { "substitute_best_equal": { "condition": "WHERE", "resulting_condition": "lpdb_placement.placement = '1' and lpdb_placement.namespace = 0 and lpdb_placement.`date` <> '0000-01-01 00:00:00.000000' and month(lpdb_placement.`date`) = '8' and dayofmonth(lpdb_placement.`date`) = '12' and year(lpdb_placement.`date`) < '2026' and lpdb_placement.opponentname <> 'TBD' and lpdb_placement.prizepoolindex = '1' and (lpdb_placement.liquipediatier = '1' or lpdb_placement.liquipediatier = '2') and lpdb_placement.liquipediatiertype <> 'Qualifier'" } }, { "attaching_conditions_to_tables": { "attached_conditions_computation": [], "attached_conditions_summary": [ { "table": "lpdb_placement", "attached_condition": "lpdb_placement.placement = '1' and lpdb_placement.namespace = 0 and lpdb_placement.`date` <> '0000-01-01 00:00:00.000000' and month(lpdb_placement.`date`) = '8' and dayofmonth(lpdb_placement.`date`) = '12' and year(lpdb_placement.`date`) < '2026' and lpdb_placement.opponentname <> 'TBD' and lpdb_placement.prizepoolindex = '1' and (lpdb_placement.liquipediatier = '1' or lpdb_placement.liquipediatier = '2') and lpdb_placement.liquipediatiertype <> 'Qualifier'" } ] } }, { "make_join_readinfo": [] }, { "test_if_skip_sort_order": [] } ] } } ] } MISSING_BYTES_BEYOND_MAX_MEM_SIZE: 0 INSUFFICIENT_PRIVILEGES: 0