# events[].sql_query.sql
SELECT "spree_stores".* FROM "spree_stores" WHERE ("spree_stores"."url" = ? OR "spree_stores"."default" = ?) ORDER BY "spree_stores"."default" ASC LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_stores".* FROM "spree_stores" WHERE ("spree_stores"."url" = ? OR "spree_stores"."default" = ?) ORDER BY "spree_stores"."default" ASC LIMIT ?

# events[].sql_query.sql
SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."completed_at" IS NULL AND "spree_orders"."currency" = ? AND "spree_orders"."guest_token" = ? AND "spree_orders"."store_id" = ? AND "spree_orders"."user_id" IS NULL LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."completed_at" IS NULL AND "spree_orders"."currency" = ? AND "spree_orders"."guest_token" = ? AND "spree_orders"."store_id" = ? AND "spree_orders"."user_id" IS NULL LIMIT ?

# events[].sql_query.sql
INSERT INTO "spree_order_mutexes" ("order_id", "created_at") VALUES (?, ?)

# events[].sql_query.normalized_sql
INSERT INTO "spree_order_mutexes" ("order_id", "created_at") VALUES (?, ?)

# events[].sql_query.sql
SELECT "spree_line_items".* FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? AND "spree_line_items"."id" = ? ORDER BY "spree_line_items"."created_at" ASC, "spree_line_items"."id" ASC

# events[].sql_query.normalized_sql
SELECT "spree_line_items".* FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? AND "spree_line_items"."id" = ? ORDER BY "spree_line_items"."created_at" ASC, "spree_line_items"."id" ASC

# events[].sql_query.sql
SELECT "spree_stores".* FROM "spree_stores" WHERE "spree_stores"."id" = ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_stores".* FROM "spree_stores" WHERE "spree_stores"."id" = ? LIMIT ?

# events[].sql_query.sql
SELECT 1 AS one FROM "spree_orders" WHERE "spree_orders"."number" = ? AND "spree_orders"."id" != ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT $1 AS one FROM "spree_orders" WHERE "spree_orders"."number" = ? AND "spree_orders"."id" != ? LIMIT ?

# events[].sql_query.sql
SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."state" = ? ORDER BY "spree_payments"."created_at" ASC

# events[].sql_query.normalized_sql
SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."state" = ? ORDER BY "spree_payments"."created_at" ASC

# events[].sql_query.sql
SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."iso" IS NULL LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."iso" IS NULL LIMIT ?

# events[].sql_query.sql
SELECT 1 AS one FROM "spree_orders" WHERE "spree_orders"."number" = ? AND "spree_orders"."id" != ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT $1 AS one FROM "spree_orders" WHERE "spree_orders"."number" = ? AND "spree_orders"."id" != ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_promotions".* FROM "spree_promotions" WHERE "spree_promotions"."apply_automatically" = ? AND ("spree_promotions"."starts_at" IS NULL OR "spree_promotions"."starts_at" < $1) AND ("spree_promotions"."expires_at" IS NULL OR "spree_promotions"."expires_at" > $2)

# events[].sql_query.sql
UPDATE "spree_orders" SET "shipment_total" = ? WHERE "spree_orders"."id" = ?

# events[].sql_query.normalized_sql
UPDATE "spree_orders" SET "shipment_total" = ? WHERE "spree_orders"."id" = ?

# events[].sql_query.sql
SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."state" = ? ORDER BY "spree_payments"."created_at" ASC

# events[].sql_query.normalized_sql
SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."state" = ? ORDER BY "spree_payments"."created_at" ASC

# events[].sql_query.sql
SELECT 1 AS one FROM "spree_orders" WHERE "spree_orders"."number" = ? AND "spree_orders"."id" != ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT $1 AS one FROM "spree_orders" WHERE "spree_orders"."number" = ? AND "spree_orders"."id" != ? LIMIT ?

# events[].sql_query.sql
SELECT 1 AS one FROM "spree_orders" WHERE "spree_orders"."number" = ? AND "spree_orders"."id" != ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT $1 AS one FROM "spree_orders" WHERE "spree_orders"."number" = ? AND "spree_orders"."id" != ? LIMIT ?

# events[].sql_query.sql
UPDATE "spree_orders" SET "state" = ?, "updated_at" = ? WHERE "spree_orders"."id" = ?

