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 = 'Job WIP Total Entry No.' ORDER BY p.ID ,pc.ControlName
Find page controls

Pages with controls equal to JOB WIP TOTAL ENTRY NO.

Seq NoPage NumberPage NameControl Name
11008Job WIP EntriesJob WIP Total Entry No. Search
21009Job WIP G/L EntriesJob WIP Total Entry No. Search
31026Job WIP WarningsJob WIP Total Entry No. Search