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

Pages with controls equal to TOTAL WIP COST AMOUNT

Seq NoPage NumberPage NameControl Name
188Job CardTotal WIP Cost Amount Search
21027Job WIP CockpitTotal WIP Cost Amount Search
39099Job WIP/Recognition FactBoxTotal WIP Cost Amount Search