Skip to content

Instantly share code, notes, and snippets.

@archon810
Created September 16, 2021 23:07
Show Gist options
  • Save archon810/e55ae2677ac44c7c3c3cf07004e5121e to your computer and use it in GitHub Desktop.
Save archon810/e55ae2677ac44c7c3c3cf07004e5121e to your computer and use it in GitHub Desktop.
323 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 397400
)
o JOIN wp_posts l ON l.ID = o.ID
322 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 392400
)
o JOIN wp_posts l ON l.ID = o.ID
306 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 384400
)
o JOIN wp_posts l ON l.ID = o.ID
273 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 288500
)
o JOIN wp_posts l ON l.ID = o.ID
272 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 403400
)
o JOIN wp_posts l ON l.ID = o.ID
267 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 243500
)
o JOIN wp_posts l ON l.ID = o.ID
266 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 269500
)
o JOIN wp_posts l ON l.ID = o.ID
265 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 388400
)
o JOIN wp_posts l ON l.ID = o.ID
265 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 273500
)
o JOIN wp_posts l ON l.ID = o.ID
261 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 214500
)
o JOIN wp_posts l ON l.ID = o.ID
255 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 275500
)
o JOIN wp_posts l ON l.ID = o.ID
254 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 237500
)
o JOIN wp_posts l ON l.ID = o.ID
251 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 260500
)
o JOIN wp_posts l ON l.ID = o.ID
249 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 270500
)
o JOIN wp_posts l ON l.ID = o.ID
247 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 208500
)
o JOIN wp_posts l ON l.ID = o.ID
246 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 234500
)
o JOIN wp_posts l ON l.ID = o.ID
244 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 276500
)
o JOIN wp_posts l ON l.ID = o.ID
243 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 265500
)
o JOIN wp_posts l ON l.ID = o.ID
242 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 280500
)
o JOIN wp_posts l ON l.ID = o.ID
239 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 315500
)
o JOIN wp_posts l ON l.ID = o.ID
239 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 296500
)
o JOIN wp_posts l ON l.ID = o.ID
239 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 266500
)
o JOIN wp_posts l ON l.ID = o.ID
235 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 250500
)
o JOIN wp_posts l ON l.ID = o.ID
234 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 246500
)
o JOIN wp_posts l ON l.ID = o.ID
231 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 256500
)
o JOIN wp_posts l ON l.ID = o.ID
229 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 269500
)
o JOIN wp_posts l ON l.ID = o.ID
226 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 259500
)
o JOIN wp_posts l ON l.ID = o.ID
225 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 125600
)
o JOIN wp_posts l ON l.ID = o.ID
225 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 319100
)
o JOIN wp_posts l ON l.ID = o.ID
221 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 254500
)
o JOIN wp_posts l ON l.ID = o.ID
218 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 99600
)
o JOIN wp_posts l ON l.ID = o.ID
217 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 269500
)
o JOIN wp_posts l ON l.ID = o.ID
215 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 291500
)
o JOIN wp_posts l ON l.ID = o.ID
214 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 110600
)
o JOIN wp_posts l ON l.ID = o.ID
212 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 267500
)
o JOIN wp_posts l ON l.ID = o.ID
207 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 328500
)
o JOIN wp_posts l ON l.ID = o.ID
207 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 186600
)
o JOIN wp_posts l ON l.ID = o.ID
206 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 163600
)
o JOIN wp_posts l ON l.ID = o.ID
206 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 316500
)
o JOIN wp_posts l ON l.ID = o.ID
204 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 309500
)
o JOIN wp_posts l ON l.ID = o.ID
203 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 306500
)
o JOIN wp_posts l ON l.ID = o.ID
199 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 296500
)
o JOIN wp_posts l ON l.ID = o.ID
195 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 303500
)
o JOIN wp_posts l ON l.ID = o.ID
195 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 110600
)
o JOIN wp_posts l ON l.ID = o.ID
194 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 303500
)
o JOIN wp_posts l ON l.ID = o.ID
193 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 348500
)
o JOIN wp_posts l ON l.ID = o.ID
193 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 299500
)
o JOIN wp_posts l ON l.ID = o.ID
193 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'app_release'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 255700
)
o JOIN wp_posts l ON l.ID = o.ID
191 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 156600
)
o JOIN wp_posts l ON l.ID = o.ID
189 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 118600
)
o JOIN wp_posts l ON l.ID = o.ID
189 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 266500
)
o JOIN wp_posts l ON l.ID = o.ID
188 Creating sort index SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt
FROM (
SELECT wp_posts.ID
FROM wp_posts
WHERE wp_posts.post_status IN ('publish')
AND wp_posts.post_type = 'apps_post'
AND wp_posts.post_password = ''
AND wp_posts.post_date != '0000-00-00 00:00:00'
ORDER BY wp_posts.post_modified ASC LIMIT 100 OFFSET 304500
)
o JOIN wp_posts l ON l.ID = o.ID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment