CREATE TABLE table_48950 ("Name dates" CLOB, "Eldest daughter from  ( date )  to  ( date ) " CLOB, "Father" CLOB, "Date married" CLOB, "Husband dates" CLOB)

When did Louise, Princess royal get married?
SELECT "Date married" FROM table_48950 WHERE "Name dates" = 'louise, princess royal'
SELECT "Date married" FROM "table_48950" WHERE "Name dates" = 'louise, princess royal'