mothMetadata 

  mothMetadata,
  labelSubtype,
  callType

      // Fetch species data - pre-filtered to just get the relevant species

      // Fetch species data with call types - pre-filtered to just get the relevant species

        description: species.description

        description: species.description,
        callTypeId: callType.id,
        callTypeName: callType.label

      .leftJoin(labelSubtype, eq(label.id, labelSubtype.labelId))
      .leftJoin(callType, eq(labelSubtype.calltypeId, callType.id))

    
    // Process species data with Map for better performance
    const speciesMap = new Map<string, Array<{
      id: string;
      label: string;
      ebirdCode: string | null;
      description: string | null;
    }>>();

    speciesResults.forEach(item => {
      if (!speciesMap.has(item.fileId)) {
        speciesMap.set(item.fileId, []);

    // Process species data with call types
    const speciesMap = speciesResults.reduce((acc, item) => {
      if (!acc[item.fileId]) {
        acc[item.fileId] = [];

      // Get the current species array for this file
      const fileSpecies = speciesMap.get(item.fileId)!;
      
      // Check if we already have this species (deduplication)
      const existingSpeciesIndex = fileSpecies.findIndex(s => s.id === item.speciesId);
      
      if (existingSpeciesIndex === -1) {
        // Add species if it doesn't already exist for this file
        fileSpecies.push({

      // Find existing species entry or create new one
      let existingSpecies = acc[item.fileId].find(s => s.id === item.speciesId);
      if (!existingSpecies) {
        existingSpecies = {

          description: item.description
        });

          description: item.description,
          callTypes: []
        };
        acc[item.fileId].push(existingSpecies);

    });

      
      // Add call type if present and not already added
      if (item.callTypeId && item.callTypeName) {
        const existingCallType = existingSpecies.callTypes.find(ct => ct.id === item.callTypeId);
        if (!existingCallType) {
          existingSpecies.callTypes.push({
            id: item.callTypeId,
            name: item.callTypeName
          });
        }
      }
      
      return acc;
    }, {} as Record<string, Array<{
      id: string;
      label: string;
      ebirdCode: string | null;
      description: string | null;
      callTypes: Array<{
        id: string;
        name: string;
      }>;
    }>>);

      species: speciesMap.get(fileData.id) || []

      species: speciesMap[fileData.id] || []