Database error 
          SELECT COUNT(*)
          FROM tbl__artist2subgroup asg
          JOIN tbl__artist_doc ad
          ON asg.artist_id=ad.tbl_obj_id
          WHERE asg.subgroup_id="2747"
          AND ad.active = 1
          AND ad.registration_confirmed = 1