...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
Create a shell script . I have the steps, I want to create a shell script to automate the task for me. It's basically an update I will be running in linux to add some field lines in file to another. I have the steps outlines already.
...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
...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
Physical Modeling Design & Structured Query Language (SQL)
Want someone to create a new coin from PIVX source code. Finished product should include bash file for easy setup of a masternode VPS on Ubuntu 18.04, and QT GUI wallets for Linux, Windows, Mac. Finished blockchain should not have Proof-of-work mining capabilities. All GUI wallets should be capable of hosting masternodes, have an explorer option built
Job hunt...right, but it can also kill your career if abused. Google is one of the first places potential employers turn to research prospective employees, finding blogs or posts that bash previous employers, or are contrary to the employers views or demonstrate that you may be a liability is hired is a quick way to kill your chances of a job offer.
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
[Instructions attached as well for easier reading] I want a bash shell script that automates the following: [Note: unless specified, configuration values are the default ones as seen when creating it via the Web Admin] 1) Asks for the AWS Key 2.1) Asks for a domain name (i.e. my-domain.com. From now on "[login to view URL]" is used to refer to the domain
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
...documentation Familiar with Develop Architecture is a plus Required Languages: C/C++ - C# - Qt - Java - Python - Bash Hint: it's not necessary to know all desktop platform program languages, just the one you good at it. Database Knowledge: MySQL - Microsoft SQL - Oracle - PostgreSQL - Mango DB - Cassandra - Redis - SQLlite Hint: it's not necessary to know
COMP2101 Bash Assignment The bash assignment consists of 3 parts. Each part will contribute to the total assignment mark. The rubric and submission for this assignment is on blackboard. To get full marks for any script, your scripts must have the following elements as covered in class: script interpreter line command line processor using while, shift
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 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
Expert knowledge of Unix scripts with awk, sed etc. Can you advise how you would approach this please? All current code will be provided as well as a screenshare if needed Description of the Request is attached ([login to view URL]) Current code is attached ([login to view URL])
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
Hi, I'm looking for 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
I need someone to make me bash script which where it needs to make a way to automate dev to stage to production so the devs at the push of a button can have everything make a backup and rsync out. I have an example script on another server which is doing the same thing so you can use that as an example if need be.
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]
...a2=6e a3=400 items=1 ppid=554072 pid=554075 auid=0 uid=6845 gid=6845 euid=6845 suid=6845 fsuid=6845 egid=6845 sgid=6845 fsgid=6845 tty=(none) ses=2443083 comm="php" exe="/bin/bash" key="BOTCATCH" -- type=PATH msg=audit(1539160233.188:56262206): item=0 name=(null) inode=928224 dev=08:15 mode=040755 ouid=0 ogid=0 rdev=00:00 nametype=NORMAL type=SYSCALL
As described in title, I need a multi org multi machine deployment on google cloud for hyperledger composer. Please also provide the terraform that is needed as we...in title, I need a multi org multi machine deployment on google cloud for hyperledger composer. Please also provide the terraform that is needed as well as all the shell bash script files
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
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. ...
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