Đã hoàn thành

Make a query


I need to add in this query, for magento 2.2.3:

SELECT e.entity_id AS 'ID',

[login to view URL] as 'SKU',

[login to view URL] AS 'Product name',

[login to view URL] AS 'Quantity',

[login to view URL] as 'Manufacturer',

[login to view URL] as 'Visibility',

[login to view URL] as 'Status'

FROM catalog_product_entity e

LEFT JOIN catalog_product_entity_varchar v1 ON e.entity_id = v1.entity_id

AND v1.store_id = 0

AND v1.attribute_id =

(SELECT attribute_id

FROM eav_attribute

WHERE attribute_code = 'name'

AND entity_type_id =

(SELECT entity_type_id

FROM eav_entity_type

WHERE entity_type_code = 'catalog_product'))

LEFT JOIN catalog_product_entity_int i1 ON e.entity_id = i1.entity_id

AND i1.store_id = 0

AND i1.attribute_id = 83


eav_attribute_option o

ON [login to view URL] = o.option_id


eav_attribute_option_value v

ON o.option_id = v.option_id AND

v.store_id = 0

LEFT JOIN catalog_product_flat_1 t4 ON e.entity_id = t4.entity_id

2 information in more

. View (how may time has been view the product)

. Sold (how much has been sold in last 2 months)

Kĩ năng: Magento, MySQL

Xem nhiều hơn: hello i need a logo for my site details in private, hello i need a presentation like this original presentation, hello i need to create a logo and a name to put on my clothing brand, hello i need urgent typist you just have to write in notepad from image i, i want to make a catalog i need designers, i need a cheap 3 page website design, Hello! I need a logo , I need to design 3 (three) mockups for the website., Hello i need 100$ in NETELLER, i am ready to pay here 160$ in advance !URGENT, hello, i need, Hello i need 90Euro , Hello i need, Hello. I need to come up with a cover design children\ s books 20 pages., Hello, i need 90$ to my skrill ac.because i can\ t withdrall my funds more then 10 days from here, i\ m ready to pay here 155$ f, Hello, i need 90$ to my skrill , I\ m looking for someone to draw simple house plans cheap. I need 2 or 3 a year, HELLO,I NEED A LITTLE PROJECT DONE REAL FAST AND WILL NEED A GOOD CODER TO DO THAT FOR ME.IF YOURE GOOD WITH PYTHON YOU ALSO WEL, do i need a boc-3, do i need add-in express

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

ID dự án: #30202638

Được trao cho:


Hello, there. I am a MERN full-stack developer with many experiences of *** front-end & back-end development. During meeting with front-end & back-end development, I have plenty of experiences in React framework, Nod Thêm

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

10 freelancer chào giá trung bình€51 cho công việc này


Hi, I can help you in adding your query, for Magento 2 Let me know when you here to discuss more in detailed about Job. I am having 10 years experience on Magento 1 & 2 development. You can check my profile : https Thêm

€90 EUR trong 1 ngày
(56 Nhận xét)
(33 Nhận xét)

Hello Sir, I can help you in preparing the sql query and showing results in form of Magento 2 grid. So you will able to see the result in proper way. Let me know when you available to discuss more about it I am having Thêm

€50 EUR trong 1 ngày
(28 Nhận xét)

Hello, dear. How are you today? As an experienced magento2 developer, I can make you queries perfectly. Hope to discuss more via chat. Thank you. Ramazan.

€50 EUR trong 7 ngày
(10 Nhận xét)

Hi there I have gone through your project detail and I am much confident to do all of the Listed optimization and enhancements to make your existing site more functional and visually appealing in minimum of time as pe Thêm

€25 EUR trong 4 ngày
(23 Nhận xét)

Hello project manager, I hope you are doing well * Magento Customization Expert* I have 5+ years experience in development fields with full customization in Magento, Magento2 starting from my carrier. but new in th Thêm

€29 EUR trong 1 ngày
(15 Nhận xét)

***Magento Expert*** Hi There, I Have gone through your initial project requirement and I have the exact match with the Skills you are looking for a current project. I am ready to work on this project and can start Thêm

€19 EUR trong 3 ngày
(16 Nhận xét)

Hi there , How are you? This is Qandil I am web developer, having over 3 years of experience on freelancer . I can work on your project to deliver you according to the requirements. For more discussion on the project , Thêm

€30 EUR trong 1 ngày
(4 Nhận xét)

Hello. I've just checked your job description carefully. I'm a senior full-stack developer with 7+ years experiences in web development using CorePHP/Laravel/CI/Wordpress, React/Angular, Mysql/Postgresql/Mongo and so o Thêm

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