Advand | Autóalkatrész webáruház és autóápolás

#SELECT cikk_raktar.cikkszam, cikk_tecdoc.gyarto, cikk_tecdoc.keresoAZ, cikk_tecdoc.DLNr FROM cikk_tecdoc LEFT JOIN cikk_raktar on (cikk_raktar.eredeti=cikk_tecdoc.cikkszam) WHERE ((cikk_tecdoc.cikkszam IN ('A1 KL9','C9 FE21598','C4 H82WK02','B7 PP 836/IP','B1 KNEKL65','C9 WK43/12(10)','B1 MANWK830/7','B7 ST314','A5 80445','A1 EP90CPU','B7 H80WK07','A2 UFI 31.500.00','A1 21756 FE','C9 H80WK07','A5 50031','C9 EP58','B1 BOS0450905095','A3 MHL KL65','A1 0450905275','C9 WK830/7','A3 BOS 0450905095','B1 HENH82WK02','C4 WK 830/7','B1 BOS0450905201','C9 0450905030','A8 367 149','A3 MNN WK830/7','A1 WK43/12(10)','A1 KL63','A8 930 379','A5 218883','B7 H80WK01','C9 FE30755','A1 12648 FE','B1 FEB12648','A2 UFI 31.583.00','A9 WK831','B1 MANWK831','C4 S 1710 B','B1 PUREP218','B1 FEB30755','C4 0450905030','B1 PUREP58','B1 MANWK830','A2 0S 1500 B','C9 EP189','B1 FTRPP836','A1 30-01-192ASK','C4 0450905201','A2 0450905002','A1 0450905095','C4 0450904058','A2 0450905095','A2 0450905275','A1 21598 FE','C9 EP191','A3 MNN WK831','A1 WK78/3','B1 BOS0450905030','C9 FE21596','A3 MHL KL9','A1 21596 FE','A2 WK831','C9 WK830','A1 0450905030','A3 MNN WK43/12(10)','A8 314 171','A1 WFF881','A1 WK830/7','C4 S 1583 B','B1 HENH80WK01','A2 J1334004','A5 19957','A1 EP189PU','B1 FEB21756','C4 F0548DREIS','A9 0450904058','C9 FE24073','A3 BOS 0450905002','A2 0450905030','B1 KNEKL2','A2 0450905201','B1 BOS0450905264','C9 WK831','B1 FTRPP874','A1 WFF144','A1 WFF544','A3 BOS 0450905201','C9 H80WK01','A2 KL65','B1 KNEKL158','A2 H82WK02','B7 H321WK','A3 MHL KL63','A9 KL65','B1 BOS0450905275','B1 HENH80WK07','C9 FC-192S','C9 0450905201','C4 S 1500 B','A3 FLT PP836','B1 PUREP189','B1 KNEKL63OF','A2 UFI 31.502.00','B1 KNEKL29','C4 450905030','C9 MBNA957','A1 J1331021HB','D1 BP ADN12317','A1 EP58PU','A1 0450904058','C9 EP218','A1 WFF432','A2 0450904058','B1 FEB21596','C9 ADN12317','A3 BOS 0450904058','C9 H82WK02','B1 BOS0450904058','C4 0450905095','C4 24073F','A1 EP191PU','A8 370 597','A1 KL65','A9 UFI 31.500.00','A8 313 489','A1 30755 FE','C9 WK78/3','A1 WK830','A9 UFI 31.583.00','A8 315 280','C4 450904058','A8 315 279','B1 BOS0450905002','C4 WK 831','A8 313 673','A3 JAP FC-192S','B1 BLPADN12317','A2 H80WK07','C4 KL 9','A3 FLT PP874','A1 0450905206','A2 KL63','C4 0450905275','C4 H80WK01','C9 0450905275','C4 KL 65','A9 UFI 31.502.00','C4 J1331021','C4 450905002','C4 H80WK07','A1 0450905264','A9 KL9','C9 EP90C','B1 PUREP90C','A5 274549','C4 450905201','C9 0450905095','C9 0450905264','C9 H321WK','C9 0450905002','B1 KNEKL9','A8 367 146','A1 24073 FE','A3 MNN WK830','A1 WFF844','A9 0450905275','B7 PP836/AG','C4 0450905002','A9 0450905030','A9 FI PP836','A9 0450905002','A3 BOS 0450905264','C4 EP189PU','B1 FEB24073','C4 0450905264','A5 27481','A8 302 336','A2 WK830/7','C9 FE12648','C4 WK 830','A3 BOS 0450905275','C4 EP90CPU','A2 KL9','A1 WFF111','A1 KL 65','A9 J1331021','C9 SP-2003','A2 FI PP836','B1 FEB21598','A2 0450905264','A1 0450905002','A9 WK830','A9 WK830/7','A8 905 807','A1 0450905201','A8 314 167','A2 J1331021','A1 WK43/12','A1 WFF304','A2 WK830','A9 0450905264','A1 WK831','C9 0450904058','A5 49936','B7 H82WK02','A3 BOS 0450905030','A8 318 283','C4 12648F','A1 KL2','A2 KL2','A2 SF PF7009','A3 MHL KL2','A5 23634','A9 KL2','A9 SF PF7009','B1 CHACFF100206','B1 KAMF301201','B1 VAI10-0336','C4 08.14.003','C4 KL 2','C6 011100','C9 0143230007','C9 PF-2003')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #