Home

Fix for Problem with views, block and nodequeue

December 11, 2008 - 10:34am — Anonymous
  1. SELECT COUNT(*) FROM (
  2.         SELECT node.nid AS nid
  3.         FROM node node
  4.         INNER JOIN nodequeue_nodes nodequeue_nodes_node
  5.                 ON node.nid = nodequeue_nodes_node.nid
  6.                 AND nodequeue_nodes_node.qid = 1
  7.         WHERE node.status <> 0
  8.         OR node.uid = ***CURRENT_USER***
  9.         or 1 = 1
  10. ) count_alias

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.