SELECT node.nid AS nid, SUM(search_index.score * .count) AS score, node.title AS node_title, node.type AS node_type, node.vid AS node_vid, field_atc_value, field_comments_value, field_marketed_value, field_furtherinfo_value, field_noc_value, field_source_value FROM node node LEFT JOIN search_index search_index ON node.nid = search_index.sid LEFT JOIN search_total ON search_index.word = .word WHERE (node.status <> 0) AND (node.type in ('druglisting')) AND (search_index.word = 'lumiracoxib') AND (search_index.type = 'search_index') GROUP BY search_index.sid, node_title, nid, node_type, node_vid, field_atc_value, field_comments_value, field_marketed_value, field_furtherinfo_value, field_noc_value, field_source_value HAVING COUNT(*) >= 1 ORDER BY node_title ASC