Skip to content

Instantly share code, notes, and snippets.

@slumos
Created May 1, 2009 03:31
Show Gist options
  • Save slumos/104853 to your computer and use it in GitHub Desktop.
Save slumos/104853 to your computer and use it in GitHub Desktop.
SELECT /*ffs_production.users:2754/7344*/
2753 AS chunk_num,
COUNT(*) AS cnt,
LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `id`,
`facebook_session_key`, `facebook_uid`, `created_at`, `updated_at`,
`active_at`, `last_refreshed_at`, `sex`, `birthday`, `cash`, `value`,
`ownerships_count`, `description`, `last_logged_in_at`, `show_help`,
`installed_at`, `uninstalled_at`, `installed`, `nickname`, `admin`,
`owner_facebook_uid`, `owner_user_id`, `network_id_0`, `network_id_1`,
`network_id_2`, `network_id_3`, `network_id_4`,
CONCAT(ISNULL(`facebook_session_key`),
ISNULL(`facebook_uid`), ISNULL(`created_at`),
ISNULL(`updated_at`), ISNULL(`active_at`),
ISNULL(`last_refreshed_at`), ISNULL(`sex`),
ISNULL(`birthday`), ISNULL(`cash`), ISNULL(`value`),
ISNULL(`ownerships_count`), ISNULL(`description`),
ISNULL(`last_logged_in_at`), ISNULL(`show_help`),
ISNULL(`installed_at`), ISNULL(`uninstalled_at`),
ISNULL(`installed`), ISNULL(`nickname`), ISNULL(`admin`),
ISNULL(`owner_facebook_uid`), ISNULL(`owner_user_id`),
ISNULL(`network_id_0`), ISNULL(`network_id_1`),
ISNULL(`network_id_2`), ISNULL(`network_id_3`),
ISNULL(`network_id_4`)))) AS UNSIGNED)), 10, 16)) AS crc
FROM `ffs_production`.`users`
USE INDEX (`PRIMARY`)
WHERE (`id` >= 45887005 AND `id` < 45903673)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment