I have a large set of car data that I output on my website - Here is an example page:
[login to view URL]
There are many cars in my SQL database and the table plugin pulls certain columns with this query:
SELECT Baureihe AS Modell, Motorisierung AS Motor, Motorart AS Kraftstoff, PS AS "Leistung in PS", Hubraum AS Hubraum, HSN AS "Schlüsselnummer HSN", TSN AS "Schlüsselnummer TSN", Getriebeart AS Getriebe, Steuer AS "KfZ Steuer pro Jahr*", Modellrange AS Baujahr, CO2WLT AS 'CO2 Ausstoß nach WLTP', CO2NEF AS 'CO2 Ausstoß nach NEFZ', Modellende AS Modellende, Modellstart AS Modellstart
FROM carwiki_OPEL
WHERE Baureihe='Crossland X'
ORDER BY Steuer
The problem is, that every car has a date range in the column named: "Modellrange".
So there are many cars that are completely identical but they only differ in the "Modellrange" where one car has only the year "2019" but the other car has "2018, 2019". This is why both cars are shown (as you can see in the screenshot).
I want to modify the SQL query that works with the $wpdb->get_results() function (as you see above) - so that no more duplicates are shown.
So I just need a simple piece of code to modify the query you see above.
I guess it is a quick fix, that's why I'm willing to pay 15 Euros. Please only message me if you understand SQL and get the task. Feel free to look at the web page to see the table and the dropdown.