Page Control Search

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Bank Acc. Posting Group' ORDER BY p.ID ,pc.ControlName
Find page controls

Pages with controls equal to BANK ACC. POSTING GROUP

Seq NoPage NumberPage NameControl Name
1370Bank Account CardBank Acc. Posting Group Search
2371Bank Account ListBank Acc. Posting Group Search
31283Payment Bank Account CardBank Acc. Posting Group Search