Report: Marriages This Month

         Description: Their anniversary is this month. [NOTE: Marriage Dates containing Abt., Bef., Bet., or Aft. may not have occurred this month.]


SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, tng_people.branch,lastname, firstname,sex,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 ((( if(sex='M',families1.marrdate,families2.marrdate) LIKE "%JUL%" )) AND ((tng_people.living !=1 && tng_people.private != 1))) AND tng_people.gedcom = "OurFamilyTree" ORDER BY lastname,firstname,if(sex='M',families1.marrdatetr,families2.marrdatetr)

Matches 1 to 50 of 213   » Comma-delimited CSV file

1 2 3 4 5 Next»

# Last Name, Given Name(s) Marriage Date Marriage Place
1 +, Eleanor, Queen consort of England  25 July 1137   
2 +, King Louis VII de France  25 July 1137   
3 Adams, Electa Ann  11 Jul 1859  Wellington, Ontario, Canada  
4 Adams, John Quincy  26 Jul 1797  London, London, England  
5 Adams, Lillian May  2 Jul 1926   
6 Adams, Margaret Rosella  1 Jul 1940   
7 Adams, Raymond David  5 Jul 1910  Winnipeg, Manitoba, Canada  
8 Adams, William Edgar  31 Jul 1894  Ontario, Canada  
9 Adams +, Abraham I  25 Jul 1733  Suffield, Hartford, Connecticut, USA  
10 Adams |, William  7 Jul 1625  High Wycombe, Buckinghamshire, England  
11 Allen +, Nicholas  3 Jul 1663  Dorchester, Suffolk, Massachusetts, USA  
12 Ames +, Samuel  8 Jul 1756  Rutland, Worcester, Massachusetts, USA  
13 Andersen +, Rasmus  10 Jul 1744  Høyland, Rogaland, Norway  
14 Anderson ??, Carl Adolf  17 Jul 1917  Polk, Minnesota, USA  
15 Anthony, Bernice Mary  2 Jul 1915  Brentford, Hounslow, London, England  
16 Armstrong, Elwood Adams  25 Jul 1967   
17 Atchison, Gladys Leona  2 Jul 1924   
18 Baker, Sarah  8 Jul 1779  Littleton, Middlesex, Massachusetts, USA  
19 Ball +, Sarah  8 Jul 1756  Rutland, Worcester, Massachusetts, USA  
20 Ball + ?? |, Mary  3 Jul 1663  Dorchester, Suffolk, Massachusetts, USA  
21 Barber +, Mary  8 Jul 1669  Connecticut, USA  
22 Barber +, Nathaniel  2 Jul 1711   
23 Bates, Eliza  19 Jul 1843  Alachua, Florida, USA  
24 Belgrave +, Thomasine  26 Jul 1585  Glemsford, Suffolk, England  
25 Bent, John  1 Jul 1658  Sudbury, Middlesex, Massachusetts, USA  
26 Blanchard, Calvin  5 Jul 1777  Westford, Middlesex, Massachusetts, USA  
27 Blaser, Sarah Mae  20 Jul 1932  Weber, Utah, USA  
28 Blount, Wilson Ohlkers  19 Jul 1940  Clarke, Georgia, USA  
29 Booth, Ella Jane  Aft. 12 Jul 1889   
30 Bowers, Henry Grady  4 Jul 1947  Danburg, Wilkes, Georgia, USA  
31 Bragg, Benjamin Calvin I  20 Jul 1932  Weber, Utah, USA  
32 Bragg, Carrie Belle  17 Jul 1919  Salt Lake City, Salt Lake, Utah, USA  
33 Bragg, George Washington I  18 Jul 1880  Hart, Georgia, USA  
34 Brent, Maurice  16 Jul 1764   
35 Brooke, John Carrington I  20 Jul 1819  Jefferson, Ohio, USA  
36 Brown + ??, Susannah  11 Jul 1782  Boothbay, Lincoln, Maine, USA  
37 Burden, Amanda E.  18 Jul 1880  Hart, Georgia, USA  
38 Burroughs, Wilfred Gordon  14 Jul 1942   
39 Carman, Edward Oscar  31 Jul 1923  Fayette, West Virginia, USA  
40 Carman ??, Hezekiah  24 Jul 1763  Baltimore, Maryland, USA  
41 Carman ??, John I  24 Jul 1763  Baltimore, Baltimore, Maryland, USA  
42 Case +, Elizabeth  16 Jul 1835   
43 Chapman, John  5 Jul 1756   
44 Chapman, John Albion I  23 Jul 1931  Camak, Warren, Georgia, USA  
45 Chapman, Nancy  19 Jul 1835  Taliaferro, Georgia, USA  
46 Chapman, Nathaniel  24 Jul 1780  Longmeadow, Hampden, Massachusetts, USA  
47 Chapman, Randal  Bef. 22 Jul 1822   
48 Chapman, Randal  23 Jul 1822  Greene, Georgia, USA  
49 Chilham +, Isabel  Bef. 12 Jul 1247   
50 Christensen, Henry Leroy  17 Jul 1919  Salt Lake City, Salt Lake, Utah, USA  


1 2 3 4 5 Next»