SELECT * FROM wp_yzar_access_res WHERE date = "2025-07-01"

		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" , "[\"61183\",\"61157\",\"61005\",\"60914\",\"60413\",\"58368\",\"56876\",\"53983\",\"52785\",\"46633\",\"31954\",\"28043\"]" , "2025-07-01");
	

		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" , "[\"62655\",\"61884\",\"61816\",\"61599\",\"61558\",\"61394\",\"61183\",\"61157\",\"61005\",\"60989\",\"60914\",\"60730\",\"60635\",\"60477\",\"60413\",\"59117\",\"58368\",\"58226\",\"58209\",\"58154\"]" , "2025-07-01");
	

		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" , "[\"63239\",\"63212\",\"63177\",\"61985\",\"61486\",\"61453\",\"61406\",\"60413\",\"53950\",\"53862\",\"53811\",\"52785\",\"51353\",\"51030\",\"40513\",\"34596\",\"19611\",\"63147\",\"63122\",\"63071\"]" , "2025-07-01");
	

		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\"]" , "2025-07-01");
	

		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" , "[\"60944\",\"52352\"]" , "2025-07-01");
	

		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" , "[\"62994\",\"62148\",\"61165\",\"60944\",\"60920\",\"60342\",\"59385\",\"58525\",\"57419\",\"57309\",\"52352\",\"51637\",\"50115\",\"44960\",\"40537\",\"40232\",\"27929\",\"12796\"]" , "2025-07-01");
	

		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" , "[\"63243\",\"62994\",\"62921\",\"60574\",\"52352\",\"40606\",\"63248\",\"63237\",\"62982\",\"62966\",\"62963\",\"62861\",\"62851\",\"62839\",\"62765\",\"62721\",\"62717\",\"61787\",\"61607\",\"61408\"]" , "2025-07-01");
	

		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\"]" , "2025-07-01");
	

		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" , "null" , "2025-07-01");
	

		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" , "[\"60519\",\"51124\",\"42985\",\"26967\",\"16334\"]" , "2025-07-01");
	

		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\",\"42985\",\"15992\",\"13854\",\"63109\",\"60311\",\"59568\",\"59307\",\"56722\",\"54736\",\"54414\",\"53283\",\"51745\",\"50377\",\"48971\",\"46596\",\"43829\",\"42116\",\"40816\",\"40503\"]" , "2025-07-01");
	

		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\"]" , "2025-07-01");
	

		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" , "[\"47079\"]" , "2025-07-01");
	

		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" , "[\"47079\",\"39193\",\"13470\"]" , "2025-07-01");
	

		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" , "[\"61775\",\"61477\",\"54310\",\"53424\",\"49865\",\"47079\",\"39697\",\"36754\",\"27651\",\"16326\",\"14615\",\"14541\",\"13436\",\"62319\",\"62209\",\"62140\",\"62007\",\"61994\",\"61678\",\"60042\"]" , "2025-07-01");
	

		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\",\"20373\",\"35527\"]" , "2025-07-01");
	

		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" , "[\"63046\",\"61149\",\"37653\"]" , "2025-07-01");
	

		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" , "[\"29373\",\"63046\",\"62211\",\"61814\",\"61586\",\"61149\",\"60233\",\"48649\",\"45093\",\"44834\",\"39350\",\"37653\",\"34050\",\"25318\",\"22657\",\"16923\"]" , "2025-07-01");
	

		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\",\"63046\",\"23717\",\"63186\",\"63140\",\"63093\",\"62988\",\"62906\",\"61087\",\"60297\",\"60233\",\"58538\",\"55974\",\"55502\",\"54910\",\"54133\",\"53597\",\"50673\",\"50438\"]" , "2025-07-01");
	

		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\",\"39162\",\"20917\",\"34050\",\"19719\",\"50097\",\"22764\",\"15974\",\"13949\",\"51660\"]" , "2025-07-01");
	

		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" , "[\"15387\"]" , "2025-07-01");
	

		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" , "[\"15387\"]" , "2025-07-01");
	

		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\",\"63035\",\"15387\",\"62265\",\"42584\",\"37272\",\"31755\",\"13459\",\"5972\",\"5238\",\"60492\",\"50761\",\"49620\",\"49147\",\"43841\",\"36882\",\"31815\",\"27645\",\"26748\",\"22230\"]" , "2025-07-01");
	

		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\",\"13459\",\"14188\",\"7807\",\"14563\",\"15387\",\"22230\",\"32337\",\"14204\",\"14694\",\"2751\",\"5238\",\"14534\"]" , "2025-07-01");
	

		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" , "[\"62479\",\"48393\"]" , "2025-07-01");
	

		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" , "[\"62479\",\"48393\",\"29265\",\"21697\",\"20819\",\"20423\",\"16441\",\"13440\"]" , "2025-07-01");
	

		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\",\"24398\",\"62817\",\"62805\",\"62761\",\"62756\",\"62644\",\"62637\",\"62510\",\"62354\",\"62243\",\"62088\",\"54854\",\"50424\",\"49126\",\"49054\",\"47476\",\"46938\",\"42592\",\"41877\"]" , "2025-07-01");
	

		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\"]" , "2025-07-01");
	

		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" , "[\"63228\",\"45975\",\"44611\"]" , "2025-07-01");
	

		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" , "[\"63228\",\"62314\",\"62047\",\"61830\",\"61626\",\"58316\",\"58012\",\"57724\",\"50402\",\"49697\",\"49119\",\"45975\",\"44611\",\"44354\",\"41019\",\"39385\",\"29574\",\"29566\",\"29396\",\"29127\"]" , "2025-07-01");
	

		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" , "[\"63195\",\"63173\",\"63064\",\"58340\",\"44354\",\"63228\",\"63210\",\"63138\",\"63106\",\"63017\",\"62789\",\"62738\",\"62334\",\"62323\",\"61892\",\"61451\",\"61416\",\"61060\",\"60950\",\"60908\"]" , "2025-07-01");
	

		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\"]" , "2025-07-01");
	

		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" , "2025-07-01");
	

		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" , "[\"47256\",\"19657\"]" , "2025-07-01");
	

		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" , "[\"32969\",\"48058\",\"47449\",\"47256\",\"30117\",\"28717\",\"21186\",\"20888\",\"20154\",\"19653\",\"19619\",\"57681\",\"55130\",\"50746\",\"50411\",\"48210\",\"45912\",\"45106\",\"44443\",\"42050\"]" , "2025-07-01");
	

		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\"]" , "2025-07-01");
	

		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" , "2025-07-01");
	

		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" , "2025-07-01");
	

		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" , "[\"27439\",\"27435\",\"17941\"]" , "2025-07-01");
	

		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\"]" , "2025-07-01");
	

		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" , "2025-07-01");
	

		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" , "null" , "2025-07-01");
	

		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\",\"57938\",\"49746\",\"49044\",\"41478\",\"58183\",\"56325\",\"54713\",\"53698\",\"50084\",\"48893\",\"47461\",\"45900\",\"43494\",\"39605\"]" , "2025-07-01");
	

		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\",\"56325\",\"55154\",\"57269\",\"55338\"]" , "2025-07-01");
	

		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" , "2025-07-01");
	

		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" , "[\"54509\"]" , "2025-07-01");
	

		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" , "[\"54509\"]" , "2025-07-01");
	

		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\"]" , "2025-07-01");
	

		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" , "[\"63228\",\"63046\",\"62479\",\"61183\",\"61157\",\"61149\",\"61005\",\"60944\",\"60914\",\"60413\",\"58368\",\"56876\",\"53983\",\"52785\",\"52352\",\"48393\",\"47079\",\"46633\",\"45975\",\"44611\"]" , "2025-07-01");
	

		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" , "[\"29373\",\"63228\",\"63046\",\"62994\",\"62655\",\"62479\",\"62314\",\"62211\",\"62148\",\"62047\",\"61884\",\"61830\",\"61816\",\"61814\",\"61626\",\"61599\",\"61586\",\"61558\",\"61394\",\"61183\"]" , "2025-07-01");
	

		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" , "[\"63195\",\"34050\",\"29373\",\"14236\",\"63243\",\"63239\",\"63212\",\"63201\",\"63177\",\"63173\",\"63064\",\"63046\",\"63035\",\"62994\",\"62921\",\"61985\",\"61566\",\"61486\",\"61453\",\"61406\"]" , "2025-07-01");
	

		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\"]" , "2025-07-01");