Suoritettu

Make a query

Hello

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

LEFT JOIN

eav_attribute_option o

ON [login to view URL] = o.option_id

LEFT JOIN

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)

Taidot: Magento, MySQL

Näytä lisää: 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

Tietoa työnantajasta:
( 205 arvostelua ) Villanova Mondovì, Italy

Projektin tunnus: #30202638

Myönnetty käyttäjälle:

SerhiiK333

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 Lisää

€20 EUR 2 päivässä
(0 Arvostelua)
0.0

10 freelanceria on tarjonnut keskimäärin €51 tähän työhön

AltiuseCreaton

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 Lisää

€90 EUR 1 päivässä
(56 arvostelua)
6.6
(33 arvostelua)
5.8
amitvishva1995

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 Lisää

€50 EUR 1 päivässä
(28 arvostelua)
5.4
DeveloperRamazan

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 7 päivässä
(10 arvostelua)
4.7
sellingsparrow

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 Lisää

€25 EUR 4 päivässä
(23 arvostelua)
4.7
magentosking

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 Lisää

€29 EUR 1 päivässä
(15 arvostelua)
4.3
proweblancerds

***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 Lisää

€19 EUR 3 päivässä
(16 arvostelua)
4.4
wadielnatrontv

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 , Lisää

€30 EUR 1 päivässä
(4 arvostelua)
3.2
lazardevobr2

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 Lisää

€50 EUR 1 päivässä
(0 arvostelua)
0.0