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 ('A8 908 794','C9 31-143220008','C9 F026407124','A3 JAP FO-599S','C4 W 8017','A2 OC1254','B7 TO-149/KAVO','A8 360 033','A3 MHL OC617','A2 FI OP557','C9 H13W01','C9 W811/80','A1 10-07-703ASK','B7 10914/JAPKO','B1 VAL586062','B1 MANW8017','B1 MANW87','B1 PURLS489A','C4 S 6902 R','B1 PURLS892','C4 J1317003','B7 10502/JAPKO','A9 UFI 23.583.00','B7 OP 595/4/IP','B1 FTROP617/1','C9 FO-706S','C9 SP-1449','B7 OP595/4/AG','C4 COF100110S','A9 FI OP617/1','D1 BP ADS72101','B1 HENH13W01','A3 MHL OC1288','D1 BP ADZ92113','B1 MANW811/80','B1 PURLS350','B7 HO-701/KAVO','A3 KAP MO-422','C4 LS489APU','A1 10-09-914ASK','A9 OC205','C9 ADS72101','E6 FL1037','A1 10-07-706ASK','C9 FO-599S','A5 432468','B7 MO-422/KAVO','A5 30171','C4 LS350PU','A8 350 614','A3 MHL OC1254','A2 UFI 23.583.00','A9 W811/80','A3 JAP FO-502S','B1 MISZ200','A2 UFI 23.271.00','B7 3918500309/JP','C4 LS892PU','C9 SP-989','C4 S 3583 R','B7 MO-429/KAVO','A5 30160','B1 KNEOC500','A1 F110','A3 FLT OP595/4','B7 10321/JAPKO','A3 MHL OC500','A1 F026407124','B1 KNEOC205','A3 JAP FO-321S','B1 BOSF026407124','A2 OC1288','B1 BLPADC42103','A3 KAP MO-429','C9 35-143220002','B7 HO-605/KAVO','B1 FTROP557','A9 OC617','A1 LS892PU','A2 OC1255','A1 OC1254','C9 FO-502S','C9 ADC42103','A1 LS489APU','A8 326 211','A8 300 100','D1 BP ADC42112','C9 FO-914S','A2 FI OP617/1','C9 ADC42112','A3 BOS F026407124','C9 OF-1780','A2 W87','B1 BLPADG02144','C4 S 6901 R','A8 358 664','A8 373 761','B1 BLPADS72101','B7 OP 557/IP','A3 MNN W811/80','A3 FLT OP557','B7 A210983/DKM','A3 MHL OC1255','A1 OC1255','B7 A210100/DKM','A9 OC1288','A1 OC205','C4 N1310510','C9 LS892','C9 LS489A','D1 BP ADC42103','A2 OC205','A1 W811/80','A1 OC500','B7 A210304/DKM','A9 UFI 23.271.00','A1 10-03-321ASK','A2 OC500','A1 35-09-900ASK','B1 BLPADC42112','B1 FTROP595/4','C9 ADZ92113','A1 W87','A8 361 750','C9 SP-814','E6 FL1157','B1 KNEOC1255','C4 O0650DREIS','B1 CHACOF100110S','B1 KAMF115501','B7 10703/JAPKO','E6 FL1214','A3 MHL OC205','C4 H13W01','C9 32-143220007','A3 MNN W87','A3 VAC V52-0132','C9 SP-934','A2 W8017','A9 OC1254','A8 370 382','A1 10-05-599ASK','B7 OP 617/1/IP','C9 34-143220001','C4 OC 205','A9 W8017','A5 174793','A8 919 462','C9 ADG02144','B7 35900/JAPKO','E6 FL1199','A5 202470','A1 OC 205','A8 318 852','A3 JAP FO-706S','B7 MO-520/KAVO','B7 OP617/1/AG','C9 LS350','B7 OP557/AG','A8 345 060','A2 J1317003','A1 OC617','B7 10705/JAPKO','A1 LS350PU','A5 174794','A5 27476','C9 W87','B7 MO-510/KAVO','A9 FI OP557','A9 F026407124','A9 W87','A1 W8017','A3 JAP FO-914S','C4 OC 617','A9 UFI 23.461.00','B7 W811/80/AG','C4 F026407124','A2 N1310510','A1 WOF120','B1 KNEOC617','C9 W8017','A2 W811/80','A8 358 665','A9 N1310510','A5 272918','A2 OC617','A8 926 772','A5 162212','C9 FO-703S','A2 UFI 23.461.00','A8 365 590','B1 VAI52-0132','A5 372458','B1 BLPADZ92113','A2 F026407124','B7 H13W01','A3 JAP FO-703S','A9 J1317003','D1 BP ADG02144','C4 W 87','A8 916 172','A9 OC500','A3 KAP HO-605','A5 206439','A8 318 330','A3 FLT OP617/1','C9 FO-321S','C4 W 811/80','A1 0451103316','A2 0451103316','A2 FI OP617','A2 J1314010','A2 J1315015','A2 SF OF0063','A3 BOS 0451103316','A3 FLT OP617','A5 44645','A8 314 274','A8 320 521','A8 360 886','A9 0451103316','A9 J1314010','A9 J1315015','A9 SF OF0063','B1 BLPADN12112','B1 BOS0451103316','B1 FEB32099','B1 FTROP617','B1 KAMF118901','B1 VAL586017','B7 A210023/DKM','B7 A210039/DKM','B7 A210159/DKM','B7 SM121','C4 0451103316','C4 J1314010','C4 J1315015','C9 0451103316','C9 ADN12112','C9 FE32099','C9 OF-934','D1 BP ADN12112')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #