{
"query_block": {
"select_id": 1,
"read_sorted_file": {
"filesort": {
"sort_key": "cscart_rf_phonemask_masks.position, cscart_rf_phonemask_masks.country",
"table": {
"table_name": "cscart_rf_phonemask_masks",
"access_type": "ALL",
"rows": 2,
"filtered": 100,
"attached_condition": "cscart_rf_phonemask_masks.company_id in (0,1) and cscart_rf_phonemask_masks.`status` = 'A'"
}
}
}
}
}
| mask_id | company_id | country | prefix | mask | status | position |
|---|---|---|---|---|---|---|
| 1 | 0 | Russia | +7 | (NNN) NNN-NN-NN | A | 10 |