SELECT s.id AS supplier_id, s.supplier_company, s.company_logo, s.supplier_address, s.supplier_location, s.supplier_contact, s.supplier_website, s.supplier_email, s.supplier_tag, s.package_id, p.pr_id, p.product_name, p.product_description, p.price, p.unit, p.feature, p.product_img, p.product_url FROM supplier_tbl AS s INNER JOIN product_tbl AS p ON p.supplier_id = s.id WHERE p.subchild_category_id='10827' ORDER BY s.package_id;