Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND (dtd.document_type = dd.document_type OR ' at line 11
SELECT dd.document_id, d.document_type, dd.detail_cd, dd.detail_data, dtd.detail_description, d.qub_location, d.ucd_location FROM document_details dd, document_type_details dtd, documents d WHERE dd.document_id IN () AND (dtd.document_type = dd.document_type OR dtd.document_type = 'default') AND dtd.detail_cd = dd.detail_cd AND d.document_id = dd.document_id ORDER BY dd.document_id, dtd.ordering
There has been an error, cannot query database, please try again later.

marked document list [export to EndNote/Ref. Manager/RefWorks] [export to csv/excel] [print]

: Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND sl.structure_id = sd.structure_id AND sl.structu' at line 20
SELECT a.name as architect_name, sarch.architect_id, sd.structure_id, sd.structure_location_id, CONCAT_WS(' - ',s.structure_name,sa.structure_name,sb.structure_name) AS structure_name, sa.structure_name AS parent_name, sl.location FROM (structure_documents sd, structure_location sl) LEFT JOIN structure s ON (s.structure_id = sd.structure_id) LEFT JOIN structure sa ON (s.parent_id = sa.structure_id) LEFT JOIN structure sb ON (sa.parent_id = sb.structure_id) LEFT JOIN structure_architect sarch ON (sarch.structure_id = s.structure_id AND sarch.structure_location_id = sl.structure_location_id) LEFT JOIN architect a ON (a.architect_id = sarch.architect_id) WHERE sd.document_id = AND sl.structure_id = sd.structure_id AND sl.structure_location_id = sd.structure_location_id
There has been an error, cannot query database, please try again later.

Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND a.architect_id = da.architect_id' at line 6
SELECT da.architect_id, a.name FROM document_architects da, architect a WHERE da.document_id = AND a.architect_id = da.architect_id
There has been an error, cannot query database, please try again later.

[remove]