Ebook: Science of Spices and Culinary Herbs - Latest Laboratory, Pre-clinical, and Clinical Studies Volume: 3 Year: 2020 Author(s): Bhushan P. Pimple,Amrita M. Kulkarni,Ruchita B. Bhor Doi:10.2174/97898114683601200301
Journal: Current Drug Targets Volume: 12 Issue: 1 Year: 2011 Page: 1595-1653 Author(s): Bharat B. Aggarwal, Sahdeo Prasad, Simone Reuter, Ramaswamy Kannappan, Vivek R. Yadav, Byoungduck Park, Ji Hye Kim, Subash C. Gupta, Kanokkarn Phromnoi, Chitra Sundaram, Seema Prasad, Madan M. Chaturvedi, Bokyung Sung
Ebook: The Chemistry inside Spices & Herbs: Research and Development Volume: 1 Year: 2022 Author(s): Omayma A. Eldahshan,Abdel Nasser B. Singab Doi:10.2174/9789815039566122010009
(select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >=316419989ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=316419989) 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 >=316419989ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=316419989) 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 >=316419989ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=316419989) 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 >=316419989ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=316419989) 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 >=316419989ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=316419989) 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 >=316419989ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=316419989) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >=316419989ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=316419989) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >=316419989ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=316419989) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >=316419989ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=316419989) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >=316419989ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=316419989) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >=316419989ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=316419989) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >=316419989ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=316419989) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >=316419989ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=316419989) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >=316419989ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=316419989) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >=316419989ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=316419989) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >=316419989ORDERBY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <=316419989) limit 1
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='121062'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 ='11574'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 ='3202'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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774071and j.to_date >=1740774071and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =3202) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774071and j.to_date >=1740774071and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =3202) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774071and j.to_date >=1740774071and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =3202)
(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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774071and j.to_date >=1740774071and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =11574) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774071and j.to_date >=1740774071and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =11574) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774071and j.to_date >=1740774071and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =11574)
(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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774071and j.to_date >=1740774071and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =121062) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774071and j.to_date >=1740774071and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =121062) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774071and j.to_date >=1740774071and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =121062)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='136601'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 ='13054'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 ='3544'and content_type ='v'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 ='125480'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 ebook_access
where content_type_id ='19816'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 ='3545'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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =3545) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =3545) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =3545)
(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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.chapter_id =19816) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.chapter_id =19816) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.chapter_id =19816)
selectcount(*) as total_count, content_type_access_id as access_type from ebook_access
where content_type_id ='14313'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 ='2913'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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2913) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2913) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =2913)
(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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.chapter_id =14313) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.chapter_id =14313) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.chapter_id =14313)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='20045'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 ='3710'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 ='107'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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =107) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =107) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =107)
(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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =3710) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =3710) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.issue_id =3710)
(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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =20045) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =20045) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.article_id =20045)
selectcount(*) as total_count, content_type_access_id as access_type from ebook_access
where content_type_id ='16877'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 ='3337'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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =3337) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =3337) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.volume_id =3337)
(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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.chapter_id =16877) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.chapter_id =16877) 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 <=316419989and j.to_ip >=316419989 )) and ((j.from_date <=1740774072and j.to_date >=1740774072and j.perpetual=0) or (j.from_date isnulland j.to_date isnulland j.perpetual=1)) and j.chapter_id =16877)
selectcount(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id ='82064'and content_type ='a'and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual=0) or
(from_date isnulland to_date isnulland perpetual=1)
)