select product id & product quantity from orders

I necessary get all products with order_id, order_date, product_id, product_quantity . But with query below i get two rows for 1 product: for _qty and _product_id . I need one row.

    $posts_table = $wpdb->posts;

    SELECT p.ID, p.post_date, i.order_item_id, im.meta_value, im.meta_key
    FROM $posts_table as p
    INNER JOIN wp_woocommerce_order_items as i
    ON p.ID = i.order_id
    INNER JOIN wp_woocommerce_order_itemmeta AS im
    ON im.order_item_id = i.order_item_id
    WHERE p.post_type='shop_order' AND (p.post_status='wc-completed' OR p.post_status='wc-delivered' OR p.post_status='wc-processing' OR p.post_status='wc-processing-noinvoice' OR p.post_status='wc-closed') AND i.order_item_type!='shipping' AND (im.meta_key='_qty' OR im.meta_key='_product_id')
    ORDER BY p.ID ASC

I get:

and

I need: