SELECT DISTINCT(uli.user_id), di.debrid_id
FROM fh_user_login_ip uli
INNER JOIN fh_debrid_ip di
  ON di.ip = uli.ip

Запрос открыт за 159,598c [159,596c выполнение, 0,002c выборка]

CREATE TABLE fh_debrid_ip (
  id int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  debrid_id int(10) UNSIGNED NOT NULL,
  ip int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (id),
  UNIQUE INDEX UX_debrid_debrid_ip (debrid_id, ip),
  CONSTRAINT FK_debrid_ip FOREIGN KEY (debrid_id)
  REFERENCES fh_debrid (id) ON DELETE RESTRICT ON UPDATE RESTRICT
)
ENGINE = INNODB
AUTO_INCREMENT = 18059
AVG_ROW_LENGTH = 77
CHARACTER SET utf8
COLLATE utf8_general_ci;

CREATE TABLE fh_user_login_ip (
  id int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  user_id int(10) UNSIGNED NOT NULL,
  ip int(10) UNSIGNED NOT NULL,
  date timestamp DEFAULT CURRENT_TIMESTAMP,
  pc_id char(13) DEFAULT NULL,
  country_id int(10) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (id),
  INDEX IX_user_login_user_ip (user_id, ip),
  CONSTRAINT FK_last_login_ip FOREIGN KEY (user_id)
  REFERENCES fh_user (id) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT FK_user_login_ip_country FOREIGN KEY (country_id)
  REFERENCES fh_country (id) ON DELETE CASCADE ON UPDATE RESTRICT
)
ENGINE = INNODB
AUTO_INCREMENT = 375674
AVG_ROW_LENGTH = 46
CHARACTER SET utf8
COLLATE utf8_general_ci;