SELECT pro.id, pro.sub_category_id, pro.product_name, pro.image, know.id, know.category_id, know.material_type, know.meta_title, know.meta_keyword, know.meta_desc, know.document_desc, know.document, mat.material_type AS Material_Name FROM dsquared_knowledge_centre AS know INNER JOIN dsquared_product AS pro ON (pro.id = know.product_id) INNER JOIN dsquared_category AS cat ON (cat.id=know.category_id) INNER JOIN dsquared_subcategory AS subcat ON (subcat.id=know.sub_category_id) INNER JOIN dsquared_material_type AS mat ON (mat.id = know.material_type) WHERE know.id =