0 SQLString: SELECT DISTINCT(pc.prod_id), (p.prod_stock + IFNULL(sum(s.st_qty), 0)) AS stock , p.prod_type, p.prod_kat, p.prod_katfull, p.prod_releasedate, p.prod_style, p.prod_pricesort, pi.pins_manu, p.prod_sc, p.prod_cc, ((CASE WHEN p.prod_stock > 0 THEN 15 ELSE 0 END) + (CASE WHEN p.prod_aff_sysnr > 0 THEN 5 ELSE 0 END) + (CASE WHEN p.prod_discontinued > 0 THEN 2 ELSE 0 END) + (CASE WHEN p.prod_ribbon <> "" THEN 5 ELSE 0 END) ) AS reverence FROM nq_prod_to_cat AS pc LEFT JOIN nq_prod AS p ON (p.prod_id = pc.prod_id) LEFT OUTER JOIN nq_prod_instr AS pi ON (p.prod_id = pi.prod_id) LEFT OUTER JOIN nq_prod_shm AS sh ON (p.prod_id = sh.prod_id) LEFT OUTER JOIN nq_prod_states AS s ON (p.prod_id = s.prod_id AND s.affiliate_id = 1000 AND store_id = 0) WHERE pc.category_id = info.php/info/p231689_KeyboardAbdeckhaubeT GROUP BY pc.prod_id ORDER BY reverence DESC in File "/var/www/nimq_shop_v2-8/private/classes/class.mysql.php" Zeile "135
Warenkorb ( 0 )
0,00 €
Versandkostenfreie
Lieferung ab 25,-€ (DE)
30 Tage
Money-Back
Sichere
Zahlung
Über 130 Jahre
Erfahrung
Telefonische
Einkaufshilfe
Es wurden keine Produkte gefunden. Bitte versuchen Sie es mit einem anderen Suchbegriff erneut.
