Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT node.nid AS nid,
- node.title AS node_title,
- node.created AS node_created,
- users.name AS users_name,
- node_data_field_teaser.field_teaser_value AS node_data_field_teaser_field_teaser_value,
- node_data_field_teaser.field_teaser_format AS node_data_field_teaser_field_teaser_format,
- node.TYPE AS node_type,
- node.vid AS node_vid,
- node_revisions.teaser AS node_revisions_teaser,
- node_revisions.format AS node_revisions_format,
- node_data_field_temas.field_temas_value AS node_data_field_temas_field_temas_value,
- node_data_field_imagen.field_imagen_fid AS node_data_field_imagen_field_imagen_fid,
- node_data_field_imagen.field_imagen_list AS node_data_field_imagen_field_imagen_list,
- node_data_field_imagen.field_imagen_data AS node_data_field_imagen_field_imagen_data
- FROM node node
- LEFT JOIN nodequeue_nodes nodequeue_nodes_node ON node.nid = nodequeue_nodes_node.nid AND nodequeue_nodes_node.qid = 6
- INNER JOIN term_node term_node ON node.vid = term_node.vid
- LEFT JOIN term_node term_node2 ON node.vid = term_node2.vid AND term_node2.tid != 253
- INNER JOIN users users ON node.uid = users.uid
- LEFT JOIN content_field_teaser node_data_field_teaser ON node.vid = node_data_field_teaser.vid
- LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
- LEFT JOIN content_field_temas node_data_field_temas ON node.vid = node_data_field_temas.vid
- LEFT JOIN content_field_imagen node_data_field_imagen ON node.vid = node_data_field_imagen.vid
- WHERE (node.STATUS <> 0) AND (node.TYPE IN ('noticia')) AND (term_node.tid = 253) AND (term_node2.tid = 125)
- ORDER BY node_created DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement