mysql - 如何限制左连接中的记录

Question

SELECT commerce_product_field_data_commerce_product__field_data_field_products.entity_id, field_products_commerce_product.nid FROM commerce_order o 
            join  commerce_payment_transaction t on o.order_id = t.order_id 
            join commerce_line_item i on o.order_id = i.order_id
            LEFT JOIN field_data_commerce_total s ON i.line_item_id = s.entity_id AND (s.entity_type = 'commerce_line_item' AND s.deleted = '0')
                LEFT JOIN field_data_commerce_product field_data_commerce_product ON i.line_item_id = field_data_commerce_product.entity_id AND (field_data_commerce_product.entity_type = 'commerce_line_item' AND field_data_commerce_product.deleted = '0')
        INNER JOIN commerce_product commerce_product_field_data_commerce_product ON field_data_commerce_product.commerce_product_product_id = commerce_product_field_data_commerce_product.product_id
        LEFT JOIN 


    (select * from field_data_field_products) 



    commerce_product_field_data_commerce_product__field_data_field_products ON commerce_product_field_data_commerce_product.product_id = commerce_product_field_data_commerce_product__field_data_field_products.field_products_product_id




    LEFT JOIN ( select nid as nid from node order by nid)



    field_products_commerce_product




    ON commerce_product_field_data_commerce_product__field_data_field_products.entity_id = field_products_commerce_product.nid LEFT JOIN (
    select r.entity_id, r.field_ranges_value from field_data_field_ranges r
    ) r

             on r.entity_id = field_products_commerce_product.nid
            WHERE t.status = 'success' and i.type = 'product' and o.Uid <> 0
         AND o.status IN  ('completed') and o.created >= '1483228800'  and o.created <= '1483315200'  and r.field_ranges_value = 'Tasty Sticks'

是我的sql

它给了我5个结果。我只需要4

产品 ID 之一属于两个 Drupal 节点，我只想要其中一个

我尝试将 LEFT JOIN ( select nid as nid from node order by nid) 更改为

LEFT JOIN（从节点顺序中选择 nid 作为 nid，按 nid 限制 1）但是我根本没有得到任何记录。除了删除其中一个重复节点之外，请知道需要更改的内容。谢谢

标签： mysqlsql