Precisamos de um especialista em SQL e Query em SQL. Temos um site desenvolvido em PHP (sem framework) onde ele realiza algumas querys em SQL. Entretanto, os bancos são BEM pesados (cada banco tem em torno de 500mb, com 2 a 3 milhões de linhas) e isso está tornando o site um pouco lento. Precisamos otimizar essas querys e o banco de dados, seja na utilizaçã...
...pontuação deles. A pontuação deles é feita assim: 1 ponto por entrega e são retirados pontos caso haja algum desvio de conduta Precisamos de um calculo automático disso em uma query Informação do folheteamento fica em 2 tabelas no BD 1 Informação das entregas fica em 1 tabela no BD 2 informaç&atil...
SELECT distinct [MISTERCHEFNET].[dbo].[Lojas].[Nome Loja] as 'Loja' ,c.[Código Vendedor] as 'Código Entregador' ,a.[Nome Funcionário] as 'Entregador' ,c.[Data Caixa] ,c.[Data/Hora Vencimento] ,(c.[Tempo Total Entrega] - c.[Tempo Preparo]) as 'Tempo Entrega' ,c.[Tempo Preparo] ,c.[Tempo Total E...
Need help speeding up wordpress page, specifically these issues: - Add Expires headers - Make fewer HTTP requests - Use cookie-free domains - Reduce DNS lookups - Minimize redirects - Leverage browser caching - Remove query strings from static resources
...website's SQL query is not being able to handle this huge database and few SQL queries are being executed very slowly. The website is hosted in a very good dedicated VPS, so hosting server is fine for the huge database but the website's SQL query need to be modified so that it can load and perform faster. My VPS >> "MySQL Slow Query" log showing ...
Our website (WordPress and Gravity Forms) has an online offering system. Clients can ask online for a quote and our server mails the offer (in pdf) to the client. Our office uses MS Access and we want to make queries from MS Access (VBA) to the database made by Gravity Forms on our website (I think the small database is stored on our site and know it is a sql-database) . So I am looking who know...
I am looking to rename multiple choice answers client side (php file) that are showing as numbers. Example what I now have in my PHP file: 'sql_query' => "SELECT element_10,element_2,element_3,element_5,element_4,element_6,element_8,element_9 FROM ap_form", Here's what I need element_5 has 2 choices Choice 1 is showing up 1 I would like it to be MA Choice 2 is ...
we have a text file which is continuously fed with new data, we need a query which reads this text file updates a SQL table according to the columns in the text file without duplicates the file also has space and page breaks
my page should have a textbox control,button and label [login to view URL] i write any sql query it should go to the server and should check whether the given sql query is correct or not..and should show the message according to that.. Platform- vb.net,SQL
I have a CSV sheet w/ all the appointments made at different locations which have the client ID number. I would like to take the client ID from the appointment table and match it with the Client Table to find out their name, number and email and which location they booked at.
...an input textarea field in the form in the right sidebar (above the other fields) to fill the popup of a marker (see an example as demo on the home page of [login to view URL]). This is not a j-query job, but a pure js. You have to add a form element, like [login to view URL], and
my page is having controls like textbox,button and a label If i enter sql query in the textbox and click on button it should tell me whether the sql query/Syntax entered is correct or not platform: [login to view URL] sql server
...freelancer: 1. Identify and help troubleshoot the load time/bad query issue 2. Create a solid recommendation for what php to use, settings, etc. For proposal purposes, the site is [login to view URL] Most of the plugins are currently shut off, but I can't even get the theme page to load to switch to a default theme. Prior to the php changes
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
I need a web based display screen similar to a Departure screen at an airport. The web page needs to be PHP based and connect to a mysql database. I will provide the sql query that will pull all relevant data. The attached file is an example of the Departure screen that will be mimicked. The labels will be changed to reflect what I need it to actually
...information for reference and more understanding i am providing some site links. i like those landing page UI and it matches with my requirement. check ref site [login to view URL] [login to view URL] we prefer developers from USA. have any query most welcome please write back to me and let me know your cost and time estimation for this task
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 setup basic environment with guidelines to do the rest of the settings myself. --Setup Elas...Remaining indexes I will create myself. Advise on how to create synonyms to include in the mappings. --Write Query DSL and optimize search --Web Layout with EUI Framework (React UI Components) --Signup and payment processing page
I need someone to write a simple sql query to copy fields between tables
...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 with map based realtime classification 5. Options for advertisement inline and overlays 6. Any other missed page which you see
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
...microphone for speech to text conversion. 3). User will be redirected to a SERP(Search Engine Result Page) as is configured in the app's default search engine. 4). Apart from this the app will also have an internal update functionality where it'll query/ping an update URL to check for any app updates and update the app if any new version is available
...to help with a two page HTML5 license deactivation UI: Page 1: user will enter activation code and press Deactivate Button. Fire query to my-sql database to check if the activation code is valid. If code is invalid then display error message saying “Invalid Activation Code.” If the activation code is valid to go page 2. Page 2: Display verif...
Hi Hanad A., I noticed your profile and would like to see if you can assist me with my query and what sort of costs i would be looking at (I have just put the basic £10 to start a conversation with you, not trying to insult you). I have had an app created that I would like to overhaul/upgrade a little and was thinking a freelancer would suit me better
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
The scope of the project is to replicate a single query of a java application to a .Net application. The Java application authenticates as follows: 1. User login to a website (We will provide a username/password) 2. There is a link to login to the application,on this page there i the username/token information that is provided, a JNLP file is being
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.
hi there I am looking for a tool to ... the search results include a summary page when you click on each record there is more info on each record I'd like to scrape info from both summary and full details page and seperate into columns on a spreadsheet, Please let me know cost and timeframe of delivery and also if you have any other query
...the new order in Magento backend. Actual Result: a.) Magento Order was not created. Reason: SQLSTATE: Syntax error or access violation: 1103 Incorrect table name '', query was: INSERT INTO `` () VALUES () b.) Something failed in this place: public_html/vendor/magento/module-sales-sequence/Model/[login to view URL](85) Migrated
...found. Problem Page: [login to view URL] on this page you can see all images are using the default image, because programming looks for a valid image, and if not found then it uses a default image as you can see. This page shows you that the record has a VALID image, by searching my the MLNumber as you can see if the query string: http://homesofheights
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 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...
I getting a SQLSTATE error message in the backend of Magento 2 on the order page. SQLSTATE[42S22]: Column not found: 1054 Unknown column '[login to view URL]' in 'field list', query was: SELECT `main_table`.`status`, `main_table`.`color` FROM `sales_order_status` AS `main_table` WHERE (`status` = 'pending') And i getting also a error message if i whant