Ok, now I am also getting this error all the time. I didn’t realize until I check the logs today. It seems to be related to the XML Sitemaps plugin.
The things I did before this was updating WP to v6.0 and WC to v6.5.1. The version of the XML Sitemaps plugin is v4.1.3.
[29-May-2022 02:41:07 UTC] WordPress database error Unknown column 'product' in 'where clause' for query SELECT
COUNT(*)
FROM
td_posts p
WHERE
p.post_password = ''
AND p.post_type = product
AND p.post_status = 'publish'
AND p.ID NOT IN (1672) made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, GoogleSitemapGeneratorLoader::do_template_redirect, GoogleSitemapGeneratorLoader::call_show_sitemap, GoogleSitemapGenerator->show_sitemap, do_action('sm_build_content'), WP_Hook->do_action, WP_Hook->apply_filters, GoogleSitemapGeneratorStandardBuilder->content, GoogleSitemapGeneratorStandardBuilder->build_posts