I need help with an SQL request. In practice it is only to count the number of references of a person if the referenced persons referenced 500 people or more. In pseudo code what I want to do: SELECT * FROM users WHERE referrer_id ='$referral_code' AS user if((SELECT COUNT(*) FROM referrals where id=user) >= 500)
I am a mechanical design engineer and searching for a master degree scholarship and I need a creative writer to write a professional motivation letter for the Swedish Institute for scholarships.
...com/uk/application-form, to be able to login, and to add an API key. The data to fill the formulary to create the account will come from data gathered in different places in the web/or database which needs to be determined. Once the creation of the account is validated, the program must login and create an API key. The login might be tricky. It must be coded
trying to create a team logo for a team within WeWork called Real Estate Advisory. The team was established in 2018 and the values are Velocity, Variety, Win Rate, and Quality. The WeWork logo is fair game, as well as any fonts containing REA or Real Estate Advisory. I have included two ideas here that were shot down, so please don't worry about sticking too close to these as guidelines. ...
I would like to make three letters I have to write as part of my immigration process towards 489 visa to Northern territories. 1- Evidence of detailed research into living and working in the NT. 2-A statement documenting the main applicant’s commitment to the NT. 3-Copies of documents evidencing the main applicant’s employability in the NT
I'm having an issue with the fasthttp library with golang. The request is returning access denied however, if I call the request via an API tester or simply somewhere else then it works fine. I will screenshare via [login to view URL] and allow control if need be.
Request for a Masternode / PoS Coin. Similar to PIVX, LRMCoin or LightPayCoin. Only who did similar kind project please bid.
This is a developed project with all parameters clearly laid out. Most graphics have been completed but may require some design work. The website is a medical records request website with multiple logins for various roles. Experience required in APIs, AWS, credit card functionality (via API). 8 week time frame.
Hello. I am looking for some help creating a really attractive logo for my start up business. This logo will be used for my website, promotional products, business cards, email, advertisements, t shirts, cups etc. I want the image to be of my own silhouette brand name and slogan. I tried starting this process myself, but can't seem to bring my visiono to life. I've attached my original...
Hi I have an app and I want to approch potential clients and ask them to advertise in my magazine . The letter should be very creative and not boring . also should mention the features and advantages over papaer edition magazine which i iwll tell you . and also offer an advertising package to them which again will be discusses.
Organization name (English): United Arab of Calgary Organization name (Arabic) الاتحاد العربي بكالجاري Nature of the business: Social service org. Location: Calgary, Alberta, Canada we are looking for a cross-cultured design (Arabic, Canadian/Albertian)
I need 4100 words translated from English to Portuguese within 2 business day. The translation should be manual. Any type of automatic translation will not be accepted. If the work is well done you can expect more work in future.
I need an experienced and reliable programmer who can develop a robot to take and close trades based on trend line and channel lines. Channel line and trend line indicators codes are already available for ready reference The codes are in ProRealTime programme.
...good results in an "applicant tracking systems (ATS)" please find, use and send results from the ATS of my resume before and after the work and last, please include a cover letter, more information can be retrieved from me if you need it....
Looking to develop a professional CV, cover letter and LinkedIn profile for a senior engineering manager. I will share my old CV and my details once agree on the cost and timeline.
...contestant from the game. 6. Each gamer will end up with a thank you message and QR code and discount based on his performance time in the game. 7. The application will be a web page and the design will be from our side. 8. The game starts with a short sound track about the game. 9. The game ends with a short sound track about where do they get to
I need to write an appeal to reactivate my selling account so my selling privileges can be reinstated
I would like this toolkit to be updated to work for the latest version. I can provide an account for testing. [login to view URL] I would then like a tool to be made that will enable me to purchase players. More details can be given.
...installation program to make it work on Windows 10 , 64-bit system, And I need to update and correct the Project Files program file to make it work perfectly and Compatible with visual studio 2017 I have all the Source code of the program in Visual Basic Project.. Thank you...
We're a startup company from Switzerland. We create Sample Libraries (virtual instruments) using new, innovative sampling technologies. We're looking for a collaboration to create the UI design for our very first library, a hyper-realistic cello. We seek a modern and fresh visual concept for how the user interacts with the interface. To give you an idea, here a few examples of an other...
My website is a marketplace where there are a certain amount of 'pieces of land' however it is all digital. People bid on them, and once owned they make dividends on their investment too. People can also sell their land. The aim is to have a marketplace where the real estate stock price goes up and up. Hope you can understand what I need doing! p.s. the idea is already Trademarked in USA...
We are a company based in Norway, owned by a Bulgarian company. We work strictly for Norwegian customers, and as of today have a client list of 83 businesses. We created a system which nearly-finishes a webshop a customer purchases from us, but it needs someone to simply edit the photos the customer sends us and place it on the right place, and put the text they send as well (it's easy, we c...
I want to have bids solicited from logging companies in the Powhatan VA area to harvest a 35 acre tract of timber. I have a recent appraisal of the property and of the timber value. I need someone to manage the bidding process and present the best offer.
Hello every one i have been working on a project for deaf sign lagnuage open source I need to create infographic and high quality video 40 sec report With voice over that explains the full project clearly “Deaf Pedia tries to make communication between deaf people and non-deaf people easier. Deaf Pedia started the first and only open source DB to share
...passenger app sends cab request notification to all drivers, when one of the drivers accept the request a message pop up tells the driver that another driver has accept the request, but in fact no driver did accept it. And requesting process continuing none stop keep sending notification to drivers until passenger cancel the request process. - and when
I have received a letter from Umwelt- und Verbrauchershutzamt regarding a shipment that we are importing. I would like to receive the translation by 12:00 11.01.2019 or faster
I need full business model RFP to request system Application same as UBER and has one more service which is take and drop to ship food and others to home. We need this asap with all features mention on document the cost depend on time of delivery the Doc and details.
I need an ios & Android app. I would like it designed and built.
We want to transform its SQL stored procedures (we have 218 of them) into JPQL language with the Hibernate framework. To show that it works well, we will ask you to justify this with unit tests in the spring application. Contact me by private message for more details.
...highlighted keywords from the provided job description. Resume copy (1.5 pages) and cover letter (half page) will be provided along with the job description. Track resume versioning record in a provided excel format and upload edited resume and cover letter in defined folder structure. The expected output should be interview-winning, ATS compliance
I need a pair children rain boots artwork proof to be design like the example 1 and example 2. Artwork need to be shown facing forward and from a side and back profile. The eps logo need to be repeated all over the rain boot. Pleas do not alter any of the logo in anyway. In the center on the brandf logo "Jaime Madison Collection" must logo must sit in the center. this logo is the brand...
i will like to have an individual with experience writing resumes and cover letters to check and review my resume and cover letter for any grammatically errors and to make necessary changes to increase my chances to get interviews.
...purpose and experiences [within the company and those outside, which gives that extra bump to make the application stand out] 2.) recommendation letter #1 [max 1 page, font size 11] * 3.) recommendation letter #2 [max 1 page, font size 11] * 4.) proofread and improve an existing resume [1 page] *this is with permission from my mentors. In the end, they
Proofreading of a one-page cover letter. 20-mins job Has been edited and proofread by another native English speaker. As this cover letter is important to me, so I just want to make sure it has zero error and looks professional.
I need help in writing an outstanding business introduction letter, a letter that will propose our services to new clients in a way that prospects will die to do business with us. The wording of the content is what I'm mostly concerned about. Needs to be convincing and eye catching. Images can be used too catch the prospect eye.
Details of the project will be discussed once communication is established.
Hello, Im looking to use google to get some result but need to do more than 10 000 request per day. we got the captcha everytime. i know Google search api was removed from April 2018 but there is any alternative to it. we need to use google as bing and yahoo don't give the best result.
...looking for a professional and native English writer/speaker to draft me a commercially sound and persuasive cover letter to accompany my business brochure in conventional mail format. The objective of the cover letter + brochure is to project a positive first impression to the intended audience which then enables me to follow through with a telephone
Hello, Thank you for your help. We paln to make a trip to Brazil and thus need: 1) A formal business invitation letter; you are free to use a formal template online, but it should contain the necessary info of the contact person (probably, you or anybody else suitable), telephone number, CNPJ and others required by the Brazilian law. 2) Your reasonable