[joe_bruin]

not sure if mysql can do this, but something along the lines of:

select *
from Issue, IssueProduct, Product
where IssueProduct.ProductID=Product.ProductID and
      IssueProduct.IssueID=Issues.IssueID and
      IssueID in 
      ( select IssueID
        from Issues
        order by IssueID desc
        limit 50 )