{
    "query": "CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY INVOKER VIEW `sakila`.`actor_info` AS select `a`.`actor_id` AS `actor_id`,`a`.`first_name` AS `first_name`,`a`.`last_name` AS `last_name`,group_concat(distinct concat(`c`.`name`,': ',(select group_concat(`f`.`title` order by `f`.`title` ASC separator ', ') from ((`sakila`.`film` `f` join `sakila`.`film_category` `fc` on((`f`.`film_id` = `fc`.`film_id`))) join `sakila`.`film_actor` `fa` on((`f`.`film_id` = `fa`.`film_id`))) where ((`fc`.`category_id` = `c`.`category_id`) and (`fa`.`actor_id` = `a`.`actor_id`)))) order by `c`.`name` ASC separator '; ') AS `film_info` from (((`sakila`.`actor` `a` left join `sakila`.`film_actor` `fa` on((`a`.`actor_id` = `fa`.`actor_id`))) left join `sakila`.`film_category` `fc` on((`fa`.`film_id` = `fc`.`film_id`))) left join `sakila`.`category` `c` on((`fc`.`category_id` = `c`.`category_id`))) group by `a`.`actor_id`,`a`.`first_name`,`a`.`last_name`",
    "lexer": {
        "@type": "PhpMyAdmin\\SqlParser\\Lexer",
        "str": "CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY INVOKER VIEW `sakila`.`actor_info` AS select `a`.`actor_id` AS `actor_id`,`a`.`first_name` AS `first_name`,`a`.`last_name` AS `last_name`,group_concat(distinct concat(`c`.`name`,': ',(select group_concat(`f`.`title` order by `f`.`title` ASC separator ', ') from ((`sakila`.`film` `f` join `sakila`.`film_category` `fc` on((`f`.`film_id` = `fc`.`film_id`))) join `sakila`.`film_actor` `fa` on((`f`.`film_id` = `fa`.`film_id`))) where ((`fc`.`category_id` = `c`.`category_id`) and (`fa`.`actor_id` = `a`.`actor_id`)))) order by `c`.`name` ASC separator '; ') AS `film_info` from (((`sakila`.`actor` `a` left join `sakila`.`film_actor` `fa` on((`a`.`actor_id` = `fa`.`actor_id`))) left join `sakila`.`film_category` `fc` on((`fa`.`film_id` = `fc`.`film_id`))) left join `sakila`.`category` `c` on((`fc`.`category_id` = `c`.`category_id`))) group by `a`.`actor_id`,`a`.`first_name`,`a`.`last_name`",
        "len": 960,
        "last": 960,
        "list": {
            "@type": "PhpMyAdmin\\SqlParser\\TokensList",
            "tokens": [
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "CREATE",
                    "value": "CREATE",
                    "keyword": "CREATE",
                    "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": "ALGORITHM",
                    "value": "ALGORITHM",
                    "keyword": "ALGORITHM",
                    "type": 1,
                    "flags": 1,
                    "position": 7
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 16
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "UNDEFINED",
                    "value": "UNDEFINED",
                    "keyword": "UNDEFINED",
                    "type": 1,
                    "flags": 1,
                    "position": 17
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 26
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "DEFINER",
                    "value": "DEFINER",
                    "keyword": "DEFINER",
                    "type": 1,
                    "flags": 1,
                    "position": 27
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 34
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`root`@`localhost`",
                    "value": "root@localhost",
                    "keyword": null,
                    "type": 8,
                    "flags": 4,
                    "position": 35
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 53
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "SQL SECURITY",
                    "value": "SQL SECURITY",
                    "keyword": "SQL SECURITY",
                    "type": 1,
                    "flags": 7,
                    "position": 54
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 66
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "INVOKER",
                    "value": "INVOKER",
                    "keyword": "INVOKER",
                    "type": 1,
                    "flags": 1,
                    "position": 67
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 74
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "VIEW",
                    "value": "VIEW",
                    "keyword": "VIEW",
                    "type": 1,
                    "flags": 1,
                    "position": 75
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 79
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`sakila`",
                    "value": "sakila",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 80
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 88
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`actor_info`",
                    "value": "actor_info",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 89
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 101
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "AS",
                    "value": "AS",
                    "keyword": "AS",
                    "type": 1,
                    "flags": 3,
                    "position": 102
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 104
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "select",
                    "value": "SELECT",
                    "keyword": "SELECT",
                    "type": 1,
                    "flags": 3,
                    "position": 105
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 111
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`a`",
                    "value": "a",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 112
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 115
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`actor_id`",
                    "value": "actor_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 116
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 126
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "AS",
                    "value": "AS",
                    "keyword": "AS",
                    "type": 1,
                    "flags": 3,
                    "position": 127
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 129
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`actor_id`",
                    "value": "actor_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 130
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 140
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`a`",
                    "value": "a",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 141
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 144
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`first_name`",
                    "value": "first_name",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 145
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 157
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "AS",
                    "value": "AS",
                    "keyword": "AS",
                    "type": 1,
                    "flags": 3,
                    "position": 158
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 160
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`first_name`",
                    "value": "first_name",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 161
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 173
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`a`",
                    "value": "a",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 174
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 177
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`last_name`",
                    "value": "last_name",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 178
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 189
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "AS",
                    "value": "AS",
                    "keyword": "AS",
                    "type": 1,
                    "flags": 3,
                    "position": 190
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 192
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`last_name`",
                    "value": "last_name",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 193
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 204
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "group_concat",
                    "value": "group_concat",
                    "keyword": "GROUP_CONCAT",
                    "type": 1,
                    "flags": 33,
                    "position": 205
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 217
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "distinct",
                    "value": "DISTINCT",
                    "keyword": "DISTINCT",
                    "type": 1,
                    "flags": 3,
                    "position": 218
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 226
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "concat",
                    "value": "concat",
                    "keyword": "CONCAT",
                    "type": 1,
                    "flags": 33,
                    "position": 227
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 233
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`c`",
                    "value": "c",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 234
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 237
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`name`",
                    "value": "name",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 238
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 244
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "': '",
                    "value": ": ",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 245
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 249
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 250
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "select",
                    "value": "SELECT",
                    "keyword": "SELECT",
                    "type": 1,
                    "flags": 3,
                    "position": 251
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 257
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "group_concat",
                    "value": "group_concat",
                    "keyword": "GROUP_CONCAT",
                    "type": 1,
                    "flags": 33,
                    "position": 258
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 270
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`f`",
                    "value": "f",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 271
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 274
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`title`",
                    "value": "title",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 275
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 282
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "order by",
                    "value": "ORDER BY",
                    "keyword": "ORDER BY",
                    "type": 1,
                    "flags": 7,
                    "position": 283
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 291
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`f`",
                    "value": "f",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 292
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 295
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`title`",
                    "value": "title",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 296
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 303
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ASC",
                    "value": "ASC",
                    "keyword": "ASC",
                    "type": 1,
                    "flags": 3,
                    "position": 304
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 307
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "separator",
                    "value": "SEPARATOR",
                    "keyword": "SEPARATOR",
                    "type": 1,
                    "flags": 3,
                    "position": 308
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 317
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "', '",
                    "value": ", ",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 318
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 322
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 323
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "from",
                    "value": "FROM",
                    "keyword": "FROM",
                    "type": 1,
                    "flags": 3,
                    "position": 324
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 328
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 329
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 330
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`sakila`",
                    "value": "sakila",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 331
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 339
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`film`",
                    "value": "film",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 340
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 346
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`f`",
                    "value": "f",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 347
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 350
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "join",
                    "value": "JOIN",
                    "keyword": "JOIN",
                    "type": 1,
                    "flags": 3,
                    "position": 351
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 355
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`sakila`",
                    "value": "sakila",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 356
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 364
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`film_category`",
                    "value": "film_category",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 365
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 380
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`fc`",
                    "value": "fc",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 381
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 385
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "on",
                    "value": "ON",
                    "keyword": "ON",
                    "type": 1,
                    "flags": 3,
                    "position": 386
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 388
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 389
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`f`",
                    "value": "f",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 390
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 393
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`film_id`",
                    "value": "film_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 394
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 403
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 404
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 405
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`fc`",
                    "value": "fc",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 406
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 410
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`film_id`",
                    "value": "film_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 411
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 420
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 421
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 422
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 423
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "join",
                    "value": "JOIN",
                    "keyword": "JOIN",
                    "type": 1,
                    "flags": 3,
                    "position": 424
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 428
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`sakila`",
                    "value": "sakila",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 429
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 437
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`film_actor`",
                    "value": "film_actor",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 438
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 450
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`fa`",
                    "value": "fa",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 451
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 455
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "on",
                    "value": "ON",
                    "keyword": "ON",
                    "type": 1,
                    "flags": 3,
                    "position": 456
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 458
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 459
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`f`",
                    "value": "f",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 460
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 463
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`film_id`",
                    "value": "film_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 464
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 473
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 474
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 475
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`fa`",
                    "value": "fa",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 476
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 480
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`film_id`",
                    "value": "film_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 481
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 490
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 491
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 492
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 493
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "where",
                    "value": "WHERE",
                    "keyword": "WHERE",
                    "type": 1,
                    "flags": 3,
                    "position": 494
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 499
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 500
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 501
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`fc`",
                    "value": "fc",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 502
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 506
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`category_id`",
                    "value": "category_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 507
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 520
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 521
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 522
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`c`",
                    "value": "c",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 523
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 526
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`category_id`",
                    "value": "category_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 527
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 540
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 541
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "and",
                    "value": "AND",
                    "keyword": "AND",
                    "type": 1,
                    "flags": 3,
                    "position": 542
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 545
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 546
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`fa`",
                    "value": "fa",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 547
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 551
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`actor_id`",
                    "value": "actor_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 552
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 562
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 563
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 564
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`a`",
                    "value": "a",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 565
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 568
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`actor_id`",
                    "value": "actor_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 569
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 579
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 580
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 581
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 582
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 583
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "order by",
                    "value": "ORDER BY",
                    "keyword": "ORDER BY",
                    "type": 1,
                    "flags": 7,
                    "position": 584
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 592
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`c`",
                    "value": "c",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 593
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 596
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`name`",
                    "value": "name",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 597
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 603
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ASC",
                    "value": "ASC",
                    "keyword": "ASC",
                    "type": 1,
                    "flags": 3,
                    "position": 604
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 607
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "separator",
                    "value": "SEPARATOR",
                    "keyword": "SEPARATOR",
                    "type": 1,
                    "flags": 3,
                    "position": 608
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 617
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "'; '",
                    "value": "; ",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 618
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 622
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 623
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "AS",
                    "value": "AS",
                    "keyword": "AS",
                    "type": 1,
                    "flags": 3,
                    "position": 624
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 626
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`film_info`",
                    "value": "film_info",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 627
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 638
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "from",
                    "value": "FROM",
                    "keyword": "FROM",
                    "type": 1,
                    "flags": 3,
                    "position": 639
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 643
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 644
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 645
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 646
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`sakila`",
                    "value": "sakila",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 647
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 655
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`actor`",
                    "value": "actor",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 656
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 663
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`a`",
                    "value": "a",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 664
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 667
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "left join",
                    "value": "LEFT JOIN",
                    "keyword": "LEFT JOIN",
                    "type": 1,
                    "flags": 7,
                    "position": 668
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 677
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`sakila`",
                    "value": "sakila",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 678
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 686
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`film_actor`",
                    "value": "film_actor",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 687
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 699
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`fa`",
                    "value": "fa",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 700
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 704
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "on",
                    "value": "ON",
                    "keyword": "ON",
                    "type": 1,
                    "flags": 3,
                    "position": 705
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 707
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 708
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`a`",
                    "value": "a",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 709
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 712
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`actor_id`",
                    "value": "actor_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 713
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 723
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 724
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 725
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`fa`",
                    "value": "fa",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 726
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 730
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`actor_id`",
                    "value": "actor_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 731
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 741
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 742
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 743
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 744
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "left join",
                    "value": "LEFT JOIN",
                    "keyword": "LEFT JOIN",
                    "type": 1,
                    "flags": 7,
                    "position": 745
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 754
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`sakila`",
                    "value": "sakila",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 755
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 763
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`film_category`",
                    "value": "film_category",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 764
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 779
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`fc`",
                    "value": "fc",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 780
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 784
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "on",
                    "value": "ON",
                    "keyword": "ON",
                    "type": 1,
                    "flags": 3,
                    "position": 785
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 787
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 788
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`fa`",
                    "value": "fa",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 789
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 793
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`film_id`",
                    "value": "film_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 794
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 803
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 804
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 805
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`fc`",
                    "value": "fc",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 806
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 810
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`film_id`",
                    "value": "film_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 811
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 820
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 821
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 822
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 823
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "left join",
                    "value": "LEFT JOIN",
                    "keyword": "LEFT JOIN",
                    "type": 1,
                    "flags": 7,
                    "position": 824
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 833
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`sakila`",
                    "value": "sakila",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 834
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 842
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`category`",
                    "value": "category",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 843
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 853
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`c`",
                    "value": "c",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 854
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 857
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "on",
                    "value": "ON",
                    "keyword": "ON",
                    "type": 1,
                    "flags": 3,
                    "position": 858
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 860
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 861
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`fc`",
                    "value": "fc",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 862
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 866
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`category_id`",
                    "value": "category_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 867
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 880
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 881
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 882
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`c`",
                    "value": "c",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 883
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 886
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`category_id`",
                    "value": "category_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 887
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 900
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 901
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 902
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 903
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "group by",
                    "value": "GROUP BY",
                    "keyword": "GROUP BY",
                    "type": 1,
                    "flags": 7,
                    "position": 904
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 912
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`a`",
                    "value": "a",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 913
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 916
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`actor_id`",
                    "value": "actor_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 917
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 927
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`a`",
                    "value": "a",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 928
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 931
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`first_name`",
                    "value": "first_name",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 932
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 944
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`a`",
                    "value": "a",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 945
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 948
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`last_name`",
                    "value": "last_name",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 949
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": null,
                    "value": null,
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": null
                }
            ],
            "count": 286,
            "idx": 286
        },
        "delimiter": ";",
        "delimiterLen": 1,
        "strict": false,
        "errors": []
    },
    "parser": {
        "@type": "PhpMyAdmin\\SqlParser\\Parser",
        "list": {
            "@type": "@1"
        },
        "statements": [
            {
                "@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement",
                "name": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                    "database": "sakila",
                    "table": "actor_info",
                    "column": null,
                    "expr": "`sakila`.`actor_info`",
                    "alias": null,
                    "function": null,
                    "subquery": null
                },
                "entityOptions": null,
                "fields": null,
                "with": null,
                "select": {
                    "@type": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement",
                    "expr": [
                        {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                            "database": null,
                            "table": "a",
                            "column": "actor_id",
                            "expr": "`a`.`actor_id`",
                            "alias": "actor_id",
                            "function": null,
                            "subquery": null
                        },
                        {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                            "database": null,
                            "table": "a",
                            "column": "first_name",
                            "expr": "`a`.`first_name`",
                            "alias": "first_name",
                            "function": null,
                            "subquery": null
                        },
                        {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                            "database": null,
                            "table": "a",
                            "column": "last_name",
                            "expr": "`a`.`last_name`",
                            "alias": "last_name",
                            "function": null,
                            "subquery": null
                        },
                        {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                            "database": null,
                            "table": null,
                            "column": null,
                            "expr": "group_concat(distinct concat(`c`.`name`,': ',(select group_concat(`f`.`title` order by `f`.`title` ASC separator ', ') from ((`sakila`.`film` `f` join `sakila`.`film_category` `fc` on((`f`.`film_id` = `fc`.`film_id`))) join `sakila`.`film_actor` `fa` on((`f`.`film_id` = `fa`.`film_id`))) where ((`fc`.`category_id` = `c`.`category_id`) and (`fa`.`actor_id` = `a`.`actor_id`)))) order by `c`.`name` ASC separator '; ')",
                            "alias": "film_info",
                            "function": "group_concat",
                            "subquery": "SELECT"
                        }
                    ],
                    "from": [
                        {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                            "database": null,
                            "table": null,
                            "column": null,
                            "expr": "(((`sakila`.`actor` `a` left join `sakila`.`film_actor` `fa` on((`a`.`actor_id` = `fa`.`actor_id`))) left join `sakila`.`film_category` `fc` on((`fa`.`film_id` = `fc`.`film_id`))) left join `sakila`.`category` `c` on((`fc`.`category_id` = `c`.`category_id`)))",
                            "alias": null,
                            "function": null,
                            "subquery": null
                        }
                    ],
                    "index_hints": null,
                    "partition": null,
                    "where": null,
                    "group": [
                        {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\GroupKeyword",
                            "type": null,
                            "expr": {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                                "database": null,
                                "table": "a",
                                "column": "actor_id",
                                "expr": "`a`.`actor_id`",
                                "alias": null,
                                "function": null,
                                "subquery": null
                            }
                        },
                        {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\GroupKeyword",
                            "type": null,
                            "expr": {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                                "database": null,
                                "table": "a",
                                "column": "first_name",
                                "expr": "`a`.`first_name`",
                                "alias": null,
                                "function": null,
                                "subquery": null
                            }
                        },
                        {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\GroupKeyword",
                            "type": null,
                            "expr": {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                                "database": null,
                                "table": "a",
                                "column": "last_name",
                                "expr": "`a`.`last_name`",
                                "alias": null,
                                "function": null,
                                "subquery": 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": 22,
                    "last": 284
                },
                "like": null,
                "partitionBy": null,
                "partitionsNum": null,
                "subpartitionBy": null,
                "subpartitionsNum": null,
                "partitions": null,
                "table": null,
                "return": null,
                "parameters": null,
                "body": [],
                "options": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                    "options": {
                        "3": {
                            "name": "ALGORITHM",
                            "equals": true,
                            "expr": "UNDEFINED",
                            "value": "UNDEFINED"
                        },
                        "4": {
                            "name": "DEFINER",
                            "equals": true,
                            "expr": {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                                "database": null,
                                "table": null,
                                "column": "root@localhost",
                                "expr": "`root`@`localhost`",
                                "alias": null,
                                "function": null,
                                "subquery": null
                            },
                            "value": "`root`@`localhost`"
                        },
                        "5": {
                            "name": "SQL SECURITY",
                            "equals": false,
                            "expr": "INVOKER",
                            "value": "INVOKER"
                        },
                        "6": "VIEW"
                    }
                },
                "first": 0,
                "last": 285
            }
        ],
        "brackets": 0,
        "strict": false,
        "errors": []
    },
    "errors": {
        "lexer": [],
        "parser": []
    }
}