The gist of the query is to get the average cost of a 3 level BOM for the last 15 weeks by getting the 3 most recent IRs from that time.