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 = 'ApproverUserID' ORDER BY p.ID ,pc.ControlName
Find page controls

Pages with controls equal to APPROVERUSERID

Seq NoPage NumberPage NameControl Name
1950Time SheetApproverUserID Search
2952Manager Time SheetApproverUserID Search
3959Time Sheet ArchiveApproverUserID Search
4975Time Sheet Archive CardApproverUserID Search