...issues even when doing simple things like a multiple post delete in wordpress. There was concerns that the timeouts were caused in the nginx to apache pass off. 3. We added Redis database caching and need to make sure that is working well. Tasks needed from freelancer: 1. Identify and help troubleshoot the load time/bad query issue 2. Create a solid
Hi All i have a table like attached image needs first negative balance date followed by second last positive balance means 7769 . -3752...like attached image needs first negative balance date followed by second last positive balance means 7769 . -3752.86 2018-08-10 08:06:35 1 min job for expert send query in your reply budget : 500 INR
Hi, We are after a simple system, to simply capture some defined inputs being passed in a query string, repost to another URL and pass the response back to original request. Background. We use a simple SMS messaging system via URL Post, they are now requiring all IP's to be whitelisted and we simply can't give them all of our customers IP's etc, so
I am looking for someone to build me a simple web application to monitor GitHub repositories. Users will interact with the application via a dashboard (after logging in with their user account). This dashboard will allow users to provide a domain name ([login to view URL]). This application will then query GitHub (either through API or headless browser, this
I have MongoDB collection. I have to group the documents in that collection based on the monthly cycle. For example, the cycle date is 20 of each month. I have to group the documents like 20/06/2018 to 19/07/2018 , 20/07/2018 to 19/08/2018.
I need someone to write a simple sql query to copy fields between tables
...com/mockplus/10-best-app-ui-design-for-your-inspiration-in-2017-938db514053b Pages - 1. Login with social login options 2. Voice and hand based search query input HOMEPAGE. Classifieds catgory visuals will help - simple one thumb based operation needed. 3. Refinement questions like search facets in 2nd level menu , like a chat bot 4. Response list of result
we have a form for insert data, we need on submit to create a query before to process to check if data exist and IF exist show a modal with alert and name of data else process
I need someone freelancer to help me to fix the query below: select count(distinct p.products_id) as total from (products p) left join manufacturers m on (m.manufacturers_id=p.manufacturers_id) left join specials s on p.products_id = s.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on
Query on Office 365 Excel Online to export the data. No bootstrapping. Need to use Dojo or jQuery, or find a way to get it into that format for me to use.
Project Duration: 1 Hour Project Overview When trying to run this query: SET `description` = REPLACE(`description`, 'â€™', ''') WHERE `description` like 'â€™%' We get the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right synt...
I am currently getting a 500 error on my website. I traced it back to an SQL query (SELECT XYZ FROM zip_code INNER JOIN city ON zip_code.city_id = city.city_id INNER JOIN region ON city.region_id = region.region_id INNER JOIN country ON region.country_id = country.country_id). The INNER JOIN country ON region.country_id = country.country_id part of
Scrape from a google spreadsheet into a database on Azure or EC2, and create a UI for non-technical people to query. Make sure certain users can add but cannot delete data from the db. Also the UI should sanitize and validate the data before entering it int the database.
With php and a free-standing html window for a desktop or mobile device, create a simple list with 6 columns (Our productid, our product sku, Amazon's asin or upc, Google's PLA id, our product name, our inventory quantity), plus a checkbox based upon sql query results we will provide. Add 3 buttons with the indicated functionality to the window, Pause
I have a quick issue I just need some advice on Fixing or a slight change of code. JSON Response is being presented to the app however, it won't append to the Diction...is being presented to the app however, it won't append to the Dictionary that I'm trying to use. Paying a maximum of $30AUD for this as it is a quick code fix. Just needs a simple fix.
Select rows to display the columns: name of product/service assign alias as “ProductService”, quantity sold of product (invoice detail), employeeID who is assigned to the invoice; where the employee ID equals 1; sort by name of product/service ascending.
SELECT [login to view URL], SUM([login to view URL] * [login to view URL]) as price FROM Customers INNER JOIN Invoice ON [login to view URL] = [login to view URL] INNER JOIN InvoiceDetail ON [login to view URL] = [login to view URL] group BY [login to view URL] I CAN"T SEEM TO GET THE Customers.Firstname...etc... because of the SUM... I can get one or the other but not both...
This work involves a pdf file of shipping labels with multiple pages that needs to be sorted based on a reference number in a text file that matches a label/page within a pdf file.. ie A list of alpha numeric letters/numbers are given vertically in a text file that need to be searched within the pdf file and as the pdf file finds the queries within its pages (which is one per page), it creates a n...
I need you to build a landing page. budget 600 Rs
I would like to have a simple project using Amazon API. 1. Connect Amazon API "All Orders" and other reports. 2. Download Orders/update order on a daily basis in the excel or in the database. 3. deploy it in the server and should able to download it or updated it in a daily basis. 4. Run the select query where promotion_id =" text%" and insert the
...from code. SQL Query have to put in procedure. --> use CALL name ( [ argument ] [, ...] ) Ref: [login to view URL] 2. SQL Procedure Generator: Procedure will be gennerator from Input.1 condition. 3. front end: View/ Search/ Create/ Delete/ Update (GUI: Data View with multi page display, 1 page ~ 20 line data) Ref simple GUI: https://github
I have a query in place and would like to create a form with drop down boxes that allows the user to run the query based on the criteria they select. I have started the form but am struggling with linking the combo boxes to the query.
We need a simple C# application sample that can query and get the current users online status from the local running Skype for Business windows application. The application can be a console or windows forms app as long as the sample can easily be loaded and run by us.
...create Mongodb query. It's maybe not the most complex query you ever find but we have not too much experience in MongodDB and how to use all this features. The query will cover all the basis filters and the use of the geospatial feature (just a simple search of maxdistance usign coordinates, we already have this). Basically, the query has to: Search
Hi I have a query which I use in SSRS report builder 2016 to display results in a chart. Query is ok but I would like a column being pivot in the query and have never done this before. Should be less than an hours work and your need to work via Any Desk on my system to change the query. Get in touch if you can help. Thanks, John
I have 2 Spreadsheets that I have attached - Data from these 2 spreadsheets will need to fill in the 3rd spreadsheet.
...new table off the excel sheet we run a query to capture unique values using combined Inst and Mid query to extract unique string from excel field. I am encountering a challenge that the table I create from the above query has hidden charachters (?) I only see this after I export it to a text file. I need a query value to clean this up. I have tried
i have a sum query i need that a group by field should be based on a if statement purpose = i have two warehouse's but dont want each item to show double only if its not there in the first do i want it to show from the 2nd job will be done by loggin in remotely its a query based on other query the whole structure might need to be redone should