Text this: Unveiling optimal SDG pathways: an innovative automated recommendation approach integrating graph pruning, intent graph, and attention mechanism