I am getting the following error on a website. I create ticket for this reason in my hosting provider. It told me "You need to edit the select query, not a select query suitable for the mariadb version on the…
I have following SQL query: SELECT tbltasks.fldTaskNr ,tbltasks.fldRITMNr ,tbltasks.fldCHGNr ,tblci.fldCI ,tblgxp.fldGxP ,tblrequester.fldRequester ,tblstatus.fldStatus ,tbltasks.fldDescription ,tblresponsible.fldResponsible ,tbllocation.fldLocation FROM tbltasks LEFT JOIN tblCI ON tblci.pkCI = tbltasks.fkCI LEFT JOIN tblgxp ON tblgxp.pkGxP = tbltasks.fkGxP LEFT JOIN tblrequester ON tblrequester.pkRequester = tbltasks.fkRequester LEFT…
MySQL statement on a school system I have created some years back was working fine but now takes close to 30 seconds to pull what appears to me a simple statement but cannot figure out how to improve it. I…
How do I append a character to all items `purchase_id' here is a manual example of what I want... SELECT * FROM `loadable_link` WHERE `product_sku` = '2101-R' ORDER BY `customer_id` DESC Then select from purchased_id and append a '0' to…
I have a table/sql issue I don't know how to solve. I need to update/create a table of user ids with order ids. Therefore I have to get a new user_id, by searching for the email in an old list.…
I'm trying to create a mysql query that looks through my scoreboard for a given playerid and then finds their highest score and then adding a rank to that score. I've come quite close to what I'm trying to achieve…
I've tried to google A LOT, and searched in other stackoverflow similar post, but i can't really find something that's helping me -.- I'm trying to make my site refresh and update my tables values, and only show the ones…
I've started to code in April 2021 so I'm super new to this. Working on my final exam, I'd need your precious help! I want to generate a dynamic list from a database, containing 2 joined tables (users and interest).…
I need to get the userID and the marketplace, where the user first bought something. The db looks like this: userID, marketplace, dateOfOrder 74526, Amazon, 2/1/2021 74526, eBay, 1/1/2021 74526, Walmart, 12/10/2021 74525, Amazon, 14/5/2021 74525, eBay, 12/4/2021 74525, Walmart,…
I'm using this query to remove duplicates from phoenix_tasks table: CREATE TEMPORARY TABLE temp SELECT `piva` FROM phoenix_tasks GROUP BY `piva` HAVING COUNT(*) > 1; DELETE FROM phoenix_tasks WHERE `piva` IN (SELECT `piva` FROM temp) AND taskStateId=1 ; DROP TEMPORARY…