gistfile1.diff

7,8c7
<   address = 127.0.0.1
<   port = 3313
---
>   listen = 127.0.0.1:3313
24c23,24
<   sql_query = SELECT `cast_members`.`id` * 5 + 0 AS `id` , CAST(`cast_members`.`name` AS CHAR) AS `name`, CAST(`cast_members`.`sort_name` AS CHAR) AS `sort_name`, IFNULL(`cast_members`.`name`, '') AS `name_sort`, IFNULL(`cast_members`.`sort_name`, '') AS `sort_name_sort`, `cast_members`.`id` AS `sphinx_internal_id`, 560823700 AS `class_crc`, '2604646539,560823700' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM cast_members    WHERE `cast_members`.`id` >= $start   AND `cast_members`.`id` <= $end    GROUP BY `cast_members`.`id`  ORDER BY NULL
---
>   sql_query_pre = SET TIME_ZONE = '+0:00'
>   sql_query = SELECT SQL_NO_CACHE `cast_members`.`id` * 5 + 0 AS `id` , `cast_members`.`name` AS `name`, `cast_members`.`sort_name` AS `sort_name`, `cast_members`.`id` AS `sphinx_internal_id`, 560823700 AS `class_crc`, 0 AS `sphinx_deleted`, IFNULL(`cast_members`.`name`, '') AS `name_sort`, IFNULL(`cast_members`.`sort_name`, '') AS `sort_name_sort` FROM `cast_members` WHERE (`cast_members`.`id` >= $start AND `cast_members`.`id` <= $end) GROUP BY `cast_members`.`id` ORDER BY NULL
32,33c32
<   sql_attr_multi = uint subclass_crcs from field
<   sql_query_info = SELECT * FROM `cast_members` WHERE  `id` = (($id - 0) / 5)
---
>   sql_query_info = SELECT * FROM `cast_members` WHERE `id` = (($id - 0) / 5)
40d38
<   morphology = stem_en
63c61,62
< U+00D9->u, U+00DA->u, U+00DB->u, U+00DC->u, U+00F9->u, U+00FA->u, U+00FB->u, U+00FC->u, U+010316->u, U+0168->u, U+0169->u, U+016A->u, U+016B->u, U+016C->u, U+016D->u, U+016E->u, U+016F->u, U+0170->u, U+0171->u, U+0172->u, U+0173->u, U+01AF->u, U+01B0->u, U+01D3->u, U+01D4->u, U+01D5->u, U+01D6->u, U+01D7->u, U+01D8->u, U+01D9->u, U+01DA->u, U+01DB->u, U+01DC->u, U+0214->u, U+0215->u, U+0216->u, U+0217->u, U+0244->u, U+0289->u, U+1D1C->u, U+1D1D->u, U+1D1E->u, U+1D41->u, U+1D58->u, U+1D59->u, U+1D64->u, U+1D7E->u, U+1D99->u, U+1DB6->u, U+1DB8->u, U+1E72->u, U+1E73->u, U+1E74->u, U+1E75->u, U+1E76->u, U+1E77->u, U+1E78->u, U+1E79->u, U+1E7A->u, U+1E7B->u, U+1EE4->u, U+1EE5->u, U+1EE6->u, U+1EE7->u, U+1EE8->u, U+1EE9->u, U+1EEA->u, U+1EEB->u, U+1EEC->u, U+1EED->u, U+1EEE->u, U+1EEF->u, U+1EF0->u, U+1EF1->u, \
---
> U+00D9->u, U+00DA->u, U+00DB->u, U+00DC->u, U+00F9->u, U+00FA->u, U+00FB->u, U+00FC->u, U+010316->u, U+0168->u, U+0169->u, U+016A->u, U+016B->u, U+016C->u, U+016D->u, U+016E->u, U+016F->u, U+0170->u, U+0171->u, U+0172->u, U+0173->u, U+01AF->u, U+01B0->u, U+01D3->u, U+01D4->u, U+01D5->u, U+01D6->u, U+01D7->u, U+01D8->u, U+01D9->u, U+01DA->u, U+01DB->u, U+01DC->u, U+0214->u, U+0215->u, U+0216->u, U+0217->u, U+0244->u, U+0289->u, U+1D1C->u, U+1D1D->u, U+1D1E->u, U+1D41->u, U+1D58->u, U+1D59->u, U+1D64->u, U+1D7E->u, U+1D99->u, U+1DB6->u, U+1DB8->u, U+1E72->u, U+1E\
> 73->u, U+1E74->u, U+1E75->u, U+1E76->u, U+1E77->u, U+1E78->u, U+1E79->u, U+1E7A->u, U+1E7B->u, U+1EE4->u, U+1EE5->u, U+1EE6->u, U+1EE7->u, U+1EE8->u, U+1EE9->u, U+1EEA->u, U+1EEB->u, U+1EEC->u, U+1EED->u, U+1EEE->u, U+1EEF->u, U+1EF0->u, U+1EF1->u, \
89c88,89
<   sql_query = SELECT `cities`.`id` * 5 + 1 AS `id` , CAST(CONCAT_WS(' ', `cities`.`name`, `cities`.`region`) AS CHAR) AS `location_name`, CAST(`cities`.`name` AS CHAR) AS `name`, CAST(`cities`.`region` AS CHAR) AS `region`, CAST(`cities`.`country_code` AS CHAR) AS `country_code`, CAST(`countries`.`name` AS CHAR) AS `country`, IFNULL(CONCAT_WS(' ', `cities`.`name`, `cities`.`region`), '') AS `location_name_sort`, IFNULL(`countries`.`name`, '') AS `country_sort`, GROUP_CONCAT(DISTINCT `users`.`id` SEPARATOR ',') AS `user_ids`, count(users.id) AS `users`, `cities`.`id` AS `sphinx_internal_id`, 2372513034 AS `class_crc`, '2372513034' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM cities    LEFT OUTER JOIN `countries` ON `countries`.id = `cities`.country_id   LEFT OUTER JOIN `users` ON users.city_id = cities.id  WHERE `cities`.`id` >= $start   AND `cities`.`id` <= $end    AND `primary` is not null and `cities`.`name`<>'' GROUP BY `cities`.`id`  ORDER BY NULL
---
>   sql_query_pre = SET TIME_ZONE = '+0:00'
>   sql_query = SELECT SQL_NO_CACHE `cities`.`id` * 5 + 1 AS `id` , CONCAT_WS(' ', `cities`.`name`, `cities`.`region`) AS `location_name`, `cities`.`name` AS `name`, `cities`.`region` AS `region`, `cities`.`country_code` AS `country_code`, `countries`.`name` AS `country`, `cities`.`id` AS `sphinx_internal_id`, 2372513034 AS `class_crc`, 0 AS `sphinx_deleted`, CONCAT_WS(' ', IFNULL(`cities`.`name`, ''), IFNULL(`cities`.`region`, '')) AS `location_name_sort`, IFNULL(`countries`.`name`, '') AS `country_sort`, GROUP_CONCAT(DISTINCT IFNULL(`users`.`id`, '0') SEPARATOR ',') AS `user_ids`, count(users.id) AS `users` FROM `cities` LEFT OUTER JOIN `countries` ON `countries`.`id` = `cities`.`country_id` LEFT OUTER JOIN `users` ON `users`.`city_id` = `cities`.`id` WHERE (`cities`.`id` >= $start AND `cities`.`id` <= $end AND `primary` is not null and `cities`.`name`<>'') GROUP BY `cities`.`id` ORDER BY NULL
92d91
<   sql_attr_uint = users
95a95
>   sql_attr_uint = users
99,100c99
<   sql_attr_multi = uint subclass_crcs from field
<   sql_query_info = SELECT * FROM `cities` WHERE  `id` = (($id - 1) / 5)
---
>   sql_query_info = SELECT * FROM `cities` WHERE `id` = (($id - 1) / 5)
107d105
<   morphology = stem_en
130c128,129
< U+00D9->u, U+00DA->u, U+00DB->u, U+00DC->u, U+00F9->u, U+00FA->u, U+00FB->u, U+00FC->u, U+010316->u, U+0168->u, U+0169->u, U+016A->u, U+016B->u, U+016C->u, U+016D->u, U+016E->u, U+016F->u, U+0170->u, U+0171->u, U+0172->u, U+0173->u, U+01AF->u, U+01B0->u, U+01D3->u, U+01D4->u, U+01D5->u, U+01D6->u, U+01D7->u, U+01D8->u, U+01D9->u, U+01DA->u, U+01DB->u, U+01DC->u, U+0214->u, U+0215->u, U+0216->u, U+0217->u, U+0244->u, U+0289->u, U+1D1C->u, U+1D1D->u, U+1D1E->u, U+1D41->u, U+1D58->u, U+1D59->u, U+1D64->u, U+1D7E->u, U+1D99->u, U+1DB6->u, U+1DB8->u, U+1E72->u, U+1E73->u, U+1E74->u, U+1E75->u, U+1E76->u, U+1E77->u, U+1E78->u, U+1E79->u, U+1E7A->u, U+1E7B->u, U+1EE4->u, U+1EE5->u, U+1EE6->u, U+1EE7->u, U+1EE8->u, U+1EE9->u, U+1EEA->u, U+1EEB->u, U+1EEC->u, U+1EED->u, U+1EEE->u, U+1EEF->u, U+1EF0->u, U+1EF1->u, \
---
> U+00D9->u, U+00DA->u, U+00DB->u, U+00DC->u, U+00F9->u, U+00FA->u, U+00FB->u, U+00FC->u, U+010316->u, U+0168->u, U+0169->u, U+016A->u, U+016B->u, U+016C->u, U+016D->u, U+016E->u, U+016F->u, U+0170->u, U+0171->u, U+0172->u, U+0173->u, U+01AF->u, U+01B0->u, U+01D3->u, U+01D4->u, U+01D5->u, U+01D6->u, U+01D7->u, U+01D8->u, U+01D9->u, U+01DA->u, U+01DB->u, U+01DC->u, U+0214->u, U+0215->u, U+0216->u, U+0217->u, U+0244->u, U+0289->u, U+1D1C->u, U+1D1D->u, U+1D1E->u, U+1D41->u, U+1D58->u, U+1D59->u, U+1D64->u, U+1D7E->u, U+1D99->u, U+1DB6->u, U+1DB8->u, U+1E72->u, U+1E\
> 73->u, U+1E74->u, U+1E75->u, U+1E76->u, U+1E77->u, U+1E78->u, U+1E79->u, U+1E7A->u, U+1E7B->u, U+1EE4->u, U+1EE5->u, U+1EE6->u, U+1EE7->u, U+1EE8->u, U+1EE9->u, U+1EEA->u, U+1EEB->u, U+1EEC->u, U+1EED->u, U+1EEE->u, U+1EEF->u, U+1EF0->u, U+1EF1->u, \
154c153
<   sql_query_pre = UPDATE `films` SET `delta` = 0
---
>   sql_query_pre = UPDATE `films` SET `delta` = 0 WHERE `delta` = 1
157c156,157
<   sql_query = SELECT `films`.`id` * 5 + 2 AS `id` , CAST(`films`.`original_title` AS CHAR) AS `original_title`, CAST(`films`.`imdb_id` AS CHAR) AS `imdb_id`, CAST(GROUP_CONCAT(DISTINCT `film_translations`.`title` SEPARATOR ' ') AS CHAR) AS `title_en_us`, CAST(`film_translations`.`sort_title` AS CHAR) AS `sort_title_en_us`, CAST(GROUP_CONCAT(DISTINCT `translations_fr_frs_films`.`title` SEPARATOR ' ') AS CHAR) AS `title_fr_fr`, CAST(COALESCE(`translations_fr_frs_films`.`sort_title`, `film_translations`.`sort_title`) AS CHAR) AS `sort_title_fr_fr`, CAST(GROUP_CONCAT(DISTINCT `translations_it_its_films`.`title` SEPARATOR ' ') AS CHAR) AS `title_it_it`, CAST(COALESCE(`translations_it_its_films`.`sort_title`, `film_translations`.`sort_title`) AS CHAR) AS `sort_title_it_it`, CAST(GROUP_CONCAT(DISTINCT `translations_de_des_films`.`title` SEPARATOR ' ') AS CHAR) AS `title_de_de`, CAST(COALESCE(`translations_de_des_films`.`sort_title`, `film_translations`.`sort_title`) AS CHAR) AS `sort_title_de_de`, CAST(GROUP_CONCAT(DISTINCT `translations_es_es_films`.`title` SEPARATOR ' ') AS CHAR) AS `title_es_es`, CAST(COALESCE(`translations_es_es_films`.`sort_title`, `film_translations`.`sort_title`) AS CHAR) AS `sort_title_es_es`, CAST(GROUP_CONCAT(DISTINCT `translations_pt_brs_films`.`title` SEPARATOR ' ') AS CHAR) AS `title_pt_br`, CAST(COALESCE(`translations_pt_brs_films`.`sort_title`, `film_translations`.`sort_title`) AS CHAR) AS `sort_title_pt_br`, CAST(GROUP_CONCAT(DISTINCT `translations_nl_nls_films`.`title` SEPARATOR ' ') AS CHAR) AS `title_nl_nl`, CAST(COALESCE(`translations_nl_nls_films`.`sort_title`, `film_translations`.`sort_title`) AS CHAR) AS `sort_title_nl_nl`, CAST(GROUP_CONCAT(DISTINCT `cast_members`.`sort_name` SEPARATOR ' ') AS CHAR) AS `directors`, IFNULL(`films`.`original_title`, '') AS `original_title_sort`, IFNULL(`films`.`imdb_id`, '') AS `imdb_id_sort`, IFNULL(`film_translations`.`sort_title`, '') AS `sort_title_en_us_sort`, IFNULL(COALESCE(`translations_fr_frs_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_fr_fr_sort`, IFNULL(COALESCE(`translations_it_its_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_it_it_sort`, IFNULL(COALESCE(`translations_de_des_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_de_de_sort`, IFNULL(COALESCE(`translations_es_es_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_es_es_sort`, IFNULL(COALESCE(`translations_pt_brs_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_pt_br_sort`, IFNULL(COALESCE(`translations_nl_nls_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_nl_nl_sort`, IFNULL(GROUP_CONCAT(DISTINCT `cast_members`.`sort_name` SEPARATOR ' '), '') AS `directors_sort`, GROUP_CONCAT(DISTINCT `screenings`.`festival_id` SEPARATOR ',') AS `festival_id`, GROUP_CONCAT(DISTINCT CONCAT(screenings.year, screenings.festival_id) SEPARATOR ',') AS `festival_year_id`, COUNT(cast_members.id) AS `director_count`, GROUP_CONCAT(DISTINCT `authorizations`.`country_id` SEPARATOR ',') AS `country`, GROUP_CONCAT(DISTINCT `distributor_films`.`distributor_id` SEPARATOR ',') AS `distributor_id`, UNIX_TIMESTAMP(MAX(authorizations.created_at)) AS `authorized_at`, GROUP_CONCAT(CONCAT(authorizations.distributor_id, LPAD(authorizations.country_id, 3, 0)) SEPARATOR ',') AS `country_distributor_composite_id`, GROUP_CONCAT(IF(authorizations.free, authorizations.country_id, NULL) SEPARATOR ',') AS `free_in_country`, `films`.`number_of_viewings` AS `number_of_viewings`, `films`.`duration` AS `duration`, `films`.`ratings_average` AS `ratings_average`, `films`.`year` AS `year`, `films`.`popularity` AS `popularity`, `films`.`mass_popularity` AS `mass_popularity`, `films`.`wanted_sort` AS `wanted_sort`, UNIX_TIMESTAMP(`films`.`published_at`) AS `published_at`, `films`.`show_in_library` AS `show_in_library`, `films`.`live` AS `live`, `trailers`.`id` AS `trailer_id`, IF(trailers.id, 1, 0) AS `has_trailer`, GROUP_CONCAT(DISTINCT `reels`.`id` SEPARATOR ',') AS `id`, IF(reels.id, 1, 0) AS `has_reel`, IF(films.duration <= 40, 1, 0) AS `is_short`, GROUP_CONCAT(DISTINCT `genres`.`id` SEPARATOR ',') AS `genre_ids`, `films`.`id` AS `sphinx_internal_id`, 578162972 AS `class_crc`, '578162972' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM films    LEFT OUTER JOIN `film_translations` ON film_translations.film_id = films.id AND film_translations.`locale` = 'en-US'   LEFT OUTER JOIN `film_translations` translations_fr_frs_films ON translations_fr_frs_films.film_id = films.id AND translations_fr_frs_films.`locale` = 'fr-FR'   LEFT OUTER JOIN `film_translations` translations_it_its_films ON translations_it_its_films.film_id = films.id AND translations_it_its_films.`locale` = 'it-IT'   LEFT OUTER JOIN `film_translations` translations_de_des_films ON translations_de_des_films.film_id = films.id AND translations_de_des_films.`locale` = 'de-DE'   LEFT OUTER JOIN `film_translations` translations_es_es_films ON translations_es_es_films.film_id = films.id AND translations_es_es_films.`locale` = 'es-ES'   LEFT OUTER JOIN `film_translations` translations_pt_brs_films ON translations_pt_brs_films.film_id = films.id AND translations_pt_brs_films.`locale` = 'pt-BR'   LEFT OUTER JOIN `film_translations` translations_nl_nls_films ON translations_nl_nls_films.film_id = films.id AND translations_nl_nls_films.`locale` = 'nl-NL'   LEFT OUTER JOIN `memberships` ON (`films`.`id` = `memberships`.`film_id`)  LEFT OUTER JOIN `cast_members` ON (`cast_members`.`id` = `memberships`.`cast_member_id`) AND credit = 'Director'   LEFT OUTER JOIN `screenings` ON screenings.film_id = films.id   LEFT OUTER JOIN `authorizations` ON authorizations.film_id = films.id   LEFT OUTER JOIN `distributor_films` ON distributor_films.film_id = films.id   LEFT OUTER JOIN `trailers` ON trailers.film_id = films.id   LEFT OUTER JOIN `reels` ON reels.film_id = films.id   LEFT OUTER JOIN `film_genres` ON (`films`.`id` = `film_genres`.`film_id`)  LEFT OUTER JOIN `genres` ON (`genres`.`id` = `film_genres`.`genre_id`)  WHERE `films`.`id` >= $start   AND `films`.`id` <= $end    AND `films`.`delta` = 0 GROUP BY `films`.`id`  ORDER BY NULL
---
>   sql_query_pre = SET TIME_ZONE = '+0:00'
>   sql_query = SELECT SQL_NO_CACHE `films`.`id` * 5 + 2 AS `id` , `films`.`original_title` AS `original_title`, `films`.`imdb_id` AS `imdb_id`, `film_translations`.`sort_title` AS `sort_title_en_us`, COALESCE(`translations_fr_frs_films`.`sort_title`, `film_translations`.`sort_title`) AS `sort_title_fr_fr`, COALESCE(`translations_it_its_films`.`sort_title`, `film_translations`.`sort_title`) AS `sort_title_it_it`, COALESCE(`translations_de_des_films`.`sort_title`, `film_translations`.`sort_title`) AS `sort_title_de_de`, COALESCE(`translations_es_es_films`.`sort_title`, `film_translations`.`sort_title`) AS `sort_title_es_es`, COALESCE(`translations_pt_brs_films`.`sort_title`, `film_translations`.`sort_title`) AS `sort_title_pt_br`, COALESCE(`translations_nl_nls_films`.`sort_title`, `film_translations`.`sort_title`) AS `sort_title_nl_nl`, GROUP_CONCAT(DISTINCT IFNULL(`cast_members`.`sort_name`, '0') SEPARATOR ' ') AS `directors`, `films`.`id` AS `sphinx_internal_id`, 578162972 AS `class_crc`, 0 AS `sphinx_deleted`, IFNULL(`films`.`original_title`, '') AS `original_title_sort`, IFNULL(`films`.`imdb_id`, '') AS `imdb_id_sort`, IFNULL(`film_translations`.`sort_title`, '') AS `sort_title_en_us_sort`, IFNULL(COALESCE(`translations_fr_frs_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_fr_fr_sort`, IFNULL(COALESCE(`translations_it_its_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_it_it_sort`, IFNULL(COALESCE(`translations_de_des_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_de_de_sort`, IFNULL(COALESCE(`translations_es_es_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_es_es_sort`, IFNULL(COALESCE(`translations_pt_brs_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_pt_br_sort`, IFNULL(COALESCE(`translations_nl_nls_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_nl_nl_sort`, GROUP_CONCAT(DISTINCT IFNULL(IFNULL(`cast_members`.`sort_name`, ''), '0') SEPARATOR ' ') AS `directors_sort`, GROUP_CONCAT(DISTINCT IFNULL(`screenings`.`festival_id`, '0') SEPARATOR ',') AS `festival_id`, GROUP_CONCAT(DISTINCT CONCAT(screenings.year, screenings.festival_id) SEPARATOR ',') AS `festival_year_id`, COUNT(cast_members.id) AS `director_count`, GROUP_CONCAT(DISTINCT IFNULL(`authorizations`.`country_id`, '0') SEPARATOR ',') AS `country`, GROUP_CONCAT(DISTINCT IFNULL(`distributor_films`.`distributor_id`, '0') SEPARATOR ',') AS `distributor_id`, UNIX_TIMESTAMP(MAX(authorizations.created_at)) AS `authorized_at`, GROUP_CONCAT(CONCAT(authorizations.distributor_id, LPAD(authorizations.country_id, 3, 0)) SEPARATOR ',') AS `country_distributor_composite_id`, GROUP_CONCAT(IF(authorizations.free, authorizations.country_id, NULL) SEPARATOR ',') AS `free_in_country`, `films`.`number_of_viewings` AS `number_of_viewings`, `films`.`duration` AS `duration`, `films`.`ratings_average` AS `ratings_average`, `films`.`year` AS `year`, `films`.`popularity` AS `popularity`, `films`.`mass_popularity` AS `mass_popularity`, `films`.`wanted_sort` AS `wanted_sort`, UNIX_TIMESTAMP(`films`.`published_at`) AS `published_at`, `films`.`show_in_library` AS `show_in_library`, `films`.`live` AS `live`, `trailers`.`id` AS `trailer_id`, IF(trailers.id, 1, 0) AS `has_trailer`, GROUP_CONCAT(DISTINCT IFNULL(`reels`.`id`, '0') SEPARATOR ',') AS `id`, IF(reels.id, 1, 0) AS `has_reel`, IF(films.duration <= 40, 1, 0) AS `is_short`, GROUP_CONCAT(DISTINCT IFNULL(`genres`.`id`, '0') SEPARATOR ',') AS `genre_ids` FROM `films` LEFT OUTER JOIN `memberships` ON `films`.`id` = `memberships`.`film_id` LEFT OUTER JOIN `cast_members` ON credit = 'Director' LEFT OUTER JOIN `screenings` ON `screenings`.`film_id` = `films`.`id` LEFT OUTER JOIN `authorizations` ON `authorizations`.`film_id` = `films`.`id` LEFT OUTER JOIN `distributor_films` ON `distributor_films`.`film_id` = `films`.`id` LEFT OUTER JOIN `trailers` ON `trailers`.`film_id` = `films`.`id` LEFT OUTER JOIN `reels` ON `reels`.`film_id` = `films`.`id` LEFT OUTER JOIN `film_genres` ON `films`.`id` = `film_genres`.`film_id` LEFT OUTER JOIN `genres` ON `genres`.`id` = `film_genres`.`genre_id` WHERE (`films`.`id` >= $start AND `films`.`id` <= $end AND `films`.`delta` = 0) GROUP BY `films`.`id` ORDER BY NULL
159a160,162
>   sql_attr_uint = sphinx_internal_id
>   sql_attr_uint = class_crc
>   sql_attr_uint = sphinx_deleted
168,170d170
<   sql_attr_uint = sphinx_internal_id
<   sql_attr_uint = class_crc
<   sql_attr_uint = sphinx_deleted
197,198c197
<   sql_attr_multi = uint subclass_crcs from field
<   sql_query_info = SELECT * FROM `films` WHERE  `id` = (($id - 2) / 5)
---
>   sql_query_info = SELECT * FROM `films` WHERE `id` = (($id - 2) / 5)
205d203
<   morphology = stem_en
228c226,227
< U+00D9->u, U+00DA->u, U+00DB->u, U+00DC->u, U+00F9->u, U+00FA->u, U+00FB->u, U+00FC->u, U+010316->u, U+0168->u, U+0169->u, U+016A->u, U+016B->u, U+016C->u, U+016D->u, U+016E->u, U+016F->u, U+0170->u, U+0171->u, U+0172->u, U+0173->u, U+01AF->u, U+01B0->u, U+01D3->u, U+01D4->u, U+01D5->u, U+01D6->u, U+01D7->u, U+01D8->u, U+01D9->u, U+01DA->u, U+01DB->u, U+01DC->u, U+0214->u, U+0215->u, U+0216->u, U+0217->u, U+0244->u, U+0289->u, U+1D1C->u, U+1D1D->u, U+1D1E->u, U+1D41->u, U+1D58->u, U+1D59->u, U+1D64->u, U+1D7E->u, U+1D99->u, U+1DB6->u, U+1DB8->u, U+1E72->u, U+1E73->u, U+1E74->u, U+1E75->u, U+1E76->u, U+1E77->u, U+1E78->u, U+1E79->u, U+1E7A->u, U+1E7B->u, U+1EE4->u, U+1EE5->u, U+1EE6->u, U+1EE7->u, U+1EE8->u, U+1EE9->u, U+1EEA->u, U+1EEB->u, U+1EEC->u, U+1EED->u, U+1EEE->u, U+1EEF->u, U+1EF0->u, U+1EF1->u, \
---
> U+00D9->u, U+00DA->u, U+00DB->u, U+00DC->u, U+00F9->u, U+00FA->u, U+00FB->u, U+00FC->u, U+010316->u, U+0168->u, U+0169->u, U+016A->u, U+016B->u, U+016C->u, U+016D->u, U+016E->u, U+016F->u, U+0170->u, U+0171->u, U+0172->u, U+0173->u, U+01AF->u, U+01B0->u, U+01D3->u, U+01D4->u, U+01D5->u, U+01D6->u, U+01D7->u, U+01D8->u, U+01D9->u, U+01DA->u, U+01DB->u, U+01DC->u, U+0214->u, U+0215->u, U+0216->u, U+0217->u, U+0244->u, U+0289->u, U+1D1C->u, U+1D1D->u, U+1D1E->u, U+1D41->u, U+1D58->u, U+1D59->u, U+1D64->u, U+1D7E->u, U+1D99->u, U+1DB6->u, U+1DB8->u, U+1E72->u, U+1E\
> 73->u, U+1E74->u, U+1E75->u, U+1E76->u, U+1E77->u, U+1E78->u, U+1E79->u, U+1E7A->u, U+1E7B->u, U+1EE4->u, U+1EE5->u, U+1EE6->u, U+1EE7->u, U+1EE8->u, U+1EE9->u, U+1EEA->u, U+1EEB->u, U+1EEC->u, U+1EED->u, U+1EEE->u, U+1EEF->u, U+1EF0->u, U+1EF1->u, \
249c248,249
<   sql_query = SELECT `films`.`id` * 5 + 2 AS `id` , CAST(`films`.`original_title` AS CHAR) AS `original_title`, CAST(`films`.`imdb_id` AS CHAR) AS `imdb_id`, CAST(GROUP_CONCAT(DISTINCT `film_translations`.`title` SEPARATOR ' ') AS CHAR) AS `title_en_us`, CAST(`film_translations`.`sort_title` AS CHAR) AS `sort_title_en_us`, CAST(GROUP_CONCAT(DISTINCT `translations_fr_frs_films`.`title` SEPARATOR ' ') AS CHAR) AS `title_fr_fr`, CAST(COALESCE(`translations_fr_frs_films`.`sort_title`, `film_translations`.`sort_title`) AS CHAR) AS `sort_title_fr_fr`, CAST(GROUP_CONCAT(DISTINCT `translations_it_its_films`.`title` SEPARATOR ' ') AS CHAR) AS `title_it_it`, CAST(COALESCE(`translations_it_its_films`.`sort_title`, `film_translations`.`sort_title`) AS CHAR) AS `sort_title_it_it`, CAST(GROUP_CONCAT(DISTINCT `translations_de_des_films`.`title` SEPARATOR ' ') AS CHAR) AS `title_de_de`, CAST(COALESCE(`translations_de_des_films`.`sort_title`, `film_translations`.`sort_title`) AS CHAR) AS `sort_title_de_de`, CAST(GROUP_CONCAT(DISTINCT `translations_es_es_films`.`title` SEPARATOR ' ') AS CHAR) AS `title_es_es`, CAST(COALESCE(`translations_es_es_films`.`sort_title`, `film_translations`.`sort_title`) AS CHAR) AS `sort_title_es_es`, CAST(GROUP_CONCAT(DISTINCT `translations_pt_brs_films`.`title` SEPARATOR ' ') AS CHAR) AS `title_pt_br`, CAST(COALESCE(`translations_pt_brs_films`.`sort_title`, `film_translations`.`sort_title`) AS CHAR) AS `sort_title_pt_br`, CAST(GROUP_CONCAT(DISTINCT `translations_nl_nls_films`.`title` SEPARATOR ' ') AS CHAR) AS `title_nl_nl`, CAST(COALESCE(`translations_nl_nls_films`.`sort_title`, `film_translations`.`sort_title`) AS CHAR) AS `sort_title_nl_nl`, CAST(GROUP_CONCAT(DISTINCT `cast_members`.`sort_name` SEPARATOR ' ') AS CHAR) AS `directors`, IFNULL(`films`.`original_title`, '') AS `original_title_sort`, IFNULL(`films`.`imdb_id`, '') AS `imdb_id_sort`, IFNULL(`film_translations`.`sort_title`, '') AS `sort_title_en_us_sort`, IFNULL(COALESCE(`translations_fr_frs_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_fr_fr_sort`, IFNULL(COALESCE(`translations_it_its_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_it_it_sort`, IFNULL(COALESCE(`translations_de_des_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_de_de_sort`, IFNULL(COALESCE(`translations_es_es_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_es_es_sort`, IFNULL(COALESCE(`translations_pt_brs_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_pt_br_sort`, IFNULL(COALESCE(`translations_nl_nls_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_nl_nl_sort`, IFNULL(GROUP_CONCAT(DISTINCT `cast_members`.`sort_name` SEPARATOR ' '), '') AS `directors_sort`, GROUP_CONCAT(DISTINCT `screenings`.`festival_id` SEPARATOR ',') AS `festival_id`, GROUP_CONCAT(DISTINCT CONCAT(screenings.year, screenings.festival_id) SEPARATOR ',') AS `festival_year_id`, COUNT(cast_members.id) AS `director_count`, GROUP_CONCAT(DISTINCT `authorizations`.`country_id` SEPARATOR ',') AS `country`, GROUP_CONCAT(DISTINCT `distributor_films`.`distributor_id` SEPARATOR ',') AS `distributor_id`, UNIX_TIMESTAMP(MAX(authorizations.created_at)) AS `authorized_at`, GROUP_CONCAT(CONCAT(authorizations.distributor_id, LPAD(authorizations.country_id, 3, 0)) SEPARATOR ',') AS `country_distributor_composite_id`, GROUP_CONCAT(IF(authorizations.free, authorizations.country_id, NULL) SEPARATOR ',') AS `free_in_country`, `films`.`number_of_viewings` AS `number_of_viewings`, `films`.`duration` AS `duration`, `films`.`ratings_average` AS `ratings_average`, `films`.`year` AS `year`, `films`.`popularity` AS `popularity`, `films`.`mass_popularity` AS `mass_popularity`, `films`.`wanted_sort` AS `wanted_sort`, UNIX_TIMESTAMP(`films`.`published_at`) AS `published_at`, `films`.`show_in_library` AS `show_in_library`, `films`.`live` AS `live`, `trailers`.`id` AS `trailer_id`, IF(trailers.id, 1, 0) AS `has_trailer`, GROUP_CONCAT(DISTINCT `reels`.`id` SEPARATOR ',') AS `id`, IF(reels.id, 1, 0) AS `has_reel`, IF(films.duration <= 40, 1, 0) AS `is_short`, GROUP_CONCAT(DISTINCT `genres`.`id` SEPARATOR ',') AS `genre_ids`, `films`.`id` AS `sphinx_internal_id`, 578162972 AS `class_crc`, '578162972' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM films    LEFT OUTER JOIN `film_translations` ON film_translations.film_id = films.id AND film_translations.`locale` = 'en-US'   LEFT OUTER JOIN `film_translations` translations_fr_frs_films ON translations_fr_frs_films.film_id = films.id AND translations_fr_frs_films.`locale` = 'fr-FR'   LEFT OUTER JOIN `film_translations` translations_it_its_films ON translations_it_its_films.film_id = films.id AND translations_it_its_films.`locale` = 'it-IT'   LEFT OUTER JOIN `film_translations` translations_de_des_films ON translations_de_des_films.film_id = films.id AND translations_de_des_films.`locale` = 'de-DE'   LEFT OUTER JOIN `film_translations` translations_es_es_films ON translations_es_es_films.film_id = films.id AND translations_es_es_films.`locale` = 'es-ES'   LEFT OUTER JOIN `film_translations` translations_pt_brs_films ON translations_pt_brs_films.film_id = films.id AND translations_pt_brs_films.`locale` = 'pt-BR'   LEFT OUTER JOIN `film_translations` translations_nl_nls_films ON translations_nl_nls_films.film_id = films.id AND translations_nl_nls_films.`locale` = 'nl-NL'   LEFT OUTER JOIN `memberships` ON (`films`.`id` = `memberships`.`film_id`)  LEFT OUTER JOIN `cast_members` ON (`cast_members`.`id` = `memberships`.`cast_member_id`) AND credit = 'Director'   LEFT OUTER JOIN `screenings` ON screenings.film_id = films.id   LEFT OUTER JOIN `authorizations` ON authorizations.film_id = films.id   LEFT OUTER JOIN `distributor_films` ON distributor_films.film_id = films.id   LEFT OUTER JOIN `trailers` ON trailers.film_id = films.id   LEFT OUTER JOIN `reels` ON reels.film_id = films.id   LEFT OUTER JOIN `film_genres` ON (`films`.`id` = `film_genres`.`film_id`)  LEFT OUTER JOIN `genres` ON (`genres`.`id` = `film_genres`.`genre_id`)  WHERE `films`.`id` >= $start   AND `films`.`id` <= $end    AND `films`.`delta` = 1 GROUP BY `films`.`id`  ORDER BY NULL
---
>   sql_query_pre = SET TIME_ZONE = '+0:00'
>   sql_query = SELECT SQL_NO_CACHE `films`.`id` * 5 + 2 AS `id` , `films`.`original_title` AS `original_title`, `films`.`imdb_id` AS `imdb_id`, `film_translations`.`sort_title` AS `sort_title_en_us`, COALESCE(`translations_fr_frs_films`.`sort_title`, `film_translations`.`sort_title`) AS `sort_title_fr_fr`, COALESCE(`translations_it_its_films`.`sort_title`, `film_translations`.`sort_title`) AS `sort_title_it_it`, COALESCE(`translations_de_des_films`.`sort_title`, `film_translations`.`sort_title`) AS `sort_title_de_de`, COALESCE(`translations_es_es_films`.`sort_title`, `film_translations`.`sort_title`) AS `sort_title_es_es`, COALESCE(`translations_pt_brs_films`.`sort_title`, `film_translations`.`sort_title`) AS `sort_title_pt_br`, COALESCE(`translations_nl_nls_films`.`sort_title`, `film_translations`.`sort_title`) AS `sort_title_nl_nl`, GROUP_CONCAT(DISTINCT IFNULL(`cast_members`.`sort_name`, '0') SEPARATOR ' ') AS `directors`, `films`.`id` AS `sphinx_internal_id`, 578162972 AS `class_crc`, 0 AS `sphinx_deleted`, IFNULL(`films`.`original_title`, '') AS `original_title_sort`, IFNULL(`films`.`imdb_id`, '') AS `imdb_id_sort`, IFNULL(`film_translations`.`sort_title`, '') AS `sort_title_en_us_sort`, IFNULL(COALESCE(`translations_fr_frs_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_fr_fr_sort`, IFNULL(COALESCE(`translations_it_its_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_it_it_sort`, IFNULL(COALESCE(`translations_de_des_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_de_de_sort`, IFNULL(COALESCE(`translations_es_es_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_es_es_sort`, IFNULL(COALESCE(`translations_pt_brs_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_pt_br_sort`, IFNULL(COALESCE(`translations_nl_nls_films`.`sort_title`, `film_translations`.`sort_title`), '') AS `sort_title_nl_nl_sort`, GROUP_CONCAT(DISTINCT IFNULL(IFNULL(`cast_members`.`sort_name`, ''), '0') SEPARATOR ' ') AS `directors_sort`, GROUP_CONCAT(DISTINCT IFNULL(`screenings`.`festival_id`, '0') SEPARATOR ',') AS `festival_id`, GROUP_CONCAT(DISTINCT CONCAT(screenings.year, screenings.festival_id) SEPARATOR ',') AS `festival_year_id`, COUNT(cast_members.id) AS `director_count`, GROUP_CONCAT(DISTINCT IFNULL(`authorizations`.`country_id`, '0') SEPARATOR ',') AS `country`, GROUP_CONCAT(DISTINCT IFNULL(`distributor_films`.`distributor_id`, '0') SEPARATOR ',') AS `distributor_id`, UNIX_TIMESTAMP(MAX(authorizations.created_at)) AS `authorized_at`, GROUP_CONCAT(CONCAT(authorizations.distributor_id, LPAD(authorizations.country_id, 3, 0)) SEPARATOR ',') AS `country_distributor_composite_id`, GROUP_CONCAT(IF(authorizations.free, authorizations.country_id, NULL) SEPARATOR ',') AS `free_in_country`, `films`.`number_of_viewings` AS `number_of_viewings`, `films`.`duration` AS `duration`, `films`.`ratings_average` AS `ratings_average`, `films`.`year` AS `year`, `films`.`popularity` AS `popularity`, `films`.`mass_popularity` AS `mass_popularity`, `films`.`wanted_sort` AS `wanted_sort`, UNIX_TIMESTAMP(`films`.`published_at`) AS `published_at`, `films`.`show_in_library` AS `show_in_library`, `films`.`live` AS `live`, `trailers`.`id` AS `trailer_id`, IF(trailers.id, 1, 0) AS `has_trailer`, GROUP_CONCAT(DISTINCT IFNULL(`reels`.`id`, '0') SEPARATOR ',') AS `id`, IF(reels.id, 1, 0) AS `has_reel`, IF(films.duration <= 40, 1, 0) AS `is_short`, GROUP_CONCAT(DISTINCT IFNULL(`genres`.`id`, '0') SEPARATOR ',') AS `genre_ids` FROM `films` LEFT OUTER JOIN `memberships` ON `films`.`id` = `memberships`.`film_id` LEFT OUTER JOIN `cast_members` ON credit = 'Director' LEFT OUTER JOIN `screenings` ON `screenings`.`film_id` = `films`.`id` LEFT OUTER JOIN `authorizations` ON `authorizations`.`film_id` = `films`.`id` LEFT OUTER JOIN `distributor_films` ON `distributor_films`.`film_id` = `films`.`id` LEFT OUTER JOIN `trailers` ON `trailers`.`film_id` = `films`.`id` LEFT OUTER JOIN `reels` ON `reels`.`film_id` = `films`.`id` LEFT OUTER JOIN `film_genres` ON `films`.`id` = `film_genres`.`film_id` LEFT OUTER JOIN `genres` ON `genres`.`id` = `film_genres`.`genre_id` WHERE (`films`.`id` >= $start AND `films`.`id` <= $end AND `films`.`delta` = 1) GROUP BY `films`.`id` ORDER BY NULL
250a251,254
>   sql_range_step = 999999999
>   sql_attr_uint = sphinx_internal_id
>   sql_attr_uint = class_crc
>   sql_attr_uint = sphinx_deleted
259,261d262
<   sql_attr_uint = sphinx_internal_id
<   sql_attr_uint = class_crc
<   sql_attr_uint = sphinx_deleted
288,289c289
<   sql_attr_multi = uint subclass_crcs from field
<   sql_query_info = SELECT * FROM `films` WHERE  `id` = (($id - 2) / 5)
---
>   sql_query_info = SELECT * FROM `films` WHERE `id` = (($id - 2) / 5)
314c314,315
<   sql_query = SELECT `genres`.`id` * 5 + 3 AS `id` , CAST(`genres`.`name` AS CHAR) AS `name`, IFNULL(`genres`.`name`, '') AS `name_sort`, `genres`.`id` AS `sphinx_internal_id`, 1116806396 AS `class_crc`, '1116806396' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM genres    WHERE `genres`.`id` >= $start   AND `genres`.`id` <= $end    GROUP BY `genres`.`id`  ORDER BY NULL
---
>   sql_query_pre = SET TIME_ZONE = '+0:00'
>   sql_query = SELECT SQL_NO_CACHE `genres`.`id` * 5 + 3 AS `id` , `genres`.`name` AS `name`, `genres`.`id` AS `sphinx_internal_id`, 1116806396 AS `class_crc`, 0 AS `sphinx_deleted`, IFNULL(`genres`.`name`, '') AS `name_sort` FROM `genres` WHERE (`genres`.`id` >= $start AND `genres`.`id` <= $end) GROUP BY `genres`.`id` ORDER BY NULL
321,322c322
<   sql_attr_multi = uint subclass_crcs from field
<   sql_query_info = SELECT * FROM `genres` WHERE  `id` = (($id - 3) / 5)
---
>   sql_query_info = SELECT * FROM `genres` WHERE `id` = (($id - 3) / 5)
329d328
<   morphology = stem_en
352c351,352
< U+00D9->u, U+00DA->u, U+00DB->u, U+00DC->u, U+00F9->u, U+00FA->u, U+00FB->u, U+00FC->u, U+010316->u, U+0168->u, U+0169->u, U+016A->u, U+016B->u, U+016C->u, U+016D->u, U+016E->u, U+016F->u, U+0170->u, U+0171->u, U+0172->u, U+0173->u, U+01AF->u, U+01B0->u, U+01D3->u, U+01D4->u, U+01D5->u, U+01D6->u, U+01D7->u, U+01D8->u, U+01D9->u, U+01DA->u, U+01DB->u, U+01DC->u, U+0214->u, U+0215->u, U+0216->u, U+0217->u, U+0244->u, U+0289->u, U+1D1C->u, U+1D1D->u, U+1D1E->u, U+1D41->u, U+1D58->u, U+1D59->u, U+1D64->u, U+1D7E->u, U+1D99->u, U+1DB6->u, U+1DB8->u, U+1E72->u, U+1E73->u, U+1E74->u, U+1E75->u, U+1E76->u, U+1E77->u, U+1E78->u, U+1E79->u, U+1E7A->u, U+1E7B->u, U+1EE4->u, U+1EE5->u, U+1EE6->u, U+1EE7->u, U+1EE8->u, U+1EE9->u, U+1EEA->u, U+1EEB->u, U+1EEC->u, U+1EED->u, U+1EEE->u, U+1EEF->u, U+1EF0->u, U+1EF1->u, \
---
> U+00D9->u, U+00DA->u, U+00DB->u, U+00DC->u, U+00F9->u, U+00FA->u, U+00FB->u, U+00FC->u, U+010316->u, U+0168->u, U+0169->u, U+016A->u, U+016B->u, U+016C->u, U+016D->u, U+016E->u, U+016F->u, U+0170->u, U+0171->u, U+0172->u, U+0173->u, U+01AF->u, U+01B0->u, U+01D3->u, U+01D4->u, U+01D5->u, U+01D6->u, U+01D7->u, U+01D8->u, U+01D9->u, U+01DA->u, U+01DB->u, U+01DC->u, U+0214->u, U+0215->u, U+0216->u, U+0217->u, U+0244->u, U+0289->u, U+1D1C->u, U+1D1D->u, U+1D1E->u, U+1D41->u, U+1D58->u, U+1D59->u, U+1D64->u, U+1D7E->u, U+1D99->u, U+1DB6->u, U+1DB8->u, U+1E72->u, U+1E\
> 73->u, U+1E74->u, U+1E75->u, U+1E76->u, U+1E77->u, U+1E78->u, U+1E79->u, U+1E7A->u, U+1E7B->u, U+1EE4->u, U+1EE5->u, U+1EE6->u, U+1EE7->u, U+1EE8->u, U+1EE9->u, U+1EEA->u, U+1EEB->u, U+1EEC->u, U+1EED->u, U+1EEE->u, U+1EEF->u, U+1EF0->u, U+1EF1->u, \
378c378,379
<   sql_query = SELECT `users`.`id` * 5 + 4 AS `id` , CAST(`users`.`id` AS CHAR) AS `id`, CAST(`users`.`email` AS CHAR) AS `email`, CAST(`users`.`full_name` AS CHAR) AS `full_name`, CAST(`users`.`username` AS CHAR) AS `username`, IFNULL(`users`.`id`, '') AS `id_sort`, IFNULL(`users`.`email`, '') AS `email_sort`, IFNULL(`users`.`full_name`, '') AS `full_name_sort`, IFNULL(`users`.`username`, '') AS `username_sort`, `users`.`id` AS `sphinx_internal_id`, 765557111 AS `class_crc`, '765557111' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM users    WHERE `users`.`id` >= $start   AND `users`.`id` <= $end    GROUP BY `users`.`id`  ORDER BY NULL
---
>   sql_query_pre = SET TIME_ZONE = '+0:00'
>   sql_query = SELECT SQL_NO_CACHE `users`.`id` * 5 + 4 AS `id` , `users`.`id` AS `id`, `users`.`email` AS `email`, `users`.`full_name` AS `full_name`, `users`.`username` AS `username`, `users`.`id` AS `sphinx_internal_id`, 765557111 AS `class_crc`, 0 AS `sphinx_deleted`, IFNULL(`users`.`id`, '') AS `id_sort`, IFNULL(`users`.`email`, '') AS `email_sort`, IFNULL(`users`.`full_name`, '') AS `full_name_sort`, IFNULL(`users`.`username`, '') AS `username_sort` FROM `users` WHERE (`users`.`id` >= $start AND `users`.`id` <= $end) GROUP BY `users`.`id` ORDER BY NULL
388,389c389
<   sql_attr_multi = uint subclass_crcs from field
<   sql_query_info = SELECT * FROM `users` WHERE  `id` = (($id - 4) / 5)
---
>   sql_query_info = SELECT * FROM `users` WHERE `id` = (($id - 4) / 5)
396d395
<   morphology = stem_en
419c418,419
< U+00D9->u, U+00DA->u, U+00DB->u, U+00DC->u, U+00F9->u, U+00FA->u, U+00FB->u, U+00FC->u, U+010316->u, U+0168->u, U+0169->u, U+016A->u, U+016B->u, U+016C->u, U+016D->u, U+016E->u, U+016F->u, U+0170->u, U+0171->u, U+0172->u, U+0173->u, U+01AF->u, U+01B0->u, U+01D3->u, U+01D4->u, U+01D5->u, U+01D6->u, U+01D7->u, U+01D8->u, U+01D9->u, U+01DA->u, U+01DB->u, U+01DC->u, U+0214->u, U+0215->u, U+0216->u, U+0217->u, U+0244->u, U+0289->u, U+1D1C->u, U+1D1D->u, U+1D1E->u, U+1D41->u, U+1D58->u, U+1D59->u, U+1D64->u, U+1D7E->u, U+1D99->u, U+1DB6->u, U+1DB8->u, U+1E72->u, U+1E73->u, U+1E74->u, U+1E75->u, U+1E76->u, U+1E77->u, U+1E78->u, U+1E79->u, U+1E7A->u, U+1E7B->u, U+1EE4->u, U+1EE5->u, U+1EE6->u, U+1EE7->u, U+1EE8->u, U+1EE9->u, U+1EEA->u, U+1EEB->u, U+1EEC->u, U+1EED->u, U+1EEE->u, U+1EEF->u, U+1EF0->u, U+1EF1->u, \
---
> U+00D9->u, U+00DA->u, U+00DB->u, U+00DC->u, U+00F9->u, U+00FA->u, U+00FB->u, U+00FC->u, U+010316->u, U+0168->u, U+0169->u, U+016A->u, U+016B->u, U+016C->u, U+016D->u, U+016E->u, U+016F->u, U+0170->u, U+0171->u, U+0172->u, U+0173->u, U+01AF->u, U+01B0->u, U+01D3->u, U+01D4->u, U+01D5->u, U+01D6->u, U+01D7->u, U+01D8->u, U+01D9->u, U+01DA->u, U+01DB->u, U+01DC->u, U+0214->u, U+0215->u, U+0216->u, U+0217->u, U+0244->u, U+0289->u, U+1D1C->u, U+1D1D->u, U+1D1E->u, U+1D41->u, U+1D58->u, U+1D59->u, U+1D64->u, U+1D7E->u, U+1D99->u, U+1DB6->u, U+1DB8->u, U+1E72->u, U+1E\
> 73->u, U+1E74->u, U+1E75->u, U+1E76->u, U+1E77->u, U+1E78->u, U+1E79->u, U+1E7A->u, U+1E7B->u, U+1EE4->u, U+1EE5->u, U+1EE6->u, U+1EE7->u, U+1EE8->u, U+1EE9->u, U+1EEA->u, U+1EEB->u, U+1EEC->u, U+1EED->u, U+1EEE->u, U+1EEF->u, U+1EF0->u, U+1EF1->u, \