SELECT DISTINCT "visitor"."ip", "name", "city", "region", "country", "visits", "asn", "organization", "updated_at" FROM "visitor" LEFT JOIN "visits" ON visitor.ip = visits.ip WHERE "asn" = 'AS23033'