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 = 'Recog. Profit G/L {706764dffe8d0d2acd1fc1b9fbda6cb15da65c5a2d3c817d78c632c1a315140e}'
ORDER BY
p.ID
,pc.ControlName