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 ('A1 13.0470-3966.2','A2 GDB1464DTE','A1 GDB1464DTE','A8 219 753','A9 13.04703966.2','A3 BOS 0986424596','A8 234 068','A2 301465','A2 13.04603966.2','A3 TEX 2370803','E7 964.0','A1 573031JC JRD','C9 0986494038','B1 BOS0986494602','C9 13.0460-3811.2','A1 0986424596','A2 T 2370503','B7 23600.190.2','A9 0986494038','A3 BOS 0986495225','B1 VAL301465','B1 FEB16422','C9 0252360019','C9 25094-19,0','A9 23600.190.2','C4 GDB1464DTE','A3 BOS 0986494038','A5 43122','A1 598698','A9 0986424596','A9 23708 182 14','C4 23600.190.1','A2 T 2509401','B1 VAL301698','C4 0986495225','C9 13.0460-3966.2','E1 62 91 6422','A1 FSL1476','A2 FE FDB1476','C9 0986494074','E7 AC600281D','A9 FE FDB1476','A1 LP1653','E7 964.0.T','B1 ZIM23600.190.1','A3 TEX 2360001','C9 VAL598465','A3 DLP LP1679','A3 FER FDB1476','A1 LP1679','B1 ZIM23600.190.2','A5 96352','A1 P61068','A1 0986494038','A9 GDB1464DTE','B1 ATE13.0470-3966','A2 05P1192','A2 05P807','B1 BOS0986424596','A8 207 195','C4 16422F','A8 236 865','C9 VAL872708','A2 13.04703966.2','A2 0986494038','C4 0986424596','C9 0252370819','A2 23600.190.2','A9 BP61068','A1 573030J JRD','A2 0986494074','A1 598465','C9 13.0470-3966.2','C4 603811','B7 23600.190.1','A1 FDB1476','A1 0986495225','A5 116694','B1 ATE13.0460-3966','A1 13.0460-3811.2','A3 TEX 2370503','B1 BOS0986494038','B1 LUCGDB1464DTE','C4 05P807','A5 76369','B1 ABS37418','A2 13.04603811.2','A1 WBP515','C9 223740','C9 0986494602','B7 0841.00/REM','A3 BOS 0986494074','A9 23600 190 14','C9 0252360019/PD','A1 0986494074','C4 16554F','A2 BP61068','C9 0252509419/PD','C4 2360001TX','C9 VAL301465','A1 13.0460-3966.2','A2 0986424596','C9 GDB1464DTE','C4 2370803TX','A9 13.04603811.2','C4 FDB5028','B1 BREP61068','A2 23600 190 14','A1 16422 FE','C9 VAL872600','A8 221 263','C9 0252509419','A3 TEX 2509401','B1 BOS0986494074','C9 2509401','C9 222364','A9 05P807','A3 FER FDB5028','A3 DLP LP1653','C4 0986494038','A1 FDB5028','C9 2370803','A9 0986494074','C9 VAL301698','A1 WBP400','B1 FEB16554','E7 331.1','C4 603966','B1 ABS37273','A2 23708 182 14','C9 0986424596','A8 227 313','A9 13.04603966.2','A2 LP1653','C9 23705-17,8 1 4','C9 2360001','C9 23600-19,0','C4 LP1653','B1 ATE13.0460-3811','C9 VAL598698','A1 16554 FE','C4 05P1192','C4 FSL1476','A1 0986424659','E7 AC0581268D','A1 2370803 TEX','B7 0859.10/REM','C9 FDB1476','C9 23708-18,2 1 4','C4 FDB1476','A8 207 196','A1 P23119','A1 WBP401','A2 ADL144213','A2 BP23119','A2 Q109-1218','A2 RH 2841.00','A3 CIF 822-322-1','A3 QUI 109-1218','A3 ROA 284100','A8 206 986','A9 BP23119','A9 Q109-1218','A9 RH 2841.00','B1 BLPADL144213','B1 BREP23119','B1 BREP61068X','B1 BREP61137','B1 FEB116057','B1 KAMJQ1012952','B1 QB109-1218','B1 ZIM23600.990.1','B7 B110599/DKM','C4 116057F','C9 19-0576','C9 23600 00 701 00','C9 PA-0080AF','C9 QB109-1218','C9 QP3797','C9 QP3797C','D1 BP ADL144213','E1 70 91 6554')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #