--- Query: 00a_urls per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
GROUP BY journals.journal_id;


--- Query: 00b_urls per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
GROUP BY files.f_year;


--- Query: 00c_ no urls per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals LEFT JOIN files ON journals.journal_id = files.journal_id) LEFT JOIN urls ON files.file_id = urls.file_id
GROUP BY journals.journal_id;


--- Query: 00d_ urls per file ---
SELECT files.file_id, count(urls.url_link)
FROM files INNER JOIN urls ON files.file_id = urls.file_id
GROUP BY files.file_id;


--- Query: 00e0 ---
SELECT journals.journal_id, urls.url_link
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*epaa.*"));


--- Query: 00e1 aytoanafores j01 ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*commin*"))
GROUP BY journals.journal_id;


--- Query: 00e10 j10 ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*/srm*"))
GROUP BY journals.journal_id;


--- Query: 00e11 j11 ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*jpeer*"))
GROUP BY journals.journal_id;


--- Query: 00e12 j12 ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*rlt.*"))
GROUP BY journals.journal_id;


--- Query: 00e13 j13 ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*pareon*"))
GROUP BY journals.journal_id;


--- Query: 00e14 j14 ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*epaa.*"))
GROUP BY journals.journal_id;


--- Query: 00e2 j02 ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*llt.msu*"))
GROUP BY journals.journal_id;


--- Query: 00e3 j03 ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*irrodl*"))
GROUP BY journals.journal_id;


--- Query: 00e4 j04 ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*cbe*"))
GROUP BY journals.journal_id;


--- Query: 00e5 j05 ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*ifets*"))
GROUP BY journals.journal_id;


--- Query: 00e6 j06 ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*jowr*"))
GROUP BY journals.journal_id;


--- Query: 00e7 j07 ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*serj*"))
GROUP BY journals.journal_id;


--- Query: 00e8 j08 ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*doi*/c*-20*"))
GROUP BY journals.journal_id;


--- Query: 00e9 j09 ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*biomedc*"))
GROUP BY journals.journal_id;


--- Query: 01_all dois ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*doi.*"));


--- Query: 01a_dois per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*doi.*"))
GROUP BY journals.journal_id;


--- Query: 01b_dois per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*doi.*"))
GROUP BY files.f_year;


--- Query: 02a_ irrodl ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*irrodl*"));


--- Query: 02b_irrodl_org ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*irrodl.org*"));


--- Query: 02c irrodl per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*irrodl.org*"))
GROUP BY journals.journal_id;


--- Query: 03_msu ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*llt.msu.*"));


--- Query: 03b msu per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*llt.msu.*"))
GROUP BY journals.journal_id;


--- Query: 03c msu per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*llt.msu.*"))
GROUP BY files.f_year;


--- Query: 04_ncbi ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*ncbi*"));


--- Query: 04b ncbi per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*ncbi.*"))
GROUP BY journals.journal_id;


--- Query: 04c ncbi per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*ncbi.*"))
GROUP BY files.f_year;


--- Query: 04d irrodlorg per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*irrodl.org*"))
GROUP BY files.f_year;


--- Query: 05_aamc ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*aamc.*"));


--- Query: 05b ammc per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*aamc.*"))
GROUP BY journals.journal_id;


--- Query: 05c aamc per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*aamc.*"))
GROUP BY files.f_year;


--- Query: 06_orcid ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*orcid*"));


--- Query: 06c orcid per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*orcid.*"))
GROUP BY journals.journal_id;


--- Query: 06c orcid per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*orcid.*"))
GROUP BY files.f_year;


--- Query: 07_jstor ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*jstor*"));


--- Query: 07b jstor per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "**jstor*"))
GROUP BY journals.journal_id;


--- Query: 07c jstor per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "**jstor*"))
GROUP BY files.f_year;


--- Query: 08_hdlhandle ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*hdl.handle*"));


--- Query: 08b hdl per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*hdl.handle*"))
GROUP BY journals.journal_id;


--- Query: 08c hdl per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*hdl.handle*"))
GROUP BY files.f_year;


--- Query: 09_tandfonline ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*tandfonline*"));


--- Query: 09b tandofline per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*tandfonline*"))
GROUP BY journals.journal_id;


--- Query: 09c tandofline per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*tandfonline*"))
GROUP BY files.f_year;


--- Query: 10_eprints ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*eprints.*"));


--- Query: 10b eprints per journals ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*eprints.*"))
GROUP BY journals.journal_id;


--- Query: 10c eprints per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*eprints.*"))
GROUP BY files.f_year;


--- Query: 11_acm ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.acm.*"));


--- Query: 11b acm per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*.acm.*"))
GROUP BY journals.journal_id;


--- Query: 11c acm per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.acm.*"))
GROUP BY files.f_year;


--- Query: 12_wiley ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*wiley.com*"));


--- Query: 12b wiley per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*wiley.com*"))
GROUP BY journals.journal_id;


--- Query: 12c wiley per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*wiley.com*"))
GROUP BY files.f_year;


--- Query: 13_springer ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*springer*"));


--- Query: 13b springer per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*springer*"))
GROUP BY journals.journal_id;


--- Query: 13c srpinger per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*springer*"))
GROUP BY files.f_year;


--- Query: 14_acrl ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*acrl.*"));


--- Query: 14b acrl per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*acrl.*"))
GROUP BY journals.journal_id;


--- Query: 14c acrl per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*acrl.*"))
GROUP BY files.f_year;


--- Query: 15_eurodl ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*eurodl.org*"));


--- Query: 15b eurodl per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*eurodl.org*"))
GROUP BY journals.journal_id;


--- Query: 15c eurodl per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*eurodl.org*"))
GROUP BY files.f_year;


--- Query: 16_jolt ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*jolt.*"));


--- Query: 16b jolt per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*jolt.*"))
GROUP BY journals.journal_id;


--- Query: 16c jolt per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*jolt.*"))
GROUP BY files.f_year;


--- Query: 17_digitalcommons ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*digitalcommons*"));


--- Query: 17b digitalcommons per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*digitalcommon*"))
GROUP BY journals.journal_id;


--- Query: 17c digitalcommons per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*digitalcommons*"))
GROUP BY files.f_year;


--- Query: 18_escholar ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*escholarship*"));


--- Query: 18b escholar py journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*escholarship*"))
GROUP BY journals.journal_id;


--- Query: 18c escholar by year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*escholarship*"))
GROUP BY files.f_year;


--- Query: 19_researchgate ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*researchgate*"));


--- Query: 19b researchgate per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*researchgate.*"))
GROUP BY journals.journal_id;


--- Query: 19c researchgate per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*researchgate.*"))
GROUP BY files.f_year;


--- Query: 20_comminfolit ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*comminfolit.org*"));


--- Query: 20b comminfolit per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*comminfolit.org*"))
GROUP BY journals.journal_id;


--- Query: 20c comminfolit per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*comminfolit.org*"))
GROUP BY files.f_year;


--- Query: 21_creative ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*creativecommons*"));


--- Query: 21b creative per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*creativecommons*"))
GROUP BY journals.journal_id;


--- Query: 21c creative per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*creativecommons*"))
GROUP BY files.f_year;


--- Query: 22_ieeexplore ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*ieeexplore*"));


--- Query: 22b ieee per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*ieeexplore.*"))
GROUP BY journals.journal_id;


--- Query: 22c ieee per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*ieeexplore.*"))
GROUP BY files.f_year;


--- Query: 23_sciencedirect ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*sciencedirect*"));


--- Query: 23b sciencedirect per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*sciencedirect.*"))
GROUP BY journals.journal_id;


--- Query: 23c sceincedirect per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*sciencedirect.*"))
GROUP BY files.f_year;


--- Query: 24_academiaedu ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*academia.edu*"));


--- Query: 24b academia per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*academia.edu*"))
GROUP BY journals.journal_id;


--- Query: 24c academia per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*academia.edu*"))
GROUP BY files.f_year;


--- Query: 25_arxiv ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*arxiv*"));


--- Query: 25b arxiv per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*arxiv*"))
GROUP BY journals.journal_id;


--- Query: 25c arxiv per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*arxiv*"))
GROUP BY files.f_year;


--- Query: 26_oreilly ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*oreilly*"));


--- Query: 26b oreilly per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*oreilly*"))
GROUP BY journals.journal_id;


--- Query: 26c oreilly per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*oreilly*"))
GROUP BY files.f_year;


--- Query: 27_onlinelearningconsortium ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*onlinelearningconsortium*"));


--- Query: 27b olc per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*onlinelearningconsortium*"))
GROUP BY journals.journal_id;


--- Query: 27c olc per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*onlinelearningconsortium*"))
GROUP BY files.f_year;


--- Query: 28_elsevier ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*elsevier*"));


--- Query: 28b elsevier per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*elsevier*"))
GROUP BY journals.journal_id;


--- Query: 28c elsevier per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*elsevier*"))
GROUP BY files.f_year;


--- Query: 29_journals_lww ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*journals.lww*"));


--- Query: 30_scribd ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*scribd*"));


--- Query: 30b scribd per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*scribd.*"))
GROUP BY journals.journal_id;


--- Query: 30c scribd per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*scribd.*"))
GROUP BY files.f_year;


--- Query: 31_med-ed ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*med-ed*"));


--- Query: 32_online-journals ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*online-journals*"));


--- Query: 33_journals_cambridge ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*journals.cambridge*"));


--- Query: 34_cloudworks ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*cloudworks*"));


--- Query: 35_openmedicine ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*openmedicine.*"));


--- Query: 36_pdx ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*pdx.*"));


--- Query: 37_academic-journals ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*academic-journals*"));


--- Query: 38_roar ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*roar*"));


--- Query: 39_publishers_org ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*publishers.org*"));


--- Query: 40_ ed_gov_all ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.ed.gov*") or ((urls.url_link) Like "*/ed.gov*"));


--- Query: 40b edgov per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*.ed.gov*") or ((urls.url_link) Like "*/ed.gov*"))
GROUP BY journals.journal_id;


--- Query: 40c edgov per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.ed.gov*") or ((urls.url_link) Like "*/ed.gov*"))
GROUP BY files.f_year;


--- Query: 41_ iase_web_org ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*iase-web.org*"));


--- Query: 41b iase per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*iase-web.org*"))
GROUP BY journals.journal_id;


--- Query: 41c iase per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*iase-web.org*"))
GROUP BY files.f_year;


--- Query: 42_ amstat ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*amstat*"));


--- Query: 42b amstat per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*amstat*"))
GROUP BY journals.journal_id;


--- Query: 42c amstat per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*amstat*"))
GROUP BY files.f_year;


--- Query: 43_ epaa_asu ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*epaa.asu*"));


--- Query: 43b epaa per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*epaa.asu*"))
GROUP BY journals.journal_id;


--- Query: 43c epaa per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*epaa.asu*"))
GROUP BY files.f_year;


--- Query: 44_ nytimes ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*nytimes.*"));


--- Query: 44b nytimes per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*nytimes.*"))
GROUP BY journals.journal_id;


--- Query: 44c nytimes per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*nytimes.*"))
GROUP BY files.f_year;


--- Query: 45_ auckland ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*stat.auckland.ac.nz*"));


--- Query: 45b auckland per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*stat.auckland.ac.nz*"))
GROUP BY journals.journal_id;


--- Query: 45c auckland per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*stat.auckland.ac.nz*"))
GROUP BY files.f_year;


--- Query: 46_ ala_org ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.ala.org*"));


--- Query: 46b ala per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*.ala.org*"))
GROUP BY journals.journal_id;


--- Query: 46c ala per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.ala.org*"))
GROUP BY files.f_year;


--- Query: 47_ gmc_uk ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*gmc-uk.org*"));


--- Query: 47b gmc per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*gmc-uk.or*"))
GROUP BY journals.journal_id;


--- Query: 47c gmc per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*gmc-uk.or*"))
GROUP BY files.f_year;


--- Query: 48_ pareonline ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*pareonline*"));


--- Query: 48b pareonline per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*pareonline.*"))
GROUP BY journals.journal_id;


--- Query: 48c pareonline per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*pareonline.*"))
GROUP BY files.f_year;


--- Query: 49_ WHO ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*who.int*"));


--- Query: 49b who by journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*who.int*"))
GROUP BY journals.journal_id;


--- Query: 49c who by year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*who.int*"))
GROUP BY files.f_year;


--- Query: 50_ educause ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*educause.*"));


--- Query: 50b educause per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*educause.*"))
GROUP BY journals.journal_id;


--- Query: 50c educause per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*educause.*"))
GROUP BY files.f_year;


--- Query: 51_ oecd ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.oecd.*") or ((urls.url_link) Like "*.oecd*"));


--- Query: 51b oecd by journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*.oecd*"))
GROUP BY journals.journal_id;


--- Query: 51c oecd by year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.oecd*"))
GROUP BY files.f_year;


--- Query: 52_ edweek ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*edweek.*"));


--- Query: 52b edweek per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*edweek.*"))
GROUP BY journals.journal_id;


--- Query: 52c edweek per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*edweek.*"))
GROUP BY files.f_year;


--- Query: 53_ chronicle_com ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.chronicle.com*") or ((urls.url_link) Like "*/chronicle.com*" ));


--- Query: 53b chronicle per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*.chronicle.com*") or ((urls.url_link) Like "*/chronicle.com*" ))
GROUP BY journals.journal_id;


--- Query: 53c chronicle per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.chronicle.com*") or ((urls.url_link) Like "*/chronicle.com*" ))
GROUP BY files.f_year;


--- Query: 54 unesco ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*unesco.org*"));


--- Query: 54b unesco per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*unesco.org*"))
GROUP BY journals.journal_id;


--- Query: 54c unesco per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*unesco.org*"))
GROUP BY files.f_year;


--- Query: 55 govuk ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*gov.uk*"));


--- Query: 55b govuk by journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*gov.uk*"))
GROUP BY journals.journal_id;


--- Query: 55c govuk per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*gov.uk*"))
GROUP BY files.f_year;


--- Query: 56 openacuk ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*open.ac.uk*"));


--- Query: 56b openacuk per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*open.ac.uk*"))
GROUP BY journals.journal_id;


--- Query: 56c openacuk per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*open.ac.uk*"))
GROUP BY files.f_year;


--- Query: 642a_all short ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*TINYURL*" OR  urls.url_link Like "*goo.gl*" OR urls.url_link Like "*bit.ly*" ));


--- Query: 642b_all per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*TINYURL*" OR  urls.url_link Like "*goo.gl*" OR urls.url_link Like "*bit.ly*" ))
GROUP BY journals.journal_id;


--- Query: 642c_all per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*bit.ly*"))
GROUP BY files.f_year;


--- Query: 643a_all googl ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*goo.gl*"));


--- Query: 643b_googl per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*goo.gl*"))
GROUP BY journals.journal_id;


--- Query: 643c_googl per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*goo.gl*"))
GROUP BY files.f_year;


--- Query: 644a_all bitly ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*bit.ly*"));


--- Query: 644b_bitly per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*bit.ly*"))
GROUP BY journals.journal_id;


--- Query: 644c_bitly per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*TINYURL*" OR  urls.url_link Like "*goo.gl*" OR urls.url_link Like "*bit.ly*" ))
GROUP BY files.f_year;


--- Query: 645_all tinyurl ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*TINYURL*"));


--- Query: 645b tinyurl per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*TINYURL*"))
GROUP BY journals.journal_id;


--- Query: 645c tinyurl per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*TINYURL*"))
GROUP BY files.f_year;


--- Query: 701a_all FB ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*facebook*"));


--- Query: 701b_fb_per_journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*facebook*"))
GROUP BY journals.journal_id;


--- Query: 701c_fb per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*facebook*"))
GROUP BY files.f_year;


--- Query: 701d_all facebook_com ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*facebook.com*"));


--- Query: 701e_fbcom per_journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*facebook.com*"))
GROUP BY journals.journal_id;


--- Query: 701f_fbcom per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*facebook.com*"))
GROUP BY files.f_year;


--- Query: 701g_all fbme ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*fb.me*"));


--- Query: 702a_all youtube ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*youtube*"));


--- Query: 702b_youtube_per_journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*youtube*"))
GROUP BY journals.journal_id;


--- Query: 702c_youtube per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*youtube*"))
GROUP BY files.f_year;


--- Query: 702d_all youtube or you_tube ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*youtube.*") or ((urls.url_link) Like "*youtu.be/*"));


--- Query: 702e_youtube or you_tube per_journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*youtube.*") or ((urls.url_link) Like "*youtu.be/*"))
GROUP BY journals.journal_id;


--- Query: 702f_youtube or you_tube per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*youtube.*") or ((urls.url_link) Like "*youtu.be/*"))
GROUP BY files.f_year;


--- Query: 702g youtube and files ---
SELECT urls.file_id, urls.url_link
FROM urls
WHERE (((urls.url_link) Like "*youtube.*") or ((urls.url_link) Like "*youtu.be/*"));


--- Query: 703a_all instagram ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*instagram*"));


--- Query: 704a_all twitter ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*twitter*")) OR (((urls.url_link) Like "*//t.co/*"));


--- Query: 704b_twitter_per_journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*twitter*"))
GROUP BY journals.journal_id;


--- Query: 704c_twitter per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*twitter*"))
GROUP BY files.f_year;


--- Query: 704d_all twitter ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*/t.co/*") or ((urls.url_link) Like "*twitter.com*"));


--- Query: 704e_twitter_tco_per_journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*/t.co/*") or ((urls.url_link) Like "*twitter.com*"))
GROUP BY journals.journal_id;


--- Query: 704f_twitter_tco per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*/t.co/*") or ((urls.url_link) Like "*twitter.com*"))
GROUP BY files.f_year;


--- Query: 704g correct twitter ---
SELECT urls.url_link, urls.file_id
FROM urls
WHERE (((urls.url_link) Like "*/t.co/*") or ((urls.url_link) Like "*twitter.com*"));


--- Query: 705a_all reddit ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*reddit*"));


--- Query: 705b_reddit per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*reddit*"))
GROUP BY files.f_year;


--- Query: 706a_all vine ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*vine.*"));


--- Query: 707a_all pinterest ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*pinterest*"));


--- Query: 708a_all askfm ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*ask.fm*"));


--- Query: 709a_all tumblr ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*tumblr*"));


--- Query: 709b_tumblr per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*tumblr*"))
GROUP BY files.f_year;


--- Query: 710a_all flickr ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*flickr*"));


--- Query: 710b_flicklr per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*flickr*"))
GROUP BY files.f_year;


--- Query: 711a_all googleplus ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*plus.google*"));


--- Query: 711b_googleplus per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*plus.google*"))
GROUP BY files.f_year;


--- Query: 712a_all google ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*google*"));


--- Query: 712b_google_per_journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*google*"))
GROUP BY journals.journal_id;


--- Query: 712c_all google per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*google*"))
GROUP BY files.f_year;


--- Query: 712d_ all google_com ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*google.*"));


--- Query: 712e_ all google_com per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*google.*"))
GROUP BY journals.journal_id;


--- Query: 712f_ all google_com per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*google.*"))
GROUP BY files.f_year;


--- Query: 712g_ all books_google ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*books.google*"));


--- Query: 712h_ all docs_google ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*docs.google*"));


--- Query: 712i_ all scholar_google ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*scholar.google*"));


--- Query: 712j_ all images_google ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*images.google*"));


--- Query: 712k_ all knol_google ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*knol.google*"));


--- Query: 712l_ all sites_google ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*sites.google*"));


--- Query: 712m_ all support_google ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*support.google*"));


--- Query: 712n_ all code_google ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*code.google*"));


--- Query: 712o_ all earth_google ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*earth.google*"));


--- Query: 712p all groups_google ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*groups.google*"));


--- Query: 712q_ all play_google ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*play.google*"));


--- Query: 712r_ all developers_google ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*developers.google*"));


--- Query: 712s_ all drive_google ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*drive.google*"));


--- Query: 712t_ all vr_google ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*vr.google*"));


--- Query: 713_ all linkedin ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*linkedin*"));


--- Query: 713b_ all linkedin_com ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*linkedin.*"));


--- Query: 713c_ all linkedin_com per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*linkedin.*"))
GROUP BY files.f_year;


--- Query: 714a_ all vk ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*vk.com*"));


--- Query: 715a_ all classmates ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*classmates*"));


--- Query: 716a_ all meetup ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*meetup*"));


--- Query: 717a_ all snapchat ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*snapchat*"));


--- Query: 718a_ all myspace ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*myspace*"));


--- Query: 719a_ all wikipedia ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*wikipedia*"));


--- Query: 719b_ all wikipedia per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*wikipedia*"))
GROUP BY journals.journal_id;


--- Query: 719c_ all wikipedia per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*wikipedia*"))
GROUP BY files.f_year;


--- Query: 719d_ all wikipedia_org ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*wikipedia.org*"));


--- Query: 719e_ all wikipedia_org per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*wikipedia.org*"))
GROUP BY journals.journal_id;


--- Query: 719f_ all wikipedia_org per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*wikipedia.org*"))
GROUP BY files.f_year;


--- Query: 720a_ all wiki no wikipedia ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*wiki*") AND ((urls.url_link) NOT Like "*wikipedia*") );


--- Query: 720b_ all wiki no wikipedia per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*wiki*") AND ((urls.url_link) NOT Like "*wikipedia*") )
GROUP BY journals.journal_id;


--- Query: 720c_ all wiki no wikipedia per journal ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*wiki*") AND ((urls.url_link) NOT Like "*wikipedia*") )
GROUP BY files.f_year;


--- Query: 721a_ all blog ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*blog*"));


--- Query: 721b_ all blog per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*blog*"))
GROUP BY journals.journal_id;


--- Query: 721c_ all blog ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*blog*"))
GROUP BY files.f_year;


--- Query: 721d_ all blogspot ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*blogspot*"));


--- Query: 721e_ all wordpress ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*wordpress*"));


--- Query: 721f_ all wordpess no blog ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*wordpress*" And (urls.url_link) Not Like "*blog*"));


--- Query: 721g worpress per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*wordpress*"))
GROUP BY journals.journal_id;


--- Query: 721h wordpress per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*wordpress*"))
GROUP BY files.f_year;


--- Query: 721i all tumblr ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*tumblr*"));


--- Query: 721j all blogger ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*blogger*"));


--- Query: 721k blogspot per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*blogspot*")) OR (((urls.url_link) Like "*blogger*"))
GROUP BY journals.journal_id;


--- Query: 721l blogspot per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*blogspot*")) OR (((urls.url_link) Like "*blogger*"))
GROUP BY files.f_year;


--- Query: 726a_ all coursera ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*coursera*"));


--- Query: 726b_ all coursera_ ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*coursera.*"));


--- Query: 726c_ all coursera_ per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*coursera.*"))
GROUP BY journals.journal_id;


--- Query: 726d_ all coursera_ per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*coursera.*"))
GROUP BY files.f_year;


--- Query: 727a_ all udemy ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*udemy*"));


--- Query: 728a_ all edx ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*edx*"));


--- Query: 728b_ all edx_ ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*edx.*"));


--- Query: 728c_ all edx_ per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*edx.*"))
GROUP BY journals.journal_id;


--- Query: 728d_ all edx_ per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*edx.*"))
GROUP BY files.f_year;


--- Query: 729a_ all udacity ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*udacity*"));


--- Query: 729b_ all udacity_ ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*udacity.*"));


--- Query: 729c_ all udacity per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*udacity.*"))
GROUP BY files.f_year;


--- Query: 730a_ all khanacademy ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*khan*") and (urls.url_link) Like "*academy*");


--- Query: 730b_ all khanacademy_org ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*khanacademy.org*"));


--- Query: 730c_ all khanacademy_org per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*khanacademy.org*"))
GROUP BY files.f_year;


--- Query: 731a_ all codeacademy ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*academy*") and (urls.url_link) Like "*code*");


--- Query: 732a_ all futurelearn ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*futurelearn*"));


--- Query: 732b_ all futurelearn_ per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*futurelearn*"))
GROUP BY files.f_year;


--- Query: 733a_ all lynda_com ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*lynda*"));


--- Query: 801a_ all edu_ ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*edu.*"));


--- Query: 801b edu per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*edu.*"))
GROUP BY journals.journal_id;


--- Query: 801c edu per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*edu.*"))
GROUP BY files.f_year;


--- Query: 802a_ all apps_ ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*apps/*") or ((urls.url_link) Like "*apps.*" ));


--- Query: 803a_ all books ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*book*"));


--- Query: 803b all books_ ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*books.*") or ((urls.url_link) Like "*books/*"));


--- Query: 803c_ all books_ per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*book*"))
GROUP BY journals.journal_id;


--- Query: 803d_ all books_ per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*book*"))
GROUP BY files.f_year;


--- Query: 804 _ac_ ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.ac.*"));


--- Query: 804b ac per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*.ac.*"))
GROUP BY journals.journal_id;


--- Query: 804c ac per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.ac.*"))
GROUP BY files.f_year;


--- Query: 805 gov ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*gov.*"));


--- Query: 805b gov per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*gov.*"))
GROUP BY journals.journal_id;


--- Query: 805c gov per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*gov.*"))
GROUP BY files.f_year;


--- Query: 806 apps ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*apps*"));


--- Query: 806b apps per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*apps*"))
GROUP BY journals.journal_id;


--- Query: 806c apps per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*apps*"))
GROUP BY files.f_year;


--- Query: 807 video ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*video*"));


--- Query: 807b video per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*video*"))
GROUP BY journals.journal_id;


--- Query: 807c video per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*video*"))
GROUP BY files.f_year;


--- Query: 808 audio ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*audio*"));


--- Query: 808b audio per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*audio*"))
GROUP BY journals.journal_id;


--- Query: 808c audio per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*audio*"))
GROUP BY files.f_year;


--- Query: 809 image ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*image*"));


--- Query: 809b image per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*image*"))
GROUP BY journals.journal_id;


--- Query: 809c image per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*image*"))
GROUP BY files.f_year;


--- Query: 810 cran ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*cran*"));


--- Query: 810b crab per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*cran*"))
GROUP BY journals.journal_id;


--- Query: 810c cran per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*cran*"))
GROUP BY files.f_year;


--- Query: 811 dspace ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*dspace*"));


--- Query: 811b dspace per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*dspace*"))
GROUP BY journals.journal_id;


--- Query: 811c dspace per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*dspace*"))
GROUP BY files.f_year;


--- Query: 812 education ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*education*"));


--- Query: 812 education per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*education*"))
GROUP BY files.f_year;


--- Query: 812b education per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*education*"))
GROUP BY journals.journal_id;


--- Query: 813 elearn ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*elearn*")) or (((urls.url_link) Like "*e-learn*"));


--- Query: 813b elearn per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*elearn*")) or (((urls.url_link) Like "*e-learn*"))
GROUP BY journals.journal_id;


--- Query: 813c elearn per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*elearn*")) or (((urls.url_link) Like "*e-learn*"))
GROUP BY files.f_year;


--- Query: 813d learn ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*learn*"));


--- Query: 813e learn per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*learn*"))
GROUP BY journals.journal_id;


--- Query: 813f learn per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*learn*"))
GROUP BY files.f_year;


--- Query: 814 faculty ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*faculty*"));


--- Query: 814b faculty per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*faculty*"))
GROUP BY journals.journal_id;


--- Query: 814c faculty per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*faculty*"))
GROUP BY files.f_year;


--- Query: 815 github ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*github*"));


--- Query: 815b github per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*github*"))
GROUP BY journals.journal_id;


--- Query: 815c github per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*github*"))
GROUP BY files.f_year;


--- Query: 901 _pdf ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.pdf*"));


--- Query: 901b _pdf per journal ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*.pdf*"))
GROUP BY journals.journal_id;


--- Query: 901c _pdf per year ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.pdf*"))
GROUP BY files.f_year;


--- Query: 901d pdf ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*pdf*"));


--- Query: 901e pdf per j ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*pdf*"))
GROUP BY journals.journal_id;


--- Query: 901f pdf per y ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*pdf*"))
GROUP BY files.f_year;


--- Query: 902 doc ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.doc*")) OR  (((urls.url_link) Like "*.docx*"));


--- Query: 902b doc per j ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*.doc*")) OR  (((urls.url_link) Like "*.docx*"))
GROUP BY journals.journal_id;


--- Query: 902c doc per y ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.doc*")) OR  (((urls.url_link) Like "*.docx*"))
GROUP BY files.f_year;


--- Query: 903 xls ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.xls*")) OR  (((urls.url_link) Like "*.xslsx*"));


--- Query: 903 xls per j ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*.xls*")) OR  (((urls.url_link) Like "*.xslsx*"))
GROUP BY journals.journal_id;


--- Query: 903c xls per y ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.xls*")) OR  (((urls.url_link) Like "*.xslsx*"))
GROUP BY files.f_year;


--- Query: 904 ppt ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.ppt*")) OR  (((urls.url_link) Like "*.pptx*"));


--- Query: 904 ppt per j ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*.ppt*")) OR  (((urls.url_link) Like "*.pptx*"))
GROUP BY journals.journal_id;


--- Query: 904 ppt per y ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.ppt*")) OR  (((urls.url_link) Like "*.pptx*"))
GROUP BY files.f_year;


--- Query: 905 htm ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.htm*"));


--- Query: 905b htm perj ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*.htm*"))
GROUP BY journals.journal_id;


--- Query: 905c htm per y ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.htm*"))
GROUP BY files.f_year;


--- Query: 906 txt ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.txt*"));


--- Query: 906 txt per j ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*.txt*"))
GROUP BY journals.journal_id;


--- Query: 906c txt per y ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.txt*"))
GROUP BY files.f_year;


--- Query: 907 php ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.php*"));


--- Query: 907b php per j ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*.php*"))
GROUP BY journals.journal_id;


--- Query: 907b php per y ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.php*"))
GROUP BY files.f_year;


--- Query: 908 asp ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.asp*"));


--- Query: 908b asp per j ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*.asp*"))
GROUP BY journals.journal_id;


--- Query: 908c asp per y ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.asp*"))
GROUP BY files.f_year;


--- Query: 909 cfm ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.cfm*"));


--- Query: 909 cfm per y ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.cfm*"))
GROUP BY files.f_year;


--- Query: 909b cfm per j ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*.cfm*"))
GROUP BY journals.journal_id;


--- Query: 910 jsp ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.jsp*"));


--- Query: 910b jsp per j ---
SELECT journals.journal_id, count(journals.journal_id)
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id
WHERE (((urls.url_link) Like "*.jsp*"))
GROUP BY journals.journal_id;


--- Query: 910c jsp per y ---
SELECT files.f_year, Count(files.f_year) AS ΠλήθοςΤουf_year
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.jsp*"))
GROUP BY files.f_year;


--- Query: ALL ---
SELECT journals.journal_id, urls.url_link
FROM (journals INNER JOIN files ON journals.journal_id = files.journal_id) INNER JOIN urls ON files.file_id = urls.file_id;


--- Query: ALL χωρίς ταιριαστό  ALL_REP ---
SELECT [ALL].journal_id, [ALL].url_link
FROM [ALL] LEFT JOIN ALL_REP ON [ALL].[url_link] = ALL_REP.[url_link]
WHERE (((ALL_REP.url_link) Is Null));


--- Query: ALL_REP ---
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*doi.*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*irrodl*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*msu.*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*ncbi*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*aamc*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*orcid*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*jstor*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*hdl.handle*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*tandfonline*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*eprints.*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*.acm.*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*wiley.com*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*springer*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*acrl.*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*eurodl*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*jolt.*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*digitalcommons*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*escholarship*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*researchgate*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*comminfolit*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*creativecommons*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*ieeexplore*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*sciencedirect*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*academia.edu*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*arxiv*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*oreilly*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*onlinelearningconsortium*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*elsevier*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*journals.lww*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*scribd*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*med-ed*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*online-journals*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*journals.cambridge*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*cloudworks*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*openmedicine.*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*pdx.*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*academic-journals*"))
UNION ALL
SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*roar*"))
UNION ALL SELECT journals.journal_id, urls.url_link
FROM journals INNER JOIN (files INNER JOIN urls ON files.file_id = urls.file_id) ON journals.journal_id = files.journal_id
WHERE (((urls.url_link) Like "*publishers.org*"));


--- Query: ALL_REP χωρίς ταιριαστό  ALL ---
SELECT ALL_REP.journal_id, ALL_REP.url_link
FROM ALL_REP LEFT JOIN [ALL] ON ALL_REP.[url_link] = [ALL].[url_link]
WHERE ((([ALL].url_link) Is Null));


--- Query: EVALUATION ---
SELECT files.file_id, count(urls.url_link)
FROM files INNER JOIN urls ON files.file_id = urls.file_id
WHERE ( files.file_id IN (1,13,28,43,64,82,98,114,134,146,158,170,181,201,220,239,270,292,314,326,346,397,456,527,613,689,778,871,944,973,1009,1037,1065,1109,1157,1203,1282,1350,1415,1443,1502,1569,1658,1752,1834,1916,1987,2046,2085,2095,2105,2115,2129,2142,2152,2164,2183,2194,2209,2221,2233,2240,2250,2257,2277,2287,2302,2348,2369,2376,2405,2444,2482,2522,2562,2602,2642,2682,2722,3283,3377,3481,3608,3783,4064,4292,4597,4859,5171,5376,5388,5400,5415,5431,5446,5462,5478,5502,5519,5526,5535,5543,5551,5559,5567,5575,5586,5599,5602,5620,5640,5669,5692,5717,5739,5762,5775,5815,5833,5848,5866,5883,5898,5916,5937,5950,5963,5981,5983,6004,6025,6053,6107,6168,6252,6329,6403,6483))
GROUP BY files.file_id;


--- Query: files01 social per j ---
SELECT files.journal_id, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*social*") )
GROUP BY files.journal_id;


--- Query: files01 social per y ---
SELECT files.f_year, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*social*") )
GROUP BY files.f_year;


--- Query: files02 media per j ---
SELECT files.journal_id, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*media*") )
GROUP BY files.journal_id;


--- Query: files02 media per y ---
SELECT files.f_year, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*media*") )
GROUP BY files.f_year;


--- Query: files03 netowrk per y ---
SELECT files.f_year, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*network*") )
GROUP BY files.f_year;


--- Query: files03 network per j ---
SELECT files.journal_id, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*network*") )
GROUP BY files.journal_id;


--- Query: files04 social media per j ---
SELECT files.journal_id, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*social*") and ((files.file_name) Like "*media*") )
GROUP BY files.journal_id;


--- Query: files04 social media per y ---
SELECT files.f_year, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*social*") and ((files.file_name) Like "*media*") )
GROUP BY files.f_year;


--- Query: files05 social network per j ---
SELECT files.journal_id, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*social*") and ((files.file_name) Like "*network*") )
GROUP BY files.journal_id;


--- Query: files05 social network per y ---
SELECT files.f_year, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*social*") and ((files.file_name) Like "*network*") )
GROUP BY files.f_year;


--- Query: files06 fb per j ---
SELECT files.journal_id, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*facebook*") )
GROUP BY files.journal_id;


--- Query: files06 fb per y ---
SELECT files.f_year, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*facebook*") )
GROUP BY files.f_year;


--- Query: files07 twitter per j ---
SELECT files.journal_id, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*twitter*") )
GROUP BY files.journal_id;


--- Query: files07 twitter per y ---
SELECT files.f_year, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*twitter*") )
GROUP BY files.f_year;


--- Query: files08 youtube per j ---
SELECT files.journal_id, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*youtube*") )
GROUP BY files.journal_id;


--- Query: files08 youtube per y ---
SELECT files.f_year, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*youtube*") )
GROUP BY files.f_year;


--- Query: files09 instagram per j ---
SELECT files.journal_id, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*instagram*") )
GROUP BY files.journal_id;


--- Query: files09 instagram per y ---
SELECT files.f_year, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*instagram*") )
GROUP BY files.f_year;


--- Query: files10 reddit per j ---
SELECT files.journal_id, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*reddit*") )
GROUP BY files.journal_id;


--- Query: files10 reddit per y ---
SELECT files.f_year, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*reddit*") )
GROUP BY files.f_year;


--- Query: files11 myspace per j ---
SELECT files.journal_id, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*myspace*") )
GROUP BY files.journal_id;


--- Query: files11 myspace per y ---
SELECT files.f_year, count(files.journal_id)
FROM files
WHERE (((files.file_name) Like "*myspace*") )
GROUP BY files.f_year;


--- Query: urls χωρίς ταιριαστό  01_all dois ---
SELECT urls.url_id, urls.url_link, urls.file_id
FROM urls LEFT JOIN [01_all dois] ON urls.[url_link] = [01_all dois].[url_link]
WHERE ((([01_all dois].url_link) Is Null));


--- Query: urls χωρίς ταιριαστό  ALL_REP ---
SELECT urls.url_id, urls.url_link, urls.file_id
FROM urls LEFT JOIN ALL_REP ON urls.[url_link] = ALL_REP.[url_link]
WHERE (((ALL_REP.url_link) Is Null));