Advertisement
Guest User

Untitled

a guest
Jun 28th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.62 KB | None | 0 0
  1. SELECT node.nid AS nid,
  2.    node.title AS node_title,
  3.    node.created AS node_created,
  4.    users.name AS users_name,
  5.    node_data_field_teaser.field_teaser_value AS node_data_field_teaser_field_teaser_value,
  6.    node_data_field_teaser.field_teaser_format AS node_data_field_teaser_field_teaser_format,
  7.    node.TYPE AS node_type,
  8.    node.vid AS node_vid,
  9.    node_revisions.teaser AS node_revisions_teaser,
  10.    node_revisions.format AS node_revisions_format,
  11.    node_data_field_temas.field_temas_value AS node_data_field_temas_field_temas_value,
  12.    node_data_field_imagen.field_imagen_fid AS node_data_field_imagen_field_imagen_fid,
  13.    node_data_field_imagen.field_imagen_list AS node_data_field_imagen_field_imagen_list,
  14.    node_data_field_imagen.field_imagen_data AS node_data_field_imagen_field_imagen_data
  15.  FROM node node
  16.  LEFT JOIN nodequeue_nodes nodequeue_nodes_node ON node.nid = nodequeue_nodes_node.nid AND nodequeue_nodes_node.qid = 6
  17.  INNER JOIN term_node term_node ON node.vid = term_node.vid
  18.  LEFT JOIN term_node term_node2 ON node.vid = term_node2.vid AND term_node2.tid != 253
  19.  INNER JOIN users users ON node.uid = users.uid
  20.  LEFT JOIN content_field_teaser node_data_field_teaser ON node.vid = node_data_field_teaser.vid
  21.  LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
  22.  LEFT JOIN content_field_temas node_data_field_temas ON node.vid = node_data_field_temas.vid
  23.  LEFT JOIN content_field_imagen node_data_field_imagen ON node.vid = node_data_field_imagen.vid
  24.  WHERE (node.STATUS <> 0) AND (node.TYPE IN ('noticia')) AND (term_node.tid = 253) AND (term_node2.tid = 125)
  25.    ORDER BY node_created DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement