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