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
Comment #1
mikebell_ commentedThis 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.
Comment #2
fizk commentedFixed in dev, according to comment #1.