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 ('A2 T 2533701','C4 116285F','C4 605786','A8 254 044','A2 RH 21362.42','A5 139569','A5 270846','A8 252 502','B1 FEB116289','C4 GDB3594','C9 13.0460-5786.2','C4 N3610519','B1 BLPADG042154','A8 256 357','A1 GDB3594','D1 BP ADG042165','A3 BOS 0986494557','A1 0986495351','C4 2533701TX','B1 FEB116378','C4 GDB3537','B1 BOS0986494557','A2 0986495351','C9 ADG042138','C9 25337 00 702 00','B7 25337.160.2','A3 CIF 822-886-1','C4 05P1710','B1 LUCGDB3594','A3 DLP LP2195','B7 1362.42/REM','B1 LUCGDB2173','A1 0986494557','A8 241 190','A9 GDB3537','A5 119337','B7 KBP-4029/KAVO','D1 BP ADG042154','A3 ROA 2136242','A1 FDB4387','B1 VAL301301','A5 271370','B7 25337.160.1','A2 N3610314','A1 GDB3569','C9 GDB2173','A3 FER FDB4387','A5 236579','A1 LP2295','A5 287428','A9 T 2533701','D1 BP ADG042138','A2 13.04605650.2','C9 25337-15,7','C4 GDB3494','A2 GDB2173','A5 287407','D1 BP ADG042127','B1 ZIM25337.160.2','C9 ADG042127','C4 LP2295','A9 RH 21362.42','A5 289827','A1 GDB3495','A8 228 553','C4 LP2195','C9 0986494908','A1 0986494768','A2 GDB3494','B1 BOS0986494768','A8 234 678','B1 LUCGDB3494','A8 258 411','B1 BLPADG042138','A8 241 300','C4 0986494557','C9 GDB3494','C4 N3610311','C9 GDB3537','A9 N3610311','A1 GDB3494','C4 GDB3569','C4 N3610314','D1 BP ADG042160','E7 903.0','B1 LUCGDB3569','C9 2533701','C9 19-2129','A1 13.0460-5650.2','A3 ROA 2136285','A9 GDB3494','B7 KBP-4022/KAVO','A5 289441','A3 BOS 0986494908','A3 ROA 2136252','B7 KBP-3025/KAVO','E6 BP2135','C4 116378F','C4 KRO3494','A1 WBP1275','B7 1362.52/REM','A1 GDB3537','B1 ATE13.0460-5650','B1 FEB116294','A8 230 264','E7 903.0.T','B1 ABS37777','B1 FEB116285','B1 BLPADG042160','C9 GDB3569','C9 ADG042154','B1 VAL302335','C9 GDB3594','A9 GDB2173','B1 CIF822-886-1','A9 13.04605786.2','B1 CIF822-886-0','A1 WBP801','B1 BLPADG042165','C9 13.0460-5650.2','A9 GDB3594','A2 GDB3594','B1 ABS35133','A1 WBP1258','A1 2533701 TEX','B1 BOS0986494908','A8 229 223','C9 0986494557','A9 13.04605650.2','C4 0986494768','C9 0986494768','A9 N3610314','B1 FEB116301','A5 88358','C4 25337.160.2','C9 VAL301301','B1 BLPADG042127','B1 ABS37914','C9 PP-K06AF','A8 233 614','A1 LP2195','A2 13.04605786.2','A8 234 156','C9 ADG042160','A3 TEX 2533701','B1 ATE13.0460-5786','A3 DLP LP2295','A2 N3610519','B1 LUCGDB3537','C4 25337.160.1','A2 GDB3537','B1 VAL302219','A1 13.0460-5786.2','C4 FDB4387','B1 ZIM25337.160.1','B7 KBP-3045/KAVO','C4 116294F','A2 N3610311','A2 Q109-0024','A3 QUI 109-0024','A5 389981','A8 253 472','A9 13.04705786.2','A9 Q109-0024','B1 ATE13.0470-5650','B1 ATE13.0470-5786','B1 KAMJQ101268','B1 QB109-0024','B7 B111279/DKM','C9 0252533715/W','C9 13.0470-5650.2','C9 13.0470-5786.2','C9 QB109-0024','C9 QP0611','C9 QP5713','C9 QP5713C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #