- 🇧🇪Belgium Ludo.R Brussels
I just got a similar issue.
In my case I just wasn't filtering the node's language itself (I was only filtering on the paragraph's referenced entities language).
Views gives duplicate result
Steps to produce this issue.
Add a paragraph type (multi value) to content type. enable revision, have more revisions of the same content
Create a view (REST Export) with relationship to paragraph and taxonomy term in paragraph
Make query settings distinct
Enable aggregation, and in settings of uuid group by value
The result shows duplicate results
I have printed the query and executed on mysql server, which does not give duplicate results
Below is the sql query
SELECT DISTINCT paragraphs_item_field_data_node__field_vehicle_colors_section__paragraph__field_vehicle_color_image.field_vehicle_color_image_target_id AS paragraphs_item_field_data_node__field_vehicle_colors_sectio, paragraphs_item_field_data_node__field_vehicle_colors_section.langcode AS paragraphs_item_field_data_node__field_vehicle_colors_sectio_1, taxonomy_term_field_data_paragraph__field_vehicl_color_thumb__taxonomy_term__field_color_image_thumbnail.field_color_image_thumbnail_target_id AS taxonomy_term_field_data_paragraph__field_vehicl_color_thumb, taxonomy_term_field_data_paragraph__field_vehicl_color_thumb.langcode AS taxonomy_term_field_data_paragraph__field_vehicl_color_thumb_1, paragraphs_item_field_data_node__field_vehicle_colors_section__paragraph__field_vehicl_color_thumb.field_vehicl_color_thumb_target_id AS paragraphs_item_field_data_node__field_vehicle_colors_sectio_2, node_field_data.langcode AS node_field_data_langcode, node__field_360_degree.field_360_degree_value AS node__field_360_degree_field_360_degree_value, taxonomy_term_field_data_paragraph__field_vehicl_color_thumb__taxonomy_term_data.uuid AS taxonomy_term_field_data_paragraph__field_vehicl_color_thumb_2, node_field_data.created AS node_field_data_created, node__field_weight.field_weight_value AS node__field_weight_field_weight_value, node_field_data.nid AS nid, MIN(node_field_data.nid) AS nid_1, MIN(paragraphs_item_field_data_node__field_vehicle_colors_section.id) AS paragraphs_item_field_data_node__field_vehicle_colors_sectio_3, MIN(taxonomy_term_field_data_paragraph__field_vehicl_color_thumb.tid) AS taxonomy_term_field_data_paragraph__field_vehicl_color_thumb_3
FROM
node_field_data node_field_data
LEFT JOIN node__field_vehicle_colors_section node__field_vehicle_colors_section ON node_field_data.nid = node__field_vehicle_colors_section.entity_id AND (node__field_vehicle_colors_section.deleted = '0' AND node__field_vehicle_colors_section.langcode = node_field_data.langcode)
LEFT JOIN paragraphs_item_field_data paragraphs_item_field_data_node__field_vehicle_colors_section ON node__field_vehicle_colors_section.field_vehicle_colors_section_target_revision_id = paragraphs_item_field_data_node__field_vehicle_colors_section.revision_id
LEFT JOIN paragraph__field_vehicl_color_thumb paragraphs_item_field_data_node__field_vehicle_colors_section__paragraph__field_vehicl_color_thumb ON paragraphs_item_field_data_node__field_vehicle_colors_section.id = paragraphs_item_field_data_node__field_vehicle_colors_section__paragraph__field_vehicl_color_thumb.entity_id AND (paragraphs_item_field_data_node__field_vehicle_colors_section__paragraph__field_vehicl_color_thumb.deleted = '0' AND paragraphs_item_field_data_node__field_vehicle_colors_section__paragraph__field_vehicl_color_thumb.langcode = paragraphs_item_field_data_node__field_vehicle_colors_section.langcode)
LEFT JOIN taxonomy_term_field_data taxonomy_term_field_data_paragraph__field_vehicl_color_thumb ON paragraphs_item_field_data_node__field_vehicle_colors_section__paragraph__field_vehicl_color_thumb.field_vehicl_color_thumb_target_id = taxonomy_term_field_data_paragraph__field_vehicl_color_thumb.tid
LEFT JOIN paragraph__field_vehicle_color_image paragraphs_item_field_data_node__field_vehicle_colors_section__paragraph__field_vehicle_color_image ON paragraphs_item_field_data_node__field_vehicle_colors_section.id = paragraphs_item_field_data_node__field_vehicle_colors_section__paragraph__field_vehicle_color_image.entity_id AND (paragraphs_item_field_data_node__field_vehicle_colors_section__paragraph__field_vehicle_color_image.deleted = '0' AND paragraphs_item_field_data_node__field_vehicle_colors_section__paragraph__field_vehicle_color_image.langcode = paragraphs_item_field_data_node__field_vehicle_colors_section.langcode)
LEFT JOIN taxonomy_term__field_color_image_thumbnail taxonomy_term_field_data_paragraph__field_vehicl_color_thumb__taxonomy_term__field_color_image_thumbnail ON taxonomy_term_field_data_paragraph__field_vehicl_color_thumb.tid = taxonomy_term_field_data_paragraph__field_vehicl_color_thumb__taxonomy_term__field_color_image_thumbnail.entity_id AND taxonomy_term_field_data_paragraph__field_vehicl_color_thumb__taxonomy_term__field_color_image_thumbnail.deleted = '0'
LEFT JOIN node__field_colo node__field_colo ON node_field_data.nid = node__field_colo.entity_id AND (node__field_colo.deleted = '0' AND node__field_colo.langcode = node_field_data.langcode)
LEFT JOIN node__field_360_degree node__field_360_degree ON node_field_data.nid = node__field_360_degree.entity_id AND (node__field_360_degree.deleted = '0' AND node__field_360_degree.langcode = node_field_data.langcode)
INNER JOIN taxonomy_term_data taxonomy_term_field_data_paragraph__field_vehicl_color_thumb__taxonomy_term_data ON taxonomy_term_field_data_paragraph__field_vehicl_color_thumb.tid = taxonomy_term_field_data_paragraph__field_vehicl_color_thumb__taxonomy_term_data.tid
LEFT JOIN node__field_weight node__field_weight ON node_field_data.nid = node__field_weight.entity_id AND (node__field_weight.deleted = '0' AND node__field_weight.langcode = node_field_data.langcode)
WHERE ((node_field_data.nid = '5')) AND ((node_field_data.status = '1') AND (node_field_data.type IN ('vehicle')) AND (paragraphs_item_field_data_node__field_vehicle_colors_section.langcode IN ('', '', '', 'en')) AND (node_field_data.langcode IN ('en')))
GROUP BY node_field_data.nid, paragraphs_item_field_data_node__field_vehicle_colors_sectio, paragraphs_item_field_data_node__field_vehicle_colors_sectio_1, taxonomy_term_field_data_paragraph__field_vehicl_color_thumb, taxonomy_term_field_data_paragraph__field_vehicl_color_thumb_1, paragraphs_item_field_data_node__field_vehicle_colors_sectio_2, node_field_data_langcode, node__field_360_degree_field_360_degree_value, taxonomy_term_field_data_paragraph__field_vehicl_color_thumb_2, node_field_data_created, node__field_weight_field_weight_value
ORDER BY node_field_data_created DESC, node__field_weight_field_weight_value ASC
LIMIT 25 OFFSET 0Closed: cannot reproduce
9.4
Last updated
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
I just got a similar issue.
In my case I just wasn't filtering the node's language itself (I was only filtering on the paragraph's referenced entities language).