# events[].sql_query.sql
SELECT "screened_ip_addresses".* FROM "screened_ip_addresses" WHERE ('99.232.23.181' <<= ip_address) LIMIT 1

# events[].sql_query.normalized_sql
SELECT "screened_ip_addresses".* FROM "screened_ip_addresses" WHERE ($1 <<= ip_address) LIMIT $2

# events[].sql_query.sql
SELECT "screened_emails".* FROM "screened_emails" ORDER BY "screened_emails"."created_at" DESC LIMIT 100

# events[].sql_query.normalized_sql
SELECT "screened_emails".* FROM "screened_emails" ORDER BY "screened_emails"."created_at" DESC LIMIT $1

# events[].sql_query.sql
SELECT 1 AS one FROM "user_emails" WHERE (lower(email) = 'anne861@discourse.org') LIMIT 1

# events[].sql_query.normalized_sql
SELECT $1 AS one FROM "user_emails" WHERE (lower(email) = $2) LIMIT $3

# events[].sql_query.normalized_sql
INSERT INTO "users" ("username", "created_at", "updated_at", "name", "password_hash", "salt", "active", "username_lower", "admin", "trust_level", "ip_address") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11) RETURNING "id"

# events[].sql_query.sql
SELECT "screened_emails".* FROM "screened_emails" ORDER BY "screened_emails"."created_at" DESC LIMIT 100

# events[].sql_query.normalized_sql
SELECT "screened_emails".* FROM "screened_emails" ORDER BY "screened_emails"."created_at" DESC LIMIT $1

# events[].sql_query.sql
SELECT 1 AS one FROM "user_emails" WHERE "user_emails"."primary" = TRUE AND "user_emails"."user_id" = 949 LIMIT 1

# events[].sql_query.normalized_sql
SELECT $1 AS one FROM "user_emails" WHERE "user_emails"."primary" = $2 AND "user_emails"."user_id" = $3 LIMIT $4

# events[].sql_query.sql
SELECT 1 AS one FROM "user_emails" WHERE (lower(email) = 'anne861@discourse.org') LIMIT 1

# events[].sql_query.normalized_sql
SELECT $1 AS one FROM "user_emails" WHERE (lower(email) = $2) LIMIT $3

