MySQL Left Join With WHERE Condition

SELECT
    tbl_subcategory.category_id
FROM
    tbl_catalogue
LEFT JOIN tbl_subcategory ON
    tbl_catalogue.sub_category_id = tbl_subcategory.id
LEFT JOIN tbl_category ON
    tbl_subcategory.category_id = sub_category_id
    WHERE tbl_catalogue.sub_category_id = 16