Home

Fix for Code

February 16, 2010 - 10:30am — Anonymous
  1. SELECT node.nid AS nid,
  2.    node_data_field_imagen_principal.field_imagen_principal_fid AS node_data_field_imagen_principal_field_imagen_principal_fid,
  3.    node_data_field_imagen_principal.field_imagen_principal_list AS node_data_field_imagen_principal_field_imagen_principal_list,
  4.    node_data_field_imagen_principal.field_imagen_principal_data AS node_data_field_imagen_principal_field_imagen_principal_data,
  5.    node.type AS node_type,
  6.    node.vid AS node_vid,
  7.    node.title AS node_title,
  8.    node_revisions.teaser AS node_revisions_teaser,
  9.    node_revisions.format AS node_revisions_format,
  10.    node.created AS node_created,
  11.    node_comment_statistics.comment_count AS node_comment_statistics_comment_count
  12.  FROM node node
  13.  LEFT JOIN nodequeue_nodes nodequeue_nodes_node ON node.nid = nodequeue_nodes_node.nid AND nodequeue_nodes_node.qid = 15
  14.  INNER JOIN term_node term_node ON node.vid = term_node.vid
  15.  LEFT JOIN nodequeue_subqueue nodequeue_nodes_node__nodequeue_subqueue ON nodequeue_nodes_node.sqid = nodequeue_nodes_node__nodequeue_subqueue.sqid
  16.  LEFT JOIN content_field_imagen_principal node_data_field_imagen_principal ON node.vid = node_data_field_imagen_principal.vid
  17.  LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
  18.  INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
  19.  WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (node.type not in ('poll', 'hobby_gallery')) AND (nodequeue_nodes_node.nid IS NULL) AND (term_node.tid = 4) AND (nodequeue_nodes_node__nodequeue_subqueue.reference = '4')
  20.    ORDER BY node_created DESC

Submit Fix

Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).
Select the syntax highlighting mode to use.