CASE
WHEN b.uid IS NOT NULL
THEN IF(b.add_type='0','2','1')
WHEN c.uid IS NOT NULL THEN
'1' ELSE '0'
END AS 'addType'
CASE
WHEN b.uid IS NOT NULL
THEN IF(b.add_type='0','2','1')
WHEN c.uid IS NOT NULL THEN
'1' ELSE '0'
END AS 'addType'