SELECT * FROM wp_yzar_access_res WHERE date = "2024-04-28"

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 1 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "life-style" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "life-style") AND (`term` = "DAY"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("life-style" , "DAY" , "[\"61609\",\"61205\",\"60679\",\"59852\",\"58529\",\"58416\",\"58370\",\"58020\",\"57650\",\"57332\",\"55891\",\"54065\",\"52465\",\"52238\",\"52043\",\"51326\",\"49138\",\"48719\",\"48538\",\"48454\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 6 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "life-style" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "life-style") AND (`term` = "WEEK"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("life-style" , "WEEK" , "[\"57332\",\"56958\",\"48538\",\"61609\",\"61205\",\"60728\",\"60679\",\"60130\",\"59852\",\"59389\",\"58529\",\"58416\",\"58370\",\"58020\",\"57650\",\"55891\",\"55465\",\"54314\",\"54065\",\"52465\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 29 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "life-style" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "life-style") AND (`term` = "MONTH"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("life-style" , "MONTH" , "[\"60130\",\"48538\",\"19081\",\"55891\",\"54340\",\"51714\",\"32433\",\"62055\",\"60728\",\"59098\",\"58150\",\"58043\",\"58003\",\"57715\",\"57332\",\"57256\",\"56958\",\"56883\",\"56775\",\"56762\"]" , "2024-04-28");
	

		SELECT WPM.meta_value AS cnt , WP.ID AS id 
		FROM wp_posts AS WP 
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "life-style" 
		INNER JOIN wp_postmeta AS WPM ON WPM.post_id = WP.ID 
			AND WPM.meta_key = "views"
		WHERE 1=1
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		GROUP BY id
		ORDER BY CAST(WPM.meta_value AS SIGNED) DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "life-style") AND (`term` = "ALL"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("life-style" , "ALL" , "[\"22445\",\"19611\",\"21449\",\"21479\",\"19507\",\"22191\",\"36239\",\"23024\",\"32827\",\"20018\",\"33521\",\"41171\",\"40441\",\"45633\",\"37999\",\"43631\",\"26842\",\"37058\",\"37617\",\"33550\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 1 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "business" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "business") AND (`term` = "DAY"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("business" , "DAY" , "[\"47092\",\"48382\",\"48003\",\"47500\",\"47094\",\"46263\",\"45787\",\"43776\",\"40537\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 6 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "business" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "business") AND (`term` = "WEEK"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("business" , "WEEK" , "[\"62187\",\"47092\",\"46020\",\"61990\",\"51495\",\"48382\",\"48003\",\"47619\",\"47500\",\"47227\",\"47147\",\"47094\",\"46263\",\"46250\",\"45849\",\"45824\",\"45787\",\"45501\",\"45499\",\"45233\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 29 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "business" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "business") AND (`term` = "MONTH"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("business" , "MONTH" , "[\"62187\",\"53483\",\"52930\",\"52553\",\"52031\",\"50361\",\"47092\",\"46020\",\"22696\",\"63237\",\"62292\",\"62109\",\"61990\",\"59967\",\"58545\",\"57740\",\"57554\",\"57396\",\"57327\",\"57264\"]" , "2024-04-28");
	

		SELECT WPM.meta_value AS cnt , WP.ID AS id 
		FROM wp_posts AS WP 
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "business" 
		INNER JOIN wp_postmeta AS WPM ON WPM.post_id = WP.ID 
			AND WPM.meta_key = "views"
		WHERE 1=1
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		GROUP BY id
		ORDER BY CAST(WPM.meta_value AS SIGNED) DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "business") AND (`term` = "ALL"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("business" , "ALL" , "[\"21084\",\"22949\",\"48979\",\"51106\",\"30872\",\"18874\",\"44362\",\"41254\",\"19540\",\"47061\",\"18883\",\"48591\",\"27660\",\"50625\",\"24319\",\"41631\",\"48746\",\"50487\",\"47600\",\"47174\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 1 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "fashion" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "fashion") AND (`term` = "DAY"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("fashion" , "DAY" , "[\"15937\",\"52970\",\"43829\",\"34808\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 6 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "fashion" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "fashion") AND (`term` = "WEEK"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("fashion" , "WEEK" , "[\"15937\",\"63201\",\"52970\",\"43829\",\"34808\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 29 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "fashion" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "fashion") AND (`term` = "MONTH"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("fashion" , "MONTH" , "[\"63201\",\"15937\",\"34808\",\"62122\",\"61227\",\"57122\",\"55901\",\"52970\",\"43829\",\"38757\",\"35232\",\"35161\",\"34719\",\"25607\",\"22679\",\"18170\",\"16162\",\"16013\",\"15798\",\"15644\"]" , "2024-04-28");
	

		SELECT WPM.meta_value AS cnt , WP.ID AS id 
		FROM wp_posts AS WP 
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "fashion" 
		INNER JOIN wp_postmeta AS WPM ON WPM.post_id = WP.ID 
			AND WPM.meta_key = "views"
		WHERE 1=1
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		GROUP BY id
		ORDER BY CAST(WPM.meta_value AS SIGNED) DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "fashion") AND (`term` = "ALL"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("fashion" , "ALL" , "[\"18393\",\"23743\",\"23125\",\"16490\",\"22520\",\"15798\",\"15035\",\"16233\",\"3374\",\"23151\",\"19069\",\"14850\",\"23848\",\"16783\",\"13562\",\"12657\",\"34019\",\"23762\",\"40816\",\"15030\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 1 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "gourmet" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "gourmet") AND (`term` = "DAY"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("gourmet" , "DAY" , "[\"59692\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 6 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "gourmet" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "gourmet") AND (`term` = "WEEK"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("gourmet" , "WEEK" , "[\"61834\",\"59692\",\"44715\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 29 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "gourmet" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "gourmet") AND (`term` = "MONTH"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("gourmet" , "MONTH" , "[\"59692\",\"62319\",\"61834\",\"57863\",\"57542\",\"54794\",\"54226\",\"46597\",\"44715\",\"22695\",\"16326\",\"15435\",\"15057\",\"14891\",\"13555\",\"13470\"]" , "2024-04-28");
	

		SELECT WPM.meta_value AS cnt , WP.ID AS id 
		FROM wp_posts AS WP 
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "gourmet" 
		INNER JOIN wp_postmeta AS WPM ON WPM.post_id = WP.ID 
			AND WPM.meta_key = "views"
		WHERE 1=1
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		GROUP BY id
		ORDER BY CAST(WPM.meta_value AS SIGNED) DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "gourmet") AND (`term` = "ALL"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("gourmet" , "ALL" , "[\"21314\",\"23131\",\"24891\",\"19405\",\"31837\",\"26769\",\"31309\",\"43220\",\"42522\",\"36463\",\"16583\",\"16351\",\"14891\",\"21933\",\"15052\",\"13690\",\"16326\",\"21300\",\"22695\",\"20373\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 1 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "body-care" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "body-care") AND (`term` = "DAY"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("body-care" , "DAY" , "[\"46583\",\"46836\",\"46546\",\"44497\",\"44046\",\"37706\",\"34050\",\"28691\",\"13553\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 6 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "body-care" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "body-care") AND (`term` = "WEEK"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("body-care" , "WEEK" , "[\"54770\",\"46583\",\"34050\",\"29373\",\"13553\",\"63093\",\"47512\",\"47244\",\"46836\",\"46546\",\"46123\",\"46062\",\"46061\",\"45914\",\"45832\",\"45508\",\"45414\",\"44721\",\"44497\",\"44046\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 29 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "body-care" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "body-care") AND (`term` = "MONTH"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("body-care" , "MONTH" , "[\"34050\",\"29373\",\"13553\",\"37706\",\"56001\",\"55949\",\"54770\",\"51546\",\"46583\",\"39655\",\"37682\",\"32304\",\"32092\",\"29330\",\"63093\",\"56364\",\"56112\",\"55994\",\"55916\",\"55874\"]" , "2024-04-28");
	

		SELECT WPM.meta_value AS cnt , WP.ID AS id 
		FROM wp_posts AS WP 
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "body-care" 
		INNER JOIN wp_postmeta AS WPM ON WPM.post_id = WP.ID 
			AND WPM.meta_key = "views"
		WHERE 1=1
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		GROUP BY id
		ORDER BY CAST(WPM.meta_value AS SIGNED) DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "body-care") AND (`term` = "ALL"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("body-care" , "ALL" , "[\"23523\",\"26668\",\"26657\",\"40578\",\"42017\",\"17187\",\"19256\",\"24874\",\"19663\",\"50849\",\"38353\",\"20917\",\"39162\",\"34050\",\"19719\",\"50097\",\"22764\",\"15974\",\"13949\",\"39053\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 1 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "hair-care" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "hair-care") AND (`term` = "DAY"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("hair-care" , "DAY" , "[\"13459\",\"12897\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 6 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "hair-care" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "hair-care") AND (`term` = "WEEK"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("hair-care" , "WEEK" , "[\"13459\",\"14236\",\"12897\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 29 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "hair-care" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "hair-care") AND (`term` = "MONTH"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("hair-care" , "MONTH" , "[\"14236\",\"13459\",\"14204\",\"12897\"]" , "2024-04-28");
	

		SELECT WPM.meta_value AS cnt , WP.ID AS id 
		FROM wp_posts AS WP 
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "hair-care" 
		INNER JOIN wp_postmeta AS WPM ON WPM.post_id = WP.ID 
			AND WPM.meta_key = "views"
		WHERE 1=1
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		GROUP BY id
		ORDER BY CAST(WPM.meta_value AS SIGNED) DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "hair-care") AND (`term` = "ALL"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("hair-care" , "ALL" , "[\"12897\",\"45483\",\"5972\",\"27873\",\"14634\",\"20846\",\"14236\",\"10203\",\"14188\",\"7807\",\"14563\",\"13459\",\"15387\",\"22230\",\"32337\",\"14204\",\"14694\",\"2751\",\"5238\",\"14534\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 1 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "health-care" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "health-care") AND (`term` = "DAY"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("health-care" , "DAY" , "[\"46944\",\"37857\",\"21697\",\"15232\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 6 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "health-care" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "health-care") AND (`term` = "WEEK"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("health-care" , "WEEK" , "[\"37857\",\"57086\",\"46944\",\"31816\",\"21697\",\"15232\",\"12548\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 29 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "health-care" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "health-care") AND (`term` = "MONTH"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("health-care" , "MONTH" , "[\"37857\",\"31816\",\"57086\",\"62088\",\"27387\",\"21697\",\"12349\",\"62817\",\"62756\",\"62203\",\"49557\",\"47633\",\"46944\",\"35682\",\"25631\",\"15232\",\"13947\",\"12548\",\"374\"]" , "2024-04-28");
	

		SELECT WPM.meta_value AS cnt , WP.ID AS id 
		FROM wp_posts AS WP 
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "health-care" 
		INNER JOIN wp_postmeta AS WPM ON WPM.post_id = WP.ID 
			AND WPM.meta_key = "views"
		WHERE 1=1
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		GROUP BY id
		ORDER BY CAST(WPM.meta_value AS SIGNED) DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "health-care") AND (`term` = "ALL"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("health-care" , "ALL" , "[\"25631\",\"27200\",\"21697\",\"20384\",\"10396\",\"27387\",\"24274\",\"1642\",\"13650\",\"4580\",\"27687\",\"20423\",\"14167\",\"13910\",\"2798\",\"11668\",\"35509\",\"21757\",\"22307\",\"19565\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 1 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "mote" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "mote") AND (`term` = "DAY"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("mote" , "DAY" , "[\"44966\",\"62138\",\"50904\",\"50465\",\"49119\",\"48868\",\"48085\",\"47255\",\"46547\",\"44462\",\"16726\",\"16371\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 6 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "mote" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "mote") AND (`term` = "WEEK"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("mote" , "WEEK" , "[\"44966\",\"62138\",\"63040\",\"61996\",\"50904\",\"50465\",\"50353\",\"49119\",\"48868\",\"48085\",\"47268\",\"47255\",\"47093\",\"46547\",\"45713\",\"45476\",\"44462\",\"40312\",\"34095\",\"21222\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 29 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "mote" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "mote") AND (`term` = "MONTH"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("mote" , "MONTH" , "[\"50353\",\"16726\",\"62138\",\"44966\",\"49119\",\"49040\",\"34095\",\"63040\",\"62365\",\"61996\",\"61764\",\"61132\",\"60867\",\"59806\",\"59405\",\"58158\",\"57975\",\"57909\",\"57724\",\"57663\"]" , "2024-04-28");
	

		SELECT WPM.meta_value AS cnt , WP.ID AS id 
		FROM wp_posts AS WP 
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "mote" 
		INNER JOIN wp_postmeta AS WPM ON WPM.post_id = WP.ID 
			AND WPM.meta_key = "views"
		WHERE 1=1
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		GROUP BY id
		ORDER BY CAST(WPM.meta_value AS SIGNED) DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "mote") AND (`term` = "ALL"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("mote" , "ALL" , "[\"18925\",\"21991\",\"20137\",\"20818\",\"16726\",\"23732\",\"23852\",\"23468\",\"20124\",\"20402\",\"23175\",\"19929\",\"19477\",\"24177\",\"21650\",\"23476\",\"23359\",\"22638\",\"20142\",\"19517\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 1 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "supplement" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "supplement") AND (`term` = "DAY"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("supplement" , "DAY" , "null" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 6 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "supplement" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "supplement") AND (`term` = "WEEK"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("supplement" , "WEEK" , "[\"46959\",\"21815\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 29 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "supplement" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "supplement") AND (`term` = "MONTH"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("supplement" , "MONTH" , "[\"46959\",\"54848\",\"50746\",\"50411\",\"50158\",\"28717\",\"27675\",\"27132\",\"26456\",\"23951\",\"21815\",\"21626\",\"18992\",\"17136\"]" , "2024-04-28");
	

		SELECT WPM.meta_value AS cnt , WP.ID AS id 
		FROM wp_posts AS WP 
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "supplement" 
		INNER JOIN wp_postmeta AS WPM ON WPM.post_id = WP.ID 
			AND WPM.meta_key = "views"
		WHERE 1=1
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		GROUP BY id
		ORDER BY CAST(WPM.meta_value AS SIGNED) DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "supplement") AND (`term` = "ALL"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("supplement" , "ALL" , "[\"27591\",\"27565\",\"21186\",\"28717\",\"21786\",\"29929\",\"20154\",\"10905\",\"8158\",\"5800\",\"18956\",\"34621\",\"32759\",\"27208\",\"28112\",\"18946\",\"28272\",\"15763\",\"14020\",\"24861\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 1 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "feature" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "feature") AND (`term` = "DAY"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("feature" , "DAY" , "null" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 6 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "feature" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "feature") AND (`term` = "WEEK"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("feature" , "WEEK" , "null" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 29 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "feature" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "feature") AND (`term` = "MONTH"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("feature" , "MONTH" , "null" , "2024-04-28");
	

		SELECT WPM.meta_value AS cnt , WP.ID AS id 
		FROM wp_posts AS WP 
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "feature" 
		INNER JOIN wp_postmeta AS WPM ON WPM.post_id = WP.ID 
			AND WPM.meta_key = "views"
		WHERE 1=1
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		GROUP BY id
		ORDER BY CAST(WPM.meta_value AS SIGNED) DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "feature") AND (`term` = "ALL"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("feature" , "ALL" , "[\"17880\",\"17941\",\"27439\",\"62144\",\"27424\",\"27435\",\"43492\",\"55276\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 1 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "yaziupclub" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "yaziupclub") AND (`term` = "DAY"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("yaziupclub" , "DAY" , "null" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 6 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "yaziupclub" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "yaziupclub") AND (`term` = "WEEK"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("yaziupclub" , "WEEK" , "[\"47461\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 29 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "yaziupclub" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "yaziupclub") AND (`term` = "MONTH"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("yaziupclub" , "MONTH" , "[\"61566\",\"49044\",\"47461\"]" , "2024-04-28");
	

		SELECT WPM.meta_value AS cnt , WP.ID AS id 
		FROM wp_posts AS WP 
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "yaziupclub" 
		INNER JOIN wp_postmeta AS WPM ON WPM.post_id = WP.ID 
			AND WPM.meta_key = "views"
		WHERE 1=1
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		GROUP BY id
		ORDER BY CAST(WPM.meta_value AS SIGNED) DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "yaziupclub") AND (`term` = "ALL"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("yaziupclub" , "ALL" , "[\"41478\",\"47461\",\"42648\",\"39605\",\"38277\",\"36367\",\"49044\",\"50084\",\"48893\",\"45900\",\"49746\",\"50933\",\"54713\",\"43494\",\"53698\",\"54956\",\"55154\",\"56325\",\"57269\",\"55338\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 1 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "secondhouse" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "secondhouse") AND (`term` = "DAY"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("secondhouse" , "DAY" , "null" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 6 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "secondhouse" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "secondhouse") AND (`term` = "WEEK"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("secondhouse" , "WEEK" , "null" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 29 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "secondhouse" 
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "secondhouse") AND (`term` = "MONTH"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("secondhouse" , "MONTH" , "null" , "2024-04-28");
	

		SELECT WPM.meta_value AS cnt , WP.ID AS id 
		FROM wp_posts AS WP 
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			 AND WT.slug = "secondhouse" 
		INNER JOIN wp_postmeta AS WPM ON WPM.post_id = WP.ID 
			AND WPM.meta_key = "views"
		WHERE 1=1
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		GROUP BY id
		ORDER BY CAST(WPM.meta_value AS SIGNED) DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "secondhouse") AND (`term` = "ALL"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("secondhouse" , "ALL" , "[\"54509\",\"54437\",\"54869\",\"55030\",\"54902\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 1 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "ALL") AND (`term` = "DAY"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("ALL" , "DAY" , "[\"47092\",\"46583\",\"44966\",\"15937\",\"62138\",\"61609\",\"61205\",\"60679\",\"59852\",\"59692\",\"58529\",\"58416\",\"58370\",\"58020\",\"57650\",\"57332\",\"55891\",\"54065\",\"52970\",\"52465\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 6 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "ALL") AND (`term` = "WEEK"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("ALL" , "WEEK" , "[\"44966\",\"37857\",\"62187\",\"62138\",\"57332\",\"56958\",\"54770\",\"48538\",\"47092\",\"46583\",\"46020\",\"34050\",\"29373\",\"15937\",\"13553\",\"13459\",\"63201\",\"63093\",\"63040\",\"61996\"]" , "2024-04-28");
	

		SELECT WL.cnt AS cnt , WP.ID AS id 
		FROM (
			SELECT COUNT(post_id) as cnt , post_id
				FROM wp_yzar_access_log
			WHERE 1=1 
				 AND access_date BETWEEN (NOW() - INTERVAL 29 DAY) AND NOW() 
			GROUP BY post_id
			ORDER BY cnt DESC 
		) AS WL
		INNER JOIN wp_posts AS WP ON WP.ID = WL.post_id 
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			
		GROUP BY id
		ORDER BY cnt DESC , id DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "ALL") AND (`term` = "MONTH"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("ALL" , "MONTH" , "[\"37857\",\"60130\",\"34050\",\"29373\",\"13553\",\"50353\",\"48538\",\"31816\",\"19081\",\"16726\",\"14236\",\"13459\",\"63201\",\"62138\",\"57086\",\"55891\",\"54340\",\"51714\",\"44966\",\"37706\"]" , "2024-04-28");
	

		SELECT WPM.meta_value AS cnt , WP.ID AS id 
		FROM wp_posts AS WP 
		INNER JOIN wp_term_relationships AS WTR ON WTR.object_id = WP.ID 
		INNER JOIN wp_term_taxonomy AS WTT ON WTT.term_taxonomy_id = WTR.term_taxonomy_id 
			AND WTT.taxonomy = "category"
			AND WTT.parent = 0
		INNER JOIN wp_terms AS WT ON WT.term_id = WTT.term_id 
			
		INNER JOIN wp_postmeta AS WPM ON WPM.post_id = WP.ID 
			AND WPM.meta_key = "views"
		WHERE 1=1
			AND WP.post_type = "post" 
			AND WP.post_status = "publish"
		GROUP BY id
		ORDER BY CAST(WPM.meta_value AS SIGNED) DESC
		LIMIT 0,20 
		

	DELETE FROM `wp_yzar_access_res`
	WHERE ((`category` = "ALL") AND (`term` = "ALL"))
	

	INSERT INTO `wp_yzar_access_res`
	(`category` , `term` , `res` , `date`)
	 VALUES 
	("ALL" , "ALL" , "[\"18925\",\"22445\",\"21991\",\"20137\",\"20818\",\"16726\",\"23732\",\"23852\",\"23468\",\"20124\",\"20402\",\"23175\",\"19929\",\"19477\",\"24177\",\"21650\",\"23476\",\"19611\",\"23359\",\"22638\"]" , "2024-04-28");