Error 1064 : 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 'ORDER BY instrumentchord.CT_ID' at line 1SELECT DISTINCT root.ROOT_ID, root.ROOT_NAME, chordtype.CT_ASCII, chordtype.CT_ASCII_ALT, instrumentchord.CT_ID, instrumentchord.IC_CHARTFILE FROM root INNER JOIN instrumentchord ON root.ROOT_NAME LIKE instrumentchord.ROOT_NAME INNER JOIN chordtype ON instrumentchord.CT_ID LIKE chordtype.CT_ID WHERE root.ROOT_ID = ORDER BY instrumentchord.CT_ID Error 1064 : 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 'ORDER BY instrumentchord.CT_ID' at line 1SELECT DISTINCT root.ROOT_ID, root.ROOT_NAME, chordtype.CT_ASCII, chordtype.CT_ASCII_ALT, instrumentchord.CT_ID, instrumentchord.IC_CHARTFILE FROM root INNER JOIN instrumentchord ON root.ROOT_NAME LIKE instrumentchord.ROOT_NAME INNER JOIN chordtype ON instrumentchord.CT_ID LIKE chordtype.CT_ID WHERE root.ROOT_ID = ORDER BY instrumentchord.CT_ID Error 1064 : 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 instrumentchord.CT_ID = 11' at line 1SELECT DISTINCT keysig.KEY_ID, keysig.KEY_MAJABBREV, root.ROOT_ID, root.ROOT_NAME, chordtype.*, instrumentchord.* FROM root INNER JOIN instrumentchord ON root.ROOT_NAME LIKE instrumentchord.ROOT_NAME INNER JOIN chordtype ON instrumentchord.CT_ID LIKE chordtype.CT_ID INNER JOIN keysig ON keysig.KEY_ID LIKE instrumentchord.KEY_ID WHERE root.ROOT_ID = AND instrumentchord.CT_ID = 11Error 1064 : 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 instrumentchord.CT_ID = 11' at line 1SELECT DISTINCT instrumentchord.IC_MIDI1, instrumentchord.IC_MIDI2, instrumentchord.IC_MIDI3, instrumentchord.IC_MIDI4, instrumentchord.IC_MIDI5, instrumentchord.IC_MIDI6 FROM instrumentchord INNER JOIN root ON instrumentchord.ROOT_NAME LIKE root.ROOT_NAME WHERE root.ROOT_ID = AND instrumentchord.CT_ID = 11Error 1064 : 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 '' at line 1SELECT DISTINCT chordtype.CT_ASCII, chordtype.CT_NAME, chordtype.CT_ID, root.ROOT_ID, instrumentchord.ROOT_NAME, instrumentchord.IC_NOTE1, instrumentchord.IC_NOTE2, instrumentchord.IC_NOTE3, instrumentchord.IC_NOTE4, instrumentchord.IC_NOTE5, instrumentchord.IC_NOTE6 FROM instrumentchord INNER JOIN chordtype ON instrumentchord.CT_ID = chordtype.CT_ID INNER JOIN keysig ON instrumentchord.KEY_ID = keysig.KEY_ID INNER JOIN root ON instrumentchord.ROOT_NAME LIKE root.ROOT_NAME WHERE Error 1064 : 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 instrumentchord.CT_ID = 11 AND chordtype.CT_ONKEY LIKE 'Y' AND keysig.KEY...' at line 1SELECT keysig.KEY_ID, keysig.KEY_MINABBREV, keysig.KEY_MAJABBREV, root.ROOT_ID, instrumentchord.* FROM keysig INNER JOIN instrumentchord ON instrumentchord.KEY_ID LIKE keysig.KEY_ID INNER JOIN root ON root.ROOT_NAME LIKE instrumentchord.ROOT_NAME INNER JOIN chordtype ON chordtype.CT_ID LIKE instrumentchord.CT_ID WHERE (root.ROOT_ID = AND instrumentchord.CT_ID = 11 AND chordtype.CT_ONKEY LIKE 'Y' AND keysig.KEY_MAJABBREV NOT LIKE root.ROOT_NAME) OR (root.ROOT_ID = AND instrumentchord.CT_ID = 11 AND chordtype.CT_ONMAJ LIKE 'Y' AND keysig.KEY_MAJABBREV LIKE root.ROOT_NAME)

The chord contains the following notes and scale degrees based on the major scale.

Key Signatures

The notes of the guitar chord fall within the following key signatures.