Skip to content

Instantly share code, notes, and snippets.

@jywarren
Created March 30, 2015 19:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jywarren/072595dd799ff3373da0 to your computer and use it in GitHub Desktop.
Save jywarren/072595dd799ff3373da0 to your computer and use it in GitHub Desktop.
SQL (180.9ms) SELECT DISTINCT `node`.nid FROM `node` LEFT OUTER JOIN `node_revisions` ON `node_revisions`.`nid` = `node`.`nid` LEFT OUTER JOIN `node_counter` ON `node_counter`.`nid` = `node`.`nid` WHERE (status = 1) ORDER BY node_revisions.timestamp DESC LIMIT 30
SQL (3.6ms) SELECT `node`.`nid` AS t0_r0, `node`.`vid` AS t0_r1, `node`.`type` AS t0_r2, `node`.`language` AS t0_r3, `node`.`title` AS t0_r4, `node`.`uid` AS t0_r5, `node`.`status` AS t0_r6, `node`.`created` AS t0_r7, `node`.`changed` AS t0_r8, `node`.`comment` AS t0_r9, `node`.`promote` AS t0_r10, `node`.`moderate` AS t0_r11, `node`.`sticky` AS t0_r12, `node`.`tnid` AS t0_r13, `node`.`translate` AS t0_r14, `node`.`cached_likes` AS t0_r15, `node`.`drupal_comments_count` AS t0_r16, `node`.`drupal_node_revisions_count` AS t0_r17, `node`.`path` AS t0_r18, `node_revisions`.`vid` AS t1_r0, `node_revisions`.`nid` AS t1_r1, `node_revisions`.`uid` AS t1_r2, `node_revisions`.`title` AS t1_r3, `node_revisions`.`body` AS t1_r4, `node_revisions`.`teaser` AS t1_r5, `node_revisions`.`log` AS t1_r6, `node_revisions`.`timestamp` AS t1_r7, `node_revisions`.`format` AS t1_r8, `node_counter`.`nid` AS t2_r0, `node_counter`.`totalcount` AS t2_r1, `node_counter`.`daycount` AS t2_r2, `node_counter`.`timestamp` AS t2_r3 FROM `node` LEFT OUTER JOIN `node_revisions` ON `node_revisions`.`nid` = `node`.`nid` LEFT OUTER JOIN `node_counter` ON `node_counter`.`nid` = `node`.`nid` WHERE `node`.`nid` IN (11731, 11730,
11729, 11728, 11727, 11726, 11724, 11723, 11722, 11720, 11719, 11718, 11717, 11716, 11715, 11714, 11713, 11712, 11711, 11710, 11708, 11707, 11706, 11705, 11704, 11703, 11702, 11701, 11700, 11699) AND (status = 1) ORDER BY node_revisions.timestamp DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment