Print Bookmark

Report: People without a default image

         Description: Mensen zonder een standaard klikplaatje

Error: The syntax of the query run with this report (ID: 159) was incorrect, and as a result the report could not be run. Please contact the system administrator at yourmail@domain.ext.

Query: SELECT lastname, firstname, personid, gedcom FROM ( SELECT p.lastname, p.firstname, p.personid, p.gedcom, MAX(ml.defphoto) AS mdp, COUNT(ml.medialinkid) AS n FROM tng_people AS p, tng_medialinks AS ml, tng_media AS m WHERE ml.personid = p.personid AND ml.gedcom = p.gedcom and ml.mediaid = m.mediaid AND m.gedcom = p.gedcom AND m.mediatypeid = 'photos' GROUP BY p.personid ) AS tmp WHERE n > 0 AND mdp != 1
Error Message:

This site powered by The Next Generation of Genealogy Sitebuilding ©, v. 9.2.2, written by Darrin Lythgoe 2001-2023.