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 ('C4 GDB1454','A9 0986424705','B1 FEB16481','E1 10 91 6454','A3 FER FDB1661','B1 ZIM23745.175.1','A3 ROA 276900','A9 23271 177 05','E7 AC813881D','A2 23271 177 05','B1 BREP50053','B1 VAL301445','A9 BP50041','A2 16454FEBI','A8 236 682','A8 206 495','A1 P50041','C9 19-0500','A3 TRW GDB1454','C9 13.0470-4990.2','C4 05P899','C9 GDB1543','A3 TEX 2327181','B1 ZIM23745.975.2','C9 0252374517','C9 GDB1454','C9 2327102','A9 FE FDB1661','A1 FDB1426','A9 FE FDB1426','B1 KAMJQ1012852','C9 VAL301445','B7 B111111/DKM','A2 GDB1543','C9 0252374517/PD','E7 579.0','B1 ZIM23271.175.2','A3 DLP LP1688','C4 16454F','C9 VAL598659','A2 23745 177 05','C4 23745.175.1','A1 16454 FE','A9 13.04604990.2','C9 FDB1426','B7 23271.175.2','A3 CIF 822-563-0','A5 73194','A3 DLP LP1828','C4 KRO1543','B1 CIF822-563-5','A9 13.04704984.2','A5 73187','A5 151978','A9 13.04604984.2','A8 230 210','C4 0986424705','B1 BLPADU174214','A5 459654','C4 23745.175.2','A1 13.0460-4990.2','A3 TEX 2374581','C9 2327181','A2 0986494576','A2 FE FDB1661','C9 2374502','C4 GDB1543','A8 229 174','C9 0986494012','C9 PF0585','A8 233 773','A2 FE FDB1426','B1 LUCGDB1543','A2 05P849A','B1 FEB16454','A9 BP50053','A3 BOS 0986494012','C4 2374502TX','A2 RH 2769.02','A1 WBP671','B1 BOS0986495278','C4 LP1688','C4 1170153','A1 0986494576','C9 23745-17,7','A1 0986424475','C9 23745-17,7 EPAD','A1 GDB1454','C9 23271 00 552 20','A9 23745.175.1','A3 ROA 276902','C9 0252327117/PD','A2 13.04704990.2','A3 FER FDB1426','A1 13.0470-4984.2','A1 GDB1543DTE','C4 604984','C4 LP1828','A8 218 004','A1 2374502 TEX','B1 ATE13.0460-4984','C9 0986424475','A9 13.04704990.2','C9 VAL598445','C9 13.0460-4990.2','A1 FDB1661','A8 229 594','A1 WBP460','A8 229 597','B1 CIF822-563-0','C9 13.0460-4984.2','B7 B110873/DKM','A1 0986424705','A1 LP1688','A2 RH 2769.00','B1 ATE13.0470-4990','C4 FDB1426','A9 GDB1543DTE','C9 PA-0510AF','A1 2327102 TEX','A2 13.04704984.2','C9 0252327117','A2 BP50041','A1 GDB1543','A9 23745 177 05','B1 VAL302044','A2 0986494012','A1 16481 FE','A1 13.0470-4990.2','C4 GDB1543DTE','A9 GDB1543','A2 GDB1454','B7 23745.175.1','A2 0986424705','C9 0986494576','A3 TEX 2374502','C9 23271-17,7 EPAD','A2 05P899','B1 LUCGDB1543DTE','B1 BLPADU174281','B1 ATE13.0470-4984','B7 23271.175.1','A2 T 2327181','C9 0986424705','A1 FSL1426','B1 ATE13.0460-4990','A1 LP1828KB','C9 23271-17,7','C4 05P849','C9 23271-17,7 0 8','A2 GDB1543DTE','A8 230 167','A2 LP1828','A2 23745.175.1','C4 KRO1454','C4 2327102TX','B1 ZIM23271.175.1','B7 23745.175.2','A1 LP1828','A2 13.04604990.2','B1 BOS0986494576','A3 TEX 2327105','B1 BREP50041','A1 598445','A2 13.04604984.2','A2 BP50053','A9 RH 2769.00','C9 2374581','C4 2327181TX','B7 0769.00/REM','A3 TEX 2327102','C9 GDB1543DTE','B1 ZIM23745.175.2','D2 EO 2769.00','B7 0769.02/REM','A2 T 2374581','A1 P50053','A1 0986494012','B1 BOS0986424705','A3 BOS 0986424705','C4 LD4990','C4 604990','A2 LP1688','C9 19-1818','A5 131018','D1 BP ADU174214','E1 10 91 6481','A1 13.0460-4984.2','B1 LUCGDB1454','A9 GDB1454','C9 13.0470-4984.2','A5 186614','C9 PF0320','A1 573092JC JRD','A3 QUI 109-1636','A9 Q109-1636','A9 Q109-1643','A9 Q109-1803','A9 Q109-1804','A9 Q109-1829','B1 BREP50053X','B1 QB109-1643','B1 QB109-1803','B1 QB109-1829','B1 VAL302277','C9 QB109-1636','C9 QB109-1643','C9 QB109-1803','C9 QB109-1804','C9 QB109-1829','C9 QP4588','C9 QP4588C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #