{"queries":[{"id":"build_info","compiledQueryString":"select build_timestamp_utc from as24ch.metadata","inputQueryString":"select build_timestamp_utc from as24ch.metadata","compiled":false,"inline":true},{"id":"brand_list","compiledQueryString":"select distinct brand from as24ch.listings where status != 'active' and brand is not null order by brand","inputQueryString":"select distinct brand from as24ch.listings where status != 'active' and brand is not null order by brand","compiled":false,"inline":true},{"id":"fuel_list","compiledQueryString":"select distinct fuel_type from as24ch.listings where status != 'active' and fuel_type is not null order by fuel_type","inputQueryString":"select distinct fuel_type from as24ch.listings where status != 'active' and fuel_type is not null order by fuel_type","compiled":false,"inline":true},{"id":"delisted","compiledQueryString":"select\n id, brand, model, version, year, mileage_km, fuel_type, drive_train,\n vehicle_type, seller_type, seller_name,\n current_price, initial_price,\n price_change_eur, (price_change_pct / 100.0)::numeric(10,3) as price_change_pct,\n days_on_platform, rotation_days,\n last_seen_at, last_status_change\nfrom as24ch.listings\nwhere status != 'active'\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\n and ('${inputs.fuel.value}' = '' or fuel_type = '${inputs.fuel.value}')\n and (year is null or year between COALESCE(NULLIF('${inputs.year_min}', ''), '2016')::int and COALESCE(NULLIF('${inputs.year_max}', ''), '2026')::int)\n and (mileage_km is null or mileage_km between COALESCE(NULLIF('${inputs.min_km}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_km}', ''), '300000')::int)\n and (current_price is null or current_price between COALESCE(NULLIF('${inputs.min_price}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_price}', ''), '500000')::int)\n and (rotation_days is null or rotation_days <= COALESCE(NULLIF('${inputs.max_days}', ''), '365')::int)\norder by last_seen_at desc\nlimit 2000","inputQueryString":"select\n id, brand, model, version, year, mileage_km, fuel_type, drive_train,\n vehicle_type, seller_type, seller_name,\n current_price, initial_price,\n price_change_eur, (price_change_pct / 100.0)::numeric(10,3) as price_change_pct,\n days_on_platform, rotation_days,\n last_seen_at, last_status_change\nfrom as24ch.listings\nwhere status != 'active'\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\n and ('${inputs.fuel.value}' = '' or fuel_type = '${inputs.fuel.value}')\n and (year is null or year between COALESCE(NULLIF('${inputs.year_min}', ''), '2016')::int and COALESCE(NULLIF('${inputs.year_max}', ''), '2026')::int)\n and (mileage_km is null or mileage_km between COALESCE(NULLIF('${inputs.min_km}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_km}', ''), '300000')::int)\n and (current_price is null or current_price between COALESCE(NULLIF('${inputs.min_price}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_price}', ''), '500000')::int)\n and (rotation_days is null or rotation_days <= COALESCE(NULLIF('${inputs.max_days}', ''), '365')::int)\norder by last_seen_at desc\nlimit 2000","compiled":false,"inline":true},{"id":"kpis","compiledQueryString":"select\n count(*) as total_delisted,\n count(*) filter (where price_change_eur < 0) as had_price_drop,\n avg(price_change_pct) filter (where price_change_pct < 0)::numeric(10,3) as avg_drop_pct,\n avg(rotation_days) filter (where rotation_days is not null)::numeric(10,1) as avg_rotation\nfrom ((select\n id, brand, model, version, year, mileage_km, fuel_type, drive_train,\n vehicle_type, seller_type, seller_name,\n current_price, initial_price,\n price_change_eur, (price_change_pct / 100.0)::numeric(10,3) as price_change_pct,\n days_on_platform, rotation_days,\n last_seen_at, last_status_change\nfrom as24ch.listings\nwhere status != 'active'\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\n and ('${inputs.fuel.value}' = '' or fuel_type = '${inputs.fuel.value}')\n and (year is null or year between COALESCE(NULLIF('${inputs.year_min}', ''), '2016')::int and COALESCE(NULLIF('${inputs.year_max}', ''), '2026')::int)\n and (mileage_km is null or mileage_km between COALESCE(NULLIF('${inputs.min_km}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_km}', ''), '300000')::int)\n and (current_price is null or current_price between COALESCE(NULLIF('${inputs.min_price}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_price}', ''), '500000')::int)\n and (rotation_days is null or rotation_days <= COALESCE(NULLIF('${inputs.max_days}', ''), '365')::int)\norder by last_seen_at desc\nlimit 2000))","inputQueryString":"select\n count(*) as total_delisted,\n count(*) filter (where price_change_eur < 0) as had_price_drop,\n avg(price_change_pct) filter (where price_change_pct < 0)::numeric(10,3) as avg_drop_pct,\n avg(rotation_days) filter (where rotation_days is not null)::numeric(10,1) as avg_rotation\nfrom (${delisted})","compiled":true,"inline":true},{"id":"by_brand","compiledQueryString":"select\n brand,\n count(*) as delisted,\n avg(rotation_days) filter (where rotation_days is not null)::numeric(10,1) as avg_rotation,\n avg(price_change_pct) filter (where price_change_pct < 0)::numeric(10,3) as avg_drop_pct,\n avg(current_price)::int as avg_price\nfrom ((select\n id, brand, model, version, year, mileage_km, fuel_type, drive_train,\n vehicle_type, seller_type, seller_name,\n current_price, initial_price,\n price_change_eur, (price_change_pct / 100.0)::numeric(10,3) as price_change_pct,\n days_on_platform, rotation_days,\n last_seen_at, last_status_change\nfrom as24ch.listings\nwhere status != 'active'\n and ('${inputs.brand.value}' = '' or brand = '${inputs.brand.value}')\n and ('${inputs.fuel.value}' = '' or fuel_type = '${inputs.fuel.value}')\n and (year is null or year between COALESCE(NULLIF('${inputs.year_min}', ''), '2016')::int and COALESCE(NULLIF('${inputs.year_max}', ''), '2026')::int)\n and (mileage_km is null or mileage_km between COALESCE(NULLIF('${inputs.min_km}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_km}', ''), '300000')::int)\n and (current_price is null or current_price between COALESCE(NULLIF('${inputs.min_price}', ''), '0')::int and COALESCE(NULLIF('${inputs.max_price}', ''), '500000')::int)\n and (rotation_days is null or rotation_days <= COALESCE(NULLIF('${inputs.max_days}', ''), '365')::int)\norder by last_seen_at desc\nlimit 2000))\nwhere brand is not null\ngroup by brand\norder by delisted desc\nlimit 20","inputQueryString":"select\n brand,\n count(*) as delisted,\n avg(rotation_days) filter (where rotation_days is not null)::numeric(10,1) as avg_rotation,\n avg(price_change_pct) filter (where price_change_pct < 0)::numeric(10,3) as avg_drop_pct,\n avg(current_price)::int as avg_price\nfrom (${delisted})\nwhere brand is not null\ngroup by brand\norder by delisted desc\nlimit 20","compiled":true,"inline":true}]}

AS24 CH — Recently Delisted

Recently Delisted Listings

Delisted listings

Brand breakdown