SELECT count(s.id)
FROM (
    SELECT id FROM l_artist_recording WHERE entity1 = xxx
    UNION ALL
    SELECT id FROM l_label_recording WHERE entity1 = xxx
);