SELECT p.id, p.name, p.@ text, pe.name 'people-name', pe.title 'people-title', pe.id 'people-id', i.path 'people-photo' FROM project p LEFT JOIN people pe ON pe.id=p.@_person LEFT JOIN stdimage i ON i.id=pe.photo2 WHERE p.id=10 LIMIT 0,1
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 '@ text, pe.name 'people-name', pe.title 'people-title', pe.id 'people-id', i.pat' at line 1