After select of this kind
SELECT a.* FROM Article AS a, Tag AS t, Tag2Object AS t2o
WHERE t.name = 'Foo'
AND t.id = t2o.tagId
AND t2o.parentObjId = a.id
links to edit each row are given. Clicks on them fail with the message:
SELECT * FROM `ArticleJW` WHERE `a`.`id` =1877;
#1054 - Unknown column 'a.id' in 'where clause'
The solution seems to be just cut the alias "a" off which is only defined in the first SQL statement.
Many thanks in advance,