Wordpress custom sql query jobs

Filter

My recent searches
Filter by:
Budget
to
to
to
Type
Skills
Languages
    Job State
    5,957 wordpress custom sql query jobs found, pricing in USD

    DESIGN MY QUERY AS DESCRIBED IN [login to view URL]

    $25 (Avg Bid)
    $25 Avg Bid
    8 bids

    I am working with a deli...number “506”, and so on. I want to be able to query it in a way so that if “506” already exists in the delimited list, it shouldn’t duplicate it because then we will have it twice. I have a sample query ready for you to look at along with few examples so it really should be easy for you if you know sql server 2014.

    $22 (Avg Bid)
    $22 Avg Bid
    2 bids

    I need to write around 50 MongoDb queries such as 1. Join of two collections 2. Data not exists in one collection after data fetched from first collections 3. Union all functionality based on data from multiple collections. 4. Script to save files into CSV It won't take more than 5-6 hours if someone is expert in Mongo.

    $130 (Avg Bid)
    $130 Avg Bid
    7 bids

    Thsi should be easy: I have a file that reads like this: $sql = mysqli_query($con, "SELECT `searchString` FROM `mightyUsersSearch` WHERE `user_id`='$cid' LIMIT 1"); if (mysqli_num_rows($sql) == 0) return 0; .... The output generates the data for the screen shot. Now I want to extend it to several such 'searchstrings' and remove LIMIT

    $21 (Avg Bid)
    $21 Avg Bid
    33 bids
    MYSQL Query Fix 3 days left

    I have a mysql query I am working on, part of it is correct and part of of it is not. I need help correcting the issue. I can provide sample data and queries. This is the main query in its current state. amtbill column does not sum correctly. I'm sure it is the type of join but I am not sure how to fix. SELECT [login to view URL], [login to view URL]

    $32 (Avg Bid)
    $32 Avg Bid
    21 bids

    Pivot Query with Multi Where clause , Sql Server

    $18 (Avg Bid)
    $18 Avg Bid
    20 bids

    The project is using PHP 5.6 the work is near taking 2 hours to solve this issue. convert this whole project to 5.6 to 7.2.1 it's a really e...using PHP 5.6 the work is near taking 2 hours to solve this issue. convert this whole project to 5.6 to 7.2.1 it's a really easy task just because I am using atom so just 3 query to convert the whole project.

    $22 (Avg Bid)
    $22 Avg Bid
    8 bids

    I want to extract some data via PHPmyadmin from a database in a CSV format. only apply if you are an expert and can do this right now. I think its small task and it can be done within 5 min if you understand my requirements. Need to be done on anydesk.

    $15 (Avg Bid)
    $15 Avg Bid
    15 bids

    Need some strong Jquery developer to set over flow issues, already we used horizontal scroll need to set overflow for one sections, will give more details.

    $30 (Avg Bid)
    $30 Avg Bid
    24 bids

    alter table [login to view URL] if the following cols dont exist add z_rech_code string 10 chars z_suc_msg string 100 chars z_min number like 999999.32 z_warn integer 2 dig default 1 Z_tries integer 2 digit default 0 z_last_topup_date date z_last_topup_run date default is create date z_enabled 0 or 1 z_ussd_1 string up to 100 dig z_ussd_1_return string up to 100 z_ussd_2 string u...

    $196 (Avg Bid)
    $196 Avg Bid
    17 bids

    We have a stored procedure with sql queries , need a person to help us converting it to cube and get the desired output. we have the dimension and measures are in place

    $6 / hr (Avg Bid)
    $6 / hr Avg Bid
    9 bids

    Hi there, My IT person is away on holidays and I need someone to help me with 6 simple queries. Very simple task is to write 6 SQL statements based on a simple data model (4 tables only). Easy for a very good SQL programmer, should take less than 20' of your time! Details of the model and the 6 questions to be shared privately after project approved

    $19 (Avg Bid)
    $19 Avg Bid
    58 bids

    Hi friends - I have this syntax that I am attempting to query an API and return data from it. My issue is that when the syntax hits List<IH> ih... line it returns a 500 error. Can someone examine this and let me know what I should do to remedy? private void LoadGrid() { List<IH> IH = new List<IH>(); IH = dal

    $37 (Avg Bid)
    $37 Avg Bid
    13 bids

    NEED SOMEONE TO HELP FIX SQL DATABASE QUERY (Load directions: 610 directions)

    $28 (Avg Bid)
    $28 Avg Bid
    25 bids

    ...1.1 Query/Search - "leaf" View Search History - Live Example: [login to view URL]~%3A=PARA1%24LD&expr=PARA1+AND+PARA2&p_s_PARA2=leaf&p_tagrepl~%3A=PARA2%24COMB&p_op_ALL=AND&a_default=search&a_search=Submit+Query&a_search=Submit+Query

    $22 (Avg Bid)
    $22 Avg Bid
    4 bids

    Please write sql statement to query “total sales of each product for each salesman who had sales on more than 1 product“ check files

    $20 (Avg Bid)
    $20 Avg Bid
    18 bids

    ...iis and hosted in aws and in AURORA db. The scope of work includes running benchmarks tests, analyzing the results and improve the query performance Till acceptable performance level is achieved. This is no simple sql writing job. Need high level expertise in understanding complex queries and rewriting them to improve the performance. Please share

    $528 (Avg Bid)
    $528 Avg Bid
    50 bids

    Need to be able to semantically parse queries to classify textual queries into buckets and translate them into actions to perform. More information if we decide to proceed.

    $2241 (Avg Bid)
    $2241 Avg Bid
    7 bids

    I need to make 10 queries on MS-Access, are multitable query. And very important, I have a table with User and password. Need to show information if user and password is valid, if not valid the query not show information. I want to the freelance will connect to my machine to make queries.

    $41 (Avg Bid)
    $41 Avg Bid
    9 bids

    The PHP needs to: Check a date field then email me (a designated email address) and a client (their email is in a table in same database) on that day. Email to say something like "Just a reminder." with a subject of "(field in database) Date" and also Check a second date field then email me (a designated email address) and a client (their email is in a table in same database...

    $134 (Avg Bid)
    $134 Avg Bid
    26 bids

    I would like some help with some simple MongoDB queries. Message me for more info!

    $24 (Avg Bid)
    $24 Avg Bid
    8 bids

    SQL Query for an existing database

    $79 (Avg Bid)
    $79 Avg Bid
    26 bids

    I am looking for someone to write an Excel / PowerBi power query to allow me to access a text analysis API provided by Tisane. The API documentation can be found here: [login to view URL]

    $97 (Avg Bid)
    $97 Avg Bid
    12 bids

    I need to solve a json_decode query (PHP, using curl_setopt). The php file will be hosted in a URL without HTTPS, but the data provider had HTTPS. The code is attached here.

    PHP
    $103 (Avg Bid)
    $103 Avg Bid
    15 bids

    ...Project Manager to a page in a table format with a link to additional information in a profile page. The Project Manager has a search and query search but the search does not work. I want to be able to input a query based on the following fields in the table: class year, position, ht, wt, state/region, gpa, act. Any assistance that you can guide me

    $513 (Avg Bid)
    $513 Avg Bid
    36 bids

    Can someone fix my C# syntax to query SQL Server from ASP.Net? This is my syntax I attempt but I have multiple compile errors -> what would be the proper way to do this? public class InvoicePullController : ApiController { public IEnumerable<Invoice> Get() { List<Invoice> result = new List<Invoice>(); using

    $28 (Avg Bid)
    $28 Avg Bid
    18 bids

    Hi! I want hire someone who can write one small query and one small function which can provide me required data in table. I have one table called number_list in which I have id, name, number and one another table called number_status in which I have id, number, start_time and end_time. I want display data in my table called name, number and Number

    $2 / hr (Avg Bid)
    $2 / hr Avg Bid
    8 bids

    I belong to about 30 Facebook Groups. I have about 10 products that I post for sale to each of these groups . I need a Program that can identify all my Post Id's in all my groups. The ID's can be saved to a text file. I own a Windows 10 laptop. If you can't write a program for my laptop, then an app for my samsung s9 android phone would be my second choice. If you could tell me how ...

    $172 (Avg Bid)
    $172 Avg Bid
    6 bids

    Calculate the Credit transaction views for each month, per customer. CreditView - In the form 1-0-0-1-1-...etc where 1 is a month with at least one transaction and 0 a month with no transaction CreditVolumeView - In the form 2-1-3-0-1-..etc where each digit is the total volume(number) of transactions for one month CreditAmountView - In the form 128-29-24-89-...etc where each number is the total ...

    $37 (Avg Bid)
    $37 Avg Bid
    2 bids

    I am looking for someone to transfer excel data manipulation logic into Microsoft power query (Microsoft power BI) to enable assessment of a large data set (>200m rows).

    $795 (Avg Bid)
    $795 Avg Bid
    33 bids

    I am looking to create a query the links two columns in the same table and considers them as a single row when running the query. This needs to ensure that column 1 ('action') and column 2 (availability_date) both equal the value listed. We have multiple entries where 'user_id' in this database table, which has matches for the action and availability_date

    $21 (Avg Bid)
    $21 Avg Bid
    15 bids

    Using Entity Framework and C# want to run a Select statement Stat...studphone from studeninfo where validated IS NULL Need full C# syntax that can query SQL Server using Entity Framework and execute the above select statement. I already have set-up Entity Framework and am returning all results from table, just need to know how to do a raw sql query

    $23 (Avg Bid)
    $23 Avg Bid
    40 bids

    I want to add query to retrieve data from other MySql database in same server to Joomla website using login user condition

    $28 (Avg Bid)
    $28 Avg Bid
    19 bids

    An existing stored procedure which is having sql queries we need to update the sql queries to MDX.

    $4 / hr (Avg Bid)
    $4 / hr Avg Bid
    10 bids

    ...medium). Site's working fine mostly, but sometimes the server CPU utilization shoots up to 200% (2 cores) because of one mysql query. On setting up a slow_query log and testing with few orders, there's this particular query which takes the most time. SELECT c.category_id, c.parent_id, [login to view URL] as title , ( SELECT COUNT(p

    $74 (Avg Bid)
    $74 Avg Bid
    5 bids

    AppGini knowledge a plus! I have a database which houses several tables, consisting of employees, their titles, and what brand they work for. I then have a table which houses various training programs and another that lists which training programs are required by which brand and for which position. I need a report that will display what training is required for each employee based upon which bran...

    $166 (Avg Bid)
    $166 Avg Bid
    20 bids

    I have a MongoDB query: var queryLookup = {from:'fromCollection',localField:'field',foreignField:'otherField',as:'lookup_info'} [login to view URL]({$match:queryObj},{$lookup:queryLookup},{$project:queryProject},{$sort:sortObj}).toArray(function(err,items){}); However, the lookup_info value is an array with the first element being the entire set

    $35 (Avg Bid)
    $35 Avg Bid
    2 bids

    ...another and discovered an issue with duplicate images. Some products call images like abcd_01, abcd_02, abcd_03 but it's always the same image. We want someone who can script a SQL function or a PHP script to make the product call abcd_01 for all variants or for all other products which call abcd_02 and abcd_03 and so on. But, obviously, we have 61637

    $34 (Avg Bid)
    $34 Avg Bid
    15 bids

    Please see excel spreadsheet attached- it has 2 tabs. Tab 1 – Jan-Sept –Lauren info Tab 2-AB vins unpaid –Andre info I need to populate column H of my tab with description “AB list.” as per the VIN and part number in his spreadsheet-column C and D on his tab The ones in yellow on his spreadsheet I did manually & populated column H on my spreadsheet by typing in...

    $22 (Avg Bid)
    $22 Avg Bid
    6 bids

    I'm providing you with a UML diagram (see attachment and the note below) and the following question based on which a SQL needs to be written. The Question is, Which Drugs are in a relationship with a Gene that is in a relationship with a Protein which has a relationship with another Protein where minimum positivity is 0.8 and minimum identicality is

    $52 (Avg Bid)
    $52 Avg Bid
    6 bids

    I need to take out matching records from sql server saven in key and value pair. Key can be anything like "Masters in Maths" etc and value can be anything like "90%" for example. I need to take out all records when i pass "Masters in Maths" as query parameter.

    $105 (Avg Bid)
    $105 Avg Bid
    10 bids

    We have a map application with a Laravel website. The GeoHash has been implemented and there's small issue with it. We need you to fix it. If you know Open Layer or Laravel programming. It should be easy. The work has to be done using remote control: Teamviewer or Anydesk.

    $51 (Avg Bid)
    $51 Avg Bid
    3 bids

    Looking for anyone with knowledge of dbf files

    $11 / hr (Avg Bid)
    $11 / hr Avg Bid
    12 bids

    Hi, I would like you to create a sample Java application that can continuously listen to any addition, modification, deletion that we do on a specific region in Pivotal Cloud Cache... We need to use Spring framework 1.5.*, Maven for the build... The application should be deployed in Pivotal Cloud Foundry.. Thank you. PS: Note if you are proficient with PCF and binding multiple internal and ext...

    $146 (Avg Bid)
    $146 Avg Bid
    10 bids

    ...give me correct answer. Please don't bid more! Query 1: select date_format(livedate,'%Y-%M') as month, sum(allotted) as made_available from sky_seat_detail s, sky_film f where [login to view URL]!='backstage' and f.live=1 and livedate>=live_date and s.film_id=[login to view URL] group by month order by livedate asc; Query 2: select date_format(live_da...

    $14 (Avg Bid)
    $14 Avg Bid
    27 bids

    I have one SAP report called ZAR AGING and this need to convert in SQL procedure. So I am looking for an expert who can read the logic from SAP and convert it in SQL query

    $39 (Avg Bid)
    $39 Avg Bid
    10 bids

    I will inform you with a detailed explanation and source of the chat.

    $24 (Avg Bid)
    $24 Avg Bid
    22 bids

    We need help writing an SQL query for Microsoft access. The calculation that I would like to perform is on time series data. The query selects data from the table (see attached file) related to a single unique identifier (CUSIP) and then performs a rolling calculation for the Variables PosShare , Cost, MV and G_L (see example calculations in attached

    $176 (Avg Bid)
    $176 Avg Bid
    11 bids