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 09:00:09'
	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
	

	DELETE FROM `wp_yzar_access_cat_res`

	

	INSERT INTO `wp_yzar_access_cat_res`

	( `res` , `date`)

	 VALUES 

	("10,2,7" , "2024-04-28");