View tariqa3.app_log_pagesaccessperyear | Generated by SchemaSpy |
View Definition:
select year(`d`.`time`) AS `Year`,`d`.`value` AS `Page`,count(`d`.`value`) AS `Accessed` from (`tariqa3`.`app_log_details` `d` join `tariqa3`.`app_log` `l` on((`d`.`log_id` = `l`.`log_id`))) where ((`d`.`key` = 'module') and (`access_type`(`l`.`url`) = 'page') and (not(`operator`(`l`.`user_id`)))) group by 1,2 order by 1,2 desc
Possibly Referenced Tables/Views: