SELECT f.container, f.filename, f.rank
FROM products p
LEFT JOIN file_downloads f ON f.id=p.stockcode and f.idtype='stockline'
WHERE p.stockcode = 'yt105' ORDER BY f.rank
No rows found, nothing to print so am exiting