Get an HGBST List (in this case, the CR_DESC list)

Get HGBST list

SELECT l1.title, 
s1.title,e1.title,e1.rank, 
s2.title,e2.title,e2.rank, 
s3.title,e3.title,e3.rank 
FROM 
table_hgbst_lst l1, 
table_hgbst_show s1, 
table_hgbst_show s2, 
table_hgbst_show s3, 
table_hgbst_elm e1, 
table_hgbst_elm e2, 
table_hgbst_elm e3, 
mtm_hgbst_elm0_hgbst_show1 m1, 
mtm_hgbst_elm0_hgbst_show1 m2, 
mtm_hgbst_elm0_hgbst_show1 m3, 
mtm_hgbst_elm0_hgbst_show1 m4, 
mtm_hgbst_elm0_hgbst_show1 m5 
WHERE l1.title LIKE 'CR_DESC' 
AND s1.objid = l1.hgbst_lst2hgbst_show 
AND s1.objid = m1.hgbst_show2hgbst_elm 
AND e1.objid = m1.hgbst_elm2hgbst_show 
AND e1.state != 'Inactive' 
AND e1.objid = m2.hgbst_elm2hgbst_show 
AND s2.objid = m2.hgbst_show2hgbst_elm 
AND s2.objid != s1.objid 
AND s2.objid = m3.hgbst_show2hgbst_elm 
AND e2.objid = m3.hgbst_elm2hgbst_show 
AND e2.objid != e1.objid 
AND e2.state != 'Inactive' 
AND e2.objid = m4.hgbst_elm2hgbst_show 
AND s3.objid = m4.hgbst_show2hgbst_elm 
AND s3.objid != s2.objid 
AND s3.objid = m5.hgbst_show2hgbst_elm 
AND e3.objid = m5.hgbst_elm2hgbst_show 
AND e3.objid != e2.objid 
AND e3.state != 'Inactive';