         COALESCE("agg_child_health"."fully_immunized_on_time", 0) AS "fully_immunized_on_time",
         COALESCE("agg_child_health"."fully_immunized_late", 0) AS "fully_immunized_late"
     FROM "public"."awc_location_months" "awc_location_months"
-    CROSS JOIN "public"."child_health_categories" "child_health_categories"
     LEFT JOIN "public"."agg_child_health" "agg_child_health" ON (
         ("awc_location_months"."month" = "agg_child_health"."month") AND
         ("awc_location_months"."aggregation_level" = "agg_child_health"."aggregation_level") AND

        "awc_location_months"."state_site_code" AS "state_site_code",
        "awc_location_months"."aggregation_level" AS "aggregation_level",
        "awc_location_months"."month" AS "month",
        "ccs_record_categories"."ccs_status" AS "ccs_status",
        "ccs_record_categories"."trimester" AS "trimester",
        "ccs_record_categories"."caste" AS "caste",
        "ccs_record_categories"."disabled" AS "disabled",
        "ccs_record_categories"."minority" AS "minority",
        "ccs_record_categories"."resident" AS "resident",
        COALESCE("agg_ccs_record"."valid_in_month", 0) AS "valid_in_month",
        COALESCE("agg_ccs_record"."valid_all_registered_in_month", 0) AS "valid_all_registered_in_month",
        COALESCE("agg_ccs_record"."lactating", 0) AS "lactating",

        ("awc_location_months"."district_id" = "agg_child_health"."district_id") AND
        ("awc_location_months"."block_id" = "agg_child_health"."block_id") AND
        ("awc_location_months"."supervisor_id" = "agg_child_health"."supervisor_id") AND
        ("awc_location_months"."awc_id" = "agg_child_health"."awc_id")
    );

DROP VIEW IF EXISTS agg_thr_monthly CASCADE;
