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, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,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 "%OCT%" )) 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 333  » Comma-delimited CSV file

1 2 3 4 5 ... Next»

# Last Name, Given Name(s) Marriage Date Marriage Place
1 +, Earl of Chester King Edward I of England  18 Oct 1254  Burgos, Castilla-Leon, Spain  
2 +, King Louis VII de France  18 Oct 1160  France  
3 +, Leonor, Queen consort of England  18 Oct 1254  Burgos, Castilla-Leon, Spain  
4 Adams, Abigail Lucretia  25 Oct 1871   
5 Adams, Anna  23 Oct 1804  West Springfield, Hampden, Massachusetts, USA  
6 Adams, Edmund Blaine  2 Oct 1942   
7 Adams, Eliza Harriet Robinson  28 Oct 1903   
8 Adams, Ezra Proctor  11 Oct 1875  Wellington, Ontario, Canada  
9 Adams, Hazel Lorraine  8 Oct 1938  Pierce, Washington, USA  
10 Adams, Illa Mae  26 Oct 1935   
11 Adams, Jack Howard  31 Oct 1948   
12 Adams, Deacon John I  31 Oct 1734  Norfolk, Massachusetts, USA  
13 Adams, President John II  25 Oct 1764  Weymouth, Norfolk, Massachusetts, USA  
14 Adams, Urban Smith  5 Oct 1944  Seattle, King, Washington, USA  
15 Adams, Doctor William Case  20 Oct 1857   
16 Adams |, Henry  19 Oct 1609  Charlton Mackrell, Somerset, England  
17 Alcock, Sarah  26 Oct 1670   
18 Anderson, Sidney Marvin  12 Oct 1943  Winger, Polk, Minnesota, USA  
19 Andrews, Elizabeth  Aft. 29 Oct 1746   
20 Appling, Joel II  17 Oct 1811  Oglethorpe, Georgia, USA  
21 Appling, Joel II  30 Oct 1814  St Clair, Alabama, USA  
22 Appling, Samuel  30 Oct 1814   
23 Armstrong, Charles Gustav  28 Oct 1903   
24 Artois +, Blanche  29 Oct 1276  Westminster, London, England  
25 Avery, Mary Ann  23 Oct 1856  Chambers, Alabama, USA  
26 Babbitt, Earl LeRoy I  Aft. 24 Oct 1943   
27 Baldwin, Robert  5 Oct 1590  Reading, Berkshire, England  
28 Ball, Isaac III  2 Oct 1814  Bristol, Addison, Vermont, USA  
29 Ball +, John  16 Oct 1690  Concord, Middlesex, Massachusetts, USA  
30 Barber ++ |, ^ Sergeant Thomas Edward  7 Oct 1640  Windsor, Hartford, Connecticut, USA  
31 Barnett, William H.  6 Oct 1850  Chambers, Alabama, USA  
32 Basset +, Aline  29 Oct 1271   
33 Bates, Raymond  5 Oct 1965  Emporia, Greensville, Virginia, USA  
34 Baugh, Elizabeth  2 Oct 1838  Jackson, Georgia, USA  
35 Baxter, Ida Rose  17 Oct 1900  Clarke, Georgia, USA  
36 Betts, Franklin  12 Oct 1820  Cecil, Maryland, USA  
37 Bigod, Roger  29 Oct 1271   
38 Bissell, Thomas  Oct 1655   
39 Blake, Anna  31 Oct 1848  Boston, Suffolk, Massachusetts, USA  
40 Blanchard, Walter  4 Oct 1906  Camak, Warren, Georgia, USA  
41 Bloodworth, Caroline  9 Oct 1906  Barnsville, Pike, Georgia, USA  
42 Bloomer, First Lady Elizabeth Ann  15 Oct 1948  Grand Rapids, Kent, Michigan, USA  
43 Bolt, Margaret E.  5 Oct 1869  Floyd, Georgia, USA  
44 Bolton, Nancy W.  30 Oct 1834  Wilkes, Georgia, USA  
45 Bolton, Penna  17 Oct 1811  Oglethorpe, Georgia, USA  
46 Box, Aaron II  18 Oct 1888  Charlevoix, Michigan, USA  
47 Box, Frank  9 Oct 1901  Carsonville, Sanilac, Michigan, USA  
48 Boylston, Susanna  31 Oct 1734  Norfolk, Massachusetts, USA  
49 Bradbury, Caroline T.  8 Oct 1861  Elbert, Georgia, USA  
50 Brent + p???, Jane Swan  Aft. 27 Oct 1781  Lancaster, Virginia, USA  


1 2 3 4 5 ... Next»