SELECT DISTINCT CONCAT(g.id, d.id) AS id, g.id AS groep_id, d.doosnummer, g.inventarisnrs
				FROM doosnummer_oud AS d, groep AS g
				JOIN groep_x_inventaris AS gxi ON gxi.groep_id=g.id
				JOIN doosnummer_x_inventaris AS dxi ON dxi.doosnummer_id=d.id
				WHERE gxi.inventaris_id=dxi.inventaris_id
				ORDER BY d.doosnummer [nativecode=1054 ** Unknown column 'd.id' in 'on clause']<br />(DataObject.php:2626)
(DataObject.php:1769)
(organisatiearchief.php:105)