SELECT
SELECT
DISTINCT T1.description_code AS sub_subcategory_code,
T1.description_text AS sub_subcategory_text,
T1.master_photograph
FROM $tblmasterproductcategory T1
INNER JOIN $tblproduct T4
ON T1.description_code = T4.product_sub_subcategory
AND T4.created_by = :base_seller
WHERE
T1.is_status = '1'
AND T1.is_deleted = '0'
AND T1.category_code = '3'
ORDER BY T1.description_text;
0.0/5 from 0 reviews