condition": "((`report_product_sales_data`.`hq_code` = '000030') and (`report_product_sales_data`.`product_id` in (11453,11472,11487,11446,11456,12088,11433,114170,11479,11491,11485,11482,70672,68998,154298,11435,11481,11515,122573,167938)) and (`report_product_sales_data`.`report_date` > '2018-05-11') and multiple equal(229, `report_product_sales_data`.`orgz_id`))" } ] } }, { "table_dependencies": [ { "table": "`report_product_sales_data`", "row_may_be_null": false, "map_bit": 0, "depends_on_map_bits": [ ] } ] }, { "ref_optimizer_key_uses": [ { "table": "`report_product_sales_data`", "field": "hq_code", "equals": "'000030'", "null_rejecting": false }, { "table": "`report_product_sales_data`", "field": "hq_code", "equals": "'000030'", "null_rejecting": false }, { "table": "`report_product_sales_data`", "field": "orgz_id", "equals": "229", "null_rejecting": false } ] }, { "rows_estimation": [ { "table": "`report_product_sales_data`", "range_analysis" |