~~NOCACHE~~
====== HobbyKing Artikel Lister ======
====== Alle Produkte im tracking ======
SELECT i.id,i.name, h.stock, h.weight, h.cost, h.date from items i,itemshistory h WHERE h.id=i.id AND h.date=(SELECT MAX(hs.date) FROM itemshistory AS hs WHERE hs.id=i.id) group by h.id ORDER BY i.name, h.date desc;
====== Produkte nach Hersteller ======
===== Assan =====
SELECT i.id,i.name, h.stock, h.weight, h.cost, h.date from items i,itemshistory h WHERE i.vendor='Assan' AND h.id=i.id AND h.date=(SELECT MAX(hs.date) FROM itemshistory AS hs WHERE hs.id=i.id) group by h.id ORDER BY i.name, h.date desc;
===== OrangeRx =====
SELECT i.id,i.name, h.stock, h.weight, h.cost, h.date from items i,itemshistory h WHERE i.vendor='OrangeRx' AND h.id=i.id AND h.date=(SELECT MAX(hs.date) FROM itemshistory AS hs WHERE hs.id=i.id) group by h.id ORDER BY i.name, h.date desc;