LGBTdb:Selected anniversaries

From lgbtDB
Jump to navigation Jump to search

This set of pages serves as a queue of selected anniversaries which populate the section of the Main Page each day. These pages also help facilitate and coordinate updates to this queue. The selected anniversaries are taken from events in history on each day of the year and holidays/observances from current calendars.

Queue

<templatestyles src="LGBTdb:Main Page/styles.css"/>

Today

LGBTdb:Selected anniversaries/today links to a page showing today's selected anniversaries.

On this day...
LGBTdb:Selected anniversaries/May 17
viewtalkedit (admins only)historyrelated changes

Tomorrow

On this day...
LGBTdb:Selected anniversaries/May 18
viewtalkedit (admins only)historyrelated changes

Resources for finding new suggestions

Queries to find new entries

Birthdays

This query returns all instances of real-life (human) persons with a birth date today. It uses the service wikibase:label to return the labels in your default language or in English.

PREFIX wd: <https://lgbtdb.wikibase.cloud/entity/>
PREFIX wdt: <https://lgbtdb.wikibase.cloud/prop/direct/>

SELECT DISTINCT ?person ?personLabel ?bdate
WHERE 
{
  ?person wdt:P1 wd:Q8775 . # Must be a human person (a real-life person)
  ?person wdt:P141 ?bdate . 
  FILTER (
    (MONTH(?bdate) = MONTH(NOW())) &&
    (DAY(?bdate) = DAY(NOW()))
  )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # Helps get the label in your language, if not, then en (English) language
}
ORDER BY ?bdate

Try it!


Deathdays

This query returns all instances of real-life (human) persons with a death date today. It uses the service wikibase:label to return the labels in your default language or in English.

PREFIX wd: <https://lgbtdb.wikibase.cloud/entity/>
PREFIX wdt: <https://lgbtdb.wikibase.cloud/prop/direct/>

SELECT DISTINCT ?person ?personLabel ?ddate
WHERE 
{
  ?person wdt:P1 wd:Q8775 . # Must be a human person (a real-life person)
  ?person wdt:P142 ?ddate . 
  FILTER (
    (MONTH(?ddate) = MONTH(NOW())) &&
    (DAY(?ddate) = DAY(NOW()))
  )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # Helps get the label in your language, if not, then en (English) language
}
ORDER BY ?bdate

Try it!


Notes