Ok one last question, how would I get the above code to only show results from one manufactuers_id? something using left join?

manufactuers_id is in zen_products and products_model_number is in zen_products_description