Here's the query from my View with that filter set to "True":

SELECT node.nid AS nid, node.title AS node_title, nodequeue_nodes_node.position AS nodequeue_nodes_node_position, 'node' AS field_data_field_banner_link_node_entity_type, 'node' AS field_data_field_banner_image_node_entity_type
FROM 
{node} node
INNER JOIN {nodequeue_nodes} nodequeue_nodes_node ON node.nid = nodequeue_nodes_node.nid
LEFT JOIN {nodequeue_queue} nodequeue_nodes_node__nodequeue_queue ON nodequeue_nodes_node.qid = nodequeue_nodes_node__nodequeue_queue.qid
WHERE (( (node.status = '1') AND (node.type IN  ('banner')) AND (nodequeue_nodes_node.nid != '1') AND (nodequeue_nodes_node__nodequeue_queue.name LIKE 'banner_slideshow' ESCAPE '\\') ))
ORDER BY nodequeue_nodes_node_position ASC

Here's the query without it

SELECT node.nid AS nid, node.title AS node_title, nodequeue_nodes_node.position AS nodequeue_nodes_node_position, 'node' AS field_data_field_banner_link_node_entity_type, 'node' AS field_data_field_banner_image_node_entity_type
FROM 
{node} node
INNER JOIN {nodequeue_nodes} nodequeue_nodes_node ON node.nid = nodequeue_nodes_node.nid
LEFT JOIN {nodequeue_queue} nodequeue_nodes_node__nodequeue_queue ON nodequeue_nodes_node.qid = nodequeue_nodes_node__nodequeue_queue.qid
WHERE (( (node.status = '1') AND (node.type IN  ('banner')) AND (nodequeue_nodes_node__nodequeue_queue.name LIKE 'banner_slideshow' ESCAPE '\\') ))
ORDER BY nodequeue_nodes_node_position ASC

The problem is this

AND (nodequeue_nodes_node.nid != '1')

It's just excluding a node that has an nid of 1.

Comments

mikebell_’s picture

This appears to be fixed in dev but not in the latest release. Here is a patch that applies against the latest release with the fix in.

fizk’s picture

Status: Active » Closed (fixed)

Fixed in dev, according to comment #1.