Small sql queryJobb

Filter

Mina senaste sökningar
Filtrera:
Budget
till
till
till
Typ
Kompetens
Språk
    Jobbstat
    6,268 small sql query jobb har hittats, med prissättning USD

    I have a search form that is slow and needs optimisation.. it is also not working as expected in some cases. I need an expert in php / mysql search expressions. Site is running on Php7 and mariadb 10. I will send the search file for your evaluation if you send me a message expressing your interest.

    $145 (Avg Bid)
    $145 Snittbud
    41 bud

    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

    $17 (Avg Bid)
    $17 Snittbud
    5 bud
    Tune the Geolocation Mysql Query 5 dagar left
    VERIFIERAD

    ...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

    $35 / hr (Avg Bid)
    $35 / hr Snittbud
    33 bud
    MySQL Query Help 5 dagar left

    ...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

    $26 (Avg Bid)
    $26 Snittbud
    14 bud

    I want to optimize my MySQL query. I have developed application in java, but when I run the query its take too much time. I want to reduce the time for result. Query sample attached.

    $93 (Avg Bid)
    $93 Snittbud
    18 bud

    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

    $28 (Avg Bid)
    $28 Snittbud
    6 bud

    Physical Modeling Design & Structured Query Language (SQL)

    $36 (Avg Bid)
    $36 Snittbud
    8 bud

    Need someone who has advanced SQL skills in Microsoft Access to assist with making and correcting queries.

    $6 / hr (Avg Bid)
    $6 / hr Snittbud
    5 bud

    Looking for someone with experience setting up databases - raw data in SQL for from multiple sources into google query for BI tool

    $421 (Avg Bid)
    $421 Snittbud
    21 bud

    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

    $27 (Avg Bid)
    $27 Snittbud
    12 bud

    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

    $79 (Avg Bid)
    $79 Snittbud
    17 bud

    ...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

    $13 (Avg Bid)
    $13 Snittbud
    3 bud
    Create mySQL query Avslutades left

    I need help writing a mySQL query to pull data from multiple tables for output into a single table (for use with the Wordpress plugin wpDataTables). More details on request.

    $22 (Avg Bid)
    $22 Snittbud
    25 bud

    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.

    $168 (Avg Bid)
    $168 Snittbud
    10 bud

    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

    $23 (Avg Bid)
    $23 Snittbud
    13 bud
    Search engine query Avslutades left

    ...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

    $20 (Avg Bid)
    $20 Snittbud
    4 bud
    Query Build Avslutades left

    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

    $463 (Avg Bid)
    $463 Snittbud
    44 bud

    ...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=1541112014&sr=8-3&keywords=small+business&dpID=511ICYoAH6L&preST=_SX218...

    $66 / hr (Avg Bid)
    $66 / hr Snittbud
    35 bud

    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

    $147 (Avg Bid)
    $147 Snittbud
    9 bud

    ...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

    $27 (Avg Bid)
    $27 Snittbud
    2 bud
    Database mysql query Avslutades left

    I have a database MYsql entry

    $28 (Avg Bid)
    $28 Snittbud
    12 bud

    Its very urgent and bid only if you are able to do right now. We need to data from cart page to checkout page. start bid with below answer 2+2 My budget is 20$(NZD) maximum

    $13 (Avg Bid)
    $13 Snittbud
    16 bud

    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

    $353 (Avg Bid)
    $353 Snittbud
    25 bud

    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

    $51 (Avg Bid)
    $51 Snittbud
    3 bud

    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 [Logga in för att visa URL] [Logga in för att visa URL]@/Rembrandt-Van-Rijn [Logga in för att visa URL]

    CSS
    $194 (Avg Bid)
    $194 Snittbud
    16 bud

    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 [Logga in för att visa URL], records start being duplicated. I suppose it is due to one of my JOIN but I've tried moving them without

    $35 (Avg Bid)
    $35 Snittbud
    12 bud
    media query in css Avslutades left

    website done but media query not working properly

    $15 (Avg Bid)
    $15 Snittbud
    15 bud

    I will ask you to query 14,000 URLs in semrush or ahrefs after API. I am interested in the parameter: backlinks / IP and possibly the number of keywords they are visible to.

    $144 (Avg Bid)
    $144 Snittbud
    7 bud

    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.

    $29 (Avg Bid)
    $29 Snittbud
    4 bud

    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.

    $9 - $47
    $9 - $47
    0 bud

    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.

    $31 (Avg Bid)
    $31 Snittbud
    1 bud

    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([Logga in för att visa URL]): name = [Logga in för att visa URL](max_length=255, verbose_name=_(u'Name')) email = [Logga in för att visa URL](verbose_name=_(u&#...

    $47 (Avg Bid)
    $47 Snittbud
    4 bud

    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.

    $125 (Avg Bid)
    $125 Snittbud
    15 bud

    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

    $202 (Avg Bid)
    $202 Snittbud
    11 bud

    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

    $42 (Avg Bid)
    $42 Snittbud
    7 bud

    I have a custom post type called BID which contains a users bid (similar to freelancer.com) I need the BID results on the page to be ordered by meta stored in a users profile, which is a custom post type PROFILE. I need to add functionality to my WordPress theme that will add a dropdown to reorder custom post type BID results in various ways, according to meta (numeric) in custom post type PROFI...

    $66 (Avg Bid)
    Sekretessavtal
    $66 Snittbud
    18 bud

    We need someone who can write MySQL queries to modify the data we have and create an output in the required format.

    $27 (Avg Bid)
    $27 Snittbud
    25 bud

    I have a large query with multiple joins and need suggestions to tweek it to run faster. May be divide it or change or use index.

    $24 (Avg Bid)
    $24 Snittbud
    11 bud

    Hello! i have wordpress site where i see my EVENTS, i need update the order of query, i think is a simple work for wordpress expert developer.

    $29 (Avg Bid)
    $29 Snittbud
    56 bud

    ...website mobile friendly with CSS media query Pages to work on : shared Header/Footers [Logga in för att visa URL] [Logga in för att visa URL]@/Rembrandt-Van-Rijn [Logga in för att visa URL]@@/8YDJKC-Night-Watch [Logga in för att visa URL] [Logga in för att visa URL][Champ20_EN]+contains+%22Books%22 https://en

    CSS
    $155 (Avg Bid)
    $155 Snittbud
    33 bud

    ...scans directory every x seconds for changes and creations of new .log files (this is already done) If the file edit/modification or creation is true then it should start mysql query to insert that last new lines of .log files Also there should be in case if pc has no connection and so on, some kind of check of last inserted files and should loop thru that

    $37 (Avg Bid)
    $37 Snittbud
    3 bud

    ...other, they can see what the opposite person has answered? That could be the query we need to run: 1. $querystr = "SELECT * FROM `wps_formmaker_submits` WHERE `user_id_wd` = ' here there is a need to add an ID of the user, with whom you are chatting. 2. Then create a wp query and get the $wpdb->get_results($querystr, OBJECT); result. 3. Display the result

    $17 / hr (Avg Bid)
    $17 / hr Snittbud
    8 bud

    For module requirement check the attached document and develop a query management module. In this development someone register for any type queries and automatically generated User ID and password for login in admin panel to post any type queries.

    $146 (Avg Bid)
    $146 Snittbud
    20 bud

    Fix SQL Query Issue. What to fix: Need to fetch those records / rows that contains all keywords in any column in Name, Descr or OtherDesc Columns. See txt file for details. Important Note: Please read the txt file and prepare your queries if any before posting, otherwise the bid will be rejected.

    $24 (Avg Bid)
    $24 Snittbud
    21 bud

    Need help in select query in MS Access

    $2 / hr (Avg Bid)
    $2 / hr Snittbud
    12 bud

    Need proper SQL Query for the following query: For E.g. there are some records in the SQL DB Table as follows: ID NAME DESCRIPTION 1 Test One This is the Test Record having test description 2 2nd Record This test record is the another one with sample text When

    $19 (Avg Bid)
    $19 Snittbud
    12 bud

    Need proper SQL Query for the following query: For E.g. there are some records in the SQL DB Table as follows: ID NAME DESCRIPTION 1 Test One This is the Test Record having test description 2 2nd Record This test record is the another one with sample text When

    $20 (Avg Bid)
    $20 Snittbud
    6 bud

    The solution I am after requires a data engineering development which should be able to query a postgreSQL database of 20 million records (2 crores). In the ideal scenario, the query should return 100,000 records under 5 seconds. I am looking for someone who is experienced in Apache Spark and able to show a proof of concept before developing a full

    $225 (Avg Bid)
    $225 Snittbud
    12 bud

    When the checkout function is used i get the error WARNING : Error while sending QUERY packet. PID in /ur/www/users/xtremezepc/[Logga in för att visa URL] on line 1924 This is causing high load times when i try to check out. there are sleeping queries being created. Need fixed NOW.

    $111 (Avg Bid)
    $111 Snittbud
    25 bud

    ...accumulated a number of spam posts over the years. I need to create a simple SQL statement that will find the posts that contain the strings: -http -https -www. .com .net .org .info that don't contain the strings youtube world-of-lucid facebook twitter What should be returned by the query is just the post id and the URL contained in the post. This data must

    $21 (Avg Bid)
    $21 Snittbud
    22 bud