Modify Global Posts Plugin

Can you use the SQL OFFSET statement:

OFFSET 1

$query = "SELECT * FROM " . $wpdb->base_prefix . "site_posts 
WHERE blog_public="1" 
AND post_type="" . $recentglobalpoststype . "" 
ORDER BY post_published_stamp 
OFFSET 1
DESC LIMIT " . $recentglobalpostsnumber;

Related Posts:

  1. How to Optimize WP site for millions of posts
  2. Differences between wpdb->get_results() and wpdb->query()
  3. Get Terms by IDs with IDs order
  4. Using WordPress public query variables
  5. How many WordPress SQL Queries per page?
  6. Slow wp_enqueue_media()
  7. Advanced Custom Fields – Query Efficiency
  8. How to display lastest post date in the homepage?
  9. Get a user’s most recent post title
  10. Different Main Navigation per category
  11. How to tell if $query_var isset?
  12. Show All Posts Insert Edit Link
  13. Get IDs of posts currently visible on archive
  14. Get posts by category with pure SQL query
  15. can’t get query to order posts by acf datepicker
  16. Sorting Grids with Essential Grid and Events Manger
  17. The use of including upgrade.php when building custom queries
  18. Custom query to get terms from post ids
  19. Get the timout value of a saved transient?
  20. WordPress query by category, sorted by custom field
  21. Does meta_query work within get_posts array?
  22. Slow meta_query with about 4 milion record on wp_postmeta
  23. How to show more than 5 posts?
  24. Deleting data from a custom table in WordPress
  25. WordPress Find Duplicate Post By Content
  26. WP Query Sort by meta value (date)
  27. How to optimize my query filtering out unwanted data?
  28. mySQL query. ORDER BY meta_key
  29. Remove posts from query for events whose start date has passed
  30. how to query multiple categories in wordpress?
  31. Disable the MySQL query in the main query
  32. Strange string in console from wpdb query
  33. Update slug (URL) of pending posts via phpMyAdmin
  34. How can I get the query that would be run for the archive page?
  35. Query metas (and not : query posts by metas)
  36. Select query for a login
  37. What’s wrong with my $wpdb prepare?
  38. pre_get_posts : ‘post__not_in’ doesn’t work with global variable
  39. where should I reset query after using get_results?
  40. Getting post data from private page
  41. Missing posts in a query
  42. Exclude featured image and custom field from this get_attachment query
  43. Protect sequence of pages with same password for each of two groups of users
  44. wpdb print all post meta
  45. Form and custom query problem
  46. Export Specific User data without plugin
  47. Query to get number of posts last week
  48. How to write: $wpdb->update having WHERE NOT value pair in the array
  49. Exclude all sticky posts front page twenty twelve
  50. wpdb COALESCE won’t work
  51. get csv of users with user_meta
  52. Custom SQL Query passing array to WHERE p.id
  53. Query does not return content
  54. Query posts dynamic date range
  55. How to read the value of a WordPress $query associative array (hash) key
  56. Parse query filter in wordpress and relation
  57. Query posts based on previous query
  58. Waypoints + infinite scroll with custom query
  59. get posts by tag to showing in a widget
  60. Mysql query not working on WordPress 4.2.2
  61. How do I get all results from my query
  62. get_post_meta with WP_query
  63. How to create an overview of posts with the same tag?
  64. List WordPress Post and Related Attachments outside of a post page
  65. How properly create a blog template for wordpress?
  66. Is there a way to add a link directly into this media query?
  67. Problem on displaying the results on my query
  68. Improve performance of slow query
  69. JetEngine Query Builder – order by value from repeater
  70. WordPress search in modified post title
  71. Filter orders by modify date
  72. How to add url parameter to every search query in SearchWp?
  73. meta_query not working
  74. Cannot get sql request from Query object?
  75. WordPress query: merge meta key (number) values and sort
  76. Heavy meta query causing SQL crash
  77. Question about of query
  78. Is there any way to get all custom posts and all custom terms with it’s meta in few queries?
  79. Modify behaviour of “s” parameter in wp_query
  80. Speed up search query that searches in post meta?
  81. How to make MySQL search queries with quotes
  82. Limiting a filtered query
  83. Archive query not working correctly
  84. Custom MySQL Query for Post and Post Meta
  85. very slow wordpress query with default query
  86. Displaying popular posts
  87. How to have more post in a page than in your home page
  88. Find all posts via SQL beginning with A of type B
  89. learn to run wpdb class
  90. Display old posts if no future posts exist
  91. Access Tables with number prefix
  92. If more than 1 image show post link?
  93. WP_Query with checkbox meta_query – WordPress [duplicate]
  94. Rewrite Query_Var URL Parameter with Slug
  95. How to query different categories on index?
  96. How to specify what kind of is_single post?
  97. Can’t See Media Queries with Inspect Tool [closed]
  98. Print data from wordpress sql query
  99. Can I create my own query in wordpress with traditional methods?
  100. How to show sticky posts on all pages of the pagination, not just the first page?