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 579.0','B1 ABS37149','C9 VAL598659','A2 13.04604984.2','B1 BOS0986494576','C4 604990','B7 0769.02/REM','B1 ATE13.0460-4984','B7 23271.175.2','A3 DLP LP1828','C4 FDB1426','C9 VAL598445','A3 BOS 0986424705','C4 23745.175.1','C9 223347','A9 13.04604990.2','C4 LD4990','A1 573092JC JRD','A9 23745 177 05','C4 2327181TX','C9 0252374517/PD','B1 TRU02.35.116','A3 BOS 0986494012','A1 P50041','A2 T 2327181','B1 VAI30-8146','C9 0252327117/PD','A2 23745 177 05','A1 WBP671','C4 0986424705','B1 ATE13.0460-4990','C9 2327102','A2 LP1688','A8 229 174','A5 186614','A1 13.0460-4984.2','B1 ZIM23271.175.1','C9 2327181','A2 T 2374581','C9 2374581','C9 23271-17,7','C9 13.0470-4990.2','A2 FE FDB1426','A9 13.04704990.2','C9 FDB1426','B7 23745.175.1','A9 BP50041','A1 571961JC JRD','A1 573152JC JRD','A9 0986424705','C9 0252327117','C9 13.0460-4984.2','B1 BOS0986424705','C4 2327102TX','A8 229 594','B7 23271.175.1','C9 23271-17,7 EPAD','A3 VAC V30-8146','A9 13.04604984.2','A9 23745.175.1','C9 0986424705','A2 LP1828','A1 13.0470-4990.2','B1 ZIM23745.175.1','C9 2374502','A2 0986424705','C4 2374502TX','A1 0986424705','C9 23745-17,7 EPAD','C9 13.0460-4990.2','C4 LP1828','A2 13.04704990.2','A1 13.0460-4990.2','A1 0986494576','A8 218 004','C9 0252374517','A1 FDB1426','B1 BREP50053','A2 FE FDB1661','A8 206 495','C4 LP1688','E7 AC813881D','B1 BREP50041','C9 0986494012','A1 598445','A3 TEX 2374502','A1 FSL1426','A1 16454 FE','B1 ZIM23271.175.2','A3 TEX 2327102','A1 LP1828KB','A3 TRU 02.35.116','A9 FE FDB1661','A1 0986424475','A3 TEX 2374581','A9 FE FDB1426','A2 13.04604990.2','C4 16454F','B1 VAL301445','A1 FDB1661','A9 BP50053','A2 23271 177 05','A8 229 597','A3 FER FDB1426','A1 0986494012','B1 FEB16454','C9 13.0470-4984.2','B1 ATE13.0470-4984','C9 0986424475','A5 73187','A2 13.04704984.2','C9 0986494576','B7 23745.175.2','A1 LP1828','A1 2374502 TEX','A2 BP50053','A3 TEX 2327181','A1 WBP460','C9 23745-17,7','A1 2327102 TEX','B7 0769.00/REM','A3 DLP LP1688','A1 P50053','B1 ATE13.0470-4990','A3 FER FDB1661','A2 23745.175.1','A2 16454FEBI','A2 0986494012','A9 13.04704984.2','C4 23745.175.2','C9 VAL301445','A1 LP1688','A1 13.0470-4984.2','B1 ZIM23745.175.2','C4 604984','E1 10 91 6454','A5 73194','A9 23271 177 05','A2 0986494576','A2 BP50041','A2 QWS0196A','A2 QWS0214A','A2 RH 2769.02','A3 QUI 109-1636','A3 QUI WS0162A','A3 QUI WS0212A','A3 QUI WS0214A','A3 ROA 276902','A8 524 179','A9 Q109-1636','A9 Q109-1643','A9 Q109-1803','A9 Q109-1804','A9 Q109-1829','A9 QWS0196A','A9 QWS0212A','A9 QWS0214A','B1 BREP50053X','B1 FEB16481','B1 KAMJQ1012852','B1 QB109-1643','B1 QB109-1803','B1 QB109-1829','B1 QBWS0162A','B1 QBWS0196A','B1 VAL302044','B1 ZIM23745.975.2','B7 B111111/DKM','C9 19-1818','C9 2115401717/MG','C9 811523005','C9 QB109-1636','C9 QB109-1643','C9 QB109-1803','C9 QB109-1804','C9 QB109-1829','C9 QBWS 0162 A','C9 QP4588','C9 QP4588C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #