: SELECT * FROM rel_art_prod LEFT OUTER JOIN products ON rel_art_prod.product_id = products.product_id LEFT OUTER JOIN product_companies ON products.product_company_id = product_companies.product_company_id LEFT OUTER JOIN product_types ON products.product_type_id = product_types.product_type_id WHERE article_id='26' order by products.product_in_stock DESC, products.product_name;.