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 ('B7 B110036/DKM','A2 21945 196 14','B1 ZIM21945.195.1','A9 RH 2134.20','A9 RH 2134.00','C4 05P719','D2 EO FDB1289','B1 LUCGDB826','C4 GDB826','C9 21945 19,6 1 4','B1 VAI10-8135-1','A2 05P216','A9 21945.195.1','B7 1163602010/JP','A3 DLP LP778','A2 05P719','B1 ABS37010','C4 602934','A2 LP1410','C9 QP0035C','A2 20669 196 14','A3 VAC V10-8135-1','B1 VAI10-8345','A2 RH 2631.10','C9 VAL301003','A8 219 864','C9 20669 00 701 00','B7 21945.195.1','A3 DLP LP1410','C4 LP778','A1 LP429','E7 P7313.10/W','A9 0986466700','B1 LUCGDB1266','A3 FER FDB1289','A1 WBP294','C9 GDB1266','A1 FDB1289','A3 TRU 07.35.229','C9 20168 10 701 00','A2 0986494021','C4 602822','C9 2194503','B7 1163602310/JP','A8 203 484','A2 FE FDB1289','A2 13.04602822.2','B7 05P216/SUZ','A2 RH 2134.00','C4 KRO826','C4 GDB1266','B1 TRU07.35.229','A2 21945.195.1','E7 AC689281D','C4 LP429','A3 VAC V10-8345-1','A3 ROA 213440','B7 0631.12/REM','C6 100554','A8 230 237','A3 VAC V10-8137','A2 FE FSL775','A9 GDB1266','B1 SKV26SKV424','A8 230 088','A9 RH 2134.40','A1 13.0460-2822.2','C9 2066921','C9 GDB826','A8 201 845','C9 0252066919','A1 WBP291','A3 ROA 263112','A3 TEX 2066921','B1 ZIM20778.196.1','C4 LP1410','A3 CIF 822-148-0','A2 20168 196 14','A2 RH 2134.20','C9 20168-19,6','C4 0986494021','C4 FSL1289','A2 RH 2134.40','A9 13.04602934.2','A1 13.0460-2934.2','A1 0986466700','A3 ROA 263110','B1 CIF822-148-0','A3 ROA 213420','A2 ABS37010','A5 36122','B1 VAI10-8345-1','A9 FE FDB1289','A2 RH 2631.12','A3 BOS 0986466700','C9 13.0460-2934.2','A1 0986494021','A1 P85042','A2 13.04602934.2','A9 20669 196 14','C9 VAL598484','C9 VAL598017','A8 215 813','A2 LP429','A3 DLP LP429','C9 0986494021','C9 0252194519','A2 LP778','C9 21945 10 701 00','C9 PA-0082AF','A1 LP778','A1 FSL775','B1 KAMJQ1012578','B1 BREP85042','B7 B110840/DKM','B7 20778.196.1','A1 WBP108','B7 0631.10/REM','B7 0134.40/REM','A9 GDB826','C9 13.0460-2822.2','B7 0134.20/REM','A8 225 620','B1 ATE13.0460-2822','A5 346078','A9 21945 196 14','C4 2066921TX','A9 0986494021','C4 1170082','C9 0986466700','A3 TEX 2016804','B1 BLPADV184269','A3 BOS 0986494021','B1 VAL301003','B1 VAI10-8135','B1 BOS0986494021','C4 21945.195.1','A9 BP85042','A5 135619','B1 VAI10-8137','B1 VAL302437','A5 15238','B7 0134.00/REM','A2 GDB1266','C4 05P216','C9 0252194519/PD','A5 118724','A1 598017','E1 30 91 6336','A1 571357D JRD','A3 VAC V10-8345','A9 20168 196 14','B1 ABS36789','B1 CIF822-215-0','C4 2016804TX','A1 LP1410','A2 0986466700','A2 BP85042','B7 1163604910/JP','A5 170205','C9 19-0501','A1 FSL1289','A2 GDB826','C9 20778-19,6','A3 VAC V10-8135','B1 TOM1312','C9 PF0145','A3 ROA 213400','A1 GDB826','A1 598484','C4 KRO1266','A1 571955J JRD','C9 20669-19,6','A8 201 827','B1 ATE13.0460-2934','A1 GDB854','A9 ABS37010','A3 TEX 2194503','B1 KAMJQ1011550','C9 2016804','A9 13.04602822.2','A1 2194503 TEX','E7 P7313.12/W','B1 BOS0986466700','A1 GDB1266','A1 FDB775','A1 FDB954','A1 P85092','A2 BP85092','A2 FE FDB775','A9 BP85092','A9 FE FDB775','B1 BREP85092','C4 FDB775','C4 FDB954')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #