...in a mySQL database which are giving me cause for help. Essentially we have a collated set of data in a few tables but we need ONLY the top 3 to be used for the position in a race. So if a racer has results from 10 races, we want to get only the top 3 and we need to SUM the total of their points in order to list the top three racers in a query Have
Hello, I need a sql query that generate a csv from a prestashop database, value required values in the csv are the following: id_order -> order number id_order_invoice -> invoice number total_products -> total paid of the order vat excluded and without shipping total_shipping_tax_excl -> shipping paid vat excluded state -> order state date
...visitor and then we display content based on the timezone. We are using a geolocation mysql table with 3M rows for this. The site is working fine when we receive maybe up to 100 visitors per second, but when that goes up to say 200 the server cannot process the query fast enough and the whole server stops. Old processes are backing up and new ones are
We are starting the next chapter of our business and lives, and need assistance from an expert dealing with Israeli bureaucracy and legal matters. The freelancer we are searching for will help retrieve documents, perform legal research and provide reports in both Hebrew and English. We will pay per project, the first being to assist us in retrieving documentation that otherwise would be difficu...
Hello potential freelancer! My partner and I need to secure legal representation for the initial opening phase of our business. We are looking to hire a remote legal assistant to help with documentation. Some of the documents will be in Hebrew so an individual with Hebrew language knowledge would be very helpful. In addition, the individual should
...select values is this session_id mentioned above. In the view, I only want to show records for the session_id associated with the current date. If I use MAX(session_id) in my query, I will get older session_id if they are the newest. If I don't aggregate this data, I get repeating records. Instead, there should be a single record for each person defined
Hi, I 'm a Business Developer at a software design and development company. I 'm seeking a remote Graphic Designer who has the ability to take freelance projects from conception to final results. The company does a wide variety of design jobs. You may inbox me. I await your response on this. Thanks!
Need to access system from MSTSC from a Remote location through static IP
...through the connected printer without downloading the document. For more info check out [login to view URL] . We need a software just like that. We need a freelancer to develop the remote application part .Any modifications on our website if required, will be developed by us. We will be sending pdf document and ZPL codes through that software. So it must
There are 3 tables: 1. Project 2. Tool 3. LinkProjectTool I need a query that lists everything in the Project table plus an extra column called ProjectTools. This column should contain a comma delimited string with all the tool names belonging to each project. The elements in this column should be sorted after Tool ID. The input data is contained
Physical Modeling Design & Structured Query Language (SQL)
Cardinal Education Writing Specialist Job Title: Writing Specialist Location: Remote (Work from home) Number of Positions: 1 Compensation: 1,000 USD paid out over a 6 month period, Dependent on experience We are seeking a creative and motivated Writing Specialist intimately familiar with essay writing, personal writing, and prompt-based narratives
We are providing remote monitoring solution so we need to develop a application for it. The application contains reports, Charts and Dashboard etc. Controller installed at the site will send all the data to the server and we need to host the monitoring application in the server.
I have a redmi note 4 mobile phone running android. I wish to install lineage OS. I have been advised I need the bootloader and TWRP. Please reply to me in a message to confirm you have read the above and confirm. 1 if this is possible and 2. how long and 3. how much it will be 4. What information you require from me. [login to view URL] Many thnaks and happy bidding
We are a uniform and safety products business based in Sydney, Australia. We require an app (for iPhone, iPad etc) which can display data from a database. The database is on a remote server. On open, the app should run an SQL statement which fetches the data, then displays the results on the device screen. There should be an UPDATE button, which re-runs
I need help and advice on the best way to allow a virtual assistant to have access from Philippines to Germany so they can manage my social media account using a german IP
...and iOS - Will not be published in Playstore, deliverable will be only APK file and IPA files. - App starts with login/password authentication. - App will read a list from a remote SQL server. - All data is already saved in SQL table. - App will show a list of places the user has to visit. Data to show is Address. - Once user gets the place to visit
Job Description ****** US IT Recruiter - Remote Position ****** We are looking to hire US IT Recruiter to work for our US division to support our Recruitment functions * US IT Recruiter (OPT/CPT/W2 and Corp to Corp positions) hiring * SERIOUS INQUIRIES ONLY Please Don't waste your time * POSITIONS AVAILABLE IMMEDIATELY * This position is 100%
I want to demonstrate SQL data in a table. Picture 1 SQL query result. Picture 2 HTML table. I want to create a query which is result will be like HTML table. I mean I want to show Year column as a row and subjects as a group. I just need a query
We are looking for an Intern for Project Coordinator's Internship , successful internship can lead to a Full time Job Preparing innovative and “outside the box” project execution plans. Ensuring monthly reports are completed for projects. Assist in the implementation of the project by collecting and disseminating information related to the organization and the implementation of p...
...Canadian National only!! Senior Frontend Engineer (Remote) for a company in UAE, City of Dubai. It will give you the chance to gain experience with leading organizations as well as flexible work hours that will fit in with your lifestyle. The client is looking to expand their team with talented remote engineers. You will design, implement and maintain
I have a query where I am dong inner joins and then doing a check for isnumeric and then data compare that is failing as I am getting Error converting data type varchar to float. Problem is I am not sure what it is complaining about. I need somebody to help me troubleshoot the query. I am comparing to how it was working a few days ago and do not see
...knowledge about user modeling in dialogue systems required * Imagine a user that needs simple words for an explanation. I want you to create a program (in python) that can query Wordnet and find synonyms for words. There must be a function that given a word, it returns synonyms. def syn(word) will return a list of synonyms. Note: Complete commenting
...Consulting is looking for Senior Frontend Engineer (Remote) for a company in UAE, City of Dubai. It will give you the chance to gain experience with leading organizations as well as flexible work hours that will fit in with your lifestyle. The client is looking to expand their team with talented remote engineers. You will design, implement and maintain
Appen are looking to find recruits who speak target languages as their first language (UK English) to participate in a project. No previous work experience is required for this task. Those interested will be asked to register on Appen Global and use Appen’s recording platform to complete 4 phone calls with another person on topics such as finance, Insurance, retail, etc. Each phone call is ...
I have a software made in c++, that generate moving objects(airplane, cars, ships) with some parameters such as velocity, acceleration, position and direction. At...probability distribution. I would like to be able to determine the next velocities, positions and directions of the objects after the initial time by using kalman filter and skyline query.
We are looking for person that would...(CTRL + W) etc... all shortkeys 2) Basics of Command Prompt entries to open/close/save and launch programs on Win10 3) Minimum 15mbs per second internet speed to qualify for Remote Control work 4) Detail oriented and polite/friendly attitude 5) Attention to educational video tutorials that we will be providing
Requires a draftsperson to help out with AutoCAD task. Need fast turn around and require someone is is responsive and full time on Upwork. Tasks requirement will be briefed to freelancer each and every time a task is given. Task includes : 1) Drafting moderate-to-complex 2D drawings, etc. 2) Preparing shop drawings, construction drawings, as-built drawings based on field red-line markups 3) Draft...
...skills to help me develop the remote server management tool. All our processes run on AWS and you will be helping me streamline one of research processes. This will entail snchronizing research tasks from my local machine to multiple server machines, monitoring task completion, loading data into machine from a defines mysql instance, and downloading results
I want to get detailed PrestaShop sales based on products: so the fields I want in the report are: product name | qty Sold | Average Product price | Total sold Price | Original products price | Total Orignal Price | discounted amount | available stock
Parallel K-means Clustering of remote Sensing Images based on MapReduce
...fetched: reasy_posts reasy_postmeta reasy_terms reasy_term_relationships reasy_term_taxonomy Custo Meta Key : min_product_price. So please help me out to create sql query to fetch products from tables when i put the values in the fields and sort the products through meta_value(min_product_price). For Example: Find the products 'pen' where category
I am learning CUDA v10.0 toolkit for use on Visual Studio 2017. I want to find someone with experience in nvidia cuda development. The "course project" goal will be to create an application which receives data from MSSQL C# .net project --> passes the data to an unmanaged CPP/CU DLL --> performs the calculation on the GPU --> returns the data to the .net application. I am not l...
Need a query build that will execute. Needs to have Select GL number GL Id number As of date Filters of less than or equal to 3 months (0 -91days) 3 months to 6 months 92 - 180 days) 6 months to 12 months (181- 365 days) Also include balance filters MILLIONS <=$100M >$100M =< $250M >$250M need to be able to add GL numbers to With as of date
I have a 200 page book that I have in draft form and I need to 1. Advice on title for book and cover design advice 2. Query letter 3. edit and format it for print This a business book aimed to small and med sized businesses similar to this one https://www.amazon.com/Small-Time-Operator-Business-Trouble/dp/163076261X/ref=sr_1_3?ie=UTF8&qid=154111
I am a busy CTO working 80+ hours a week that needs someone reliable, trustworthy and patient to be my second brain. Typical tasks include 1. Managing calendar and email 2. Organising my personal life 3. Answering calls for me when I am busy or in surgery 4. Knowing what I need without having to ask! I am looking for someone who lives in Australia, and who is easily contactable and dependabl...
Hello, for a small association we need a project and shopping list to build a scoreboard with this functionality: - 2 x 7-segments led to show score of left team, 2 x 7-segments led to show score of right team and 2 x 7-segments led to show time (6 digits on total). It must contain an arduino with RF funcionality, the communication to the led display and all the power source. Numbers must be hig...
I need an experienced developer to fix an iOS iPad app built with Swift. The App is having an issue during it's build. It's likely due to a missing library/framework. Please only apply if you’re available to start working on this issue today. The issue needs to be fixed urgently. Important: The developer will need to work remotely on my computer to fix the issue. Also, I have a...
We are a multi-brand clothing store and , from season to season, we buy clothes for the following season from suppliers. We need a query system to understand what we ordered in the past. On the basis of the request, then, we will decide whether it will be appropriate to order a particular item or not. Example: 1) We have already ordered 70 gray sweatshirts
...a script I can run in the background of a browser (Chrome, Firefox) to track a Instagram user that blocks/unblocks me to stalk my profile. I want to be able to change the query interval (every 30 seconds - 10 minutes) and change the username. As output, I'd would like a simple log in any text format that would show me when the user unblocked me. The