Many to many relationship sql query仕事
I have some translation projects and am looking for translators who can establish a long-term relationship. It's best for those who are beginners and want some experiences for your resume. Since the task is basically easy and long term, the rate will be $0.012 - 0.015 per word. Please leave your bid with your specialized field if you have. I'll contact all but agents. Thank you! 翻訳プロジェクトがいくつかあり、長期間協力していただける方を探しています。 翻訳業を始めたばかりの方や、履歴書に書ける経験をされたい方にぴったりの業務です。 内容は基本的に簡単で、長期ということもあり1単語$0.012 - 0.015で考えております。 コメントいただければこちらからお問い合わせさせていただきます。 専門分野や専門にしたい分野があればコメントに書いてください。 よろしくお願いします。
Describe your job here: ■利用目的と概要： タイのチョンブリ県で平日お役所に書類を提出 In Chongburi Prefecture Submit documents to Goverment ■指定項目・制限等： タイ人またはタイ語が理解できる Thai people or Thai language available people ■自由記載： Goverment document submit, or receive goverment document 政府系の書類、役所への提出受け取りをしていただきます 弊社バンコクにあり、チョンブリへの訪問が毎回面倒なため、 受け取った書類をそのまま役所へ提出していただくお仕事です。 because our office is BKK , so it is difficult to visit so many time. Working is only bring document to goverment office in Chonburi. ■注意・禁止事項： 作業対象内容を第三者へ漏洩する行為 既に提案した内容をそのまま転用する行為 Caution Prohibited act Action to leak work contents to third parties Act of diverting contents already proposed
We a looking for someone to develop an bitcoin payment gateway like gocoin ( ). The features are simple, including Forms, Notifications, admin, and payment etc. UIUX skilled is a plus. Opportunity for long term relationship and additional work.
...PHP, SSIS, SSRS programer. We are continue to develop CS system, MS SQL +SSIS ,SSRS of server side and PHP front with IIS. All MS solution based. We have Server side engineer in house. and test server with dummy data, you can try from remote. development can do english based with skype, github,mail and so on. We hope to good offshore appications. Thanks now we are searching below project enginner. 1 upgrade SQL server SSIS import program 2005 to 2012 SSIS side is improt form exel to dbo and job lancher is C# based exe. Req Skill C# 2000, SSIS, SQL prototype, ex- version will remained Documets also you need to upgarede customizing and version up job. Becase some field connection was changed. 2 upgarde SS...
... We are searching freelancer of PHP, SSIS, SSRS programer. We are continue to develop CS system, MS SQL +SSIS ,SSRS of server side and PHP front with IIS. All MS solution based. We have Server side engineer in house. we have test server with dummy data, you can try from remote. development can do english based with skype, github,mail and so on. We hope to good offshore appications. Thanks now we are searching below project enginner. 1 upgrade SQL server SSIS import program2005 to 2012 SSIS side is improt form CSV to DB, job lancher is C# based. Req Skill C# 2000, SSIS, SQL 2 upgarde SSRS program 2005 to 2012 small customizing upgarde checking. over 100 report should upgarde 3 php with sql add new s...
依頼の目的 修士論文のネイティブチェックをお願い致します。 分野：タジキスタンの教育と市場参加・賃金の関係について（教育と経済学分野について多少の専門用語あり） 分量：約10,000 words 重視する点：学術論文のため、文法について厳格にチェックをしていただきたいです。またフォーマルで固い表現や、アカデミックライティングに明るい方を探しています。少々急ぎのため、厚かましいお願いですが出来れば3日程度で納品してくれる方を探しております。 目安予算：1万５千円〜１万８千円程度 以上宜しくお願い致します。 Purpose: Proofreading of master's thesis. (English) Theme of master's thesis: The relationship between education and labor market in Tajikistan Number of words: 10,000 words Budget: ¥15,000-18,000 JPY Expected delivery date: 1/29, Fri. (JST)
...サービス要件 1. 特定のゲームタイトルに関連する記事を取得すること 2. プログラムの特定の一か所に記述されたゲームタイトルパラメーターを変更するだけで対応したデータが取得できること 3. 海外ゲームタイトルであっても取得可能であること 4. 1日に1回バッチを回した際、以前に取得したことがない記事をリストとして取得できること 5. 記事のタイトル・サムネイル・記事本文の一部を取得すること ■ システム要件 1. PHP + MySQLで構築すること 2. PHP5.3で推奨されていない表現を用いないこと 3. Cronによって動作すること 4. プログラムを動かすサーバー OR dbサーバーに対して必要以上の負荷をかけないこと ■ 納品物については以下の通りとなります 1. プログラム本体の納品（PHP） 2. データの格納先DB-Tableの納品（SQLクエリ） ■ 応募条件 1. 応募時にどのような方法で実現する予定なのかを簡潔に明記してください （Ex. TwitterSerch API と Bing Serch APIを用いて実現します、など） ▽参考Webサイト サイト名：スマートニュース/newspicksなどのバックエンド ▽使用するプログラミング言語/ツール/特殊技術（テクノロジー） ・PHP(5.3） ・MySQL ▽注意点・禁止事項 ※ 他で登録されているデザインや商標の転用など、他社の知的財産権を侵すこと ※ 商用利用できないライセンスのプログラムを用いること ※ ▽その他コメント ※実際のWebサイト開発/アプリケーション開発の進め方・別途詳細は、 クラウドワークスのメッセージでやりとりして決められればと思...
Fix a magento error SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction MagentoのSQLをバックアップ後に管理画面にログインしようとすると以下のエラーが表示されてログインできない。 SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction 希望： 問題の解決と原因の究明と説明、今後への対処の説明と実行をお願いします。 緊急です。 重要視する項目：金額、スピード、作業内容及び方法の説明 予想される作業内容：（あくまでも予想です） 未実行クエリの再実行または未実行クエリの削除 innodb_lock_wait_timeoutの値変更 50秒->180秒
...=========================================== We are a translation company specialized on technical and patent translations from many languages to English, including Japanese. We already have some clients in Japan, but we want to expand our business there, so we are searching for candidates that can come to be interviewed to our branch office in Japan (Tokyo). We need a salesperson / account manager in Japan; the candidate will be required to: - Actively make sales calls to Japanese companies to sell translation services, and so develop new customers (no need for doing translations). - Contact and visit customers - keep a permanent, live relationship with the customers. - Manage the existing customer accounts and...
...an SEO professional that can help us build the authority of our travel website in Japan. Someone that can help us build diverse and high quality links from relevant Japanese websites pointing to different pages of our site. Skills required: Native Japanese speaker, good English, Content writing, Link building, Keyword research, In depth knowledge of the Japanese Internet landscape. Conditions and Approximate budget: $3000 - $5000 AUD on a monthly basis (negotiable depending on experience and proposal). Although we would start with a 6 months trial period. We are looking for a long term relationship....
I need a simple flutter demo with 1 screen. Where app: - Display device token on app screen with copy button - Have possibility to receive push and display on Xcode debug that push receive - who also react on background and silent push (if app on background or close) and if app open it should show how many silient or background push he was get while app was close or in background. - Who display once come back to app how many background push and how many silent push was get until last open app I NOT want firebase solution. I want AppleApn use direct.
I'm looking for a LookML professional who can assist me with creating models and explores within Looker. Key Responsibilities: - Develop and implement LookML models specifically focused on Dimensions and Measures. - Help me in joining multiple tables within derived tables. Ideal Skills: - Proficient in LookML and Looker. - Extensive experience working with SQL databases, BigQuery, or Redshift. Please provide examples of your previous work with LookML models.
...JavaScript developer to assemble a Chrome extension in JavaScript that I have already built. I developed a set of features for a Chrome extension, but they are in separate files. Also, I would like to add one or two features that have not been developed yet. After making it into a single application, make it robust for testing. I have a Chrome extension that can take notes on any webpage, but I want to incorporate features I have already developed. I need the application to be robust. Key Features: - The primary function of this extension is to save notes, annotations, and bookmarks (already built only a front end). - Any notes, annotations, and bookmarks are displayed on the right-hand side, and any context information is displayed in the left-hand ...
I'...primarily involve working with SQL databases and leveraging the Django framework. Key Responsibilities: - API Development: Building, testing, and maintaining APIs to support various applications and services. - Database Management: Overseeing the interaction with our SQL databases, ensuring data integrity and optimizing performance. Ideal Skills: - Proficiency in Python, particularly in a backend context. - Familiarity with SQL databases, including basic query writing and database design. - Prior experience or knowledge of the Django framework. - Understanding of API structures and principles. This is a great opportunity for a fresher looking to kickstart their career in backend development. If you have a passion for coding and a keen ...
...developer for a 2-months project. The developer is required to work on upgrades to our existing reporting panel at our Nikaton, Dhaka, Bangladesh office. Freelancer have to work in our physical office . It's not a remote job. MS-SQL database expertise is required. The office hours are from 9 A.M. to 6 P.M., and lunch is complimentary. The project involves: - Implementing new features. - Bug fixing. - Performance optimization. The new features to be added include: - Customizable reports. The level of customization for the reports includes: - User-defined filters - Customizable layouts - Export options (PDF, Excel) Ideal candidates should have: - Extensive experience in raw PHP - Proven track record in developing reporting panels - Abilit...
Hello FL. I am looking to connect with a photoshop designer who can make minor edits to a photo from a recent shoot. Please can you: 1. Remove the greenscreen from the original. 2. Remove all green shadows throughout the image around the face from the original. 3. Provide the file with the edits required ready for use in a YouTube thumbnail, using the same styling as the example.png. You will provide the new version of the image and .PSD file at handover. I have many more images that need this work so looking to connect with someone to work with frequently. Thanks Toby
I'm looking for a skilled SQL developer to create a query for data retrieval from my MySQL database. Ideal candidates for this project should: - Have extensive experience working with MySQL databases - Possess a strong understanding of SQL syntax and functions - Be capable of writing efficient and effective data retrieval queries.
...comprehensive strategy to enhance the user experience (UX), streamline navigation, and improve the flow of information across three interconnected websites: Primary Objectives: Simplify and Enhance Navigation: 1. Improve the organization of categories and services to ensure intuitive, user-friendly navigation across the websites. 2. Optimize the flow of information between the sites to reduce confusion and improve conversions. Modernize Website Infrastructure: 3. Address outdated designs and technical issues (e.g., plugins on InovoAesthetics). 4. Develop a scalable, mobile-first design strategy to ensure fast, responsive, and seamless user experiences. Streamline Services and Branding: 5. Clarify the focus of each website to reduce redundancy
My company has been operating since 2006. I am looking to grow my business and need someone reliable to take on a lot of my small tasks to free up a lot of my time. I'm willing to give bonuses and raises to someone who will prove to be a true professional. I'm in need of a personal assistant who can help me manage email and communication, sales, customer service, and verification calls and emails. The most critical aspect of this role will be handling customer service, primarily through phone support. You will be communicating with both parents and students who are taking high school courses and some attending full time. There are many details, so I need someone who is sharp, a quick learner, pays attention to detail, is a...
I’m looking for a freelancer to help move data from an MS SQL database to Google BigQuery and automate this process using Python scripts. The goal is to centralize the data for better analysis and set up a structure in BigQuery that is organized and scalable for future use. I will provide access to BigQuery so the freelancer can set up datasets and organize the data directly within the platform. Scope of Work: Data Extraction and Transformation: - Extract data from SQL tables (e.g., inventory, item details, sales history) based on specific fields and filters - Ensure data is cleaned and formatted for smooth loading into BigQuery. BigQuery Setup and Organization: - Access BigQuery to set up and structure datasets (e.g., inventory_da...
Tenemos un sistema que tiene archivos .ADE y . ADP, bk de sql server. Como este sistema esta obsoleto, necesitamos migrarlo o adaptarlo a algo mas moderno. Preferiblemente web based o si es mas economico desktop base.
Job Summary: We are seeking talented Full Stack .NET Developers to join our team. This is a flexible opportunity, with both full-time and part-time positions available, designed to cater to professionals with varied availability. As a developer, you will contribute to building and maintaining robust, scalable, and high-performing web and desktop applications using the latest .NET technologies. Responsibilities: Back-End Development: Develop and maintain server-side components using C# and ASP.NET Core. Design APIs (RESTful or gRPC) for seamless front-end integration. Work with Entity Framework and databases such as SQL Server or SQLite for efficient data management. Ensure secure and scalable solutions through best practices in cryptography and system a...
I'm looking for a service to add members from one Telegram group to another (scraping usernames from public groups and adding them to my group). 1) What is the price for 1k members? 2) What is the timeline to finish? - NO smm panel/bots... (I will provide you public groups to take members from and add to my group) - This will be an ongoing project, as I plan to place many additional orders later. - Only professionals with prior experience in this type of work !
I'm seeking an individual or team who can refer and sell online technical courses to working professionals. The ideal candidate should have a deep network in the tech industry and connections with professionals eager to upskill. Key Responsibilities: - Identify and suggest relevant technical courses - Engage and close deals with potential clients - Manage and sustain client relationships Skills and Experience Required: - Extensive network in the tech industry - Experience in sales and business development - Excellent communication and relationship management skills - Knowledge of online technical courses
as discussed in the chat section
...skilled freelancer to develop a Facebook engagement tracking and leaderboard system for my posts. The system should: 1. Track likes, shares, and comments on my Facebook posts 2. Create daily, weekly, and yearly leaderboards of top engaging users 3. Store data in a database for easy access and analysis ### Key Features: - **Data Collection**: Gather engagement data from my Facebook posts (likes, shares, comments) - **User Tracking**: Identify and track individual users who interact with my posts - **Leaderboard Generation**: Create separate leaderboards for likes, shares, and comments - **Time-based Rankings**: Generate daily, weekly, and yearly highscores - **Data Storage**: Use a database to store and manage collected data - **User Interface**: Develop a simple interfa...
1. Project Overview: SkyGuide is a web app designed to assist flight attendants and pilots by providing easy access to their union contracts. Users input questions and receive AI-generated responses based on their specific contract details. The app is near completion and will be prepared for alpha testing and promotion by March 1st, 2025. 2. Objectives: Fix existing errors and issues in the app. Implement the ability for the app to correctly call the appropriate OpenAI assistant based on the user's airline and workgroup. Ensure seamless user signup, subscription handling, and integration between Stripe and Supabase. Finalize all features and functionality to prepare for alpha testing. 3. Target Audience: Flight attendants and pilots from various air...
...issue with a website built using the framework on PHP 7.0. The website was recently migrated from cPanel to DirectAdmin, and since then, we've encountered an error message indicating a variable named $where is not found. Error Details: Error Message: PHP Notice – yiibaseErrorException: Undefined variable: where Code Snippet:: PHP $connection = Yii::$app->getDb(); $command = $connection->createCommand("SELECT id FROM product $where"); $result = $command->queryAll(); Potential Causes: Missing Variable Definition: The $where variable might not be properly defined or assigned a value before it's used in the SQL query. Configuration Issue: The migration from cPanel to DirectAdmin might have caused configuration chan...
...are seeking a highly-skilled developer (or development team) to create an intelligent, machine vision-driven application for a tablet device. The core function of this application is to use the tablet’s built-in camera as a real-time sensor to count the number of unique individuals passing through its field of view. A critical requirement is the application’s ability to correctly identify and track individuals to prevent redundant counts—ensuring that each person is counted only once, even if they linger in front of the camera or exit and re-enter the scene. Key Objectives: Accurate Counting of Unique Individuals: The application should reliably differentiate one individual from another and maintain a running count of how ma...
Hi Waseem, I have another PPT project that I would love your help with. This is for internal employees on how to set their annual goals. I have 4 slides that I would like help with formatting/layout. I have added comments on each slide on what I'm hoping to get help with. I am not sure how many hours it would take you so would like to get your thoughts to determine if we do a fixed price or hourly rate. Could you let me know when you would have time to turn around 4 slides? Thank you!
We are a new nonprofit organization in the U.S. that will bring together current and former National Football League (NFL) cheerleaders to give back to their local communities through volunteerism and fundraising. We will also support many other charities, such as kids, seniors, Veterans, the homeless, animal rescue, and the environment. We have two preliminary logos, created by ChatGPT. We like certain aspects of each and would like someone to create a blend of the two as follows: 1) Use file #1 as your starting point 2) Replace the center cheerleader with the cheerleader in file #2. We love the heart on her shirt. 3) Remove the 2 extra pom poms behind the side cheerleaders heads (they are already holding 2 pom poms in their hands; that's enough) 4) In...
We we forced to udpate our server form centos7 to alvaviva that has a more recent version of mysql, now one main pure php file we have are throwing some errors. We need someone to update it. No logic changes needed just syntax and maybe some database access query.
My Elasticsearch setup is currently experiencing critical health issues, particularly with the cluster. I am in need of a seasoned network administrator who can diagnose and rectify these issues, as well as optimize the overall performance of Elasticsearch. Key Requirements: - Expertise ...critical health issues, particularly with the cluster. I am in need of a seasoned network administrator who can diagnose and rectify these issues, as well as optimize the overall performance of Elasticsearch. Key Requirements: - Expertise in Elasticsearch version 7.x - Proven track record in network administration - Ability to enhance search query speeds - Skills in solving cluster health and indexing problems Your timely intervention can help restore my Elasticsearch to optimal...
I'm seeking a seasoned SQL Server expert to configure transactional replication on my SQL Server for a production environment. Key Requirements: - Configure Publisher and configure Subscriber in SQL server. - In-depth knowledge and hands-on experience with SQL Server - Proven expertise in setting up and configuring transactional replication. - Familiarity with production environment protocols and best practices. - Strong problem-solving skills and attention to detail.
I want to design a landing page with 7 to 8 sections, along with two additional pages: a Pricing page and a Contact page. I already have the Figma file, and I need the pages to be functional and responsive for both desktop and mobile. I have a budget constraint of 3000 INR. Please provide the following details to help me proceed: 1. Which technology will you use for the design? 2. How many days will it take to complete? 3. What do you need from me to get started?
...system and mobile APP. -Developer needs to have the ability to quickly create complex solutions, deploy them on AWS, and contribute to the team whenever requested. -AI systems integration. -You need to know how to apply SOLID principles. -Understanding of how creating entity-relationship diagram. You can use some tool recommended for that. I need your nodejs developer do this test in three business days so that I can know his abilities: Rules for the test: Implement the backend of the screens contained in the design in the link below using these technologies and others that can add value to the project: Node.js and PostgreSQL. In addition, the project needs to be added to a private repository on Bitbucket. Commits on Bitb...
I need to convert 80-90 slides into a professional morph version. The project will involve many repeated pages. The style of the transformed slides should be creative and modern. Key requirements: - Ability to understand and implement modern and creative design elements - Proficiency in PowerPoint morph transitions - Keen attention to detail, especially with repeated slides I don't have a specific design theme or color scheme in mind, I'm open to suggestions. Please provide links to your preferred designs or similar styles.
I'm seeking a seasoned SQL Server expert to configure transactional replication on my SQL Server for a production environment. Key Requirements: - Configure Publisher and configure Subscriber in SQL server. - In-depth knowledge and hands-on experience with SQL Server - Proven expertise in setting up and configuring transactional replication. - Familiarity with production environment protocols and best practices. - Strong problem-solving skills and attention to detail.
I need a query function that handles total event duration data. The function should be able to process numerical data representing event durations. The example sheet contains the data and i want a sum(v) in the query function in the cell A8 error message : Impossible d'analyser la chaîne de requête pour Le paramètre 2 de la fonction QUERY : AVG_SUM_ONLY_NUMERIC
...academic teaching law to students in the UK, preparing them for the bar exam. I aim to transform my teaching materials into an engaging online course, which will be hosted on platforms like YouTube. This project involves creating e-learning content that will continue throughout the course. This is the first episode of a course titled ‘Business Law and Practice’, which will cover various concepts of how businesses operate under English law. The course will consist of approximately 22 chapters, with each chapter containing multiple episodes. Scope of Work: • The first episode is around 10 minutes long. Please provide a quote based on a 10-minute video, with margin for the final version to be slightly shorter or longer. • The first video w...
...researcher and writer to help me craft an analytical research paper focusing on the contemporary social theory as it pertains to Robert Merton. Key Responsibilities: Write a four-page minimum paper explaining how Merton’s work expanded our understanding of Anomie. Explain the relationship between the success motive and the structural limits to success. Explain the various types of deviance implied in Merton’s theory of Anomie: Ritualism, Innovation, Retreatist, and Rebellion. How does Merton’s approach to anomie differ from Durkheim’s? - Write a clear, structured and engaging analytical research paper. Ideal Skills: - Strong background in contemporary social theory and Merton's work. - Excellent research and analytica...
We need a developer to build a web-based 3D PDF conversion platform that converts .dwg, .dxf, and .obj files into interactive 3D PDFs viewable in Adobe Acrobat Pro. The Frontend will integrate with WordPress, using a membership plugin (e.g., MemberPress) to manage access levels. Users must be able to upload files, select from customizable templates, and download branded 3D PDFs supporting zoom, rotate, and pan. Security is paramount, with files processed via HTTPS and deleted afterward. We want a white-labeled solution, removing any third-party branding. Experience with Python, CAD parsing, and PDF generation is essential. Finished Project will look like: Stage 1: Front-End (Price Options) Purpose: Visitors arrive on the website and see subscription tiers or one-tim...
...Description: Freelance Digital Marketer for Luxury Retreat Ads We are seeking an experienced and creative digital marketing freelancer to design, manage, and optimize ads to attract high-net-worth women for an exclusive luxury retreat in Sedona, AZ. Responsibilities: • Develop ad copy and creatives tailored to the target audience. • Set up ad campaigns across multiple platforms (Facebook, Instagram, etc.). • Implement and optimize ad sets, targeting, and pixels to ensure maximum reach and engagement. • Manage and monitor the ad performance for a 14-day campaign, with the potential for long-term collaboration. • Provide detailed campaign reports and insights to measure success. Requirements: • Proven experience run...
I'm seeking a comprehensive feasibility study on the legal frameworks applicable to payment Customer Relationship Management (CRM) systems in both the EU and the US. This research should focus particularly on data privacy and consumer protection laws in both regions, as well as financial compliance laws in the US and financial compliance regulations in the EU. Key areas of exploration: - The legal requirements for payment CRM systems in the US and the EU. - An assessment of data privacy and consumer protection laws in both regions. - An evaluation of financial compliance laws in the US and the EU. Ideal skills and experience: - Extensive knowledge and understanding of both US and EU legal frameworks. - Previous experience conducting feasibility studies. - A strong back...
...bags with a very very strong intent to add products to our catalogue in near future. Ideally we would like you to sell to distributors who can order at least 1 twenty or forty feet container of 20 tons, but we dont mind dealing with other parties either or in smaller quantities initially. This is an opportunity for those who would like flexible working hours. We offer a generous compensation of at least $1,000 per container on a repeated basis, i.e. to say that irrespective of how many times in a year the same client places order, you will be entitled to receive your compensation of at least $1,000 per container. Moreover, please note that to make your life easy we like to sell our products at a fraction of its market ...
I'm looking for a professional with strong skills in Filemaker and .Net Core. The primary focus of this project is data management, specifically integrating with an SQL Database. Key Responsibilities: - Integrate Filemaker with an SQL Database - Carry out data retrieval tasks Ideal candidates should have: - Proficiency in Filemaker and .Net Core - Experience in SQL Database integration - Strong data management skills
...send by chat) *******Amazing how most people don't read or follow instructions******* *Read attached PDF with requirements *Will not do Milestones (Get paid once project is completed) *Only Real bids No placeholders. *Send APK by chat of sleep app you made *Send chat direct instead of bid as you have a better chance of us seeing it I'm seeking a seasoned professional Flutter developer to create a comprehensive Sleep Tracker / Sleep Sounds App. This app should track sleep and include an extensive library of sleep sounds, meditations, stories, music, and videos. All content should be manageable from a detailed, user-friendly admin panel. Flutter Sleep Tracker / Sleep Sounds App If you can't take criticism or be called out don't respond. Had a ...
I need an experienced Shopify specialist to help me fill up my store with pet products and pet transportation items. My goal is to launch as soon as possible. Key Responsibilities: - Assist in product sourcing and store setup - Improve and complete product descriptions - Ensure everything is ready for a successful launch. And I want to get my site ranking High Seo on Google and others I have some product descriptions ready, but will need assistance with others. If you do a good job, I'm open to a longer-term working relationship. Ideal Skills: - Proficiency in Shopify - Experience with e-commerce, specifically pet products is a plus - SEO knowledge for high ranking I'm committed to taking care of whoever I hire, and with your help,...