# events[].sql_query.normalized_sql
INSERT INTO "user_emails" ("user_id", "email", "primary", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id"

# events[].sql_query.normalized_sql
INSERT INTO "email_tokens" ("user_id", "email", "token", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id"

# events[].sql_query.sql
UPDATE "email_tokens" SET "expired" = TRUE WHERE "email_tokens"."user_id" = 949 AND (id != 982)

# events[].sql_query.normalized_sql
UPDATE "email_tokens" SET "expired" = $1 WHERE "email_tokens"."user_id" = $2 AND (id != $3)

# events[].sql_query.normalized_sql
INSERT INTO "user_stats" ("user_id", "new_since") VALUES ($1, $2) RETURNING "user_id"

# events[].sql_query.sql
SELECT "users".* FROM "users" WHERE "users"."id" = 949 LIMIT 1

# events[].sql_query.normalized_sql
SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2

# events[].sql_query.sql
UPDATE "topic_users" SET notification_level = CASE WHEN total_msecs_viewed < 240000 THEN 1 ELSE 2 END WHERE "topic_users"."notifications_reason_id" IS NULL AND "topic_users"."user_id" = 949

# events[].sql_query.normalized_sql
UPDATE "topic_users" SET notification_level = CASE WHEN total_msecs_viewed < $1 THEN $2 ELSE $3 END WHERE "topic_users"."notifications_reason_id" IS NULL AND "topic_users"."user_id" = $4

# events[].sql_query.sql
SELECT "users".* FROM "users" WHERE "users"."id" = 949 LIMIT 1

# events[].sql_query.normalized_sql
SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2

# events[].sql_query.sql
INSERT INTO "user_profiles" ("user_id") VALUES (949) RETURNING "user_id"

# events[].sql_query.normalized_sql
INSERT INTO "user_profiles" ("user_id") VALUES ($1) RETURNING "user_id"

# events[].parameters[].value
{:user=>#<UserProfile user_id: 949, location: nil, website: nil, bio_raw: nil, bio_cooked: nil, dism

# events[].sql_query.sql
SELECT "tags"."id" FROM "tags" WHERE 1=0

# events[].sql_query.normalized_sql
SELECT "tags"."id" FROM "tags" WHERE $1=$2

# events[].sql_query.sql
SELECT "tags"."id" FROM "tags" WHERE 1=0

# events[].sql_query.normalized_sql
SELECT "tags"."id" FROM "tags" WHERE $1=$2

# events[].sql_query.sql
SELECT "tags"."id" FROM "tags" WHERE 1=0

# events[].sql_query.normalized_sql
SELECT "tags"."id" FROM "tags" WHERE $1=$2

# events[].sql_query.sql
SELECT "tags"."id" FROM "tags" WHERE 1=0

# events[].sql_query.normalized_sql
SELECT "tags"."id" FROM "tags" WHERE $1=$2

# events[].sql_query.sql
SELECT "user_avatars".* FROM "user_avatars" WHERE "user_avatars"."user_id" = 949 LIMIT 1

# events[].sql_query.normalized_sql
SELECT "user_avatars".* FROM "user_avatars" WHERE "user_avatars"."user_id" = $1 LIMIT $2

# events[].sql_query.normalized_sql
INSERT INTO "user_avatars" ("user_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id"

# events[].sql_query.sql
SELECT 1 AS one FROM "web_hooks" INNER JOIN "web_hook_event_types_hooks" ON "web_hook_event_types_hooks"."web_hook_id" = "web_hooks"."id" INNER JOIN "web_hook_event_types" ON "web_hook_event_types"."id" = "web_hook_event_types_hooks"."web_hook_event_type_id" WHERE "web_hooks"."active" = TRUE AND (web_hooks.wildcard_web_hook = TRUE OR web_hook_event_types.name = 'user') LIMIT 1

# events[].sql_query.normalized_sql
SELECT $1 AS one FROM "web_hooks" INNER JOIN "web_hook_event_types_hooks" ON "web_hook_event_types_hooks"."web_hook_id" = "web_hooks"."id" INNER JOIN "web_hook_event_types" ON "web_hook_event_types"."id" = "web_hook_event_types_hooks"."web_hook_event_type_id" WHERE "web_hooks"."active" = $2 AND (web_hooks.wildcard_web_hook = $3 OR web_hook_event_types.name = $4) LIMIT $5

# events[].sql_query.sql
SELECT COUNT(*) FROM (SELECT 1 AS one FROM "topics" WHERE ("topics"."deleted_at" IS NULL) LIMIT 16) subquery_for_count

# events[].sql_query.normalized_sql
SELECT COUNT(*) FROM (SELECT $1 AS one FROM "topics" WHERE ("topics"."deleted_at" IS NULL) LIMIT $2) subquery_for_count

# events[].sql_query.sql
SELECT "users"."id" FROM "users" INNER JOIN "user_auth_tokens" ON "user_auth_tokens"."user_id" = "users"."id" WHERE "users"."admin" = TRUE AND (users.id > 0) ORDER BY user_auth_tokens.created_at LIMIT 1

# events[].sql_query.normalized_sql
SELECT "users"."id" FROM "users" INNER JOIN "user_auth_tokens" ON "user_auth_tokens"."user_id" = "users"."id" WHERE "users"."admin" = $1 AND (users.id > $2) ORDER BY user_auth_tokens.created_at LIMIT $3

# events[].sql_query.sql
SELECT "color_schemes".* FROM "color_schemes" WHERE "color_schemes"."id" = -1 LIMIT 1

# events[].sql_query.normalized_sql
SELECT "color_schemes".* FROM "color_schemes" WHERE "color_schemes"."id" = $1 LIMIT $2

# events[].sql_query.sql
SELECT categories.*, t.slug topic_slug FROM "categories" LEFT JOIN topics t on t.id = categories.topic_id WHERE (NOT categories.read_restricted) ORDER BY "categories"."position" ASC

# events[].sql_query.normalized_sql
SELECT categories.*, t.slug topic_slug FROM "categories" LEFT JOIN topics t on t.id = categories.topic_id WHERE (NOT categories.read_restricted) ORDER BY "categories"."position" ASC

# events[].return_value.value
[#<Category id: 1, name: "Uncategorized", color: "0088CC", topic_id: nil, topic_count: 0, created_at

# events[].return_value.value
Topics that don't need a category, or don't fit into any other existing category.

# events[].return_value.value
Topics that don't need a category, or don't fit into any other existing category.

# events[].return_value.value
Topics that don't need a category, or don't fit into any other existing category.

# events[].sql_query.sql
SELECT "user_fields".* FROM "user_fields" ORDER BY "user_fields"."position" ASC

# events[].sql_query.normalized_sql
SELECT "user_fields".* FROM "user_fields" ORDER BY "user_fields"."position" ASC

# events[].sql_query.sql
SELECT "users".* FROM "users" WHERE "users"."admin" = TRUE AND (users.id > 0) ORDER BY last_seen_at DESC

# events[].sql_query.normalized_sql
SELECT "users".* FROM "users" WHERE "users"."admin" = $1 AND (users.id > $2) ORDER BY last_seen_at DESC

# events[].sql_query.sql
SELECT COUNT(*) FROM "users" WHERE "users"."moderator" = TRUE AND "users"."admin" = FALSE AND (users.id > 0)

# events[].sql_query.normalized_sql
SELECT COUNT(*) FROM "users" WHERE "users"."moderator" = $1 AND "users"."admin" = $2 AND (users.id > $3)

# events[].return_value.value
About - Discourse

# events[].return_value.value
About - Discourse

# metadata.name
AboutController .index crawler view should include correct user URLs