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 ('C9 ADN142122','A2 0986494507','A1 P61098','C9 23597-18,0','E7 262.0.T','A2 FE FDB1135','A1 571930J JRD','A1 0986494507','A1 FDB1378','C4 LP1610','A2 23597 180 15','A1 598325','C4 0986494039','C9 VAL598726','A2 21980 180 15','A3 DLP LP1699','B1 BREP56038','A1 13.0460-3975.2','B7 0643.20/REM','A2 05P661','C9 21980-18,0 1 5','C4 2198003TX','C9 0986424455','A1 0986424455','A2 0986424455','C9 VAL301726','A8 207 981','A8 217 745','A2 FE FSL1135','A1 0986494039','A9 13.04603977.2','B1 BREP61098','A1 LP1519','A1 WBP449','C4 FQT1135','B1 FEB16441','A9 23597 180 15','C4 0986495235','A9 0986424455','A3 TRU 19.35.021','A2 LP1610','A1 WBP378','A8 216 277','B1 VAL301726','C4 2359703TX','A9 FE FDB1378','A1 WBP126','C9 0252359718/PD','A1 WBP125','A1 0986495235','A9 FE FDB1135','C9 VAL598461','A9 13.04603975.2','C4 FDB1135','A3 FER FDB1378','A9 21980 180 15','B7 21980.180.1','D1 BP ADN142122','A8 215 837','B7 0643.00/REM','C4 LP1699','A1 P56038','A2 13.04603977.2','A3 DLP LP1610','A1 FQT1378','B1 ATE13.0460-3977','C9 FDB1378','B1 ABS37040','C9 13.0460-3977.2','A5 77660','A2 FE FDB1378','A8 217 273','A5 42605','C9 2198003','C9 0252198018','A3 FER FDB1135','A9 0986494039','C4 05P903','A5 129590','B1 ATE13.0460-3975','A2 0986495052','A1 LP1699','C9 2359703','C4 603977','A1 FSL1135','B1 BOS0986424455','B7 21981.180.1','A5 50065','A2 BP61098','A9 05P903','B7 0643.01/REM','C9 FDB1135','A3 BOS 0986494039','A3 TEX 2198003','A8 235 246','A1 16441 FE','A2 05P1106','C9 0252198018/PD','C4 05P662','C9 0986494039','C4 LP1519','A9 BP61098','C9 13.0460-3975.2','C9 0986424660','A1 0986495052','B7 0643.10/REM','A8 205 592','C4 05P1106','B1 BOS0986494039','A2 LP1617','A1 2198003 TEX','C9 223938','C9 VAL598324','A9 21980 180 25','B7 SP 312','A2 05P903','B1 ZIM21981.180.1','A3 DLP LP1617','B1 BLPADN142122','C4 FDB1378','A1 598461','A2 0986495011','A8 209 903','A2 LP1699','C9 2198004','C4 LP1617','A3 TEX 2198004','C9 VAL598325','A3 TEX 2359703','A2 BP56038','C9 0252359718','C9 21980-18,0','A1 13.0460-3974.2','A1 571931J JRD','A8 235 250','B1 ZIM21980.180.1','A2 21980 180 25','A3 DLP LP1519','A2 13.04603975.2','A1 FQT1135','C4 05P661','A3 BOS 0986424455','A1 LP1617','A2 LP1519','A1 0986424660','B1 BOS0986494507','A3 BOS 0986495052','C9 0986494507','A9 BP56038','E7 262.0','A2 0986495235','A1 0986495011','A1 0986424487','C4 603975','A3 BOS 0986495235','A8 205 619','A2 0986494039','A1 LP1610','A3 BOS 0986494507','A3 BOS 0986495011','E1 60 91 6441','A1 13.0460-3977.2','A1 FDB1135','A2 05P662','A5 17413','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)) #