1eecf4ff8376317b0e5912935046fbb8afa5cebd
1 -- Deletes lost addresses, medals and phones.
3 FROM profile_addresses
AS a
4 WHERE a.
type = 'home' AND NOT EXISTS (SELECT *
8 FROM profile_addresses
AS a
9 WHERE a.
type = 'job' AND NOT EXISTS (SELECT *
11 WHERE a.pid
= j.pid
AND a.
id = j.
id);
13 FROM profile_addresses
AS a
14 WHERE a.
type = 'hq' AND NOT EXISTS (SELECT *
15 FROM profile_job_enum
AS je
16 WHERE a.jobid
= je.
id);
18 FROM profile_addresses
AS a
19 WHERE a.
type = 'group' AND NOT EXISTS (SELECT *
21 WHERE a.groupid
= g.
id);
23 FROM profile_medals
AS m
24 WHERE m.gid
!= 0 AND NOT EXISTS (SELECT *
25 FROM profile_medal_grade_enum
AS mg
26 WHERE m.mid
= mg.mid
AND m.gid
= mg.gid
);
28 FROM profile_phones
AS p
29 WHERE p.link_type
= 'address' AND NOT EXISTS (SELECT *
30 FROM profile_addresses
AS a
31 WHERE p.pid
= a.pid
AND p.link_id
= a.
id);
33 FROM profile_phones
AS p
34 WHERE p.link_type
= 'pro' AND NOT EXISTS (SELECT *
36 WHERE p.pid
= j.pid
AND p.link_id
= j.
id);
38 FROM profile_phones
AS p
39 WHERE p.link_type
= 'user' AND NOT EXISTS (SELECT *
41 WHERE p.pid
= pf.pid
);
43 FROM profile_phones
AS p
44 WHERE p.link_type
= 'hq' AND NOT EXISTS (SELECT *
45 FROM profile_job_enum
AS je
46 WHERE p.link_id
= je.
id);
48 FROM profile_phones
AS p
49 WHERE p.link_type
= 'group' AND NOT EXISTS (SELECT *
51 WHERE p.link_id
= g.
id);
53 -- vim:set syntax=mysql: