...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 tried with clever things like SELECT driver, SUM(`position`) FROM (SELECT driver, race, season, `position`, IF(@lastDriver=(@lastDriver:=driver), @auto:=@auto+1
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
...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 coming in faster than old ones can be processed. I had a developer add this functionality and he is no geolocation expert. He added the table and used a basic query. By what I've had a chance to read online this
...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
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
Plagiarism is a serious problem in research. In this project, you will implement a very simple string matching algorithms. Your input will be a corpus of existing documents and a pattern you are looking for. Your output will be the set of documents that contain your query pattern.
Physical Modeling Design & Structured Query Language (SQL)
Hello, I need someone who can clean my email list and help me to pass Omnivore Best regards
I need help create a small utility to exchange JSON string between C++ and C# - C# 4.5 or higher as a WebSocket server. C# can push JSON serialized as string data to clients. - C++ code (11+) can be WebSocket client. C++ must be independent and compile-able to a single executable file on Linux and Android 4.4+. No library dependency accompanied with
I have a design of an all-access pass that I want created but made with better graphics and gold leafing lettering. I have an example of the gold lettering in the file and an example of the all-access pass in the file too
Constantin - For the project on [login to view URL], the client is wanting a few updates/revisions. I'll post full detai...I'll post full details in chat again when accepted I suppose? We can confirm pricing/etc, but it will probably amount to 1 interior page design and some revisions/a new option for hoe page design, so +/-, 2 interior page designs?
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
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
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.
I NEED TODAY WORK START IMEADIATLY i have a list of numbers i excel i need the, organised for use in database. list looks like 0015 0037 0050 0139 0150 0151 0152 0153 0154 0155 0180 i need this to be changed into 0015,0037,0050,0139,0150-0155,0180 so every time there are a numbers serie the system returns Start nr - end nr , all single numbers are entered one by one Multiple ID's: 254...
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
...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
...sentences composed of random words using all words in the English language. The sentences are to adhere to the rules of English grammar and syntax, as you can see on the example page provided. The sentences should make no sense. The program is to run continuously generating these sentences. The only two controls I need are: one to start the program and another
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
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
I need a fullstack developer in .net, c# , Angular 6, CSS ,HTML5, For front end and For back end Bootstrap, J query, java Ajax web API TFS. Who has good working knowledge on that and ready to work daily 3-4 hours remotely like team viwer and IST morning time in between 7 to 11am We have fixed monthly paid long term project so budget is monthly based
Hi, I have a php script including some sql code inside. My script is working ok in my local server, but because the purpose is interact with Moodle database, it is required to follow specific formatting Moodle requires in order to show the appropriate results from my query. Please check the attached php file contaning the whole code. You need previous
Make our website mobile friendly with CSS media query we do not give access on the server, so you cannot modify our CSS files, you will have to use the browser F12 to make the CSS, then send us the new CSS by email. 8 Pages to work on : shared Header/Footers [login to view URL] [login to view URL]@/Rembrandt-Van-Rijn [login to view URL]
...168.8.6 Accept: text/html, */* User-Agent: Mozilla/3.0 (compatible; Indy Library)" I use OllyDBG to check the code of this ".exe". file, my goal is changing that IP address string "[login to view URL]" to " to "[login to view URL]" It seems the code in this ".exe" software lead me into an infinite cycle when I trying to use F8(Step over...
Hello, I have my scrapyRT server up and running but now I need to pass parameters to my spider There is an issue created with 2 solutions but I cant make it work : [login to view URL] Options are : A) Using "meta" field to pass parameters : I cant read them B) Patch the library with the code of that link : Couldnt make
I need the help from a SQL expert. When I execute the following query I get most of the information I want, that is full completed courses by user in Moodle. The problem is when I add one course column to be shown as a result, for example [login to view URL], records start being duplicated. I suppose it is due to one of my JOIN but I've tried moving them without
Hello, I need some work for excel to be done. We have inventory lists in excel that is large file. We would li...should be marked green. if not than it should be written in a special column . Text in barcode are only numbers. We need some kind of function to do that, or macro or something. Hoe I explained well, for all other questions just contact me.
Hi! This project is about a query to get results by date using mongoengine over mongodb to filter results by month, year and month and age So, I have a model in Mongoengine class Contact([login to view URL]): name = [login to view URL](max_length=255, verbose_name=_(u'Name')) email = [login to view URL](verbose_name=_(u'E-mail'))
We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excel macro to connect to Jira query for Epics, stories, linked test cases, bugs found during testing. I have all of the JQL needed to find the issues in Jira.
I have a very small database (<40 entries) that I'd like to make available online in an attractive, user-friendly manner. Users should be able to take a "quiz" to select what data they're looking for (3-5 questions/search criteria), and the web app should then produce results in a preferred order. It should not look like a database but rather an attractive online quiz/form. ...
We are a home builder and we have organized our invoices from our subcontractors and vendors by their name and not the address it was billed for. We have about 5 years worth of invoices from 400 different subcontractors. Some pdfs only have about 5 bills per year and others have 100 per year. In the 5 year time span we have built close to 300 houses that these invoices would have been billed ...
I am using Power Query to access football scores data from an API service in JSON format. The API endpoint address contains my API key and API secret and everything works well. However, instead of having to do a new query with a different endpoint address every time I want to get new information, I wish to have the address dynamic so that the variable