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...
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 do need a styled design for my family tree-genealogy. I want something fancy, feel like an "old" style, like the examples attached. The result-delivery file needs to be open, or in Adobe Illustrator, Photoshop or Gimp project, where I can add my family information and be able to print it, the width size should be 140cm. The concept needs to consider
I need someone to write a simple sql query to copy fields between tables
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
Hello, I have a simple project where I need you guys to make a simple downline page view based on sign in user. Which is mean Sign in user able to view their own downline tree. Currently I have made a page for admin view where admin can view all downline as in attached no 1photos. I tried to replicate the same method for user side but it not working
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
$$$ READ BEFORE BID OR REPORTED AS SPAM $$$ Hello, I need some one who got Speed Tree software, to deliver to me a few high quality low-poly game ready models. ONLY bid if you have the software or you can deliver the quality you see in the attached screenshot. Thanks
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.
I would need the basic code of a tree with checkbox selectors for a Cordova mobile app, working properly in both Android and iOS builds. (please see attached screenshot as an example). I do not need to code any action, as we will do it ourselves. It is only having the basic functionality of the tree selector, and a nice look and feel, working in a Cordova
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.
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...
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 require a simple family tree app that allows the user to create a family tree and add, update and remove family members. The family tree needs to be displayed graphically using a gui, preferably javafx. The family member being displayed on the tree only requires the persons name,but when clicked on will bring up their corresponding fields e.g (age
we need bubble tree drawing algorithm implementation in c++ with opencv library. it takes the input as in the form of vertices and edges and give the input of graph drawing.
MLM Project Please See the attachment file then only apply . This is a commision based system and there was a Binary & Unilevel tree concept. I need Complete Design with Front End 1. Front End Responsive Template For front End 2. Admin Panel 3. User Panel 4. Commission will be reflect to in his dashboard. 5. if you can create in wordpress
I need a good .NET mvc developer who can show a family tree from database. i have everything already coded but the problem is i used google charts but its not supporting full family tree i am looking for something like : [login to view URL]
I need you to build a landing page. budget 600 Rs
MLM Project This is a commision based system and there was a Binary & Unilevel tree concept. I need Complete Design with Front End 1. Front End Responsive Template For front End 2. Admin Panel 3. User Panel 4. Commission will be reflect to in his dashboard. Note : I have to complete with in 4 to 5 day , if any one who have already script
I need a good .NET mvc developer who can show a family tree from database. i have everything already coded but the problem is i used google charts but its not supporting full family tree i am looking for something like : [login to view URL] if any one have experience with d3.js they can do this easily.
I NEED A APP APP IN DIFFRENT PRIZE . EVERY DAY WIN A PRIZE. PRIZE IN WINNER GURANTED IN PUBLIC PRIZE TICKET PRIZE COST DIVIDED IN ADMIN OPTION APP REGISTRATION EVERY PERSON WITH GOOGLE EMAIL OR FACBOOK OR MOBILE NO IF ANY PERSON SHARE APP GET AND JOIN ANY PERSON PER PERSON 10 POINT WIN IF JOIN 10 PERSON GET 100 POINT MEAN RS 2 & USE IN NUMBER IN PRIZE TICKET ADD MONEY FEAUTRE ...
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.
I need a native Chinese to go to the China Tree Nut Conference and attend the conference and take lots of photographs and report about the event. You will be required to talk to attendees, and ask how they see their business now and in the future and take notes. You will also be required to represent our publication in a professional manner. The event
...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