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 ('C4 F026407077','A5 30172','A2 UFI 23.265.00','A3 MHL OC196','A9 W87','A9 W610/6','A1 10-04-410ASK','A3 MHL OC194','B7 OP575/AG','A5 206439','E6 FL1062','A8 916 172','B1 HENH313W','A1 F026407077','A2 W87','A8 318 330','A1 F208','A3 VAC V30-1338','A3 FLT OP558','A8 907 970','A1 10-01-198ASK','C9 W610/6','C4 OC 196','C4 H313W','B7 OP 575/IP','C9 F026407077','A9 F026407077','A2 OC617','C9 H90W25','A1 OC194','A8 358 654','B7 H90W25','A2 W6019','B1 BLPADM52105','A2 W610/2','B1 HENH90W25','A3 MNN W610/2','C4 W 610/2','A3 FLT OP575','A9 W814/80','A1 J1313002HB','B1 BOSF026407200','B1 HENH345W','B1 FTROP595/4','A1 J1314013HB','A9 OC617','B1 BOSF026407077','C4 OC 617','A3 MNN W67','B7 OP595/4/AG','A9 FI OP575','B1 MANW6019','A9 OC1177','B1 HENH97W11','A1 F129','B1 MANW610/2','A1 10-M0-001ASK','A5 38819','C9 W6019','C4 S 3485 R','A5 30117','A1 WOF197','A1 WOF131','A3 MNN W87','A1 W610/6','A8 920 015','A1 W814/80','C9 FO-316S','C9 FO-410S','A8 920 430','A8 300 081','C4 W 6019','A8 370 630','A3 FLT OP595/4','C4 W 67','C9 LS350','D1 BP ADM52105','B1 VAL586062','B7 OP557/AG','C4 H90W25','A2 FI OP575','B1 MANW814/80','A2 OC1177','A8 349 237','B1 FTROP557','A1 J1313015HB','C9 FO-498S','A1 10-04-498ASK','A1 F123','B7 H313W','C9 W610/2','A5 162212','A8 318 339','A5 23607','A1 OC 194','A2 FI OP557','C4 W 814/80','C9 W87','A1 F122','A1 F110','A5 372329','A8 365 906','A2 F026407077','A2 UFI 23.243.00','A1 LS350PU','C9 F026407200','A8 327 960','A1 OC617','B1 MANW610/6','C4 H97W11','E6 FL1199','A9 W67','A1 J1314018HB','A9 W6019','A1 OC196','A3 FLT OP557','A3 MNN W610/6','A9 UFI 23.265.00','A8 365 888','C4 O0539DREIS','C9 W814/80','A2 OC194','A1 H90W25','C4 W 610/6','A1 WOF386','A1 W67','C4 LS350PU','A9 UFI 23.243.00','C4 W 87','B7 OP 595/4/IP','A9 FI OP558','A1 J1314012HB','B7 H97W11','A3 BOS F026407077','A3 JAP FO-498S','A3 MHL OC617','A2 W610/6','A3 JAP FO-316S','B1 VAI30-1338','A1 W87','A2 W814/80','C9 W67','A2 W67','A5 208501','A8 350 614','A3 JAP FO-410S','A5 250135','A3 MNN W814/80','A1 W610/2','C4 O0543DREIS','D1 BP ADC42103','A1 W6019','B1 PURLS350','A8 345 060','A1 F119','B1 MANW67','A9 OC194','C9 ADC42103','A8 914 081','C4 H345W','A2 H90W25','A1 OC152','A1 OC1177','C4 S 3479 R','A2 FI OP558','A1 10-0H-005ASK','C4 OC 194','A1 WOF191','A8 914 082','A8 318 364','B1 MANW87','B7 OP 558/IP','B1 BLPADC42103','A2 OC196','A1 F126','A8 358 664','A9 W610/2','B7 OP 557/IP','B1 FTROP575','A9 FI OP557','A1 J1315024HB','A3 MHL OC1177','A9 OC196','A8 370 542','C9 H97W11','B1 FTROP558','C9 ADM52105','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)) #