A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ': AND ad.disciplineID = l.lookupID ORDER BY l.' at line 7

SELECT ad.disciplineID, l.lookupText FROM artist_discipline AS ad, lookup AS l WHERE ad.artistID = 999http: AND ad.disciplineID = l.lookupID ORDER BY l.lookupText