SELECT n.nid AS nid, n.title AS title, n.sticky AS sticky, n.created AS created, year.field_class_note_class_year_value AS field_class_note_class_year_value FROM {node} n INNER JOIN {field_data_field_class_note_class_year} year ON n.nid = year.entity_id WHERE (n.type = :db_condition_placeholder_0) AND (n.status = :db_condition_placeholder_1) AND (year.field_class_note_class_year_value = :db_condition_placeholder_2) AND (created BETWEEN :db_condition_placeholder_3 AND :db_condition_placeholder_4) ORDER BY field_class_note_class_year_value ASC, created DESC