CategoryCustomQuery.sql

##custom query berdasarkan level3
SELECT l1.name , l2.name , l3.name  FROM Category AS l3 
            LEFT JOIN Category AS l2 ON l3.parent = l2.secureId 
            LEFT JOIN Category AS l1 ON l2.parent = l1.secureId
            WHERE l3.secureId = {{secureId}}
            
            
##custom query berdasarkan level 2
SELECT l1.name , l2.name FROM Category AS l2 
            LEFT JOIN Category AS l1 ON l2.parent = l1.secureId
            WHERE l2.secureId = {{secureId}}