#Erreur

#requête SQL: Documentation

SELECT DISTINCT v0.lexical AS `project`
FROM symbols v0
LEFT JOIN (

SELECT DISTINCT tmp0_3ada.project AS `project` , t3.object AS `shortdesc`
FROM tmp0_3ada, triples t3
WHERE t3.predicate = -7078256341659301505
AND t3.subject = tmp0_3ada.project
) AS `tmp1_3ada` ON tmp0_3ada.project = tmp1_3ada.project
LIMIT 0 , 30

#MySQL a répondu:Documentation
#1054 - Unknown column 'tmp0_3ada.project' in 'on clause'



#but 'tmp0_3ada.project' exists, as 

SELECT DISTINCT tmp0_3ada.project AS `project` , t3.object AS `shortdesc`
FROM tmp0_3ada, triples t3
WHERE t3.predicate = -7078256341659301505
AND t3.subject = tmp0_3ada.project

#is ok