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 Analytical Chemistry Volume: 8 Issue: 1 Year: 2012 Page: 159-167 Author(s): Shaodong Jia, Hee-Seung Lee, Myung-Joo Choi, Sang Hyun Sung, Sang B. Han, Jeong H. Park, Soon-Sun Hong, Sung W. Kwon, Jeongmi Lee
Journal: Combinatorial Chemistry & High Throughput Screening Volume: 14 Issue: 4 Year: 2011 Page: 267-278 Author(s): Tor Regberg, Charlotta Lindquist, Ake Pilotti, Christel Ellstrom, Lars Fagerstam, Ann Eckersten, Yasuro Shinohara, Steven L. Gallion, Joseph C. Hogan
(select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >=314340157ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314340157) 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 >=314340157ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314340157) 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 >=314340157ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314340157) 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 >=314340157ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314340157) 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 >=314340157ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314340157) 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 >=314340157ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >=314340157ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >=314340157ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >=314340157ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >=314340157ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >=314340157ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >=314340157ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >=314340157ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >=314340157ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >=314340157ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >=314340157ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=314340157) limit 1
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='5579'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 ='1204'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 ='21'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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =21) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =21) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =21)
(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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =1204) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =1204) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =1204)
(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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =5579) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =5579) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =5579)
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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 ='68987'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 ='6523'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 ='1666'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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =1666) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =1666) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =1666)
(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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =6523) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =6523) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =6523)
(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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =68987) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =68987) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =68987)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='17720'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 ='3306'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 ='64'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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =64) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =64) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =64)
(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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =3306) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =3306) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =3306)
(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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =17720) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =17720) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =17720)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='81343'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 ='7924'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 ='2036'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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2036) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2036) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2036)
(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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =7924) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =7924) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =7924)
(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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =81343) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =81343) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =81343)
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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and 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 journal_access
where content_type_id ='20902'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 ='4271'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 ='26'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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =26) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =26) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =26)
(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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =4271) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =4271) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =4271)
(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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =20902) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =20902) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =20902)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='18691'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 ='3928'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 ='65'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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =65) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =65) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =65)
(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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =3928) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =3928) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =3928)
(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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =18691) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =18691) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =18691)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='71965'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 ='7266'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 ='1762'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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =1762) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =1762) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =1762)
(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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =7266) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =7266) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =7266)
(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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =71965) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =71965) 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 <=314340157and j.to_ip >=314340157 )) and ((j.from_date <=1740775934and j.to_date >=1740775934and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =71965)