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 BP61068','B1 CIF822-322-1','C9 GDB1624','A3 BOS 0986494038','C9 0252509419/PD','C9 GDB1669','E7 AC600281D','A9 GDB1669','A9 23600 190 14','A1 573031JC JRD','C9 PF0176','A2 RH 2859.10','C4 FSL1476','C9 0986494602','A1 FDB5028','A8 234 068','A1 GDB1624','C9 PF0558','B7 B110599/DKM','C4 GDB1624','B1 BREP61068X','E7 964.0','C9 FDB1476','A2 23708 182 14','C4 GDB1464','C9 VAL301465','A1 GDB1591','C4 FDB5028','A1 GDB1676','A5 43122','A2 0986494038','A9 0986494038','C4 GDB1669','C4 23600.190.1','B1 ATE13.0460-3966','C9 QP3797','B1 KAMJQ1012952','C9 0986494038','A1 WBP515','B1 ABS37273','C9 25094-19,0','A1 WBP401','B7 0841.00/REM','A5 116694','A2 T 2509401','A5 96352','E1 62 91 6422','C4 LP1653','A8 221 263','A2 BP23119','C4 0986495225','A3 DLP LP1653','A2 LP1653','B1 ZIM23600.190.1','A2 13.04603811.2','A9 13.04703966.2','A1 LP1653','C9 19-0576','A8 227 313','A8 207 196','A9 BP61068','B1 ZIM23600.190.2','C9 2370803','C4 2360001TX','B1 BREP61068','A1 13.0470-3966.2','C4 GDB1591','A2 FE FDB1476','B1 BOS0986494602','C9 23600 00 701 00','B1 BLPADP154218','A2 GDB1464','B7 0859.10/REM','A1 GDB1669','A2 GDB1624','A9 GDB1464','C9 VAL598465','B1 LUCGDB1464','A2 23600.190.2','A3 FER FDB1476','A3 TEX 2509401','A1 13.0460-3966.2','A3 TEX 2370803','B1 VAL301465','A9 05P807','A2 RH 2841.00','A1 FDB1476','B1 BOS0986494038','C9 VAL872600','A2 05P807','B1 ABS37885','A1 GDB1464DTE','C4 603966','A1 598465','A9 RH 2841.00','A9 13.04603966.2','A5 76369','A1 0986494038','B1 LUCGDB1624','B1 CIF822-948-0','A3 CIF 822-322-1','A1 2370803 TEX','A3 FER FDB5028','C9 PF0228','E7 964.0.T','A2 GDB1669','A1 13.0460-3811.2','A8 230 173','A9 FE FDB1476','C9 23600-19,0','B1 LUCGDB1669','A3 TRW GDB1464','C9 0252370819','C9 0252360019/PD','C9 QP3797C','C9 0252509419','C4 GDB1464DTE','B7 23600.190.1','C4 05P1192','B7 23600.190.2','B1 BREP23119','B1 VAI22-0082','C9 13.0460-3811.2','A3 ROA 284100','A2 GDB1464DTE','B1 ABS37418','A1 0986424659','C4 KRO1464','A2 13.04603966.2','A1 GDB1464','C4 2370803TX','A2 301465','E7 AC0581268D','B1 ATE13.0470-3966','E2 721 239 755','A2 23600 190 14','A9 23600.190.2','C9 13.0470-3966.2','C9 2360001','A3 TEX 2360001','A1 WBP532','C9 0252360019','A9 13.04603811.2','B1 ATE13.0460-3811','C4 0986494038','A9 GDB1624','B1 TOM1342','A9 BP23119','C9 GDB1464','C4 05P807','A9 GDB1464DTE','A3 VAC V22-0082','C9 13.0460-3966.2','A1 0986495225','C4 FDB1476','E7 331.1','C9 PA-0080AF','A2 13.04703966.2','B1 LUCGDB1464DTE','B1 BREP61137','A8 207 195','B1 FRE901218','C9 23708-18,2 1 4','A9 23708 182 14','C9 2509401','A1 FSL1476','D1 BP ADP154218','A2 05P1192','A1 P61068','A3 ROA 285910','A1 P23119','C9 GDB1464DTE','A5 170162','A8 236 865','A3 BOS 0986495225','C4 603811','B1 ZIM23600.990.1','A1 573032JC JRD','A1 FDB1083','A2 FE FDB1083','A3 FER FDB1083','A5 42596','A9 FE FDB1083')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #