MySQLi error in file /home/domains/www.ikcro.nl/htdocs/php/ext/listthemaobjectfeedzoek_niek.php, on line 226, on query:
SELECT o.id, o.name, o.titles, o.initials, o.prefix, o.postfix, o.christianname, o.kindofobject, objectterm.term, dates FROM Object o, Objectdate m left join objectterm on o.id = objectterm.id WHERE (objectterm.thesaurus = 'itemsoort' or objectterm.id is null) and (objectterm.thesaurus = 'itemsoort' and objectterm.term <> 'Dossier') and (o.id=m.id and (KindOfDate='Publikatiedatum' or KindOfDate='Begindatum' or KindOfDate='Invoer')) and o.KindOfObject='item' and (name like '%woningmarkt%' or ChristianName like '%woningmarkt%' or (o.id in (select x.id from ObjectText x where Text like '%woningmarkt%')) or (o.id in (select t.id from ObjectTerm t where t.Term like '%woningmarkt%'))) GROUP BY o.id ORDER BY m.dates DESC, Name, Titles, Initials, Prefix, Postfix

Error: Unknown column 'o.id' in 'on clause'