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 ('C9 H90W25','A3 FLT OP575','A1 J1314012HB','A9 OC196','A9 FI OP558','A8 358 664','B1 VAI30-1338','A3 VAC V30-1338','C9 W610/6','A2 F026407077','A5 30117','A1 W610/6','B1 MANW67','C4 W 67','A2 UFI 23.265.00','C4 W 6019','A1 OC 194','C4 H90W25','C4 OC 617','A1 10-04-410ASK','B7 OP 595/4/IP','C9 W6019','A1 J1314018HB','A8 914 081','A8 365 888','C9 ADC42103','A8 349 237','B1 PURLS350','B7 OP595/4/AG','A1 F129','A1 OC194','B1 HENH90W25','A5 23607','A8 914 082','A2 UFI 23.243.00','B7 OP557/AG','A1 WOF197','C9 W67','A9 OC1177','A5 208501','A1 J1313002HB','C4 W 610/6','A9 F026407077','E6 FL1199','A3 MHL OC194','A8 327 960','B1 FTROP557','A8 370 542','A8 916 172','A3 MNN W67','A3 MHL OC617','B1 MANW610/6','A2 W610/6','A1 F208','C4 H97W11','B7 OP 558/IP','A9 OC617','C9 FO-316S','A1 F026407077','A8 907 970','A1 WOF386','A1 F122','A2 FI OP558','B1 BLPADC42103','A8 358 654','A3 JAP FO-316S','C9 W610/2','A1 10-M0-001ASK','B7 OP 575/IP','A1 W610/2','C4 OC 196','A1 F123','A2 W6019','B1 HENH345W','A5 250135','C4 W 610/2','C4 O0539DREIS','A8 345 060','A1 W67','C9 ADM52105','A1 W814/80','A9 W610/2','C4 S 3485 R','A5 372329','B1 BLPADM52105','A2 W814/80','D1 BP ADM52105','B1 FTROP595/4','C9 W814/80','B1 HENH313W','A2 H90W25','B1 FTROP558','C4 F026407077','A1 J1314013HB','E6 FL1062','B1 FTROP575','A3 MNN W87','A1 W6019','A9 W87','A1 OC152','B1 MANW610/2','C4 W 87','A3 MNN W814/80','B7 H90W25','B1 MANW87','A1 F126','A2 OC1177','A1 10-0H-005ASK','C4 S 3479 R','A5 206439','A1 LS350PU','A3 JAP FO-498S','A9 W67','A1 OC617','A8 370 630','B1 BOSF026407077','A3 MHL OC196','A2 W87','C9 F026407200','A8 350 614','A5 162212','A1 OC1177','A1 J1315024HB','B1 HENH97W11','A3 MHL OC1177','A1 WOF131','B1 VAL586062','C9 LS350','A2 OC196','A1 WOF191','C4 H345W','C9 H97W11','C9 FO-410S','A2 FI OP575','C4 LS350PU','A3 BOS F026407077','A1 H90W25','A3 JAP FO-410S','A1 F110','A8 318 330','A8 318 364','A2 OC617','A2 W610/2','A1 J1313015HB','A8 920 430','C4 O0543DREIS','B7 H97W11','A3 FLT OP557','C9 F026407077','A2 W67','A8 300 081','A3 MNN W610/6','A2 FI OP557','A9 W610/6','A2 OC194','B7 H313W','A1 10-01-198ASK','A9 FI OP557','C4 OC 194','B1 BOSF026407200','A8 318 339','A1 10-04-498ASK','C4 H313W','A9 W6019','A9 FI OP575','A3 FLT OP558','B7 OP 557/IP','A3 FLT OP595/4','A8 920 015','A3 MNN W610/2','C9 W87','B1 MANW814/80','A9 UFI 23.265.00','A1 OC196','A9 UFI 23.243.00','A9 W814/80','A5 30172','C4 W 814/80','A1 F119','D1 BP ADC42103','A5 38819','A9 OC194','B7 OP575/AG','A8 365 906','B1 MANW6019','A1 W87','C9 FO-498S','A1 32100 FE','A1 J1317003HB','A2 J1313002','A2 J1314012','A2 J1314013','A2 SF OF0054','A3 JAP FO-313S','A3 JAP FO-502S','A3 JAP FO-599S','A5 30160','A5 30162','A5 30171','A5 30174','A8 920 092','A9 J1313002','A9 J1314012','A9 J1314013','A9 SF OF0054','B1 BLPADH22114','B1 BLPADM52107','B1 KAMF102001','B1 KAMF118901','B1 KNEOC1177','B1 KNEOC617','B1 VAL586060','B7 A210021/DKM','B7 HO-824/KAVO','B7 SM104','C4 J1313002','C4 J1314012','C4 J1314013','C4 S 3265 R','C9 31-143220006','C9 ADH22114','C9 ADM52107','C9 FE32100','C9 FO-313S','C9 FO-503S','C9 FO-599S','C9 OF-0410','D1 BP ADH22114','D1 BP ADM52107','E6 FL1045','E6 FL1151')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #