Ebook: Bioactive Phytochemicals: Drug Discovery to Product Development Volume: 1 Year: 2020 Author(s): Kamran Javed Naquvi,Javed Ahamad,Raad A Kaskoos,Naila Hasan Ali Alkefai,Afrin Salma,Showkat R. Mir Doi:10.2174/9789811464485120010007
Journal: Current Drug Discovery Technologies Volume: 4 Issue: 4 Year: 2007 Page: 229-245 Author(s): Luis F. Vieira Ferreira, Isabel L. Ferreira Machado
Journal: Current Topics in Medicinal Chemistry Volume: 19 Issue: 9 Year: 2019 Page: 741-752 Author(s): ThaÑs Cailleau,Lauren R. Adams,Neha Arora,Gyoung-Dong Kang,Luke Masterson,Neki Patel,John A. Hartley,Shenlan Mao,Jay Harper,Philip W. Howard
(select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >=314545352ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_corporate WHERE to_ip >=314545352ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_token WHERE to_ip >=314545352ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_trail WHERE to_ip >=314545352ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_corporate WHERE to_ip >=314545352ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_token WHERE to_ip >=314545352ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >=314545352ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >=314545352ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >=314545352ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >=314545352ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >=314545352ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >=314545352ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >=314545352ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >=314545352ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >=314545352ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >=314545352ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314545352) limit 1
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='87502'and content_type ='a'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='8448'and content_type ='i'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='2329'and content_type ='v'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2329) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2329) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2329)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =8448) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =8448) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =8448)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =87502) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =87502) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =87502)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='59265'and content_type ='a'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='5654'and content_type ='i'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='1361'and content_type ='v'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =1361) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =1361) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =1361)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =5654) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =5654) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =5654)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =59265) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =59265) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =59265)
selectcount(*) as total_count, content_type_access_id as access_type from ebook_access
where content_type_id ='14166'and content_type ='c'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from ebook_access
where content_type_id ='2899'and content_type ='v'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2899) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2899) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2899)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.chapter_id =14166) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.chapter_id =14166) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.chapter_id =14166)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='120060'and content_type ='a'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='11752'and content_type ='i'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='3224'and content_type ='v'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =3224) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =3224) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =3224)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =11752) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =11752) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =11752)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =120060) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =120060) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =120060)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='37380'and content_type ='a'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='869'and content_type ='i'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='579'and content_type ='v'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =579) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =579) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =579)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =869) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =869) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =869)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =37380) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =37380) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =37380)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='97707'and content_type ='a'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='9158'and content_type ='i'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='2599'and content_type ='v'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2599) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2599) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2599)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =9158) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =9158) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =9158)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =97707) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =97707) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774238and j.to_date >=1740774238and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =97707)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='78917'and content_type ='a'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='7389'and content_type ='i'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='1816'and content_type ='v'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =1816) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =1816) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =1816)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =7389) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =7389) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =7389)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =78917) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =78917) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =78917)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='128802'and content_type ='a'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='12473'and content_type ='i'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='3409'and content_type ='v'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =3409) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =3409) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =3409)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =12473) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =12473) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =12473)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =128802) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =128802) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =128802)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='99609'and content_type ='a'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='9485'and content_type ='i'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='2584'and content_type ='v'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2584) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2584) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2584)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =9485) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =9485) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =9485)
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN111THENtrueELSEfalseENDas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =99609) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
falseas terms_popup,
"S" as content_download_type,
nullas restricted_user_access_key,
nullas restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_corporate` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =99609) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
falseas terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN0THENfalseELSEtrueENDas tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_token` as `j` innerjoin `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <=314545352and j.to_ip >=314545352 )) and ((j.from_date <=1740774239and j.to_date >=1740774239and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =99609)