Help with sql to fetch the latest released Manufacturers tab information for an item.

I need help to develop an SQL to fetch the latest released Manufacturers tab information for an item.

Here is one use case where there should be one row returned and it's not returing any rows.

SELECT chg.change_number, it.item_number, mpart.part_number, mfr.name, nt.description AS "Mfr_LC"
FROM manu_by aml
JOIN manu_parts mpart ON mpart.id = aml.manu_part
JOIN manufacturers mfr ON mfr.id = mpart.manu_id
JOIN item it ON aml.agile_part = it.id
JOIN change chg ON chg.id = it.default_change
JOIN nodetable nt ON mfr.status = nt.id