SELECT * FROM wp_yzar_access_cat_res WHERE date = "2024-04-28"
SELECT wp_terms.*, wp_term_taxonomy.*, SUM( wp_postmeta.meta_value +0 ) AS views
FROM wp_posts
LEFT JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID
INNER JOIN wp_term_relationships ON ( wp_posts.ID = wp_term_relationships.object_id )
INNER JOIN wp_term_taxonomy ON ( wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id )
INNER JOIN wp_terms ON ( wp_term_taxonomy.term_id = wp_terms.term_id )
WHERE wp_posts.post_date < '2024-04-28 11:42:18'
AND wp_posts.post_type = 'post'
AND wp_posts.post_status = 'publish'
AND wp_posts.post_password = ''
AND wp_postmeta.meta_key = 'views'
AND wp_terms.term_id IN(2,4,5,6,7,8,9,10,11,12,13)
AND wp_term_taxonomy.taxonomy = 'category'
GROUP BY wp_terms.term_id
ORDER BY views DESC LIMIT 3
10,2,7,
DELETE FROM `wp_yzar_access_cat_res`
INSERT INTO `wp_yzar_access_cat_res`
( `res` , `date`)
VALUES
("10,2,7" , "2024-04-28");