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 ('A9 H90W26','A5 50034','B1 KAMF100201','C9 H90W03','C9 LS891','B7 OP541/AG','A1 OC494','C9 206547595','A8 320 551','A1 WOF100','A5 266304','A9 W713/18','B1 PURLS370','A1 10-03-398ASK','A9 SF OF0961','A9 FI OP699','A2 W712/41','C4 H90W26','A1 LS206PU','C9 DO229','C9 W712/22(10)','A8 370 603','A1 WOF125','A8 370 616','A8 357 428','B7 A210028/DKM','C9 DO1833','C4 W 713/18','C4 W 712/75','C9 OF-935','A3 FLT OP570/1','A9 OC242','A2 FI OP570','C4 0451103232','A2 586010','A8 318 367','A5 30163','C9 H90W26','A9 UFI 23.299.00','C9 FO-398S','A1 OC90O.F.','A8 318 320','A8 365 926','A2 FI OP630','B1 KNEOC405/3','A3 FLT OP699','C9 50013917','B7 H14W08','B1 MANW713/18','A3 BOS 0451103204','A3 KAP DO-710','A1 W713/18','B1 FTROP570/1','A9 0451103232','A3 FLT OP570','A2 OC90OF','A9 FI OP541','A3 VAC V40-0079','C9 6140650004','C9 SP-1275','A2 OC405/3','A9 0451103079','C9 SP-943','C9 0451103079','A2 0451103370','A8 370 608','B7 1218500900/JP','C9 OF-900','B7 SM105','C4 OC 405/3','B1 VAL586058','A3 MHL OC494','C9 0451103297','A3 JAP FO-398S','A3 BOS 0451103232','A5 40952','A5 52519','B1 BOS0451103079','A9 FI OP570','C9 W712/22','B1 VAL586072','C9 W712/75','C9 0451103370','A2 SF OF0961','B7 H90W16','B1 VAI40-0079','A1 W712/75','A5 66034','C9 FO-098S','A1 0451103204','A2 W712/75','A9 SF OF0957','A1 W712/22','A8 313 806','B7 10098/JAPKO','A1 10-00-098ASK','A3 BOS 0451103370','C4 0451103079','A1 W712/22(10)','B1 BOS0451103297','A3 MNN W712/22','B1 FTROP541','A3 MNN W712/75','A2 0451103204','B1 FTROP570','B1 BOS0451103204','B7 W712/75/AG','B1 FTROP699','C4 OC 242','A9 OC90OF','C4 J1310900','A1 OC242','A3 MNN W712/41','A8 300 075','C4 W 712/41','B1 KNEOC242','B1 MANW712/75','B1 MISZ299','A1 OC 405/3','C4 W 712/22','A1 0451103079','A1 0451103232','A5 13134','C9 OF-891','C4 W 712/22 (10)','B1 CHACOF101102S','A1 WOF159','A3 MHL OC90','A2 SF OF0009','B7 OP630/AG','B1 FTROP630','A3 MNN W712/22(10)','A3 MHL OC242','B1 MANW712/41','C9 SP-935','C4 O0580DREIS','B1 VAI40-0089','B1 VAL586017','B7 OP570/1/AG','A2 UFI 23.299.00','A3 HEN H90W16','A1 W712/41','A3 MHL OC90OF','A8 338 887','A2 0451103232','A2 SF OF0957','B7 H90W26','A1 50013100/10','B1 HENH90W03','C4 0451103370','C9 0451103204','A5 66026','C4 H90W16','B7 OP570/AG','C9 W712/41','B7 OP 630/IP','C9 H90W16','A9 OC405/3','B7 A210002-S/DKM','A5 202455','A9 W712/75','B1 HENH90W26','A3 FLT OP630','B1 PURLS206','B7 OP 699/IP','A1 WOF148','B7 DO-705/KAVO','A3 JAP FO-098S','A5 121483','C9 H14W08','C9 50013100','B1 KAMF113401','A9 J1310900','A2 OC90','B7 H90W03','C4 H90W03','C4 OC 90','A3 BOS 0451103079','C4 N1310913','A8 330 722','B1 PURLS891','C9 0451103232','C4 S 3299 R','A3 FLT OP541','A9 SF OF0009','A9 OC90','A2 H90W03','B1 KAMF104301','C9 LS370','C9 DO237','C9 6143220009','A9 0451103297','A2 FI OP699','A8 319 338','B1 BOS0451103370','B1 KAMF106301','A2 OC242','A1 LS891PU','B7 A210623/DKM','A1 0451103370','C4 0451103297','A2 FI OP541','A1 OC405/3','A9 FI OP570/1','A3 MNN W713/18','C9 W713/18','B1 KNEOC90','A2 OC494','A8 342 926','A3 BOS 0451103297','C9 71760816','A1 LS370PU','B7 OP 570/1/IP','B1 KNEOC90OF','A1 OC90','B7 DO-710/KAVO','B7 OP 570/IP','B1 CHACOF101106S','A9 FI OP630','B7 10398/JAPKO','A2 W713/18','B1 BOS0451103232','B1 VAL586010','A2 H90W26','A3 MHL OC405/3','B7 A210075/DKM','C4 LS370PU','A2 0451103079','A9 0451103370','A5 40951','A2 0451103297','A8 312 837','A1 J1310900HB','B1 VAL586078','C4 S 7130 R','A1 0451103297','A1 G1069','A2 FI OP570/1','A5 337786','C4 LS891PU','B7 OP 541/IP','B7 A210002/DKM','A9 W712/41','A3 VAC V40-0089','C9 LS206','A2 J1310900','C9 71758775','A1 G106','A1 50013100','B1 CHAG102/610','B7 SM116','B1 HENH90W16')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #