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 598461','A1 FQT1378','A2 05P903','A1 13.0460-3974.2','A3 DLP LP1617','A2 0986494507','A1 0986495235','C9 0986494507','A3 FER FDB1135','A1 0986424660','A3 BOS 0986495235','C9 21980-18,0','C9 0986424455','C4 0986495235','A9 13.04603977.2','A2 BP61098','A2 0986495011','B1 BOS0986494039','A8 209 903','A8 205 592','C4 603975','A9 FE FDB1135','A1 LP1617','C4 LP1519','C9 0986424660','A1 LP1519','A3 DLP LP1519','A2 LP1699','A1 FDB1135','B7 0643.10/REM','C9 23597-18,0','B1 VAL301726','A5 17413','A1 13.0460-3977.2','A2 0986495235','B1 BLPADN142122','A1 FSL1135','B7 SP 312','A3 BOS 0986495011','A1 0986495011','C9 VAL598461','C9 21980-18,0 1 5','A1 WBP126','A1 LP1610','A1 571931J JRD','B1 ABS37040','A1 FQT1135','C4 FDB1378','A3 TRU 19.35.021','B1 BOS0986424455','C9 0252198018','B7 0643.20/REM','A2 05P662','C4 05P661','A8 235 250','A1 0986494039','A2 13.04603975.2','C4 603977','A1 0986494507','A3 BOS 0986494039','A2 0986494039','B1 ATE13.0460-3977','C4 FDB1135','A3 DLP LP1610','A2 LP1617','C4 LP1610','C4 0986494039','A9 0986424455','A8 217 745','A5 42605','A1 FDB1378','A1 LP1699','A1 13.0460-3975.2','B7 21980.180.1','A2 23597 180 15','C9 0252359718','A5 50065','C4 05P1106','A1 0986424455','E7 262.0','A1 0986495052','A3 BOS 0986495052','A2 13.04603977.2','A8 216 277','C9 FDB1378','B1 ZIM21980.180.1','C9 223938','A9 21980 180 15','C4 LP1699','B7 21981.180.1','B1 BREP61098','B1 ATE13.0460-3975','C4 2359703TX','A9 21980 180 25','A1 16441 FE','C4 2198003TX','B7 0643.01/REM','A2 21980 180 25','A3 BOS 0986494507','B1 BOS0986494507','E1 60 91 6441','A1 571930J JRD','A1 WBP378','A8 205 619','A9 BP61098','C9 VAL301726','A2 FE FDB1378','A3 BOS 0986424455','B1 BREP56038','A2 0986495052','B7 0643.00/REM','A2 0986424455','A9 05P903','A9 13.04603975.2','A3 FER FDB1378','A8 235 246','D1 BP ADN142122','C9 2198003','A2 BP56038','A1 598325','C4 LP1617','A1 0986424487','C9 13.0460-3975.2','C9 VAL598325','E7 262.0.T','A1 WBP125','A2 LP1610','A9 23597 180 15','A9 0986494039','A1 WBP449','A5 77660','A2 21980 180 15','A2 05P661','C9 VAL598324','A8 215 837','A1 P61098','C9 13.0460-3977.2','A2 FE FDB1135','C4 05P662','C4 05P903','A2 FE FSL1135','A9 FE FDB1378','A3 TEX 2198004','C4 FQT1135','A1 P56038','A8 207 981','C9 ADN142122','C9 0252359718/PD','A2 LP1519','A3 TEX 2359703','B1 ZIM21981.180.1','C9 0986494039','A3 DLP LP1699','A9 BP56038','A3 TEX 2198003','B1 FEB16441','A1 2198003 TEX','C9 0252198018/PD','C9 FDB1135','C9 2198004','C9 VAL598726','A5 129590','C9 2359703','A2 05P1106','A8 217 273','A1 P68042','A2 J3601093','A2 Q113-1354X','A2 QWS0215A','A2 RH 2643.00','A2 RH 2643.20','A3 CIF 822-253-0','A3 QUI 113-1354X','A3 QUI WS0215A','A3 ROA 264300','A3 ROA 264320','A9 BP68042','A9 J3601093','A9 Q113-1354X','A9 RH 2643.00','A9 RH 2643.20','B1 BLPADP154217','B1 BREP68042','B1 FEB16575','B1 KAMJQ1013206','B1 QBWS0215A','B7 B110648/DKM','C4 16575F','C4 J3601093','C9 19-0555','C9 19-3392','C9 QB113-1354X','C9 QBWS 0215 A','C9 QP2611','C9 QP2611C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #