Đang Thực Hiện

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

Kĩ năng: Magento, MySQL

Xem nhiều hơn: edit csv mysql query, asp mysql query, 2013 lost connection mysql query, mysql query report, php mysql query table, mysql query record bash, mysql query csv file, fix mysql errors, write mysql query, optimize mysql query software, mysql query php table css, php mysql query format table, mysql query search, cacti custom mysql query, google map mysql query results, mysql fix 2013 query, fix mysql query error, fix mysql query

Về Bên Thuê:
( 188 nhận xét ) Villanova Mondovì, Italy

ID dự án: #22357880

Được trao cho:

mrjob05

Hi there, I can help you with your query. The problem could be with your join or grouping. Check the relation (primary - foreign key) columns between the two tables. I'll have to have a look at your database schema Thêm

€20 EUR trong 1 ngày
(0 Đánh Giá)
0.0

9 freelancer đang chào giá trung bình €27 cho công việc này

gursukh

yes sure i can help you right now

€30 EUR trong 0 ngày
(173 Nhận xét)
6.7
sat12

i will create a correct mysql query..............................................................................

€80 EUR trong 1 ngày
(171 Nhận xét)
6.2
nixtech

Hello Sir, Can i help you with the query please? I am willing to start right away. Please check my profile for work and experience. Regards Ashwin

€35 EUR trong 1 ngày
(80 Nhận xét)
5.6
TechZeal1988

Hello, I saw your job posting and I hastened to submit my proposal for your review. According to your job description, you need a professional experienced web developer who's done your job with out of the box quality. Thêm

€20 EUR trong 2 ngày
(9 Nhận xét)
4.0
Zeeshan0489

I WILL FIX IN 20 MINUTES... Hi there! I've read the project details and ready to start making but can you message me i want to ask some questions about that. I am new to freelancer but i have an experience of more tha Thêm

€12 EUR trong 7 ngày
(5 Nhận xét)
3.1
adricabrelles

Hi I am a Sènior Dba with more than 15 years experience. I can help you.

€23 EUR trong 1 ngày
(3 Nhận xét)
2.4
ayyar1

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.

€19 EUR trong 1 ngày
(1 Nhận xét)
0.7
nikkobanac1996

I have used MYSQL database administration before. Please send me a sample database so i can start working on it

€8 EUR trong 1 ngày
(0 Nhận xét)
0.0