I am currently selecting a number of rows, joining another table but can have duplicate entries. I want to remove the duplicates (which I have done), but I want to...work because it needs to order by from the JOIN table. Maybe I need a subquery, but I'm not familiar with those. It's a 2 minute job for people with someone with adequate MySQL skills.
Hi, I have a query which is running very slow, especially when more user_ids (e.g. 10 ids) are added to the IN statement. I am looking for a DB expert to help me optimise this query so that it runs as fast as possible. Here is the query: [url removed, login to view] Thanks!
Hi, Having had 2 different apps developed(android and iOS for both projects) I now need the source code to be uploaded onto my server for the databases (admin and super admin panel for both projects) and i need both apps uploaded to google play for android and the app store for iOS. And need everything linked so that it works and can be further tested
I need a question to be solved with Power BI Direct Query. You need to have experience with Power BI and Direct Query to be able to solve this question. I need a solution in Power BI and cannot accept solutions that involve significantly changing the data set.
Medical website utilize there different databases. We have wholesale clients, retail clients and drug database information area that is the core of the design. I need a creative person to assist in the the design idea and creative process beside the development
We need a query to generate the quantity sold and the price for each product in prestashop for each year. I can provide a database dump. We need to be able to export in excel/csv like the below example, I should be able to change the year in the query, for example to generate results for 2015, 2016 and 2017 separately. Product | Quantity Sold
I need you to write a final project report for my arduino based project , i had already done the hardware and software. I can give you the details of the hardware , circuit diagram and software code using this details help me to write a 50 page final project report with less than 30% plagiarism. I will provide a template to follow.
I have a MySQL server that is hosted in my home network. I have admin access to the Window 10 O/S as well as the MySql server. However, am unable to access this from outside my home using the public IP. I am posting this for the 2nd time as the previous freelancer had confirmed that port 3306 is not opened by my ISP. I wanted someone to validate
...management company of 4 departments (one employee per each department) + admin. We have our OneDrive system and use linked Excel files at the moment. We need an instant online remote access to preview, edit and save files. Kind of support: Network Description of support work: We are a small growing building and project management company of 4 departments
Hello Friends, I have developed a form to insert the values from Google maps using j query with single color for each record and successfully saving in the back end. Now I am unable to retrieve the inserted data with color I have saved and update the map / existing record. I will provide you the tables and queries related to that form. You
Teach me how to assign unique public IP to virtual server for remote access 1. Single chip computer that has a MiFi router 2. I want to remotely access this computer over the 3G/4G network by accessing an iP address of that single chip computer. i.e., like visiting a webserver 3. Will probably need port forwarding and setting up static public ip
I have a query that it should finish in about 30 minutes but instead it just keeps running on end, it fills the filesystem and then die I need someone that knows SQL very well, has experience with columnar database and how they work (example no indexes etc) and that it can properly read and understand query plans I will provide the query and more
I need to develop an app for the remote management of some relays. To make an example: By app on the cellphone I want to turn on the heating or lights on a boat, and I want to read the engine temperature or if the door is open. the HW is almost ready I only need the APP and some advice on any server An electronic card is mounted on a boat, this board
Somos Phonitek, una compañía dedicada a la comercialización de teléfonos móviles vía Internet ([url removed, login to view]). Estamos buscando un técnico de asistencia remota para nuestros clientes, una persona con la calificación necesaria para resolver los problemas que puedan surgirle al cliente promedio y que no requieran una reparaci&...
We're looking for someone with a great eye for high-production-value, visually interesting footage and the ability to scour for creative ...collect. This test assignment needs to be completed ASAP. Please be prepared. If selected, the next stage would be a bigger contract project. And after that, similar ongoing remote freelance/contract work.
Looking for a developer to add some features to any existing good RAT for Windows. I need an admin panel accessible in browser from where I can give commands to be done by RAT on clients browsers. I'll give full details to who is interested in this project.
Need server person to configure windows 2008 vps server via Skype remote access now. Running slowly with no files or data.