: SELECT * FROM rel_accessories LEFT OUTER JOIN products ON rel_accessories.accessor_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 id='1447' ORDER by products.product_in_stock DESC.