Hilfe bei Abfrage MySQL

[MudGuard]

Hi,

LEFT JOIN relation AS c

ON (a.articleID = c.relationLink)

LEFT JOIN elements AS d
ON (c.elementID = d.elementID)

WHERE (c.relationType = 'article')
AND (d.elementType = 'category')
AND (a.articleID = '1')

  
Das (c.relationType = 'article') bzw. das (d.elementType = 'category') ist m.E. Teil der Join-Bedinung, nicht Teil der Datensatzauswahl.  
  
Also eher so:  
~~~sql
LEFT JOIN relation AS c  
	ON ((a.articleID = c.relationLink) AND (c.relationType = 'article'))  
	  
LEFT JOIN elements AS d  
	ON ((c.elementID = d.elementID) AND (d.elementType = 'category'))  
	  
WHERE (a.articleID = '1')

cu,
Andreas