SELECT p.* FROM `pins` as p JOIN client_map cp ON cp.PIN = p.PIN WHERE cp.Client = 'Volusion' GROUP BY p.PIN LIMIT 1000