Dolbex

If you have more than a couple thousand records you want to geocode all at once we found a great service from USC’s GIS department that allows you to geocode records in an Access database.  It’s not terribly fast but we were able to geocode nearly 200,000 records in a couple of days. Just make sure your computer isn’t set to go to sleep an hour after you step away from the computer…. :/

https://webgis.usc.edu/Default.aspx

DELETE users.*, profiles.*
FROM users u, profiles prof
WHERE u.id = prof.user_id
AND u.created < '2009-01-01'

DELETE orphan_table FROM orphan_table
LEFT JOIN user_table
ON orphan_table.user_id = user_table.id
WHERE user_table.id IS NULL;