CousinsConnection;
Building a Family Tree for all variations of
Kitces, Keces, Keses, Kitzes, Ketzis, Kitzis, Kicis, Kitsis, Chitis, and Кицис
As well as
Charest, Pearson, Gordon, Westheimer, Greenwald, Simon, Rohr, Dunsky

Report: Recent Marriages

         Description:


Error: The syntax of the query run with this report (ID: 6) was incorrect, and as a result the report could not be run. Please contact the system administrator at family@kitces.com.

Query: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, tng_people.branch,lastname, firstname,(if(sex='M',families1.wife,families2.husband)) as spouse,if(sex='M',families1.marrdate,families2.marrdate),if(sex='M',families1.marrplace,families2.marrplace), tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_families AS families1 ON (tng_people.gedcom = families1.gedcom AND tng_people.personID = families1.husband ) LEFT JOIN tng_families AS families2 ON (tng_people.gedcom = families2.gedcom AND tng_people.personID = families2.wife ) WHERE (TO_DAYS(if(sex='M',families1.marrdatetr,families2.marrdatetr)) > TO_DAYS(todayDATE_SUB(NOW(), INTERVAL -13 HOUR)) - 365 AND sex = "M") AND tng_people.gedcom = "MAIN" ORDER BY if(sex='M',families1.marrdatetr,families2.marrdatetr) desc
Error Message: