{
    "query": "SELECT  * FROM address USE INDEX (idx_fk_city_id) FORCE KEY FOR GROUP BY (a, b,c) WHERE city_id<0",
    "lexer": {
        "@type": "PhpMyAdmin\\SqlParser\\Lexer",
        "str": "SELECT  * FROM address USE INDEX (idx_fk_city_id) FORCE KEY FOR GROUP BY (a, b,c) WHERE city_id<0",
        "len": 97,
        "last": 97,
        "list": {
            "@type": "PhpMyAdmin\\SqlParser\\TokensList",
            "tokens": [
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "SELECT",
                    "value": "SELECT",
                    "keyword": "SELECT",
                    "type": 1,
                    "flags": 3,
                    "position": 0
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "  ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 6
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "*",
                    "value": "*",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 8
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 9
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "FROM",
                    "value": "FROM",
                    "keyword": "FROM",
                    "type": 1,
                    "flags": 3,
                    "position": 10
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 14
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "address",
                    "value": "address",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 15
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 22
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "USE",
                    "value": "USE",
                    "keyword": "USE",
                    "type": 1,
                    "flags": 3,
                    "position": 23
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 26
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "INDEX",
                    "value": "INDEX",
                    "keyword": "INDEX",
                    "type": 1,
                    "flags": 19,
                    "position": 27
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 32
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 33
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "idx_fk_city_id",
                    "value": "idx_fk_city_id",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 34
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 48
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 49
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "FORCE",
                    "value": "FORCE",
                    "keyword": "FORCE",
                    "type": 1,
                    "flags": 3,
                    "position": 50
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 55
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "KEY",
                    "value": "KEY",
                    "keyword": "KEY",
                    "type": 1,
                    "flags": 19,
                    "position": 56
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 59
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "FOR",
                    "value": "FOR",
                    "keyword": "FOR",
                    "type": 1,
                    "flags": 3,
                    "position": 60
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 63
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "GROUP BY",
                    "value": "GROUP BY",
                    "keyword": "GROUP BY",
                    "type": 1,
                    "flags": 7,
                    "position": 64
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 72
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 73
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "a",
                    "value": "a",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 74
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 75
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 76
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "b",
                    "value": "b",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 77
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 78
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "c",
                    "value": "c",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 79
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 80
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 81
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "WHERE",
                    "value": "WHERE",
                    "keyword": "WHERE",
                    "type": 1,
                    "flags": 3,
                    "position": 82
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 87
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "city_id",
                    "value": "city_id",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 88
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "<",
                    "value": "<",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 95
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "0",
                    "value": 0,
                    "keyword": null,
                    "type": 6,
                    "flags": 0,
                    "position": 96
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": null,
                    "value": null,
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": null
                }
            ],
            "count": 39,
            "idx": 39
        },
        "delimiter": ";",
        "delimiterLen": 1,
        "strict": false,
        "errors": []
    },
    "parser": {
        "@type": "PhpMyAdmin\\SqlParser\\Parser",
        "list": {
            "@type": "@1"
        },
        "statements": [
            {
                "@type": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement",
                "expr": [
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                        "database": null,
                        "table": null,
                        "column": null,
                        "expr": "*",
                        "alias": null,
                        "function": null,
                        "subquery": null
                    }
                ],
                "from": [
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                        "database": null,
                        "table": "address",
                        "column": null,
                        "expr": "address",
                        "alias": null,
                        "function": null,
                        "subquery": null
                    }
                ],
                "index_hints": [
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\IndexHint",
                        "type": "USE",
                        "indexOrKey": "INDEX",
                        "for": null,
                        "indexes": [
                            {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                                "database": null,
                                "table": null,
                                "column": null,
                                "expr": "(idx_fk_city_id)",
                                "alias": null,
                                "function": null,
                                "subquery": null
                            }
                        ]
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\IndexHint",
                        "type": "FORCE",
                        "indexOrKey": "KEY",
                        "for": "GROUP BY",
                        "indexes": [
                            {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                                "database": null,
                                "table": null,
                                "column": null,
                                "expr": "(a, b,c)",
                                "alias": null,
                                "function": null,
                                "subquery": null
                            }
                        ]
                    }
                ],
                "partition": null,
                "where": [
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
                        "identifiers": [
                            "city_id"
                        ],
                        "isOperator": false,
                        "expr": "city_id<0"
                    }
                ],
                "group": null,
                "group_options": null,
                "having": null,
                "order": null,
                "limit": null,
                "procedure": null,
                "into": null,
                "join": null,
                "union": [],
                "end_options": null,
                "options": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                    "options": []
                },
                "first": 0,
                "last": 37
            }
        ],
        "brackets": 0,
        "strict": false,
        "errors": []
    },
    "errors": {
        "lexer": [],
        "parser": []
    }
}