-
Privatkunde
- Geschäftskunde
Germany
Versand Germany
-
Terminbuchung
-
Hello Login Konto & Listen
-
Neues Konto? Erstellen Sie hier.
- Meine Listen
- Sonderpreise
- Einkaufslisten
- Mein Konto
- Persönliche Daten
- Bestellungen
- Adressen
- Zahlungsarten
-
-
SALE
Ordnen & Registrieren
Papiere & Blöcke
Schreiben & Korrigieren
Kleben & Versenden
Präsentation & Planung
Technik & Zubehör
Büroeinrichtung
Meist verkaufte Produkte
SELECT DISTINCT oi.supplier_id, oi.ord_id, pro.pro_description_short, (pbp.pbp_price_amount + (pbp.pbp_price_amount * pbp.pbp_tax)) AS pbp_price_amount, pbp.pbp_price_amount AS pbp_price_without_tax, pbp.pbp_tax, pg.pg_mime_source_url FROM order_items AS oi LEFT JOIN products AS pro ON pro.supplier_id = oi.supplier_id LEFT JOIN products_bundle_price AS pbp ON pbp.supplier_id = oi.supplier_id AND pbp.pbp_lower_bound = '1' LEFT JOIN products_gallery AS pg ON pg.supplier_id = oi.supplier_id AND pg.pg_mime_purpose = 'normal' AND pg.pg_mime_order = '1' JOIN (SELECT supplier_id FROM order_items GROUP BY supplier_id HAVING COUNT(*) >= 1 ORDER BY RAND() LIMIT 12) AS random_suppliers ON random_suppliers.supplier_id = oi.supplier_id WHERE pg.pg_mime_source_url IS NOT NULL AND pg.pg_mime_source_url <> '' GROUP BY oi.supplier_id
Schulranzen
Beliebte Produkte in Ordnen & Registrieren
Beliebte Produkte in Präsentation & Planung
Baumarkt
Neues Konto? Erstellen Sie hier.
Zurück zum Seitenanfang