Create a SQl request
5 USD ps_customer and ps_address
It requires what id_customer would draw the value of id_gender in the request.
The query lacks the column id_gender that is in another ps_customer table.
The request itself is now processing without a dop column like this.
SELECT a.`id_address`, a.`firstname` AS `firstname`, a.`lastname` AS `lastname`, `address1`, `postcode`, `city`, cl.`id_country` AS `country`
, cl. `name` as country
From `ps_address` a
LEFT JOIN `ps_country_lang` cl ON (cl.`id_country` = a.`id_country` AND cl.`id_lang` = 3)
LEFT JOIN `ps_customer` c ON a.id_customer = c.id_customer
WHERE 1 AND a.id_customer != 0 AND c.id_shop IN (1) AND a.`deleted` = 0
Tables in the archive
Applications 1
Client's review of cooperation with Vladimir G.
Create a SQl requestEverything went well. The executor made the right request and explained the reason.
Freelancer's review of cooperation with Timur Timur
Create a SQl requestAll quickly, good customer.
-
Winning proposal2 days5 USD
1479 72 0 Winning proposal2 days5 USD
Hello to Timor.
Your project is interesting, I have been able to add the field.
Let’s find out that you’re wrong.
-
а если добавить в select еще с.id_gender что произойдет?
-
Пустой фалик формирует
-
можно еще дамп ps_country_lang ?
-
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 ∙ 1 day 21 hours back ∙ 4 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 ∙ 2 days back ∙ 17 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 ∙ 3 days 15 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 ∙ 4 days 21 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 ∙ 5 days back ∙ 13 proposals |
Ukraine