Überarbeitet State Struktur.

[Sebastian Fischer]

Hallo Vinzenz,

habe mal anhand Deines Artikels den SQL-State überarbeitet. Hier ist das bisherige immer noch nicht komplett richtige State. Wieder hakt es am aktuellen Preis. Dafür sind die Joins jetzt hoffendlich besser gewählt.

SELECT
      tx_sfpricetracker_lists.owner,
   tx_sfpricetracker_products.producer,
   tx_sfpricetracker_products.name,
   tx_sfpricetracker_products.description,
   tx_sfpricetracker_products.link,
   tx_sfpricetracker_products.amount,
   MIN(tx_sfpricetracker_prices.price) AS lowestprice,
   tx_sfpricetracker_prices.price AS currentprice

FROM

tx_sfpricetracker_products
INNER JOIN (tx_sfpricetracker_products_prices_mm
INNER JOIN tx_sfpricetracker_prices ON tx_sfpricetracker_products_prices_mm.uid_foreign = tx_sfpricetracker_prices.uid
) ON tx_sfpricetracker_products.uid = tx_sfpricetracker_products_prices_mm.uid_local
INNER JOIN (tx_sfpricetracker_lists_products_mm
INNER JOIN tx_sfpricetracker_lists ON tx_sfpricetracker_lists_products_mm.uid_local = tx_sfpricetracker_lists.uid
) ON tx_sfpricetracker_products.uid = tx_sfpricetracker_lists_products_mm.uid_foreign

WHERE

tx_sfpricetracker_products.uid = 2
AND tx_sfpricetracker_lists.owner = 1

GROUP BY tx_sfpricetracker_products.uid