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 keep the one with the latest time (bidTime) and using MAX(bidTime) doesn't work. Using ORDER BY doesn't work because it needs to order by from the JOIN table. Maybe I need a subquery, but I'm not familiar with those. I...
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!
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.
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
...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 just need to retrieve the saved data with different colors for
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 a WordPress query written to pull repeater entries that have a specific option selected from a custom post type. I have the custom post type and all of the fields created, including a select field that I need the entries to be queried by - just having some trouble with the code to display the correct results.
Im needing a query added to my wordpress site ([url removed, login to view]) that basically runs like this: The customer types in their car license / rego number and hits search. The website then needs find the cars details on carjam.co.nz. It then needs to find the matching vehicle on my database, and copy some details and put them into a graphic which it displays
Small project,, need help with write script query data from mysql then turn it into feed or API
I have a .js file that controls several intranet pages for my organization. I am trying to get 1-3 snippets added to this file. I'll definitely share the .js file that I have once hired. To start off, I'll need a snippet that does the following: - Creates a keyboard shortcut to go back to homepage. For example: if I press ALT+H on my keyboard, it should take me back to my intranet ho...
Hello, I'm using wordpress with an email newsletter plugin name "Mailster", bought on Canyon. I set up a cron job to send email each minute, everything is OK until NOW: Each time the cron run, it eat 100% CPU of my VPS for about 60 seconds, that makes the web so slow. I contact the plugin editor but they seem busy, so I decide to find someone who can fix this. Thank ...
...have their current php code modified with a MYSQL query. Project Details. The client has a static page that uses a query to select * from a specific table. The client recently updated their database and now they have 5 tables, all of them have identical structures with different data in each one. The client wants to create a query that will find which