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

Pages with controls equal to ACC. WIP COSTS AMOUNT

Seq NoPage NumberPage NameControl Name
188Job CardAcc. WIP Costs Amount Search
29099Job WIP/Recognition FactBoxAcc. WIP Costs Amount Search