# events[].sql_query.normalized_sql
UPDATE "spree_orders" SET "state" = ?, "updated_at" = ? WHERE "spree_orders"."id" = ?

# events[].sql_query.sql
INSERT INTO "spree_state_changes" ("name", "previous_state", "stateful_id", "stateful_type", "next_state", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)

# events[].sql_query.normalized_sql
INSERT INTO "spree_state_changes" ("name", "previous_state", "stateful_id", "stateful_type", "next_state", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)

# events[].sql_query.sql
SELECT 1 AS one FROM "spree_orders" WHERE "spree_orders"."number" = ? AND "spree_orders"."id" != ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT $1 AS one FROM "spree_orders" WHERE "spree_orders"."number" = ? AND "spree_orders"."id" != ? LIMIT ?

# events[].return_value.value
You are being redirected.</

# events[].sql_query.sql
DELETE FROM "spree_order_mutexes" WHERE "spree_order_mutexes"."id" = ?

# events[].sql_query.normalized_sql
DELETE FROM "spree_order_mutexes" WHERE "spree_order_mutexes"."id" = ?

# events[].sql_query.sql
SELECT "spree_stores".* FROM "spree_stores" WHERE ("spree_stores"."url" = ? OR "spree_stores"."default" = ?) ORDER BY "spree_stores"."default" ASC LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_stores".* FROM "spree_stores" WHERE ("spree_stores"."url" = ? OR "spree_stores"."default" = ?) ORDER BY "spree_stores"."default" ASC LIMIT ?

# events[].sql_query.sql
SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."completed_at" IS NULL AND "spree_orders"."currency" = ? AND "spree_orders"."guest_token" = ? AND "spree_orders"."store_id" = ? AND "spree_orders"."user_id" IS NULL LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."completed_at" IS NULL AND "spree_orders"."currency" = ? AND "spree_orders"."guest_token" = ? AND "spree_orders"."store_id" = ? AND "spree_orders"."user_id" IS NULL LIMIT ?

# events[].sql_query.sql
INSERT INTO "spree_order_mutexes" ("order_id", "created_at") VALUES (?, ?)

# events[].sql_query.normalized_sql
INSERT INTO "spree_order_mutexes" ("order_id", "created_at") VALUES (?, ?)

# events[].sql_query.sql
SELECT COUNT(*) FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ?

# events[].sql_query.normalized_sql
SELECT COUNT(*) FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ?

# events[].sql_query.sql
SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."id" = ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."id" = ? LIMIT ?

# events[].sql_query.sql
SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."iso" = ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."iso" = ? LIMIT ?

# events[].sql_query.sql
SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."iso" = ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."iso" = ? LIMIT ?

# events[].sql_query.sql
SELECT "spree_zones".* FROM "spree_zones" WHERE "spree_zones"."name" IS NULL LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_zones".* FROM "spree_zones" WHERE "spree_zones"."name" IS NULL LIMIT ?

# events[].sql_query.sql
SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."id" = ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."id" = ? LIMIT ?

# events[].sql_query.sql
SELECT 1 AS one FROM "spree_states" WHERE "spree_states"."country_id" = ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT $1 AS one FROM "spree_states" WHERE "spree_states"."country_id" = ? LIMIT ?

# events[].sql_query.sql
SELECT "spree_states".* FROM "spree_states" WHERE "spree_states"."country_id" = ? ORDER BY "spree_states"."name" ASC

# events[].sql_query.normalized_sql
SELECT "spree_states".* FROM "spree_states" WHERE "spree_states"."country_id" = ? ORDER BY "spree_states"."name" ASC

# events[].sql_query.sql
SELECT "spree_zones".* FROM "spree_zones" WHERE "spree_zones"."name" IS NULL LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_zones".* FROM "spree_zones" WHERE "spree_zones"."name" IS NULL LIMIT ?

# events[].sql_query.sql
SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."id" = ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."id" = ? LIMIT ?

# events[].sql_query.sql
SELECT 1 AS one FROM "spree_states" WHERE "spree_states"."country_id" = ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT $1 AS one FROM "spree_states" WHERE "spree_states"."country_id" = ? LIMIT ?

# events[].sql_query.sql
SELECT "spree_states".* FROM "spree_states" WHERE "spree_states"."country_id" = ? ORDER BY "spree_states"."name" ASC

