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 ('B1 KNEOC244','A3 FLT OP629/2','A3 MNN W712/37','C4 0451103363','E2 300 058 756','C4 S 4500 R','A2 N1313032','A9 OC1051','D1 BP ADM52122','A9 F026407078','B1 FTROP629/1','B1 TRU01.42.110','A3 MNN W712/73','C9 6140650005','B1 FEB39747','A3 BER Z342','A8 365 184','B7 H315WK','C9 FE109139','C9 ADM52118','B7 A210005/DKM','A1 W712','A1 0451103309','A1 OC21','B1 PURLS934','A5 337788','C4 W 7008','B7 OP532/2/AG','A2 FI OP629/1','A1 C103','B1 KNEOC21','A9 FI OP629/2','B1 PURLS285','A9 OC21','B7 1518503409/JP','A9 SF OF0078','A3 VAC V25-0103','A1 C182','A1 F026407203','A2 F026407225','B1 FEB38813','A1 38813 FE','A8 353 103','B7 OP597/1/AG','A9 SF OF0138','A9 UFI 23.267.00','B1 BLPADM52111','C9 LS285','B7 A210414/DKM','C9 302134595','A5 169850','A2 OC21OF','A5 110506','C9 71758791','C9 ADM52111','C9 W714/3','C9 FO-L09S','B1 FEB37422','A8 319 128','B1 VAI25-0145','B1 VAI10-0316','B1 CHACCH9901','B1 KNEOC466','B7 OP629/2/AG','A3 VAC V25-0101','A2 N1313034','A9 FI OP532/2','D1 BP ADM52117','B1 MANW7008','B7 OP 629/2/IP','A5 361686','A2 FI OP532/2','C9 300058756','A3 MNN W712','A1 OC466','B1 PURLS357','C9 LS357','A2 OC1051','B1 VAL586083','E6 FL1209','C9 H90W22','C9 LS188B','A1 F026407078','A3 VAC V40-0080','A1 LS908PU','A2 H90W01','A1 OC1063','B1 CHACOF102103S','C9 LS908','A1 OC21O.F.','A8 921 296','C9 OF-1067','C9 FO-322S','C4 H90W01','B1 VAL586145','B1 BOSF026407078','B7 A210034/DKM','B7 H90W01','A8 365 910','C9 LS702','C9 71758709','C4 N1313034','B7 10L09/JAPKO','A1 OC244','A2 0986452068','C4 H90W27','B1 MANW712','D1 BP ADM52118','C9 OF-1072','C9 LS934','B7 10394/JAPKO','A3 MHL OC1051','A1 OC606','A9 W7008','B1 FTROP597/1','C4 W 712','B1 KAMF119001','A3 FLT OP532/2','A9 UFI 23.103.00','A9 W712','B1 VAI25-0101','A8 359 156','C9 H90W01','A5 288070','A9 FI OP597/1','B1 KAMF113001','C9 71761637','C9 ADM52122','C4 W 7008 SD','C9 50013919','C9 7143220010','B7 SM196','B1 BLPADM52118','A2 586023','C4 F026407225','A9 N1313034','A3 BOS F026407203','A9 OC606','A9 UFI 23.413.00','B7 A210172/DKM','A9 SF OF0126','C9 SP-945','C9 F026407225','B1 FEB39760','B1 KNEOC1051','C9 LS205','A8 374 862','A2 OC21','A5 44776','B1 BLPADM52117','A9 0451103363','A1 LS934PU','A8 302 051','C4 01.42.110','B1 VAI25-0103','B7 A210738/DKM','A9 N1313032','B1 FEB39759','C4 W 712/73','A1 WOF209','C9 01.42.110','B1 PURLS188B','A1 W712/73','C4 H319W','A1 0451103363','C9 SP-828','B7 OP 551/IP','C9 W7008','A2 UFI 23.103.00','B1 BOSF026407225','B1 MANW712/73','C4 LS188BPU','A1 10-0L-L09ASK','A9 FI OP551','B1 FTROP629/2','A8 332 595','C9 SP-1296','C9 DO261','B1 KAMF114501','A2 SF OF0126','C4 LS908PU','B1 FEB39746','B7 OP629/1/AG','C9 300029756','B7 SM110','C4 OC 466','A5 206430','B7 OP 532/2/IP','B7 1518503709/JP','A9 OC1063','A9 OC21OF','B7 SM109','A3 FLT OP551','A8 370 544','B7 W7015/AG','A1 LS357PU','A1 C20480102000/GRX','D1 BP ADM52111','A8 393 166','B1 PURLS908','A5 341962','C4 LS702PU','A9 W7015','B7 10322/JAPKO','B1 KNEOC606','A2 F026407078','C4 F026407078','A8 333 082','A9 F026407203','C4 LS205PU','A3 BOS F026407078','B7 H315W','A8 365 937','A2 SF OF0105','A3 JAP FO-322S','C4 J1313021','A2 UFI 23.267.00','B7 A210410/DKM','A1 WOF112','A3 VAC V25-0145','C4 LS934PU','A1 LS702PU','A5 288082','A8 348 232','C4 OC 1063','C4 O0550DREIS','B1 FEB109139','B1 HENH90W33','B1 VAL585657','C4 H315W','A5 189440','C4 F026407203','C4 LS357PU','C4 OC 606','A5 373222','A1 W714/3','A2 OC606','E6 FL1203','B1 HENH90W27','A2 OC1063','A2 W712','B1 BLPADM52122','C9 SP-892','C9 SP-1073','B7 OP 629/1/IP','B7 A210074/DKM','A3 FLT OP597/1','C9 SP-1423','C4 OC 21','B1 VAL586068','C9 7143220017','B1 BOS0451103363','C9 F026407078','A9 F026407225','B7 OP 597/1/IP','A1 0002635904','A8 389 804','A2 586039','A1 OC1051','C9 7143220014','A8 918 263','A2 FI OP597/1','A8 372 532','A9 W712/73','A2 OC466','C9 W712/73','A9 W714/3','A1 WOF147','B1 MANW714/3','A3 MHL OC606','A3 MNN W7008','A2 W714/3','C4 V40-0080','B1 PURLS205','A8 371 115','B7 H90W22','A3 FLT OP629/1','B1 MANW7015','A2 W712/73','C4 LS285PU','A3 VAC V10-0316','A1 C204','B1 FTROP551','A2 J1313021','A9 J1313021','B1 VAL586019','C9 BERZ342','C9 0451103363','A2 W7008','C4 W 714/3','B1 HENH90W01','C4 N1313032','C4 OC 1051','C4 39746F','A3 BOS 0451103363','C9 ADM52117','C9 W7015','B1 HENH319W','C4 S 9431 R','B1 VAL586023','C9 H90W06','A8 370 601','B7 OP551/AG','A8 378 012','B1 PURLS702','A1 W7008','A2 0451103363','A3 TRU 01.42.110','B7 H90W27','C9 H90W27','A8 325 297','C4 MO-540','A9 FI OP629/1','A2 W7015','A8 312 833','A1 W7015','A1 LS188BPU','B1 CHACOF100182S','A1 LS285PU','C9 DO942','A5 174792','C9 SP-1457','A3 MHL OC21','B1 KNEOC21OF','A8 353 104','B1 VAI40-0080','B1 VAL586039','B7 MO-540/KAVO','B1 HENH315W','A1 WOF259','B1 FEB37425','A2 SF OF0138','A8 328 205','C9 W712','C4 39760F','A1 0986452068','A2 UFI 23.413.00','A5 174740','A2 FI OP629/2','C4 W 7015','B1 BOSF026407203','B1 FTROP532/2','A2 FI OP551','A2 SF OF0078','C9 DO215','A3 JAP FO-L09S','B1 KNEOC1063','B7 H90W33','E6 FL1210','A1 LS205PU','C4 H90W33','A3 MNN W714/3','A1 WOF123','A5 202450','A8 318 325','C4 O0549DREIS','C9 FE38813','C9 F026407203','C4 S 3413 R','A2 F026407203','A1 W712/37','A3 MHL OC1063','A1 W68/3','A2 W68/3','A3 JAP FO-279S','A3 JAP FO-394S','A5 202449','A5 246884','A5 43729','A8 300 023','A9 W68/3','B1 MANW68/3','B7 A210006/DKM','B7 MO-534/KAVO','B7 TO-138/KAVO','C4 O0547DREIS','C4 W 68/3','C9 FO-279S','C9 FO-394S','C9 W68/3')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #