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)

Skills: Magento, MySQL

See more: 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

About the Employer:
( 205 reviews ) Villanova Mondovì, Italy

Project ID: #30202638

Awarded to:


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 More

€20 EUR in 2 days
(0 Reviews)

10 freelancers are bidding on average €51 for this job


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 More

€90 EUR in 1 day
(56 Reviews)
(33 Reviews)

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 More

€50 EUR in 1 day
(28 Reviews)

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 in 7 days
(10 Reviews)

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 More

€25 EUR in 4 days
(23 Reviews)

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 More

€29 EUR in 1 day
(15 Reviews)

***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 More

€19 EUR in 3 days
(16 Reviews)

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 , More

€30 EUR in 1 day
(4 Reviews)

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 More

€50 EUR in 1 day
(0 Reviews)