2006-2007 Supporters (In-Kind)
- user warning: Table 'unjourna_dag.node_data_field_order' doesn't exist
query: SELECT count( DISTINCT(node.nid)) FROM node node LEFT JOIN node_data_field_year node_data_field_year ON node.vid = node_data_field_year.vid LEFT JOIN node_supporter node_data_field_type ON node.vid = node_data_field_type.vid LEFT JOIN node_data_field_order node_data_field_order ON node.vid = node_data_field_order.vid LEFT JOIN node_supporter node_data_field_logo ON node.vid = node_data_field_logo.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public'))) AND ( (node.status = '1') AND (node_data_field_year.field_year_value IN ('2006','2007')) AND (node.type IN ('supporter')) AND (node_data_field_type.field_type_value IN ('In-Kind')) AND (node_data_field_order.field_order_value > '') ) in /home4/unjourna/public_html/includes/database.mysql.inc on line 167.
- user warning: Table 'unjourna_dag.node_data_field_order' doesn't exist
query: SELECT DISTINCT(node.nid), node_data_field_order.field_order_value AS node_data_field_order_field_order_value, node_data_field_logo.field_logo_value AS node_data_field_logo_field_logo_value, node_data_field_logo.field_logo_format AS node_data_field_logo_field_logo_format FROM node node LEFT JOIN node_data_field_year node_data_field_year ON node.vid = node_data_field_year.vid LEFT JOIN node_supporter node_data_field_type ON node.vid = node_data_field_type.vid LEFT JOIN node_data_field_order node_data_field_order ON node.vid = node_data_field_order.vid LEFT JOIN node_supporter node_data_field_logo ON node.vid = node_data_field_logo.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public'))) AND ( (node.status = '1') AND (node_data_field_year.field_year_value IN ('2006','2007')) AND (node.type IN ('supporter')) AND (node_data_field_type.field_type_value IN ('In-Kind')) AND (node_data_field_order.field_order_value > '') ) ORDER BY node_data_field_order_field_order_value ASC LIMIT 0, 50 in /home4/unjourna/public_html/includes/database.mysql.inc on line 167.
|
