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 MANW75/3','C9 ADN12121','B1 HENH20W13','A2 0451103235','C9 OF-727','A3 JAP FO-891S','A2 SF OF0961','E2 207 580 756','A2 OC471','A8 307 641','A1 F105','C9 FE32398','A1 OC727','A1 0451103233','B7 W79/AG','B7 SM142','C4 LS280APU','C4 0451103111','A9 F026407022','A9 J1315020','A1 W712/47','A8 318 884','B1 BOS0451103336','A1 WOF180','C9 LS309','A2 W712/47','B1 KNEOC727','C4 0451103336','D2 7700274177','A5 51852','C4 H221W','C9 LS571','D2 8200768913','C4 0451103299','A9 OC467','A2 OC223','B1 MISZ194','B1 VAI42-0053','A9 OC223','A2 UFI 23.177.00','A1 F120','A1 10-05-595ASK','A1 10-01-122ASK','A8 315 290','C9 FO-595S','D2 86001543357','C9 LS932','C4 F026407022','C9 0451103293','B1 MANW712/47','A1 10-09-990ASK','C9 ADN12139','C4 N1311044','D2 8200768927','A1 LS280APU','C9 SP-1321','B1 CHACOF103105S','B1 BOS0451103111','A9 FI OP643/3','A9 UFI 23.481.00','B1 VAI46-0084','A1 OC309','E2 207 027 756','B1 KNEOC3','A1 WOF272','A8 378 804','A3 VAC V46-0083','A2 UFI 23.194.00','B7 OP 643/3/IP','B1 HENH221W','C9 0451103336','B1 KAMF100301','B1 VAL586003','A1 LS218PU','C9 W79','C4 27155F','B7 W75/3/AG','A8 365 769','B1 BLPADC42115','B1 BOS0451103299','C4 OC 471','B1 PURLS932','A2 W75/3','B7 10990/JAPKO','B1 BLPADN12138','C9 0451103235','A1 WOF462','C9 H221W','C9 DO905','C9 SP-1039','D1 BP ADN12138','A1 0451103336','C9 LS280A','A3 FLT OP643/4','B1 PURLS576','A3 MNN W712/47','C9 W75/3','A9 UFI 23.194.00','C4 O0640DREIS','C4 O0636DREIS','C4 LS933PU','C9 SP-955','A5 202468','A1 OC3','A9 SF OF0961','A1 27155 FE','B7 OP 643/4/IP','D1 BP ADN12121','A1 LS223PU','A1 LS576PU','A5 80590','A8 392 939','B1 FTROP643/3','A9 SF OF0012','A1 0451103111','A5 80557','A3 JAP FO-990S','A1 W79','A2 F026407022','A8 314 351','C9 0451103111','D1 BP ADN12139','C4 W 79','A9 0451103336','A3 BOS 0451103235','B7 SM142/1','C9 SP-946','A1 WOF1905','A5 80527','B1 HENH11W02','A9 0451103299','B1 BLPADL142115','A1 OC471','A2 UFI 23.195.00','B7 H20W13','A3 BOS 0451103111','B1 KNEOC223','A3 BOS 0451103336','A9 UFI 23.195.00','A3 BOS F026407022','B1 MANW79','A3 MHL OC3','C9 50013504','B1 BOS0451103235','A1 H221W','A1 LS932PU','B7 OP643/3/AG','A5 86220','A3 KAP MO-441','C4 OC 223','A3 VAC V46-0084','C9 16-143220005','C4 J1315020','C9 FE27155','C9 SP-956','B1 PURLS280A','B7 10595/JAPKO','A2 FI OP643/3','A8 340 115','B1 PURLS571','B1 BLPADN12137','B7 H11W02','A8 312 858','A9 W79','B1 FEB27155','A3 MHL OC467','C9 W712/47','C9 ADL142115','A2 0451103299','A1 OC 309','A3 MNN W75/3','A2 UFI 23.262.00','B7 OP643/4/AG','C9 71758768','A9 UFI 23.419.00','D2 F136','A1 W75/3','E6 FL1192','A2 FI OP643/4','A1 0451103235','A5 38995','B1 FTROP643/4','A2 UFI 23.481.00','B1 TRU02.18.169','A5 40953','C9 LS218','A1 WOF104','A2 OC3','A3 MHL OC223','B7 A210009/DKM','C9 SP-952','C9 0451103299','C9 DO1800','A9 UFI 23.401.00','A5 40950','C4 OC 727','A1 10-08-891ASK','A1 LS571PU','B1 BLPADN12121','A9 OC727','D1 BP ADN12136','C9 ADN12138','D1 BP ADN12135','C9 F026407022','C4 H11W02','A2 W79','A9 UFI 23.262.00','B7 4318500709/JP','A2 SF OF0012','C4 LS218PU','C4 COF100136S','B7 H221W','B1 PURLS223','B1 BLPADN12136','A8 312 839','B1 VAL586001','A2 UFI 23.401.00','C9 ADN12136','A2 OC727','D1 BP ADN12137','A8 370 509','A1 0451103299','C4 32398F','B7 1218505709/JP','B1 VAI46-0083','A1 0451103293','C9 ADN12135','A3 FLT OP643/3','A9 UFI 23.177.00','A2 OC467','A1 OC467','A1 OC223','C9 DO1836','B1 PURLS933','A3 BOS 0451103299','A5 24793','C9 LS576','A8 365 862','A9 0451103111','A9 H11W02','A9 W712/47','A1 WOF155','A8 365 933','C4 7700274177OE','B1 BLPADN12139','A2 H11W02','A3 MNN W79','C9 71758726','C9 ADC42115','A8 315 301','B1 KAMF106201','A5 80537','C4 OC 467','C9 FO-990S','B1 KAMF105101','A3 VAC V42-0053','A3 MHL OC727','B1 KNEOC471','C4 S 3820 R','A5 40945','A8 313 487','A8 315 284','C9 71760808','A3 JAP FO-595S','C4 LS932PU','B1 BOSF026407022','C9 FO-891S','B1 CHACOF100136S','C9 FO-122S','A2 0451103336','C9 OF-1039','A9 UFI 23.418.00','A2 UFI 23.418.00','A9 W75/3','C9 DO832','A2 0451103111','B7 H221WK','B1 PURLS218','A5 202467','A8 323 933','A5 66925','C9 OF-1321','B1 BLPADN12135','A1 32102 FE','B1 FEB32102','C4 W 712/47','C4 S 3418 R','C9 OF-986','B7 MO-441/KAVO','C4 W 75/3','A3 JAP FO-122S','A1 F026407022','D1 BP ADC42115','A2 UFI 23.419.00','C9 H11W02','A8 365 980','C9 ADN12137','B7 A210582/DKM','C9 16-143220000','D2 8671002274','C9 LS933','A5 174871','A1 32398 FE','B1 FEB32398','C9 LS223','B1 KNEOC309','B7 10891/JAPKO','A9 FI OP643/4','B1 KNEOC467','A1 LS933PU','A2 J1315020','A8 343 569','A8 306 367','A8 919 259')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #