Error : Unknown column 'truss2' in 'where clause'
SELECT s.structure_name, s.notes, sp.structure_name AS parent_name, sp.structure_id AS parent_id, sg.structure_name AS grandparent_name, sg.structure_id AS grandparent_id, sl.location, sl.structure_location_id, slh.event, slh.date_start, slh.date_end, slh.structure_location_history_id, slh.notes AS event_note, sa.architect_id, sa.note, a.name FROM structure s LEFT JOIN structure sp ON (s.parent_id = sp.structure_id) LEFT JOIN structure sg ON (sp.parent_id = sg.structure_id) LEFT JOIN structure_location sl ON (sl.structure_id = s.structure_id AND sl.structure_location_id = '') LEFT JOIN structure_location_history slh ON (slh.structure_id = s.structure_id AND slh.structure_location_id = sl.structure_location_id) LEFT JOIN structure_architect sa ON (sa.structure_id = s.structure_id AND sa.structure_location_id = sl.structure_location_id AND sa.structure_location_history_id = slh.structure_location_history_id) LEFT JOIN architect a ON (a.architect_id = sa.architect_id) WHERE s.structure_id = truss2 ORDER BY slh.date_end
There has been an error, cannot query database, please try again later.

structure details


Error : Unknown column 'truss2' in 'where clause'
SELECT structure_name, structure_id FROM structure WHERE parent_id = truss2 ORDER BY structure_name
There has been an error, cannot query database, please try again later.

structure history

Error : Unknown column 'truss2' in 'where clause'
SELECT a.architect_id, a.name, sa.note FROM structure_architect sa, architect a WHERE sa.structure_id = truss2 AND structure_location_history_id = 0 AND a.architect_id = sa.architect_id
There has been an error, cannot query database, please try again later.

Currently no events for this structure

Error : Unknown column 'truss2' in 'where clause'
SELECT DISTINCT document_id, document_type, title_1, title_2, author, date, year FROM document_warehouse WHERE structure_id = truss2 ORDER BY document_type, year desc
There has been an error, cannot query database, please try again later.

related documents

No related documents

Images

IMAGE