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 u...
...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...
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
We would like to test several PopUps that motivate Software Users to convert. The PopUps have to be in perfect Portuguese and with welcoming/positive messages and design. Corporate Identity is set and can be delivered. The main job is to find the right wording and a positive design. We will need several PopUps that are building up on each other (PopUp 1, PopUp 2, PopUp 3 for example) and different...
We would like to test several PopUps that motivate Software Users to convert. The PopUps have to be in perfect Italian and with welcoming/positive messages and design. Corporate Identity is set and can be delivered. The main job is to find the right wording and a positive design. We will need several PopUps that are building up on each other (PopUp 1, PopUp 2, PopUp 3 for example) and different pr...
We are wanting to create a audio track for our company phone line. When a customer calls in and is put on hold, they will listen to this audio piece. We want a kiwi to do a voice over and then we will add audio to it. Similar to these examples: [login to view URL]
I've posted the HTML on a website, need to just use ssh to modify the [login to view URL] file on a linux box. It's basically just centering an image, the title, fixing the width of text below the image to be the same width as the image and centering, but not centering the text in the boxes, they should still be left-aligned. See attached image.
You need a new website. You need me to design and build it.
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 rig...
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.
Yahoo has a message board for each stock ticker. for example here for Apple Inc. AAPL. [login to view URL] Once logged in with Yahoo one can post a message in the comment box. I need a script to be able to post a message for stock ticker XYZ using some yahoo credentials/account. Script needs to be able to run from commandline
I need a professional resume Writer. if any One please call me or drop me a message on my no. [Removed by Freelancer.com Admin - please see Section 13 of our Terms and Conditions]
See pictures for some points I would like to realise. My website is sarmking.com. I would like to have all these points done, if you are able to do so please send me a chat message! Thank you!
Hi We are looking for developers who have an extensive experience working with Node.js with async operations, integrating npm modules, Message Queues & experience with running child processes Familiarity with Puppeteer & [login to view URL] would be good. Task are as follows: 1. Fetching list of urls from Firebase
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...
when i am sending cloud message from firebase, ios device are not getting the notifications
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...
Mac expert needed. Fix the layout of my messages app on my Mac. I am using Chrome on OS High Sierra. The messages app only shows person's face and phone. I want it to show more. It used to show more but now it does not. See attached. Need to make left side column wider. Login remotely with team viewer.
...allow me to load up multiple telegram accounts, and scrape a specific telegram group users. Then would send them an invite to a specific channel of my request or send them a message. The bot will need to be able to export the scraped users and keep a log of people added or who has been messaged. If you have already created something like this, please
I need a 3D model of something.
Independent competent coder wanted. No web companies and "teams" Message for lots of tasks. You must have good English and work live and quick. I want to see changes as they are happening. No time wasters. I pay an hourly rate of $10 per hour.
I need you to build a landing page. budget 600 Rs
I require an webbased application 1. from where I can send whatsapp message to all mobile numbers saved in our database or excel file. 2. tell me all the requirement and information in advance in bid itself, either third party information , cost or any issue we can face later.
The implementation should run on Google App Engine python standard environment (python 2.7) Input: 1. A photo (either still image or GIF animation can be accepted) 2. Text1 3. Text2 Output: 1. A new photo with Text1 and Text2 on the bottom. Text1 is on the first line and center-aligned; Text2 on the second line and right-aligned (Please see sample images as attached) 2. If the input photo is GIF...