select * from preferences where domain LIKE "com.apple.sharingd" and username = (SELECT username FROM logged_in_users l, users u WHERE l.user = u.username LIMIT 1) and key = 'DiscoverableMode' and value = 'Everyone';