SELECT node.nid AS nid,
   SUM(search_index.score * search_total.count) AS score,
   node_data_field_picture.field_picture_fid AS node_data_field_picture_field_picture_fid,
   node_data_field_picture.field_picture_list AS node_data_field_picture_field_picture_list,
   node_data_field_picture.field_picture_data AS node_data_field_picture_field_picture_data,
   node.type AS node_type,
   node.vid AS node_vid,
   node.title AS node_title,
   node_revisions.teaser AS node_revisions_teaser,
   node_revisions.format AS node_revisions_format,
   node.created AS node_created
 FROM node node 
 LEFT JOIN search_index search_index ON node.nid = search_index.sid
 LEFT JOIN search_total search_total ON search_index.word = search_total.word
 LEFT JOIN content_field_picture node_data_field_picture ON node.vid = node_data_field_picture.vid
 LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
 WHERE (search_index.word = 'steak') AND (search_index.type = 'node') AND (node.type in ('recipe')) AND (node.status <> 0)
 GROUP BY search_index.sid, node_created, nid, node_data_field_picture_field_picture_fid, node_data_field_picture_field_picture_list, node_data_field_picture_field_picture_data, node_type, node_vid, node_title, node_revisions_teaser, node_revisions_format
 HAVING COUNT(*) >= 1
 ORDER BY node_created DESC