In your SELECT at the beginning of the SQL query, you insert pl.name as product_name.
You placed the LEFT JOIN correctly.
How to insert SQL into the forum?
You click on <>
and choose SQL at the bottom.
When several dots are used in the text, it means that there is a continuation after these dots (in your case, your SQL).