Sql command query parent table mysqlроботи

Доброго дня! Шукаю фрілансера, хто міг би допомогти час від часу писати коди SQL запитів для SAP B1.

...Супроводження процесу впровадження. Вимоги: • Досвід роботи – від 2-х років. • C++11, STL, GCC/CLang, GDB/LLDB, GNU Make, CMake, Bash. • Знання STL — контейнерів та алгоритмів. • Знання файлового вводу/виводу у стандарті POSIX. • Знання POSIX Threads —нитки, м’ютекси, умовні змінні. • Вміння користуватися системою контроля версій Git. • Вміння користуватися командним рядком Linux. • Реляциійні БД, SQL. • Основи функціонування комп’ютерних мереж, протоколи TCP и HTTP. Знання HTTP/1.1. Знанння архитектури REST. • Багатопоточність. Буде плюсом: • C++14, 17, 20. • Qt. • Boost. • Засоби статичного і и динамічного анализа коду (cppcheck, clang-tidy, clazy, valgrind, gprof, &helli...

Рейтинги підраховуються на основі готових формул. Рейтиги повинні постійно перераховуватись після завершення матчу в залежності від результату. Всі дані беруться з сайту через api. Ціна обговорюється після детального ознайомлення з завданням. Детальний опис завдання відправлю в повідомлення.

Front: Vuejs3 (routing, vuetify) Back-API: flask( SQLAlchemy, flask-restful, uwsgi), jwt, mysql Нужно реализовать SPA. Два типа пользователей (юзер, админ), доступ к SPA только после авторизации (пара логин/пароль). Для юзера: (страница №1) - реализовать поиск по базе данных, поиск по всех полях (отдельно по дате, фио, заказу), предусмотреть последующую фильтрацию результатов пользователем (фильтрация: пользователь вводит текстовую строку и если она может быть включением любой ячейки своей колонки результата поиска то отображается, остальные прячем), предусмотреть пагинацию. (страница №2) - как и страницы №1, но база другая, поля базы совпадают. Для админа: добавление новых юзеров админом, и доступ к функционалу описанному у юзера. База данных: ФИО (текстовое), ДатаРожд...

... Шукає Unity розробника для створення багатокористувацької браузерної 3D гри, Unity за допомогою WebGL. Обов'язкові навички: Вміння працювати в Unity і знання мови C#. Плюсом буде додаткові знання: JS, HTML 5. І back end розробника для написання серверної частини на ASP.NET Core. Обов'язкові навички: ASP.NET Core Entity framework core SQL С кидайте свої резьуме на: business@ або проджект менеджеру проекту: viktorstor@ KICKOOS GAMES - це молода outsourc GameDev компанія, що з недавна почала розробляти і внутрішні проекти. Друзі компанія зараз розширюється і влітку планує відкрити офіс в Україні, тому долучайтеся до нашої спільноти у телеграмі, де публікуются відкриті вакансії на різні позиції.

Для нашого онлайн ...найсучасніших веб-технологій для різних пристроїв (мобільних, планшетів) Профіль: • Хороші знання з програмного забезпечення (об'єктно-орієнтований дизайн, шаблони проектування, тестування) • самостійна робота та вирішення проблем • високий рівень мотивації • Досвід роботи з PHP, Symfony, Laravel або Zend, є перевагою • Вільне володіння німецькою чи англійською мовами • Дуже хороші знання PHP, MySQL та JavaScript • Добре знання HTML (5) та CSS (3)

Будь ласка, вкажіть 1-3 проекти, де Ви працювали із таксономіями (WordPress) та як Ви їх застосовували, де робили кастомну адмінку PHP+MySQL. Очікую на оцінку вартості та термінів, або уточнювальних запитань. Посилання на ТЗ:

Потрібно розгорнути на віртуальному сервері 1. веб сервер (apache/nginx/ +PHP) 2. СУБД (mysql/postgresql) 3. сам сайт

1) Є портали відкритих даних. наприклад 2) Потрібно розробити засоби завантаження відкритих наборів даних. вимоги: 1) Веб рішення (далі сервіс). на базі наприклад PostgreSQL / MySQL 2) конфігурація процесу завантаження конкретного набору даних: - даємо посилання на набір даних - Сервіс парсить структуру - на підставі парсинга конфігуруємо таблицю БД, куди будемо завантажувати дані - вказуємо періодичність завантаження даних - зберігаємо конфігурацію. 3) Сервіс повинен виконувати завантаження за розкладом. 4) Сервіс веде лог завантаження 5) Перегляд інформації повинен мати: графік та лог завантаження, таблицю з даними, конфігурацію процесу(тобто url, тип файлу)

Потрібно зробити легкі лабораторні роботи, терміново! Файли прикріпив, за потребою скину методичку.

Я маю довгострокову роботу, яка пов'язана з нашим попереднім проектом 'Change Framework CMS from Shopify to Prestashop - PHP, HTML, CMS, SQL'

Привіт chnazar, бачив твоє резюме на рахунок пошуку роботи якщо тебі цікавий довготривалий проект (PHP,JS,HTML,CSS,MySQL) можемо обговорити деталі

Hi, I am in need of a skilled professional who is proficient in developing a Customer Service CRM with a key focus on the functionality of issue tracking and resolution. As the priority of the project, I require the CRM to systematically record and t...optimization The deliverable is a Web-based CRM application that is easy to navigate and meets all the desired functionality aspects. It would be added advantage if you have previously built CRM systems following a similar brief. This job requires an understanding of how customer service CRM platforms function, and I am eager to work with someone who can bring proven knowledge and experience to the table. The platform should also have capabilities to be improved for future adjustments. I am looking forward to some great proposals. ...

...existing SPSS tables to match APA 7th edition requirements, including double-spacing, 12 point-font, Times New Roman font style, and, if needed, notes under the table or necessary italicization or bolding of headers/keywords. Manual entry of descriptive text and data values to form each independent table is needed. In other words, raw data cannot be provided to manipulate or recompute in SPSS or any other program! The SPSS tables currently display: Table 1. 4 columns and 13 rows Table 2. 11 columns and 7 rows Table 3. 11 columns and 6 rows Table 4. 6 columns and 2 rows Table 5. 7 columns and 4 rows Table 6. 11 columns and 4 rows Table 7. 7 columns and 7 rows Total: 57 columns and 43 rows, where not all intersects consist o...

I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in...

I'm in search of a MailWizz expert Key responsibilities: - Customizing the user interface design to improve the overall user experience and branding. - Devising a mechanism to manage debits of email credits efficiently. We simply want to add emailing credits to our customers mailbox account and we will ad...credits the account based upon the amount paid. We then simply like to debit the credits for each email sent. Very simple. If we give the mailbox user 10,000 credits and they emails 3,000 emails the 3,000 is debited from the 10,000 balance and 7,000 credits are left. We have already configured Mail Wizz with Postfix MTA We own our servers and we wish to integrate the emailing server with our MySQL database. This is the first of many jobs that we will require cus...

I am looking for a skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particularly...working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, MySQL...

I'm facing an issue with my Laravel admin panel, specifically a database table owner error that's occurring when uploading a zip file. - The error seems to be centered around the database table ownership. - The error happens during the process of uploading a zip file. - I can provide more details on the issue if required. I'm looking for a professional with experience in Laravel, database management, and debugging to help resolve this issue. The ideal candidate should be familiar with Laravel's database interactions and be able to navigate and troubleshoot these types of issues efficiently.

...message templates to facilitate the sending of common messages, such as order confirmations, appointment reminders, promotions, etc. Activity Logging: Implement an activity logging system that records all interactions performed through the application, including message sending, delivery status, etc. Technologies Used: PHP: Primary programming language for backend development of the application. MySQL: Database for storing user information, contacts, and activity logs. WhatsApp Business API: Official API provided by WhatsApp for sending messages from business applications. HTML/CSS/JavaScript: For frontend development of the administration and configuration web application. Deliverables: Complete source code of the PHP application. Detailed documentation on installation, config...

I'm in need of a skilled PHP/MySQL programmer to help me resolve issues with my legacy application. While the data in the current database isn't critical and can be easily recreated, the system is currently not allowing the addition or update of database records, although deletion is possible. Key requirements and responsibilities: - The main issue is resolving the problem of not being able to add or update database records. - There are no error messages displayed, so a deep understanding of PHP and MySQL is needed to identify and solve the root problem. - Once the issue is resolved, the next step would be to optimize the application to prevent similar issues in the future. Ideal skills: - Proficient in PHP and MySQL - Experience in working with and debugg...

I'm in need of a freelancer skilled in graphic design to make some necessary corrections to a billboard design. The changes needed are specifically centered around the text, requiring moderate rephrasing and an increase in font size for better visibility. Ideal Skills and Experience: - Strong command of graphic design software and tools - Experience in creating and modifying billboard designs - Attention to detail and ability to execute moderate text rephrasing - Proficiency in adjusting font sizes for better readability The turnaround time for this project is urgent, so please only apply if you're confident in your ability to deliver high-quality work quickly.

I'm in need of an architectural designer proficient in commercial design. Specifically, the project involves creating an engaging an...Conceptualization, layout design, space planning, and usability assessment. - Commercial Design Experience: You will need to showcase past projects, particularly those that focus on restaurant spaces. Experience in designing themed restaurants will be a significant advantage. - Creativity: The restaurant will feature a specific theme. I'm looking for someone who can bring innovative ideas to the table and transform the space into an immersive dining experience. - Knowledge: An understanding of restaurant operations, construction, and regulatory compliance is preferred to ensure a design that's not only aesthetically appealing but also ...

As the client, I require the services of a skilled copy typist who can accurately duplicate a PDF document. The original document contains tables, so a certain level of precision and attention to detail will be necessary. Your tasks: - Copy typing a PDF document - Transcribing tables as text - Ensuring 100% accuracy The ideal freelancer for this job has previous experience with copy typing and transcription, and is familiar with working with PDF documents and tables. A strong understanding of English and high attention to detail is imperative.

I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and file handling - Experience in configuring hostin...

...the issues and aligned to the developmental goals for the students. For example, you might include a statement such as “According to Dr. I. M. Expert, cyber-bullying is detrimental to a student’s development because it makes students feel unsafe.” Research and provide resources that are directly related to the issue and are aligned to the developmental goals for students. These are resources a parent or teacher could use to learn more about the issue and how to address the impact of the issue. These are resources that may be available in your community, such as food banks, language lessons for parents, etc. You may also choose to include resources that are available from federal, state, and local governments. These are not the resources you use to understand...

As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediately. I wil...

...ensuring proper data flow and interaction between the two. 6. Collaborate with the frontend developer to ensure smooth integration of custom designs. 7. Optimize the website for performance, security, and scalability. **Skills Required:** 1. Strong experience with Laravel 10.x framework, including MVC architecture, routing, middleware, and blade templating. 2. Proficiency in database management with MySQL or other relational databases. 3. Deep understanding of backend development principles and best practices. 4. Proven track record with API integration, particularly with payment gateways and shipping partners. 5. Familiarity with frontend technologies (HTML, CSS, JavaScript) to connect frontend to backend. 6. Familiarity with version control systems, such as Git, for collaborat...

...perspective correction of the images. It works in cases where the shape has 4 corners. If a shape has more than 4 corners, the script will not work. Please see attached and The script obviously fails on the "L" shapes. The has the expected result simulated. Attached is a zipped folder with everything you need to start. To run a script, use this command {filename} Example The "source" folder has various source images that have working and non-working cases. I need a solution that will work in most "non-working" cases. This script also has a function that saves points coordinates to JSON (before, after, and applied translations) It needs to be working and save only 4 points. Once a first working

...objectives are: Optimal candidates should possess: - Strong writing and editing skills - A knack for structuring information effectively - The ability to create engaging and clear content however, no Chatgpt , no google Bard/Gemini, or any other AI tool. Cybersecurity CIA Analysis (2019-Present) Need in-depth analysis of CIA triad in recent research? 5 IEEE papers (2019-present) Comparative table with key insights ⚡ Fast, expert research & delivery Order now & unlock cybersecurity knowledge! Tags: cybersecurity, research, CIA, IEEE, analysis, comparison - Identifying potential vulnerabilities in multiple IoT in smart city systems - Analyzing existing cybersecurity measures - Proposing enhanced security solutions The ideal candidate will understand Security Ch...

...documentation. We need a checkout option for Zelle and for Cashapp. These will be seamless just like checking out with credit card. The customer will select one of the two options and then they will be prompted to login to their account to complete the payment then upon successful payment they will be reverted to the payment success screen. Additionally you will add a field into the product category table and to the product add/edit pages in the admin panel for payment options allowed. Certain product categories can be paid with credit card whereas the others cannot. So something like cc_allowed and the answer would be y or n. Upon the options in the checkout if cc not allowed then this option won’t be available to the customer. You will do the above mentioned functional...

I'm looking for a talented artist to create a series of crypto-themed meme art pieces. Key Requirements: - Style: Cartoonish - Usage: For social media content Ideal Expertise: - Strong command of cartoon art style - Creative flair for creating engaging meme content The art will be associated with crypto culture, so familiarity with the latest trends, memes and/or iconic figures within the crypto space is a huge plus. The final pieces must be eye-catching and suitable for sharing on various social media platforms. If you have a knack for humor and can blend it with crypto themes, this project is perfect for you.

As a business user, I need assistance with the configuration of SS...WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the above over the call since this is a secured environment. Also, this needs to be executed...

... we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to collaborate with a dedicate...

...three different algorithms for matching a resume with jobs on the website. They are coded in python. You have to create the APIs for webapplication. Then you create the Website which has 2 user types. Job Seeker and Employer. Login to use (home page) Job seeker will upload their resume details using a fixed form. Employer can post as many jobs using an upload job form. The data is stored in a table. On clicking the Find Jobs button (after uploading resume) or Find Profiles (for each job posting uploaded) the results page will show the ranked results (either job or resume depending on user). Home Page - Login SignUp buttons only...no design or banner or random stuff. Profile Page - Form Filling page with resume details. Resume Form Page Job Description Page Simple Dashboard...

...I supplied. Environment is: volleyball2stg From the ticket: I have tried again to update the staging site with the latest copy of the production and update the plugins and theme as well as the PHP version and here is the result. Updating the Pro theme have broken the existing layout of the pages and will need an overhaul of the child theme to match the new parent theme version when it comes to the structure. Updating the PHP version to 8.2 have generated and error on the WooCommerce collapsing categories pro plugin. I am not sure if this plugin is still maintained for the only review that it had was way back 2016. The last post on their twitter account is way back in 2021. This plugin needs to be updated to match the requirements of PHP 8.2 before we can

I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including the Production number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results...

I'm currently in need of a skilled professional versed in CSS3, HTML5, PHP, and MYSQL. My primary requirement consists of creating minimalist and clean CSS styles for specific pages, namely the products page, product view, and checkout page. In addition to this, there will be some light PHP work involved. The ideal candidate should have demonstrable experience in these areas and a good eye for clean and minimalist design. Efficiency and attention to detail are key.

I'm seeking someone to thoroughly edit my CV focused on the medical industry. Key tasks will involve: - Reformatting for a cleaner, professional layout - Intensive spell-check and grammar corrections - Enhancing content and wording to sell my qualifications and skills effectively. It's essential for the freelancer to have a strong command of English, excellent proofreading skills, and profound knowledge of medical industry-specific language. Your task is to ensure that my CV speaks fluently about my capabilities and stands out amongst competitors. The final CV should be delivered as a Word document. Scaling experience with CV writing, especially in the medical field will be seen as a big plus. Keep it professional, concise, and persuasive.

I'm in need of a developer who can compile a Windows Exe file for the Real-ESRGAN GitHub project. The Exe file should operate on CPU, and accept command-line. Currently, the GitHub project offers only a GPU exe file, hence the need for a CPU version. GitHub link for Real-ESRGAN:

...for the Snipepay Payment Plugin: WooCommerce Integration: Develop a payment plugin to integrate Snipepay into WooCommerce, allowing users to choose Snipepay along with existing options like PayPal and GoUrl for payments. Deliverables: A fully functional WordPress plugin for hosting management. A Snipepay payment gateway plugin for WooCommerce. Skills Required: Proficient in PHP, JavaScript, and SQL. Experience with WordPress and WooCommerce plugin development. Strong understanding of RESTful API integration. Knowledge in payment gateway integration, specifically Snipepay, PayPal, and GoUrl. Excellent problem-solving skills and attention to detail. Project Timeline: Please provide an estimated timeline for completion with your bid. Budget: Your bid should include the total cos...

Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )

I'm in need of a talented copywriter to handle a variety of projects. - The ideal candidate for this role is someone who has a strong command of the English language and the ability to create engaging, compelling copy that will resonate with my target audience. - I'm looking for someone who has experience writing for a variety of mediums, including web content, social media, and marketing materials. - You should be able to adapt your writing style to suit different platforms and audiences, and have a good understanding of SEO principles. - It would be a bonus if you have experience writing for business professionals or young adults. If you're a creative, detail-oriented copywriter with a passion for engaging your readers, I'd love to hear from you.

...effectively showcase their professional experience, skills, and achievements. The ideal candidate will have a keen eye for detail, excellent writing skills, and a strong understanding of various industries and job markets. Requirements: -Proven experience as a resume writer or similar role, with a portfolio of successfully crafted resumes. -Excellent written communication skills and a strong command of grammar, punctuation, and syntax. -Proficiency in Microsoft Word or other word processing software for resume creation and formatting. -Knowledge of ATS principles and strategies for optimizing resumes for keyword relevance. -Ability to conduct thorough consultations and effectively communicate with clients to understand their needs and preferences. -Attention to detail and a com...

I need an expert API developer to create a functional, reliable API for automating table reservations and event bookings on my website, integrating with Tabology. The task involves: - Understanding the existing booking system on the site - Defining specific automation processes for table reservations and event bookings - Integrating these processes with Tabology to enhance efficiency and usability A successful freelancer for this project should demonstrate significant experience with API development and have a deep understanding of booking system operations. Familiarity with Tabology integration will definitely be an added advantage.

...Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...

We have an existing PHP/QuickBooks Online application designed to sync QuickBooks invoices to a MySQL database. The application works correctly when executed but we have an issue where the security token needs to be refreshed manually every 24 hours. We need to devise a way for this application to run with no requirement for refreshing the token manually. The program syncs orders in real-time so manual token refresh is not an acceptable way to do this. A developer is required with experience working with QBO applications and working with the QBO token refresh system so this refresh is done automatically.

...Import data from xml sheets into multiple prestashop faced search feature table. Here's an outline of the tasks Script to Parse XML for Nightly Update: This script will run once a night to parse a large XML file provided by the content provider. It will update, add, or remove relevant data in the PrestaShop facet search database tables. The script should be optimized to avoid system slowdowns and long processing times. Script to Parse Product XML Files: The second script. This script will run continuously and parse XML product files located in a specified folder and its subfolders. Mapping of data: Correct mapping between products and relevant categories will be established using XML data and existing PrestaShop MySQL tables. As we have large amount of produ...

...Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...

I am looking for a professional logo designer who has a keen eye for creating engaging and dynamic logos. You need to be a creative thinker who can bring fresh new ideas to the table as I do not have a specific concept in mind. Key Responsibilities: - Creating an innovative and captivating logo design - Being open to feedback and willing to make adjustments as needed Ideal Skills: - Extensive experience in logo design - Creative thinking and open-mindedness - Strong communication skills to understand design requirements and feedback I can't wait to see what unique ideas you bring!

I require a professional Turkish translator who can help me with the translation of a business document. Key Requirements and Skills: - Native Turkish speaker or fluent in Turkish - Proven experience in translating business documents - Excellent command of the English language - Understanding of formal tone and language in the business context - Familiarity with common terminologies used in business documents The project will involve translating a document from English to Turkish while maintaining a formal tone suitable for business communication. The translator should ensure that the translated document is not only linguistically accurate but also culturally appropriate for a Turkish business audience. A background in business translation would be a definite plus. Please inclu...