U8yxEU8h

1--DROP TABLE relatii
2DROP TABLE user_lists CASCADE CONSTRAINTS;
3/
4DROP TABLE user_ratings CASCADE CONSTRAINTS;
5/
6DROP TABLE movie_list CASCADE CONSTRAINTS;
7/
8DROP TABLE rating_review CASCADE CONSTRAINTS;
9/
10DROP TABLE movie_ratings CASCADE CONSTRAINTS;
11/
12DROP TABLE movie_genre CASCADE CONSTRAINTS;
13/
14DROP TABLE movie_crew CASCADE CONSTRAINTS;
15/
16--DROP TABLE entitati
17DROP TABLE users CASCADE CONSTRAINTS;
18/
19DROP TABLE ratings CASCADE CONSTRAINTS;
20/
21DROP TABLE lists CASCADE CONSTRAINTS;
22/
23DROP TABLE genres CASCADE CONSTRAINTS;
24/
25DROP TABLE movies CASCADE CONSTRAINTS;
26/
27DROP TABLE reviews CASCADE CONSTRAINTS;
28/
29DROP TABLE roles CASCADE CONSTRAINTS;
30/
31DROP TABLE people CASCADE CONSTRAINTS;
32/
33--Creare tabele entitati
34CREATE TABLE users
35(
36    id NUMBER CONSTRAINT id_users_primary_key PRIMARY KEY,
37    username VARCHAR2(30) NOT NULL CONSTRAINT username_must_be_unique UNIQUE,
38    password RAW(64) CONSTRAINT password_not_null NOT NULL,
39    e_mail VARCHAR2(320) NOT NULL CONSTRAINT e_mail_must_be_unique UNIQUE, --64@255
40    rank CHAR(1) NOT NULL CONSTRAINT rank_must_be_valid CHECK (rank IN ('u', 'm', 'a')), -- user / moderator / admin
41    birth_date DATE NOT NULL,
42    origin_country VARCHAR2(50),
43    created_at DATE DEFAULT CURRENT_DATE,
44    updated_at DATE DEFAULT CURRENT_DATE
45)
46/
47CREATE TABLE movies
48(
49    id NUMBER CONSTRAINT id_movies_primary_key PRIMARY KEY,
50    title VARCHAR2(150) NOT NULL,
51    image BLOB NOT NULL,
52    release_date DATE NOT NULL,
53    duration INTERVAL DAY TO SECOND NOT NULL,
54    parental_rating VARCHAR2(2),
55    origin_country VARCHAR2(50),
56    language VARCHAR2(2),
57    budget NUMBER,
58    created_at DATE DEFAULT CURRENT_DATE,
59    updated_at DATE DEFAULT CURRENT_DATE
60)
61/
62CREATE TABLE people
63(
64    id NUMBER CONSTRAINT id_people_primary_key PRIMARY KEY,
65    first_name VARCHAR2(100),
66    last_name VARCHAR2(100),
67    birth_date DATE,
68    description VARCHAR2(1000),
69    origin_country VARCHAR2(50),
70    created_at DATE DEFAULT CURRENT_DATE,
71    updated_at DATE DEFAULT CURRENT_DATE
72)
73/
74CREATE TABLE reviews
75(
76    id NUMBER CONSTRAINT id_reviews_primary_key PRIMARY KEY,
77    title VARCHAR2(100) NOT NULL,
78    description VARCHAR2(1000) NOT NULL,
79    review_date DATE NOT NULL,
80    likes NUMBER DEFAULT 0,
81    dislikes NUMBER DEFAULT 0,
82    spoiler NUMBER(1) DEFAULT 0,
83    created_at DATE DEFAULT CURRENT_DATE,
84    updated_at DATE DEFAULT CURRENT_DATE
85)
86/
87CREATE TABLE roles
88(
89    id NUMBER CONSTRAINT id_roles_primary_key PRIMARY KEY,
90    role VARCHAR2(50) NOT NULL CONSTRAINT role_must_be_unique UNIQUE,
91    created_at DATE DEFAULT CURRENT_DATE,
92    updated_at DATE DEFAULT CURRENT_DATE
93)
94/
95CREATE TABLE ratings
96(
97    id NUMBER CONSTRAINT id_ratings_primary_key PRIMARY KEY,
98    rating NUMBER(2) NOT NULL,
99    created_at DATE DEFAULT CURRENT_DATE,
100    updated_at DATE DEFAULT CURRENT_DATE
101)
102/
103CREATE TABLE lists
104(
105    id NUMBER CONSTRAINT id_lists_primary_key PRIMARY KEY,
106    creation_date DATE DEFAULT CURRENT_DATE,
107    created_at DATE DEFAULT CURRENT_DATE,
108    updated_at DATE DEFAULT CURRENT_DATE
109)
110/
111CREATE TABLE genres
112(
113    id NUMBER CONSTRAINT id_genres_primary_key PRIMARY KEY,
114    genre VARCHAR2(25) NOT NULL CONSTRAINT genre_must_be_unique UNIQUE,
115    created_at DATE DEFAULT CURRENT_DATE,
116    updated_at DATE DEFAULT CURRENT_DATE
117)
118/
119--Creare tabele relatii
120CREATE TABLE user_lists
121(
122    id NUMBER CONSTRAINT id_user_lists_primary_key PRIMARY KEY,
123    id_user NUMBER,
124    id_list NUMBER,
125    created_at DATE DEFAULT CURRENT_DATE,
126    updated_at DATE DEFAULT CURRENT_DATE,
127    
128    CONSTRAINT fk_user_lists_id_user FOREIGN KEY (id_user) REFERENCES users(id),
129    CONSTRAINT fk_user_lists_id_list FOREIGN KEY (id_list) REFERENCES lists(id)
130)
131/
132CREATE TABLE user_ratings
133(
134    id NUMBER CONSTRAINT id_user_ratings_primary_key PRIMARY KEY,
135    id_user NUMBER,
136    id_rating NUMBER,
137    created_at DATE DEFAULT CURRENT_DATE,
138    updated_at DATE DEFAULT CURRENT_DATE,
139    
140    CONSTRAINT fk_user_ratings_id_user FOREIGN KEY (id_user) REFERENCES users(id),
141    CONSTRAINT fk_user_ratings_id_rating FOREIGN KEY (id_rating) REFERENCES ratings(id)
142)
143/
144CREATE TABLE rating_review
145(
146    id NUMBER CONSTRAINT id_user_review_primary_key PRIMARY KEY,
147    id_rating NUMBER,
148    id_review NUMBER,
149    created_at DATE DEFAULT CURRENT_DATE,
150    updated_at DATE DEFAULT CURRENT_DATE,
151    
152    CONSTRAINT fk_rating_review_id_rating FOREIGN KEY (id_rating) REFERENCES ratings(id),
153    CONSTRAINT fk_reting_review_id_review FOREIGN KEY (id_review) REFERENCES reviews(id)
154)
155/
156CREATE TABLE movie_ratings
157(
158    id NUMBER CONSTRAINT id_movie_ratings_primary_key PRIMARY KEY,
159    id_rating NUMBER,
160    id_movie NUMBER,
161    created_at DATE DEFAULT CURRENT_DATE,
162    updated_at DATE DEFAULT CURRENT_DATE,
163    
164    CONSTRAINT fk_movie_ratings_id_rating FOREIGN KEY (id_rating) REFERENCES ratings(id),
165    CONSTRAINT fk_movie_ratings_id_movie FOREIGN KEY (id_movie) REFERENCES movies(id)
166)
167/
168CREATE TABLE movie_genre
169(
170    id NUMBER CONSTRAINT id_movie_genre_primary_key PRIMARY KEY,
171    id_genre NUMBER,
172    id_movie NUMBER,
173    created_at DATE DEFAULT CURRENT_DATE,
174    updated_at DATE DEFAULT CURRENT_DATE,
175    
176    CONSTRAINT fk_movie_genre_id_genre FOREIGN KEY (id_genre) REFERENCES genres(id),
177    CONSTRAINT fk_movie_genre_id_movie FOREIGN KEY (id_movie) REFERENCES movies(id)
178)
179/
180CREATE TABLE movie_list
181(
182    id NUMBER CONSTRAINT id_movie_list_primary_key PRIMARY KEY,
183    id_list NUMBER,
184    id_movie NUMBER,
185    created_at DATE DEFAULT CURRENT_DATE,
186    updated_at DATE DEFAULT CURRENT_DATE,
187    
188    CONSTRAINT fk_movie_list_id_list FOREIGN KEY (id_list) REFERENCES lists(id),
189    CONSTRAINT fk_movie_list_id_movie FOREIGN KEY (id_movie) REFERENCES movies(id)
190)
191/
192CREATE TABLE movie_crew
193(
194    id NUMBER CONSTRAINT id_movie_crew_primary_key PRIMARY KEY,
195    id_person NUMBER,
196    id_role NUMBER,
197    id_movie NUMBER,
198    created_at DATE DEFAULT CURRENT_DATE,
199    updated_at DATE DEFAULT CURRENT_DATE,
200    
201    CONSTRAINT fk_movie_crew_id_person FOREIGN KEY (id_person) REFERENCES people(id),
202    CONSTRAINT fk_movie_crew_id_role FOREIGN KEY (id_role) REFERENCES roles(id),
203    CONSTRAINT fk_movie_crew_id_movie FOREIGN KEY (id_movie) REFERENCES movies(id)
204)
205/
206--Triggers
207--a_increment -> auto_increment
208--updt_at -> updated_at
209--Auto-Increment pentru toate tabelele
210DROP SEQUENCE SEQ_ID_GENRES_ICRMT;
211/
212DROP SEQUENCE SEQ_ID_LISTS_ICRMT;
213/
214DROP SEQUENCE SEQ_ID_MOVIES_ICRMT;
215/
216DROP SEQUENCE SEQ_ID_MOVIE_CREW_ICRMT;
217/
218DROP SEQUENCE SEQ_ID_MOVIE_GENRE_ICRMT;
219/
220DROP SEQUENCE SEQ_ID_MOVIE_LIST_ICRMT;
221/
222DROP SEQUENCE SEQ_ID_MOVIE_RATINGS_ICRMT;
223/
224DROP SEQUENCE SEQ_ID_PEOPLE_ICRMT;
225/
226DROP SEQUENCE SEQ_ID_RATINGS_ICRMT;
227/
228DROP SEQUENCE SEQ_ID_RATING_REVIEW_ICRMT;
229/
230DROP SEQUENCE SEQ_ID_REVIEWS_ICRMT;
231/
232DROP SEQUENCE SEQ_ID_ROLES_ICRMT;
233/
234DROP SEQUENCE SEQ_ID_USERS_ICRMT;
235/
236DROP SEQUENCE SEQ_ID_USER_LISTS_ICRMT;
237/
238DROP SEQUENCE SEQ_ID_USER_RATINGS_ICRMT;
239/
240CREATE SEQUENCE seq_id_users_icrmt START WITH 1 MINVALUE 0 INCREMENT BY 1 NOCACHE;
241/
242CREATE SEQUENCE seq_id_movies_icrmt START WITH 1 MINVALUE 0 INCREMENT BY 1 NOCACHE;
243/
244CREATE SEQUENCE seq_id_people_icrmt START WITH 1 INCREMENT BY 1 MINVALUE 0 NOCACHE;
245/
246CREATE SEQUENCE seq_id_reviews_icrmt START WITH 1 INCREMENT BY 1 MINVALUE 0 NOCACHE;
247/
248CREATE SEQUENCE seq_id_roles_icrmt START WITH 1 INCREMENT BY 1 MINVALUE 0 NOCACHE;
249/
250CREATE SEQUENCE seq_id_ratings_icrmt START WITH 1 INCREMENT BY 1 MINVALUE 0 NOCACHE;
251/
252CREATE SEQUENCE seq_id_lists_icrmt START WITH 1 INCREMENT BY 1 MINVALUE 0 NOCACHE;
253/
254CREATE SEQUENCE seq_id_genres_icrmt START WITH 1 INCREMENT BY 1 MINVALUE 0 NOCACHE;
255/
256CREATE SEQUENCE seq_id_user_lists_icrmt START WITH 1 INCREMENT BY 1 MINVALUE 0 NOCACHE;
257/
258CREATE SEQUENCE seq_id_user_ratings_icrmt START WITH 1 INCREMENT BY 1 MINVALUE 0 NOCACHE;
259/
260CREATE SEQUENCE seq_id_rating_review_icrmt START WITH 1 INCREMENT BY 1 MINVALUE 0 NOCACHE;
261/
262CREATE SEQUENCE seq_id_movie_ratings_icrmt START WITH 1 INCREMENT BY 1 MINVALUE 0 NOCACHE;
263/
264CREATE SEQUENCE seq_id_movie_genre_icrmt START WITH 1 INCREMENT BY 1 MINVALUE 0 NOCACHE;
265/
266CREATE SEQUENCE seq_id_movie_list_icrmt START WITH 1 INCREMENT BY 1 MINVALUE 0 NOCACHE;
267/
268CREATE SEQUENCE seq_id_movie_crew_icrmt START WITH 1 INCREMENT BY 1 MINVALUE 0 NOCACHE;
269/
270CREATE OR REPLACE TRIGGER id_users_a_increment 
271    BEFORE INSERT ON users 
272    FOR EACH ROW
273BEGIN
274  SELECT seq_id_users_icrmt.NEXTVAL
275  INTO   :new.id
276  FROM   dual;
277END;
278/
279CREATE OR REPLACE TRIGGER id_movies_a_increment 
280    BEFORE INSERT ON movies 
281    FOR EACH ROW
282BEGIN
283  SELECT seq_id_movies_icrmt.NEXTVAL
284  INTO   :new.id
285  FROM   dual;
286END;
287/
288CREATE OR REPLACE TRIGGER id_people_a_increment 
289    BEFORE INSERT ON people
290    FOR EACH ROW
291BEGIN
292  SELECT seq_id_people_icrmt.NEXTVAL
293  INTO   :new.id
294  FROM   dual;
295END;
296/
297CREATE OR REPLACE TRIGGER id_reviews_a_increment 
298    BEFORE INSERT ON reviews
299    FOR EACH ROW
300BEGIN
301  SELECT seq_id_reviews_icrmt.NEXTVAL
302  INTO   :new.id
303  FROM   dual;
304END;
305/
306CREATE OR REPLACE TRIGGER id_roles_a_increment 
307    BEFORE INSERT ON roles
308    FOR EACH ROW
309BEGIN
310  SELECT seq_id_roles_icrmt.NEXTVAL
311  INTO   :new.id
312  FROM   dual;
313END;
314/
315CREATE OR REPLACE TRIGGER id_ratings_a_increment 
316    BEFORE INSERT ON ratings
317    FOR EACH ROW 
318BEGIN
319  SELECT seq_id_ratings_icrmt.NEXTVAL
320  INTO   :NEW.ID
321  FROM   dual;
322END;
323/
324CREATE OR REPLACE TRIGGER id_lists_a_increment 
325    BEFORE INSERT ON lists
326    FOR EACH ROW
327BEGIN
328  SELECT seq_id_lists_icrmt.NEXTVAL
329  INTO   :new.id
330  FROM   dual;
331END;
332/
333CREATE OR REPLACE TRIGGER id_genres_a_increment 
334    BEFORE INSERT ON genres
335    FOR EACH ROW
336BEGIN
337  SELECT seq_id_genres_icrmt.NEXTVAL
338  INTO   :new.id
339  FROM   dual;
340END;
341/
342CREATE OR REPLACE TRIGGER id_user_lists_a_increment 
343    BEFORE INSERT ON user_lists
344    FOR EACH ROW
345BEGIN
346  SELECT seq_id_user_lists_icrmt.NEXTVAL
347  INTO   :new.id
348  FROM   dual;
349END;
350/
351CREATE OR REPLACE TRIGGER id_user_ratings_a_increment 
352    BEFORE INSERT ON user_ratings
353    FOR EACH ROW
354BEGIN
355  SELECT seq_id_user_ratings_icrmt.NEXTVAL
356  INTO   :new.id
357  FROM   dual;
358END;
359/
360CREATE OR REPLACE TRIGGER id_rating_review_a_increment 
361    BEFORE INSERT ON rating_review
362    FOR EACH ROW
363BEGIN
364  SELECT seq_id_rating_review_icrmt.NEXTVAL
365  INTO   :new.id
366  FROM   dual;
367END;
368/
369CREATE OR REPLACE TRIGGER id_movie_ratings_a_increment
370    BEFORE INSERT ON movie_ratings
371    FOR EACH ROW
372BEGIN
373  SELECT seq_id_movie_ratings_icrmt.NEXTVAL
374  INTO   :new.id
375  FROM   dual;
376END;
377/
378CREATE OR REPLACE TRIGGER id_movie_genre_a_increment 
379    BEFORE INSERT ON movie_genre
380    FOR EACH ROW
381BEGIN
382  SELECT seq_id_movie_genre_icrmt.NEXTVAL
383  INTO   :new.id
384  FROM   dual;
385END;
386/
387CREATE OR REPLACE TRIGGER id_movie_list_a_increment 
388    BEFORE INSERT ON movie_list
389    FOR EACH ROW
390BEGIN
391  SELECT seq_id_movie_list_icrmt.NEXTVAL
392  INTO   :new.id
393  FROM   dual;
394END;
395/
396CREATE OR REPLACE TRIGGER id_movie_crew_a_increment 
397    BEFORE INSERT ON movie_crew
398    FOR EACH ROW
399BEGIN
400  SELECT seq_id_movie_crew_icrmt.NEXTVAL
401  INTO   :new.id
402  FROM   dual;
403END;
404/
405CREATE OR REPLACE TRIGGER users_update_updt_at
406    BEFORE UPDATE ON users
407    FOR EACH ROW
408BEGIN
409   SELECT CURRENT_DATE
410   INTO :NEW.updated_at
411   FROM dual;
412END;
413/
414CREATE OR REPLACE TRIGGER movies_update_updt_at
415    BEFORE UPDATE ON movies
416    FOR EACH ROW
417BEGIN
418   SELECT CURRENT_DATE
419   INTO :NEW.updated_at
420   FROM dual;
421END;
422/
423CREATE OR REPLACE TRIGGER people_update_updt_at
424    BEFORE UPDATE ON people
425    FOR EACH ROW
426BEGIN
427   SELECT CURRENT_DATE
428   INTO :NEW.updated_at
429   FROM dual;
430END;
431/
432CREATE OR REPLACE TRIGGER reviews_update_updt_at
433    BEFORE UPDATE ON reviews
434    FOR EACH ROW
435BEGIN
436   SELECT CURRENT_DATE
437   INTO :NEW.updated_at
438   FROM dual;
439END;
440/
441CREATE OR REPLACE TRIGGER roles_update_updt_at
442    BEFORE UPDATE ON roles
443    FOR EACH ROW
444BEGIN
445   SELECT CURRENT_DATE
446   INTO :NEW.updated_at
447   FROM dual;
448END;
449/
450CREATE OR REPLACE TRIGGER ratings_update_updt_at
451    BEFORE UPDATE ON ratings
452    FOR EACH ROW
453BEGIN
454   SELECT CURRENT_DATE
455   INTO :NEW.updated_at
456   FROM dual;
457END;
458/
459CREATE OR REPLACE TRIGGER lists_update_updt_at
460    BEFORE UPDATE ON lists
461    FOR EACH ROW
462BEGIN
463   SELECT CURRENT_DATE
464   INTO :NEW.updated_at
465   FROM dual;
466END;
467/
468CREATE OR REPLACE TRIGGER genres_update_updt_at
469    BEFORE UPDATE ON genres
470    FOR EACH ROW
471BEGIN
472   SELECT CURRENT_DATE
473   INTO :NEW.updated_at
474   FROM dual;
475END;
476/
477CREATE OR REPLACE TRIGGER user_lists_update_updt_at
478    BEFORE UPDATE ON user_lists
479    FOR EACH ROW
480BEGIN
481   SELECT CURRENT_DATE
482   INTO :NEW.updated_at
483   FROM dual;
484END;
485/
486CREATE OR REPLACE TRIGGER user_ratings_update_updt_at
487    BEFORE UPDATE ON user_ratings
488    FOR EACH ROW
489BEGIN
490   SELECT CURRENT_DATE
491   INTO :NEW.updated_at
492   FROM dual;
493END;
494/
495CREATE OR REPLACE TRIGGER rating_review_update_updt_at
496    BEFORE UPDATE ON rating_review
497    FOR EACH ROW
498BEGIN
499   SELECT CURRENT_DATE
500   INTO :NEW.updated_at
501   FROM dual;
502END;
503/
504CREATE OR REPLACE TRIGGER movie_ratings_update_updt_at
505    BEFORE UPDATE ON movie_ratings
506    FOR EACH ROW
507BEGIN
508   SELECT CURRENT_DATE
509   INTO :NEW.updated_at
510   FROM dual;
511END;
512/
513CREATE OR REPLACE TRIGGER movie_genre_update_updt_at
514    BEFORE UPDATE ON movie_genre
515    FOR EACH ROW
516BEGIN
517   SELECT CURRENT_DATE
518   INTO :NEW.updated_at
519   FROM dual;
520END;
521/
522CREATE OR REPLACE TRIGGER movie_list_update_updt_at
523    BEFORE UPDATE ON movie_list
524    FOR EACH ROW
525BEGIN
526   SELECT CURRENT_DATE
527   INTO :NEW.updated_at
528   FROM dual;
529END;
530/
531CREATE OR REPLACE TRIGGER movie_crew_update_updt_at
532    BEFORE UPDATE ON movie_crew
533    FOR EACH ROW
534BEGIN
535   SELECT CURRENT_DATE
536   INTO :NEW.updated_at
537   FROM dual;
538END;
539/
540CREATE OR REPLACE TRIGGER check_age_threshold
541  BEFORE INSERT OR UPDATE ON users
542  FOR EACH ROW
543BEGIN
544  IF (TRUNC(MONTHS_BETWEEN(SYSDATE, :NEW.birth_date) / 12) < 10) THEN
545    RAISE_APPLICATION_ERROR(-20001, 'Invalid date_of_birth: the user must be over 10 years old: ');
546  END IF;
547END;
548/
549
550--Procedura pentru populare tabela de users
551CREATE OR REPLACE PROCEDURE populate_users_table(p_total_users IN NUMBER) AS
552    TYPE username_p_s_array IS VARRAY(200) OF users.username%TYPE;
553    TYPE username_middle_array IS VARRAY(1000) OF users.username%TYPE;
554    TYPE e_mail_domain_array IS VARRAY(150) OF users.e_mail%TYPE;
555    TYPE origin_country_array IS VARRAY(200) OF users.origin_country%TYPE;
556
557    v_username users.username%TYPE; --varchar2(30)
558    v_password users.password%TYPE; --CHAR(64)
559    v_e_mail users.e_mail%TYPE; --VARCHAR2(320)
560    v_rank users.rank%TYPE; --CHAR(1)
561    v_birth_date users.birth_date%TYPE; --DATE
562    v_origin_country users.origin_country%TYPE; --VARCHAR2(50)
563
564    v_username_sufixes_prefixes username_p_s_array := username_p_s_array('now','resources','tools','source','review','system','book','guide','talk','data','vision','load','box','focus','beat','voice','share','cafe','nexus','zone','sight','link','lab','insight','vine','board','flow','signs','network','wire','cast','ville','nation','egg','cove','news','today','future','fun','watch','story','fever','coast','side','road','heat','bite','insider','club','connect','the','my','i','me','we','you','e','top','pro','best','super','ultra','all','cyber','simply','free','1st','meta','re','metro','urban','head','hit','front','techno','ever','rush','think','solo','radio','vip','hot','smart','cool','hot','fast','fresh','sleek','first','daily','best','sharp','light','classic','fast','great','quick','ubi','bis','ad','ambi','inter','liber','mono','poli','tele','omni','exo','extra','hyper','hypo','intro','proto','intra','micro','macro','multi','neo','iso','mono','io','virtus','ego','vox','ex','ideo','novo','novus','pax','rex','velox','verus','vivo','nova','pico','nano','micro','milli','kilo','mega','giga','tera','peta','aero','cosmo','deca','eco','geo','hex','oxy','uni','poly','media','direct','access','ez','easy','info','interactive','biz','buzz','bit','byte','up','tech','on','out','auto','pulse','x','venture','trend','life','retro','secret');
565    v_username_middle username_middle_array := username_middle_array('ability','able','about','above','accept','according','account','across','act','action','activity','actually','add','address','administration','admit','adult','affect','after','again','against','age','agency','agent','ago','agree','agreement','ahead','air','all','allow','almost','alone','along','already','also','although','always','American','among','amount','analysis','and','animal','another','answer','any','anyone','anything','appear','apply','approach','area','argue','arm','around','arrive','art','article','artist','as','ask','assume','at','attack','attention','attorney','audience','author','authority','available','avoid','away','baby','back','bad','bag','ball','bank','bar','base','be','beat','beautiful','because','become','bed','before','begin','behavior','behind','believe','benefit','best','better','between','beyond','big','bill','billion','bit','black','blood','blue','board','body','book','born','both','box','boy','break','bring','brother','budget','build','building','business','but','buy','by','call','camera','campaign','can','cancer','candidate','capital','car','card','care','career','carry','case','catch','cause','cell','center','central','century','certain','certainly','chair','challenge','chance','change','character','charge','check','child','choice','choose','church','citizen','city','civil','claim','class','clear','clearly','close','coach','cold','collection','college','color','come','commercial','common','community','company','compare','computer','concern','condition','conference','Congress','consider','consumer','contain','continue','control','cost','could','country','couple','course','court','cover','create','crime','cultural','culture','cup','current','customer','cut','dark','data','daughter','day','dead','deal','death','debate','decade','decide','decision','deep','defense','degree','Democrat','democratic','describe','design','despite','detail','determine','develop','development','die','difference','different','difficult','dinner','direction','director','discover','discuss','discussion','disease','do','doctor','dog','door','down','draw','dream','drive','drop','drug','during','each','early','east','easy','eat','economic','economy','edge','education','effect','effort','eight','either','election','else','employee','end','energy','enjoy','enough','enter','entire','environment','environmental','especially','establish','even','evening','event','ever','every','everybody','everyone','everything','evidence','exactly','example','executive','exist','expect','experience','expert','explain','eye','face','fact','factor','fail','fall','family','far','fast','father','fear','federal','feel','feeling','few','field','fight','figure','fill','film','final','finally','financial','find','fine','finger','finish','fire','firm','first','fish','five','floor','fly','focus','follow','food','foot','for','force','foreign','forget','form','former','forward','four','free','friend','from','front','full','fund','future','game','garden','gas','general','generation','get','girl','give','glass','go','goal','good','government','great','green','ground','group','grow','growth','guess','gun','guy','hair','half','hand','hang','happen','happy','hard','have','he','head','health','hear','heart','heat','heavy','help','her','here','herself','high','him','himself','his','history','hit','hold','home','hope','hospital','hot','hotel','hour','house','how','however','huge','human','hundred','husband','I','idea','identify','if','image','imagine','impact','important','improve','in','include','including','increase','indeed','indicate','individual','industry','information','inside','instead','institution','interest','interesting','international','interview','into','investment','involve','issue','it','item','its','itself','job','join','just','keep','key','kid','kill','kind','kitchen','know','knowledge','land','language','large','last','late','later','laugh','law','lawyer','lay','lead','leader','learn','least','leave','left','leg','legal','less','let','letter','level','lie','life','light','like','likely','line','list','listen','little','live','local','long','look','lose','loss','lot','love','low','machine','magazine','main','maintain','major','majority','make','man','manage','management','manager','many','market','marriage','material','matter','may','maybe','me','mean','measure','media','medical','meet','meeting','member','memory','mention','message','method','middle','might','military','million','mind','minute','miss','mission','model','modern','moment','money','month','more','morning','most','mother','mouth','move','movement','movie','Mr','Mrs','much','music','must','my','myself','name','nation','national','natural','nature','near','nearly','necessary','need','network','never','new','news','newspaper','next','nice','night','no','none','nor','north','not','note','nothing','notice','now','nt','number','occur','of','off','offer','office','officer','official','often','oh','oil','ok','old','on','once','one','only','onto','open','operation','opportunity','option','or','order','organization','other','others','our','out','outside','over','own','owner','page','pain','painting','paper','parent','part','participant','particular','particularly','partner','party','pass','past','patient','pattern','pay','peace','people','per','perform','performance','perhaps','period','person','personal','phone','physical','pick','picture','piece','place','plan','plant','play','player','PM','point','police','policy','political','politics','poor','popular','population','position','positive','possible','power','practice','prepare','present','president','pressure','pretty','prevent','price','private','probably','problem','process','produce','product','production','professional','professor','program','project','property','protect','prove','provide','public','pull','purpose','push','put','quality','question','quickly','quite','race','radio','raise','range','rate','rather','reach','read','ready','real','reality','realize','really','reason','receive','recent','recently','recognize','record','red','reduce','reflect','region','relate','relationship','religious','remain','remember','remove','report','represent','Republican','require','research','resource','respond','response','responsibility','rest','result','return','reveal','rich','right','rise','risk','road','rock','role','room','rule','run','safe','same','save','say','scene','school','science','scientist','score','sea','season','seat','second','section','security','see','seek','seem','sell','send','senior','sense','series','serious','serve','service','set','seven','several','sex','sexual','shake','share','she','shoot','short','shot','should','shoulder','show','side','sign','significant','similar','simple','simply','since','sing','single','sister','sit','site','situation','six','size','skill','skin','small','smile','so','social','society','soldier','some','somebody','someone','something','sometimes','son','song','soon','sort','sound','source','south','southern','space','speak','special','specific','speech','spend','sport','spring','staff','stage','stand','standard','star','start','state','statement','station','stay','step','still','stock','stop','store','story','strategy','street','strong','structure','student','study','stuff','style','subject','success','successful','such','suddenly','suffer','suggest','summer','support','sure','surface','system','table','take','talk','task','tax','teach','teacher','team','technology','television','tell','ten','tend','term','test','than','thank','that','the','their','them','themselves','then','theory','there','these','they','thing','think','third','this','those','though','thought','thousand','threat','three','through','throughout','throw','thus','time','to','today','together','tonight','too','top','total','tough','toward','town','trade','traditional','training','travel','treat','treatment','tree','trial','trip','trouble','true','truth','try','turn','TV','two','type','under','understand','unit','until','up','upon','us','use','usually','value','various','very','victim','view','violence','visit','voice','vote','wait','walk','wall','want','war','watch','water','way','we','weapon','wear','week','weight','well','west','western','what','whatever','when','where','whether','which','while','white','who','whole','whom','whose','why','wide','wife','will','win','wind','window','wish','with','within','without','woman','wonder','word','work','worker','world','worry','would','write','writer','wrong','yard','yeah','year','yes','yet','you','young','your','yourself');
566    v_e_mails_domains e_mail_domain_array := e_mail_domain_array('aol.com', 'att.net', 'comcast.net', 'facebook.com', 'gmail.com', 'gmx.com', 'googlemail.com','google.com', 'hotmail.com', 'hotmail.co.uk', 'mac.com', 'me.com', 'mail.com', 'msn.com','live.com', 'sbcglobal.net', 'verizon.net', 'yahoo.com', 'yahoo.co.uk','email.com', 'fastmail.fm', 'games.com' /* AOL */, 'gmx.net', 'hush.com', 'hushmail.com', 'icloud.com','iname.com', 'inbox.com', 'lavabit.com', 'love.com' /* AOL */, 'outlook.com', 'pobox.com', 'protonmail.com','rocketmail.com' /* Yahoo */, 'safe-mail.net', 'wow.com' /* AOL */, 'ygm.com' /* AOL */,'ymail.com' /* Yahoo */, 'zoho.com', 'yandex.com','bellsouth.net', 'charter.net', 'cox.net', 'earthlink.net', 'juno.com','btinternet.com', 'virginmedia.com', 'blueyonder.co.uk', 'freeserve.co.uk', 'live.co.uk','ntlworld.com', 'o2.co.uk', 'orange.net', 'sky.com', 'talktalk.co.uk', 'tiscali.co.uk','virgin.net', 'wanadoo.co.uk', 'bt.com','sina.com', 'sina.cn', 'qq.com', 'naver.com', 'hanmail.net', 'daum.net', 'nate.com', 'yahoo.co.jp', 'yahoo.co.kr', 'yahoo.co.id', 'yahoo.co.in', 'yahoo.com.sg', 'yahoo.com.ph', '163.com', '126.com', 'aliyun.com', 'foxmail.com','hotmail.fr', 'live.fr', 'laposte.net', 'yahoo.fr', 'wanadoo.fr', 'orange.fr', 'gmx.fr', 'sfr.fr', 'neuf.fr', 'free.fr','gmx.de', 'hotmail.de', 'live.de', 'online.de', 't-online.de' /* T-Mobile */, 'web.de', 'yahoo.de','libero.it', 'virgilio.it', 'hotmail.it', 'aol.it', 'tiscali.it', 'alice.it', 'live.it', 'yahoo.it', 'email.it', 'tin.it', 'poste.it', 'teletu.it','mail.ru', 'rambler.ru', 'yandex.ru', 'ya.ru', 'list.ru','hotmail.be', 'live.be', 'skynet.be', 'voo.be', 'tvcablenet.be', 'telenet.be','hotmail.com.ar', 'live.com.ar', 'yahoo.com.ar', 'fibertel.com.ar', 'speedy.com.ar', 'arnet.com.ar','yahoo.com.mx', 'live.com.mx', 'hotmail.es', 'hotmail.com.mx', 'prodigy.net.mx','yahoo.com.br', 'hotmail.com.br', 'outlook.com.br', 'uol.com.br', 'bol.com.br', 'terra.com.br', 'ig.com.br', 'itelefonica.com.br', 'r7.com', 'zipmail.com.br', 'globo.com', 'globomail.com', 'oi.com.br');
567    v_origins_countries origin_country_array := origin_country_array('Afghanistan','Albania','Algeria','Andorra','Angola','Antigua and Barbuda','Argentina','Armenia','Australia','Austria','Azerbaijan','The Bahamas','Bahrain','Bangladesh','Barbados','Belarus','Belgium','Belize','Benin','Bhutan','Bolivia','Bosnia and Herzegovina','Botswana','Brazil','Brunei','Bulgaria','Burkina Faso','Burundi','Cabo Verde','Cambodia','Cameroon','Canada','Central African Republic','Chad','Chile','China','Colombia','Comoros','Congo','Costa Rica','Croatia','Cuba','Cyprus','Czech Republic','Denmark','Djibouti','Dominica','Dominican Republic','East Timor','Ecuador','Egypt','El Salvador','Equatorial Guinea','Eritrea','Estonia','Eswatini','Ethiopia','Fiji','Finland','France','Gabon','The Gambia','Georgia','Germany','Ghana','Greece','Grenada','Guatemala','Guinea','Guinea-Bissau','Guyana','Haiti','Honduras','Hungary','Iceland','India','Indonesia','Iran','Iraq','Ireland','Israel','Italy','Jamaica','Japan','Jordan','Kazakhstan','Kenya','Kiribati','Korea, North','Korea, South','Kosovo','Kuwait','Kyrgyzstan','Laos','Latvia','Lebanon','Lesotho','Liberia','Libya','Liechtenstein','Lithuania','Luxembourg','Madagascar','Malawi','Malaysia','Maldives','Mali','Malta','Marshall Islands','Mauritania','Mauritius','Mexico','Micronesia','Moldova','Monaco','Mongolia','Montenegro','Morocco','Mozambique','Myanmar','Namibia','Nauru','Nepal','Netherlands','New Zealand','Nicaragua','Niger','Nigeria','North Macedonia','Norway','Oman','Pakistan','Palau','Panama','Papua New Guinea','Paraguay','Peru','Philippines','Poland','Portugal','Qatar','Romania','Russia','Rwanda','Saint Kitts and Nevis','Saint Lucia','Saint Vincent and the Grenadines','Samoa','San Marino','Sao Tome and Principe','Saudi Arabia','Senegal','Serbia','Seychelles','Sierra Leone','Singapore','Slovakia','Slovenia','Solomon Islands','Somalia','South Africa','Spain','Sri Lanka','Sudan','Sudan, South','Suriname','Sweden','Switzerland','Syria','Taiwan','Tajikistan','Tanzania','Thailand','Togo','Tonga','Trinidad and Tobago','Tunisia','Turkey','Turkmenistan','Tuvalu','Uganda','Ukraine','United Arab Emirates','United Kingdom','United States','Uruguay','Uzbekistan','Vanuatu','Vatican City','Venezuela','Vietnam','Yemen','Zambia','Zimbabwe');
568    
569    v_count NUMBER := 0;
570    v_generated_name VARCHAR2(100);
571BEGIN
572    FOR v_index IN 0..p_total_users - 1 LOOP
573    
574        v_generated_name :=  v_username_sufixes_prefixes(DBMS_RANDOM.VALUE(1, v_username_sufixes_prefixes.COUNT)) ||
575                             v_username_middle(DBMS_RANDOM.VALUE(1, v_username_middle.COUNT)) ||
576                             v_username_sufixes_prefixes(DBMS_RANDOM.VALUE(1, v_username_sufixes_prefixes.COUNT)||
577                             TRUNC(DBMS_RANDOM.VALUE(0,99)));
578                             
579        SELECT COUNT(*) INTO v_count FROM users WHERE username = v_generated_name;
580        WHILE v_count != 0 OR LENGTH(v_generated_name) > 29 LOOP
581            v_generated_name := v_username_sufixes_prefixes(DBMS_RANDOM.VALUE(1, v_username_sufixes_prefixes.COUNT)) ||
582                          v_username_middle(DBMS_RANDOM.VALUE(1, v_username_middle.COUNT)) ||
583                          v_username_sufixes_prefixes(DBMS_RANDOM.VALUE(1, v_username_sufixes_prefixes.COUNT) ||
584                             TRUNC(DBMS_RANDOM.VALUE(0,99)));
585            SELECT COUNT(*) INTO v_count FROM users WHERE username = v_generated_name;
586        END LOOP;
587        
588        v_username := v_generated_name;
589        
590        v_password := DBMS_CRYPTO.RANDOMBYTES(32);
591        
592        v_e_mail := v_username || '@' || v_e_mails_domains(DBMS_RANDOM.VALUE(1, v_e_mails_domains.COUNT));
593        
594        IF DBMS_RANDOM.VALUE(0.00, 0.99) <= 0.98 THEN
595            v_rank := 'u';
596        ELSE
597            v_rank := 'm';
598        END IF;
599        
600        v_birth_date := CURRENT_DATE - (TRUNC(DBMS_RANDOM.VALUE(11,70)) * 365);
601        
602        v_origin_country := v_origins_countries(DBMS_RANDOM.VALUE(1, v_origins_countries.COUNT));
603        
604        INSERT INTO users (username, password, e_mail, rank, birth_date, origin_country) 
605        VALUES (v_username, v_password, v_e_mail, v_rank, v_birth_date, v_origin_country);
606        
607    END LOOP;
608END populate_users_table;
609/
610CREATE OR REPLACE FUNCTION generate_random_date(p_start_date IN DATE, p_end_date IN DATE)
611RETURN DATE AS
612BEGIN
613    return TO_DATE(TRUNC(DBMS_RANDOM.VALUE(TO_CHAR(p_start_date, 'J'), TO_CHAR(p_end_date, 'J'))), 'J');
614END;
615/
616CREATE OR REPLACE FUNCTION generate_random_movie_duration
617RETURN movies.duration%TYPE AS
618    v_days CHAR(1);
619    v_hours NUMBER(2);
620BEGIN
621    IF (DBMS_RANDOM.value() < 0.001) THEN
622        v_days := '1';
623    ELSE
624        v_days := '0';
625    END IF;
626    
627    IF (DBMS_RANDOM.value() < 0.01) THEN
628        v_hours := TRUNC(DBMS_RANDOM.value(3, 23));
629    ELSE
630        v_hours := TRUNC(DBMS_RANDOM.value(0, 3));
631    END IF;
632
633    return TO_DSINTERVAL(v_days || ' ' || 
634                         v_hours || ':' ||
635                         TO_CHAR(TRUNC(DBMS_RANDOM.value(0, 59))) || ':' ||
636                         TO_CHAR(TRUNC(DBMS_RANDOM.value(0, 59))));
637END;
638/
639--Procedura pentru populare tabela de filme
640CREATE OR REPLACE PROCEDURE populate_movies_table(p_total_movies IN NUMBER) AS
641    TYPE title_array IS VARRAY(5000) OF movies.title%TYPE;
642    TYPE parental_rating_array IS VARRAY(5) OF movies.parental_rating%TYPE;
643    TYPE origin_country_array IS VARRAY(200) OF movies.origin_country%TYPE;
644    TYPE language_array IS VARRAY(249) OF movies.language%TYPE;
645    
646    v_title_array title_array := title_array('Carmencita - spanyol tánc','??????????','??????????','Carmencita','Carmencita','Le clown et ses chiens','A bohóc és kutyái','Le clown et ses chiens','Clovnul si cainii sai','????? ? ??? ??????','The Clown and His Dogs','Sarmanul Pierrot','Szegény Pierrot','?????? ?????','Pauvre Pierrot','Poor Pierrot','Pauvre Pierrot','Un bon bock','Un ?ap de bere','Un bon bock','?????? ?????? ????','A Good Beer','Egy jó pohár sör','Blacksmithing Scene','????? ? ?????','Blacksmith Shop','Blacksmith Scene #1','Blacksmithing','A patkolókovács','Blacksmith Scene','Blacksmith Scene','The Blacksmiths Forge','????????? ???????? ??????','Chinezes Fumadores de Ópio','Chinese Opium Den','Kínai ópiumbarlang','Chinese Opium Den','Corbett and Courtney Before the Kinetograph','Corbett and Courtney Before the Kinetograph','A Corbett-Courtney bokszmeccs','The Corbett-Courtney Fight','Jim Corbett vs. Peter Courtney','Edison Kinetoscopic Record of Boxers','??????? ? ?????? ????? ??????????????','Edison asszisztense tüsszent','Edison Kinetoscopic Record of a Sneeze','Edison Kinetoscopic Record of a Sneeze','Edison Kinetoscopic Record of a Sneeze','???, ?????????? ?? ?????????? ???????','Fred Otts Sneeze','Miss Jerry','Miss Jerry','Miss Jerry','La sortie de lusine Lumière à Lyon','La Salida De Los Obreros De La Fábrica Lumière','Salida de obreros de la fábrica Lumiere','La sortie des ouvriers de lusine Lumière','Arbeiter verlassen die Lumière-Werke','Luscita dalle fabbriche Lumière','????? ??????? ? ??????? ??????','Työntekijät poistuvat Lumière-tehtaalta','A munkaid? vége','Wyjscie robotników z fabryki','La salida de los obreros de la fábrica Lumière','Leaving the Lumière Factory','Lumière-fabrikens arbetare','Exiting the Factory','A Saída dos Operários da Fábrica Lumière','Employees Leaving the Lumière Factory','Sortie dusine','La sortie de lusine Lumière à Lyon','Akrobatisches Potpourri','Akrobatisches Potpourri','?????????????? ?????','A Chegada de um Trem à Estação','The Arrival of a Train','Tåget anländer till stationen','The Arrival of a Train at La Ciotat','Juna saapuu asemalle','Ankunft eines Zuges in La Ciotat','A vonat érkezése','???????? ?????? ?? ?????? ?????? ??-?????','La llegada de un tren a la estación de la ciotat','Bir trenin La Ciotat garina varisi','Larrivée du train en gare de La Ciotat','Toget kører ind på Le Ciotat','The Arrival of a Train','Larrivo di un treno alla stazione di La Ciotat','The Arrival of a Train','The Arrival of a Train','Przyjazd pociagu na stacje','The Arrival of a Train','Larrivée dun train à La Ciotat','Príchod vlaku do stanice La Ciotat','The Arrival of the Mail Train','Larrivo di un treno nella stazione di La Ciotat','Neuville-sur-Saône: Débarquement du congrès des photographes à Lyon','Przybycie delegatów na kongres fotograficzny w Lyonie','A kongresszus tagjainak partraszállása','Débarquement','Promenade des congressistes sur le bord de la Saône','Arrivée des congressistes à Neuville-sur-Saône','Le débarquement du congrès de photographie à Lyon','???????? ????????? ?? ???????????? ? ?????','The Photographical Congress Arrives in Lyon','Congrès des sociétés photographiques de France','Neuville-sur-Saône: Débarquement du congrès des photographes à Lyon','O Regador Regado','Larroseur arrosé','Larroseur arrosé','The Waterer Watered','Puutarhuri','Pokropený kropic','Der begossene Gärtner','Trädgårsmästarn','Le jardinier et le petit espiègle','The Sprayer Sprayed','The Sprinkler Sprinkled','??????? ???????????','Tables Turned on the Gardener','Gartneren vandes','El Regador Regado','A megöntözött öntöz?','Vattnaren bevattnad','Le jardinier','Oblany ogrodnik','Linnaffiatore annaffiato','?o???? ???????','Egy kabin körül','Around a Bathing Hut','Autour dune cabine','Autour dune cabine','Boat Leaving the Port','Lódz wyplywajaca z portu','????? ??????? ?? ?????','Kiköt?b?l távozó bárka','La sortie du port','Vene lähtee satamasta','Barque sortant du port','Barque sortant du port','Båten lämnar hamnet','Italienischer Bauerntanz','Bauerntanz zweier Kinder','??????????? ???????????? ?????','Italienischer Bauerntanz','Das boxende Känguruh','Cangurul boxer','Das boxende Känguruh','???? ? ???????','Mr. Delaware and the Boxing Kangaroo','The Clown Barber','The Derby 1895','????? 1895','The Derby 1895','The Blacksmiths','Kowale','???????','Les forgerons','Blacksmith Scene','Les forgerons','Blacksmiths at Work','Hafvet','Baignade en mer','????','Meri','Plivanje u moru','Sea Bathing','The Sea','La mer','A Dip in the Sea','Meri ihmeellisine kylpykuvauksineen','Kapiel w morzu','Baignade en mer','Opening of the Kiel Canal','Eroffnung des Nordostsee Kanals','Inauguration of the Kiel Canal by Kaiser Wilhelm II','A Kieli-csatorna megnyitása','Opening of the Kiel Canal','The Oxford and Cambridge University Boat Race','Et spil kort','Kortspelet','Ett parti ecarté','?????? ? ?????','Partia kart','Card Game','Korttipeli','Game of Cards','The Messers. Lumière at Cards','Kártyaparti','Ecarté peliä','Partie décarté','Partie décarté','Cordeliers Square in Lyon','??????? ???????? ? ?????','Place des Cordeliers à Lyon','Place des Cordeliers à Lyon','Cordeliers Square, Lyons, France','A Pesca do Peixe Dourado','La pêche aux poissons rouges','La pêche aux poissons rouges','Zabawa z rybka','???a???????? ??????? ?????','Fishing for Goldfish','Le goûter de bébé','Lapsen ateria','Baby mades','A kisbaba reggelije','La colazione del bimbo','Barnets måltid','Babys Lunch','Babys Dinner','Feeding the Baby','La comida del bebé','Babys Meal','O Almoço do Bebê','??????? ????????','Karmienie dziecka','Repas de bébé','Déjeuner de bébé','???????? ????, ????????? ?????????? ? ?????','Rough Sea at Dover','A hullámzó tenger Dovernél','Sea Waves at Dover','Rough Sea at Dover','A South-West Storm in Dover','A South-Wester','Saut à la couverte','Sotilaskuva','Brimade dans une caserne','En soldatscen','?????? ?? ???????','Jumping the Blanket','Le saut à la couverture','Le saut à la couverture','Dans serpentin','Serpentinen Tanz','Die Serpentintänzerin','Serpentintanz Mlle. Ancion','?????????','A Acrobacia','Hyppyjä','La voltige','?o???????????','Trick Riding','La voltige','Arrivée dun train gare de Vincennes','Arrivée dun train gare de Vincennes','Arrival of a Train at Vincennes Station','Larroseur','Larroseur','The Sprinkler Sprinkled','Watering the Flowers','Awakening of Rip','Awakening of Rip','??????????? ????','Sea Bathing','???????? ? ????','Baignade en mer','Baignade en mer','The Ball Game','Barnet Horse Fair','Boat Leaving the Harbor at Trouville','Barque sortant du port de Trouville','Barque sortant du port de Trouville','Snowball Fight','Bataille de neige','A Batalha de Neve','???? ? ??????','Bataille de neige','Bataille de boules de neige','Hógolyó csata','Die Schneeballschlacht','Bitwa na sniezki','Seine nehrindeki gemiler','Bateau-mouche sur la Seine','Bateau-mouche sur la Seine','Batteuse à vapeur','Le bivouac','Les blanchisseuses','Les blanchisseuses','The Washerwomen','Mosónök','Bois de Boulogne','Bois de Boulogne','Bois de Boulogne (Porte de Madrid)','Boulevard des Italiens','The Boxing Kangaroo','Boxing Match; or, Glove Contest','Bébé et fillettes','Baby and Young Girls','Bébé et fillettes','The Bohemian Encampment','Gypsies at Home','El campamento bohemio','Campement de bohémiens','Campement de bohémiens','Carga de rurales','Carga de rurales','Rurales Mexicanos al galope','Verpflichtung der Landpolizei','Desfile de rurales al galope el 16 de septiembre','A Chegada do Comboio Inaugural à Estação Central do Porto','A Merry-Go-Round','Les chevaux de bois','Les chevaux de bois','Le chiffonnier','Uma Corrida de Touros no Campo Pequeno','Cortège de tzar allant à Versailles','Cortège de tzar allant à Versailles','The Czar and His Cortege Going to Versailles','The Czars Cortege in the Bois de Boulogne','Cortège de tzar au Bois de Boulogne','Cortège de tzar au Bois de Boulogne','Coronation of a Village Maiden','Couronnement de la rosière','Couronnement de la rosière','Dancing Darkies','Dancing Girls','Danse serpentine','Dessinateur express','Dessinateur express (M. Thiers)','Dessinateur express','Dessinateur: Chamberlain','Dessinateur: Reine Victoria','Dessinateur: Von Bismark','Dix chapeaux en 60 secondes','Conjurer Making Ten Hats in Sixty Seconds','Dix chapeaux en 60 secondes','Unloading the Boat','Déchargement de bateaux au Havre','Déchargement de bateaux','Déchargement de bateaux','Post No Bills','??????','Defense Show','???????????? ? ????????????','Défense dafficher','Défense dafficher','Demolition of a Wall','Seinän kaataminen','Demolición de un muro','Demolição de um Muro','Demolition of a Wall','?????????? ?????','Falbontás','Zburzenie muru','Miten seinä hajotetaan','Démolition dun mur','En vägg rivs','Démolition dun mur','Automobiles Starting a Race','Départ des automobiles','Départ des automobiles','Officers of French Army Leaving Service','Départ des officiers','Départ des officiers','Effets de mer sur les rochers','Effets de mer sur les rochers','Sea Breaking on the Rocks','Children Playing on the Beach','Enfants jouant sur la plage','Enfants jouant sur la plage','Egy hölgy elt?nése','???????????? ???? ? ?????? ?????? ?????','The Vanishing Lady','The Conjuring of a Woman at the House of Robert Houdin','Escamotage dune dame au théâtre Robert Houdin','O Desaparecimento de uma Dama no Teatro Robert Houdin','Escamotage dune dame au théâtre Robert Houdin','Znikajaca kobieta','????? ???? ? ?????','Rip and the Dwarf','Exit of Rip and the Dwarf','Exit of Rip and the Dwarf','Le fakir, mystère indien','Feira de Gado na Corujeira','Feira de Gado na Corujeira','A Feira da Corujeira','O Mercado da Corujeira','La gare Saint-Lazare','Manoeuvres of the French Army','Grandes manoeuvres','Grandes manoeuvres','Les haleurs de bateaux','Les haleurs de bateaux','Towing a Boat on the River','A Hard Wash','A Hard Wash','A Pickaninnys Battle','Die Indiskreten','Les indiscrets','The Peeping Toms','Les indiscrets','The Drunkards','Les ivrognes','Les ivrognes','Gardener Burning Weeds','Jardinier brûlant des herbes','Jardinier brûlant des herbes','Beach and Pier at Trouville, 1st part','Jetée et plage de Trouville (1er partie)','Jetée et plage de Trouville (1er partie)','Jetée et plage de Trouville (2e partie)','Jetée et plage de Trouville (2e partie)','Beach and Pier at Trouville, 2nd part','Jour de marché à Trouville','Jour de marché à Trouville','Market Day','Vonattal Jeruzsálemböl','Départ de Jérusalem en chemin de fer','Départ de Jérusalem en chemin de fer','?????? ?? ?????????? ?? ???????? ??????','Juna lähtee Jerusalemista','Tåget avgår från Jerusalem','Leaving Jerusalem by Railway','Wyjezdzajac z Jerozolimy koleja zelazna','Breaking Up of the Territorial Army','Libération des territoriaux','Libération des territoriaux','Ukleti zamak','Rezydencja diabla','The House of the Devil','The Manor of the Devil','Manor of the Devil','O Solar do Diabo','The Devils Manor','The Haunted Castle','Le manoir du diable','????? ???????','Le manoir du diable','Az ördög kastélya','The Devils Castle','Marée montante sur Brise-Larmes','Tide Rising Over the Breakwater','Marée montante sur Brise-Larmes','Melbourne','Miss de Vere','Miss de Vere','Miss de Vere (gigue anglaise)','Le papier protée','The Mysterious Paper','Le papier protée','Place Saint-Augustin','Place de lOpéra, First View','Place de lOpéra, 1er aspect','Place de lOpéra, 1er aspect','Place de lOpéra, Second View','Place de lOpéra, 2e aspect','Place de lOpéra, 2e aspect','Place de la Bastille','Place de la Concorde','Place de la Concorde','A párizsi Concorde tér','Place du théâtre français','The Beach at Villiers in a Gale','Plage de Villiers par gros temps','Plage de Villiers par gros temps','Plus fort que le maître','Smarter than the Teacher','Plus fort que le maître','Pompiers à Lyon','Passage des pompes','Paris: les pompiers, I. Passage des pompes','Pompiers à Lyon','The Docks at Marseilles','Les quais à Marseille','Les quais à Marseille','Retour au cantonnement','Revue navale à Cherbourg','Revue navale à Cherbourg','Naval Review at Cherburg','Rip Leaving Sleepy Hollow','??? ???????? ?????? ??????','Rip Leaving Sleepy Hollow','Rip Meeting the Dwarf','Rip Meeting the Dwarf','??? ????????? ?????','Rip Passing Over the Mountain','Rip Passing Over Hill','Rip Passing Over the Mountain','??? ????????? ????? ????','Rips Toast','Rips Toast','???? ????','Rips Toast to Hudson and Crew','Rips Toast to Hudson','???? ???? ?? ???????','Rips Toast to Hudson','20 ??? ??? ????','Rips Twenty Years Sleep','Rips Twenty Years Sleep','Le régiment','Le régiment','French Regiment Going to the Parade','Réunion dofficiers','Réunion dofficiers','French Officers Meeting','Sac au dos','Saída do Pessoal Operário da Fábrica Confiança','Workers Exit from the Confianca Shirt Factory','Saída do Pessoal Operário da Fábrica Confiança','Saída do Pessoal Operário da Camisaria Confiança','Salut malencontreux dun déserteur','Sauvetage en rivière, 1er','Rescue on the River, Pt. 2','Sauvetage en rivière, 1er','Sauvetage en rivière, 2e','Sauvetage en rivière, 2e','Rescue on the River, Pt. 1','Le piou-piou galant','The Soldiers Courtship','Vojnikovo udvaranje','The Soldiers Courtship','Closing Hours at Viberts Perfume Factory','Sortie des ateliers Vibert','Sortie des ateliers Vibert','Séance de prestidigitation','Conjuring','Séance de prestidigitation','Tempête sur la jetée du treport','The Pier at Treport During a Storm','Tempête sur la jetée du treport','The Terrible Railway Accident','Tom Old Boot','Tom Old Boot, nain grotesque','Nain grotesque','Les tribulations dun concierge','Academy for Young Ladies','Un lycée de jeunes filles','Un lycée de jeunes filles','A Little Rascal','Un petit diable','Un petit diable','A Little Devil','Une altercation au café','Une nuit terrible','Užasna no?','??????? ????','??? ??????? ?????','Une nuit terrible','Przerazajaca noc','Mia Tromeri Nichta','Uma Noite Terrível','A Terrible Night','Playing Cards','Une partie de cartes','Partia kart','Card Party','Játékkártyák','?????? ? ?????','Une partie de cartes','La voiture du potier','The Wandering Negro Minstrels','Oh, That Watermelon!','A Watermelon Feast','A Watermelon Feast','Larroseur arrosé','Au réfectoire','?? ???????? ?????????','????????????? ?????????','The Bewitched Inn','To Magemeno Pandochio','Lauberge ensorcelée','Lauberge ensorcelée','Zaczarowana gospoda','Laveugle','Baignade dans le torrent','Baignade dans le torrent','Bathing in a Stream','Ballet libella','Buffalo Bill and Escort','The Burglars','Les cambrioleurs','Les cambrioleurs','? ???????????','Chez le magnétiseur','At the Hypnotists','Chez le magnétiseur','En classe','Le cocher de fiacre endormi','Alvó taxisoför','Le cocher de fiacre endormi','The Corbett-Fitzsimmons Fight','??? ???????? ? ????????????','The Corbett-Fitzsimmons Fight','Coucher dYvette et Pierreuse','Le Coucher dYvette','Le Coucher dYvette','Dans les coulisses','Dans les coulisses','Behind the Scenes','Danse fleur de lotus','Faust és Margit','Faust and Marguerite','Faust et Marguerite','Faust et Marguerite','Lhallucination de lalchimiste','Lhallucination de lalchimiste','The Hallucinated Alchemist','? ?????????? ??? ?????????','The Alchemists Hallucination','?? ???????????? ??????','The Haunted Castle','Az elvarázsolt kastély','The Haunted Castle','Henley Regatta','While Under a Hypnotists Influence','Le magnétiseur','Le magnétiseur','The Hypnotist at Work','Lhôtel empoisonné','Lhôtel empoisonné','A Badly Managed Hotel','Idylle','Idylle interrompue','Le cabinet de Méphistophélès','Le cabinet de Méphistophélès','The Devils Laboratory','The Cabinet of Mephistopheles','The Laboratory of Mephistopheles','The Last Days of Pompeii','Leçon de danse','Niagara','Les chutes','A Niagara-vízesés','Les chutes','Niagara Falls','The Niagara Waterfall','Niagara-fallet','Niagaran putoukset','Le planton du colonel','The Fisherman at the Stream','Le pêcheur dans le torrent','Le pêcheur dans le torrent','Riña en un café','Salida de los trabajadores de la fábrica España Industrial','Salida de misa de doce del Pilar de Zaragoza','Salida del público de la iglesia parroquial de Santa María de Sans','Slagsmål i gamla Stockholm','Une bataille dans le vieux Stockholm','Slagsmål i gamla Stockholm','The Twins Tea Party','Une nuit agitée','X-Rays','The X-Ray Fiend','The X-Ray Fiend','????????????? ???','Battle of Santiago Bay','Výstavní párkar a lepic plakátù','The Exhibition Sausage Seller and the Billposter','Výstavní párkar a lepic plakátù','The Bill Sticker and the Sausage Vendor','A Boca do Inferno','A Sea Cave Near Lisbon','A Sea Cave Near Lisbon','A Boca do Inferno em Cascais','Brittania','The Burglar on the Roof','The Cavaliers Dream','The Cave of the Demons','La caverne maudite','La caverne maudite','Le chemin de croix','Cenicienta','Cinderella','Cinderella and the Fairy Godmother','Cinderella','????? ??????, ?????!','Come Along, Do!','Come Along, Do!','Viens donc, je ten prie','Exhibition','Bemutató','The Corsican Brothers','Cripple Creek Bar-Room Scene','??? ? ??????-?????','Cripple Creek Bar-Room Scene','La crèche à Bethléem','Le cuirassé Maine','La cène','The Deserter','Dorotea','Appointment at the Mill','Dostavenícko ve mlýnici','Svábovo zmarené dostavenícko','Déménagement à la cloche de bois','Ella Lola, a la Trilby','Lentrée à Jérusalem','Express Train on a Railway Cutting','Les farces de Jocko','Faust and Mephistopheles','La flagellation','La fuite en Égypte','Glasgow Fire Engine','Gran corrida de toros','Indian War Council','Le jardin des oliviers','Je vous y prrrrends!','Je vous y prrrrends!','Je vous y prends...','Jésus devant Pilate','Leçons de boxe','Llegada de un tren a la estación de ferrocarril del Norte, de Barcelona','London Express','A molnár és a kéménysepr?','The Miller and the Sweep','??????? ? ?????????','The Miller and Sweep','The Miller and the Sweep','The Miller and Chimney Sweep','Photographing a Ghost','A Novice at X-rays','Les rayons Röntgen','Les rayons Röntgen','The Astronomers Dream','O Sonho do Astrônomo','La lune à un mètre. Lobservatoire, la lune, Phoebé','A Trip to the Moon','The Moon at One Meter','To Oniro tou Astronomou','Astronomov san','???? ????? ???? ? ?????','?? ?????? ??? ??????????','Sueños de un astrónomo','The Moon at Arms Length','La lune à un mètre','Le rêve dun astronome','La lune à un mètre','Egy méterre a Hold','La luna a un metro','The Astronomers Dream; or, The Man in the Moon','Saida do Paquete Duque de Braganca','Scène descamotage','Scène descamotage','Disappearing Act','Tearing Down the Spanish Flag','Smích a plác','Smích a plác','Tears and Laughter','Visita de Doña María Cristina y Alfonso XIII a Barcelona','Waves and Spray','Die Affäre Dreyfus','O Caso Dreyfus','Sprawa Dreyfusa','Dreyfusova aféra','The Dreyfus Affair','???? ????????','Laffaire Dreyfus','A Dreyfus-ügy','Laffaire Dreyfus','Aladdin and the Wonderful Lamp','The Artist and the Flower Girl','Aspectos da Praia de Cascais','At the Club','Au cabaret','Au cabaret','Laveugle','Battlefield','La belle et la bête','La belle et la bête','Beauty and the Beast','Boat Race','Bombardment of Mafeking','O Bom Absinto','La bonne absinthe','Wonderful Absinthe','La bonne absinthe','Casey at the Bat, or, The Fate of a Rotten Umpire','Casey at the Bat','Casey at the Bat','Cinderella','Cinderella','Cinderella and the Glass Slipper','Cendrillon','Cendrillon','???????????','Cenicienta','Baile Até à Meia-Noite','Cinderela','Stachtopouta','Hamupip?ke','???????','Chegada ao Cais do Sodré do Primeiro Combóio em Cascais','Chegada de Um Comboio a Cascais','Portuguese Railway Train','Portuguese Railway Train','A Tour in Spain and Portugal','Portuguese Railway Train','Le chiffonnier','Choque de dos transatlánticos','Cléopâtre','Cléopâtre','Cleopatras Tomb','Robbing Cleopatras Tomb','La colonne de feu','Haggards She: The Pillar of Fire','The Pillar of Fire','La danse du feu','La columna de fuego','? ????? ??? ??????','I Stili tis Fotias','????? ????','Courte échelle','Le crucifiement','Les dangers de lalcoolisme','Danse serpentine par Mme. Bob Walter','Delivering Newspapers','Distributing a War Extra on Union Square','World News Wagon','Distributing a War Extra','Distributing a War Extra','La descente de croix','The Sign of the Cross','The Devil in a Convent','Le diable au couvent','Le diable au couvent','Diabel w klasztorze','?????? ? ?????????','O Diabo no Convento','Le déjeuner des enfants','Erreur judiciaire','The Haunted House','Limpressionniste fin de siècle','LIllusionniste fin de siècle','????????????? ????? ????','A századforduló b?vésze','An Up-to-Date Conjuror','LImpressionniste fin de siècle','A Turn of the Century Illusionist','An Up-to-Date Conjuror','The Conjurer','Limpressionniste fin de siècle','The Kings Death at Winstead','?????? ????','Beerbohm Tree, the Great English Actor','King John','Kralj Janez','King John','The Kiss in the Tunnel','The Kiss in the Tunnel','??? ???? ??? ??????','Tunnel Kiss','O Beijo no Túnel','Csók az alagútban','??????? ? ???????','A Kiss in the Tunnel','Ena Fili sto Tounel','The Legacy','Llegada del vapor Bellver a Mallorca','Matches: An Appeal','La mauvaise soupe','The Misers Doom','Monnaie de lapin','Mésaventure dun charbonnier','Panorama from the Tower of the Brooklyn Bridge','La résurrection','Le tondeur de chiens','Le tonnelier','Transformations','Un bon lit','A Midnight Episode','Avventura a mezzanotte','Un bon lit','Un lunch','Vista de la entrada principal de la plaza de toros de Jerez, el segundo día de feria','Évocation spirite','Summoning the Spirits','Évocation spirite','Invocação de um Espírito','?????? ?????','Chimmie Hicks at the Races','Above the Limit','Jimmie Hicks in Automobile','Automobile and Jimmy Hicks','Above the Limit','Above the Speedway','Langélus','Larléquine','Army Life','Army Life, or How Soldiers Are Made','Army Life','Arrivée dArléquin','Arrivée de Pierette et Pierrot','As Seen Through a Telescope','The Professor and His Field Glass','Lastronome indiscret','Mit látunk a távcs?ben','??? ????? ? ????????','Como Visto Por um Telescópio','As Seen Through the Telescope','Attack on a China Mission','Attack on a China Mission','Attack on a Chinese Mission','Blue Jackets to the Rescue','????????? ?? ?????? ? ?????','Ataque em uma Missão na China','Ataque a uma Missão na China','Avenue de lopéra','Badinage','Bataille doreillers','Bataille de boules de neige','Buffalo Bills Show Parade','Buffalo Bills Wild West Parade','Buffalo Bills Wild West Parade','Buffalo Bills Wild West Show','Le bébé','Chez le Maréchal-Ferrant','At the Photographers','Chez le photographe','Chez le photographe','Yellow Peril','Chinese Magic','Chinese Magic','Chirurgie fin de siècle','Turn-of-the-Century Surgery','Chirurgie na konci století','Chirurgie fin de siècle','The Clown and the Alchemist','La concierge','Coucher dune Parisienne','Dance de livresse','Amor bag Kulisserne','Dans les coulisses','Dans les coulisses','Danse du papillon','Danse du pas des foulards par des almées','La danse du ventre','Danse du voile','Danse serpentine','Danses','Déclaration damour','Les fredaines de Pierrette','Pierrettes Escapades','Le départ dArlequin et de Pierrette','The Enchanted Drawing','The Enchanted Drawing','?? ???????? ??????','Az elvarázsolt rajz','??????????? ???????','O Desenho Encantado','To Magemeno Schedio','Faust and Marguerite','The Cabbage-Patch Fairy','La fée aux choux, ou la naissance des enfants','La fée aux choux, ou la naissance des enfants','Gavotte directoire','Buyukannenin Okuma Gozlugu','????????? ????','Os Óculos de Leitura da Vovó','Grandmas Reading Glass','Grandmas Reading Glass','A nagymama nagyítója','LHabanera','Le duel dHamlet','Hamlet, Scene de Duel','Le duel dHamlet','Hamlet, Duel Scene with Laertes','Hamlet','Happy Hooligan','The House That Jack Built','The House That Jack Built','The House That Jack Built','How It Feels to Be Run Over','Milyen érzés, ha elgázolják az embert','?????? ???, ????? ???? ?????????','How It Feels to Be Run Over','Chimmie Hicks and the Rum Omelet','Le lapin','??????? ??? ????? ?????????','Let Me Dream Again','Let Me Dream Again','Hagyj újra álmodni!','Leçon de danse','Le marchand de coco','Marché à la volaille','Le matelot','Die Jungfrau von Orleans','Eine moderne Jungfrau von Orleans','Maple Viewing','Momijigari','Maple Leaf Viewing','Momijigari','Mort dAdonis','The Mystic Swing','Panorama de Barcelona: monumentos y fiestas','Pas Japonais','Pas de grâce','Pas des éventails','Pas du poignard','La paysanne','La petite magicienne','Le Polichinelle','La poupée noire','La reine des jouets','Retour des champs','Le sang dAdonis donnant naissance à la rose rouge','Saut humidifié de M. Plick','Early Christian Martyrs','Soldiers of the Cross','Soldiers of the Cross','La source','Spanish Bullfight','Suite de la danse','La tarentelle','Uncle Josh in a Spooky Hotel','Uncle Joshs Nightmare','O Pesadelo de Tio Josh','Uncle Joshs Nightmare','Une rage de dents','Valse directoire','Valse lente','Lécossaise','Another Job for the Undertaker','Another Job for the Undertaker','?????? ?????? ??? ????????????','Buffalo Bills Wild West','Buffalo Bills Wild West Parade','Parade of Buffalo Bills Wild West','Buffalo Bills Wild West Parade','Buffalo Bills Parade','Charmant froufrou','What Came Out of the Cheese; or, The Lilliputians in a New York Restaurant','The Cheese Mites, or Lilliputians in a London Restaurant','The Cheese Mites, or Lilliputians in a London Restaurant','Cheesemites','The Countryman and the Cinematograph','The Countryman and the Cinematograph','??????????????? ??????? ??????? ?????????? ????????','El?ször találkoznak vidéken a vetít?géppel','The Countrymans First Sight of the Animated Pictures','Danses basques','Day at the Circus','Execution of Czolgosz with Panorama of Auburn Prison','Czolgosz kivégzése az auburni börtön látképével','Execução de Czolgosz com Panorâmica da Prisão de Auburn','Electrocution of Czolgosz','Execution of Czolgosz with Panorama of Auburn Prison','Exercício de Artilharia no Hipódromo de Belém','Fire!','T?z van!','Fire!','Fogo!','?????','Frivolité','The Haunted Curiosity Shop','The Haunted Curiosity Shop','????? ? ????????????','Die Geschichte eines Verbrechens','História de um Crime','Story of a Crime','History of a Crime','Egy b?ntény története','??????? ?????? ????????????','Histoire dun crime','Histoire dun crime','O Homem com a Cabeça de Borracha','Czlowiek z gumowa glowa','The Man with the India-Rubber Head','? ???????? ?? ?? ?????? ??? ?????????','Kautsjuk-Hovedet','?e????? ? ????????? ???????','El hombre con la cabeza de goma','Lhomme à la tête en caoutchouc','El hombre de la cabeza de goma','The Man with the Rubber Head','Lhomme à la tête en caoutchouc','A gumifej? ember','The India Rubber Head','Hussards et grisettes','Lavatory moderne','Lecture quotidienne','The Magic Sword, or A Medieval Mystery','The Magic Sword','The Magic Sword','Magical Sword','Panorama of Esplanade by Night','Parada de Bombeiros','Uma Parada dos Alunos da Casa Pia de Lisboa','Pas de colombine','Den lille Rødhætte','Le petit chaperon rouge','Piroska és a farkas','Le petit chaperon rouge','Little Red Riding Hood','Caperucita roja','Fiestas de bicicletas para niños','A Road for Childrens Bicycles in Barcelona','Pista de bicicletas para niños en Barcelona','Scrooge; or Marleys Ghost','Scrooge; or Marleys Ghost','Scrooge; or Marleys Ghost','??????, ??? ??????? ?????','Scrooge, or Marleys Ghost','Scène damour','Scène divresse','The Devils Seven Castles','Los siete castillos del Diablo','?? ???? ?????? ??? ????????','The Seven Castles of the Devil','Ta Epta Kastra tou Diavolou','Les sept châteaux du diable','Les sept châteaux du diable','Tel est pris qui croyait prendre','Uma Tourada à Antiga Portuguesa','A táncz','The Dance','A tánc','A táncz','Undressing Extraordinary','Undressing Extraordinary, or The Troubles of a Tired Traveller','Undressing Extraordinary','Les vagues','Visita de la escuadra inglesa a Barcelona','Rompeolas','Visit of the British Navy to Barcelona','Visita de la escuadra inglesa a Barcelona','La belle au bois dormant','Tornerose','La belle au bois dormant','Sleeping Beauty','Buffalo Bills Wild West Show','Carnaval en las ramblas','Carreras de caballos en el hipódromo de Barcelona','Miss Dundee et les chiens savants','Chiens savants','Miss Dundee and Her Performing Dogs','???? ????? ? ?? ?????????????? ??????','Les chiens savants','Les clowns','La cour des miracles','Le sacre dÉdouard VII','Reproduction, Coronation Ceremonies: King Edward VII','The Coronation of Edward VII','Edward VIIs kroning','The Coronation of Edward VII','The Coronation of King Edward VII','The Coronation of Edward VII','????????? ??????? VII','Le couronnement du roi Édouard VII','Danse excentrique','Danse excentrique','Serpentine Dance by Lina Esbrard','Danse fantaisiste','Danse mauresque','La dent récalcitrante','The Enchanted Cup','En faction','Farces de cuisinière','La fiole enchantée','Fruits de saison','La gavotte','La gigue','Jack y la habichuela gigante','???? ? ??????? ??????','Babszem Jankó','João e o Pé de Feijão','Jack and the Beanstalk','Jack and the Beanstalk','Le lion savant','Le marchand de ballons','Mother Goose Nursery Rhymes','Le pommier','Pour secouer la salade','La première gamelle','The Prince of Darkness','Procesión de las hijas de María de la parroquia de Sans','Procession of the Daughters of the Virgin Mary from the Sants Church','Procesión de las hijas de María de la parroquia de Sans','Quadrille réaliste','Naissance des enfants','Sage-femme de première classe','A Parteira da Classe Média','Sage-femme de première classe','Midwife to the Upper Classes','???? ? ?????????? ????????? ??????','Building Up and Demolishing the Star Theatre','Demolishing and Building Up the Star Theatre','Star Theatre','A Star Theatre lebontása és felépítése','Demolishing and Building Up the Star Theatre','Trompé mais content','The Troublesome Fly','Les trésors de satan','Les trésors de satan','????????? ??????','Mephistopheles School of Magic','The Treasures of Satan','The Devils Money Bags','Uncle Josh at the Moving Picture Show','Uncle Josh at the Moving Picture Show','Josh bácsi és a mozgókép','???? ???? ?? ??????????','Un cabinet particulier','Une scène en cabinet particulier vue à travers le trou de la serrure','Une scène en cabinet particulier vue à travers le trou de la serrure','A Peculiar Cabinet','Les victimes de lalcoolisme','Alkoholismens skadelige Følger','Les victimes de lalcoolisme','Alcohol and Its Victims','En Tur til Maanen','Cesta na Mesíc','A Trip to the Moon','Viaje a la Luna','Taxidi sti Selini','Viaje a la Luna','Resan till månen','Le voyage dans la lune','Resan till månen','A Trip to Mars','Le voyage dans la lune','Viagem à Lua','Viagem à Lua','A Trip to the Moon','Utazás a Holdba','Een avontuur bij de maan','Put na mesec','??????????? ?? ????','Potovanje na luno','?????? ??? ??????','Viaggio nella Luna','Reisen til månen','A Trip to the Moon','Die Reise zum Mond','A Trip to the Moon','A Trip to the Moon','Gessekai Ryokô','Voyage to the Moon','Cesta na Mesíc','Op reis naar de maan','Matka Kuuhun','Viaje a la luna','Podróz na ksiezyc','The Wild Man of Borneo','Léquilibriste','Alicja w krainie czarów','Alice no País das Maravilhas','Alice im Wunderland','Alíz Csodaországban','Alice in Wonderland','Alices Adventures in Wonderland','Alice in Wonderland','Alice in Wonderland','????? ? ?????? ?????','Les apaches pas veinards','Les aventures dun voyageur trop pressé','??????','The Enchanted Box','La boîte à malice','La boîte à malice','The Shallow Box Trick','Les braconniers','Buffalo Bills Parade','Showing Indians and Band Mounted','Buffalo Bills Parade','Buffalo Bills Street Parade','Cake-walk de la pendule','Carreras de bicicletas en el parque','La chasse au cambrioleur','????????? ??????','A Chess Dispute','A Chess Dispute','Comme on fait son lit on se couche','How Monsieur Takes His Bath','Comment monsieur prend son bain','Comment monsieur prend son bain','Compagnons de voyage encombrants','Dorothys Dream','Enlèvement en automobile et mariage précipité','???????????????? ???????? ????????????','An Extraordinary Cab Accident','An Extraordinary Cab Accident','Faust et Méphistophélès','Le fiancé ensorcelé','The Great Train Robbery','Dai Ressha Gôtô','??????? ?????????? ??????','Suuri junaryöstö','Le vol du rapide','Velká zeleznicní loupez','Serghate Bozorge Ghatar','?????? ???????????? ??????','Le vol du grand rapide','Det store togrøveriet','A nagy vonatrablás','Det store togrøveri','Der große Eisenbahnraub','Le vol du grand rapide','The Great Train Robbery','El gran robo al tren','O Grande Roubo do Trem','Asalto y robo al tren','Den stora tågplundringen','Der grosse Eisenbahnüberfall','Napad na ekspres','Assalto al treno','???????? ????????','A csodálatos virágfüzér','The Marvelous Wreath','La guirlande merveilleuse','La guirlande merveilleuse','Marvellous Wreath','Gulliver in the Land of Giants','Gulliver en el país de los gigantes','Gulliver en el país de los gigantes','Henrettelsen','Capital Execution','Henrettelsen','Hiawatha','Hiawatha, the Indian Messiah','Hiawatha','Hiawatha, the Messiah of the Ojibway','Hiawatha, the Messiah of the Ojibway','The Passion Play of America','Illusionniste renversant','Jocko musicien','Kit Carson','Vida de um Bombeiro Americano','Life of an American Fireman','Egy amerikai t?zoltó élete','The Life of an American Fireman','Life of an American Fireman','????? ????????????? ?????????','??????? ?? ???? ??????????? ??????????','Le liqueur du couvent','Lutteurs américains','La main du professeur Hamilton ou le roi des dollars','?? ??????? ??? ????? ?????','O Acidente de Mary Jane','? ????????? ??? ????? ?????','Mary Janes Mishap; or, Dont Fool with the Paraffin','Mary Jane mal?rje','Mary Janes Mishap','??????????? ???? ?????','Mary Janes Mishap','The Messenger Boys Mistake','Modelage express','La mouche','? ?????????','Meloman','The Music Lover','O Melomanis','Le mélomane','O Melômano','A zenebolond','???????','The Melomaniac','The Music Lover','El melómano','Le mélomane','N.Y. Fire Department Returning','New York City Fire Department','N.Y. Fire Department Returning','Ne bougeons plus','Nos bons étudiants','Panorama of Rikers Island, N.Y.','The Pioneers','Potage indigeste','La poule fantaisiste','Puerto de Barcelona','Puerto de Barcelona','Barcelona Harbour','Rip Van Winkle','??? ??? ??????','Rip Van Winkle','? ??????? ???','Kingdom of the Fairies','Le royaume des fées','To Vasilio ton Neraidon','Fairyland; or, the Kingdom of the Fairies','O Reino das Fadas','Fairyland: A Kingdom of Fairies','?? ???????? ??? ????????','Au royaume des fées','The Fairyland','A tündérkirályság','Paa Havsens Bund','Feernes Kongerige','The Kingdom of the Fairies','Répétition dans un cirque','Secours aux naufragés','Service précipité','The Sick Kitten','The Sick Kitten','The Little Doctor and the Sick Kitten','O Gatinho Doente','??????? ???????','A beteg kiscicus','Les surprises de laffichage','I kaliva tou mparmpa Thoma','Uncle Toms Cabin; or, Slavery Days','Uncle Toms Cabin','Uncle Toms Cabin','?????? ???? ????','La cabaña del tío Tom','Tamás bátya kunyhója','A Cabana do Pai Tomás','Uncle Toms Cabin','Uncle Toms Cabin','La cabaña del tío Tom','La valise enchantée','La valise enchantée','Rejsekufferten','Le voleur sacrilège','Voyage of the Arctic','The Adventurous Voyage of The Arctic','Voyage of the Arctic, or How Captain Kettle Discovered the North Pole','Wyprawa na biegun','The Adventurous Voyage of The Arctic','Après la fête','Lassassinat du courrier de Lyon','Behind the Scenes','Behind the Scenes','Algies Mishap','Vedd meg a cseresznyéd!','Rum vs. Cherries','??? ??????? ???? ???????','Buy Your Own Cherries','Buy Your Own Cherries','Le coffre enchanté','????????????? ??????','Le coffre enchanté','The Bewitched Trunk','The Enchanted Trunk','A Colliers Life','A Colliers Life','A Miners Daily Life','Comment on disperse les foules','Les deux rivaux','Les enfants du miracle','La gavotte de la reine','The Great Sword Combat on the Stairs','A Gentleman of France','A Gentleman of France','Monsieur Beaucaire: The Adventures of a Gentleman of France','The Great Train Robbery','The Great Train Robbery','??????? ?????????? ??????','?????? ?? ?? ??????? ??????','A Terra Além do Pôr-do-Sol','The Land Beyond the Sunset','The Land Beyond the Sunset','La leçon de pipeau','Loiseau envolé','Opening the Williamsburg Bridge','The Opening of the Williamsburg Bridge','Opening the Williamsburg Bridge','Anúncio Pessoal','Rendez-vous par annonce','Házassági hirdetés','Personal','Personal','Pierrot assassin','Pierrot assassin','Pierrot, Murderer','Le pompon malencontreux','Le pêcheur de perles','Le pêcheur de perles','The Pearl Fisherman','The Pearl Fisher','Down in the Deep','Railroad Smashup','A Railway Tragedy','Rescued by Rover','Rescued by Rover','??????? ???????','O Resgate de Rover','Rover, a kutya','??????????? ?????? ???????????','The Voyage Across the Impossible','Viagem Através do Impossível','Cesta do nemozna','Podróz do krainy niemozliwosci','Rejsen gennem Firmamentet','Le voyage à travers limpossible','Le voyage à travers limpossible','The Voyage Through the Impossible','Il viaggio attraverso limpossibile','The Impossible Voyage','Utazás a lehetetlenbe','Nemogu?e putovanje','An Impossible Voyage','?? ????????? ??????','The Abductors','Adventures of Sherlock Holmes; or, Held for a Ransom','Sherlock Holmes sidste Bedrift','Adventures of Sherlock Holmes','Adventures of Sherlock Holmes','Bohemios','Corrida de beneficencia en Zaragoza, por Quinito y Montes','Coso y Paseo de Santa Engracia (Calles y plazas de Zaragoza)','Coso y Paseo de Santa Engracia (Calles y plazas de Zaragoza)','Escenas callejeras','La course à la perruque','La course à la perruque','La caza de la peluca','The Wig Chase','Jagten paa Parykken','The Effects of Too Much Scotch','D.T.s, or the Effect of Drink','D.T.s, or the Effect of Drink','Departure of Peary and the Roosevelt from New York','Departure of Peary and the Roosevelt from New York','Departure of Peary for the North Pole','Desde el coso a la calle Cerdán (Calles y plazas de Zaragoza)','Chauffeur als Anfänger','The Inexperienced Chauffeur','Les débuts dun chauffeur','Les débuts dun chauffeur','El dúo de la Africana','The Duet from LAfricaine','El dúo de la Africana','La esméralda','Esmeralda','Esmeralda','Funeral of Hiram Cronk','Gigantes y cabezudos por la calle de Alfonso','Gigantes y cabezudos','Gigantes y cabezudos','Los guapos de la Vaquería del Parque','Lhereu de can Pruna','El heredero de casa Pruna','The Gallants of the Park','Los guapos del parque','Az elektromos szálloda','The Electric Hotel','?? ????????? ??????????','To Ilektriko Xenodochio','Hôtel électrique','El hotel eléctrico','????????????? ?????','Det elektriske Hotel','El hotel eléctrico','Hotel elettrico','Hussar of the Guard','El húsar de la guardia','El húsar de la guardia','Juanito el forzudo','???????????','The Kleptomaniac','A Cleptomaníaca','The Kleptomaniac','The Life of Charles Peace','The Little Train Robbery','The Little Train Robbery','????????? ?????????? ??????','The Moonshiners','Moonshiners','The Moonshiners','Moose Hunting in Newfoundland','???-???????? ?????','In the N.Y. Subway','The Interboro Subway','A new york-i metró','Interior N.Y. Subway, 14th St. to 42nd St.','New York Subway','New York Subway','Pendaison à Jefferson City','Pendaison à Jefferson City','Hanging at Jefferson City','Pennsylvania Tunnel Excavation','Plaza de la Magdalena (Calles y plazas de Zaragoza)','Raffles','Raffles, the Amateur Cracksman','The Adventures of Raffles, the Amateur Cracksman','Raffles, the Amateur Cracksman','Reuben in the Opium Joint','Se da de comer','Donem de menjar','The Siege of Chile','Los sitios de Chile','Los sitios de Chile','Torrero y la ribera (Calles y plazas de Zaragoza)','The Wooing and Wedding of a Coon','A sof?r','The ? Motorist','??????????? ????????????','The Mad Motorist','The ? Motorist','Questionmark Motorist','The ? Motorist','Anarkistens svigermor','The Anarchists Mother-in-Law','Anarkistens svigermor','Apachentanz','Arrival of Emigrants, Ellis Island','Bilbao, Portugalete y los Altos Hornos','Bonden i København','Bonden i København','Lars Hovedstadsrejse','Branden i Frihavnen','Lødag den 12, ds. Engen Opagelse','Branden i Frihavnen','Bobs Tod','Bobs Death','Caros død','Caros død','Cerveza gratis','Free Beer','Cerveza gratis','Chr. IXs bisættelse','The Funeral of King Christian IX','Kong Christian IXs Bisættelse','Christian IXS bisættelse','The Dancers Dream','Dream of a Racetrack Fiend','Dream of a Racetrack Fiend','Dream of the Race Track Fiend','Egy ínyenc álma','Dream of a Rarebit Fiend','Dream of a Rarebit Fiend','??? ???????? ?????? ? ?????','Ædedolkens Drøm','Ferias en San Sebastián y Cabalgata en la Ría','Fiskareliv i Nordon','En Fiskers farefulde Færd','Des Fischers gefährlicher Beruf','Fiskernes Liv i Norden','Fiskerliv i Norden','Fiskerliv i Norden','Kalastajia Pohjolassa','Den fulde Mand','En foræring til min Kone','En foræring til min Kone','Den fulde Mand','en gåva till min hustru','Ein Geschenk für meine Frau','Frederik VIIIs kroning','Frederik den 8.s proklamation','Proklamationen af Kong Frederik d. VIII','Slaget i September','Fæstningskrigen','Fæstningskrigen','The Hand of the Artist','The Haunted Hotel','Lhôtel hanté','The Haunted Hotel','Kísértett szálloda','The Haunted Hotel; or, The Strange Adventures of a Traveler','Das Spukhotel','????????? ? ????????????','?????????? ???? ??????? ???','Vicces arcok vicces fázisai','Humorous Phases of Funny Faces','Humorous Phases of Funny Faces','?????????????? ?????? ??? ?????? ???????','Valkoinen orja','A escrava branca','Den hvide slavinde','Den hvide slavinde','Hævnet','Kathleen Mavourneen','Kathleen Mavourneen','Kathleen','Los kikos','Clowns','Los kikos','Konfirmanden el','Konfirmanden','Konfirmander på Alleenberg','Konfirmanden','Konfirmander på Frederiksberg','Ladrones burlados','Vild Vesten','The Life of a Cowboy','The Life of a Cowboy','Os Lusíadas','Mellem Aber og Bjørne','Mellem Aber og Bjørne','Zoologisk Have','A Modern Oliver Twist; or, The Life of a Pickpocket','A Modern Oliver Twist','A Modern Oliver Twist','The Night Before Christmas','The Night Before Christmas','I nykta prin apo ta Hristougenna','Hanging Stockings on a Christmas Eve','Szenteste','Professorens Morgenavis','Professorens Morgenavis','Professorns morgontidning','The Merry Frolics of Satan','Ta 400 htypimata tou diavolou','The 400 Tricks of the Devil','Les quat cents farces du diable','As Quatrocentas Farsas do Diabo','Az ördög 400 csapása','Les 400 farces du diable','????????? ???????? ???????','Gli allegri inganni di Satana','Les quatre cents coups du diable','Czterysta zartów diabelskich','Les quatre cents farces du diable','Rosenborg Have','Røverhøvdingen','Røverhøvdingens Flugt og Død','Røverhøvdingens Flugt og Død','San Francisco Disaster','The San Francisco Earthquake','Secreto de confesión','Die schwarze Maske','Den sorte maske','Den sorte maske','The Black Mask','Den sarta masken','Kelly bandájának története','The Story of the Kelly Gang','Die Geschichte der Kelly Bande','The Story of the Kelly Gang','Amid the Workings of the Deep','20,000 Leagues Under the Sea','20.000 Léguas Submarinas','20000 lieues sous les mers','Deux cent mille lieues sous les mers','20000 ??? ??? ?????','20.000 milja pod morem','Under the Seas','Le cauchemar dun pêcheur','Ali Baba et les quarante voleurs','Ali Babá e os Quarenta Ladrões','Ali Baba and the Forty Thieves','Ali Baba et les quarante voleurs','Ali Baba og de 40 Røvere','???-???? ? ????? ???????????','Angelo, Tyran fra Padua','Angelo, Tyran fra Padua','Angelo, Tyrant of Padua','An Awful Skate; or, The Hobo on Rollers','The Bandit Makes Good','A Batalha das Flores no Campo Grande','Bauernhaus und Grafenschloß','Ben Hur','Ben Hur','???-???','Ben Hur','Camille','The Lady with the Camellias','Kameliadamen','La dama de las camelias','Kameliadamen','Kamelianainen','La dama de las camelias','El ciego de la aldea','Concurso de sardanas en el parque Guell','A Curious Dream','La dea del mare','Der var engang','König Drosselbart','Der var engang','Descoberta da América por Cristovão Colombo','Dr. Skinum','Dr. Skinum','Il dottor Skinum','Lenfant prodigue','Lenfant prodigue','The Prodigal Son','Eureka Stockade','Els tres tombs','Fiestas de San Antonio','Fiestas de San Antonio','Flugten fra seraillet','The Flight from the Seraglio','Pako seraljista','Flugten fra seraillet','Rosen','From the Rococo Times','Rosen','Fyrtøjet','Wonderful Mirrors','The Magic Mirror','The Magic Mirror','Les glaces merveilleuses','Les glaces merveilleuses','Hamlet','Hamlet, Prins af Danmark','Hamlet, Prince of Denmark','Hamlet','Hamlet','Isbjørnejagten','En isbjørnejagt','Lohengrin','Lohengrin','Den forlegne Lohengrin','Leijonanmetsästys','Löwenjagd','Løvejagten','Løvejagten paa Elleore','Lion Hunting','Løvejagten','The Magic Fountain Pen','Mesalliancen','Mesalliancen','A Misalliance','Eine Mesalliance','Mordet paa Fyn','Mr. Gay and Mrs.','La muerte del tirano','En ny hat til Madammen','En ny hat til Madammen','Ein Hut nach neuester Mode','Ein neuer Hut','Othello','Othello','?????','Othello','Otello von Venedig','Otello','Otello','Otello','Othello indstuderes','?????','Othello','Othello','The Power of the Sultan','The Sultans Power','In the Sultans Power','In the Sultans Power','Procesión marítima en Santa Cristina','O Rapto de Uma Actriz','??????? ??????????','The Red Spectre','?? ??????? ?????','Le spectre rouge','To Kokkino Fasma','Le spectre rouge','Robbery Under Arms','Romería a San Medín','Røverens brud','La mère du coupable','Røverens brud','Ryövärin morsian','The Robbers Sweetheart','Salaviinan polttajat','Lönnbrännare','Salaviinanpolttajat','Stalking and Shooting Caribou in Newfoundland','Stalking and Shooting Caribou in Newfoundland','A Caribou Hunt','Testamentet','Testamentet','The Will','That Fatal Sneeze','A végzetes tüsszentés','That Fatal Sneeze','Nysepulveret','??? ??????? ???????','Tierra baja','Tryllesækken','Tryllesækken','The Magic Bag','The Ugly Duckling','Villafranca: Fiestas del Drac y bailes típicos','Yale Laundry','Ostler Joe','??????????? ?????','Dollie kalandjai','The Adventures of Dollie','The Adventures of Dollie','Dollys Abenteuer','Les aventures de Dollie','As Aventuras de Dollie','After Many Years','Amleto','Amleto','Hamlet','Hamlet','Hamlet','Hamlet','Amleto','Amleto','Amor que mata','The Anarchists Sweetheart','Antony and Cleopatra, the Love Story of the Noblest Roman and the Most Beautiful Egyptian','Antony and Cleopatra','Antony and Cleopatra','As You Like It','Lassassinat du duc de Guise','Lassassinat du duc de Guise','O Assassinato do Duque de Guise','Duqueza de Guize','Guisen herttuan murha','Hertugen af Guises Mord','???????? ??????? ?? ????','?????????? ?? ??? ??? ???','Guise herceg meggyilkolása','The Assassination of the Duke de Guise','Die Ermordung des Herzogs von Guise','O Assassinato do Duque de Guise','Zabójstwo ksiecia Gwizjusza','At the Crossroads of Life','At the Crossroads of Life','Crossroads of Life','At the French Ball','An Awful Moment','An Awful Moment','??????? ??????','Balked at the Altar','???????????? ? ??????','Balked at the Altar','The Bandits Waterloo','Barbara Fritchie: The Story of a Patriotic American Woman','Barbara Fritchie: The Story of a Forgotten Woman','Barbara Fritchie: The Story of a Patriotic American Woman','Behind the Scenes: Where All Is Not Gold That Glitters','Behind the Scenes','Behind the Scenes','Betrayed by a Handprint','????????????? ?????????','Betrayed by a Handprint','Betrayed by Hand Prints','Biblical Scenes','Bjørnejagten','?????? ??????','The Black Viper','The Black Viper','La vipère noire','Bobbys Kodak','The Boston Tea Party','The Boy Detective, or The Abductors Foiled','A Calamitous Elopement','??????????? ?????','Une déclaration difficile','A Calamitous Elopement','The Call of the Wild','Los calzoncillos de Tony','Il cane riconoscente','Nuit tragique','Il cane riconoscente','The Grateful Dog','Cursa de cavalls a lHipodrom','Carreras de caballos en el Hipodromo','Carreras de caballos de 1908','Carreras de caballos de 1908','Le cauchemar de Fantoche','Living Blackboard','Le cauchemar de Fantoche','?????? ? ????????','The Puppets Nightmare','Caught by Wireless','The Christmas Burglars','Humanity Through the Ages','La civilisation à travers les âges','La civilisation à travers les âges','Classmates','The Clubman and the Tramp','Los competidores','Concealing a Burglar','Corrida de toros con Antonio Fuentes','Bullfight with Antonio Fuentes','Corrida de toros con Antonio Fuentes','Bullfight with Ricardo Torres Bombita','Corrida de toros con Ricardo Torres Bombita','Corrida de toros con Ricardo Torres Bombita','Greven fra Monte Christo','El conde de Monte Cristo','The Count of Monte Cristo','The Count of Monte Cristo','Cupids Pranks','Cupids Pranks','As Travessuras do Cupido','El curioso impertinente','The Death of Othello','Desdemona','Desdemona','The Devil','La Dolores','Don Juan Tenorio','Don Quijote','Don Álvaro o la fuerza del sino','Ex-Convict No. 900','Loro nascosto','Ex-Convict No. 900','Excursión a Montserrat','Excursión a Montserrat','Montserrat pintoresco','The Fairylogue and Radio-Plays','Falsely Accused!','A Famous Escape','Black and White','?????????????','Fantazmagória','Fantasmagorie','Metamorphosis','?????????????','Fantasmagorie','A Fantasy','The Fatal Hour','???? ?????? ? ????','Father Gets in the Game','Father Gets in the Game','The Feud and the Turkey','Fiestas del carnaval de 1908 en Barcelona','A Florida Feud: or, Love in the Everglades','A Florida Feud: or, Love in the Everglades','Florida Crackers','The Flower Girl of Paris','For Love of Gold','For Love of Gold','Amor ao Ouro','For a Wifes Honor','The French Maid','El fusilamiento de Dorrego','El fusilamiento de Dorrego','Egzekucja Dorrego','Gerona monumental','The Girl and the Outlaw','The Greasers Gauntlet','El guardia burlado','The Guerrilla','The Heart of O Yama','The Helping Hand','The Helping Hand','The Scarlet Woman','Her First Adventure','His Day of Rest','Huldas Lovers','Humpty Dumpty Circus','Inauguración de la exposición hispano-francesa','Inauguración de la exposición hispano-francesa','Inauguración de la exposición hispano-francesa de 1908 por su alteza real el infante Don Carlos','The Barbarian Ingomar','Ingomar, the Barbarian','Ingomar, the Barbarian','The Ingrate','The Invisible Fluid','Julius Caesar','Julius Caesar, an Historical Tragedy','Julius Caesar','The Kentuckian','King of the Cannibal Islands','The Kings Messenger','The Kings Messenger, a Story of Love, Intrigue and Heroism','The Kings Messenger','Leah the Forsaken','The Life of an American Cowboy','Lonesome Junction','Macbeth','Macbeth','??????','Macbeth, Shakespeares Sublime Tragedy','Macbeth','Making Moving Pictures','Mallorca, illa daurada','Majorca, Golden Island','Mallorca, isla dorada','The Man and the Woman','The Man in the Box','Maria Marten','The Red Barn Mystery','The Red Barn Crime','Maria Marten','María Rosa','The Merchant of Venice','The Merchant of Venice','Købmanden i Venedig','Mixed Babies','Monasterio de Poblet','Monday Morning in a Coney Island Police Court','Monday Morning in a Coney Island Police Court','Coney Island Police Court','??-?? ?????','Money Mad','Money Mad','Os Moços de Fretes Têm Sede','Mr. Jones at the Ball','Mrs. Jones Entertains','The Music Master','Old Isaacs, the Pawnbroker','Othello','Jealousy','Othello','The Outlaw','Over the Hill to the Poorhouse','The Paris Hat','El pastorcito de Torrente','The Pirates Gold','The Planters Wife','The Planters Wife','Malasia','Poverty and Compassion','The Princess in the Vase','Professional Jealousy','Raffles, an American Cracksman','The Reckoning','The Red Girl','Lenfant et le peau-rouge','The Red Man and the Child','The Red Man and the Child','Rescued from an Eagles Nest','Rescued from an Eagles Nest','I Ørnekløer','Kimentés a sas fészkéb?l','????????? ?? ???????? ??????','O Resgate no Ninho da Águia','Richard III','Richard III','Richard III: A Shakespearian Tragedy','The Roman','????? ???????','Romance of a Jewess','Romance of a Jewess','The Romance of an Egg','Romeo and Juliet, a Romantic Story of the Ancient Feud Between the Italian Houses of Montague and Capulet','Romeo and Juliet','Romeo y Julieta','Romeo and Juliet','The Dream of an Opium Fiend','Le rêve dun fumeur dopium','??? ?????????? ??????','Le rêve dun fumeur dopium','O Pesadelo do Escultor','The Sculptors Nightmare','The Sculptors Nightmare','She','Sherlock Holmes i Livsfare','Sherlock Holmes i Livsfare','Raffles Flugt fra Fængslet','Sherlock Holmes','Sherlock Holmes I','Sherlock Holmes II','Sherlock Holmes II: Raffles Escaped from Prison','Sherlock Holmes II','Sherlock Holmes III','Sherlock Holmes III','Sherlock Holmes III: The Detectives Adventure in the Gas Cellar','Simulacro de bomberos en la Plaza de Cataluña, de Barcelona','A Smoked Husband','The Snowman','????? ? ???????','The Song of the Shirt','The Song of the Shirt','Az ing dala','The Stage Rustler','The Stage-Struck Daughter','The Stolen Jewels','Svend Dyrings hus','?????????????? ????????','Le tambourin fantastique','Le tambourin fantastique','Knight of Black Art','?????????? ?? ????????????','Ukro?ena goropad','Makrancos hölgy','????????? ??????????','The Taming of the Shrew','The Taming of the Shrew','La fierecilla domada','The Tavern Keepers Daughter','The Tavern Keepers Daughter','The Tavern Keepers Daughter','The Test of Friendship','Thompsons Night Out','To the Custody of the Father','Trop crédules','Susceptible Youth','Susceptible Youth','Trop crédules','Gli ultimi giorni di Pompeii','?????????? ??? ?? ??????','La destruccion de Pompeya','Gli ultimi giorni di Pompeii','Pompeis sidste page','De laatste dagen van Pompeï','Pompeji utolsó napjai','Les derniers jours de Pompéi','The Last Days of Pompeii','Die letzten Tage von Pompeji','An Unexpected Santa Claus','The Valets Wife','The Valets Wife','The Valets Wife, or, Deceiving the Uncle','The Vaqueros Vow','Hercules the Athlete; or, Love Behind the Scenes','Verdens Herkules','Verdens Herkules','The Vikings Daughter: The Story of the Ancient Norsemen','The Vikings Daughter: The Story of the Ancient Norsemen','The Vikings Daughter','A Visit to the Seaside','A Visit to the Seaside at Brighton Beach, England','A Visit to the Seaside','When Knighthood Was in Flower','When Knights Were Bold','Where the Breakers Roar','Wiegenlied','A Womans Way','The Yellow Peril','The Zulus Heart','Der Luftkrieg der Zukunft','The Aerial Torpedo','The Airship Destroyer','The Battle in the Clouds','??????????? ??????????','The Airship Destroyer','Amor heroico','And a Little Child Shall Lead Them','Andreas Hofer','Andreas Hofer','Andreas Hofer','The Apache Girls Revenge','The Revenge of the Apache Girl','Apachepigens hævn','Apachepigens hævn','The Artists Revenge','As It Is in Real Life','At the Altar','At the Altar','?? ??????','An Attempt to Smash a Bank','Aventuras de Pepín','The Awakening','Threads of Fate','A Babys Shoe','A Babys Shoe','The Bailiff and the Dressmakers','Barnet som Velgører','The Child Benefactor','Lapsi hyväntekijänä','Barnet som Velgører','El barranco del lobo','Baño imprevisto','Surprise Bath','Baño imprevisto','The Best Man Wins','The Better Way','Bettys Choice','Bill Sharkeys Last Game','Bill Sharkeys Last Game','Bill Sharkeys Revenge','Última Cartada','The Black Sheep','The Blind Man','El blocao Velarde','Bluebeard','La bocana de Mar Chica','The Brahma Diamond','The Broken Locket','Et budskab til Napoleon paa Elba','A Message to Napoleon','Et budskab til Napoleon paa Elba','The Burglar and the Child','A Burglars Mistake','Guerra de Melilla','Spanish War with the Riffs in Melilla','Der Krieg von Melilla','La guerra di Melilla','Campaña del Riff','Richelieu or the Cardinals Conspiracy','The Cardinals Conspiracy','The Cardinals Conspiracy','Celos gitanos','A Change of Heart','A Child of the Forest','The Childrens Friend','The Childrens Friend','O Amigo das Crianças','Choosing a Husband','Siouxindianeren Comata','Comata, the Sioux','Comata, the Sioux','???????','Confidence','Confidence','A Convicts Sacrifice','Corazón de madre','???? ??????','The Cord of Life','The Cord of Life','Arbetare contra överklassen','?????????? ????????','O Preço do Trigo','Les spéculateurs','A Corner in Wheat','A Corner in Wheat','A gabonat?zsde spekulánsai','Storspekulanten','Le spéculateur en grains','The Country Doctor','???????? ????','Il medico di campagna','The Country Doctor','A Cowards Courage','The Cricket on the Hearth','The Cricket on the Hearth','???????? ???????','Os Crimes de Diogo Alves','The Criminal Hypnotist','Cultura do Cacau em S. Tome','A Cultura do Cacau','A Cultura do Cacau','The Cultivation of the Cacao Tree','The Curse of Money','?????? ??? ????','The Curtain Pole','The Curtain Pole','The Day After','Dagen derpaa','The Day After','De Garraf a Barcelona','The Death Disc: A Story of the Cromwellian Period','The Death Disc: A Story of the Cromwellian Period','The Death Disc','The Death of Ivan the Terrible','Smert Ioanna Groznogo','?????? ?????? ????????','The Deception','Un día en Xochimilco','Don Juans Hochzeit','Don Juans Wedding','Der Herzenknicker','Don Juan heiratet','Don Juan heiratet','Don Juans Bryllup','Incident from Don Quixote','Don Quichotte','La toile daraignée merveilleuse','La toile daraignée merveilleuse','The Painting of a Miraculous Spider','Two Valiants Face to Face','Dos guapos frente a frente','Dos guapos frente a frente','Los dos hermanos','The Drive for a Life','?????????? ???????','Egy részeg megtérése','A Drunkards Reformation','A Drunkards Reformation','The Eavesdropper','Edgar Allan Poe','????? ????? ??','Edgar Allen Poe','Edgar Allan Poe','Eloping with Auntie','Gespräch der Präsidenten Diaz-Taft','Entrevista de los Presidentes Díaz-Taft','Entrevista de los Presidentes Díaz-Taft','Eradicating Auntie','Eradicating Aunty','Eradicating Aunty','The Expiation','Fabricación del corcho en Sant Feliu de Guixols','The Faded Lilies','A Fair Exchange','Faldgruben','Farmer Giles Visit to London','Farmer Giles in London','Farmer Giles Visit to London','The Fascinating Mrs. Francis','A Fathers Mistake','Fellow Clerks','Fiesta de toros','Fiestas de Santa Lucía - Belenes','Fiestas en La Garriga','A Fools Revenge','Kongen morer sig','A Fools Revenge','Fools of Fate','The Foundling: A Dressing Room Waif','The Foundling','The Foundling','?????????????? ??????','Bakchisarayskiy fontan','Fontanna w Bakczysaraju','The Fountain of Bakhchisarai','The French Duel','Amigo da Família','The Friend of the Family','The Friend of the Family','Fuss and Feathers','?????? ?????','Getting Even','Getting Even','The Gibson Girl','?????? ???????','The Gibson Goddess','The Gibson Goddess','Gira política de Madero y Pino Suárez','The Girls and Daddy','Le glas du père Césaire','Rintocchi funebri per parà Cesare','Le glas du père Césaire','??????? ???','The Golden Louis','The Golden Louis','The Grey Dame','Den graa dame','The Grey Lady','Den grå damen','The Grey Lady','Harmaa nainen','Den graa dame','Grevinde X','The Red Domino','Den røde Domino','Guzman the Brave','Guzmán el Bueno','Guzmán el Bueno','Hamlet','Hamlet, Prince of Denmark','Hamlet','Hansel and Gretel','Hansel and Gretel','Hansel y Gretel','The Heart of a Clown','The Heart of a Cowboy','The Heart of an Outlaw','Heksen og cyklisten','The Witch and the Bicyclist','A feiticeira e o ciclista','Heksen og cyklisten','Cycle Rider and the Witch','Az els? sütemény','Her First Biscuits','Her First Biscuits','Her Indian Hero','Herremandens Barnebarn','Godsejerens Barnebarn','Herremandens Barnebarn','The Farmers Grandson','Godsejerens Datter','1776, or The Hessian Renegades','?????????? ?????????','The Hessian Renegades','The Hessian Renegades','The Hindoo Dagger','His Duty','His Lost Love','His Reformation','His Wards Love','His Wifes Mother','His Wifes Visitor','The Honor of Thieves','The House of Cards','I Did It','The Terrible Quarrel','I Did It, Mamma','I Did It','I Did It, Mama','The Idiot of the Mountains','In Little Italy','Fra det gamle Kentucky','In Old Kentucky','A régi Kentuckyban','In Old Kentucky','In a Hempen Bag','In the Watches of the Night','In the Window Recess','The Indian Runners Romance','?????? ?????????? ??????','The Indian Runners Romance','The Indian Trailer','Industria del corcho','Jailbird in Borrowed Feathers','Max Linder vil gerne have et Barn','Sehnsucht nach einem Kind','Max tahtoo saada lapsia','När Max vill hafva barn','Max Linders Big Family','Je voudrais un enfant','Je voudrais un enfant','Jealousy and the Man','Jessie, the Stolen Child','The Jilt','Jones and His New Neighbors','Jones and the Lady Book Agent','?????? ?????????? ???????????? ?????????','The Joneses Have Amateur Theatricals','The Joneses Have Amateur Theatricals','El joyero','Les joyeux microbes','A Bad Case','Les joyeux microbes','The Merry Microbes','The Jolly Germs','Judgment','Justicia de Felipe II','Justicia de Felipe II','The Justice of Philip II','Kinemacolor Puzzle','King Lear','Willys Streiche: Klebolin klebt alles','Klebolin klebt alles','Klebolin klebt alles','Der kleine Detektiv','Dødsspringet','Dödsspringet','Dødsspringet','En kvinde af folket','A Woman of the People','En kvinde af folket','Lady Helens Escapade','Leather Stocking','Læderstrømpe og Den sidste Mohikaner','Leather Stocking','La lumière retrouvée','? ?????? ????','The Light That Came','The Light That Came','Lines of White on a Sullen Sea','The Little Darling','The Little Darling','???????','The Little Teacher','Lochinvar','Locura de amor','Love Crazy','Locura de amor','?????????? ?????','The Lonely Villa','The Lonely Villa','O Casarão Isolado','Samotna willa','A magányos villa','Love Finds a Way','The Luck of the Cards','Lucky Jim','Lucky Jim','????????? ????','???????? ?? ??????','The Lure of the Gown','The Lure of the Gown','Lægens offer','La légende de larc-en-ciel','Gasrøret','Det løbske gasrør','Det løbske gasrør','Macbeth','Macbeth','Macbeth','??????','Macbeth','Macbeth','Macbeth','Macbeth','Madam Sans Gene; or, The Duchess of Danzig','Madame Sans-Gêne','Madame Sans-Gêne','En Nonnes Kærlighedsroman','Madame de Langeais','Madame de Langeais','A Maid of the Mountains','Mamma','A Man with Three Wives','A Man with Three Wives','Manden med de tre Koner','The Maniac Cook','Le mariage forcé','Le mariage forcé','Max gifter sig','The Medicine Bottle','Melilla y el Gurugu','???????????? ?????','The Mended Lute','The Mended Lute','The Message','The Mexican Sweethearts','A Mexicans Gratitude','A Midnight Adventure','Midnight Disturbance','En Skærsommernatsdrøm','Sonho de uma Noite de Verão','A Midsummer Nights Dream','??? ? ?????? ????','A Midsummer Nights Dream','Sonhos de uma Noite de Verão','The Mills of the Gods','Mistaken Identity','Galejslaven Jean Valjean','Les Misérables','Jean Valjean','Les Misérables','Les Misérables','Nyomorultak','Les Misérables','Nedznicy','Molière','The Life of Moliere','Molière','Molière','Molier','Le Moulin maudit','The Mill','Le Moulin maudit','The Mill','Het sprookje van den vervloekten molen','The Mountaineers Honor','Mr. Jones Has a Card Party','Mr. Jones Burglar','Jones Burglar','Mr. Jones Burglar','Mrs. Jones Lover; or, I Want My Hat','Mrs. Jones Lover','Mrs. Jones Lover; or, I Want My Hat','I Want My Hat','Amante da Senhora Jones','Mutterliebe','Napoleon og hans lille Trompetist','Napoleon fra Vuggen til Graven','The Life of Napoleon (Part Two)','Napóleon, a végzet embere','Napoleon, the Man of Destiny','Napoleon, the Man of Destiny','A Narrow Escape from Lynching','The Necklace','The New Servant','A New Trick','Niños en la alameda','The Note in the Shoe','???? ?? ???????','Nursing a Viper','Nursing a Viper','Naar Djævle er paa Spil','Quand les diables font des siennes','Wenn der Teufel im Spiel ist','How Brother Cook was Taught a Lesson','När djäflarna äro på färde','Naar Djævle er paa Spil','Quando i diavoli ci mattono la corna!','Den nærsynede guvernante','The Short-Sighted Governess','Den nærsynede guvernante','Oh, Uncle!','Twist Olivér','Oliver Twist','Oliver Twist','?????? ?????','Custers Last Stand','On the Little Big Horn or Custers Last Stand','On the Little Big Horn or Custers Last Stand','De onde Veje','One Busy Hour','One Good Turn Deserves Another','One Touch of Nature','Only a Tramp','The Open Gate','Otello','Othello','Othello','Otelló','?????','Othello','Othello','Otello de Moor van Venetie','Otello','Othello','The Destiny of Paul Wang','Paul Wangs Destiny','Paul Wangs skæbne','Paul Wangs skæbne','The Peachbasket Hat','The Peachbasket Hat','The Peach-Basket Hat','Pippa Passes; or, The Song of Conscience','The Song of Conscience','Pippa Passes; or, The Song of Conscience','????? ????????','The Politicians Love Story','The Politicians Love Story','?????? ????????','Por un ratón','Le portrait de Mireille','Portrait of Mireille','Le portrait de Mireille','Il ritratto di Mireille','Pranks','Primera carrera internacional de automóviles Peña-Rhin','La primera y segunda casetas','The Prince and the Pauper','Koldus és királyfi','The Prince and the Pauper','El príncipe y el mendigo','Princess Nicotine; or, The Smoke Fairy','????????? ????????','Princess Nicotine; or, The Smoke Fairy','The Smoke Fairy','Protección de un convoy de víveres en el puente de camellos','Den prøjsiske Spion','The Prussian Spy','The Prussian Spy','The Ranchmans Rival','The Red Mans View','The Red Mans View','?????? ????????????','?????','The Renunciation','The Renunciation','The Restoration','Resurrection','Resurrection','???????????','Revolutionsbryllup','Revolutionsbryllup','A Wedding During the French Revolution','Richelieu; or: The Conspiracy','Richelieu; or: The Conspiracy','Richelieu, avagy az összeesküvés','The Road Agents','The Road to the Heart','Robbing the Widowed and Fatherless','A Rose of the Tenderloin','The Roues Heart','A Rude Hostess','A Rural Elopement','Ruy Blas','The Sacrifice','Salome Mad','The Salvation Army Lass','Saul and David','Saul and David','Saul og David','Saul and David: The Biblical Story of the Shepherd Boy Who Became King of the Israelites','Schneiders Anti-Noise Crusade','The Sealed Room','Det forseglede Værelse','???????????? ???????','La chambre scellée','The Sealed Room','The Seventh Day','Shanghaied','She Would Be an Actress','Sherlock Holmes IV','Sherlock Holmes V','Sherlock Holmes VI','A Sinners Repentance','A Sisters Love','A Sisters Love: A Tale of the Franco-Prussian War','A Sisters Love: A Tale of the Franco-Prussian War','The Slave','The Sleepwalker','Smiths Knockabout Theatre','The Sons Return','??????????? ????','The Sons Return','Le songe dune nuit dété','A Sound Sleeper','The Spanish Girl','The Special Licence','The Special Licence','The Special License','Gøngehøvdingen','Gøngehøvdingen','Stormen paa København den 11. Februar 1659','A Strange Meeting','El sueño milagroso','El sueño milagroso','Magical Dream','The Suicide Club','A Sweet Revenge','Sweet and Twenty','A Tale of the West','Teaching a Husband a Lesson','Ten Nights in a Barroom','Tender Hearts','O Terremoto de Benavente','The Test','They Would Elope','Those Darn Hats','Those Awful Hats','Ces sacrés chapeaux','??? ??????? ?????','Those Awful Hats','Te okropne kapelusze','Those Boys!','Through the Breakers','Tis an Ill Wind','Tis an Ill Wind That Blows No Good','Tis an Ill Wind That Blows No Good','De to guldgravere','De to guldgravere','Kaksi kullankaivajaa','To Save Her Soul','Toma caseta Z','Toma del Gurugu','Tragedia torera','Tragic Love','En Fælde for Julemanden','A Trap for Santa','A Trap for Santa Claus','??????? ??? ?????-??????','A Trap for Santa Claus','The Treacherous Policeman','The Trick That Failed','A Troublesome Satchel','Trying to Get Arrested','Twin Brothers','Two Memories','Two Women and a Man','Two of the Boys','La vida en el campamento','Viernes de dolores','The Violin Maker of Cremona','?????????? ?????? ?? ???????','The Violin Maker of Cremona','Instrumentmageren fra Cremona','The Voice of the Violin','The Voice of the Violin','????? ???????','Wanted, a Child','Was Justice Served?','Washington Under the American Flag','The Way of Man','We Must Do Our Best','The Welcome Burglar','What Drink Did','What Drink Did','? ???? ???????? ????????','Whats Your Hurry?','When Thieves Fall Out','The Winning Coat','With Her Card','Within an Ace','A Womans Vanity','The Wooden Leg','A Wreath in Time','The Wrong Coat','Lincolns Clemency','Abraham Lincolns Clemency','The Clemency of Abraham Lincoln','Abraham Lincolns Clemency','La clémence dAbraham Lincoln','Across the Plains','An Affair of Hearts','The Affair of an Egg','Afgrunden','??????','Afgrunden','Der Abgrund','Woman Always Pays','I avysos','Gøglerblod','Kuilu','Avgrunden','O Abismo','Afgrunden','Przepasc','The Woman Always Pays','Abgründe','The Abyss','Tuhon partaalla','A züllés útján','Od stupne k stupni','Syvyys','Alices Adventures in Wonderland','All on Account of the Milk','Almost','Laluminite','Lallumina','Laluminite','Amateur Night','Ambrosius','Amleto','Amleto','Hamlet','Hamlet','Amor gitano','The Angel of the Studio','Ansigttyven I','Indbruddet hos Konsul Bjørn','Ansigttyven II','Antony and Cleopatra','Antonius och Kleopatra','Cleopatra','Cléopâtre','Cléopâtre','Cleopatra','Antonius ja Kleopatra','An Arcadian Maid','An Arcadian Maid','????????? ????','Arms and the Woman','As It Is in Life','As It Is in Life','Como é na Vida','?????? ?????','As the Bells Rang Out!','Lauberge rouge','Lauberge rouge','La locanda rossa','The Red Inn','Away Out West','The Bad Mans Christmas Gift','The Bad Mans Last Deed','A Rough Night on the Bridge','Baixant de la font del Gat','The Bandits Wife','Bankierens Datter','The Bankers Daughters','The Bankers Daughters','The Bearded Bandit','Behind the Scenes','The Bewitched Boxing Gloves','The Blue Bird','Briton and Boer','The Broken Doll','A Broken Spell','Broncho Billys Redemption','The Brothers','Buffalo Bills Wild West and Pawnee Bills Far East','The Bully','The Butterfly','By Order of Napoleon','The Call to Arms','The Call','Carceleras','Carceleras','Les prisonnières','Carminella','O Centenário da Guerra Peninsular','Chantecler Atraiçoado','The Child and the Fiddler','???? ?????','A Child of the Ghetto','A Child of the Ghetto','A Childs Faith','A Childs Impulse','A Childs Stratagem','Circle C Ranchs Wedding Present','The Clerks Downfall','The Cloisters Touch','The Common Enemy','Den fælles Fjende','The Common Enemy','Concurso de niños','The Connecticut Yankee','Conscience','The Baker Boy','Conscience','Conscience; or, The Baker Boy','The Converts','Un corpus de sangre','Corrida da Rampa','The Costers Wedding','The Course of True Love','The Courtship of Miles Standish','The Cowboy and the Squaw','A Cowboys Mother-in-Law','The Cowboys Sweetheart','A Cowboys Vindication','The Cowpunchers Ward','Cretinetti e le donne','Cretinetti e le donne','Lehman og Kvinderne','The Crime of a Grandfather','Le crime du grand-père','Le crime du grand-père','Il delitto del nonno','Cyclone Petes Matrimony','Kameliadamen','Camille','La dame aux camélias','Kameliadamen','Die Kameliendame','La dame aux camélias','La dama de las camelias','The Dancing Girl of Butte','Davy Crockett','The Deputys Love Affair','Desfile histórico del centenario','The Desperado','El diablo está en Zaragoza','A Dixie Mother','Djævlesonaten','Don Juan de Serrallonga','Dorian Grayn muotokuva','Dorian Grays Portræt','Dorian Grays Portræt','Dorian Gray porträtt','Dorothy und Vogelscheuche in Oz','Dorothy and the Scarecrow in Oz','Dorothy and the Scarecrow in Oz','The Dukes Plan','The Dumb Half Breeds Defense','Den døde Rotte','Døden','Effecting a Cure','The Electrical Vitalizer','Elektra','Rakkaus leikkikaluna','Leikki lemmen kanssa','Elskovsleg','En lek med kärleken','Elskovsleg','Elverhøj','Elverhøj','Os Filhos de Eduard IV','La morte dei figli di Re Eduardo','Les enfants dÉdouard','Les enfants dÉdouard','The Engineers Romance','The Engineers Daughter','The Englishman and the Girl','La esclusa','Examination Day at School','Excursión al Gombreny','La expiación','Fabricación del cemento Asland','The Face at the Window','Faithful','??????','Faithful','The Farmers Daughter','Una farsa de colas','A Fatal Picnic','Faust','Faust','Faust','La fecha de Pepín','La diada den Pepet','El día den Pepet','The Fence on Bar Z Ranch','La figlia di Jefte','The Vow; or, Jephthahs Daughter','La fille de Jephté','La fille de Jephté','La fine di Paganini','La fin de Paganini','La fin de Paganini','The End of Paganini','The Final Settlement','O Ajuste Final','The Final Settlement','??????? ?????','A Flash of Light','A Flash of Light','Un alma reprobada','Flema inglesa','Lépée du spirite','British Phlegm','Nicholas el Tonto','A Fallen Spirit','Le flegme britannique','Flores y perlas','Fleurs et perles','Flores y perlas','The Flower of the Ranch','For Her Sisters Sake','The Forest Ranger','Frankenstein','????????????','Frankenstein','Frankenstein','Frankenštajn','Potted Plays No. 3','The Freezing Mixture','The Freezing Mixture','From Storm to Sunshine','From Tyranny to Liberty','The Fugitive','El fugitivo','The Fugitive','??????','A Gambler of the West','Et gensyn','Gentleman Joe','The Girl and the Fugitive','La fille dArizona','The Girl from Arizona','The Girl from Arizona','The Girl on Triple X','Gold Is Not All','A Gold Necklace','Miss Dorothys Halsbaand','A Gold Necklace','The Gold Seekers','The Golden Supper','The Golden Supper','Het gouden feestmaal','Great Fight at All-Sereno','Los guapos','Los guapos','Les gandins','Hamlet','Hamlet','Hamlet','Her Fathers Pride','Sin Faders Stolthed','Her Fathers Pride','Her Photograph','Her Terrible Ordeal','Her Terrible Ordeal','?? ???????? ?????????','La hija del guardacostas','La hija del guardacostas','The Coastguards Daughter','La fille du garde-côte','His Brothers Wife','Hans sidste Indbrud','His Last Burglary','His Last Burglary','Hans sidste Dollar','His Last Dollar','His Last Dollar','His Mothers Necklace','His New Lid','His Only Daughter','His Sister-In-Law','The Honor of His Family','The Hoodoo','Le legs de loncle Slip','The Hoodoo','The House with Closed Shutters','??? ? ????????? ????????','The House with Closed Shutters','La casa con las persianas echadas','The House of the Seven Gables','Valkoinen orjakauppa','The White Slave Trade','Die weiße Sklavin I','Leánykeresked?k','Den hvide slavehandel','Den hvide slavehandel','De blanke slavin','The Iconoclast','The Impalement','Impersonating the Policeman Lodger','In Lifes Cycle','In Neighboring Kingdoms','In Old California','In the Border States','Na Fronteira do Estado','?? ??????? ??????','Dans les états limitrophes','En los estados fronterizos','In the Border States','In the Hands of the Enemy','In the Mission Shadows','The Season of Buds','In the Season of Buds','In the Season of Buds','An Indian Girls Awakening','An Indian Girls Love','An Indian Girls Love','An Indian Wifes Devotion','An Indian Wifes Devotion','Devoção da Esposa Índia','Inundaciones en Lérida','Jakes Daughter','The Jewel Case','Sølvdaasen','Sølvdaasen med Juvelerne','Sølvdaasen','John Dough and the Cherub','Juggling on the Brain','Justicias del rey Don Pedro','Kapergasten','A Knot in the Plot','Kærlighed og selvmord','Köpenhamns nattlif eller Äktamännen på villovägar','København ved Nat','Copenhagen by Night','København ved Nat','Köpenhaminan yöelämää eli Aviomiehet harhateillä','The Lady and the Burglar','The Land of Oz','The Last Deal','De zoon van den predikant','The Lesson','The Lesson','Forty Years in the Land of the Midian','Mózes élete','Moses lif i lefvande bilder','The Victory of Israel','The Life of Moses','The Life of Moses','The Plagues of Egypt','The Promised Land','Little Angels of Luck','The Little Orphan','The Little Prospector','Llegada del marqués de Polavieja a Veracruz','The Long Trail','Lord Blends Love Story','Love Among the Roses','?????? ????? ???','Love Among the Roses','Love of Chrysanthemum','Loves C. Q. D.','Lucha fratricida o Nobleza aragonesa','La lucha por la divisa','Luck of Roaring Camp','Miss Dorothy har Tandpine','A Lucky Toothache','A Lucky Toothache','Macbeth','??????','Macbeth','A Mad Infatuation','Madre mía','La fille du Niagara','The Maid of Niagara','The Maid of Niagara','The Man','Mannequins','Gelbstern','La couverture du cheval','La manta del caballo','La manta del caballo','The Fairy Bookseller','Le marchand dimages','Le marchand dimages','The Marked Time-Table','The Marked Trail','The Masher','May and December','Mazeppa, or the Wild Horse of Tartary','Mazeppa','Mazeppa, or the Wild Horse of Tartary','Mellem pligt og kærlighed','Et menneskeliv','???????????? ?????','Il mercante di Venezia','Il mercante di Venezia','Shylock, ou le marchand de Venise','Shyloch, ó el mercador de Venecia','The Merchant of Venice','Der Kaufmann von Venedig','Der Kaufmann von Venedig','The Message of the Violin','Messaline','Messaline','The justice of Claudius','Messalina','The Mexicans Faith','Michael Strogoff: A Courier of the Czar','Michael Strogoff','Michael Strogoff','Mihail Strogov','A Midnight Cupid','Os Milagres de Nossa Senhora da Penha','The Cowboy Millionaire','Cowboymillionæren','The Cowboy Millionaire','Fell Heir to a Million Dollars','The Millionaire Cowboy','The Millionaire and the Ranch Girl','The Misers Child','The Missing Bridegroom','The Mistaken Bandit','??????????? ??????? ???','The Modern Prodigal','The Modern Prodigal','A Mohawks Way','The Mohawks Treasure','Mohikanere','A Mohawks Way','Montblanc la serra','El moscardón','The Patchwork Quilt','A Mothers Devotion; or, The Firing of the Patchwork Quilt','A Mothers Devotion; or, The Firing of the Patchwork Quilt','A Mothers Devotion','A Moving Picture Rehearsal','Muggsy er en Helt','Muggsy Becomes a Hero','Muggsy Becomes a Hero','Muggsys First Sweetheart','Never Again','The New Magdalen','The New Stenographer','The Newlyweds','The Newly Weds','The Newlyweds','Maiskaya noch, ili utoplennitsa','A Night in May','???? ? ???','Not So Bad as It Seemed','The Oath and the Man','?????? ? ???????','The Oath and the Man','Jarní sen starého mládence','Jarní sen starého mládence','Sen starého mládence','The Old Bachelors Dream','The Old Hat','The Old Soldier','An Old Story with a New Ending','On the Reef','One Night, and Then --','Ononkos Vow','Orientalsk dans','Our Darling','The Outlaws Sacrifice','?????? ???????','Over Silent Paths','Over Silent Paths','The Padres Secret','Paganini','Pals of the Range','Para domar la suegra','Para domar la suegra','To Tame the Mother-in-Law','Parada militar en el paseo','Patricia of the Plains','Peder Tordenskjold','Peder Tordenskjold','Søhelten Tordenskjold','Tordenskjold i Dynekilen','A Pesca do Bacalhau','The Phoenix','The Picture Thieves','A Plain Song','The Plans of the Fortress','El pobre Valbuena','The Pony Express Rider','Un portero modelo','Un porter model','Un portier modèle','Pride of the Range','The Princess and the Peasant','The Purgation','Rainha Depois de Morta Inês de Castro','??????','Ramona','Ramona: A Story of the White Mans Injustice to the Indian','Ramona','The Ranch Girls Legacy','The Ranch Girls Legacy','A Refusal','Ranch Life in the Great Southwest','Élet a délnyugati ranchon','Ranch Life in the Great Southwest','The Ranchmans Feud','The Range Riders','The Rangers Bride','König Lear','King Lear','Re Lear','Re Lear','King Lear','El rey Lear','Re Lear','Le roi Lear','Re Lear','?????? ???','A Record Hustle Through Foggy London','A Record Hustle Through Foggy London','Seeing London in One Hour','Regina von Emmeritz och konung Gustaf II Adolf','Regina von Emmeritz og Kong Gustav Adolph','Regina von Emmeritz och konung Gustaf II Adolf','Regina von Emmeritz','En rekrut fra 64','Ein Rekrut von 64','En rekrut fra 64','Rekryytti vuodelta 1864','En rekryt från år 1864','Revolução de 5 de Outubro','Ribera del Llobregat','A Rich Revenge: A Comedy of the California Oil Fields','A Rich Revenge','A Rich Revenge','The Rocky Road','Le roi des parfums','Il re dei profumi','Le roi des parfums','A Romance of the Western Hills','Rose o Salem Town','???? ??????','Rose o Salem Town','Pigen fra Salem','De roos van Salem','A Sailors Sacrifice','A Salutary Lesson','The Seal of the Church','Segunda carrera automovilista Peña-Rhin (Mataró-Argentona)','Serious Sixteen','The Sheriffs Sacrifice','The Silent Message','Jævne Folk','Simple Charity','Simple Charity','Sisters','Skarpretterens Søn','Skarpretterens Søn','The Son of the Executioner','The Smoker','Elskovsfløjten','The Song of the Wildwood Flute','The Song of the Wildwood Flute','The Sorrows of the Unfaithful','The Stricken Home','The Suffragettes and the Hobble Skirt','A Summer Flirtation','A Summer Idyl','A Summer Idyll','A Summer Idyll','En Sommertragedie','A Summer Tragedy','A Summer Tragedy','Sunshine Sue','Take Me Out to the Ball Game','Treinando Animais Selvagens','Taming Wild Animals','Taming Wild Animals','Taming a Husband','Teatro de la naturaleza en Sabadell','The Tenderfoot Messenger','The Tenderfoots Triumph','That Chink at Golden Gulch','Thou Shalt Not','The Thread of Destiny','The Thread of Destiny','Aftenklokkerne','The Thread of Destiny: A Tale of the Old Suthwest','Through Fire to Fortune','Tommy Gets His Sister Married','Tommy Gets His Sister Married','Tommy veut marier sa soeur','The Touts Remembrance','In the Olden Time','A Tragedy of the Olden Times','A Tragedy of the Olden Times','A Story of the Olden Times','La Joconde','Un tragico amore di Monna Lisa, la Gioconda','Mona Lisan rakkausseikkailu','Mona Lisas kärleksäfventyr','Le tragique amour de Mona Lisa','Le tragique amour de Mona Lisa','Trail to the West','A Womans Treachery','A Womans Treachery','A Treacherous Woman','Trimming of Paradise Gulch','Enfeites com Flores Selvagens','Trimming of Paradise Gulch','True to His Duty','The Truth Will Out','The Twisted Trail','The Twisted Trail: A Story of Fate in the Mountain Wilds','The Twisted Trail','Das räudige Schaf im Fürstentum Camarillo','The Two Brothers','The Two Brothers','The Two Fathers','Two Little Waifs','Two Little Waifs','Two Little Waifs: A Modern Fairy Tale','???????????? ????','O Mar Imutável','The Unchanging Sea','The Unchanging Sea','Haabet','Onkel Toms Hytte','Uncle Toms Cabin','Onkel Toms stuga','Uncle Toms Cabin','La cabaña del tío Tom','Under Western Skies','Unexpected Help','The Unknown Claim','Up San Juan Hill','Up a Tree','O Usurário','?????????','The Usurer','The Usurer','Valdemar Sejr','The Vampire','A Vein of Gold','A Victim of Jealousy','Värmländingarne','Värmlänningarne','Men of Varmland','Värmlänningarne','Waiter No. 5','Tjener Nr. 5','Waiter No. 5','The Way of the World','The Wedding That Didnt Come Off','Western Chivalry','A Western Maid','A Western Womans Way','A Westerners Way','What the Daisy Said','Marguerittens Spaadom','What the Daisy Said','When We Called the Plumber In','When We Were in Our Teens','When We Were in Our Teens','Da vi var 21','When the World Sleeps','White Roses','Hvem er hun?','Madame X','La femme','Kvinnan','Wer ist Sie?','Nainen','Hvem er hun?','Who Is She?','??????? ?????','Wilful Peggy','Wilful Peggy','Winning Back His Love','?????? ? ??? ?????','Winning Back His Love','Teruggewonnen liefde','The Woman from Mellons','The Woman Hater','A Womans Folly','O Mágico de Oz','???????????? ????????? ?????? ??','The Wizard of Oz','The Wonderful Wizard of Oz','The Wonderful Wizard of Oz','Óz, a csodák csodája','A Workers Wife','As Últimas Inundações do Tejo em Santarém','The Stronger Love','Tween Two Loves','Entre deux amours','Between Two Loves','Tween Two Loves','Across the Plains','The Adopted Child','The Adventures of Billy','The Adventures of a Baby','The Aeroplane Inventor','Kuolema matkustajana eli Ilmapurjehtijan kohtalo','En Opfinders Skæbne','Döden som passagerare eller En aviatikers öde','En Opfinders Skæbne','Döden som passagerare eller En upfinnares öde','Kuolema matkustajana eli Erään keksijän kohtalo','After the Ball','The Aggressor','Aida','Fatal Love','Amor fatal','Amor fatal','Amor que mata','The Amorous Doctor','The Angel of Paradise Ranch','The Angel of the Slums','Arizona Bill','Artful Kate','As in a Looking Glass','At a Quarter of Two','At a Quarter to Two','A Quarter After Two','Mr. Burglar, M.D.','At a Quarter of Two','At the Break of Dawn','At the Dukes Command','At the Threshold of Life','Aux lions les chrétiens','Aux lions les chrétiens','The Christian Martyrs','Münchhausen báró kalandjai','Les hallucinations de baron de Munchhausen','Les aventures de baron de Munchhausen','???????????? ?????? ???????????','Les aventures de baron de Munchhausen','The Hallucinations of Baron Munchausen','Przygody barona Munchausena','Baron Munchhausen','Baron Munchausens Dream','Munchhausen','The Awakening of John Bond','Back to the Primitive','Back to the Soil','The Backwoodsmans Suspicion','The Bad Mans Downfall','The Bad Mans First Prayer','A Balkan Episode','El barón','The Baron','The Baron','The Battle of Bunker Hill','United States History Series #3: The Battle of Bunker Hill','The Battle of Bunker Hill','The Battle of Trafalgar','Slaget ved Trafalgar','The Battle of Trafalgar','The Battle','The Battle','La batalla','La batalla','?????','Bedraget i døden','Doktor Gar el Hama','A Dead Mans Child','Bedraget i døden','Behind the Stockade','The Best Man Wins','Marys Convert','The Better Way','Going Straight','The Better Way','A Linda Betty','Betty Becomes a Maid','Betty Becomes a Maid','Bill Bumpers Bargain','The Black Arrow','The Blackmailer','A Biograph Fantasy in the Land of Flowers','The Blind Princess and the Poet','The Blind Princess and the Poet','Die Blinde','Die Blinde - Der Roman eines hässlichen Mannes','Bobby, the Coward','Bondefangeri i Vaterland','The Border Ranger','A Boy of the Revolution','Boys Will Be Boys','The Brand','Branding a Bad Man','The Broken Cross','Broncho Billys Adventure','Broncho Billys Christmas Dinner','Browns German Liver Cure','En bryllupsaften','Buffalo Bill on the Brain','The Bunco Game at Lizardhead','The Burglar as Father Christmas','Caesars Prisoners','The Call of the Song','The Cameramans Revenge','The Cameramans Revenge','La vendetta del cineoperatore','The Revenge of a Kinematograph Cameraman','A Vingança do Cameraman','Mest kinematograficheskogo operatora','? ???????? ??? ????????????????','Zemsta kinooperatora','Az operat?r bosszúja','????? ???????????????????? ?????????','La venganza del cámara de cine','Captain Barnacles Courtship','The Animal Trainers Daughter','Captain Kate','Kaptajn Kate','Rescued by Her Lions','Captain Kate; or, The Animal Trainers Daughter','Captain Midnight, the Bush King','The Bushrangers Bride','Captain Midnight, the Bush King','Captain Starlight, or Gentleman of the Road','Captain Starlight','Gentleman of the Road','Captain Starlight, or Gentleman of the Road','Carmen o la hija del contrabandista','Carmen o la hija del bandido','Carmenita the Faithful','Carnaval en Palamós','Castillo de Arampruña','The Cattle Rustlers Father','A Cattle Rustlers Father','A Cattle Rustlers Father','The Cattlemans Daughter','Caught with the Goods','Kain og Abel','Cain and Abel','Caïn et Abel','Caïn et Abel','The Changing of Silas Warner','The Changing of Silas Warner','Checkmated','The Chiefs Daughter','The Child Crusoes','?????????????? ????','A Christmas Carol','A Christmas Carol','Cenicienta','Cinderella','Cinderella','Cenicienta','Cinderella','Cinderella','A Citizeness of Paris','The Clowns Sacrifice','The Codfish Industry in Newfoundland','The Coffin Ship','Comrades','Conscience','A Conspiracy Against the King','The Corporation and the Ranch Girl','Cortejo Cívico','The Count and the Cowboys','A Country Cupid','The Country Lovers','The Courting of Mary','The Cowboy Coward','The Punchers Law','Os Crimes de Diogo Alves','The Crooked Road','The Crusader','A Cure for Crime','A Cure for the Crime','A Cure for Crime','Cyrano et dAssoucy','Cyrano et dAssoucy','Cyrano e dAssoucy','Dads Girls','The Daddys Dream','The Daisy Cowboys','Dan the Dandy','Dandy Dick of Bishopsgate','De Gerona a Olot en ferrocarril (De Olot a Gerona en ferrocarril)','A Dead Mans Honor','A Dead Mans Honor','En Misforstaaelse','To Menneskeskæbner','The Death of Nathan Hale','The Death of Nathan Hale','United States History Series #5: The Death of Nathan Hale','The Declaration of Independence','The Declaration of Independence','United States History Series #4: The Declaration of Independence','A Decree of Destiny','The Desert Claim','Detective Henry and the Paris Apaches','Le devoir et lhonneur','A Devoted Friend','The Diamond Star','La digue','La digue','Tama','Pour sauver la Hollande','The Diving Girl','The Doctor','A Dogs Tale','Don Pedro el Cruel','The Dream','Dutch Gold Mine','Dæmonen','Dæmonen','Demonen','Det falske Spil','Le dévouement dun gosse','Ungdom och lättsinne','Ekspeditricen','Nuoruus ja kevytmielisyys','Kaupan myyjätär','Ekspeditricen','Enoch Arden: Part I','Enoch Arden: Part I','Øen i Sydhavet','???? ?????, ???? I','???? ?????: ????? 1','Enoch Arden: Part II','Enoch Arden: Part II','???? ?????: ????? 2','???? ?????, ???? II','Eskimos in Labrador','Ester: A Biblical Episode','Eugene Wrayburn','The Failure','The Fair Dentist','Marys Patients','The Fair Dentist','Den smukke kvindelige Tandlæge','The Faithful Indian','The Faithful Indian','Den trofaste Indianer','The Fall of Babylon','El fantasma del castillo','Farligt spel','Den farlige leg','Den farlige leg','Vaarallista peliä','The Fatal Wedding','Fate','Fate','Das Schicksal','Fates Funny Frolic','Fates Turning','Fattigdommens forbandelse','Fattigdommens forbannelse','Fattigdommens forbandelse','Feria de ganado en Villarrodona','Feria de ganado en Villarrodona','Cattle Market in Vilarrodona','Fiesta Mayor de Manresa','Fiestas del Sitio en Bilbao','Fiestas en La Bisbal','Fighting Blood','Les Quatre Diables','The Four Devils','De röda artisterna','The Four Daredevils','De fire djævle','De fire djævle','A négy ördög','Neljä paholaista eli Punaiset taiteilijat','Os Quatro Diabos','The Four Dare Devils','De fyra djäflarna eller De röda artisterna','Fisher Folks','The Fishermaid','The Fisher-Maid','The Fisher-Maid','The Fishermans Daughter','Flos Discipline','The Flower Girl of Florence','Following Mothers Footsteps','In Mothers Footsteps','Following Mothers Footsteps','In His Mothers Footsteps','For Her Brothers Sake','For the Crown','For the Queens Honor','Desdemona','For aabent Tæppe','Desdemona','For aabent Tæppe','The Foresters Plea','Forgiven in Death','Foul Play','The Four Poster Pest','Freezing Auntie','Den fremmede fugl','Vieras lintu','Az idegen madár','Der fremde Vogel','De Dood van Asta Nielsen','O estranho pássaro','Der fremde Vogel','Unge hjerter','Den främmande fågeln','A French Duel','Friday the 13th','From Factory Girl to Prima Donna','From the Bottom of the Sea','The Submarine Spy','From the Bottom of the Sea','A Frontier Doctor','Galileo','A Gasoline Engagement','The Generals Daughter','The Generals Only Son','George Warringtons Escape','The Geranium','Get Rich Quick','The Ghosts Warning','The Girl Back East','The Girl and the Motor Boat','The Girl of the West','The Gold Lust','The Golden West','Loccidente doro','The Golden West','A Good Turn','The Gordian Knot','The Gun Man','The Gunman','The Gun Man','Okrutny ojciec','Der vilder foter','The Harsh Father','Herinneringen aan lang vervlogen dagen','Heart Beats of Long Ago','Heart Beats of Long Ago','The Heart of a Savage','The Heiress','Helping Him Out','Henry VIII','VIII. Henrik','Henry VIII','Her Awakening','Her Awakening','Despertando de um Letargo','Her Crowning Glory','?? ???????? ???????','Her Crowning Glory','Her Darkest Hour','Her Hero','Her Sacrifice','Her Two Sons','Her Wedding Ring','The Hidden Mine','The Hidden Trail','The Highlander','His Birthday','His Conscience','His Daughter','Zijn dochter','His Daughter','Ægtemandens Manchetskjorte','His Dress Shirt','Dorothys Sorger','His Dress Shirt','His Friends Wife','His Last Burglary','His Message','His Mother','La vieille maman','Die alte Mutter','His Mother','His Mothers Scarf','His Nemesis','His Sisters Children','His Trust','??? ???????????','Su responsabilidad','His Trust: The Faithful Devotion and Self-Sacrifice of an Old Negro Servant','Sa confiance','His Trust: The Faithful Devotion and Self-Sacrifice of an Old Negro Servant','Teljesített küldetés','??????????? ???????','Cumplió con su responsabilidad','His Trust Fulfilled','His Trust Fulfilled','Home, a Thanksgiving Story','Home','Home','Home Sweet Home','The Honeymooners','Honor Thy Father','By the House That Jack Built','How Betty Won the School','How Mrs. Murray Saved the American Army','How Mrs. Murray Saved the American Army','How Mrs. Murray Saved the Army','United States History Series #6: How Mrs. Murray Saved the American Army','How She Triumphed','How She Triumphed','An Argument in Favor of Physical Culture','How Sir Andrew Lost His Vote','The Hypnotist and the Convict','I det stora ögonblicket','In dem großen Augenblick','Ratkaisevalla hetkellä','Im großen Augenblick','The Great Moment','Nos grandes momentos','Im großen Augenblick','Det store øjeblik','The Immortal Alamo','Fall of the Alamo','The Immortal Alamo','In Old California When the Gringoes Came','In Old California When the Gringos Came','In Old California When the Gringos Came','In Sunny Spain','In Old Madrid','In Old Madrid','In the Days of 49','In the Days of Forty-Nine','In the Days of 49','In the Days of Chivalry','In the Days of Gold','In the Reign of Terror','The Sultans Garden','In the Sultans Garden','In the Sultans Garden','The Indian Brothers','The Indian Maidens Lesson','An Indians Sacrifice','Indiscretions of Betty','As Inconsequências de Betty','Indiscretions of Betty','Industrias textiles','The Infant at Snakeville','An International Heart Breaker','The Inventors Son','The Italian Barber','Italian Blood','Italian Blood','Sangre italiana','Jahreszeiten des Lebens','Jane Shore','The Jealous Husband','Johnson at the Wedding','23 pugnali per Cesare','Julius Caesar','Julius Caesar','Julius Caesars Sandals','Järnbäraren','Järnbäraren','Forført','Kitty of Coleraine','Kinemacolor Songs','Simon the Cellarer','Kinemacolor Songs','The King of Indigo','Nos Dias do Ouro','Kit Carsons Wooing','Kit Carsons Wooing','Kitty the Dressmaker','A Knight of the Road','Lady Beaulays Necklace','????????? ????? ????','The Last Drop of Water','The Last Drop of Water','O Último Gole de Água','Den sidste Draabe Vand','The Last Farewell','Lost Years','The Last of the Mohicans','The Law of the Range','The Leading Lady','The Life of Rufus Dawes','The Life of Rufus Dawes','The Convict Hero','The Lighthouse Keeper','The Lily of the Tenements','The Little Daughters Letter','Little Lady Lafayette','Little Nells Tobacco','Winsor McCay, the Famous Cartoonist of the N.Y. Herald and His Moving Comics - The First Artist to Attempt Drawing Pictures That Will Move','?????? ?????? ? ??? ?????????? ????????','Little Nemo','Winsor McCay, le dernier cri des dessins animés','Kis Nemo Szundiországban','Winsor McCay and His Animated Comics','Winsor McCay, the Famous Cartoonist of the N.Y. Herald and His Moving Comics','Winsor McCay Makes His Cartoons Move','Le dernier cri des dessins animés','Winsor McCay','Winsor McCay Explains His Moving Cartoons to John Bunny','Winsor McCay, the Famous Cartoonist of the N.Y. Herald and His Moving Comics','Little Red Riding Hood','Little Red Riding Hood','Caperucita roja','The Living Peach','De moedige dochter van den stationschef','????????????? ?? ?????????','The Lonedale Operator','Telegrafistinden paa Station Lonedale','A távírászlány','A Operadora da Lonedale','The Lonedale Operator','Salvada por el teléfono','The Long Road','Destinys Roadway with Its Many Turns','The Long Road','Lost Illusions','The Lost Necklace','The Lost Ring','The Lost Ring','Den tabte Ring','Johnsons Honeymoon','The Lost Ring; or, Johnsons Honeymoon','Lost in the Arctic','Lost in the Jungle','Forvildet i Urskoven','Lost in the Jungle','Love Conquers','Love Heeds Not Showers','Love Story of Charles II','Love and Hatred','Love in a Cottage','Love in the Hills','Love or Riches','Loves Strategy','Lucha por la herencia','The Lucky Card','A Lucky Escape','Ludwig from Germany','The Lure of the City','Macbeth','??????','Macbeth','Madame Babylas aime les animaux','Frau Babylas liebt die Tiere','Mrs. Pussy Loves Animals','Madame Babylas aime les animaux','Madame Rex','Madame Rex','Madame Rex','Madero al sur del país','The Madman','The Magic Ring','Maid or Man','Major the Red Cross Dog','The Making of a Man','A Man for All That','?????????','The Manicure Lady','The Manicure Lady','A Manly Man','A Manly Man','His Gratitude','Une mariée qui se fait attendre','Une mariée qui se fait attendre','La mariée récalcitrante','The Master and the Man','Maud Muller','Max and His Prescription','Kiinaviinin uhri','Kinavinets offer','Victime du quinquina','Max victime du quinquina','???? - ?????? ??????','Max victime du quinquina','Max als Opfer des Bordeaux-Weines','Max Toma um Tônico','Max Takes Tonics','Max als Opfer des Bordeaux-Weines','The Meeting of the Ways','The Meeting of the Ways','Et Gensyn foran Retsskranken','Menneskedyret','The Message in the Bottle','Midsummer Tide','Mikes Hero','Mike, the Miser','The Millionaire and the Squatter','The Millionaires Nephew','The Miners Curse','The Minute Man','The Mirror','Mischievous Puck','?????? ??????','The Misers Heart','The Misers Heart','Les misérables - Époque 1: Jean Valjean','Kurjat','Les Misérables, Part 1: Jean Valjean','Les misérables - Époque 1: Jean Valjean','Una cenicienta moderna','A Modern Cinderella','A Modern Cinderella','The Modern Dianas','A Modern Hero','The Modern Pygmalion and Galatea','Monasterio de Caralps en Berga','Monasterio de Ripoll','Money to Burn','The Mountain Law','Moïse sauvé des eaux','Music Hath Charms','Mustang Petes Love Affair','The Mystery of a Hansom Cab','Mystic Manipulations','Nell Gwynn the Orange Girl','The New Church Carpet','Bar Zs New Cook','The New Cook','Bar Zs New Cook','The New Dress','The New Manager','A Noble Heart','The ONeill','The Irish Rebel','The ONeill','Oedipus Rex','The Old Confectioners Mistake','Oliver Cromwell','On the Brink','On the Deserts Edge','Only in the Way','Out from the Shadow','The Outlaw Samaritan','The Outlaw and the Child','The Outlaw Deputy','Over the Garden Wall','Over the Hills','A Pals Oath','Par habitude','Paradise Lost','Pasiones de una princesa egipcia','The Passions of an Egyptian Princess','The Passions of an Egyptian Princess','The Peasants and the Fairy','Picciola; or, The Prison Flower','A Flor do Prisioneiro','Picciola; or, The Prison Flower','The Pied Piper of Hamelin','The Pirates of 1920','The Poisoned Flume','The Politicians Dream','Politikerens Drøm','The Politicians Dream','The Poor Sick Men','The Power of Good','The Power of Love','The Price of a Man','The Priests Burden','The Primal Call','Priscillas Engagement Kiss','Priscillas Engagement Ring','Priscillas Engagement Ring','The Convicts Song','????? ???????????','The Prisoners Song','Pesnya katorzhanina','Das Lied des Zuchthäuslers','La canzone del forzato','La chanson du forçat','The Convicts Song','The Professor and the New Hat','The Profligate','Les aventures dun petit homme','Pulgarcito','Pulgarcito','The Punchers New Love','The Question Mark','Railroad Raiders of 62','A Race with Death','The Ranchmans Son','The Ranchmans Son','Rattlesnakes and Gunpowder','The Rebels Daughter','Rédemption','Rédemption','John Farleys Redemption','The Reform Candidate','The Reporter','The Revenue Man and the Girl','Richard III','Richard III','?????? 3','Un chiaro di luna ai tempi di Richelieu','Un clair de lune sous Richelieu','Un clair de lune sous Richelieu','The Rise and Fall of Weary Willie','The Romance on Bar O','A Romance of the Rio Grande','The Romantic Story of Margaret Catchpole','The Romantic Story of Margaret Catchpole','Queen of the Smugglers','A Romany Tragedy','The Rosary','The Two Devotions','The Rosary','The Rose of Kentucky','The Story of the Rose','The Roses Story','The Roses Story','The Ruling Passion','Le sacrifice dAbraham','Le sacrifice dAbraham','Abrahams Sacrifice','Sansón y Dalila','Samson and Delilah','Samson and Delilah','Saved from Herself','Saved from Herself','Salvo por Si Mesmo','Saved from Himself','Saved from Himself','Salvo por Si Mesmo','The Scarlet Letter','The Schoolmaster of Mariposa','Science','Second Sight','The Sentinel Asleep','She','The Sheriffs Brother','The Sheriffs Chum','The Sheriffs Decision','Los siete niños de Écija o Los bandidos de Sierra Morena','The Silent Tongue','The Silken Thread','Simpkins Dream of a Holiday','Sir Percy and the Punchers','Le siège de Calais','Le siège de Calais','The Siege of Calais','The Skating Bug','The Sky Pilot','Skæbnebæltet','The Smile of a Child','The Sorrowful Example','Der schwarze Traum','Svarta drömmen','A fekete álom','The Black Dream','Synkkä unelma','O sonho negro','?????? ???','Musta uni','Czarne marzenie','Den sorte drøm','Den svarta drömmen','The Spanish Gypsy','Spike Shannons Last Fight','Sport Hípico','Amor de Índio','The Squaws Love','The Squaws Love','The Stage Drivers Daughter','A Stage Romance','The Stampede','The Star Spangled Banner','The Star Spangled Banner','United States History Series #1: The Star Spangled Banner','The Stolen Dog','The Story of the Indian Ledge','The Story of Indian Ledge','The Story of the Indian Ledge','The Strike at the Little Jonny Mine','The Stuff Heroes Are Made Of','The Stuff That Dreams Are Made Of','The Subduing of Mrs. Nag','Sunshine Through the Dark','The Surgeons Temptation','Swank and the Remedy','Sweet Memories','Sweet Memories','Sweetheart Days','Sweet Nell of Old Drury','Sweet Nell of Old Drury','Nell Gwynne','Nell Gwynne','Nell Gwyn','The Switchmans Tower','Swords and Hearts','Swords and Hearts','Espadas y corazones','Espadas e Corações','Isien pahat teot','Die Sünden der Väter','Regina','Fædrenes synd','Fädrens synder','Die Sünden der Väter','Fädernas synder','The Devils Assistant','Die Sünde ihrer Väter','Asta Nielsen-Neue Serie. VII','Az apák b?nei','Isien synnit','Isäin pahat teot','Historia en dos ciudades','A Tale of Two Cities','A Tale of Two Cities','Een episode uit de Fransche revolutie','Engeland en Frankrijk','In Londen en Parijs','Un drame damour sous la Révolution','Bastillens Offer','La Bastille','Két város','Från franska revolutionen eller I döden för sin kärlek','Tusschen twee millioenen-steden','Tarragona monumental','Teaching Dad to Like Her','Telemachus','The Tell-Tale Knife','The Telltale Knife','The Telltale Knife','Temblor de 1911 en México','A Terrible Discovery','That Winsome Winnie Smile','Their First Quarrel','Their First Misunderstanding','Their First Misunderstanding','The Thief and the Girl','Three Million Dollars','The Three Musketeers: Part 2','The Three Musketeers: Part 2','Tri musketara, drugi deo','Three Sisters','Through Darkened Vales','Through His Wifes Picture','The Thumb Print','A Thwarted Vengeance','The Tomboy','La Tosca','The Toss of a Coin','The Totem Mark','Trading His Mother','The Trail of Books','The Tribes Penalty','Trilby and Svengali','Troublesome Secretaries','Secretários Galantes','The Troublesome Secretaries; or, How Betty Outwitted Her Father','Troublesome Secretaries','A True Westerner','Two Can Play at the Same Game','The Two Chorus Girls','Two Christmas Hampers','The Two Fugitives','Two Officers','Kate Claxtons Two Orphans','The Two Orphans','The Two Orphans','The Two Paths','The Two Reformations','The Two Sides','The Two-Gun Man','Uncle Hirams List','Uncles Picnic','Under the Stars and Bars','Jo tykkere, jo bedre','Under forvandlingens lov','Under forvandlingens lov','An Unknown Language','The Unveiling','An Unwilling Cowboy','Van Bibbers Experiment','Temptations of a Great City','Temptations of the Great City','Suuren kaupungin yöelämän seuraukset eli Valkoinen orjakauppa III','Les Tentations dune Grande Ville','Ved Fængslets Port','Foran Fængslets Port','A börtön kapujában','Följderna af nattlifvet i storstad eller Den hvita slafhandeln III','Ved Fængslets Port','Pettäjätär','?????????????','The Traitress','The Treacherous Woman','Den store elskov','Förräderskan','Kavaltajatar','Die Verräterin','Die Verräterin','Vicio y virtud','A Victim of Circumstances','La vie telle quelle est','La vie telle quelle est','Life as It Is','The Voice of the Child','Was He a Coward?','A Western Girls Sacrifice','Western Hearts','Corações do Oeste','Western Hearts','A Western Redemption','What Shall We Do with Our Old?','??? ??? ?????? ? ?????? ??????????','What Shall We Do with Our Old?','What a Woman Can Do','The Wheels of Justice','When Love and Honor Called','When Two Hearts Are Won','When a Man Loves','When a Man Loves','Naar Manden elsker','When a Mans Married','When a Mans Married His Trouble Begins','When a Mans Married His Trouble Begins','When the Cats Away','The White Medicine Man','The White Red Man','The White Rose of the Wilds','The White Rose of the Wilds','A Story of the West','Why He Gave Up','The Winds of Fate','The Wizard and the Brigands','A Woman Scorned','The Woodcutters Romance','A Wreath of Orange Blossoms','The Yiddisher Cowboy','Zwei Frauen','Il fulminato','Lélectrocuté','Lélectrocuté','An Actors Romance','Adam and Eve','The Adventure of the Italian Model','The Adventure of the Retired Army Colonel','The Adventures of Lieutenant Petrosino','The Life and Death of Lieutenant Petrosino','The Adventures of Lieutenant Petrosino','Agaton och Fina','The Cowboy Socialist','The Agitator','The Agitator','The Alaska-Siberian Expedition','The Alaska-Siberian Expedition','The Carnegie Museum Alaska-Siberian Expedition','The Alcaldes Conspiracy','Alias Billy Sargent','Alkali Ike Bests Broncho Billy','Alkali Ike Plays the Devil','Alkali Ike Stung!','Alkali Ikes Boarding House','Alkali Ikes Close Shave','Alkali Ikes Love Affair','Alkali Ikes Motorcycle','Alkali Ikes Pants','All for Her','All for a Girl','Alt for Norge','On the Altar of Death','The Altar of Death','The Altar of Death','Los amantes de Teruel','Ambitious Butler','The Ambitious Butler','Ambitious Butler','An American Invasion','Amor de bestia','Les amours de la reine Élisabeth','Erzsébet királyn?','Królowa Elzbieta','Queen Elizabeth','Drottning Elisabeth','La reine Élisabeth','But the Greatest of These Is Charity','Anfisa','??????','The Angel and the Stranded Troupe','The Animal Within','El aniversario del fallecimiento de la suegra de Enhart','El aniversario del fallecimiento de la suegra de Enhart','Anniversaire du décès de la belle-mère dEnhart','Anny - en gatepiges roman','Anny - Story of a Prostitute','Anny - en gatepiges roman','The Apache Renegade','The Arabs Bride','Onneton Jenny','A szegény Jenny','Die arme Jenny','Den olyckliga Jenny','Die arme Jenny','Proletarpigen','Pobre Jenny','Jenny parka','Poor Jenny','The Arrowmakers Daughter','The Arrowmakers Daughter','The Arrow Makers Daughter','As You Like It','As You Like It','Jak wam sie podoba','El asesinato de Canalejas','Asesinato y entierro de Canalejas','Asesinato y entierro de Don José Canalejas','Asesinato y entierro de Don José Canalejas','At Coney Island','At Coney Island','Cohen at Coney Island','At Cripple Creek','At It Again','At Scrogginses Corner','At the Point of the Sword','At Swords Points','At the Point of the Sword','Atop of the World in Motion','Beverly C. Dobbs Original Alaska-Siberian Motion Pictures','Atop of the World in Motion','Las aventuras del Pollo Palomeque','The Baby and the Stork','The Bachelor and the Baby','The Bachelors Waterloo','The Bachelors Waterloo: A Leap Year Story','The Bachelors Waterloo','Le bagnard','The Ball Player and the Bandit','La Barrera número 13','A Batalha','Battle in the Virginia Hills','Battle of Pottsburg Bridge','A Battle of Wits','A Squaws Strategy','The Battle of the Red Men','An Indian Maids Vengeance','The Battle of the Red Men','The Battleground','A Bear Escape','The Detectives','A Bear Escape','Une bête aux abois','A Beast at Bay','A Beast at Bay','The Sissy Cowboy','The Beating He Needed','The Beating He Needed','A gyönyör? Ljukanida','?????????? ????????','Przepiekna Lukianida','The Beautiful Leukanida','Prekrasnaya Lyukanida','Before the White Man Came','The Bell of Penance','Bellas Beaus','Bernáték kikocsiznak','Billy McGraths Love Letters','Billy and the Butler','Billys Burglar','Billys Stratagem','La ruse de Billy','Billys Stratagem','Black Sheep','Blind Love','Blinks and Jinks, Attorneys at Law','A Blot on the Scutcheon','The Boss of the Katy Mine','The Brave Hunter','A Brave Little Woman','Broncho Billys Heart','Broncho Billys Mexican Wife','Broncho Billy Outwitted','Broncho Billys Promise','Brothers','Browns Seance','Brutality','Brutalitás','Brutalitet','Brutality','The Bugler of Battery B','Bunny All at Sea','Bunny at the Derby','O Dilema do Assaltante','The Burglars Dilemma','The Burglars Dilemma','??????? ????','De val van Troje','Trojan kukistus','A Queda de Tróia','??????? ????','Pad Troje','The Fall of Troy','La chûte de Troie','La caida de Troya','La caduta di Troia','La caduta di Troia','Trojas Fald','The Fall of Troy','Trója eleste','Pád Tróje','Calamity Annes Ward','Calamity Annes Ward','Calamity Anne, Guardian','The Cap of Invisibility','Captain Barnacles Messmates','Captain Barnacles Messmates','Captain Barnacles Messmate','Wolsey bíboros','Cardinal Wolsey','Cardinal Wolsey','Carlota Angela','Carmen','Casey at the Bat','Castillo de Ostalric','Chains','A Change of Spirit','Charles IV','The Chiefs Blanket','A Childs Devotion','Børnenes Brøde','A Childs Remorse','A Childs Remorse','Children Who Labor','The Chorus Girl','Chumps','Chumps','Chumps: A Fairy Story for Overgrownups','Cleopatra','Cleopatra','?????????','Cleopatra: The Romance of a Woman and a Queen','Helen Gardner in Cleopatra','Cleopatra','Helen Gardner in Cleopatra','The Clod','United States History Series #9: The Close of the American Revolution','The Close of the American Revolution','The Close of the American Revolution','The Clowns Triumph','What Happened to Mary? Episode 6','A Clue to Her Parentage','A Clue to Her Parentage','Cohen Collects a Debt','The Colonels Escape','The Colonels Peril','The Colonels Son','The Colonels Ward','Christopher Columbus','The Coming of Columbus','The Coming of Columbus','Concurso Hípico no Porto','À la conquête du pôle','Die Entdeckung des Nordpols','Zdobycie bieguna','The Conquest of the Pole','? ????????? ??? ??????? ?????','Die Eroberung des Pols','?????????? ??????','Die Entdeckung des Nordpols','Alla conquista del polo','A Conquista do polo','Az Északi-sark meghódítása','A la conquista del polo','À la conquête du pôle','The Chamber of Horrors','Conscience','Conscience','La conspiration des drapeaux','The Convicts Parole','Counsel for the Defense','A Cowboys Stratagem','The Crime and the Criminal','The Crisis','A Cry for Help','The Cry of the Children','The Cry of the Children','???? ???????','The Cub Reporters Big Scoop','A Cure for Pokeritis','????????? ?? ??????','A Cure for Pokeritis','Curfew Shall Not Ring Tonight','Custers Last Raid','General Custers sidste Kamp','Custers Last Fight','Custers Last Fight','Cutting California Redwoods','The Dam Builder','The Dance at Silver Gulch','LInferno','Dantes Inferno','Helvetet','Linferno','Dantes Helvede','El infierno','Lenfer','Helvetti','A pokol','??','LInferno','A Dança dos Apaches','The Darling of the CSA','The Darling of the C.S.A.','The Darling of the CSA','A Dash Through the Clouds','A Daughters Sacrifice','The Deacons Troubles','Departure of a Grand Old Man','A nagy öreg futása','Ukhod velikogo startsa','???? ???????? ??????','The Deserter','A Desperate Lover','Diamond Cut Diamond','Do Men Love Women?','Don César de Bazan','Don Caesar de Bazan','Don Caesar de Bazan','A Double Reward','Dr. Jekyll et Mr. Hyde','Dr. Jekyll and Mr. Hyde','Dr Džekil i g. Hajd','?????? ??????? ? ?????? ????','Dr. Jekyll and Mr. Hyde','Dramatic Passion of Algabert and Elisberth of Rodembourg','La dramatique passion dAlgabert et dÉlisabeth de Rodembourg','La Légende des Chevaliers DAlgabert','De rampzalige liefde van Algabert en Elisabeth van Rodenburg','The Legend of the Knights of Algabert','Verschmähte Liebe','La dramatique passion dAlgabert et dÉlisabeth de Rodembourg','In Feudal Days','The Dream of a Motion Picture Director','The Dream of a Moving Picture Director','The Dream of a Moving Picture Director','The Driver of the Deadwood Coach','The Drummer Girl of Vicksburg','The Drummers Vacation','The Duel','The Duel','El duelo','The Dumb Wooer','The Dumb Wooing','The Dumb Wooing','The Last Performance','Dödshoppet från cirkuskupolen','Dödsritten under cirkuskupolen','The Last Performance','Dödsritten under cirkuskupolen','En Tragedie under Cirkuskuplen','Sous la coupole du cirque','The Death Ride Under the Big Top','Dødskysset','Den stora cirkusattraktionen eller Dödssprånget till häst från cirkuskupolen','Suuri sirkusvetovoima eli Kuolemanhyppy hevosen selkään sirkuksen katonrajasta','Det store clou','De doodsprong uit de nok van het circus','Dødsspring til hest fra cirkuskuplen','Suuri sirkusvetovoima eli Kuolemanhyppy hevosenselässä sirkuksen kupukatosta','De groote circus-attractie','Het grote circusdrama','The Great Circus Catastrophe','Dødsspring til hest fra cirkuskuplen','Dodsspring til hest fra circuskuplen','Early Days in the West','The Easter Bonnet','Eclipse de sol','De eed van Stephan Huller','Der Eid des Stephan Huller','Stephan Hullers Ed','Der Eid des Stephan Huller','An Elizabethan Romance','The Engagement Ring','The Engagement Ring','Forlovelsesringen','El anillo de compromiso','Max Linder englantilaisine ystävineen','Herzliches Einverständnis','Entente cordiale','Entente cordiale','Max et lentente cordiale','Max und sein Rivale','Max und sein Rivale','Max Linder och hans engelska vän Fragsen','Episódios da Terrível Explosão de Bombas no Porto','Catástrofe no Porto','Episódios da Terrível Explosão de Bombas no Porto','La eterna madre','The Eternal Mother','The Eternal Mother','Eva','When Honor Calls','Eva','Eva','Every Inch a Man','Excursión a San Lorenzo de Munt','The Eye That Never Sleeps','Fadren','The Faith Healer','The Fall of Montezuma','A Flirting Mixup','Cured','A Family Mixup','A Family Mixup','The Fatal Chocolate','Chocolate fatal','The Fatal Chocolate','Fates Interception','The Father','The Fear','Feathertop','The Female of the Species','??????? ?? ????????','The Female of the Species','A Feud in the Kentucky Hills','The Feudal Debt','The Fickle Spaniard','Fiesta colombófila en el Tibidabo','The Man with Wax Faces','??????? ??????','Figures de cire','Figures de cire','Le fils de Charles Quint','The First Violin','The Flirting Husband','The Flower Girls Romance','The Flying Circus','Den flygande cirkus','The Pride of the Circus','Lentävä sirkus','Der fliegende Cirkus','Den flyvende cirkus','Den flyvende cirkus','Nebbia','Fog','Fog','For Freedom of Cuba','For Her','For His Son','???? ????','For His Son','Pour son fils','For the Cause','For the Commonwealth','For the Honor of the Name','For the Honor of the Seventh','The Forest Rose','Fortunes of a Composer','Friends','??????','Friends','Amigos','Amigos','Le friquet','Från krubban till korset','De la crèche à la croix','?? ????? ?? ?????? ??? ????? ?? ????????','Del pesebre a la cruz','Jesus of Nazareth','From the Manger to the Cross; or, Jesus of Nazareth','The Life of Christ','From the Manger to the Cross; or, Jesus of Nazareth','From the Submerged','The Frontier Child','The Frontier Child','The Settlers Child','Le fumiste','The Furs','A Gamblers Villainy','The Gamblers','Il Segreto DellAciaio','Joaquin Goerthal y el Secreto del Acero','Joachim Goëthal et le secret de lacier','The Great Steel Secret','Le secret de lacier','Het geheim van het staal','Joachim Goethal and the Secret of Steel','The Secret of Steel','Geralds Butterfly','Heltens Lokomotiv','??????? ? ?? ???????','The Girl and Her Trust','The Girl and Her Trust','The Girl in the Caboose','The Girl in the Next Room','Kärlek och hat','Den glade løjtnant','Den glade løjtnant','Rakkaus ja viha','The God Within','The God of Gold','The Goddess of Sagebrush Gulch','The Godmother','Gold and Glitter','A Good Catch','The Governor','The Grandfather','Grannie','???????? ? ???????','A Formiga e o Gafanhoto','A szöcske és a hangya','Strekoza i muravey','The Grasshopper and the Ant','The Dragonfly and the Ant','Greater Wealth','The Green-Eyed Monster','A Grocery Clerks Romance','The Gypsy Flirt','Veselye stsenki iz zhizni zhivotnykh','??????? ?????? ?? ????? ????????','Happy Scenes from Animal Life','The Harbinger of Peace','Harbor Island','He Must Have a Wife','The Indian Massacre','The Heart of an Indian','The Heart of an Indian','The Indian Massacre','Heaven Avenges','Helens Marriage','Help! Help!','Et hemmeligt Giftermaal','A Ruined Life','Ett hemligt giftermål','A Secret Marriage','Ett hemligt giftermål','Ett hemligt giftermål eller Bekännelsen på dödsbädden','En moder','Hemmeligheden','Hemmeligheten','Hemmeligheden','Her Choice','Her Dressmakers Bills','Her Kid Sister','Her Own Money','Her Visitor','Heredity','Herod','John the Baptist','Herod','The Hieroglyphic','His Lesson','His Mothers Hope','His Mothers Picture','His Only Son','His Own Fault','His Secretary','His Wifes Stratagem','Hoffmeyers Legacy','The Holy City','Home Folks','The Honor of the Firm','For the Honor of the Firm','The Honor of the Firm','Hot Stuff','The House of Pride','How Father Accomplished His Work','How Jim Proposed','How a Horseshoe Upset a Happy Family','How a Mosquito Operates','How a Mosquito Operates','A szúnyog m?ködése','The Story of a Mosquito','Winsor McCay and His Jersey Skeeters','??? ????????? ?????','The Hungry Mosquito','Idas Christmas','Il y a des pieds au plafond','Il y a des pieds au plafond','Ci son dei piedi sul soffitto','The Illumination','In His Fathers Steps','In Swift Waters','In the Aisles of the Wild','In the Elemental World','In the North Woods','Inbad, the Count','An Indians Friendship','The Indian Raiders','Indian Romeo and Juliet','An Indian Summer','The Indian Uprising at Santa Fe','De industrieel van Pont Avesnes','El informante','The Informer','The Informer','The Inner Circle','Prison');
647    v_parental_rating_array parental_rating_array := parental_rating_array('G', 'PG', 'R', 'NC', 'NR');
648    v_origins_country_array origin_country_array := origin_country_array('Afghanistan','Albania','Algeria','Andorra','Angola','Antigua and Barbuda','Argentina','Armenia','Australia','Austria','Azerbaijan','The Bahamas','Bahrain','Bangladesh','Barbados','Belarus','Belgium','Belize','Benin','Bhutan','Bolivia','Bosnia and Herzegovina','Botswana','Brazil','Brunei','Bulgaria','Burkina Faso','Burundi','Cabo Verde','Cambodia','Cameroon','Canada','Central African Republic','Chad','Chile','China','Colombia','Comoros','Congo','Costa Rica','Croatia','Cuba','Cyprus','Czech Republic','Denmark','Djibouti','Dominica','Dominican Republic','East Timor','Ecuador','Egypt','El Salvador','Equatorial Guinea','Eritrea','Estonia','Eswatini','Ethiopia','Fiji','Finland','France','Gabon','The Gambia','Georgia','Germany','Ghana','Greece','Grenada','Guatemala','Guinea','Guinea-Bissau','Guyana','Haiti','Honduras','Hungary','Iceland','India','Indonesia','Iran','Iraq','Ireland','Israel','Italy','Jamaica','Japan','Jordan','Kazakhstan','Kenya','Kiribati','Korea, North','Korea, South','Kosovo','Kuwait','Kyrgyzstan','Laos','Latvia','Lebanon','Lesotho','Liberia','Libya','Liechtenstein','Lithuania','Luxembourg','Madagascar','Malawi','Malaysia','Maldives','Mali','Malta','Marshall Islands','Mauritania','Mauritius','Mexico','Micronesia','Moldova','Monaco','Mongolia','Montenegro','Morocco','Mozambique','Myanmar','Namibia','Nauru','Nepal','Netherlands','New Zealand','Nicaragua','Niger','Nigeria','North Macedonia','Norway','Oman','Pakistan','Palau','Panama','Papua New Guinea','Paraguay','Peru','Philippines','Poland','Portugal','Qatar','Romania','Russia','Rwanda','Saint Kitts and Nevis','Saint Lucia','Saint Vincent and the Grenadines','Samoa','San Marino','Sao Tome and Principe','Saudi Arabia','Senegal','Serbia','Seychelles','Sierra Leone','Singapore','Slovakia','Slovenia','Solomon Islands','Somalia','South Africa','Spain','Sri Lanka','Sudan','Sudan, South','Suriname','Sweden','Switzerland','Syria','Taiwan','Tajikistan','Tanzania','Thailand','Togo','Tonga','Trinidad and Tobago','Tunisia','Turkey','Turkmenistan','Tuvalu','Uganda','Ukraine','United Arab Emirates','United Kingdom','United States','Uruguay','Uzbekistan','Vanuatu','Vatican City','Venezuela','Vietnam','Yemen','Zambia','Zimbabwe');
649    v_language_array language_array := language_array('AF','AX','AL','DZ','AS','AD','AO','AI','AQ','AG','AR','AM','AW','AU','AT','AZ','BH','BS','BD','BB','BY','BE','BZ','BJ','BM','BT','BO','BQ','BA','BW','BV','BR','IO','BN','BG','BF','BI','KH','CM','CA','CV','KY','CF','TD','CL','CN','CX','CC','CO','KM','CG','CD','CK','CR','CI','HR','CU','CW','CY','CZ','DK','DJ','DM','DO','EC','EG','SV','GQ','ER','EE','ET','FK','FO','FJ','FI','FR','GF','PF','TF','GA','GM','GE','DE','GH','GI','GR','GL','GD','GP','GU','GT','GG','GN','GW','GY','HT','HM','VA','HN','HK','HU','IS','IN','ID','IR','IQ','IE','IM','IL','IT','JM','JP','JE','JO','KZ','KE','KI','KP','KR','KW','KG','LA','LV','LB','LS','LR','LY','LI','LT','LU','MO','MK','MG','MW','MY','MV','ML','MT','MH','MQ','MR','MU','YT','MX','FM','MD','MC','MN','ME','MS','MA','MZ','MM','NA','NR','NP','NL','NC','NZ','NI','NE','NG','NU','NF','MP','NO','OM','PK','PW','PS','PA','PG','PY','PE','PH','PN','PL','PT','PR','QA','RE','RO','RU','RW','BL','SH','KN','LC','MF','PM','VC','WS','SM','ST','SA','SN','RS','SC','SL','SG','SX','SK','SI','SB','SO','ZA','GS','SS','ES','LK','SD','SR','SJ','SZ','SE','CH','SY','TW','TJ','TZ','TH','TL','TG','TK','TO','TT','TN','TR','TM','TC','TV','UG','UA','AE','GB','US','UM','UY','UZ','VU','VE','VN','VG','VI','WF','EH','YE','ZM','ZW');
650    
651    v_title movies.title%TYPE; -- VARCHAR2(150)
652    v_image movies.image%TYPE; -- BLOB
653    v_release_date movies.release_date%TYPE; -- DATE
654    v_duration movies.duration%TYPE; -- INTERVAL DAY TO SECOND
655    v_parental_rating movies.parental_rating%TYPE; -- VARCHAR2(2)
656    v_origin_country movies.origin_country%TYPE; -- VARCHAR2(50)
657    v_language movies.language%TYPE; -- VARCHAR2(2)
658    v_budget movies.budget%TYPE; -- NUMBER
659
660BEGIN
661    FOR v_index IN 1..p_total_movies LOOP
662        v_title := v_title_array(DBMS_RANDOM.VALUE(1, v_title_array.COUNT));
663        
664        IF (DBMS_RANDOM.VALUE() < 0.25) THEN
665            v_title := v_title || ' ' || TRUNC(DBMS_RANDOM.value(1, 10));
666        END IF;
667        
668        v_image := EMPTY_BLOB();
669        
670        v_release_date := generate_random_date(TO_DATE('01-01-1900', 'dd-mm-yyyy'), CURRENT_DATE);
671        
672        v_duration := generate_random_movie_duration();
673        
674        v_parental_rating := v_parental_rating_array(DBMS_RANDOM.VALUE(1, v_parental_rating_array.COUNT));
675        
676        v_origin_country := v_origins_country_array(DBMS_RANDOM.VALUE(1, v_origins_country_array.COUNT));
677        
678        v_language := v_language_array(DBMS_RANDOM.VALUE(1, v_language_array.COUNT));
679        
680        v_budget := TRUNC(DBMS_RANDOM.VALUE(100, 400000000),1);
681        
682        INSERT INTO movies (title, image, release_date, duration, parental_rating, origin_country, language, budget) 
683        VALUES (v_title, v_image, v_release_date, v_duration, v_parental_rating, v_origin_country, v_language, v_budget);
684    END LOOP;
685END populate_movies_table;
686/
687CREATE OR REPLACE PROCEDURE populate_people_table(p_total_people IN NUMBER) AS
688    TYPE first_name_array IS VARRAY(5000) OF VARCHAR2(100);
689    TYPE origin_country_array IS VARRAY(200) OF VARCHAR(50);
690    
691    v_first_name people.first_name%TYPE; --varchar2(100)
692    v_last_name people.last_name%TYPE; --CHAR(100)
693    v_birth_date people.birth_date%TYPE; --DATE
694    v_description people.description%TYPE; --VARCHAR2(1000)
695    v_origin_country people.origin_country%TYPE; --VARCHAR2(50)
696
697    v_first_names first_name_array := first_name_array('Aaren','Aarika','Abagael','Abagail','Abbe','Abbey','Abbi','Abbie','Abby','Abbye','Abigael','Abigail','Abigale','Abra','Ada','Adah','Adaline','Adan','Adara','Adda','Addi','Addia','Addie','Addy','Adel','Adela','Adelaida','Adelaide','Adele','Adelheid','Adelice','Adelina','Adelind','Adeline','Adella','Adelle','Adena','Adey','Adi','Adiana','Adina','Adora','Adore','Adoree','Adorne','Adrea','Adria','Adriaens','Adrian','Adriana','Adriane','Adrianna','Adrianne','Adriena','Adrienne','Aeriel','Aeriela','Aeriell','Afton','Ag','Agace','Agata','Agatha','Agathe','Aggi','Aggie','Aggy','Agna','Agnella','Agnes','Agnese','Agnesse','Agneta','Agnola','Agretha','Aida','Aidan','Aigneis','Aila','Aile','Ailee','Aileen','Ailene','Ailey','Aili','Ailina','Ailis','Ailsun','Ailyn','Aime','Aimee','Aimil','Aindrea','Ainslee','Ainsley','Ainslie','Ajay','Alaine','Alameda','Alana','Alanah','Alane','Alanna','Alayne','Alberta','Albertina','Albertine','Albina','Alecia','Aleda','Aleece','Aleen','Alejandra','Alejandrina','Alena','Alene','Alessandra','Aleta','Alethea','Alex','Alexa','Alexandra','Alexandrina','Alexi','Alexia','Alexina','Alexine','Alexis','Alfi','Alfie','Alfreda','Alfy','Ali','Alia','Alica','Alice','Alicea','Alicia','Alida','Alidia','Alie','Alika','Alikee','Alina','Aline','Alis','Alisa','Alisha','Alison','Alissa','Alisun','Alix','Aliza','Alla','Alleen','Allegra','Allene','Alli','Allianora','Allie','Allina','Allis','Allison','Allissa','Allix','Allsun','Allx','Ally','Allyce','Allyn','Allys','Allyson','Alma','Almeda','Almeria','Almeta','Almira','Almire','Aloise','Aloisia','Aloysia','Alta','Althea','Alvera','Alverta','Alvina','Alvinia','Alvira','Alyce','Alyda','Alys','Alysa','Alyse','Alysia','Alyson','Alyss','Alyssa','Amabel','Amabelle','Amalea','Amalee','Amaleta','Amalia','Amalie','Amalita','Amalle','Amanda','Amandi','Amandie','Amandy','Amara','Amargo','Amata','Amber','Amberly','Ambur','Ame','Amelia','Amelie','Amelina','Ameline','Amelita','Ami','Amie','Amii','Amil','Amitie','Amity','Ammamaria','Amy','Amye','Ana','Anabal','Anabel','Anabella','Anabelle','Analiese','Analise','Anallese','Anallise','Anastasia','Anastasie','Anastassia','Anatola','Andee','Andeee','Anderea','Andi','Andie','Andra','Andrea','Andreana','Andree','Andrei','Andria','Andriana','Andriette','Andromache','Andy','Anestassia','Anet','Anett','Anetta','Anette','Ange','Angel','Angela','Angele','Angelia','Angelica','Angelika','Angelina','Angeline','Angelique','Angelita','Angelle','Angie','Angil','Angy','Ania','Anica','Anissa','Anita','Anitra','Anjanette','Anjela','Ann','Ann-Marie','Anna','Anna-Diana','Anna-Diane','Anna-Maria','Annabal','Annabel','Annabela','Annabell','Annabella','Annabelle','Annadiana','Annadiane','Annalee','Annaliese','Annalise','Annamaria','Annamarie','Anne','Anne-Corinne','Anne-Marie','Annecorinne','Anneliese','Annelise','Annemarie','Annetta','Annette','Anni','Annice','Annie','Annis','Annissa','Annmaria','Annmarie','Annnora','Annora','Anny','Anselma','Ansley','Anstice','Anthe','Anthea','Anthia','Anthiathia','Antoinette','Antonella','Antonetta','Antonia','Antonie','Antonietta','Antonina','Anya','Appolonia','April','Aprilette','Ara','Arabel','Arabela','Arabele','Arabella','Arabelle','Arda','Ardath','Ardeen','Ardelia','Ardelis','Ardella','Ardelle','Arden','Ardene','Ardenia','Ardine','Ardis','Ardisj','Ardith','Ardra','Ardyce','Ardys','Ardyth','Aretha','Ariadne','Ariana','Aridatha','Ariel','Ariela','Ariella','Arielle','Arlana','Arlee','Arleen','Arlen','Arlena','Arlene','Arleta','Arlette','Arleyne','Arlie','Arliene','Arlina','Arlinda','Arline','Arluene','Arly','Arlyn','Arlyne','Aryn','Ashely','Ashia','Ashien','Ashil','Ashla','Ashlan','Ashlee','Ashleigh','Ashlen','Ashley','Ashli','Ashlie','Ashly','Asia','Astra','Astrid','Astrix','Atalanta','Athena','Athene','Atlanta','Atlante','Auberta','Aubine','Aubree','Aubrette','Aubrey','Aubrie','Aubry','Audi','Audie','Audra','Audre','Audrey','Audrie','Audry','Audrye','Audy','Augusta','Auguste','Augustina','Augustine','Aundrea','Aura','Aurea','Aurel','Aurelea','Aurelia','Aurelie','Auria','Aurie','Aurilia','Aurlie','Auroora','Aurora','Aurore','Austin','Austina','Austine','Ava','Aveline','Averil','Averyl','Avie','Avis','Aviva','Avivah','Avril','Avrit','Ayn','Bab','Babara','Babb','Babbette','Babbie','Babette','Babita','Babs','Bambi','Bambie','Bamby','Barb','Barbabra','Barbara','Barbara-Anne','Barbaraanne','Barbe','Barbee','Barbette','Barbey','Barbi','Barbie','Barbra','Barby','Bari','Barrie','Barry','Basia','Bathsheba','Batsheva','Bea','Beatrice','Beatrisa','Beatrix','Beatriz','Bebe','Becca','Becka','Becki','Beckie','Becky','Bee','Beilul','Beitris','Bekki','Bel','Belia','Belicia','Belinda','Belita','Bell','Bella','Bellanca','Belle','Bellina','Belva','Belvia','Bendite','Benedetta','Benedicta','Benedikta','Benetta','Benita','Benni','Bennie','Benny','Benoite','Berenice','Beret','Berget','Berna','Bernadene','Bernadette','Bernadina','Bernadine','Bernardina','Bernardine','Bernelle','Bernete','Bernetta','Bernette','Berni','Bernice','Bernie','Bernita','Berny','Berri','Berrie','Berry','Bert','Berta','Berte','Bertha','Berthe','Berti','Bertie','Bertina','Bertine','Berty','Beryl','Beryle','Bess','Bessie','Bessy','Beth','Bethanne','Bethany','Bethena','Bethina','Betsey','Betsy','Betta','Bette','Bette-Ann','Betteann','Betteanne','Betti','Bettina','Bettine','Betty','Bettye','Beulah','Bev','Beverie','Beverlee','Beverley','Beverlie','Beverly','Bevvy','Bianca','Bianka','Bibbie','Bibby','Bibbye','Bibi','Biddie','Biddy','Bidget','Bili','Bill','Billi','Billie','Billy','Billye','Binni','Binnie','Binny','Bird','Birdie','Birgit','Birgitta','Blair','Blaire','Blake','Blakelee','Blakeley','Blanca','Blanch','Blancha','Blanche','Blinni','Blinnie','Blinny','Bliss','Blisse','Blithe','Blondell','Blondelle','Blondie','Blondy','Blythe','Bobbe','Bobbee','Bobbette','Bobbi','Bobbie','Bobby','Bobbye','Bobette','Bobina','Bobine','Bobinette','Bonita','Bonnee','Bonni','Bonnibelle','Bonnie','Bonny','Brana','Brandais','Brande','Brandea','Brandi','Brandice','Brandie','Brandise','Brandy','Breanne','Brear','Bree','Breena','Bren','Brena','Brenda','Brenn','Brenna','Brett','Bria','Briana','Brianna','Brianne','Bride','Bridget','Bridgette','Bridie','Brier','Brietta','Brigid','Brigida','Brigit','Brigitta','Brigitte','Brina','Briney','Brinn','Brinna','Briny','Brit','Brita','Britney','Britni','Britt','Britta','Brittan','Brittaney','Brittani','Brittany','Britte','Britteny','Brittne','Brittney','Brittni','Brook','Brooke','Brooks','Brunhilda','Brunhilde','Bryana','Bryn','Bryna','Brynn','Brynna','Brynne','Buffy','Bunni','Bunnie','Bunny','Cacilia','Cacilie','Cahra','Cairistiona','Caitlin','Caitrin','Cal','Calida','Calla','Calley','Calli','Callida','Callie','Cally','Calypso','Cam','Camala','Camel','Camella','Camellia','Cami','Camila','Camile','Camilla','Camille','Cammi','Cammie','Cammy','Candace','Candi','Candice','Candida','Candide','Candie','Candis','Candra','Candy','Caprice','Cara','Caralie','Caren','Carena','Caresa','Caressa','Caresse','Carey','Cari','Caria','Carie','Caril','Carilyn','Carin','Carina','Carine','Cariotta','Carissa','Carita','Caritta','Carla','Carlee','Carleen','Carlen','Carlene','Carley','Carlie','Carlin','Carlina','Carline','Carlita','Carlota','Carlotta','Carly','Carlye','Carlyn','Carlynn','Carlynne','Carma','Carmel','Carmela','Carmelia','Carmelina','Carmelita','Carmella','Carmelle','Carmen','Carmencita','Carmina','Carmine','Carmita','Carmon','Caro','Carol','Carol-Jean','Carola','Carolan','Carolann','Carole','Carolee','Carolin','Carolina','Caroline','Caroljean','Carolyn','Carolyne','Carolynn','Caron','Carree','Carri','Carrie','Carrissa','Carroll','Carry','Cary','Caryl','Caryn','Casandra','Casey','Casi','Casie','Cass','Cassandra','Cassandre','Cassandry','Cassaundra','Cassey','Cassi','Cassie','Cassondra','Cassy','Catarina','Cate','Caterina','Catha','Catharina','Catharine','Cathe','Cathee','Catherin','Catherina','Catherine','Cathi','Cathie','Cathleen','Cathlene','Cathrin','Cathrine','Cathryn','Cathy','Cathyleen','Cati','Catie','Catina','Catlaina','Catlee','Catlin','Catrina','Catriona','Caty','Caye','Cayla','Cecelia','Cecil','Cecile','Ceciley','Cecilia','Cecilla','Cecily','Ceil','Cele','Celene','Celesta','Celeste','Celestia','Celestina','Celestine','Celestyn','Celestyna','Celia','Celie','Celina','Celinda','Celine','Celinka','Celisse','Celka','Celle','Cesya','Chad','Chanda','Chandal','Chandra','Channa','Chantal','Chantalle','Charil','Charin','Charis','Charissa','Charisse','Charita','Charity','Charla','Charlean','Charleen','Charlena','Charlene','Charline','Charlot','Charlotta','Charlotte','Charmain','Charmaine','Charmane','Charmian','Charmine','Charmion','Charo','Charyl','Chastity','Chelsae','Chelsea','Chelsey','Chelsie','Chelsy','Cher','Chere','Cherey','Cheri','Cherianne','Cherice','Cherida','Cherie','Cherilyn','Cherilynn','Cherin','Cherise','Cherish','Cherlyn','Cherri','Cherrita','Cherry','Chery','Cherye','Cheryl','Cheslie','Chiarra','Chickie','Chicky','Chiquia','Chiquita','Chlo','Chloe','Chloette','Chloris','Chris','Chrissie','Chrissy','Christa','Christabel','Christabella','Christal','Christalle','Christan','Christean','Christel','Christen','Christi','Christian','Christiana','Christiane','Christie','Christin','Christina','Christine','Christy','Christye','Christyna','Chrysa','Chrysler','Chrystal','Chryste','Chrystel','Cicely','Cicily','Ciel','Cilka','Cinda','Cindee','Cindelyn','Cinderella','Cindi','Cindie','Cindra','Cindy','Cinnamon','Cissiee','Cissy','Clair','Claire','Clara','Clarabelle','Clare','Claresta','Clareta','Claretta','Clarette','Clarey','Clari','Claribel','Clarice','Clarie','Clarinda','Clarine','Clarissa','Clarisse','Clarita','Clary','Claude','Claudelle','Claudetta','Claudette','Claudia','Claudie','Claudina','Claudine','Clea','Clem','Clemence','Clementia','Clementina','Clementine','Clemmie','Clemmy','Cleo','Cleopatra','Clerissa','Clio','Clo','Cloe','Cloris','Clotilda','Clovis','Codee','Codi','Codie','Cody','Coleen','Colene','Coletta','Colette','Colleen','Collen','Collete','Collette','Collie','Colline','Colly','Con','Concettina','Conchita','Concordia','Conni','Connie','Conny','Consolata','Constance','Constancia','Constancy','Constanta','Constantia','Constantina','Constantine','Consuela','Consuelo','Cookie','Cora','Corabel','Corabella','Corabelle','Coral','Coralie','Coraline','Coralyn','Cordelia','Cordelie','Cordey','Cordi','Cordie','Cordula','Cordy','Coreen','Corella','Corenda','Corene','Coretta','Corette','Corey','Cori','Corie','Corilla','Corina','Corine','Corinna','Corinne','Coriss','Corissa','Corliss','Corly','Cornela','Cornelia','Cornelle','Cornie','Corny','Correna','Correy','Corri','Corrianne','Corrie','Corrina','Corrine','Corrinne','Corry','Cortney','Cory','Cosetta','Cosette','Costanza','Courtenay','Courtnay','Courtney','Crin','Cris','Crissie','Crissy','Crista','Cristabel','Cristal','Cristen','Cristi','Cristie','Cristin','Cristina','Cristine','Cristionna','Cristy','Crysta','Crystal','Crystie','Cthrine','Cyb','Cybil','Cybill','Cymbre','Cynde','Cyndi','Cyndia','Cyndie','Cyndy','Cynthea','Cynthia','Cynthie','Cynthy','Dacey','Dacia','Dacie','Dacy','Dael','Daffi','Daffie','Daffy','Dagmar','Dahlia','Daile','Daisey','Daisi','Daisie','Daisy','Dale','Dalenna','Dalia','Dalila','Dallas','Daloris','Damara','Damaris','Damita','Dana','Danell','Danella','Danette','Dani','Dania','Danica','Danice','Daniela','Daniele','Daniella','Danielle','Danika','Danila','Danit','Danita','Danna','Danni','Dannie','Danny','Dannye','Danya','Danyelle','Danyette','Daphene','Daphna','Daphne','Dara','Darb','Darbie','Darby','Darcee','Darcey','Darci','Darcie','Darcy','Darda','Dareen','Darell','Darelle','Dari','Daria','Darice','Darla','Darleen','Darlene','Darline','Darlleen','Daron','Darrelle','Darryl','Darsey','Darsie','Darya','Daryl','Daryn','Dasha','Dasi','Dasie','Dasya','Datha','Daune','Daveen','Daveta','Davida','Davina','Davine','Davita','Dawn','Dawna','Dayle','Dayna','Ddene','De','Deana','Deane','Deanna','Deanne','Deb','Debbi','Debbie','Debby','Debee','Debera','Debi','Debor','Debora','Deborah','Debra','Dede','Dedie','Dedra','Dee','Dee Dee','Deeann','Deeanne','Deedee','Deena','Deerdre','Deeyn','Dehlia','Deidre','Deina','Deirdre','Del','Dela','Delcina','Delcine','Delia','Delila','Delilah','Delinda','Dell','Della','Delly','Delora','Delores','Deloria','Deloris','Delphine','Delphinia','Demeter','Demetra','Demetria','Demetris','Dena','Deni','Denice','Denise','Denna','Denni','Dennie','Denny','Deny','Denys','Denyse','Deonne','Desdemona','Desirae','Desiree','Desiri','Deva','Devan','Devi','Devin','Devina','Devinne','Devon','Devondra','Devonna','Devonne','Devora','Di','Diahann','Dian','Diana','Diandra','Diane','Diane-Marie','Dianemarie','Diann','Dianna','Dianne','Diannne','Didi','Dido','Diena','Dierdre','Dina','Dinah','Dinnie','Dinny','Dion','Dione','Dionis','Dionne','Dita','Dix','Dixie','Dniren','Dode','Dodi','Dodie','Dody','Doe','Doll','Dolley','Dolli','Dollie','Dolly','Dolores','Dolorita','Doloritas','Domeniga','Dominga','Domini','Dominica','Dominique','Dona','Donella','Donelle','Donetta','Donia','Donica','Donielle','Donna','Donnamarie','Donni','Donnie','Donny','Dora','Doralia','Doralin','Doralyn','Doralynn','Doralynne','Dore','Doreen','Dorelia','Dorella','Dorelle','Dorena','Dorene','Doretta','Dorette','Dorey','Dori','Doria','Dorian','Dorice','Dorie','Dorine','Doris','Dorisa','Dorise','Dorita','Doro','Dorolice','Dorolisa','Dorotea','Doroteya','Dorothea','Dorothee','Dorothy','Dorree','Dorri','Dorrie','Dorris','Dorry','Dorthea','Dorthy','Dory','Dosi','Dot','Doti','Dotti','Dottie','Dotty','Dre','Dreddy','Dredi','Drona','Dru','Druci','Drucie','Drucill','Drucy','Drusi','Drusie','Drusilla','Drusy','Dulce','Dulcea','Dulci','Dulcia','Dulciana','Dulcie','Dulcine','Dulcinea','Dulcy','Dulsea','Dusty','Dyan','Dyana','Dyane','Dyann','Dyanna','Dyanne','Dyna','Dynah','Eachelle','Eada','Eadie','Eadith','Ealasaid','Eartha','Easter','Eba','Ebba','Ebonee','Ebony','Eda','Eddi','Eddie','Eddy','Ede','Edee','Edeline','Eden','Edi','Edie','Edin','Edita','Edith','Editha','Edithe','Ediva','Edna','Edwina','Edy','Edyth','Edythe','Effie','Eileen','Eilis','Eimile','Eirena','Ekaterina','Elaina','Elaine','Elana','Elane','Elayne','Elberta','Elbertina','Elbertine','Eleanor','Eleanora','Eleanore','Electra','Eleen','Elena','Elene','Eleni','Elenore','Eleonora','Eleonore','Elfie','Elfreda','Elfrida','Elfrieda','Elga','Elianora','Elianore','Elicia','Elie','Elinor','Elinore','Elisa','Elisabet','Elisabeth','Elisabetta','Elise','Elisha','Elissa','Elita','Eliza','Elizabet','Elizabeth','Elka','Elke','Ella','Elladine','Elle','Ellen','Ellene','Ellette','Elli','Ellie','Ellissa','Elly','Ellyn','Ellynn','Elmira','Elna','Elnora','Elnore','Eloisa','Eloise','Elonore','Elora','Elsa','Elsbeth','Else','Elset','Elsey','Elsi','Elsie','Elsinore','Elspeth','Elsy','Elva','Elvera','Elvina','Elvira','Elwira','Elyn','Elyse','Elysee','Elysha','Elysia','Elyssa','Em','Ema','Emalee','Emalia','Emelda','Emelia','Emelina','Emeline','Emelita','Emelyne','Emera','Emilee','Emili','Emilia','Emilie','Emiline','Emily','Emlyn','Emlynn','Emlynne','Emma','Emmalee','Emmaline','Emmalyn','Emmalynn','Emmalynne','Emmeline','Emmey','Emmi','Emmie','Emmy','Emmye','Emogene','Emyle','Emylee','Engracia','Enid','Enrica','Enrichetta','Enrika','Enriqueta','Eolanda','Eolande','Eran','Erda','Erena','Erica','Ericha','Ericka','Erika','Erin','Erina','Erinn','Erinna','Erma','Ermengarde','Ermentrude','Ermina','Erminia','Erminie','Erna','Ernaline','Ernesta','Ernestine','Ertha','Eryn','Esma','Esmaria','Esme','Esmeralda','Essa','Essie','Essy','Esta','Estel','Estele','Estell','Estella','Estelle','Ester','Esther','Estrella','Estrellita','Ethel','Ethelda','Ethelin','Ethelind','Etheline','Ethelyn','Ethyl','Etta','Etti','Ettie','Etty','Eudora','Eugenia','Eugenie','Eugine','Eula','Eulalie','Eunice','Euphemia','Eustacia','Eva','Evaleen','Evangelia','Evangelin','Evangelina','Evangeline','Evania','Evanne','Eve','Eveleen','Evelina','Eveline','Evelyn','Evey','Evie','Evita','Evonne','Evvie','Evvy','Evy','Eyde','Eydie','Ezmeralda','Fae','Faina','Faith','Fallon','Fan','Fanchette','Fanchon','Fancie','Fancy','Fanechka','Fania','Fanni','Fannie','Fanny','Fanya','Fara','Farah','Farand','Farica','Farra','Farrah','Farrand','Faun','Faunie','Faustina','Faustine','Fawn','Fawne','Fawnia','Fay','Faydra','Faye','Fayette','Fayina','Fayre','Fayth','Faythe','Federica','Fedora','Felecia','Felicdad','Felice','Felicia','Felicity','Felicle','Felipa','Felisha','Felita','Feliza','Fenelia','Feodora','Ferdinanda','Ferdinande','Fern','Fernanda','Fernande','Fernandina','Ferne','Fey','Fiann','Fianna','Fidela','Fidelia','Fidelity','Fifi','Fifine','Filia','Filide','Filippa','Fina','Fiona','Fionna','Fionnula','Fiorenze','Fleur','Fleurette','Flo','Flor','Flora','Florance','Flore','Florella','Florence','Florencia','Florentia','Florenza','Florette','Flori','Floria','Florida','Florie','Florina','Florinda','Floris','Florri','Florrie','Florry','Flory','Flossi','Flossie','Flossy','Flss','Fran','Francene','Frances','Francesca','Francine','Francisca','Franciska','Francoise','Francyne','Frank','Frankie','Franky','Franni','Frannie','Franny','Frayda','Fred','Freda','Freddi','Freddie','Freddy','Fredelia','Frederica','Fredericka','Frederique','Fredi','Fredia','Fredra','Fredrika','Freida','Frieda','Friederike','Fulvia','Gabbey','Gabbi','Gabbie','Gabey','Gabi','Gabie','Gabriel','Gabriela','Gabriell','Gabriella','Gabrielle','Gabriellia','Gabrila','Gaby','Gae','Gael','Gail','Gale','Galina','Garland','Garnet','Garnette','Gates','Gavra','Gavrielle','Gay','Gaye','Gayel','Gayla','Gayle','Gayleen','Gaylene','Gaynor','Gelya','Gena','Gene','Geneva','Genevieve','Genevra','Genia','Genna','Genni','Gennie','Gennifer','Genny','Genovera','Genvieve','George','Georgeanna','Georgeanne','Georgena','Georgeta','Georgetta','Georgette','Georgia','Georgiana','Georgianna','Georgianne','Georgie','Georgina','Georgine','Geralda','Geraldine','Gerda','Gerhardine','Geri','Gerianna','Gerianne','Gerladina','Germain','Germaine','Germana','Gerri','Gerrie','Gerrilee','Gerry','Gert','Gerta','Gerti','Gertie','Gertrud','Gertruda','Gertrude','Gertrudis','Gerty','Giacinta','Giana','Gianina','Gianna','Gigi','Gilberta','Gilberte','Gilbertina','Gilbertine','Gilda','Gilemette','Gill','Gillan','Gilli','Gillian','Gillie','Gilligan','Gilly','Gina','Ginelle','Ginevra','Ginger','Ginni','Ginnie','Ginnifer','Ginny','Giorgia','Giovanna','Gipsy','Giralda','Gisela','Gisele','Gisella','Giselle','Giuditta','Giulia','Giulietta','Giustina','Gizela','Glad','Gladi','Gladys','Gleda','Glen','Glenda','Glenine','Glenn','Glenna','Glennie','Glennis','Glori','Gloria','Gloriana','Gloriane','Glory','Glyn','Glynda','Glynis','Glynnis','Gnni','Godiva','Golda','Goldarina','Goldi','Goldia','Goldie','Goldina','Goldy','Grace','Gracia','Gracie','Grata','Gratia','Gratiana','Gray','Grayce','Grazia','Greer','Greta','Gretal','Gretchen','Grete','Gretel','Grethel','Gretna','Gretta','Grier','Griselda','Grissel','Guendolen','Guenevere','Guenna','Guglielma','Gui','Guillema','Guillemette','Guinevere','Guinna','Gunilla','Gus','Gusella','Gussi','Gussie','Gussy','Gusta','Gusti','Gustie','Gusty','Gwen','Gwendolen','Gwendolin','Gwendolyn','Gweneth','Gwenette','Gwenneth','Gwenni','Gwennie','Gwenny','Gwenora','Gwenore','Gwyn','Gwyneth','Gwynne','Gypsy','Hadria','Hailee','Haily','Haleigh','Halette','Haley','Hali','Halie','Halimeda','Halley','Halli','Hallie','Hally','Hana','Hanna','Hannah','Hanni','Hannie','Hannis','Hanny','Happy','Harlene','Harley','Harli','Harlie','Harmonia','Harmonie','Harmony','Harri','Harrie','Harriet','Harriett','Harrietta','Harriette','Harriot','Harriott','Hatti','Hattie','Hatty','Hayley','Hazel','Heath','Heather','Heda','Hedda','Heddi','Heddie','Hedi','Hedvig','Hedvige','Hedwig','Hedwiga','Hedy','Heida','Heidi','Heidie','Helaina','Helaine','Helen','Helen-Elizabeth','Helena','Helene','Helenka','Helga','Helge','Helli','Heloise','Helsa','Helyn','Hendrika','Henka','Henrie','Henrieta','Henrietta','Henriette','Henryetta','Hephzibah','Hermia','Hermina','Hermine','Herminia','Hermione','Herta','Hertha','Hester','Hesther','Hestia','Hetti','Hettie','Hetty','Hilary','Hilda','Hildagard','Hildagarde','Hilde','Hildegaard','Hildegarde','Hildy','Hillary','Hilliary','Hinda','Holli','Hollie','Holly','Holly-Anne','Hollyanne','Honey','Honor','Honoria','Hope','Horatia','Hortense','Hortensia','Hulda','Hyacinth','Hyacintha','Hyacinthe','Hyacinthia','Hyacinthie','Hynda','Ianthe','Ibbie','Ibby','Ida','Idalia','Idalina','Idaline','Idell','Idelle','Idette','Ileana','Ileane','Ilene','Ilise','Ilka','Illa','Ilsa','Ilse','Ilysa','Ilyse','Ilyssa','Imelda','Imogen','Imogene','Imojean','Ina','Indira','Ines','Inesita','Inessa','Inez','Inga','Ingaberg','Ingaborg','Inge','Ingeberg','Ingeborg','Inger','Ingrid','Ingunna','Inna','Iolande','Iolanthe','Iona','Iormina','Ira','Irena','Irene','Irina','Iris','Irita','Irma','Isa','Isabel','Isabelita','Isabella','Isabelle','Isadora','Isahella','Iseabal','Isidora','Isis','Isobel','Issi','Issie','Issy','Ivett','Ivette','Ivie','Ivonne','Ivory','Ivy','Izabel','Jacenta','Jacinda','Jacinta','Jacintha','Jacinthe','Jackelyn','Jacki','Jackie','Jacklin','Jacklyn','Jackquelin','Jackqueline','Jacky','Jaclin','Jaclyn','Jacquelin','Jacqueline','Jacquelyn','Jacquelynn','Jacquenetta','Jacquenette','Jacquetta','Jacquette','Jacqui','Jacquie','Jacynth','Jada','Jade','Jaime','Jaimie','Jaine','Jami','Jamie','Jamima','Jammie','Jan','Jana','Janaya','Janaye','Jandy','Jane','Janean','Janeczka','Janeen','Janel','Janela','Janella','Janelle','Janene','Janenna','Janessa','Janet','Janeta','Janetta','Janette','Janeva','Janey','Jania','Janice','Janie','Janifer','Janina','Janine','Janis','Janith','Janka','Janna','Jannel','Jannelle','Janot','Jany','Jaquelin','Jaquelyn','Jaquenetta','Jaquenette','Jaquith','Jasmin','Jasmina','Jasmine','Jayme','Jaymee','Jayne','Jaynell','Jazmin','Jean','Jeana','Jeane','Jeanelle','Jeanette','Jeanie','Jeanine','Jeanna','Jeanne','Jeannette','Jeannie','Jeannine','Jehanna','Jelene','Jemie','Jemima','Jemimah','Jemmie','Jemmy','Jen','Jena','Jenda','Jenelle','Jeni','Jenica','Jeniece','Jenifer','Jeniffer','Jenilee','Jenine','Jenn','Jenna','Jennee','Jennette','Jenni','Jennica','Jennie','Jennifer','Jennilee','Jennine','Jenny','Jeralee','Jere','Jeri','Jermaine','Jerrie','Jerrilee','Jerrilyn','Jerrine','Jerry','Jerrylee','Jess','Jessa','Jessalin','Jessalyn','Jessamine','Jessamyn','Jesse','Jesselyn','Jessi','Jessica','Jessie','Jessika','Jessy','Jewel','Jewell','Jewelle','Jill','Jillana','Jillane','Jillayne','Jilleen','Jillene','Jilli','Jillian','Jillie','Jilly','Jinny','Jo','Jo Ann','Jo-Ann','Jo-Anne','Joan','Joana','Joane','Joanie','Joann','Joanna','Joanne','Joannes','Jobey','Jobi','Jobie','Jobina','Joby','Jobye','Jobyna','Jocelin','Joceline','Jocelyn','Jocelyne','Jodee','Jodi','Jodie','Jody','Joeann','Joela','Joelie','Joell','Joella','Joelle','Joellen','Joelly','Joellyn','Joelynn','Joete','Joey','Johanna','Johannah','Johna','Johnath','Johnette','Johnna','Joice','Jojo','Jolee','Joleen','Jolene','Joletta','Joli','Jolie','Joline','Joly','Jolyn','Jolynn','Jonell','Joni','Jonie','Jonis','Jordain','Jordan','Jordana','Jordanna','Jorey','Jori','Jorie','Jorrie','Jorry','Joscelin','Josee','Josefa','Josefina','Josepha','Josephina','Josephine','Josey','Josi','Josie','Josselyn','Josy','Jourdan','Joy','Joya','Joyan','Joyann','Joyce','Joycelin','Joye','Jsandye','Juana','Juanita','Judi','Judie','Judith','Juditha','Judy','Judye','Juieta','Julee','Juli','Julia','Juliana','Juliane','Juliann','Julianna','Julianne','Julie','Julienne','Juliet','Julieta','Julietta','Juliette','Julina','Juline','Julissa','Julita','June','Junette','Junia','Junie','Junina','Justina','Justine','Justinn','Jyoti','Kacey','Kacie','Kacy','Kaela','Kai','Kaia','Kaila','Kaile','Kailey','Kaitlin','Kaitlyn','Kaitlynn','Kaja','Kakalina','Kala','Kaleena','Kali','Kalie','Kalila','Kalina','Kalinda','Kalindi','Kalli','Kally','Kameko','Kamila','Kamilah','Kamillah','Kandace','Kandy','Kania','Kanya','Kara','Kara-Lynn','Karalee','Karalynn','Kare','Karee','Karel','Karen','Karena','Kari','Karia','Karie','Karil','Karilynn','Karin','Karina','Karine','Kariotta','Karisa','Karissa','Karita','Karla','Karlee','Karleen','Karlen','Karlene','Karlie','Karlotta','Karlotte','Karly','Karlyn','Karmen','Karna','Karol','Karola','Karole','Karolina','Karoline','Karoly','Karon','Karrah','Karrie','Karry','Kary','Karyl','Karylin','Karyn','Kasey','Kass','Kassandra','Kassey','Kassi','Kassia','Kassie','Kat','Kata','Katalin','Kate','Katee','Katerina','Katerine','Katey','Kath','Katha','Katharina','Katharine','Katharyn','Kathe','Katherina','Katherine','Katheryn','Kathi','Kathie','Kathleen','Kathlin','Kathrine','Kathryn','Kathryne','Kathy','Kathye','Kati','Katie','Katina','Katine','Katinka','Katleen','Katlin','Katrina','Katrine','Katrinka','Katti','Kattie','Katuscha','Katusha','Katy','Katya','Kay','Kaycee','Kaye','Kayla','Kayle','Kaylee','Kayley','Kaylil','Kaylyn','Keeley','Keelia','Keely','Kelcey','Kelci','Kelcie','Kelcy','Kelila','Kellen','Kelley','Kelli','Kellia','Kellie','Kellina','Kellsie','Kelly','Kellyann','Kelsey','Kelsi','Kelsy','Kendra','Kendre','Kenna','Keri','Keriann','Kerianne','Kerri','Kerrie','Kerrill','Kerrin','Kerry','Kerstin','Kesley','Keslie','Kessia','Kessiah','Ketti','Kettie','Ketty','Kevina','Kevyn','Ki','Kiah','Kial','Kiele','Kiersten','Kikelia','Kiley','Kim','Kimberlee','Kimberley','Kimberli','Kimberly','Kimberlyn','Kimbra','Kimmi','Kimmie','Kimmy','Kinna','Kip','Kipp','Kippie','Kippy','Kira','Kirbee','Kirbie','Kirby','Kiri','Kirsten','Kirsteni','Kirsti','Kirstin','Kirstyn','Kissee','Kissiah','Kissie','Kit','Kitti','Kittie','Kitty','Kizzee','Kizzie','Klara','Klarika','Klarrisa','Konstance','Konstanze','Koo','Kora','Koral','Koralle','Kordula','Kore','Korella','Koren','Koressa','Kori','Korie','Korney','Korrie','Korry','Kris','Krissie','Krissy','Krista','Kristal','Kristan','Kriste','Kristel','Kristen','Kristi','Kristien','Kristin','Kristina','Kristine','Kristy','Kristyn','Krysta','Krystal','Krystalle','Krystle','Krystyna','Kyla','Kyle','Kylen','Kylie','Kylila','Kylynn','Kym','Kynthia','Kyrstin','La Verne','Lacee','Lacey','Lacie','Lacy','Ladonna','Laetitia','Laina','Lainey','Lana','Lanae','Lane','Lanette','Laney','Lani','Lanie','Lanita','Lanna','Lanni','Lanny','Lara','Laraine','Lari','Larina','Larine','Larisa','Larissa','Lark','Laryssa','Latashia','Latia','Latisha','Latrena','Latrina','Laura','Lauraine','Laural','Lauralee','Laure','Lauree','Laureen','Laurel','Laurella','Lauren','Laurena','Laurene','Lauretta','Laurette','Lauri','Laurianne','Laurice','Laurie','Lauryn','Lavena','Laverna','Laverne','Lavina','Lavinia','Lavinie','Layla','Layne','Layney','Lea','Leah','Leandra','Leann','Leanna','Leanor','Leanora','Lebbie','Leda','Lee','Leeann','Leeanne','Leela','Leelah','Leena','Leesa','Leese','Legra','Leia','Leigh','Leigha','Leila','Leilah','Leisha','Lela','Lelah','Leland','Lelia','Lena','Lenee','Lenette','Lenka','Lenna','Lenora','Lenore','Leodora','Leoine','Leola','Leoline','Leona','Leonanie','Leone','Leonelle','Leonie','Leonora','Leonore','Leontine','Leontyne','Leora','Leshia','Lesley','Lesli','Leslie','Lesly','Lesya','Leta','Lethia','Leticia','Letisha','Letitia','Letizia','Letta','Letti','Lettie','Letty','Lexi','Lexie','Lexine','Lexis','Lexy','Leyla','Lezlie','Lia','Lian','Liana','Liane','Lianna','Lianne','Lib','Libbey','Libbi','Libbie','Libby','Licha','Lida','Lidia','Liesa','Lil','Lila','Lilah','Lilas','Lilia','Lilian','Liliane','Lilias','Lilith','Lilla','Lilli','Lillian','Lillis','Lilllie','Lilly','Lily','Lilyan','Lin','Lina','Lind','Linda','Lindi','Lindie','Lindsay','Lindsey','Lindsy','Lindy','Linea','Linell','Linet','Linette','Linn','Linnea','Linnell','Linnet','Linnie','Linzy','Lira','Lisa','Lisabeth','Lisbeth','Lise','Lisetta','Lisette','Lisha','Lishe','Lissa','Lissi','Lissie','Lissy','Lita','Liuka','Liv','Liva','Livia','Livvie','Livvy','Livvyy','Livy','Liz','Liza','Lizabeth','Lizbeth','Lizette','Lizzie','Lizzy','Loella','Lois','Loise','Lola','Loleta','Lolita','Lolly','Lona','Lonee','Loni','Lonna','Lonni','Lonnie','Lora','Lorain','Loraine','Loralee','Loralie','Loralyn','Loree','Loreen','Lorelei','Lorelle','Loren','Lorena','Lorene','Lorenza','Loretta','Lorette','Lori','Loria','Lorianna','Lorianne','Lorie','Lorilee','Lorilyn','Lorinda','Lorine','Lorita','Lorna','Lorne','Lorraine','Lorrayne','Lorri','Lorrie','Lorrin','Lorry','Lory','Lotta','Lotte','Lotti','Lottie','Lotty','Lou','Louella','Louisa','Louise','Louisette','Loutitia','Lu','Luce','Luci','Lucia','Luciana','Lucie','Lucienne','Lucila','Lucilia','Lucille','Lucina','Lucinda','Lucine','Lucita','Lucky','Lucretia','Lucy','Ludovika','Luella','Luelle','Luisa','Luise','Lula','Lulita','Lulu','Lura','Lurette','Lurleen','Lurlene','Lurline','Lusa','Luz','Lyda','Lydia','Lydie','Lyn','Lynda','Lynde','Lyndel','Lyndell','Lyndsay','Lyndsey','Lyndsie','Lyndy','Lynea','Lynelle','Lynett','Lynette','Lynn','Lynna','Lynne','Lynnea','Lynnell','Lynnelle','Lynnet','Lynnett','Lynnette','Lynsey','Lyssa','Mab','Mabel','Mabelle','Mable','Mada','Madalena','Madalyn','Maddalena','Maddi','Maddie','Maddy','Madel','Madelaine','Madeleine','Madelena','Madelene','Madelin','Madelina','Madeline','Madella','Madelle','Madelon','Madelyn','Madge','Madlen','Madlin','Madonna','Mady','Mae','Maegan','Mag','Magda','Magdaia','Magdalen','Magdalena','Magdalene','Maggee','Maggi','Maggie','Maggy','Mahala','Mahalia','Maia','Maible','Maiga','Maighdiln','Mair','Maire','Maisey','Maisie','Maitilde','Mala','Malanie','Malena','Malia','Malina','Malinda','Malinde','Malissa','Malissia','Mallissa','Mallorie','Mallory','Malorie','Malory','Malva','Malvina','Malynda','Mame','Mamie','Manda','Mandi','Mandie','Mandy','Manon','Manya','Mara','Marabel','Marcela','Marcelia','Marcella','Marcelle','Marcellina','Marcelline','Marchelle','Marci','Marcia','Marcie','Marcile','Marcille','Marcy','Mareah','Maren','Marena','Maressa','Marga','Margalit','Margalo','Margaret','Margareta','Margarete','Margaretha','Margarethe','Margaretta','Margarette','Margarita','Margaux','Marge','Margeaux','Margery','Marget','Margette','Margi','Margie','Margit','Margo','Margot','Margret','Marguerite','Margy','Mari','Maria','Mariam','Marian','Mariana','Mariann','Marianna','Marianne','Maribel','Maribelle','Maribeth','Marice','Maridel','Marie','Marie-Ann','Marie-Jeanne','Marieann','Mariejeanne','Mariel','Mariele','Marielle','Mariellen','Marietta','Mariette','Marigold','Marijo','Marika','Marilee','Marilin','Marillin','Marilyn','Marin','Marina','Marinna','Marion','Mariquilla','Maris','Marisa','Mariska','Marissa','Marita','Maritsa','Mariya','Marj','Marja','Marje','Marji','Marjie','Marjorie','Marjory','Marjy','Marketa','Marla','Marlane','Marleah','Marlee','Marleen','Marlena','Marlene','Marley','Marlie','Marline','Marlo','Marlyn','Marna','Marne','Marney','Marni','Marnia','Marnie','Marquita','Marrilee','Marris','Marrissa','Marsha','Marsiella','Marta','Martelle','Martguerita','Martha','Marthe','Marthena','Marti','Martica','Martie','Martina','Martita','Marty','Martynne','Mary','Marya','Maryann','Maryanna','Maryanne','Marybelle','Marybeth','Maryellen','Maryjane','Maryjo','Maryl','Marylee','Marylin','Marylinda','Marylou','Marylynne','Maryrose','Marys','Marysa','Masha','Matelda','Mathilda','Mathilde','Matilda','Matilde','Matti','Mattie','Matty','Maud','Maude','Maudie','Maura','Maure','Maureen','Maureene','Maurene','Maurine','Maurise','Maurita','Maurizia','Mavis','Mavra','Max','Maxi','Maxie','Maxine','Maxy','May','Maybelle','Maye','Mead','Meade','Meagan','Meaghan','Meara','Mechelle','Meg','Megan','Megen','Meggi','Meggie','Meggy','Meghan','Meghann','Mehetabel','Mei','Mel','Mela','Melamie','Melania','Melanie','Melantha','Melany','Melba','Melesa','Melessa','Melicent','Melina','Melinda','Melinde','Melisa','Melisande','Melisandra','Melisenda','Melisent','Melissa','Melisse','Melita','Melitta','Mella','Melli','Mellicent','Mellie','Mellisa','Mellisent','Melloney','Melly','Melodee','Melodie','Melody','Melonie','Melony','Melosa','Melva','Mercedes','Merci','Mercie','Mercy','Meredith','Meredithe','Meridel','Meridith','Meriel','Merilee','Merilyn','Meris','Merissa','Merl','Merla','Merle','Merlina','Merline','Merna','Merola','Merralee','Merridie','Merrie','Merrielle','Merrile','Merrilee','Merrili','Merrill','Merrily','Merry','Mersey','Meryl','Meta','Mia','Micaela','Michaela','Michaelina','Michaeline','Michaella','Michal','Michel','Michele','Michelina','Micheline','Michell','Michelle','Micki','Mickie','Micky','Midge','Mignon','Mignonne','Miguela','Miguelita','Mikaela','Mil','Mildred','Mildrid','Milena','Milicent','Milissent','Milka','Milli','Millicent','Millie','Millisent','Milly','Milzie','Mimi','Min','Mina','Minda','Mindy','Minerva','Minetta','Minette','Minna','Minnaminnie','Minne','Minni','Minnie','Minnnie','Minny','Minta','Miof Mela','Miquela','Mira','Mirabel','Mirabella','Mirabelle','Miran','Miranda','Mireielle','Mireille','Mirella','Mirelle','Miriam','Mirilla','Mirna','Misha','Missie','Missy','Misti','Misty','Mitzi','Modesta','Modestia','Modestine','Modesty','Moina','Moira','Moll','Mollee','Molli','Mollie','Molly','Mommy','Mona','Monah','Monica','Monika','Monique','Mora','Moreen','Morena','Morgan','Morgana','Morganica','Morganne','Morgen','Moria','Morissa','Morna','Moselle','Moyna','Moyra','Mozelle','Muffin','Mufi','Mufinella','Muire','Mureil','Murial','Muriel','Murielle','Myra','Myrah','Myranda','Myriam','Myrilla','Myrle','Myrlene','Myrna','Myrta','Myrtia','Myrtice','Myrtie','Myrtle','Nada','Nadean','Nadeen','Nadia','Nadine','Nadiya','Nady','Nadya','Nalani','Nan','Nana','Nananne','Nance','Nancee','Nancey','Nanci','Nancie','Nancy','Nanete','Nanette','Nani','Nanice','Nanine','Nannette','Nanni','Nannie','Nanny','Nanon','Naoma','Naomi','Nara','Nari','Nariko','Nat','Nata','Natala','Natalee','Natalie','Natalina','Nataline','Natalya','Natasha','Natassia','Nathalia','Nathalie','Natividad','Natka','Natty','Neala','Neda','Nedda','Nedi','Neely','Neila','Neile','Neilla','Neille','Nelia','Nelie','Nell','Nelle','Nelli','Nellie','Nelly','Nerissa','Nerita','Nert','Nerta','Nerte','Nerti','Nertie','Nerty','Nessa','Nessi','Nessie','Nessy','Nesta','Netta','Netti','Nettie','Nettle','Netty','Nevsa','Neysa','Nichol','Nichole','Nicholle','Nicki','Nickie','Nicky','Nicol','Nicola','Nicole','Nicolea','Nicolette','Nicoli','Nicolina','Nicoline','Nicolle','Nikaniki','Nike','Niki','Nikki','Nikkie','Nikoletta','Nikolia','Nina','Ninetta','Ninette','Ninnetta','Ninnette','Ninon','Nissa','Nisse','Nissie','Nissy','Nita','Nixie','Noami','Noel','Noelani','Noell','Noella','Noelle','Noellyn','Noelyn','Noemi','Nola','Nolana','Nolie','Nollie','Nomi','Nona','Nonah','Noni','Nonie','Nonna','Nonnah','Nora','Norah','Norean','Noreen','Norene','Norina','Norine','Norma','Norri','Norrie','Norry','Novelia','Nydia','Nyssa','Octavia','Odele','Odelia','Odelinda','Odella','Odelle','Odessa','Odetta','Odette','Odilia','Odille','Ofelia','Ofella','Ofilia','Ola','Olenka','Olga','Olia','Olimpia','Olive','Olivette','Olivia','Olivie','Oliy','Ollie','Olly','Olva','Olwen','Olympe','Olympia','Olympie','Ondrea','Oneida','Onida','Oona','Opal','Opalina','Opaline','Ophelia','Ophelie','Ora','Oralee','Oralia','Oralie','Oralla','Oralle','Orel','Orelee','Orelia','Orelie','Orella','Orelle','Oriana','Orly','Orsa','Orsola','Ortensia','Otha','Othelia','Othella','Othilia','Othilie','Ottilie','Page','Paige','Paloma','Pam','Pamela','Pamelina','Pamella','Pammi','Pammie','Pammy','Pandora','Pansie','Pansy','Paola','Paolina','Papagena','Pat','Patience','Patrica','Patrice','Patricia','Patrizia','Patsy','Patti','Pattie','Patty','Paula','Paule','Pauletta','Paulette','Pauli','Paulie','Paulina','Pauline','Paulita','Pauly','Pavia','Pavla','Pearl','Pearla','Pearle','Pearline','Peg','Pegeen','Peggi','Peggie','Peggy','Pen','Penelopa','Penelope','Penni','Pennie','Penny','Pepi','Pepita','Peri','Peria','Perl','Perla','Perle','Perri','Perrine','Perry','Persis','Pet','Peta','Petra','Petrina','Petronella','Petronia','Petronilla','Petronille','Petunia','Phaedra','Phaidra','Phebe','Phedra','Phelia','Phil','Philipa','Philippa','Philippe','Philippine','Philis','Phillida','Phillie','Phillis','Philly','Philomena','Phoebe','Phylis','Phyllida','Phyllis','Phyllys','Phylys','Pia','Pier','Pierette','Pierrette','Pietra','Piper','Pippa','Pippy','Polly','Pollyanna','Pooh','Poppy','Portia','Pris','Prisca','Priscella','Priscilla','Prissie','Pru','Prudence','Prudi','Prudy','Prue','Queenie','Quentin','Querida','Quinn','Quinta','Quintana','Quintilla','Quintina','Rachael','Rachel','Rachele','Rachelle','Rae','Raeann','Raf','Rafa','Rafaela','Rafaelia','Rafaelita','Rahal','Rahel','Raina','Raine','Rakel','Ralina','Ramona','Ramonda','Rana','Randa','Randee','Randene','Randi','Randie','Randy','Ranee','Rani','Rania','Ranice','Ranique','Ranna','Raphaela','Raquel','Raquela','Rasia','Rasla','Raven','Ray','Raychel','Raye','Rayna','Raynell','Rayshell','Rea','Reba','Rebbecca','Rebe','Rebeca','Rebecca','Rebecka','Rebeka','Rebekah','Rebekkah','Ree','Reeba','Reena','Reeta','Reeva','Regan','Reggi','Reggie','Regina','Regine','Reiko','Reina','Reine','Remy','Rena','Renae','Renata','Renate','Rene','Renee','Renell','Renelle','Renie','Rennie','Reta','Retha','Revkah','Rey','Reyna','Rhea','Rheba','Rheta','Rhetta','Rhiamon','Rhianna','Rhianon','Rhoda','Rhodia','Rhodie','Rhody','Rhona','Rhonda','Riane','Riannon','Rianon','Rica','Ricca','Rici','Ricki','Rickie','Ricky','Riki','Rikki','Rina','Risa','Rita','Riva','Rivalee','Rivi','Rivkah','Rivy','Roana','Roanna','Roanne','Robbi','Robbie','Robbin','Robby','Robbyn','Robena','Robenia','Roberta','Robin','Robina','Robinet','Robinett','Robinetta','Robinette','Robinia','Roby','Robyn','Roch','Rochell','Rochella','Rochelle','Rochette','Roda','Rodi','Rodie','Rodina','Rois','Romola','Romona','Romonda','Romy','Rona','Ronalda','Ronda','Ronica','Ronna','Ronni','Ronnica','Ronnie','Ronny','Roobbie','Rora','Rori','Rorie','Rory','Ros','Rosa','Rosabel','Rosabella','Rosabelle','Rosaleen','Rosalia','Rosalie','Rosalind','Rosalinda','Rosalinde','Rosaline','Rosalyn','Rosalynd','Rosamond','Rosamund','Rosana','Rosanna','Rosanne','Rose','Roseann','Roseanna','Roseanne','Roselia','Roselin','Roseline','Rosella','Roselle','Rosemaria','Rosemarie','Rosemary','Rosemonde','Rosene','Rosetta','Rosette','Roshelle','Rosie','Rosina','Rosita','Roslyn','Rosmunda','Rosy','Row','Rowe','Rowena','Roxana','Roxane','Roxanna','Roxanne','Roxi','Roxie','Roxine','Roxy','Roz','Rozalie','Rozalin','Rozamond','Rozanna','Rozanne','Roze','Rozele','Rozella','Rozelle','Rozina','Rubetta','Rubi','Rubia','Rubie','Rubina','Ruby','Ruperta','Ruth','Ruthann','Ruthanne','Ruthe','Ruthi','Ruthie','Ruthy','Ryann','Rycca','Saba','Sabina','Sabine','Sabra','Sabrina','Sacha','Sada','Sadella','Sadie','Sadye','Saidee','Sal','Salaidh','Sallee','Salli','Sallie','Sally','Sallyann','Sallyanne','Saloma','Salome','Salomi','Sam','Samantha','Samara','Samaria','Sammy','Sande','Sandi','Sandie','Sandra','Sandy','Sandye','Sapphira','Sapphire','Sara','Sara-Ann','Saraann','Sarah','Sarajane','Saree','Sarena','Sarene','Sarette','Sari','Sarina','Sarine','Sarita','Sascha','Sasha','Sashenka','Saudra','Saundra','Savina','Sayre','Scarlet','Scarlett','Sean','Seana','Seka','Sela','Selena','Selene','Selestina','Selia','Selie','Selina','Selinda','Seline','Sella','Selle','Selma','Sena','Sephira','Serena','Serene','Shae','Shaina','Shaine','Shalna','Shalne','Shana','Shanda','Shandee','Shandeigh','Shandie','Shandra','Shandy','Shane','Shani','Shanie','Shanna','Shannah','Shannen','Shannon','Shanon','Shanta','Shantee','Shara','Sharai','Shari','Sharia','Sharity','Sharl','Sharla','Sharleen','Sharlene','Sharline','Sharon','Sharona','Sharron','Sharyl','Shaun','Shauna','Shawn','Shawna','Shawnee','Shay','Shayla','Shaylah','Shaylyn','Shaylynn','Shayna','Shayne','Shea','Sheba','Sheela','Sheelagh','Sheelah','Sheena','Sheeree','Sheila','Sheila-Kathryn','Sheilah','Shel','Shela','Shelagh','Shelba','Shelbi','Shelby','Shelia','Shell','Shelley','Shelli','Shellie','Shelly','Shena','Sher','Sheree','Sheri','Sherie','Sherill','Sherilyn','Sherline','Sherri','Sherrie','Sherry','Sherye','Sheryl','Shina','Shir','Shirl','Shirlee','Shirleen','Shirlene','Shirley','Shirline','Shoshana','Shoshanna','Siana','Sianna','Sib','Sibbie','Sibby','Sibeal','Sibel','Sibella','Sibelle','Sibilla','Sibley','Sibyl','Sibylla','Sibylle','Sidoney','Sidonia','Sidonnie','Sigrid','Sile','Sileas','Silva','Silvana','Silvia','Silvie','Simona','Simone','Simonette','Simonne','Sindee','Siobhan','Sioux','Siouxie','Sisely','Sisile','Sissie','Sissy','Siusan','Sofia','Sofie','Sondra','Sonia','Sonja','Sonni','Sonnie','Sonnnie','Sonny','Sonya','Sophey','Sophi','Sophia','Sophie','Sophronia','Sorcha','Sosanna','Stace','Stacee','Stacey','Staci','Stacia','Stacie','Stacy','Stafani','Star','Starla','Starlene','Starlin','Starr','Stefa','Stefania','Stefanie','Steffane','Steffi','Steffie','Stella','Stepha','Stephana','Stephani','Stephanie','Stephannie','Stephenie','Stephi','Stephie','Stephine','Stesha','Stevana','Stevena','Stoddard','Storm','Stormi','Stormie','Stormy','Sue','Suellen','Sukey','Suki','Sula','Sunny','Sunshine','Susan','Susana','Susanetta','Susann','Susanna','Susannah','Susanne','Susette','Susi','Susie','Susy','Suzann','Suzanna','Suzanne','Suzette','Suzi','Suzie','Suzy','Sybil','Sybila','Sybilla','Sybille','Sybyl','Sydel','Sydelle','Sydney','Sylvia','Tabatha','Tabbatha','Tabbi','Tabbie','Tabbitha','Tabby','Tabina','Tabitha','Taffy','Talia','Tallia','Tallie','Tallou','Tallulah','Tally','Talya','Talyah','Tamar','Tamara','Tamarah','Tamarra','Tamera','Tami','Tamiko','Tamma','Tammara','Tammi','Tammie','Tammy','Tamqrah','Tamra','Tana','Tandi','Tandie','Tandy','Tanhya','Tani','Tania','Tanitansy','Tansy','Tanya','Tara','Tarah','Tarra','Tarrah','Taryn','Tasha','Tasia','Tate','Tatiana','Tatiania','Tatum','Tawnya','Tawsha','Ted','Tedda','Teddi','Teddie','Teddy','Tedi','Tedra','Teena','TEirtza','Teodora','Tera','Teresa','Terese','Teresina','Teresita','Teressa','Teri','Teriann','Terra','Terri','Terrie','Terrijo','Terry','Terrye','Tersina','Terza','Tess','Tessa','Tessi','Tessie','Tessy','Thalia','Thea','Theadora','Theda','Thekla','Thelma','Theo','Theodora','Theodosia','Theresa','Therese','Theresina','Theresita','Theressa','Therine','Thia','Thomasa','Thomasin','Thomasina','Thomasine','Tiena','Tierney','Tiertza','Tiff','Tiffani','Tiffanie','Tiffany','Tiffi','Tiffie','Tiffy','Tilda','Tildi','Tildie','Tildy','Tillie','Tilly','Tim','Timi','Timmi','Timmie','Timmy','Timothea','Tina','Tine','Tiphani','Tiphanie','Tiphany','Tish','Tisha','Tobe','Tobey','Tobi','Toby','Tobye','Toinette','Toma','Tomasina','Tomasine','Tomi','Tommi','Tommie','Tommy','Toni','Tonia','Tonie','Tony','Tonya','Tonye','Tootsie','Torey','Tori','Torie','Torrie','Tory','Tova','Tove','Tracee','Tracey','Traci','Tracie','Tracy','Trenna','Tresa','Trescha','Tressa','Tricia','Trina','Trish','Trisha','Trista','Trix','Trixi','Trixie','Trixy','Truda','Trude','Trudey','Trudi','Trudie','Trudy','Trula','Tuesday','Twila','Twyla','Tybi','Tybie','Tyne','Ula','Ulla','Ulrica','Ulrika','Ulrikaumeko','Ulrike','Umeko','Una','Ursa','Ursala','Ursola','Ursula','Ursulina','Ursuline','Uta','Val','Valaree','Valaria','Vale','Valeda','Valencia','Valene','Valenka','Valentia','Valentina','Valentine','Valera','Valeria','Valerie','Valery','Valerye','Valida','Valina','Valli','Vallie','Vally','Valma','Valry','Van','Vanda','Vanessa','Vania','Vanna','Vanni','Vannie','Vanny','Vanya','Veda','Velma','Velvet','Venita','Venus','Vera','Veradis','Vere','Verena','Verene','Veriee','Verile','Verina','Verine','Verla','Verna','Vernice','Veronica','Veronika','Veronike','Veronique','Vevay','Vi','Vicki','Vickie','Vicky','Victoria','Vida','Viki','Vikki','Vikky','Vilhelmina','Vilma','Vin','Vina','Vinita','Vinni','Vinnie','Vinny','Viola','Violante','Viole','Violet','Violetta','Violette','Virgie','Virgina','Virginia','Virginie','Vita','Vitia','Vitoria','Vittoria','Viv','Viva','Vivi','Vivia','Vivian','Viviana','Vivianna','Vivianne','Vivie','Vivien','Viviene','Vivienne','Viviyan','Vivyan','Vivyanne','Vonni','Vonnie','Vonny','Vyky','Wallie','Wallis','Walliw','Wally','Waly','Wanda','Wandie','Wandis','Waneta','Wanids','Wenda','Wendeline','Wendi','Wendie','Wendy','Wendye','Wenona','Wenonah','Whitney','Wileen','Wilhelmina','Wilhelmine','Wilie','Willa','Willabella','Willamina','Willetta','Willette','Willi','Willie','Willow','Willy','Willyt','Wilma','Wilmette','Wilona','Wilone','Wilow','Windy','Wini','Winifred','Winna','Winnah','Winne','Winni','Winnie','Winnifred','Winny','Winona','Winonah','Wren','Wrennie','Wylma','Wynn','Wynne','Wynnie','Wynny','Xaviera','Xena','Xenia','Xylia','Xylina','Yalonda','Yasmeen','Yasmin','Yelena','Yetta','Yettie','Yetty','Yevette','Ynes','Ynez','Yoko','Yolanda','Yolande','Yolane','Yolanthe','Yoshi','Yoshiko','Yovonnda','Ysabel','Yvette','Yvonne','Zabrina','Zahara','Zandra','Zaneta','Zara','Zarah','Zaria','Zarla','Zea','Zelda','Zelma','Zena','Zenia','Zia','Zilvia','Zita','Zitella','Zoe','Zola','Zonda','Zondra','Zonnya','Zora','Zorah','Zorana','Zorina','Zorine','Zsa Zsa','Zsazsa','Zulema','Zuzana');
698    v_origins_countries origin_country_array := origin_country_array('Afghanistan','Albania','Algeria','Andorra','Angola','Antigua and Barbuda','Argentina','Armenia','Australia','Austria','Azerbaijan','The Bahamas','Bahrain','Bangladesh','Barbados','Belarus','Belgium','Belize','Benin','Bhutan','Bolivia','Bosnia and Herzegovina','Botswana','Brazil','Brunei','Bulgaria','Burkina Faso','Burundi','Cabo Verde','Cambodia','Cameroon','Canada','Central African Republic','Chad','Chile','China','Colombia','Comoros','Congo','Costa Rica','Croatia','Cuba','Cyprus','Czech Republic','Denmark','Djibouti','Dominica','Dominican Republic','East Timor','Ecuador','Egypt','El Salvador','Equatorial Guinea','Eritrea','Estonia','Eswatini','Ethiopia','Fiji','Finland','France','Gabon','The Gambia','Georgia','Germany','Ghana','Greece','Grenada','Guatemala','Guinea','Guinea-Bissau','Guyana','Haiti','Honduras','Hungary','Iceland','India','Indonesia','Iran','Iraq','Ireland','Israel','Italy','Jamaica','Japan','Jordan','Kazakhstan','Kenya','Kiribati','Korea, North','Korea, South','Kosovo','Kuwait','Kyrgyzstan','Laos','Latvia','Lebanon','Lesotho','Liberia','Libya','Liechtenstein','Lithuania','Luxembourg','Madagascar','Malawi','Malaysia','Maldives','Mali','Malta','Marshall Islands','Mauritania','Mauritius','Mexico','Micronesia','Moldova','Monaco','Mongolia','Montenegro','Morocco','Mozambique','Myanmar','Namibia','Nauru','Nepal','Netherlands','New Zealand','Nicaragua','Niger','Nigeria','North Macedonia','Norway','Oman','Pakistan','Palau','Panama','Papua New Guinea','Paraguay','Peru','Philippines','Poland','Portugal','Qatar','Romania','Russia','Rwanda','Saint Kitts and Nevis','Saint Lucia','Saint Vincent and the Grenadines','Samoa','San Marino','Sao Tome and Principe','Saudi Arabia','Senegal','Serbia','Seychelles','Sierra Leone','Singapore','Slovakia','Slovenia','Solomon Islands','Somalia','South Africa','Spain','Sri Lanka','Sudan','Sudan, South','Suriname','Sweden','Switzerland','Syria','Taiwan','Tajikistan','Tanzania','Thailand','Togo','Tonga','Trinidad and Tobago','Tunisia','Turkey','Turkmenistan','Tuvalu','Uganda','Ukraine','United Arab Emirates','United Kingdom','United States','Uruguay','Uzbekistan','Vanuatu','Vatican City','Venezuela','Vietnam','Yemen','Zambia','Zimbabwe');
699
700BEGIN
701    FOR v_index IN 0..p_total_people - 1 LOOP
702        v_first_name := v_first_names(DBMS_RANDOM.VALUE(1, v_first_names.COUNT));
703        v_last_name := v_first_names(DBMS_RANDOM.VALUE(1, v_first_names.COUNT));
704        v_birth_date := CURRENT_DATE - (TRUNC(DBMS_RANDOM.VALUE(11,70)) * 365);
705        v_description := DBMS_RANDOM.STRING('A', 500);
706        v_origin_country := v_origins_countries(DBMS_RANDOM.VALUE(1, v_origins_countries.COUNT));
707        INSERT INTO people (first_name, last_name, birth_date, description, origin_country) 
708        VALUES (v_first_name, v_last_name, v_birth_date, v_description, v_origin_country);
709    END LOOP;
710END;
711/
712--Procedura pentru popularea tabelei roles
713CREATE OR REPLACE PROCEDURE populate_roles_table AS
714    TYPE roless IS VARRAY(50) OF VARCHAR2(50);
715    
716    v_role roles.role%TYPE; --varchar2(50)
717    
718    v_roles roless := roless('Director', 'Writer', 'Story Editor', 'Dialogue Coach', 'Location Manager', 'Set Designer', 'Art Director', 'Costume Designer', 'Unit Production Manager', 'Line Producer', 'Production Manager', 'Assistant Director', 'Second Assistant Director', 'Continuity Person', 'Cinematographer', 'Gaffer', 'Camera Operator', 'Assistant Cameraman', 'Film Loader', 'Steadicam Operator', 'Production Sound Mixer', 'Boom Operator', 'Actor', 'Key Grip', 'Dolly Grip', 'Best Boy', 'Visual Effects Director', 'FX Coordinator', 'Property Master', 'Leadman', 'Costumer', 'Make-up Artist', 'Body Make-up Artist', 'Hairdresser', 'Unit Publicist', 'Production Caterer', 'Post-Production Supervisor', 'Editor', 'Color Timer', 'Negative Cutter', 'Music Mixer', 'Matte Artist');
719
720BEGIN
721    FOR v_index IN 1..v_roles.COUNT LOOP
722        INSERT INTO roles (role) VALUES (v_roles(v_index));
723    END LOOP;
724END;
725/
726--Procedura pentru popularea tabelei genres
727CREATE OR REPLACE PROCEDURE populate_genres_table AS
728    TYPE genress IS VARRAY(100) OF VARCHAR2(25);
729    
730    v_genre genres.genre%TYPE; --varchar2(25)
731    v_genres genress := genress('Aerospace ','Biography','Buddy Cop ','Burlesque ','Chick Flick','Circus ','Comedy ','Black comedy','Gross-out ','Romantic comedy ','Screwball comedy ','Wacky Comedy ','Stoner ','Coming-of-age s.','Comic Book -superhero','Concert ','Courtroom drama ','Current Events ','Detective ','Disaster ','Drama ','Romantic Drama ','Educational ','Ephemeral ','Exploitation ','Blaxploitation','Fantasy ','fantastique','Gangster ','Gay movies','Gothic ','Heist ','History ','Horror ','Slasher ','Jungle ','Martial arts ','Wu Xia ','Medieval ','Military ','Mountie ','Mystery ','Nature ','Police ','Politics ','Pornographic ','Prison ','Propaganda ','Psycho ','Religion ','Revolution ','Road movie','Romance ','Science ','Science fiction ','Sex ','Sitcom ','Social guidance ','Spiritual ','Sports ','Baseball ','Spy ','Sword and Sandal ','Teen ','Travelogue','Variety ','War ','Submarine ','Western');
732    
733BEGIN
734    FOR v_index IN 1..v_genres.COUNT LOOP
735        INSERT INTO genres (genre) VALUES (v_genres(v_index));
736    END LOOP;
737END;
738/
739CREATE OR REPLACE PROCEDURE populate_reviews_table(p_total_reviews IN NUMBER) AS
740    TYPE titles_begin IS VARRAY(50) OF VARCHAR2(100);
741
742    v_title reviews.title%TYPE; --VARCHAR2(100)
743    v_description reviews.description%TYPE; --VARCHAR2(1000
744    v_review_date reviews.review_date%TYPE; --DATE
745    v_likes reviews.likes%TYPE; --NUMBER
746    v_dislikes reviews.dislikes%TYPE; --NUMBER
747    v_spoiler reviews.spoiler%TYPE; --NUMBER(1)
748    
749    title_begin titles_begin := titles_begin('able','bad','best','better','big','black','certain','clear','different','early','easy','economic','federal','free','full','good','great','hard','high','human','important','international','large','late','little','local','long','low','major','military','national','new','old','only','other','political','possible','public','real','recent','right','small','social','special','strong','sure','true','white','whole','young');
750    
751BEGIN
752    FOR v_index IN 1..p_total_reviews LOOP
753        v_title := title_begin(DBMS_RANDOM.VALUE(1, title_begin.COUNT)) || DBMS_RANDOM.STRING('A', 5);
754        
755        v_description := DBMS_RANDOM.STRING('A', 500);
756        
757        v_review_date := CURRENT_DATE - (TRUNC(DBMS_RANDOM.VALUE(0,11)) * 365);
758        
759        v_likes := TRUNC(DBMS_RANDOM.VALUE(0, 999999));
760        
761        v_dislikes := TRUNC(DBMS_RANDOM.VALUE(0, 9999));
762        
763        v_spoiler := ROUND(DBMS_RANDOM.VALUE(0, 1));
764        
765        INSERT INTO reviews (title, description, review_date, likes, dislikes, spoiler) 
766        VALUES (v_title, v_description, v_review_date, v_likes, v_dislikes, v_spoiler);
767    END LOOP;
768END;
769/
770CREATE OR REPLACE PROCEDURE populate_ratings_table(p_total_ratings IN NUMBER) AS
771BEGIN
772    FOR v_index IN 1..p_total_ratings LOOP
773        INSERT INTO ratings (rating) VALUES (ROUND(DBMS_RANDOM.VALUE(1, 10)));
774    END LOOP;
775END;
776/
777CREATE OR REPLACE PROCEDURE populate_lists_table(p_total_lists IN NUMBER) AS
778BEGIN
779    FOR v_index IN 1..p_total_lists LOOP
780        INSERT INTO lists (creation_date) VALUES (CURRENT_DATE - (DBMS_RANDOM.VALUE(0, 10) * DBMS_RANDOM.VALUE(1, 365)));
781    END LOOP;
782END;
783/
784CREATE OR REPLACE PROCEDURE populate_rating_review_table AS
785    v_id_rating NUMBER := 1;
786BEGIN
787    FOR v_review IN (SELECT * FROM reviews) LOOP
788        INSERT INTO rating_review (id_rating, id_review) VALUES (v_id_rating, v_review.id);
789        v_id_rating := v_id_rating + 1;
790    END LOOP;
791END;
792/
793CREATE OR REPLACE PROCEDURE populate_user_ratings_table AS
794    v_totalUsers NUMBER DEFAULT 0;
795    v_first_id_users NUMBER;
796BEGIN
797    SELECT COUNT(*) INTO v_totalUsers FROM users;
798    SELECT MIN(users.id) INTO v_first_id_users FROM users;
799
800    FOR v_rating IN (SELECT * FROM ratings) LOOP
801        INSERT INTO user_ratings (id_user, id_rating) VALUES (TRUNC(DBMS_RANDOM.VALUE(v_first_id_users, v_first_id_users + v_totalUsers)), v_rating.id);
802    END LOOP;
803END;
804/
805CREATE OR REPLACE PROCEDURE populate_movie_genre_table AS
806    v_totalGenres NUMBER;
807    v_first_id_genres NUMBER;
808    v_random_probability NUMBER;
809BEGIN
810    SELECT COUNT(*) INTO v_totalGenres FROM genres;
811    SELECT MIN(genres.id) INTO v_first_id_genres FROM genres;
812
813    FOR v_movie IN (SELECT * FROM movies) LOOP
814        v_random_probability := DBMS_RANDOM.VALUE(0.01, 0.99);
815        CASE
816        WHEN v_random_probability <= 0.3 THEN
817            INSERT INTO movie_genre (id_genre, id_movie) VALUES (TRUNC(DBMS_RANDOM.VALUE(v_first_id_genres, v_first_id_genres + v_totalGenres)), v_movie.id);
818        WHEN v_random_probability <= 0.7 AND v_random_probability > 0.3  THEN
819            INSERT INTO movie_genre (id_genre, id_movie) VALUES (TRUNC(DBMS_RANDOM.VALUE(v_first_id_genres, v_first_id_genres + v_totalGenres - v_totalGenres/2 - 1)), v_movie.id);
820            INSERT INTO movie_genre (id_genre, id_movie) VALUES (TRUNC(DBMS_RANDOM.VALUE( v_first_id_genres + v_totalGenres - v_totalGenres/2, v_first_id_genres + v_totalGenres)), v_movie.id);
821        ELSE 
822            INSERT INTO movie_genre (id_genre, id_movie) VALUES (TRUNC(DBMS_RANDOM.VALUE(v_first_id_genres, v_first_id_genres + v_totalGenres - (v_totalGenres/3 * 2) - 1)), v_movie.id);
823            INSERT INTO movie_genre (id_genre, id_movie) VALUES (TRUNC(DBMS_RANDOM.VALUE(v_first_id_genres + v_totalGenres - (v_totalGenres/3 * 2),v_first_id_genres + v_totalGenres - v_totalGenres/3 - 1)), v_movie.id);
824            INSERT INTO movie_genre (id_genre, id_movie) VALUES (TRUNC(DBMS_RANDOM.VALUE(v_first_id_genres + v_totalGenres - v_totalGenres/3, v_first_id_genres + v_totalGenres)), v_movie.id);
825        END CASE;
826    END LOOP;
827END;
828/
829CREATE OR REPLACE PROCEDURE populate_movie_crew_table AS
830    v_total_people NUMBER;
831    v_first_id_people NUMBER;
832    v_total_roles NUMBER;
833    v_first_id_role NUMBER;
834    v_total_team_members NUMBER;
835BEGIN
836    SELECT COUNT(*) INTO v_total_people FROM people;
837    SELECT MIN(people.id) INTO v_first_id_people FROM people;
838    SELECT COUNT(*) INTO v_total_roles FROM roles;
839    SELECT MIN(roles.id) INTO v_first_id_role FROM roles;
840
841    FOR v_movie IN (SELECT * FROM movies) LOOP
842         v_total_team_members := ROUND(DBMS_RANDOM.VALUE(10, 100));
843         FOR v_index IN 1..v_total_team_members LOOP
844            INSERT INTO movie_crew (id_movie, id_person, id_role)
845            VALUES (v_movie.id, TRUNC(DBMS_RANDOM.VALUE(v_first_id_people, v_first_id_people + v_total_people)), TRUNC(DBMS_RANDOM.VALUE(v_first_id_role, v_first_id_role + v_total_roles)));
846         END LOOP;
847    END LOOP;
848END;
849/
850CREATE OR REPLACE PROCEDURE populate_user_lists_table AS
851    v_total_users NUMBER;
852    v_first_id_from_users NUMBER;
853BEGIN
854    SELECT COUNT(*) INTO v_total_users FROM users;
855    SELECT MIN(users.id) INTO v_first_id_from_users FROM users;
856
857    FOR v_list IN (SELECT * FROM lists) LOOP
858         INSERT INTO user_lists (id_user, id_list) 
859         VALUES(TRUNC(DBMS_RANDOM.VALUE(v_first_id_from_users, v_first_id_from_users + v_total_users)), v_list.id);
860    END LOOP;
861END;
862/
863CREATE OR REPLACE PROCEDURE populate_movie_list_table AS
864    v_total_movies NUMBER DEFAULT 0;
865    v_first_id_from_movies NUMBER;
866    v_numberFromList NUMBER DEFAULT 0;
867BEGIN
868    SELECT COUNT(*) INTO v_total_movies FROM movies;
869    SELECT MIN(movies.id) INTO v_first_id_from_movies FROM movies;
870
871    FOR v_list IN (SELECT * FROM lists) LOOP
872        v_numberFromList := TRUNC(DBMS_RANDOM.VALUE(5, 50));
873        FOR v_index IN 1..v_numberFromList LOOP
874            INSERT INTO movie_list (id_list, id_movie) 
875            VALUES(v_list.id, TRUNC(DBMS_RANDOM.VALUE(v_first_id_from_movies, v_first_id_from_movies + v_total_movies)));
876        END LOOP;
877    END LOOP;
878END;
879/
880CREATE OR REPLACE PROCEDURE populate_movie_ratings_table AS
881    v_total_movies NUMBER DEFAULT 0;
882    v_first_id_from_movie NUMBER;
883BEGIN
884    SELECT COUNT(*) INTO v_total_movies FROM movies;
885    SELECT MIN(movies.id) INTO v_first_id_from_movie FROM movies;
886
887    FOR v_rating IN (SELECT * FROM ratings) LOOP
888        INSERT INTO movie_ratings (id_rating, id_movie) 
889        VALUES(v_rating.id, TRUNC(DBMS_RANDOM.VALUE(v_first_id_from_movie, v_first_id_from_movie + v_total_movies)));
890    END LOOP;
891END;
892/
893BEGIN
894    populate_users_table(100000);
895END;
896/
897BEGIN
898    populate_people_table(20000);
899END;
900/
901BEGIN
902    populate_roles_table();
903END;
904/
905BEGIN
906    populate_movies_table(25000);
907END;
908/
909BEGIN
910    populate_genres_table();
911END;
912/
913BEGIN
914    populate_ratings_table(300000); -- trebuie sa fie mai mare ca reviews deoarece nu poti avea mai multe review-uri ca rating-uri
915END;
916/
917BEGIN
918    populate_reviews_table(15000); 
919END;
920/
921BEGIN
922    populate_lists_table(20000);
923END;
924/
925BEGIN
926    populate_rating_review_table();
927END;
928/
929BEGIN
930    populate_movie_genre_table();
931END;
932/
933BEGIN
934    populate_user_lists_table();
935END;
936/
937BEGIN
938    populate_movie_crew_table();
939END;
940/
941BEGIN
942    populate_user_ratings_table();
943END;
944/
945BEGIN
946    populate_movie_list_table();
947END;
948/
949BEGIN
950    populate_movie_ratings_table();
951END;