************************************************* views26 views26 latest_patch (probably dublicates different behaviour on/off=distinct? / missing pager!) string(4) "node" string(3) "nid" string(809) " SELECT node.nid AS nid, node_data_field_photoperioxes.field_photoperioxes_fid AS node_data_field_photoperioxes_field_photoperioxes_fid, node_data_field_photoperioxes.field_photoperioxes_list AS node_data_field_photoperioxes_field_photoperioxes_list, node_data_field_photoperioxes.field_photoperioxes_data AS node_data_field_photoperioxes_field_photoperioxes_data, node_data_field_photoperioxes.delta AS node_data_field_photoperioxes_delta, node.type AS node_type, node.vid AS node_vid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (node.type in ('%s')) AND (node.nid = %d) " string(4) "node" string(3) "nid" string(329) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (node.type in ('%s')) AND (node.nid = %d) " string(1) "n" string(3) "nid" string(63) " SELECT n.nid FROM {node} n WHERE n.status = 1 AND n.nid IN (%d)" string(1) "n" string(3) "nid" string(67) " SELECT n.nid FROM {node} n WHERE n.status = 1 AND n.nid IN (%d, %d)" string(1) "n" string(3) "nid" string(128) " SELECT COUNT(*) FROM {node} n INNER JOIN {og} og ON n.nid = og.nid WHERE og.og_directory=1 AND n.type IN ('%s') AND n.status = 1" string(1) "n" string(3) "nid" string(152) " SELECT n.nid, n.title FROM {node} n INNER JOIN {og} og ON n.nid = og.nid WHERE n.status = 1 AND n.type IN ('%s') AND og.og_directory=1 ORDER BY nid DESC" string(4) "node" string(3) "nid" string(614) " SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.sticky AS node_sticky, node.created AS node_created FROM {node} node LEFT JOIN {term_node} term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 332 LEFT JOIN {term_node} term_node_value_1 ON node.vid = term_node_value_1.vid AND term_node_value_1.tid = 338 WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (term_node_value_0.tid = %d OR term_node_value_1.tid = %d) AND (node.nid != %d) ORDER BY node_sticky DESC, node_created DESC " string(4) "node" string(3) "nid" string(614) " SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.sticky AS node_sticky, node.created AS node_created FROM {node} node LEFT JOIN {term_node} term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 332 LEFT JOIN {term_node} term_node_value_1 ON node.vid = term_node_value_1.vid AND term_node_value_1.tid = 338 WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (term_node_value_0.tid = %d OR term_node_value_1.tid = %d) AND (node.nid != %d) ORDER BY node_sticky DESC, node_created DESC " string(4) "node" string(3) "nid" string(196) " SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.created AS node_created FROM {node} node WHERE (node.type in ('%s')) AND (node.status <> 0) ORDER BY node_created DESC " string(4) "node" string(3) "nid" string(196) " SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.created AS node_created FROM {node} node WHERE (node.type in ('%s')) AND (node.status <> 0) ORDER BY node_created DESC " string(1) "n" string(3) "nid" string(252) " SELECT n.nid, n.title, l.comment_count FROM {node} n INNER JOIN {term_node} tn ON tn.vid = n.vid INNER JOIN {term_data} td ON td.tid = tn.tid INNER JOIN {node_comment_statistics} l ON n.nid = l.nid WHERE n.status = 1 AND td.vid = %d ORDER BY n.nid DESC" string(1) "n" string(3) "nid" string(1402) " SELECT n.nid, n.uid, n.title, n.type, e.event_start, e.event_start AS event_start_orig, e.event_end, e.event_end AS event_end_orig, e.timezone, e.has_time, e.has_end_date, tz.offset AS offset, tz.offset_dst AS offset_dst, tz.dst_region, tz.is_dst, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_start_utc, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_end_utc, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_start_user, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_end_user, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_start_site, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_end_site, tz.name as timezone_name FROM {node} n INNER JOIN {event} e ON n.nid = e.nid INNER JOIN {event_timezones} tz ON tz.timezone = e.timezone WHERE n.status = 1 AND ((e.event_start >= '%s' AND e.event_start <= '%s') OR (e.event_end >= '%s' AND e.event_end <= '%s') OR (e.event_start <= '%s' AND e.event_end >= '%s')) GROUP BY n.nid HAVING (event_start >= '%s' AND event_start <= '%s') OR (event_end >= '%s' AND event_end <= '%s') OR (event_start <= '%s' AND event_end >= '%s') ORDER BY event_start ASC" string(4) "node" string(3) "nid" string(636) " SELECT node.nid AS nid, node.title AS node_title, feedapi_node_item.arrived AS feedapi_node_item_arrived FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND ((UPPER(%s) LIKE UPPER('%%%s%%') OR UPPER(%s) LIKE UPPER('%%%s%%'))) ORDER BY feedapi_node_item_arrived DESC " string(4) "node" string(3) "nid" string(508) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND ((UPPER(%s) LIKE UPPER('%%%s%%') OR UPPER(%s) LIKE UPPER('%%%s%%'))) " string(4) "node" string(3) "nid" string(636) " SELECT node.nid AS nid, node.title AS node_title, feedapi_node_item.arrived AS feedapi_node_item_arrived FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND ((UPPER(%s) LIKE UPPER('%%%s%%') OR UPPER(%s) LIKE UPPER('%%%s%%'))) ORDER BY feedapi_node_item_arrived DESC " string(4) "node" string(3) "nid" string(508) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND ((UPPER(%s) LIKE UPPER('%%%s%%') OR UPPER(%s) LIKE UPPER('%%%s%%'))) " string(4) "node" string(3) "nid" string(592) " SELECT node.nid AS nid, node.title AS node_title, feedapi_node_item.arrived AS feedapi_node_item_arrived FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND (((%s) LIKE ('%%%s%%'))) ORDER BY feedapi_node_item_arrived DESC " string(4) "node" string(3) "nid" string(464) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND (((%s) LIKE ('%%%s%%'))) " string(1) "n" string(3) "nid" string(241) " SELECT n.uid, n.created FROM {node} n WHERE n.status = 1 AND n.type IN ('blog', 'forum', 'ipaper', 'book', 'infotravel', 'infrastructures', 'law', 'ogbase', 'organenterprise', 'page', 'personalphotogallery', 'relax', 'spatialdata', 'story') " string(4) "node" string(3) "nid" string(245) " SELECT DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 7200 SECOND), '%Y%m') AS created_year_month, COUNT(node.nid) AS num_records FROM {node} node WHERE node.status <> 0 GROUP BY created_year_month ORDER BY created_year_month DESC " string(4) "node" string(3) "nid" string(245) " SELECT DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 7200 SECOND), '%Y%m') AS created_year_month, COUNT(node.nid) AS num_records FROM {node} node WHERE node.status <> 0 GROUP BY created_year_month ORDER BY created_year_month DESC " string(1) "n" string(3) "nid" string(109) " SELECT n.nid, n.title, n.created FROM {node} n WHERE n.type = 'blog' AND n.status = 1 ORDER BY n.created DESC" string(1) "n" string(3) "nid" string(108) " SELECT MAX(n.created) FROM {node} n INNER JOIN {poll} p ON p.nid = n.nid WHERE n.status = 1 AND p.active = 1" string(4) "node" string(3) "nid" string(311) " SELECT node.nid AS nid, node_revisions.title AS node_revisions_title, node_revisions.nid AS node_revisions_nid, node.type AS node_type FROM {node} node LEFT JOIN {node_revisions} node_revisions ON node.vid = node_revisions.vid WHERE (node.status <> 0) AND (node.nid = %d) ORDER BY node_type ASC " string(4) "node" string(3) "nid" string(167) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {node_revisions} node_revisions ON node.vid = node_revisions.vid WHERE (node.status <> 0) AND (node.nid = %d) " string(1) "n" string(3) "nid" string(63) " SELECT n.nid FROM {node} n WHERE n.status = 1 AND n.nid IN (%d)" +full cleaned cache string(4) "node" string(3) "nid" string(809) " SELECT node.nid AS nid, node_data_field_photoperioxes.field_photoperioxes_fid AS node_data_field_photoperioxes_field_photoperioxes_fid, node_data_field_photoperioxes.field_photoperioxes_list AS node_data_field_photoperioxes_field_photoperioxes_list, node_data_field_photoperioxes.field_photoperioxes_data AS node_data_field_photoperioxes_field_photoperioxes_data, node_data_field_photoperioxes.delta AS node_data_field_photoperioxes_delta, node.type AS node_type, node.vid AS node_vid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (node.type in ('%s')) AND (node.nid = %d) " string(4) "node" string(3) "nid" string(329) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (node.type in ('%s')) AND (node.nid = %d) " string(1) "n" string(3) "nid" string(63) " SELECT n.nid FROM {node} n WHERE n.status = 1 AND n.nid IN (%d)" string(1) "n" string(3) "nid" string(67) " SELECT n.nid FROM {node} n WHERE n.status = 1 AND n.nid IN (%d, %d)" string(1) "n" string(3) "nid" string(128) " SELECT COUNT(*) FROM {node} n INNER JOIN {og} og ON n.nid = og.nid WHERE og.og_directory=1 AND n.type IN ('%s') AND n.status = 1" string(1) "n" string(3) "nid" string(152) " SELECT n.nid, n.title FROM {node} n INNER JOIN {og} og ON n.nid = og.nid WHERE n.status = 1 AND n.type IN ('%s') AND og.og_directory=1 ORDER BY nid DESC" string(4) "node" string(3) "nid" string(614) " SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.sticky AS node_sticky, node.created AS node_created FROM {node} node LEFT JOIN {term_node} term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 332 LEFT JOIN {term_node} term_node_value_1 ON node.vid = term_node_value_1.vid AND term_node_value_1.tid = 338 WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (term_node_value_0.tid = %d OR term_node_value_1.tid = %d) AND (node.nid != %d) ORDER BY node_sticky DESC, node_created DESC " string(4) "node" string(3) "nid" string(614) " SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.sticky AS node_sticky, node.created AS node_created FROM {node} node LEFT JOIN {term_node} term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 332 LEFT JOIN {term_node} term_node_value_1 ON node.vid = term_node_value_1.vid AND term_node_value_1.tid = 338 WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (term_node_value_0.tid = %d OR term_node_value_1.tid = %d) AND (node.nid != %d) ORDER BY node_sticky DESC, node_created DESC " string(4) "node" string(3) "nid" string(196) " SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.created AS node_created FROM {node} node WHERE (node.type in ('%s')) AND (node.status <> 0) ORDER BY node_created DESC " string(4) "node" string(3) "nid" string(196) " SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.created AS node_created FROM {node} node WHERE (node.type in ('%s')) AND (node.status <> 0) ORDER BY node_created DESC " string(1) "n" string(3) "nid" string(252) " SELECT n.nid, n.title, l.comment_count FROM {node} n INNER JOIN {term_node} tn ON tn.vid = n.vid INNER JOIN {term_data} td ON td.tid = tn.tid INNER JOIN {node_comment_statistics} l ON n.nid = l.nid WHERE n.status = 1 AND td.vid = %d ORDER BY n.nid DESC" string(1) "n" string(3) "nid" string(1402) " SELECT n.nid, n.uid, n.title, n.type, e.event_start, e.event_start AS event_start_orig, e.event_end, e.event_end AS event_end_orig, e.timezone, e.has_time, e.has_end_date, tz.offset AS offset, tz.offset_dst AS offset_dst, tz.dst_region, tz.is_dst, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_start_utc, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_end_utc, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_start_user, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_end_user, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_start_site, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_end_site, tz.name as timezone_name FROM {node} n INNER JOIN {event} e ON n.nid = e.nid INNER JOIN {event_timezones} tz ON tz.timezone = e.timezone WHERE n.status = 1 AND ((e.event_start >= '%s' AND e.event_start <= '%s') OR (e.event_end >= '%s' AND e.event_end <= '%s') OR (e.event_start <= '%s' AND e.event_end >= '%s')) GROUP BY n.nid HAVING (event_start >= '%s' AND event_start <= '%s') OR (event_end >= '%s' AND event_end <= '%s') OR (event_start <= '%s' AND event_end >= '%s') ORDER BY event_start ASC" string(4) "node" string(3) "nid" string(636) " SELECT node.nid AS nid, node.title AS node_title, feedapi_node_item.arrived AS feedapi_node_item_arrived FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND ((UPPER(%s) LIKE UPPER('%%%s%%') OR UPPER(%s) LIKE UPPER('%%%s%%'))) ORDER BY feedapi_node_item_arrived DESC " string(4) "node" string(3) "nid" string(508) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND ((UPPER(%s) LIKE UPPER('%%%s%%') OR UPPER(%s) LIKE UPPER('%%%s%%'))) " string(4) "node" string(3) "nid" string(636) " SELECT node.nid AS nid, node.title AS node_title, feedapi_node_item.arrived AS feedapi_node_item_arrived FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND ((UPPER(%s) LIKE UPPER('%%%s%%') OR UPPER(%s) LIKE UPPER('%%%s%%'))) ORDER BY feedapi_node_item_arrived DESC " string(4) "node" string(3) "nid" string(508) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND ((UPPER(%s) LIKE UPPER('%%%s%%') OR UPPER(%s) LIKE UPPER('%%%s%%'))) " string(4) "node" string(3) "nid" string(592) " SELECT node.nid AS nid, node.title AS node_title, feedapi_node_item.arrived AS feedapi_node_item_arrived FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND (((%s) LIKE ('%%%s%%'))) ORDER BY feedapi_node_item_arrived DESC " string(4) "node" string(3) "nid" string(464) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND (((%s) LIKE ('%%%s%%'))) " string(1) "n" string(3) "nid" string(278) " SELECT COUNT(*) AS count, td.tid, td.vid, td.name, td.description FROM {term_data} td INNER JOIN {term_node} tn ON td.tid = tn.tid INNER JOIN {node} n ON tn.vid = n.vid WHERE td.vid IN (%d) GROUP BY td.tid, td.vid, td.name, td.description HAVING COUNT(*) > 0 ORDER BY count DESC" string(1) "n" string(3) "nid" string(278) " SELECT COUNT(*) AS count, td.tid, td.vid, td.name, td.description FROM {term_data} td INNER JOIN {term_node} tn ON td.tid = tn.tid INNER JOIN {node} n ON tn.vid = n.vid WHERE td.vid IN (%d) GROUP BY td.tid, td.vid, td.name, td.description HAVING COUNT(*) > 0 ORDER BY count DESC" string(1) "n" string(3) "nid" string(278) " SELECT COUNT(*) AS count, td.tid, td.vid, td.name, td.description FROM {term_data} td INNER JOIN {term_node} tn ON td.tid = tn.tid INNER JOIN {node} n ON tn.vid = n.vid WHERE td.vid IN (%d) GROUP BY td.tid, td.vid, td.name, td.description HAVING COUNT(*) > 0 ORDER BY count DESC" string(1) "n" string(3) "nid" string(278) " SELECT COUNT(*) AS count, td.tid, td.vid, td.name, td.description FROM {term_data} td INNER JOIN {term_node} tn ON td.tid = tn.tid INNER JOIN {node} n ON tn.vid = n.vid WHERE td.vid IN (%d) GROUP BY td.tid, td.vid, td.name, td.description HAVING COUNT(*) > 0 ORDER BY count DESC" string(1) "n" string(3) "nid" string(241) " SELECT n.uid, n.created FROM {node} n WHERE n.status = 1 AND n.type IN ('blog', 'forum', 'ipaper', 'book', 'infotravel', 'infrastructures', 'law', 'ogbase', 'organenterprise', 'page', 'personalphotogallery', 'relax', 'spatialdata', 'story') " string(4) "node" string(3) "nid" string(245) " SELECT DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 7200 SECOND), '%Y%m') AS created_year_month, COUNT(node.nid) AS num_records FROM {node} node WHERE node.status <> 0 GROUP BY created_year_month ORDER BY created_year_month DESC " string(4) "node" string(3) "nid" string(245) " SELECT DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 7200 SECOND), '%Y%m') AS created_year_month, COUNT(node.nid) AS num_records FROM {node} node WHERE node.status <> 0 GROUP BY created_year_month ORDER BY created_year_month DESC " string(1) "n" string(3) "nid" string(109) " SELECT n.nid, n.title, n.created FROM {node} n WHERE n.type = 'blog' AND n.status = 1 ORDER BY n.created DESC" string(1) "n" string(3) "nid" string(108) " SELECT MAX(n.created) FROM {node} n INNER JOIN {poll} p ON p.nid = n.nid WHERE n.status = 1 AND p.active = 1" string(4) "node" string(3) "nid" string(311) " SELECT node.nid AS nid, node_revisions.title AS node_revisions_title, node_revisions.nid AS node_revisions_nid, node.type AS node_type FROM {node} node LEFT JOIN {node_revisions} node_revisions ON node.vid = node_revisions.vid WHERE (node.status <> 0) AND (node.nid = %d) ORDER BY node_type ASC " string(4) "node" string(3) "nid" string(167) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {node_revisions} node_revisions ON node.vid = node_revisions.vid WHERE (node.status <> 0) AND (node.nid = %d) " string(1) "n" string(3) "nid" string(63) " SELECT n.nid FROM {node} n WHERE n.status = 1 AND n.nid IN (%d)" views26 614original (with pager! / normal? dublicates on/off=distinct?) string(4) "node" string(3) "nid" string(809) " SELECT node.nid AS nid, node_data_field_photoperioxes.field_photoperioxes_fid AS node_data_field_photoperioxes_field_photoperioxes_fid, node_data_field_photoperioxes.field_photoperioxes_list AS node_data_field_photoperioxes_field_photoperioxes_list, node_data_field_photoperioxes.field_photoperioxes_data AS node_data_field_photoperioxes_field_photoperioxes_data, node_data_field_photoperioxes.delta AS node_data_field_photoperioxes_delta, node.type AS node_type, node.vid AS node_vid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (node.type in ('%s')) AND (node.nid = %d) " string(4) "node" string(3) "nid" string(329) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (node.type in ('%s')) AND (node.nid = %d) " string(1) "n" string(3) "nid" string(63) " SELECT n.nid FROM {node} n WHERE n.status = 1 AND n.nid IN (%d)" string(1) "n" string(3) "nid" string(67) " SELECT n.nid FROM {node} n WHERE n.status = 1 AND n.nid IN (%d, %d)" string(1) "n" string(3) "nid" string(128) " SELECT COUNT(*) FROM {node} n INNER JOIN {og} og ON n.nid = og.nid WHERE og.og_directory=1 AND n.type IN ('%s') AND n.status = 1" string(1) "n" string(3) "nid" string(152) " SELECT n.nid, n.title FROM {node} n INNER JOIN {og} og ON n.nid = og.nid WHERE n.status = 1 AND n.type IN ('%s') AND og.og_directory=1 ORDER BY nid DESC" string(4) "node" string(3) "nid" string(614) " SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.sticky AS node_sticky, node.created AS node_created FROM {node} node LEFT JOIN {term_node} term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 332 LEFT JOIN {term_node} term_node_value_1 ON node.vid = term_node_value_1.vid AND term_node_value_1.tid = 338 WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (term_node_value_0.tid = %d OR term_node_value_1.tid = %d) AND (node.nid != %d) ORDER BY node_sticky DESC, node_created DESC " string(4) "node" string(3) "nid" string(614) " SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.sticky AS node_sticky, node.created AS node_created FROM {node} node LEFT JOIN {term_node} term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 332 LEFT JOIN {term_node} term_node_value_1 ON node.vid = term_node_value_1.vid AND term_node_value_1.tid = 338 WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (term_node_value_0.tid = %d OR term_node_value_1.tid = %d) AND (node.nid != %d) ORDER BY node_sticky DESC, node_created DESC " string(4) "node" string(3) "nid" string(196) " SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.created AS node_created FROM {node} node WHERE (node.type in ('%s')) AND (node.status <> 0) ORDER BY node_created DESC " string(4) "node" string(3) "nid" string(196) " SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.created AS node_created FROM {node} node WHERE (node.type in ('%s')) AND (node.status <> 0) ORDER BY node_created DESC " string(1) "n" string(3) "nid" string(252) " SELECT n.nid, n.title, l.comment_count FROM {node} n INNER JOIN {term_node} tn ON tn.vid = n.vid INNER JOIN {term_data} td ON td.tid = tn.tid INNER JOIN {node_comment_statistics} l ON n.nid = l.nid WHERE n.status = 1 AND td.vid = %d ORDER BY n.nid DESC" string(1) "n" string(3) "nid" string(1402) " SELECT n.nid, n.uid, n.title, n.type, e.event_start, e.event_start AS event_start_orig, e.event_end, e.event_end AS event_end_orig, e.timezone, e.has_time, e.has_end_date, tz.offset AS offset, tz.offset_dst AS offset_dst, tz.dst_region, tz.is_dst, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_start_utc, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_end_utc, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_start_user, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_end_user, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_start_site, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_end_site, tz.name as timezone_name FROM {node} n INNER JOIN {event} e ON n.nid = e.nid INNER JOIN {event_timezones} tz ON tz.timezone = e.timezone WHERE n.status = 1 AND ((e.event_start >= '%s' AND e.event_start <= '%s') OR (e.event_end >= '%s' AND e.event_end <= '%s') OR (e.event_start <= '%s' AND e.event_end >= '%s')) GROUP BY n.nid HAVING (event_start >= '%s' AND event_start <= '%s') OR (event_end >= '%s' AND event_end <= '%s') OR (event_start <= '%s' AND event_end >= '%s') ORDER BY event_start ASC" string(4) "node" string(3) "nid" string(636) " SELECT node.nid AS nid, node.title AS node_title, feedapi_node_item.arrived AS feedapi_node_item_arrived FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND ((UPPER(%s) LIKE UPPER('%%%s%%') OR UPPER(%s) LIKE UPPER('%%%s%%'))) ORDER BY feedapi_node_item_arrived DESC " string(4) "node" string(3) "nid" string(508) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND ((UPPER(%s) LIKE UPPER('%%%s%%') OR UPPER(%s) LIKE UPPER('%%%s%%'))) " string(4) "node" string(3) "nid" string(636) " SELECT node.nid AS nid, node.title AS node_title, feedapi_node_item.arrived AS feedapi_node_item_arrived FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND ((UPPER(%s) LIKE UPPER('%%%s%%') OR UPPER(%s) LIKE UPPER('%%%s%%'))) ORDER BY feedapi_node_item_arrived DESC " string(4) "node" string(3) "nid" string(508) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND ((UPPER(%s) LIKE UPPER('%%%s%%') OR UPPER(%s) LIKE UPPER('%%%s%%'))) " string(4) "node" string(3) "nid" string(592) " SELECT node.nid AS nid, node.title AS node_title, feedapi_node_item.arrived AS feedapi_node_item_arrived FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND (((%s) LIKE ('%%%s%%'))) ORDER BY feedapi_node_item_arrived DESC " string(4) "node" string(3) "nid" string(464) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND (((%s) LIKE ('%%%s%%'))) " string(1) "n" string(3) "nid" string(241) " SELECT n.uid, n.created FROM {node} n WHERE n.status = 1 AND n.type IN ('blog', 'forum', 'ipaper', 'book', 'infotravel', 'infrastructures', 'law', 'ogbase', 'organenterprise', 'page', 'personalphotogallery', 'relax', 'spatialdata', 'story') " string(4) "node" string(3) "nid" string(245) " SELECT DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 7200 SECOND), '%Y%m') AS created_year_month, COUNT(node.nid) AS num_records FROM {node} node WHERE node.status <> 0 GROUP BY created_year_month ORDER BY created_year_month DESC " string(4) "node" string(3) "nid" string(245) " SELECT DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 7200 SECOND), '%Y%m') AS created_year_month, COUNT(node.nid) AS num_records FROM {node} node WHERE node.status <> 0 GROUP BY created_year_month ORDER BY created_year_month DESC " string(1) "n" string(3) "nid" string(109) " SELECT n.nid, n.title, n.created FROM {node} n WHERE n.type = 'blog' AND n.status = 1 ORDER BY n.created DESC" string(1) "n" string(3) "nid" string(108) " SELECT MAX(n.created) FROM {node} n INNER JOIN {poll} p ON p.nid = n.nid WHERE n.status = 1 AND p.active = 1" string(4) "node" string(3) "nid" string(311) " SELECT node.nid AS nid, node_revisions.title AS node_revisions_title, node_revisions.nid AS node_revisions_nid, node.type AS node_type FROM {node} node LEFT JOIN {node_revisions} node_revisions ON node.vid = node_revisions.vid WHERE (node.status <> 0) AND (node.nid = %d) ORDER BY node_type ASC " string(4) "node" string(3) "nid" string(167) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {node_revisions} node_revisions ON node.vid = node_revisions.vid WHERE (node.status <> 0) AND (node.nid = %d) " string(1) "n" string(3) "nid" string(63) " SELECT n.nid FROM {node} n WHERE n.status = 1 AND n.nid IN (%d)" +full cleaned cache string(4) "node" string(3) "nid" string(809) " SELECT node.nid AS nid, node_data_field_photoperioxes.field_photoperioxes_fid AS node_data_field_photoperioxes_field_photoperioxes_fid, node_data_field_photoperioxes.field_photoperioxes_list AS node_data_field_photoperioxes_field_photoperioxes_list, node_data_field_photoperioxes.field_photoperioxes_data AS node_data_field_photoperioxes_field_photoperioxes_data, node_data_field_photoperioxes.delta AS node_data_field_photoperioxes_delta, node.type AS node_type, node.vid AS node_vid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (node.type in ('%s')) AND (node.nid = %d) " string(4) "node" string(3) "nid" string(329) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (node.type in ('%s')) AND (node.nid = %d) " string(1) "n" string(3) "nid" string(63) " SELECT n.nid FROM {node} n WHERE n.status = 1 AND n.nid IN (%d)" string(1) "n" string(3) "nid" string(67) " SELECT n.nid FROM {node} n WHERE n.status = 1 AND n.nid IN (%d, %d)" string(1) "n" string(3) "nid" string(128) " SELECT COUNT(*) FROM {node} n INNER JOIN {og} og ON n.nid = og.nid WHERE og.og_directory=1 AND n.type IN ('%s') AND n.status = 1" string(1) "n" string(3) "nid" string(152) " SELECT n.nid, n.title FROM {node} n INNER JOIN {og} og ON n.nid = og.nid WHERE n.status = 1 AND n.type IN ('%s') AND og.og_directory=1 ORDER BY nid DESC" string(4) "node" string(3) "nid" string(614) " SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.sticky AS node_sticky, node.created AS node_created FROM {node} node LEFT JOIN {term_node} term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 332 LEFT JOIN {term_node} term_node_value_1 ON node.vid = term_node_value_1.vid AND term_node_value_1.tid = 338 WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (term_node_value_0.tid = %d OR term_node_value_1.tid = %d) AND (node.nid != %d) ORDER BY node_sticky DESC, node_created DESC " string(4) "node" string(3) "nid" string(614) " SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.sticky AS node_sticky, node.created AS node_created FROM {node} node LEFT JOIN {term_node} term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 332 LEFT JOIN {term_node} term_node_value_1 ON node.vid = term_node_value_1.vid AND term_node_value_1.tid = 338 WHERE (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (term_node_value_0.tid = %d OR term_node_value_1.tid = %d) AND (node.nid != %d) ORDER BY node_sticky DESC, node_created DESC " string(4) "node" string(3) "nid" string(196) " SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.created AS node_created FROM {node} node WHERE (node.type in ('%s')) AND (node.status <> 0) ORDER BY node_created DESC " string(4) "node" string(3) "nid" string(196) " SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.created AS node_created FROM {node} node WHERE (node.type in ('%s')) AND (node.status <> 0) ORDER BY node_created DESC " string(1) "n" string(3) "nid" string(252) " SELECT n.nid, n.title, l.comment_count FROM {node} n INNER JOIN {term_node} tn ON tn.vid = n.vid INNER JOIN {term_data} td ON td.tid = tn.tid INNER JOIN {node_comment_statistics} l ON n.nid = l.nid WHERE n.status = 1 AND td.vid = %d ORDER BY n.nid DESC" string(1) "n" string(3) "nid" string(1402) " SELECT n.nid, n.uid, n.title, n.type, e.event_start, e.event_start AS event_start_orig, e.event_end, e.event_end AS event_end_orig, e.timezone, e.has_time, e.has_end_date, tz.offset AS offset, tz.offset_dst AS offset_dst, tz.dst_region, tz.is_dst, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_start_utc, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_end_utc, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_start_user, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_end_user, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_start_site, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_end_site, tz.name as timezone_name FROM {node} n INNER JOIN {event} e ON n.nid = e.nid INNER JOIN {event_timezones} tz ON tz.timezone = e.timezone WHERE n.status = 1 AND ((e.event_start >= '%s' AND e.event_start <= '%s') OR (e.event_end >= '%s' AND e.event_end <= '%s') OR (e.event_start <= '%s' AND e.event_end >= '%s')) GROUP BY n.nid HAVING (event_start >= '%s' AND event_start <= '%s') OR (event_end >= '%s' AND event_end <= '%s') OR (event_start <= '%s' AND event_end >= '%s') ORDER BY event_start ASC" string(4) "node" string(3) "nid" string(636) " SELECT node.nid AS nid, node.title AS node_title, feedapi_node_item.arrived AS feedapi_node_item_arrived FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND ((UPPER(%s) LIKE UPPER('%%%s%%') OR UPPER(%s) LIKE UPPER('%%%s%%'))) ORDER BY feedapi_node_item_arrived DESC " string(4) "node" string(3) "nid" string(508) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND ((UPPER(%s) LIKE UPPER('%%%s%%') OR UPPER(%s) LIKE UPPER('%%%s%%'))) " string(4) "node" string(3) "nid" string(636) " SELECT node.nid AS nid, node.title AS node_title, feedapi_node_item.arrived AS feedapi_node_item_arrived FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND ((UPPER(%s) LIKE UPPER('%%%s%%') OR UPPER(%s) LIKE UPPER('%%%s%%'))) ORDER BY feedapi_node_item_arrived DESC " string(4) "node" string(3) "nid" string(508) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND ((UPPER(%s) LIKE UPPER('%%%s%%') OR UPPER(%s) LIKE UPPER('%%%s%%'))) " string(4) "node" string(3) "nid" string(592) " SELECT node.nid AS nid, node.title AS node_title, feedapi_node_item.arrived AS feedapi_node_item_arrived FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND (((%s) LIKE ('%%%s%%'))) ORDER BY feedapi_node_item_arrived DESC " string(4) "node" string(3) "nid" string(464) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {feedapi_node_item_feed} feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN {node} node_feedapi_node_item_feed ON feedapi_node_item_feed.feed_nid = node_feedapi_node_item_feed.nid LEFT JOIN {feedapi_node_item} feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid WHERE (node.type in ('%s')) AND (node.status <> 0) AND (((%s) LIKE ('%%%s%%'))) " string(1) "n" string(3) "nid" string(278) " SELECT COUNT(*) AS count, td.tid, td.vid, td.name, td.description FROM {term_data} td INNER JOIN {term_node} tn ON td.tid = tn.tid INNER JOIN {node} n ON tn.vid = n.vid WHERE td.vid IN (%d) GROUP BY td.tid, td.vid, td.name, td.description HAVING COUNT(*) > 0 ORDER BY count DESC" string(1) "n" string(3) "nid" string(278) " SELECT COUNT(*) AS count, td.tid, td.vid, td.name, td.description FROM {term_data} td INNER JOIN {term_node} tn ON td.tid = tn.tid INNER JOIN {node} n ON tn.vid = n.vid WHERE td.vid IN (%d) GROUP BY td.tid, td.vid, td.name, td.description HAVING COUNT(*) > 0 ORDER BY count DESC" string(1) "n" string(3) "nid" string(278) " SELECT COUNT(*) AS count, td.tid, td.vid, td.name, td.description FROM {term_data} td INNER JOIN {term_node} tn ON td.tid = tn.tid INNER JOIN {node} n ON tn.vid = n.vid WHERE td.vid IN (%d) GROUP BY td.tid, td.vid, td.name, td.description HAVING COUNT(*) > 0 ORDER BY count DESC" string(1) "n" string(3) "nid" string(278) " SELECT COUNT(*) AS count, td.tid, td.vid, td.name, td.description FROM {term_data} td INNER JOIN {term_node} tn ON td.tid = tn.tid INNER JOIN {node} n ON tn.vid = n.vid WHERE td.vid IN (%d) GROUP BY td.tid, td.vid, td.name, td.description HAVING COUNT(*) > 0 ORDER BY count DESC" string(1) "n" string(3) "nid" string(241) " SELECT n.uid, n.created FROM {node} n WHERE n.status = 1 AND n.type IN ('blog', 'forum', 'ipaper', 'book', 'infotravel', 'infrastructures', 'law', 'ogbase', 'organenterprise', 'page', 'personalphotogallery', 'relax', 'spatialdata', 'story') " string(4) "node" string(3) "nid" string(245) " SELECT DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 7200 SECOND), '%Y%m') AS created_year_month, COUNT(node.nid) AS num_records FROM {node} node WHERE node.status <> 0 GROUP BY created_year_month ORDER BY created_year_month DESC " string(4) "node" string(3) "nid" string(245) " SELECT DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 7200 SECOND), '%Y%m') AS created_year_month, COUNT(node.nid) AS num_records FROM {node} node WHERE node.status <> 0 GROUP BY created_year_month ORDER BY created_year_month DESC " string(1) "n" string(3) "nid" string(109) " SELECT n.nid, n.title, n.created FROM {node} n WHERE n.type = 'blog' AND n.status = 1 ORDER BY n.created DESC" string(1) "n" string(3) "nid" string(108) " SELECT MAX(n.created) FROM {node} n INNER JOIN {poll} p ON p.nid = n.nid WHERE n.status = 1 AND p.active = 1" string(4) "node" string(3) "nid" string(311) " SELECT node.nid AS nid, node_revisions.title AS node_revisions_title, node_revisions.nid AS node_revisions_nid, node.type AS node_type FROM {node} node LEFT JOIN {node_revisions} node_revisions ON node.vid = node_revisions.vid WHERE (node.status <> 0) AND (node.nid = %d) ORDER BY node_type ASC " string(4) "node" string(3) "nid" string(167) " SELECT node.nid AS nid FROM {node} node LEFT JOIN {node_revisions} node_revisions ON node.vid = node_revisions.vid WHERE (node.status <> 0) AND (node.nid = %d) " string(1) "n" string(3) "nid" string(63) " SELECT n.nid FROM {node} n WHERE n.status = 1 AND n.nid IN (%d)"