Die beliebtesten Produkte im SPD-Shop:
 
SELECT svai.*, sum(quantity) as quantity,shop_item_has_category.category_line_no, shop_category.code FROM `shop_sales_line` INNER JOIN shop_view_active_item svai ON svai.company = shop_sales_line.company AND svai.shop_code = shop_sales_line.shop_code AND svai.language_code = shop_sales_line.language_code AND svai.item_no = shop_sales_line.item_no INNER JOIN shop_sales_header ON shop_sales_header.id = shop_sales_line.shop_sales_header_id AND shop_sales_header.order_date > DATE_SUB(curdate(),INTERVAL 3 MONTH) AND shop_sales_header.order_error = 0 INNER JOIN shop_item_has_category ON shop_item_has_category.item_no = shop_sales_line.item_no INNER JOIN shop_category ON shop_category.line_no = shop_item_has_category.category_line_no WHERE shop_sales_line.company = 'IMAGE Ident Marketing' AND shop_sales_line.shop_code = 'EINE-WELT' AND shop_sales_line.language_code = 'DEU' AND shop_sales_line.item_no <> 'A100566' AND svai.chili_item_only_logged_visible = 0 GROUP BY shop_sales_line.item_no ORDER BY quantity DESC LIMIT 12
Mappe für Ehrenurkunden (SPD Logo Silber)
Mappe für Ehrenurkunden (SPD-Logo Silber) für 25- und 40jährige Mitgliedschaft
Lieferbar innerhalb 2-3 Werktagen
Mappe für Ehrenurkunden (SPD Logo Gold)
Mappe für Ehrenurkunden (SPD-Logo Gold) ab 50jährige Mitgliedschaft
Lieferbar innerhalb 2-3 Werktagen
A100528
Ehrennadel 40 Jahre, Silber/Rot
Lieferbar innerhalb 2-3 Werktagen
A100523
Ehrennadel 50 Jahre, Gold
Lieferbar innerhalb 2-3 Werktagen
A100595
weißer Briefumschlag 1 Paket = 50 Stück
Lieferbar innerhalb 2-3 Werktagen