CREATE TABLE pin_to_url (
  pin int PRIMARY KEY,
  url varchar(255)
);

SELECT v.*, pu.url FROM visitors v
  JOIN pin_to_url pu ON pu.pin = v.pin
  ORDER BY whatever;