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