In Bearbeitung

SQL Task for Table Output in Wordpress Plugin

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.

Fähigkeiten: MySQL, PHP, SQL, WordPress, Datenbankverwaltung

Mehr darüber wordpress search plugin dropdown, wordpress plugin dropdown menu pages, free wordpress verticle dropdown menu plugin, wordpress css dropdown menu plugin, wordpress plugin dropdown menu vertical, simple table mysql data wordpress plugin, dropdown menu wordpress plugin, write wordpress plugin sql, football league results table wordpress plugin, wordpress plugin output table, wordpress plugin display sql table, ajax table filter wordpress plugin, create table in wordpress plugin, display database table in wordpress plugin, create database table in wordpress plugin, best table maker wordpress plugin, restaurant table booking wordpress plugin

Über den Arbeitgeber:
( 6 Bewertungen ) Ettlingen, Germany

Projekt-ID: #28461522

Vergeben an:

sanjay1450

Hi There, I checked and understood your requirement I can modify SQL Query as per your need. Thanks!!

€30 EUR in 1 Tag
(17 Bewertungen)
4.6