# events[].sql_query.normalized_sql
SELECT "spree_states".* FROM "spree_states" WHERE "spree_states"."country_id" = ? ORDER BY "spree_states"."name" ASC

# events[].sql_query.sql
SELECT 1 AS one FROM "spree_adjustments" INNER JOIN "spree_line_items" ON "spree_adjustments"."adjustable_id" = "spree_line_items"."id" WHERE "spree_line_items"."order_id" = ? AND "spree_adjustments"."adjustable_type" = ? AND ("spree_adjustments".amount != 0) LIMIT ?

# events[].sql_query.normalized_sql
SELECT $1 AS one FROM "spree_adjustments" INNER JOIN "spree_line_items" ON "spree_adjustments"."adjustable_id" = "spree_line_items"."id" WHERE "spree_line_items"."order_id" = ? AND "spree_adjustments"."adjustable_type" = ? AND ("spree_adjustments".amount != $2) LIMIT ?

# events[].sql_query.sql
SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."order_id" = ? AND ("spree_adjustments".amount != 0) AND "spree_adjustments"."source_type" = ? AND "spree_adjustments"."eligible" = ?

# events[].sql_query.normalized_sql
SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."order_id" = ? AND ("spree_adjustments".amount != $1) AND "spree_adjustments"."source_type" = ? AND "spree_adjustments"."eligible" = ?

# events[].sql_query.sql
SELECT 1 AS one FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = ? AND "spree_adjustments"."adjustable_type" = ? AND ("spree_adjustments".amount != 0) AND "spree_adjustments"."eligible" = ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT $1 AS one FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = ? AND "spree_adjustments"."adjustable_type" = ? AND ("spree_adjustments".amount != $2) AND "spree_adjustments"."eligible" = ? LIMIT ?

# events[].sql_query.sql
SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" IS NULL ORDER BY "spree_taxons"."lft" ASC

# events[].sql_query.normalized_sql
SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" IS NULL ORDER BY "spree_taxons"."lft" ASC

# events[].sql_query.sql
DELETE FROM "spree_order_mutexes" WHERE "spree_order_mutexes"."id" = ?

# events[].sql_query.normalized_sql
DELETE FROM "spree_order_mutexes" WHERE "spree_order_mutexes"."id" = ?

# events[].sql_query.sql
SELECT "spree_stores".* FROM "spree_stores" WHERE ("spree_stores"."url" = ? OR "spree_stores"."default" = ?) ORDER BY "spree_stores"."default" ASC LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_stores".* FROM "spree_stores" WHERE ("spree_stores"."url" = ? OR "spree_stores"."default" = ?) ORDER BY "spree_stores"."default" ASC LIMIT ?

# events[].sql_query.sql
SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."completed_at" IS NULL AND "spree_orders"."currency" = ? AND "spree_orders"."guest_token" = ? AND "spree_orders"."store_id" = ? AND "spree_orders"."user_id" IS NULL LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."completed_at" IS NULL AND "spree_orders"."currency" = ? AND "spree_orders"."guest_token" = ? AND "spree_orders"."store_id" = ? AND "spree_orders"."user_id" IS NULL LIMIT ?

# events[].sql_query.sql
SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."id" = ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."id" = ? LIMIT ?

# events[].sql_query.sql
SELECT "spree_states".* FROM "spree_states" WHERE "spree_states"."country_id" = ? ORDER BY "spree_states"."name" ASC, name ASC

# events[].sql_query.normalized_sql
SELECT "spree_states".* FROM "spree_states" WHERE "spree_states"."country_id" = ? ORDER BY "spree_states"."name" ASC, name ASC

# events[].sql_query.sql
SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."id" = ? LIMIT ?

# events[].sql_query.normalized_sql
SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."id" = ? LIMIT ?

# events[].sql_query.sql
SELECT "spree_states".* FROM "spree_states" WHERE "spree_states"."country_id" = ? ORDER BY "spree_states"."name" ASC, name ASC

# events[].sql_query.normalized_sql
SELECT "spree_states".* FROM "spree_states" WHERE "spree_states"."country_id" = ? ORDER BY "spree_states"."name" ASC, name ASC

# metadata.name
Address country requires state but has no state shows the state input field