Help with sql request
2 USD From . . .by DB_PREFIXThe product p
Let’s join.”by DB_PREFIX“Product_attribute by
ON(pa.product_id = p.product_id AND pa.attribute_id = '392')
WHERE p.image IS NULL GROUP BY p.product_id`This is for a photo from a similar productSELECT DISTINCT(p.image)
From . . .by DB_PREFIX“Product_attribute by
Let’s join.”by DB_PREFIXThe product p
ON(pa.product_id = p.product_id)
WHERE pa.text LIKE '"$model"AND pa.language_id = '.$language_id.'AND pa.attribute_id = '.$attr_id.'and p.image is not zero
Group by p.product_id
LIMIT 1How can all this be implemented with 1 request?That would immediately get the goods in which you have no photo from the first request and there are similar photos from the second request.Goods that do not have similar photos must be dismissed.Payment on the private bank card.
Client's review of cooperation with Aleksandr Polischuk
Help with sql requestAlexander with the assigned task managed without problems and very quickly! I recommend cooperation.
Freelancer's review of cooperation with Igor Gladkov
Help with sql requestA clear and clear task, the customer is quickly contacted. I recommend cooperation.
-
Winning proposal1 day2 USD
894 44 0 Winning proposal1 day2 USD
Good day . Write to Ls, I have a ready solution. Checked on Opencart, it works.
Current freelance projects in the category Databases & SQL
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 3 days 13 hours back ∙ 6 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 3 days 16 hours back ∙ 19 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 5 days 7 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"
Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 6 days 12 hours back ∙ 36 proposals |
Development of an analytical Power BI dashboard
45 USD
This is our request, we need a person who understands Power BI: Screen 1: Strategic Cockpit (Financial Health of the Plant) Goal: To understand in 5 seconds, "where are we losing money and how much?". KPI Tiles (Top Bar): Overall margin (Actual vs Plan) in %. Amount of "lost… Databases & SQL ∙ 6 days 16 hours back ∙ 13 proposals |
Kharkiv