{
    "query": "SELECT casein_pipe, email_cp, name_first_cp, name_last_cp, purpose_pipe\nFROM (tbl_comp_person INNER JOIN `tbl_pipelist` ON tbl_comp_person.IDp = tbl_pipelist.IDp)\nWHERE casein_pipe > '2016-03-01' AND  `campaign_id_pipe` = 24569 AND `weeksonlist_pipe` = 1\nORDER BY `tbl_pipelist`.`casein_pipe` ASC",
    "lexer": {
        "@type": "PhpMyAdmin\\SqlParser\\Lexer",
        "str": "SELECT casein_pipe, email_cp, name_first_cp, name_last_cp, purpose_pipe\nFROM (tbl_comp_person INNER JOIN `tbl_pipelist` ON tbl_comp_person.IDp = tbl_pipelist.IDp)\nWHERE casein_pipe > '2016-03-01' AND  `campaign_id_pipe` = 24569 AND `weeksonlist_pipe` = 1\nORDER BY `tbl_pipelist`.`casein_pipe` ASC",
        "len": 296,
        "last": 296,
        "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": "casein_pipe",
                    "value": "casein_pipe",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 7
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 18
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 19
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "email_cp",
                    "value": "email_cp",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 20
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 28
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 29
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "name_first_cp",
                    "value": "name_first_cp",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 30
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 43
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 44
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "name_last_cp",
                    "value": "name_last_cp",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 45
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 57
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 58
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "purpose_pipe",
                    "value": "purpose_pipe",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 59
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 71
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "FROM",
                    "value": "FROM",
                    "keyword": "FROM",
                    "type": 1,
                    "flags": 3,
                    "position": 72
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 76
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 77
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "tbl_comp_person",
                    "value": "tbl_comp_person",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 78
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 93
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "INNER JOIN",
                    "value": "INNER JOIN",
                    "keyword": "INNER JOIN",
                    "type": 1,
                    "flags": 7,
                    "position": 94
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 104
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`tbl_pipelist`",
                    "value": "tbl_pipelist",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 105
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 119
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ON",
                    "value": "ON",
                    "keyword": "ON",
                    "type": 1,
                    "flags": 3,
                    "position": 120
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 122
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "tbl_comp_person",
                    "value": "tbl_comp_person",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 123
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 138
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "IDp",
                    "value": "IDp",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 139
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 142
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 143
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 144
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "tbl_pipelist",
                    "value": "tbl_pipelist",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 145
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 157
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "IDp",
                    "value": "IDp",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 158
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 161
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 162
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "WHERE",
                    "value": "WHERE",
                    "keyword": "WHERE",
                    "type": 1,
                    "flags": 3,
                    "position": 163
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 168
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "casein_pipe",
                    "value": "casein_pipe",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 169
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 180
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ">",
                    "value": ">",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 181
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 182
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "'2016-03-01'",
                    "value": "2016-03-01",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 183
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 195
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "AND",
                    "value": "AND",
                    "keyword": "AND",
                    "type": 1,
                    "flags": 3,
                    "position": 196
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "  ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 199
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`campaign_id_pipe`",
                    "value": "campaign_id_pipe",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 201
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 219
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 220
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 221
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "24569",
                    "value": 24569,
                    "keyword": null,
                    "type": 6,
                    "flags": 0,
                    "position": 222
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 227
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "AND",
                    "value": "AND",
                    "keyword": "AND",
                    "type": 1,
                    "flags": 3,
                    "position": 228
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 231
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`weeksonlist_pipe`",
                    "value": "weeksonlist_pipe",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 232
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 250
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 251
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 252
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "1",
                    "value": 1,
                    "keyword": null,
                    "type": 6,
                    "flags": 0,
                    "position": 253
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 254
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ORDER BY",
                    "value": "ORDER BY",
                    "keyword": "ORDER BY",
                    "type": 1,
                    "flags": 7,
                    "position": 255
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 263
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`tbl_pipelist`",
                    "value": "tbl_pipelist",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 264
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 278
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`casein_pipe`",
                    "value": "casein_pipe",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 279
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 292
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ASC",
                    "value": "ASC",
                    "keyword": "ASC",
                    "type": 1,
                    "flags": 3,
                    "position": 293
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": null,
                    "value": null,
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": null
                }
            ],
            "count": 70,
            "idx": 70
        },
        "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": "casein_pipe",
                        "expr": "casein_pipe",
                        "alias": null,
                        "function": null,
                        "subquery": null
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                        "database": null,
                        "table": null,
                        "column": "email_cp",
                        "expr": "email_cp",
                        "alias": null,
                        "function": null,
                        "subquery": null
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                        "database": null,
                        "table": null,
                        "column": "name_first_cp",
                        "expr": "name_first_cp",
                        "alias": null,
                        "function": null,
                        "subquery": null
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                        "database": null,
                        "table": null,
                        "column": "name_last_cp",
                        "expr": "name_last_cp",
                        "alias": null,
                        "function": null,
                        "subquery": null
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                        "database": null,
                        "table": null,
                        "column": "purpose_pipe",
                        "expr": "purpose_pipe",
                        "alias": null,
                        "function": null,
                        "subquery": null
                    }
                ],
                "from": [
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                        "database": null,
                        "table": null,
                        "column": null,
                        "expr": "(tbl_comp_person INNER JOIN `tbl_pipelist` ON tbl_comp_person.IDp = tbl_pipelist.IDp)",
                        "alias": null,
                        "function": null,
                        "subquery": null
                    }
                ],
                "index_hints": null,
                "partition": null,
                "where": [
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
                        "identifiers": [
                            "casein_pipe",
                            "2016-03-01"
                        ],
                        "isOperator": false,
                        "expr": "casein_pipe > '2016-03-01'"
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
                        "identifiers": [],
                        "isOperator": true,
                        "expr": "AND"
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
                        "identifiers": [
                            "campaign_id_pipe"
                        ],
                        "isOperator": false,
                        "expr": "`campaign_id_pipe` = 24569"
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
                        "identifiers": [],
                        "isOperator": true,
                        "expr": "AND"
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
                        "identifiers": [
                            "weeksonlist_pipe"
                        ],
                        "isOperator": false,
                        "expr": "`weeksonlist_pipe` = 1"
                    }
                ],
                "group": null,
                "group_options": null,
                "having": null,
                "order": [
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\OrderKeyword",
                        "expr": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                            "database": null,
                            "table": "tbl_pipelist",
                            "column": "casein_pipe",
                            "expr": "`tbl_pipelist`.`casein_pipe`",
                            "alias": null,
                            "function": null,
                            "subquery": null
                        },
                        "type": "ASC"
                    }
                ],
                "limit": null,
                "procedure": null,
                "into": null,
                "join": null,
                "union": [],
                "end_options": null,
                "options": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                    "options": []
                },
                "first": 0,
                "last": 68
            }
        ],
        "brackets": 0,
        "strict": false,
        "errors": []
    },
    "errors": {
        "lexer": [],
        "parser": []
    }
}