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 ('A3 TEX 2303401','C9 VAL598801','C9 19-0653','B1 VAI25-0001-1','A9 FE FDB1654','C9 2303401','C9 VAL301801','A9 23034 186 05','A2 23034 186 05','A3 VAC V10-8233-1','B1 ATE13.0460-7123','B7 SP 259','B1 TOM1213','A1 WBP387','E7 AC691281D','C4 23418.190.1','C9 2341801','B7 23418.190.1','A2 FE FVR1484','C9 GDB1459','A1 GDB1538','A1 LP1801','C9 PA-0314AF','B1 VAI10-8184-1','B1 TOM1358','A2 GDB1459','C9 PF0539','A2 13.04607123.2','A1 FDB1654','A1 13.0460-7123.2','A2 LP784','E7 AC0581238D','A9 13.04607154.2','B7 0721.02/REM','B1 ZIM23418.190.1','A1 573022JC JRD','D2 EO 05P975','C4 LP1529','C4 GDB1538','C9 0986494415','A9 23418 196 05','B7 05P975/SUZ','C9 13.0460-7156.2','C9 0252184919/W','A8 219 882','A3 BOS 0986424780','A3 FER FDB1654','C9 19-1820','C4 LP784','A5 130377','C9 0986424780','A2 LP1801','A9 13.04607123.2','A3 DLP LP1801','A1 FSL1484','A2 13.04607156.2','A3 ROA 272102','A2 GDB1538','B7 B110864/DKM','A1 P85062','A1 0986424780','B1 BLPADV184245','C4 05P1238','B1 VAI10-8233','A3 FER FVR1484','C9 0252184919/PD','A2 13.04607154.2','B1 VAL302030','B1 LUCGDB1459','A2 RH 2721.02','C9 FDB1654','A3 CIF 822-550-0','C9 QP7319','A2 LP2021','A8 206 681','B1 VAL301801','A2 05P975','A2 0986494415','A1 GDB1459','A8 236 278','C4 05P982','A1 LP2021','A5 174963','A9 BP85062','C4 607123','B1 LUCGDB1538','A3 VAC V10-8184-1','C9 21849 00 701 10','A3 VAC V25-0001-1','C9 0252103419/W','A9 0986424780','B7 1163603610/JP','B1 ZIM23034.190.1','A9 FE FVR1484','C9 23034 00 703 10','A1 0986494415','C4 607156','A2 23418 196 05','B1 CIF822-279-1','C9 0252341819/W','C9 23418-19,6','A1 13.0460-7156.2','B1 KAMJQ101165','A5 77912','B1 ZIM21849.200.1','A1 WBP319','A8 224 501','A2 LP1529','B1 CIF822-550-0','A2 0986424780','C4 KRO1538','C9 QP1193','C9 PF0262','A8 217 864','B7 21849.200.1','C4 1170104','A3 VAC V10-8233','B7 B110798/DKM','C9 0252341819/PD','B1 VAI25-0001','B1 KAMJQ1012992','A8 230 207','A9 0986494415','A2 05P982','E3 21849.200.1','A3 DLP LP784','B1 ABS37453','A5 131466','B1 VAI10-8233-1','C9 19-1124','C9 23034-18,6','A1 573206J JRD','B1 CIF822-550-2','C4 21849.200.1','C4 607154','A1 WBP104','A2 FE FDB1654','A8 217 861','B7 1163604410/JP','C9 VAL598858','A9 GDB1459','A3 VAC V10-8184','C9 500038646','A3 DLP LP1529','A3 TEX 2341801','C4 0986424780','D1 BP ADV184245','A1 598489','B7 B110903/DKM','C4 LP2021','C9 23418 00 703 10','A1 FSL1654','A3 DLP LP2021','B7 05P982/SUZ','A3 BOS 0986494415','A3 VAC V25-0001','C4 FSL1654','A1 13.0460-7154.2','B1 ATE13.0460-7156','A8 217 794','A1 FVR1484','B1 BREP85062','A9 13.04607156.2','A1 LP1529','A1 LP784','A2 05P1525','C4 05P975','C9 PF0540','B1 ABS37141','B1 CIF822-550-1','C9 QP7319C','B1 BOS0986494415','B1 ATE13.0460-7154','C9 13.0460-7123.2','C4 LP1801','A2 05P1238','C9 GDB1538','C4 FDB1654','A2 BP85062','C4 2341801TX','B1 BOS0986424780','C9 13.0460-7154.2','C9 VAL598489','E1 30 91 6458','B1 VAI10-8184','C9 PF0261','A9 GDB1538','B7 23034.190.1','A1 FDB1055','A1 GDB1440','A2 GDB1440','A8 230 161','A9 FE FDB1055','A9 GDB1440','B1 LUCGDB1440','C4 GDB1440','C9 GDB1440')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #