user warning: Table './db60648_wikistock/search_index' is marked as crashed and should be repaired
query: SELECT COUNT(*) FROM (SELECT DISTINCT(feeds_data_syndication.id) AS id,
SUM(search_index.score * search_total.count) AS score,
node_feeds_data_syndication__feeds_source.config AS node_feeds_data_syndication__feeds_source_config,
node_feeds_data_syndication.nid AS node_feeds_data_syndication_nid,
feeds_data_syndication.url AS feeds_data_syndication_url,
feeds_data_syndication.timestamp AS feeds_data_syndication_timestamp,
node_feeds_data_syndication.title AS node_feeds_data_syndication_title,
feeds_data_syndication.title AS feeds_data_syndication_title,
feeds_data_syndication.description AS feeds_data_syndication_description
FROM feeds_data_syndication feeds_data_syndication
INNER JOIN node node_feeds_data_syndication ON feeds_data_syndication.feed_nid = node_feeds_data_syndication.nid
LEFT JOIN data_taxonomy data_taxonomy_feeds_data_syndication ON feeds_data_syndication.id = data_taxonomy_feeds_data_syndication.id
LEFT JOIN term_data term_data_data_taxonomy ON data_taxonomy_feeds_data_syndication.tid = term_data_data_taxonomy.tid AND term_data_data_taxonomy.vid = 2
LEFT JOIN votingapi_vote votingapi_vote_feeds_data_syndication_mark_trash ON feeds_data_syndication.id = votingapi_vote_feeds_data_syndication_mark_trash.content_id AND (votingapi_vote_feeds_data_syndication_mark_trash.content_type = 'feeds_data_syndication' AND votingapi_vote_feeds_data_syndication_mark_trash.value_type = 'mark' AND votingapi_vote_feeds_data_syndication_mark_trash.tag = 'trash')
LEFT JOIN search_index search_index ON feeds_data_syndication.id = search_index.sid
LEFT JOIN search_total search_total ON search_index.word = search_total.word
LEFT JOIN feeds_source node_feeds_data_syndication__feeds_source ON node_feeds_data_syndication.nid = node_feeds_data_syndication__feeds_source.feed_nid
WHERE (search_index.word = 'appl') AND (search_index.type = 'feeds_data_syndication') AND (feeds_data_syndication.timestamp >= 1283799986-7866000) AND (feeds_data_syndication.timestamp <= 1283799986+0) AND (votingapi_vote_feeds_data_syndication_mark_trash.value IS NULL)
GROUP BY search_index.sid, feeds_data_syndication_timestamp, id
HAVING COUNT(*) >= 1
ORDER BY feeds_data_syndication_timestamp DESC
) count_alias in /nfs/c04/h05/mnt/60648/domains/wikistock.com/html/profiles/managingnews/modules/contrib/views/includes/view.inc on line 745.
user warning: Table './db60648_wikistock/search_index' is marked as crashed and should be repaired
query: SELECT DISTINCT(feeds_data_syndication.id) AS id,
SUM(search_index.score * search_total.count) AS score,
node_feeds_data_syndication__feeds_source.config AS node_feeds_data_syndication__feeds_source_config,
node_feeds_data_syndication.nid AS node_feeds_data_syndication_nid,
feeds_data_syndication.url AS feeds_data_syndication_url,
feeds_data_syndication.timestamp AS feeds_data_syndication_timestamp,
node_feeds_data_syndication.title AS node_feeds_data_syndication_title,
feeds_data_syndication.title AS feeds_data_syndication_title,
feeds_data_syndication.description AS feeds_data_syndication_description
FROM feeds_data_syndication feeds_data_syndication
INNER JOIN node node_feeds_data_syndication ON feeds_data_syndication.feed_nid = node_feeds_data_syndication.nid
LEFT JOIN data_taxonomy data_taxonomy_feeds_data_syndication ON feeds_data_syndication.id = data_taxonomy_feeds_data_syndication.id
LEFT JOIN term_data term_data_data_taxonomy ON data_taxonomy_feeds_data_syndication.tid = term_data_data_taxonomy.tid AND term_data_data_taxonomy.vid = 2
LEFT JOIN votingapi_vote votingapi_vote_feeds_data_syndication_mark_trash ON feeds_data_syndication.id = votingapi_vote_feeds_data_syndication_mark_trash.content_id AND (votingapi_vote_feeds_data_syndication_mark_trash.content_type = 'feeds_data_syndication' AND votingapi_vote_feeds_data_syndication_mark_trash.value_type = 'mark' AND votingapi_vote_feeds_data_syndication_mark_trash.tag = 'trash')
LEFT JOIN search_index search_index ON feeds_data_syndication.id = search_index.sid
LEFT JOIN search_total search_total ON search_index.word = search_total.word
LEFT JOIN feeds_source node_feeds_data_syndication__feeds_source ON node_feeds_data_syndication.nid = node_feeds_data_syndication__feeds_source.feed_nid
WHERE (search_index.word = 'appl') AND (search_index.type = 'feeds_data_syndication') AND (feeds_data_syndication.timestamp >= 1283799986-7866000) AND (feeds_data_syndication.timestamp <= 1283799986+0) AND (votingapi_vote_feeds_data_syndication_mark_trash.value IS NULL)
GROUP BY search_index.sid, feeds_data_syndication_timestamp, id
HAVING COUNT(*) >= 1
ORDER BY feeds_data_syndication_timestamp DESC
LIMIT 0, 10 in /nfs/c04/h05/mnt/60648/domains/wikistock.com/html/profiles/managingnews/modules/contrib/views/includes/view.inc on line 771.
user warning: Table './db60648_wikistock/search_index' is marked as crashed and should be repaired
query: SELECT SUM(search_index.score * search_total.count) AS score,
feeds_data_syndication.timestamp AS feeds_data_syndication_timestamp,
feeds_data_syndication.id AS id
FROM feeds_data_syndication feeds_data_syndication
INNER JOIN node node_feeds_data_syndication ON feeds_data_syndication.feed_nid = node_feeds_data_syndication.nid
LEFT JOIN data_taxonomy data_taxonomy_feeds_data_syndication ON feeds_data_syndication.id = data_taxonomy_feeds_data_syndication.id
LEFT JOIN term_data term_data_data_taxonomy ON data_taxonomy_feeds_data_syndication.tid = term_data_data_taxonomy.tid AND term_data_data_taxonomy.vid = 2
LEFT JOIN votingapi_vote votingapi_vote_feeds_data_syndication_mark_trash ON feeds_data_syndication.id = votingapi_vote_feeds_data_syndication_mark_trash.content_id AND (votingapi_vote_feeds_data_syndication_mark_trash.content_type = 'feeds_data_syndication' AND votingapi_vote_feeds_data_syndication_mark_trash.value_type = 'mark' AND votingapi_vote_feeds_data_syndication_mark_trash.tag = 'trash')
LEFT JOIN search_index search_index ON feeds_data_syndication.id = search_index.sid
LEFT JOIN search_total search_total ON search_index.word = search_total.word
WHERE (search_index.word = 'appl') AND (search_index.type = 'feeds_data_syndication') AND (feeds_data_syndication.timestamp >= 1283799987-1209600) AND (feeds_data_syndication.timestamp <= 1283799987+0) AND (votingapi_vote_feeds_data_syndication_mark_trash.value IS NULL)
GROUP BY feeds_data_syndication_timestamp, id
ORDER BY feeds_data_syndication_timestamp ASC
in /nfs/c04/h05/mnt/60648/domains/wikistock.com/html/profiles/managingnews/modules/contrib/views/includes/view.inc on line 775.
user warning: Table './db60648_wikistock/search_index' is marked as crashed and should be repaired
query: SELECT feeds_data_syndication.id AS id,
SUM(search_index.score * search_total.count) AS score,
feeds_data_syndication.timestamp AS feeds_data_syndication_timestamp
FROM feeds_data_syndication feeds_data_syndication
INNER JOIN node node_feeds_data_syndication ON feeds_data_syndication.feed_nid = node_feeds_data_syndication.nid
LEFT JOIN data_taxonomy data_taxonomy_feeds_data_syndication ON feeds_data_syndication.id = data_taxonomy_feeds_data_syndication.id
LEFT JOIN term_data term_data_data_taxonomy ON data_taxonomy_feeds_data_syndication.tid = term_data_data_taxonomy.tid AND term_data_data_taxonomy.vid = 2
LEFT JOIN votingapi_vote votingapi_vote_feeds_data_syndication_mark_trash ON feeds_data_syndication.id = votingapi_vote_feeds_data_syndication_mark_trash.content_id AND (votingapi_vote_feeds_data_syndication_mark_trash.content_type = 'feeds_data_syndication' AND votingapi_vote_feeds_data_syndication_mark_trash.value_type = 'mark' AND votingapi_vote_feeds_data_syndication_mark_trash.tag = 'trash')
LEFT JOIN search_index search_index ON feeds_data_syndication.id = search_index.sid
LEFT JOIN search_total search_total ON search_index.word = search_total.word
WHERE (search_index.word = 'appl') AND (search_index.type = 'feeds_data_syndication') AND (feeds_data_syndication.timestamp >= 1283799987-7866000) AND (feeds_data_syndication.timestamp <= 1283799987+0) AND (votingapi_vote_feeds_data_syndication_mark_trash.value IS NULL)
GROUP BY search_index.sid, feeds_data_syndication_timestamp, id
HAVING COUNT(*) >= 1
ORDER BY feeds_data_syndication_timestamp DESC
LIMIT 0, 50 in /nfs/c04/h05/mnt/60648/domains/wikistock.com/html/profiles/managingnews/modules/contrib/views/includes/view.inc on line 771.
user warning: Table './db60648_wikistock/search_index' is marked as crashed and should be repaired
query: SELECT DISTINCT(feeds_data_syndication.id) AS id,
SUM(search_index.score * search_total.count) AS score,
node_feeds_data_syndication__feeds_source.config AS node_feeds_data_syndication__feeds_source_config,
feeds_data_syndication.url AS feeds_data_syndication_url,
feeds_data_syndication.description AS feeds_data_syndication_description,
feeds_data_syndication.title AS feeds_data_syndication_title,
term_data_data_taxonomy__term_geo.lat AS term_data_data_taxonomy__term_geo_lat,
term_data_data_taxonomy__term_geo.lon AS term_data_data_taxonomy__term_geo_lon,
term_data_data_taxonomy.name AS term_data_data_taxonomy_name,
term_data_data_taxonomy.vid AS term_data_data_taxonomy_vid,
term_data_data_taxonomy.tid AS term_data_data_taxonomy_tid,
term_data_data_taxonomy_1.name AS term_data_data_taxonomy_1_name,
term_data_data_taxonomy_1.vid AS term_data_data_taxonomy_1_vid,
term_data_data_taxonomy_1.tid AS term_data_data_taxonomy_1_tid,
feeds_data_syndication.timestamp AS feeds_data_syndication_timestamp
FROM feeds_data_syndication feeds_data_syndication
INNER JOIN node node_feeds_data_syndication ON feeds_data_syndication.feed_nid = node_feeds_data_syndication.nid
INNER JOIN data_taxonomy data_taxonomy_feeds_data_syndication ON feeds_data_syndication.id = data_taxonomy_feeds_data_syndication.id
LEFT JOIN data_taxonomy data_taxonomy_feeds_data_syndication_1 ON feeds_data_syndication.id = data_taxonomy_feeds_data_syndication_1.id
INNER JOIN term_data term_data_data_taxonomy ON data_taxonomy_feeds_data_syndication.tid = term_data_data_taxonomy.tid AND term_data_data_taxonomy.vid = 1
LEFT JOIN data_taxonomy data_taxonomy ON feeds_data_syndication.id = data_taxonomy.id
LEFT JOIN term_data term_data_data_taxonomy_1 ON data_taxonomy.tid = term_data_data_taxonomy_1.tid AND term_data_data_taxonomy_1.vid = 2
LEFT JOIN votingapi_vote votingapi_vote_feeds_data_syndication_mark_trash ON feeds_data_syndication.id = votingapi_vote_feeds_data_syndication_mark_trash.content_id AND (votingapi_vote_feeds_data_syndication_mark_trash.content_type = 'feeds_data_syndication' AND votingapi_vote_feeds_data_syndication_mark_trash.value_type = 'mark' AND votingapi_vote_feeds_data_syndication_mark_trash.tag = 'trash')
LEFT JOIN search_index search_index ON feeds_data_syndication.id = search_index.sid
LEFT JOIN search_total search_total ON search_index.word = search_total.word
LEFT JOIN feeds_source node_feeds_data_syndication__feeds_source ON node_feeds_data_syndication.nid = node_feeds_data_syndication__feeds_source.feed_nid
LEFT JOIN term_geo term_data_data_taxonomy__term_geo ON term_data_data_taxonomy.tid = term_data_data_taxonomy__term_geo.tid
WHERE (search_index.word = 'appl') AND (search_index.type = 'feeds_data_syndication') AND (feeds_data_syndication.timestamp >= 1283799987-7866000) AND (feeds_data_syndication.timestamp <= 1283799987+0) AND (votingapi_vote_feeds_data_syndication_mark_trash.value IS NULL)
GROUP BY search_index.sid, feeds_data_syndication_timestamp, id
HAVING COUNT(*) >= 1
ORDER BY feeds_data_syndication_timestamp DESC
LIMIT 0, 10 in /nfs/c04/h05/mnt/60648/domains/wikistock.com/html/profiles/managingnews/modules/contrib/views/includes/view.inc on line 771.