SELECT DISTINCT node.title AS node_title, node.nid AS nid, field_data_field_news_category.field_news_category_tid AS field_news_category_tid, 'node' AS field_data_field_image_node_entity_type, 'node' AS field_data_field_news_category_node_entity_type, DATE_FORMAT((DATE_ADD('19700101', INTERVAL node.created SECOND) + INTERVAL 10800 SECOND), '%Y%m%d%H%i') AS node_created_minute
FROM node LEFT JOIN field_data_field_news_category ON field_data_field_news_category.field_news_category_tid != NULL
WHERE (( (node.status = '1') AND (node.type IN ('news')) ))
GROUP BY field_news_category_tid
ORDER BY node_created_minute DESC LIMIT 10 OFFSET 0