WordPress database error: [Unknown column 'r.int_designation' in 'SELECT']
SELECT s.an_staff, s.int_wp_id, CONCAT(tl.txt_title,' ', s.txt_forename,' ',s.txt_surname) AS txt_staff, r.an_role, r.txt_role, r.int_designation FROM tbl_staff AS s INNER JOIN tbl_title AS tl ON s.int_title = tl.an_title INNER JOIN tbl_role AS r ON s.int_role = r.an_role WHERE s.bool_current = 1 ORDER by r.int_designation, s.an_staff

Warning: Undefined variable $content in /home/u401582245/domains/doctranet.co.uk/public_html/wp-content/plugins/code-snippets/php/snippet-ops.php(663) : eval()'d code on line 20
{"id":1967,"date":"2021-03-09T19:40:50","date_gmt":"2021-03-09T19:40:45","guid":{"rendered":"https:\/\/doctranet.co.uk\/index.php\/home\/inventory-add-2\/"},"modified":"2021-03-09T19:41:54","modified_gmt":"2021-03-09T19:41:54","slug":"meeting-add","status":"publish","type":"page","link":"https:\/\/doctranet.co.uk\/index.php\/home\/meeting-add\/","title":{"rendered":"Meeting Add"},"content":{"rendered":"

ADDING a NEW meeting<\/p>

Meeting Date<\/th><\/tr>
<\/th><\/tr>
Meeting Type<\/th><\/tr>
Attendee<\/th> Role<\/th> Present<\/th><\/tr><\/tbody><\/table>
<\/form>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":519,"menu_order":65,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1967","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/doctranet.co.uk\/index.php\/wp-json\/wp\/v2\/pages\/1967","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/doctranet.co.uk\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/doctranet.co.uk\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/doctranet.co.uk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/doctranet.co.uk\/index.php\/wp-json\/wp\/v2\/comments?post=1967"}],"version-history":[{"count":2,"href":"https:\/\/doctranet.co.uk\/index.php\/wp-json\/wp\/v2\/pages\/1967\/revisions"}],"predecessor-version":[{"id":1970,"href":"https:\/\/doctranet.co.uk\/index.php\/wp-json\/wp\/v2\/pages\/1967\/revisions\/1970"}],"up":[{"embeddable":true,"href":"https:\/\/doctranet.co.uk\/index.php\/wp-json\/wp\/v2\/pages\/519"}],"wp:attachment":[{"href":"https:\/\/doctranet.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=1967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}