SELECT name_id, description_id, image_path, bc.base_energy, bc.energy_factor_per_level,
        bc.base_metal, bc.metal_factor_per_level, bc.base_food, bc.food_factor_per_level,
        bp.base_energy, bp.energy_factor_per_level, bp.base_metal, bp.metal_factor_per_level,
        bp.base_food, bp.food_factor_per_level, bp.base_housing, bp.housing_factor_per_level,
        bp.base_ecology, bp.ecology_factor_per_level,
        pb.level, br.building_level as BuildingLevel, br.building_id
        FROM buildings
        JOIN building_costs bc ON buildings.id = bc.id
        JOIN building_production bp ON buildings.id = bp.id
        LEFT JOIN planet_buildings pb ON pb.building_id = buildings.id
        LEFT JOIN building_requirements br ON br.id = pb.id AND br.building_level = pb.level
        WHERE pb.id = $1