Server : ApacheSystem : Linux host.digitalbabaji.in 4.18.0-513.11.1.el8_9.x86_64 #1 SMP Wed Jan 17 02:00:40 EST 2024 x86_64 User : addictionfreeind ( 1003) PHP Version : 7.2.34 Disable Function : exec,passthru,shell_exec,system Directory : /home/addictionfreeind/www/admin1/vendor/phpmyadmin/sql-parser/tests/data/parser/ |
Upload File : |
{
"query": "SELECT\np.aa,\np.bb,\nCASE\nWHEN p.cc = 'Y' and dd = 'Found' then '99.99999'\nWHEN p.cc = '' and dd = 'Found' then '00.00000'\n ELSE '99.99999' END as RR,\nCASE\nWHEN dd = 'Found' then 'Y'\n ELSE 'N' END as RRI,\nCASE\n\tWHEN (SELECT MAX(cd) from LSA act group by act.an having p.acn = act.an) > '2021-01-28' THEN '06/30/2020'\n WHEN p.co < '2021-01-28' THEN '12/31/2019'\n ELSE '06/30/2020' END as DAOD\nFROM `LTKP` p\nleft join `LQA` qa\non qa.pi = p.ID\nleft join LSA act\non p.acn = act.an\nwhere p.a =1 and p.mr = 1 and p.sc<> '23' and qa.qt = 'TEXT' and p.tl = \"TEXT\" and qa.a = 1",
"lexer": {
"@type": "PhpMyAdmin\\SqlParser\\Lexer",
"str": "SELECT\np.aa,\np.bb,\nCASE\nWHEN p.cc = 'Y' and dd = 'Found' then '99.99999'\nWHEN p.cc = '' and dd = 'Found' then '00.00000'\n ELSE '99.99999' END as RR,\nCASE\nWHEN dd = 'Found' then 'Y'\n ELSE 'N' END as RRI,\nCASE\n\tWHEN (SELECT MAX(cd) from LSA act group by act.an having p.acn = act.an) > '2021-01-28' THEN '06/30/2020'\n WHEN p.co < '2021-01-28' THEN '12/31/2019'\n ELSE '06/30/2020' END as DAOD\nFROM `LTKP` p\nleft join `LQA` qa\non qa.pi = p.ID\nleft join LSA act\non p.acn = act.an\nwhere p.a =1 and p.mr = 1 and p.sc<> '23' and qa.qt = 'TEXT' and p.tl = \"TEXT\" and qa.a = 1",
"len": 579,
"last": 579,
"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": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 6
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "p",
"value": "p",
"keyword": null,
"type": 0,
"flags": 0,
"position": 7
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 8
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "aa",
"value": "aa",
"keyword": null,
"type": 0,
"flags": 0,
"position": 9
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 11
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 12
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "p",
"value": "p",
"keyword": null,
"type": 0,
"flags": 0,
"position": 13
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 14
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "bb",
"value": "bb",
"keyword": null,
"type": 0,
"flags": 0,
"position": 15
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 17
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 18
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "CASE",
"value": "CASE",
"keyword": "CASE",
"type": 1,
"flags": 3,
"position": 19
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 23
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "WHEN",
"value": "WHEN",
"keyword": "WHEN",
"type": 1,
"flags": 3,
"position": 24
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 28
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "p",
"value": "p",
"keyword": null,
"type": 0,
"flags": 0,
"position": 29
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 30
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "cc",
"value": "cc",
"keyword": null,
"type": 0,
"flags": 0,
"position": 31
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 33
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 34
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 35
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'Y'",
"value": "Y",
"keyword": null,
"type": 7,
"flags": 1,
"position": 36
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 39
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "and",
"value": "AND",
"keyword": "AND",
"type": 1,
"flags": 3,
"position": 40
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 43
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "dd",
"value": "dd",
"keyword": null,
"type": 0,
"flags": 0,
"position": 44
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 46
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 47
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 48
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'Found'",
"value": "Found",
"keyword": null,
"type": 7,
"flags": 1,
"position": 49
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 56
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "then",
"value": "THEN",
"keyword": "THEN",
"type": 1,
"flags": 3,
"position": 57
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 61
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'99.99999'",
"value": "99.99999",
"keyword": null,
"type": 7,
"flags": 1,
"position": 62
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 72
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "WHEN",
"value": "WHEN",
"keyword": "WHEN",
"type": 1,
"flags": 3,
"position": 73
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 77
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "p",
"value": "p",
"keyword": null,
"type": 0,
"flags": 0,
"position": 78
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 79
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "cc",
"value": "cc",
"keyword": null,
"type": 0,
"flags": 0,
"position": 80
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 82
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 83
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 84
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "''",
"value": "",
"keyword": null,
"type": 7,
"flags": 1,
"position": 85
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 87
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "and",
"value": "AND",
"keyword": "AND",
"type": 1,
"flags": 3,
"position": 88
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 91
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "dd",
"value": "dd",
"keyword": null,
"type": 0,
"flags": 0,
"position": 92
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 94
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 95
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 96
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'Found'",
"value": "Found",
"keyword": null,
"type": 7,
"flags": 1,
"position": 97
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 104
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "then",
"value": "THEN",
"keyword": "THEN",
"type": 1,
"flags": 3,
"position": 105
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 109
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'00.00000'",
"value": "00.00000",
"keyword": null,
"type": 7,
"flags": 1,
"position": 110
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 120
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "ELSE",
"value": "ELSE",
"keyword": "ELSE",
"type": 1,
"flags": 3,
"position": 125
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 129
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'99.99999'",
"value": "99.99999",
"keyword": null,
"type": 7,
"flags": 1,
"position": 130
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 140
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "END",
"value": "END",
"keyword": "END",
"type": 1,
"flags": 1,
"position": 141
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 144
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "as",
"value": "AS",
"keyword": "AS",
"type": 1,
"flags": 3,
"position": 145
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 147
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "RR",
"value": "RR",
"keyword": null,
"type": 0,
"flags": 0,
"position": 148
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 150
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 151
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "CASE",
"value": "CASE",
"keyword": "CASE",
"type": 1,
"flags": 3,
"position": 152
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 156
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "WHEN",
"value": "WHEN",
"keyword": "WHEN",
"type": 1,
"flags": 3,
"position": 157
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 161
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "dd",
"value": "dd",
"keyword": null,
"type": 0,
"flags": 0,
"position": 162
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 164
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 165
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 166
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'Found'",
"value": "Found",
"keyword": null,
"type": 7,
"flags": 1,
"position": 167
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 174
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "then",
"value": "THEN",
"keyword": "THEN",
"type": 1,
"flags": 3,
"position": 175
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 179
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'Y'",
"value": "Y",
"keyword": null,
"type": 7,
"flags": 1,
"position": 180
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 183
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "ELSE",
"value": "ELSE",
"keyword": "ELSE",
"type": 1,
"flags": 3,
"position": 188
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 192
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'N'",
"value": "N",
"keyword": null,
"type": 7,
"flags": 1,
"position": 193
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 196
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "END",
"value": "END",
"keyword": "END",
"type": 1,
"flags": 1,
"position": 197
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 200
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "as",
"value": "AS",
"keyword": "AS",
"type": 1,
"flags": 3,
"position": 201
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 203
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "RRI",
"value": "RRI",
"keyword": null,
"type": 0,
"flags": 0,
"position": 204
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 207
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 208
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "CASE",
"value": "CASE",
"keyword": "CASE",
"type": 1,
"flags": 3,
"position": 209
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n\t",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 213
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "WHEN",
"value": "WHEN",
"keyword": "WHEN",
"type": 1,
"flags": 3,
"position": 215
},
{
"@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": 16,
"position": 220
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "SELECT",
"value": "SELECT",
"keyword": "SELECT",
"type": 1,
"flags": 3,
"position": 221
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 227
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "MAX",
"value": "MAX",
"keyword": "MAX",
"type": 1,
"flags": 33,
"position": 228
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 231
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "cd",
"value": "cd",
"keyword": null,
"type": 0,
"flags": 0,
"position": 232
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 234
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 235
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "from",
"value": "FROM",
"keyword": "FROM",
"type": 1,
"flags": 3,
"position": 236
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 240
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "LSA",
"value": "LSA",
"keyword": null,
"type": 0,
"flags": 0,
"position": 241
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 244
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "act",
"value": "act",
"keyword": null,
"type": 0,
"flags": 0,
"position": 245
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 248
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "group by",
"value": "GROUP BY",
"keyword": "GROUP BY",
"type": 1,
"flags": 7,
"position": 249
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 257
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "act",
"value": "act",
"keyword": null,
"type": 0,
"flags": 0,
"position": 258
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 261
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "an",
"value": "an",
"keyword": null,
"type": 0,
"flags": 0,
"position": 262
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 264
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "having",
"value": "HAVING",
"keyword": "HAVING",
"type": 1,
"flags": 3,
"position": 265
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 271
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "p",
"value": "p",
"keyword": null,
"type": 0,
"flags": 0,
"position": 272
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 273
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "acn",
"value": "acn",
"keyword": null,
"type": 0,
"flags": 0,
"position": 274
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 277
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 278
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 279
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "act",
"value": "act",
"keyword": null,
"type": 0,
"flags": 0,
"position": 280
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 283
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "an",
"value": "an",
"keyword": null,
"type": 0,
"flags": 0,
"position": 284
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 286
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 287
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ">",
"value": ">",
"keyword": null,
"type": 2,
"flags": 2,
"position": 288
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 289
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'2021-01-28'",
"value": "2021-01-28",
"keyword": null,
"type": 7,
"flags": 1,
"position": 290
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 302
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "THEN",
"value": "THEN",
"keyword": "THEN",
"type": 1,
"flags": 3,
"position": 303
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 307
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'06/30/2020'",
"value": "06/30/2020",
"keyword": null,
"type": 7,
"flags": 1,
"position": 308
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 320
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "WHEN",
"value": "WHEN",
"keyword": "WHEN",
"type": 1,
"flags": 3,
"position": 325
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 329
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "p",
"value": "p",
"keyword": null,
"type": 0,
"flags": 0,
"position": 330
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 331
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "co",
"value": "co",
"keyword": null,
"type": 0,
"flags": 0,
"position": 332
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 334
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "<",
"value": "<",
"keyword": null,
"type": 2,
"flags": 2,
"position": 335
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 336
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'2021-01-28'",
"value": "2021-01-28",
"keyword": null,
"type": 7,
"flags": 1,
"position": 337
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 349
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "THEN",
"value": "THEN",
"keyword": "THEN",
"type": 1,
"flags": 3,
"position": 350
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 354
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'12/31/2019'",
"value": "12/31/2019",
"keyword": null,
"type": 7,
"flags": 1,
"position": 355
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 367
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "ELSE",
"value": "ELSE",
"keyword": "ELSE",
"type": 1,
"flags": 3,
"position": 372
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 376
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'06/30/2020'",
"value": "06/30/2020",
"keyword": null,
"type": 7,
"flags": 1,
"position": 377
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 389
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "END",
"value": "END",
"keyword": "END",
"type": 1,
"flags": 1,
"position": 390
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 393
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "as",
"value": "AS",
"keyword": "AS",
"type": 1,
"flags": 3,
"position": 394
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 396
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "DAOD",
"value": "DAOD",
"keyword": null,
"type": 0,
"flags": 0,
"position": 397
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 401
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "FROM",
"value": "FROM",
"keyword": "FROM",
"type": 1,
"flags": 3,
"position": 402
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 406
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`LTKP`",
"value": "LTKP",
"keyword": null,
"type": 8,
"flags": 2,
"position": 407
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 413
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "p",
"value": "p",
"keyword": null,
"type": 0,
"flags": 0,
"position": 414
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 415
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "left join",
"value": "LEFT JOIN",
"keyword": "LEFT JOIN",
"type": 1,
"flags": 7,
"position": 416
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 425
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`LQA`",
"value": "LQA",
"keyword": null,
"type": 8,
"flags": 2,
"position": 426
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 431
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "qa",
"value": "qa",
"keyword": null,
"type": 0,
"flags": 0,
"position": 432
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 434
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "on",
"value": "ON",
"keyword": "ON",
"type": 1,
"flags": 3,
"position": 435
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 437
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "qa",
"value": "qa",
"keyword": null,
"type": 0,
"flags": 0,
"position": 438
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 440
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "pi",
"value": "pi",
"keyword": "PI",
"type": 0,
"flags": 0,
"position": 441
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 443
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 444
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 445
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "p",
"value": "p",
"keyword": null,
"type": 0,
"flags": 0,
"position": 446
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 447
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "ID",
"value": "ID",
"keyword": null,
"type": 0,
"flags": 0,
"position": 448
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 450
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "left join",
"value": "LEFT JOIN",
"keyword": "LEFT JOIN",
"type": 1,
"flags": 7,
"position": 451
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 460
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "LSA",
"value": "LSA",
"keyword": null,
"type": 0,
"flags": 0,
"position": 461
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 464
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "act",
"value": "act",
"keyword": null,
"type": 0,
"flags": 0,
"position": 465
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 468
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "on",
"value": "ON",
"keyword": "ON",
"type": 1,
"flags": 3,
"position": 469
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 471
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "p",
"value": "p",
"keyword": null,
"type": 0,
"flags": 0,
"position": 472
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 473
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "acn",
"value": "acn",
"keyword": null,
"type": 0,
"flags": 0,
"position": 474
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 477
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 478
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 479
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "act",
"value": "act",
"keyword": null,
"type": 0,
"flags": 0,
"position": 480
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 483
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "an",
"value": "an",
"keyword": null,
"type": 0,
"flags": 0,
"position": 484
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 486
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "where",
"value": "WHERE",
"keyword": "WHERE",
"type": 1,
"flags": 3,
"position": 487
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 492
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "p",
"value": "p",
"keyword": null,
"type": 0,
"flags": 0,
"position": 494
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 495
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "a",
"value": "a",
"keyword": null,
"type": 0,
"flags": 0,
"position": 496
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 497
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 498
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "1",
"value": 1,
"keyword": null,
"type": 6,
"flags": 0,
"position": 499
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 500
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "and",
"value": "AND",
"keyword": "AND",
"type": 1,
"flags": 3,
"position": 501
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 504
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "p",
"value": "p",
"keyword": null,
"type": 0,
"flags": 0,
"position": 505
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 506
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "mr",
"value": "mr",
"keyword": null,
"type": 0,
"flags": 0,
"position": 507
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 509
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 510
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 511
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "1",
"value": 1,
"keyword": null,
"type": 6,
"flags": 0,
"position": 512
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 513
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "and",
"value": "AND",
"keyword": "AND",
"type": 1,
"flags": 3,
"position": 514
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 517
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "p",
"value": "p",
"keyword": null,
"type": 0,
"flags": 0,
"position": 518
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 519
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "sc",
"value": "sc",
"keyword": null,
"type": 0,
"flags": 0,
"position": 520
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "<>",
"value": "<>",
"keyword": null,
"type": 2,
"flags": 2,
"position": 522
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 524
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'23'",
"value": "23",
"keyword": null,
"type": 7,
"flags": 1,
"position": 525
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 529
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "and",
"value": "AND",
"keyword": "AND",
"type": 1,
"flags": 3,
"position": 530
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 533
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "qa",
"value": "qa",
"keyword": null,
"type": 0,
"flags": 0,
"position": 534
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 536
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "qt",
"value": "qt",
"keyword": null,
"type": 0,
"flags": 0,
"position": 537
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 539
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 540
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 541
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'TEXT'",
"value": "TEXT",
"keyword": null,
"type": 7,
"flags": 1,
"position": 542
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 548
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "and",
"value": "AND",
"keyword": "AND",
"type": 1,
"flags": 3,
"position": 549
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 552
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "p",
"value": "p",
"keyword": null,
"type": 0,
"flags": 0,
"position": 553
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 554
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "tl",
"value": "tl",
"keyword": null,
"type": 0,
"flags": 0,
"position": 555
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 557
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 558
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 559
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\"TEXT\"",
"value": "TEXT",
"keyword": null,
"type": 7,
"flags": 2,
"position": 560
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 566
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "and",
"value": "AND",
"keyword": "AND",
"type": 1,
"flags": 3,
"position": 567
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 570
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "qa",
"value": "qa",
"keyword": null,
"type": 0,
"flags": 0,
"position": 571
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 573
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "a",
"value": "a",
"keyword": null,
"type": 0,
"flags": 0,
"position": 574
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 575
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 576
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 577
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "1",
"value": 1,
"keyword": null,
"type": 6,
"flags": 0,
"position": 578
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": null,
"value": null,
"keyword": null,
"type": 9,
"flags": 0,
"position": null
}
],
"count": 263,
"idx": 263
},
"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": "p",
"column": "aa",
"expr": "p.aa",
"alias": null,
"function": null,
"subquery": null
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": "p",
"column": "bb",
"expr": "p.bb",
"alias": null,
"function": null,
"subquery": null
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\CaseExpression",
"value": null,
"conditions": [
[
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"p",
"cc",
"Y"
],
"isOperator": false,
"expr": "p.cc = 'Y'"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [],
"isOperator": true,
"expr": "AND"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"dd",
"Found"
],
"isOperator": false,
"expr": "dd = 'Found'"
}
],
[
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"p",
"cc",
""
],
"isOperator": false,
"expr": "p.cc = ''"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [],
"isOperator": true,
"expr": "AND"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"dd",
"Found"
],
"isOperator": false,
"expr": "dd = 'Found'"
}
]
],
"results": [
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": null,
"column": "99.99999",
"expr": "'99.99999'",
"alias": null,
"function": null,
"subquery": null
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": null,
"column": "00.00000",
"expr": "'00.00000'",
"alias": null,
"function": null,
"subquery": null
}
],
"compare_values": [],
"else_result": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": null,
"column": "99.99999",
"expr": "'99.99999'",
"alias": null,
"function": null,
"subquery": null
},
"alias": "RR",
"expr": "CASE WHEN p.cc = 'Y' AND dd = 'Found' THEN '99.99999' WHEN p.cc = '' AND dd = 'Found' THEN '00.00000' ELSE '99.99999' END AS `RR`"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\CaseExpression",
"value": null,
"conditions": [
[
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"dd",
"Found"
],
"isOperator": false,
"expr": "dd = 'Found'"
}
]
],
"results": [
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": null,
"column": "Y",
"expr": "'Y'",
"alias": null,
"function": null,
"subquery": null
}
],
"compare_values": [],
"else_result": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": null,
"column": "N",
"expr": "'N'",
"alias": null,
"function": null,
"subquery": null
},
"alias": "RRI",
"expr": "CASE WHEN dd = 'Found' THEN 'Y' ELSE 'N' END AS `RRI`"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\CaseExpression",
"value": null,
"conditions": [
[
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"MAX",
"cd",
"LSA",
"act",
"an",
"p",
"acn",
"2021-01-28"
],
"isOperator": false,
"expr": "(SELECT MAX(cd) from LSA act group by act.an having p.acn = act.an) > '2021-01-28'"
}
],
[
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"p",
"co",
"2021-01-28"
],
"isOperator": false,
"expr": "p.co < '2021-01-28'"
}
]
],
"results": [
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": null,
"column": "06/30/2020",
"expr": "'06/30/2020'",
"alias": null,
"function": null,
"subquery": null
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": null,
"column": "12/31/2019",
"expr": "'12/31/2019'",
"alias": null,
"function": null,
"subquery": null
}
],
"compare_values": [],
"else_result": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": null,
"column": "06/30/2020",
"expr": "'06/30/2020'",
"alias": null,
"function": null,
"subquery": null
},
"alias": "DAOD",
"expr": "CASE WHEN (SELECT MAX(cd) from LSA act group by act.an having p.acn = act.an) > '2021-01-28' THEN '06/30/2020' WHEN p.co < '2021-01-28' THEN '12/31/2019' ELSE '06/30/2020' END AS `DAOD`"
}
],
"from": [
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": "LTKP",
"column": null,
"expr": "`LTKP`",
"alias": "p",
"function": null,
"subquery": null
}
],
"index_hints": null,
"partition": null,
"where": [
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"p",
"a"
],
"isOperator": false,
"expr": "p.a =1"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [],
"isOperator": true,
"expr": "AND"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"p",
"mr"
],
"isOperator": false,
"expr": "p.mr = 1"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [],
"isOperator": true,
"expr": "AND"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"p",
"sc",
"23"
],
"isOperator": false,
"expr": "p.sc<> '23'"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [],
"isOperator": true,
"expr": "AND"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"qa",
"qt",
"TEXT"
],
"isOperator": false,
"expr": "qa.qt = 'TEXT'"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [],
"isOperator": true,
"expr": "AND"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"p",
"tl",
"TEXT"
],
"isOperator": false,
"expr": "p.tl = \"TEXT\""
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [],
"isOperator": true,
"expr": "AND"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"qa",
"a"
],
"isOperator": false,
"expr": "qa.a = 1"
}
],
"group": null,
"group_options": null,
"having": null,
"order": null,
"limit": null,
"procedure": null,
"into": null,
"join": [
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword",
"type": "LEFT",
"expr": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": "LQA",
"column": null,
"expr": "`LQA`",
"alias": "qa",
"function": null,
"subquery": null
},
"on": [
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"qa",
"pi",
"p",
"ID"
],
"isOperator": false,
"expr": "qa.pi = p.ID"
}
],
"using": null
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword",
"type": "LEFT",
"expr": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": "LSA",
"column": null,
"expr": "LSA",
"alias": "act",
"function": null,
"subquery": null
},
"on": [
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"p",
"acn",
"act",
"an"
],
"isOperator": false,
"expr": "p.acn = act.an"
}
],
"using": null
}
],
"union": [],
"end_options": null,
"options": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
"options": []
},
"first": 0,
"last": 261
}
],
"brackets": 0,
"strict": false,
"errors": []
},
"errors": {
"lexer": [],
"parser": []
}
}