SELECT node.nid AS nid,
   node.created AS node_created,
   node.title AS node_title,
   node_counter.totalcount AS node_counter_totalcount,
   node_data_field_aflv_programma.field_aflv_info_value AS node_data_field_aflv_programma_field_aflv_info_value,
   node.type AS node_type,
   node.vid AS node_vid,
   node_data_field_aflv_date.field_aflv_date_value AS node_data_field_aflv_date_field_aflv_date_value
 FROM node node
 LEFT JOIN content_type_aflevering node_data_field_aflv_programma ON node.vid = node_data_field_aflv_programma.vid
 LEFT JOIN node_counter node_counter ON node.nid = node_counter.nid
 LEFT JOIN content_field_aflv_date node_data_field_aflv_date ON node.vid = node_data_field_aflv_date.vid
 WHERE (node.type in ('aflevering')) AND (node.status <> 0) AND (node_data_field_aflv_programma.field_aflv_programma_nid = 225)
   GROUP BY nid
   ORDER BY node_data_field_aflv_date_field_aflv_date_value ASC