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

Pages with controls equal to POSTED SERVICE INVOICE NOS.

Seq NoPage NumberPage NameControl Name
15919Service Mgt. SetupPosted Service Invoice Nos. Search
25919Service Mgt. SetupPosted Service Invoice Nos. Search