SELECT COUNT(*) AS expression
FROM
(SELECT DISTINCT node.title AS node_title, node.nid AS nid, field_data_field_term_colors.delta AS field_data_field_term_colors_delta, field_data_field_term_materials.delta AS field_data_field_term_materials_delta, field_data_field_term_product_categories.delta AS field_data_field_term_product_categories_delta, field_data_field_term_rooms.delta AS field_data_field_term_rooms_delta, field_data_field_term_topics.delta AS field_data_field_term_topics_delta, node.created AS node_created, 'node' AS field_data_field_photo_square_node_entity_type, 1 AS expression
FROM
node node
LEFT JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND flag_content_node.fid = '2'
LEFT JOIN field_data_field_term_rooms field_data_field_term_rooms ON node.nid = field_data_field_term_rooms.entity_id AND (field_data_field_term_rooms.entity_type = 'node' AND field_data_field_term_rooms.deleted = '0')
LEFT JOIN field_data_field_term_colors field_data_field_term_colors ON node.nid = field_data_field_term_colors.entity_id AND (field_data_field_term_colors.entity_type = 'node' AND field_data_field_term_colors.deleted = '0')
LEFT JOIN field_data_field_term_materials field_data_field_term_materials ON node.nid = field_data_field_term_materials.entity_id AND (field_data_field_term_materials.entity_type = 'node' AND field_data_field_term_materials.deleted = '0')
LEFT JOIN field_data_field_term_product_categories field_data_field_term_product_categories ON node.nid = field_data_field_term_product_categories.entity_id AND (field_data_field_term_product_categories.entity_type = 'node' AND field_data_field_term_product_categories.deleted = '0')
LEFT JOIN field_data_field_term_topics field_data_field_term_topics ON node.nid = field_data_field_term_topics.entity_id AND (field_data_field_term_topics.entity_type = 'node' AND field_data_field_term_topics.deleted = '0')
WHERE (( (node.status = '1') AND (node.type IN  ('article', 'video')) AND (field_data_field_term_rooms.field_term_rooms_tid IS NOT NULL ) )))