upgrade/1.1.14/02_delete_unlinked_rows.sql

   1 DELETE * FROM profile_addresses WHERE pid = 44872 AND jobid = 0 AND groupid = 0 AND type = 'home' AND id = 0;
   2 DELETE * FROM profile_addresses WHERE pid = 16669 AND jobid = 0 AND groupid = 0 AND type = 'job' AND id = 0;
   3 DELETE * FROM profile_addresses WHERE pid = 44872 AND jobid = 0 AND groupid = 0 AND type = 'job' AND id = 0;
   4 DELETE * FROM profile_phones WHERE pid = 16669 AND link_type = 'pro' AND link_id = 0 AND tel_id = 0;
   5 DELETE * FROM profile_phones WHERE pid = 44872 AND link_type = 'pro' AND link_id = 0 AND tel_id = 0;
   6 DELETE * FROM profile_phones WHERE pid = 44872 AND link_type = 'user' AND link_id = 0 AND tel_id = 0;
   7 DELETE * FROM profile_phones WHERE pid = 44872 AND link_type = 'user' AND link_id = 0 AND tel_id = 1;