Discussion with JS-R by phone, during which we determined some immediate tasks:
SELECT * FROM `owners` WHERE own_institutional=0 AND own_surname=""and at JS-R's request, fixed 260 of them with this:
UPDATE `owners` SET `own_surname` = (SELECT RIGHT( `own_display_name` , LOCATE( ' ', REVERSE( `own_display_name` ) ) - 1 )) WHERE CHAR_LENGTH(`own_surname`) = 0 and own_institutional=0; UPDATE `owners` SET `own_forenames` = (SELECT LEFT( `own_display_name` , CHAR_LENGTH( `own_display_name`) - LOCATE( ' ', REVERSE( `own_display_name` ) ) )) WHERE CHAR_LENGTH(`own_forenames`) = 0 and own_institutional = 0;
SELECT owners.* FROM owners LEFT JOIN owners_to_titles ON owners.own_owner_id=owners_to_titles.ott_owner_id_fk WHERE owners_to_titles.ott_owner_id_fk IS NULL;and sent to JS-R in the form of a spreadsheet. These owners may be linked in some other way, of course -- as sellers, or through mortgages. "owners" is actually "actors" (individuals or companies who act in transactions).
No Pingbacks for this post yet...
A database project to collect historical data on properties and titles.
|<< <||> >>|