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

Pages with controls equal to REQUESTS TO APPROVE

Seq NoPage NumberPage NameControl Name
11152COHUB Company SummaryRequests to Approve Search
21153COHUB Company Short SummaryRequests to Approve Search
39070Accounting Services ActivitiesRequests to Approve Search
49144Approvals ActivitiesRequests to Approve Search