Fix Mysql query

Hello, i did this query on Magento 2.2.6 SELECT DISTINCT so.increment_id, so.created_at, so.customer_firstname, so.customer_email, soi.product_options FROM sales_order so INNER JOIN sales_order_item soi ON so.increment_id = soi.order_id WHERE [login to view URL] = 'processing' AND 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 Thank you