If I understand the problem, try adding "GROUP BY products_id" between the WHERE and ORDER clauses. I don't have any linked products in my database to test this with, so all bets are off here.

You should end up with something like this:

WHERE products_status =1
GROUP BY products_id
ORDER BY products_last_modified DESC