Hello, i did this query on Magento 2.2.6
so.increment_id, so.created_at, so.customer_firstname, so.customer_email, soi.product_options
ON so.increment_id = soi.order_id
[login to view URL] = 'processing'
so.customer_email NOT LIKE '%amazon%'
AND soi.product_options LIKE '%location%'
GROUP BY so.increment_id
ORDER BY so.increment_id ASC
but it doesnt working because in sales_order_item the order_id is not the increment_id of sales order.
I didn't find the order id in sales_order_item, but i need it for collect data indicated in the select.
Plz, magento expert, explain me how make this query
9 freelancer đang chào giá trung bình €27 cho công việc này
Sir, I read your requirement carefully and am interested in your project. I'm expert MySQL databases, I can correct your queries in less than hour. Thanks for reading.