WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ordering AS (SELECT ROW_NUMBER() OVER (ORDER BY post_modified_gmt) AS n, pos' at line 1 for query
WITH ordering AS (SELECT ROW_NUMBER() OVER (ORDER BY post_modified_gmt) AS n, post_modified_gmt
FROM yg3yh_posts USE INDEX ( type_status_date )
WHERE post_status IN ('publish')
AND post_type = 'post'
ORDER BY post_modified_gmt)
SELECT post_modified_gmt
FROM ordering
WHERE MOD(n, 1000) = 0;
made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array('pre_get_posts'), WP_Hook->do_action, WP_Hook->apply_filters, WPSEO_Sitemaps->redirect, WPSEO_Sitemaps->build_sitemap, WPSEO_Sitemaps->build_root_map, WPSEO_Post_Type_Sitemap_Provider->get_index_links, WPSEO_Post_Type_Sitemap_Provider->get_all_dates_using_with_clause
-
This topic was modified 5 days, 14 hours ago by
zecompadre.