<commit_before>CREATE TABLE relbib_ids (
  record_id VARCHAR(10) NOT NULL PRIMARY KEY) DEFAULT CHARSET=utf8mb4;

GRANT DROP ON vufind.relbib_ids TO 'vufind'@'localhost';

CREATE VIEW resource_tags_relbib AS (
  SELECT * FROM resource_tags WHERE resource_id IN 
  (SELECT resource.id FROM resource JOIN relbib_ids 
   ON resource.record_id = relbib_ids.record_id)
);

CREATE TABLE bibstudies_ids (
  record_id VARCHAR(10) NOT NULL PRIMARY KEY) DEFAULT CHARSET=utf8mb4;

GRANT DROP ON vufind.bibstudies_ids TO 'vufind'@'localhost';

CREATE VIEW resource_tags_bibstudies AS (
  SELECT * FROM resource_tags WHERE resource_id IN 
  (SELECT resource.id FROM resource JOIN relbib_ids 
   ON resource.record_id = bibstudies_ids.record_id)
);
<commit_msg>Fix wrong variable<commit_after>CREATE TABLE relbib_ids (
  record_id VARCHAR(10) NOT NULL PRIMARY KEY) DEFAULT CHARSET=utf8mb4;

GRANT DROP ON vufind.relbib_ids TO 'vufind'@'localhost';

CREATE VIEW resource_tags_relbib AS (
  SELECT * FROM resource_tags WHERE resource_id IN 
  (SELECT resource.id FROM resource JOIN relbib_ids 
   ON resource.record_id = relbib_ids.record_id)
);

CREATE TABLE bibstudies_ids (
  record_id VARCHAR(10) NOT NULL PRIMARY KEY) DEFAULT CHARSET=utf8mb4;

GRANT DROP ON vufind.bibstudies_ids TO 'vufind'@'localhost';

CREATE VIEW resource_tags_bibstudies AS (
  SELECT * FROM resource_tags WHERE resource_id IN 
  (SELECT resource.id FROM resource JOIN bibstudies_ids
   ON resource.record_id = bibstudies_ids.record_id)
);

{'fraction_non_alphanumeric': 0.06533333333333333, 'fraction_numerical': 0.010666666666666666, 'mean_word_length': 5.360169491525424, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5871044', 'n_tokens_mistral': 553, 'n_tokens_neox': 497, 'n_words': 146}