ideal body weight
- user warning: Incorrect key file for table '/tmp/#sql_9ec_1.MYI'; try to repair it
query: SELECT node.title AS node_title,
node.nid AS nid,
node.type AS node_type,
node.vid AS node_vid,
node_revisions.teaser AS node_revisions_teaser,
node_revisions.format AS node_revisions_format,
RAND() AS _random
FROM swportal_node node
LEFT JOIN swportal_node_revisions node_revisions ON node.vid = node_revisions.vid
WHERE (node.type in ('review', 'soft')) AND (node.status = 1) AND ((node_revisions.body) != (''))
ORDER BY _random ASC
LIMIT 0, 8 in /var/www/drupal/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1191.
- user warning: Incorrect key file for table '/tmp/#sql_9ec_1.MYI'; try to repair it
query: SELECT COUNT(*) FROM (SELECT comments.cid AS cid,
comments.nid AS comments_nid,
node_comments.nid AS node_comments_nid,
comments.timestamp AS comments_timestamp,
comments.name AS comments_name,
comments.uid AS comments_uid,
comments.homepage AS comments_homepage,
comments.subject AS comments_subject
FROM swportal_comments comments
LEFT JOIN swportal_node node_comments ON comments.nid = node_comments.nid
WHERE node_comments.status = 1 OR (node_comments.uid = 0 AND 0 <> 0) OR 0 = 1
) count_alias in /var/www/drupal/sites/all/modules/views/plugins/views_plugin_pager.inc on line 141.
