amp views

Hi,

I want to know how to get every amp page views from database of the plugin if there is one. I wrote my own sql code to bring the other post views using a statistics plugin but I need to add the amp views to get the total views.

my sql code was:

SELECT u.user_login AS Author, p.post_title AS title, p.post_date As date, SUM(pop.pageviews) as post_views
from _DJG_posts as p
INNER JOIN _DJG_users as u ON u.ID = p.post_author AND p.post_date > '2022-01-01 00:00:00' AND p.post_date < '2022-02-28 00:00:00' AND p.post_type = 'post' AND p.post_title != 'مسودة تلقائية' AND p.post_title != 'Auto Draft'
INNER JOIN _DJG_popularpostsdata as pop ON p.ID = pop.postid

GROUP BY title
ORDER BY post_views DESC

How can I add the amp views to it? please, give me database name but if you can edit the code, it will be helpful too.

Thanks

The page I need help with: [log in to see the link]