$query = "SELECT node.type AS node_type, COUNT(node.type) AS node_type_1 FROM {node} node LEFT JOIN {field_data_field_state} field_data_field_state ON node.nid = field_data_field_state.entity_id AND (field_data_field_state.entity_type = 'node' AND field_data_field_state.deleted = '0') WHERE (( (node.type IN  ('product')) AND (node.status = '1') AND (field_data_field_state.field_state_value NOT LIKE 'Published' ESCAPE '\\') AND (field_data_field_state.field_state_value NOT LIKE 'Draft' ESCAPE '\\') )) GROUP BY node_type";